noaa_stations_map (view)
1 row where refStationId = 9419750
This data as json, CSV (advanced)
rowid | stationId | latitude | longitude | refStationId | stationType | parentGeoGroupId | seq | geoGroupId | geoGroupName | level | geoGroupType | abbrev | good |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
206 | 9419059 | 41.0567 | -124.147 | 9419750 | S | 1450 | 19 | Trinidad Harbor | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW noaa_stations_map AS select rowid, stationId, lat as latitude, lon as longitude, refStationId, stationType, parentGeoGroupId, seq, geoGroupId, geoGroupName, level, geoGroupType, abbrev, good from noaa_stations;