Re: I can get data from MySQL, but Ferret doesn't plot for me....

The SQL query is

SELECT lsm.gtime,lsm.la,lsm.lo,tt
FROM lsm
WHERE (tt != -99.9) AND (lsm.lo>=106.0 AND lsm.lo<=110.0) AND (lsm.la>=0.0 AND lsm.la<=13.0) AND (lsm.gtime>='2004-09-28' AND lsm.gtime<='2004-09-28')

I can get data by issuing this SQL query to MySQL.

The intermediate NetCDF file is attached.

I can dump correct data by "ncdump" program .

I think the problem occurs in the Ferret visualization phase.

Following message is appeared when Ferret opens the intermediate NetCDF file.

[vmdctest@vdcsvra output]$ ferret
        NOAA/PMEL TMAP
        FERRET v5.70
        Linux(g77) 2.4.20 - 06/28/04
         5-Oct-04 09:21

yes? use 4e880c75dddd67c72c54680ebf19f2de.nc
*** NOTE: Coordinates out of order or missing on axis trdim at subscript 2
*** NOTE: A dummy axis of subscripts will be used
yes?

I discovered that the "Illegal Limits" message always appears when I choose a single time range.

Such as 28-Sep-2004 to 28-Sep-2004 or 27-Sep-2004 23:00:00 to 27-Sep-2004 23:00:00.

Thanks in advance.

Joe, I'm sorry that the LAS server is not available to the outside world now.

Our machine lives in Intranet for the security reason, but the Internet users might access it through sister server in the future.

Thanks!!

cch,

It looks like there is some mismatch between your XML configuration of the ranges of data stored in your database and the actual ranges encountered. Your configuration file should have a section of <database_access ...> properties as described here

http://ferret.pmel.noaa.gov/cgi-bin/LASdoc?file=23

I would suspect something amiss in the description of the time variable. The actual SQL query used to extract data from your database can be found in las/server/log/mysql_request.txt. You might try logging on to MySQL (or whatever server you are using) and issuing this request by hand to see what you get.

The las/server/log/debug file should also tell you whether your request for a plot failed at the SQL data access phase or at the Ferret visualization phase. If the SQL data access succeeded and you generated an intermediate NetCDF file you should be able to find the name of the intermediate NetCDF file in the debug file. Try opening this dataset in Ferret to see if the axes make sense.

If your LAS is available to the outside world, I'll have a look at it from here.

-- Jon

cch wrote:
The LAS can access RDB data ok, but when I use following condition:

- select view = lon-lat map

- select output = profile location plot

- lon = 106E - 110E

- lat = 0 - 13N

- select time range = 28-Sep-2004 - 28-Sep-2004

Following message occurred:
Illegal Limits
Sorry ...
    There are no data available in the range -6.3264E+10: to :
    The data begin at 0.5:2.5 and continue to :
Please try again with a time that lies within this range.
But if I choose select output = text, it will return text data for me:
Output by Live Access Server
Mon Oct  4 17:29:35 2004

  Dataset title: asia_prof_ctd.cdp
  missing value: -99.9
Longitude range: 106.00E to 110.00E
 Latitude range: 0.00N to 13.00N
    Depth range:  to 
     Time range: 28-Sep-2004 to 28-Sep-2004
    Time origin: 28-Sep-2004

prof_ID,      lon,     lat,   depth, hours since,Temperature (tt)
      1, 108.0800, 12.6800,       0,      0.0000,            22
      2, 109.2000, 12.2500,       0,      0.0000,          26.4
      3, 108.1000, 10.9300,       0,      0.0000,            26
      4, 106.6700, 10.8200,       0,      0.0000,          26.3
      5, 106.5800,  8.7000,       0,      0.0000,          26.2
      6, 106.2500,  3.2000,       0,      0.0000,          25.7
      7, 108.3800,  3.9500,       0,      0.0000,         -99.9
      8, 109.6700,  1.0800,       0,      0.0000,         -99.9
        
Another question is, when I use following time-range condition:
 
- select view = lon-lat map
- select output = profile location plot
- lon = 106E - 110E
- lat = 0 - 13N
- select time range = 27-Sep-2004 23:00:00 - 28-Sep-2004
 
The output gif file is attached, why can't I see anything on it?? 
 
Thanks very much... 
 
 
 

