LOCATION OF USCRN STATIONS WHICH PROVIDE SOIL-MOISTURE DATA

Hi Dear,
How can I get the location information of USCRN stations which provides soil-moisture data?

Comments

  • Dear janardanroy46,

    attached you'll find a txt file with the locations.
    best regards,
    ISMN-Team

    PS: When you log in to our website under >data access>advanced download you can produce a list using the following query:

    SELECT station.network_abbr, station.station_id, station.station_Name,  ST_Y(station.station_location) as lat, ST_X(station.station_location) as lon
    FROM station JOIN timeseries ON station.station_id = timeseries.station_id
    Where timeseries.variable_id = 8 and station.network_abbr ='USCRN'
    GROUP BY station.network_abbr, station.station_id
    ORDER BY station.network_abbr, station.station_name
    

    PPS: When you download data at our website, the location is also included in the header/first row of the files containing timeseries data.

Sign In or Register to comment.