List all stations

hydrohydro
in Portal Issues

Hello everyone, I want to list all the available stations with variables and coordinates

In advanced search I paste
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
GROUP BY station.network_abbr, station.station_id
ORDER BY station.network_abbr, station.station_name

But results are limited to 100 rows and automatic download does not start. Where I am doing it wrong?

Sign In or Register to comment.