<datasets> <synop name="synop" url="asia_prof_ctd.cdp" lonString="longitude" latString="latitude"> <properties> <ui>  <default>file:ui.xml#insituProfile</default> </ui> <database_access name="MySQL"> <db_type>mysql</db_type> <db_name>amdp</db_name> <db_title>synop</db_title> <db_host>172.16.20.35</db_host> <db_login>guest</db_login> <db_passwd></db_passwd> <db_table>lsm</db_table> <longitude>lsm.lo</longitude> <lon_domain>-180:180</lon_domain> <latitude>lsm.la</latitude> <depth></depth> <depth_units></depth_units> <time>lsm.gtime</time> <time_sample>1999-01-01</time_sample> <profID></profID> <metadata>x,y,t</metadata> <executable>/usr/bin/asciival</executable> <missing>-99.9</missing> <timeout>80</timeout> </database_access> </properties> <variables> <tt name="Temperature (tt)" units="C"> <link match="/lasdata/grids/synop_XYZT_grid"/> </tt> <tdd name="Dew-point depression (tdd)" units="C"> <link match="/lasdata/grids/synop_XYZT_grid"/> </tdd> <dd name="Wind direction (dd)" units="degree"> <link match="/lasdata/grids/synop_XYZT_grid"/> </dd> <ff name="Wind speed (ff)" units="m/s"> <link match="/lasdata/grids/synop_XYZT_grid"/> </ff> <pp2 name="Pressure at mean sea level (pmsl)" units="mb"> <link match="/lasdata/grids/synop_XYZT_grid"/> </pp2> </variables> </synop> </datasets> <grids> <synop_XYZT_grid> <link match="/lasdata/axes/synop_X"/> <link match="/lasdata/axes/synop_Y"/>  <link match="/lasdata/axes/synop_T"/> </synop_XYZT_grid> </grids> <axes> <synop_X units="degree_east" type="x"> <arange start="-179" step="1" size="360"/> </synop_X> <synop_Y units="degree_north" type="y"> <arange start="-89" step="1" size="180"/> </synop_Y>  <synop_T units="hour" type="t"> <v>2004-09-18 00:00:00</v> <v>2004-09-18 01:00:00</v> <v>2004-09-18 02:00:00</v> <v>2004-09-18 03:00:00</v> <v>2004-09-18 04:00:00</v> <v>2004-09-18 05:00:00</v> <v>2004-09-18 06:00:00</v> <v>2004-09-18 07:00:00</v> <v>2004-09-18 08:00:00</v> <v>2004-09-18 09:00:00</v> <v>2004-09-18 10:00:00</v> <v>2004-09-18 11:00:00</v> <v>2004-09-18 12:00:00</v> <v>2004-09-18 13:00:00</v> <v>2004-09-18 14:00:00</v> <v>2004-09-18 15:00:00</v> <v>2004-09-18 16:00:00</v> <v>2004-09-18 17:00:00</v> <v>2004-09-18 18:00:00</v> <v>2004-09-18 19:00:00</v> <v>2004-09-18 20:00:00</v> <v>2004-09-18 21:00:00</v> <v>2004-09-18 22:00:00</v> <v>2004-09-18 23:00:00</v> <v>2004-09-19 00:00:00</v> <v>2004-09-19 01:00:00</v> <v>2004-09-19 02:00:00</v> <v>2004-09-19 03:00:00</v> <v>2004-09-19 04:00:00</v> <v>2004-09-19 05:00:00</v> <v>2004-09-19 06:00:00</v> <v>2004-09-19 07:00:00</v> <v>2004-09-19 08:00:00</v> <v>2004-09-19 09:00:00</v> <v>2004-09-19 10:00:00</v> <v>2004-09-19 11:00:00</v> <v>2004-09-19 12:00:00</v> <v>2004-09-19 13:00:00</v> <v>2004-09-19 14:00:00</v> <v>2004-09-19 15:00:00</v> <v>2004-09-19 16:00:00</v> <v>2004-09-19 17:00:00</v> <v>2004-09-19 18:00:00</v> <v>2004-09-19 19:00:00</v> <v>2004-09-19 20:00:00</v> <v>2004-09-19 21:00:00</v> <v>2004-09-19 22:00:00</v> <v>2004-09-19 23:00:00</v> <v>2004-09-20 00:00:00</v> <v>2004-09-20 01:00:00</v> <v>2004-09-20 02:00:00</v> <v>2004-09-20 03:00:00</v> <v>2004-09-20 04:00:00</v> <v>2004-09-20 05:00:00</v> <v>2004-09-20 06:00:00</v> <v>2004-09-20 07:00:00</v> <v>2004-09-20 08:00:00</v> <v>2004-09-20 09:00:00</v> <v>2004-09-20 10:00:00</v> <v>2004-09-20 11:00:00</v> <v>2004-09-20 12:00:00</v> <v>2004-09-20 13:00:00</v> <v>2004-09-20 14:00:00</v> <v>2004-09-20 15:00:00</v> <v>2004-09-20 16:00:00</v> <v>2004-09-20 17:00:00</v> <v>2004-09-20 18:00:00</v> <v>2004-09-20 19:00:00</v> <v>2004-09-20 20:00:00</v> <v>2004-09-20 21:00:00</v> <v>2004-09-20 22:00:00</v> <v>2004-09-20 23:00:00</v> <v>2004-09-21 00:00:00</v> <v>2004-09-21 01:00:00</v> <v>2004-09-21 02:00:00</v> <v>2004-09-21 03:00:00</v> <v>2004-09-21 04:00:00</v> <v>2004-09-21 05:00:00</v> <v>2004-09-21 06:00:00</v> <v>2004-09-21 07:00:00</v> <v>2004-09-21 08:00:00</v> <v>2004-09-21 09:00:00</v> <v>2004-09-21 10:00:00</v> <v>2004-09-21 11:00:00</v> <v>2004-09-21 12:00:00</v> <v>2004-09-21 13:00:00</v> <v>2004-09-21 14:00:00</v> <v>2004-09-21 15:00:00</v> <v>2004-09-21 16:00:00</v> <v>2004-09-21 17:00:00</v> <v>2004-09-21 18:00:00</v> <v>2004-09-21 19:00:00</v> <v>2004-09-21 20:00:00</v> <v>2004-09-21 21:00:00</v> <v>2004-09-21 22:00:00</v> <v>2004-09-21 23:00:00</v> <v>2004-09-22 00:00:00</v> <v>2004-09-22 01:00:00</v> <v>2004-09-22 02:00:00</v> <v>2004-09-22 03:00:00</v> <v>2004-09-22 04:00:00</v> <v>2004-09-22 05:00:00</v> <v>2004-09-22 06:00:00</v> <v>2004-09-22 07:00:00</v> <v>2004-09-22 08:00:00</v> <v>2004-09-22 09:00:00</v> <v>2004-09-22 10:00:00</v> <v>2004-09-22 11:00:00</v> <v>2004-09-22 12:00:00</v> <v>2004-09-22 13:00:00</v> <v>2004-09-22 14:00:00</v> <v>2004-09-22 15:00:00</v> <v>2004-09-22 16:00:00</v> <v>2004-09-22 17:00:00</v> <v>2004-09-22 18:00:00</v> <v>2004-09-22 19:00:00</v> <v>2004-09-22 20:00:00</v> <v>2004-09-22 21:00:00</v> <v>2004-09-22 22:00:00</v> <v>2004-09-22 23:00:00</v> <v>2004-09-23 00:00:00</v> <v>2004-09-23 01:00:00</v> <v>2004-09-23 02:00:00</v> <v>2004-09-23 03:00:00</v> <v>2004-09-23 04:00:00</v> <v>2004-09-23 05:00:00</v> <v>2004-09-23 06:00:00</v> <v>2004-09-23 07:00:00</v> <v>2004-09-23 08:00:00</v> <v>2004-09-23 09:00:00</v> <v>2004-09-23 10:00:00</v> <v>2004-09-23 11:00:00</v> <v>2004-09-23 12:00:00</v> <v>2004-09-23 13:00:00</v> <v>2004-09-23 14:00:00</v> <v>2004-09-23 15:00:00</v> <v>2004-09-23 16:00:00</v> <v>2004-09-23 17:00:00</v> <v>2004-09-23 18:00:00</v> <v>2004-09-23 19:00:00</v> <v>2004-09-23 20:00:00</v> <v>2004-09-23 21:00:00</v> <v>2004-09-23 22:00:00</v> <v>2004-09-23 23:00:00</v> <v>2004-09-24 00:00:00</v> <v>2004-09-24 01:00:00</v> <v>2004-09-24 02:00:00</v> <v>2004-09-24 03:00:00</v> <v>2004-09-24 04:00:00</v> <v>2004-09-24 05:00:00</v> <v>2004-09-24 06:00:00</v> <v>2004-09-24 07:00:00</v> <v>2004-09-24 08:00:00</v> <v>2004-09-24 09:00:00</v> <v>2004-09-24 10:00:00</v> <v>2004-09-24 11:00:00</v> <v>2004-09-24 12:00:00</v> <v>2004-09-24 13:00:00</v> <v>2004-09-24 14:00:00</v> <v>2004-09-24 15:00:00</v> <v>2004-09-24 16:00:00</v> <v>2004-09-24 17:00:00</v> <v>2004-09-24 18:00:00</v> <v>2004-09-24 19:00:00</v> <v>2004-09-24 20:00:00</v> <v>2004-09-24 21:00:00</v> <v>2004-09-24 22:00:00</v> <v>2004-09-24 23:00:00</v> <v>2004-09-25 00:00:00</v> <v>2004-09-25 01:00:00</v> <v>2004-09-25 02:00:00</v> <v>2004-09-25 03:00:00</v> <v>2004-09-25 04:00:00</v> <v>2004-09-25 05:00:00</v> <v>2004-09-25 06:00:00</v> <v>2004-09-25 07:00:00</v> <v>2004-09-25 08:00:00</v> <v>2004-09-25 09:00:00</v> <v>2004-09-25 10:00:00</v> <v>2004-09-25 11:00:00</v> <v>2004-09-25 12:00:00</v> <v>2004-09-25 13:00:00</v> <v>2004-09-25 14:00:00</v> <v>2004-09-25 15:00:00</v> <v>2004-09-25 16:00:00</v> <v>2004-09-25 17:00:00</v> <v>2004-09-25 18:00:00</v> <v>2004-09-25 19:00:00</v> <v>2004-09-25 20:00:00</v> <v>2004-09-25 21:00:00</v> <v>2004-09-25 22:00:00</v> <v>2004-09-25 23:00:00</v> <v>2004-09-26 00:00:00</v> <v>2004-09-26 01:00:00</v> <v>2004-09-26 02:00:00</v> <v>2004-09-26 03:00:00</v> <v>2004-09-26 04:00:00</v> <v>2004-09-26 05:00:00</v> <v>2004-09-26 06:00:00</v> <v>2004-09-26 07:00:00</v> <v>2004-09-26 08:00:00</v> <v>2004-09-26 09:00:00</v> <v>2004-09-26 10:00:00</v> <v>2004-09-26 11:00:00</v> <v>2004-09-26 12:00:00</v> <v>2004-09-26 13:00:00</v> <v>2004-09-26 14:00:00</v> <v>2004-09-26 15:00:00</v> <v>2004-09-26 16:00:00</v> <v>2004-09-26 17:00:00</v> <v>2004-09-26 18:00:00</v> <v>2004-09-26 19:00:00</v> <v>2004-09-26 20:00:00</v> <v>2004-09-26 21:00:00</v> <v>2004-09-26 22:00:00</v> <v>2004-09-26 23:00:00</v> <v>2004-09-27 00:00:00</v> <v>2004-09-27 01:00:00</v> <v>2004-09-27 02:00:00</v> <v>2004-09-27 03:00:00</v> <v>2004-09-27 04:00:00</v> <v>2004-09-27 05:00:00</v> <v>2004-09-27 06:00:00</v> <v>2004-09-27 07:00:00</v> <v>2004-09-27 08:00:00</v> <v>2004-09-27 09:00:00</v> <v>2004-09-27 10:00:00</v> <v>2004-09-27 11:00:00</v> <v>2004-09-27 12:00:00</v> <v>2004-09-27 13:00:00</v> <v>2004-09-27 14:00:00</v> <v>2004-09-27 15:00:00</v> <v>2004-09-27 16:00:00</v> <v>2004-09-27 17:00:00</v> <v>2004-09-27 18:00:00</v> <v>2004-09-27 19:00:00</v> <v>2004-09-27 20:00:00</v> <v>2004-09-27 21:00:00</v> <v>2004-09-27 22:00:00</v> <v>2004-09-27 23:00:00</v> <v>2004-09-28 00:00:00</v> <v>2004-09-28 01:00:00</v> <v>2004-09-28 02:00:00</v> <v>2004-09-28 03:00:00</v> <v>2004-09-28 04:00:00</v> <v>2004-09-28 05:00:00</v> <v>2004-09-28 06:00:00</v> <v>2004-09-28 07:00:00</v> <v>2004-09-28 08:00:00</v> <v>2004-09-28 09:00:00</v> <v>2004-09-28 10:00:00</v> <v>2004-09-28 11:00:00</v> <v>2004-09-28 12:00:00</v> <v>2004-09-28 13:00:00</v> <v>2004-09-28 14:00:00</v> <v>2004-09-28 15:00:00</v> <v>2004-09-28 16:00:00</v> <v>2004-09-28 17:00:00</v> <v>2004-09-28 18:00:00</v> <v>2004-09-28 19:00:00</v> <v>2004-09-28 20:00:00</v> <v>2004-09-28 21:00:00</v> <v>2004-09-28 22:00:00</v> <v>2004-09-28 23:00:00</v> </synop_T> </axes>