noaa_stations_map (view)
18 rows where refStationId = 9410660
This data as json, CSV (advanced)
Suggested facets: parentGeoGroupId, seq
rowid | stationId | latitude | longitude | refStationId | stationType | parentGeoGroupId | seq | geoGroupId | geoGroupName | level | geoGroupType | abbrev | good |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15 | 9410583 | 33.6 | -117.9 | 9410660 | S | 1447 | 1 | Balboa Pier, Newport Beach | 2 | 0 | |||
16 | 9410599 | 33.63 | -117.958 | 9410660 | S | 1447 | 2 | Santa Ana River entrance (inside) | 2 | 0 | |||
17 | TWC0427 | 33.71666666666701 | -118.05 | 9410660 | S | 1447 | 3 | Los Patos (highway bridge) | 2 | 0 | |||
19 | 9410686 | 33.7717 | -118.21 | 9410660 | S | 1447 | 5 | Long Beach, Inner Harbor | 2 | 0 | |||
20 | 9410650 | 33.7067 | -118.273 | 9410660 | S | 1447 | 6 | Cabrillo Beach | 2 | 0 | |||
22 | TWC0439 | 33.75 | -118.26666666666995 | 9410660 | S | 1447 | 8 | Los Angeles Harbor, Mormon Island | 2 | 0 | |||
23 | 9410738 | 33.8467 | -118.398 | 9410660 | S | 1447 | 9 | King Harbor, Santa Monica Bay | 2 | 0 | |||
24 | 9410777 | 33.9083 | -118.433 | 9410660 | S | 1447 | 10 | El Segundo, Santa Monica Bay | 2 | 0 | |||
26 | TWC0445 | 34.1 | -119.1 | 9410660 | S | 1448 | 0 | Mugu Lagoon (ocean pier) | 2 | 0 | |||
27 | 9411065 | 34.1483 | -119.203 | 9410660 | S | 1448 | 1 | Port Hueneme | 2 | 0 | |||
28 | 9411189 | 34.2667 | -119.283 | 9410660 | S | 1448 | 2 | Ventura | 2 | 0 | |||
29 | 9411270 | 34.3483 | -119.443 | 9410660 | S | 1448 | 3 | Rincon Island, Mussel Shoals | 2 | 0 | |||
34 | 9410092 | 33.4317 | -118.503 | 9410660 | S | 1449 | 1 | Catalina Harbor, Santa Catalina Island | 2 | 0 | |||
36 | TWC0463 | 33.48333333333299 | -119.03333333333005 | 9410660 | S | 1449 | 3 | Santa Barbara Island | 2 | 0 | |||
37 | 9410068 | 33.2667 | -119.497 | 9410660 | S | 1449 | 4 | San Nicolas Island | 2 | 0 | |||
38 | 9410971 | 34.02 | -119.683 | 9410660 | S | 1449 | 5 | Prisoners Harbor, Santa Cruz Island | 2 | 0 | |||
39 | 9410962 | 34.0083 | -120.047 | 9410660 | S | 1449 | 6 | Bechers Bay, Santa Rosa Island | 2 | 0 | |||
40 | 9410988 | 34.0567 | -120.355 | 9410660 | S | 1449 | 7 | Cuyler Harbor, San Miguel Island | 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;