List all stations
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?