[Thread Prev][Thread Next][Index]

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



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...
 
 
 




[Thread Prev][Thread Next][Index]

Dept of Commerce / NOAA / OAR / PMEL / TMAP
Contact Us | Privacy Policy | Disclaimer | Accessibility Statement