noaa_stations_map (view)
7 rows where refStationId = 9413450
This data as json, CSV (advanced)
Suggested facets: latitude, longitude, parentGeoGroupId, seq, level
rowid | stationId | latitude | longitude | refStationId | stationType | parentGeoGroupId | seq | geoGroupId | geoGroupName | level | geoGroupType | abbrev | good |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45 | 9413375 | 36.52 | -121.94 | 9413450 | S | 1457 | 4 | Carmel Cove, Carmel Bay | 2 | 0 | |||
47 | 9413617 | 36.8017 | -121.787 | 9413450 | S | 1676 | 1 | General Fish Company Pier | 3 | 0 | |||
48 | 9413616 | 36.8017 | -121.79 | 9413450 | S | 1676 | 2 | Moss Landing, Ocean Pier | 3 | 0 | |||
49 | 9413626 | 36.8133 | -121.787 | 9413450 | S | 1676 | 3 | Elkhorn Yacht Club | 3 | 0 | |||
50 | 9413623 | 36.81 | -121.785 | 9413450 | S | 1676 | 4 | Elkhorn Slough, Highway 1 Bridge | 3 | 0 | |||
51 | 9413624 | 36.8133 | -121.758 | 9413450 | S | 1676 | 5 | Pacific Mariculture Dock | 3 | 0 | |||
56 | 9413745 | 36.9583 | -122.017 | 9413450 | S | 1676 | 10 | Santa Cruz, Monterey 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;