noaa_stations_map (view)
7 rows where refStationId = 9418767
This data as json, CSV (advanced)
Suggested facets: latitude
rowid | stationId | latitude | longitude | refStationId | stationType | parentGeoGroupId | seq | geoGroupId | geoGroupName | level | geoGroupType | abbrev | good |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
198 | 9418686 | 40.6867 | -124.222 | 9418767 | S | 1678 | 2 | Hookton Slough | 3 | 0 | |||
199 | 9418757 | 40.7567 | -124.193 | 9418767 | S | 1678 | 3 | Elk River Railroad Bridge | 3 | 0 | |||
200 | 9418778 | 40.7783 | -124.197 | 9418767 | S | 1678 | 4 | Bucksport | 3 | 0 | |||
201 | 9418801 | 40.8067 | -124.167 | 9418767 | S | 1678 | 5 | Eureka | 3 | 0 | |||
202 | 9418802 | 40.8067 | -124.142 | 9418767 | S | 1678 | 6 | Eureka Slough Bridge | 3 | 0 | |||
204 | 9418851 | 40.85 | -124.117 | 9418767 | S | 1678 | 8 | Arcata Wharf | 3 | 0 | |||
205 | 9418865 | 40.865 | -124.148 | 9418767 | S | 1678 | 9 | Mad River Slough, Arcata Bay | 3 | 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;