|
Good afternoon. I am still having trouble getting insitu data into LAS. I'm currently attempting to do this from mysql. I've followed the insitu_demo files carefully, but can't get real data working. I've changed all of my data types to floats and changed my date to one which can be read by the TMAP date module (YYYYMMDDHHMMSS). A working version of the insitu demo is running from the same server, and LAS is able to access the dates from my database and interpret them correctly (I have the proper date range on the constraints page.) Yet each time I attempt to get output, I get the error "The query submitted to the back end database returned no valid data for this variable." Here is what my table looks like (levels are press2): mysql> describe test6; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | id | float | YES | | NULL | | | geo_hgt_m | float | YES | | NULL | | | temp_10C | float | YES | | NULL | | | Td_diff_10C | float | YES | | NULL | | | wind_dir | float | YES | | NULL | | | wind_spd_10ms | float | YES | | NULL | | | new_date | bigint(17) | YES | | NULL | | | press2 | float | YES | | NULL | | | lat | float | YES | | NULL | | | lon | float | YES | | NULL | | +---------------+------------+------+-----+---------+-------+ 10 rows in set (0.00 sec) I've successfully queried the database from the "test" query in the documentation: mysql> SELECT lon,lat,press2,new_date,temp_10C -> FROM test6 -> WHERE lon>=-195.363327 AND lon<=-60.1234 -> AND lat>=23.783333 AND lat<=83.183333 -> AND new_date>=20050401000000 AND new_date<=20050420000000 -> limit 100; +--------+-------+--------+----------------+----------+ | lon | lat | press2 | new_date | temp_10C | +--------+-------+--------+----------------+----------+ | -80.23 | 40.53 | 965 | 20050404000000 | 80 | | -80.23 | 40.53 | 925 | 20050404000000 | 54 | | -80.23 | 40.53 | 850 | 20050404000000 | -11 | | -80.23 | 40.53 | 700 | 20050404000000 | -85 | | -80.23 | 40.53 | 500 | 20050404000000 | -219 | | -80.23 | 40.53 | 400 | 20050404000000 | -323 | Does anyone have suggestions of what I could try next? Thanks! Andrea -- Andrea Fey NOMADS Project Intern Andrea.Fey@noaa.gov 828-271-4474 |