noaa_stations_map (view)
3 rows where refStationId = 9416841
This data as json, CSV (advanced)
rowid | stationId | latitude | longitude | refStationId | stationType | parentGeoGroupId | seq | geoGroupId | geoGroupName | level | geoGroupType | abbrev | good |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190 | TWC0771 | 38.95 | -123.73333333333005 | 9416841 | S | 1450 | 11 | Point Arena | 2 | 0 | |||
192 | TWC0777 | 39.3 | -123.8 | 9416841 | S | 1450 | 13 | Mendocino, Mendocino Bay | 2 | 0 | |||
193 | 9417624 | 39.6333 | -123.783 | 9416841 | S | 1450 | 15 | Westport | 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;