noaa_stations
208 rows
This data as json, CSV (advanced)
stationId ▼ | lat | lon | refStationId | stationType | parentGeoGroupId | seq | geoGroupId | geoGroupName | level | geoGroupType | abbrev | good |
---|---|---|---|---|---|---|---|---|---|---|---|---|
9414818 | 37.8633 | -122.42 | 9414290 | S | 1451 | 50 | Angel Island, East Garrison | 2 | 0 | |||
9414819 | 37.865 | -122.493 | 9414290 | S | 1451 | 48 | Sausalito, Corps of Engineers Dock | 2 | 0 | |||
9414835 | 37.8917 | -121.488 | 9415144 | S | 1455 | 15 | Borden Highway Bridge, Middle River | 2 | 0 | |||
9414836 | 37.8833 | -121.577 | 9415144 | S | 1455 | 14 | Borden Highway Bridge, Old River | 2 | 0 | |||
9414837 | 37.8917 | -122.443 | 9414290 | S | 1451 | 51 | Point Chauncey | 2 | 0 | |||
9414843 | 37.8983 | -122.32 | 9414290 | S | 1451 | 53 | Point Isabel | 2 | 0 | |||
9414849 | 37.91 | -122.358 | 9414290 | S | 1451 | 54 | Richmond Inner Harbor | 2 | 0 | |||
9414863 | 37.92829895019531 | -122.4000015258789 | R | 1451 | 55 | Chevron Oil Company Pier, Richmond | 2 | 1 | ||||
9414866 | 37.935 | -121.435 | 9415144 | S | 1455 | 13 | Holt, Whiskey Slough | 2 | 0 | |||
9414868 | 37.9383 | -121.56 | 9415144 | S | 1455 | 12 | Orwood, Old River | 2 | 0 | |||
9414873 | 37.945 | -122.475 | 9414290 | S | 1451 | 58 | Point San Quentin | 2 | 0 | |||
9414874 | 37.94329833984375 | -122.51300048828125 | R | 1451 | 57 | Corte Madera Creek | 2 | 0 | ||||
9414881 | 37.9583 | -122.425 | 9414290 | S | 1451 | 56 | Point Orient | 2 | 0 | |||
9414883 | 37.9583 | -121.29 | 9415144 | S | 1455 | 6 | Stockton | 2 | 0 | |||
9414906 | 37.8183 | -122.528 | 9414290 | S | 1451 | 0 | Point Bonita, Bonita Cove | 2 | 0 | |||
9414958 | 37.90800094604492 | -122.67849731445312 | R | 1450 | 0 | Bolinas Lagoon | 2 | 1 | ||||
9415009 | 37.9933 | -122.447 | 9414290 | S | 1452 | 0 | Point San Pedro | 2 | 0 | |||
9415020 | 37.9941667 | -122.9736111 | R | 1450 | 1 | Point Reyes | 2 | 1 | ||||
9415021 | 37.994998931884766 | -121.41999816894531 | R | 1455 | 5 | Blackslough Landing | 2 | 0 | ||||
9415052 | 38.015 | -122.503 | 9414290 | S | 1452 | 6 | Gallinas, Gallinas Creek | 2 | 0 | |||
9415053 | 38.0117 | -121.638 | 9415144 | S | 1455 | 10 | Dutch Slough | 2 | 0 | |||
9415056 | 38.015 | -122.363 | R | 1452 | 1 | Pinole Point | 2 | 1 | ||||
9415064 | 38.02 | -121.815 | R | 1455 | 0 | Antioch | 2 | 1 | ||||
9415074 | 38.0233 | -122.292 | 9414290 | S | 1452 | 2 | Hercules, Refugio Landing | 2 | 0 | |||
9415095 | 38.0333 | -121.583 | 9415144 | S | 1455 | 11 | Irish Landing, Sand Mound Slough | 2 | 0 | |||
9415096 | 38.0367 | -121.88 | 9415144 | S | 1454 | 11 | Pittsburg, New York Slough | 2 | 0 | |||
9415102 | 38.03463888888889 | -122.1251944444445 | R | 1453 | 8 | Martinez-Amorco Pier | 2 | 1 | ||||
9415105 | 38.04999923706055 | -121.49700164794922 | R | 1455 | 4 | Wards Island, Little Connection Slough | 2 | 0 | ||||
9415111 | 38.0433 | -122.13 | 9415144 | S | 1453 | 7 | Benicia | 2 | 0 | |||
9415112 | 38.0433 | -121.918 | R | 1454 | 10 | Mallard Island Ferry Wharf | 2 | 1 | ||||
9415117 | 38.045 | -121.42 | 9415144 | S | 1455 | 8 | Bishop Cut, Disappointment Slough | 2 | 0 | |||
9415142 | 38.0583 | -122.243 | 9414290 | S | 1453 | 5 | Selby | 2 | 0 | |||
9415143 | 38.0583 | -122.223 | R | 1453 | 6 | Crockett | 2 | 1 | ||||
9415144 | 38.056 | -122.0395 | R | 1454 | 4 | PORT CHICAGO, SUISUN BAY | 2 | 1 | ||||
9415145 | 38.055 | -121.657 | 9415144 | S | 1455 | 9 | False River | 2 | 0 | |||
9415149 | 38.0617 | -121.555 | 9415144 | S | 1455 | 3 | Prisoners Point | 2 | 0 | |||
9415165 | 38.1117 | -122.273 | 9414290 | S | 1453 | 1 | Vallejo, Mare Island Strait | 2 | 0 | |||
9415176 | 38.0733 | -121.848 | 9415144 | S | 1456 | 0 | Collinsville | 2 | 0 | |||
9415193 | 38.086700439453125 | -121.68499755859375 | R | 1455 | 1 | Threemile Slough entrance | 2 | 0 | ||||
9415205 | 38.0767 | -121.885 | 9415144 | S | 1454 | 8 | Montezuma Slough | 2 | 0 | |||
9415218 | 38.07 | -122.25 | R | 1453 | 0 | Mare Island | 2 | 1 | ||||
9415227 | 38.1 | -122.033 | 9415144 | S | 1454 | 9 | Point Buckler | 2 | 0 | |||
9415228 | 38.1133 | -122.868 | 9414290 | S | 1450 | 6 | Inverness, Tomales Bay | 2 | 0 | |||
9415229 | 38.097599029541016 | -121.56839752197266 | R | 1455 | 2 | Korths Harbor, San Joaquin River | 2 | 0 | ||||
9415236 | 38.1067 | -121.7 | 9415144 | S | 1456 | 1 | Threemile Slough | 2 | 0 | |||
9415252 | 38.11530555555556 | -122.5056666666667 | 9414290 | S | 1452 | 3 | Petaluma River entrance | 2 | 0 | |||
9415257 | 38.11 | -121.498 | 9415144 | S | 1677 | 1 | Terminous, South Fork | 3 | 0 | |||
9415265 | 38.1283 | -122.073 | R | 1454 | 0 | Suisun Slough entrance | 2 | 1 | ||||
9415266 | 38.1267 | -122.1 | 9415144 | S | 1454 | 1 | Pierce Harbor, Goodyear Slough | 2 | 0 | |||
9415287 | 38.125 | -121.578 | 9415144 | S | 1677 | 0 | Georgiana Slough entrance | 3 | 0 | |||
9415307 | 38.1367 | -121.907 | 9415144 | S | 1454 | 7 | Meins Landing, Montezuma Slough | 2 | 0 | |||
9415316 | 38.145 | -121.692 | R | 1456 | 2 | Rio Vista | 2 | 1 | ||||
9415320 | 38.1467 | -122.883 | 9414290 | S | 1450 | 5 | Reynolds, Tomales Bay | 2 | 0 | |||
9415338 | 38.1567 | -122.407 | R | 1452 | 8 | Sonoma Creek | 2 | 1 | ||||
9415339 | 38.1617 | -122.893 | 9414290 | S | 1450 | 4 | Marshall, Tomales Bay | 2 | 0 | |||
9415344 | 38.1617 | -122.55 | 9414290 | S | 1452 | 7 | Hog Island, San Antonio Creek | 2 | 0 | |||
9415379 | 38.18 | -122.045 | 9415144 | S | 1454 | 2 | Joice Island, Suisun Slough | 2 | 0 | |||
9415396 | 38.19 | -122.917 | 9414290 | S | 1450 | 3 | Blakes Landing, Tomales Bay | 2 | 0 | |||
9415402 | 38.1867 | -121.98 | 9415144 | S | 1454 | 5 | Montezuma Slough Bridge | 2 | 0 | |||
9415414 | 38.1833 | -121.655 | 9415144 | S | 1456 | 3 | Steamboat Slough, Snug Harbor Marina | 2 | 0 | |||
9415415 | 38.1917 | -122.312 | 9414290 | S | 1453 | 2 | Edgerley Island, Napa River | 2 | 0 | |||
9415446 | 38.21 | -122.307 | 9414290 | S | 1453 | 3 | Brazos Drawbridge, Napa River | 2 | 0 | |||
9415447 | 38.21 | -122.427 | 9414290 | S | 1452 | 9 | Wingo, Sonoma Creek | 2 | 0 | |||
9415469 | 38.2283 | -122.977 | 9414290 | S | 1450 | 2 | Tomales Bay entrance | 2 | 0 | |||
9415478 | 38.2267 | -121.49 | 9415144 | S | 1677 | 2 | New Hope Bridge | 3 | 0 | |||
9415498 | 38.2367 | -122.03 | 9415144 | S | 1454 | 3 | Suisun City, Suisun Slough | 2 | 0 | |||
9415565 | 38.2767 | -121.495 | 9415144 | S | 1456 | 4 | Snodgrass Slough | 2 | 0 | |||
9415584 | 38.2283 | -122.613 | 9414290 | S | 1452 | 5 | Upper drawbridge, Petaluma River | 2 | 0 | |||
9415623 | 38.2983 | -122.28 | 9414290 | S | 1453 | 4 | Napa, Napa River | 2 | 0 | |||
9415625 | 38.3083 | -123.055 | 9414290 | S | 1450 | 7 | Bodega Harbor entrance | 2 | 0 | |||
9415846 | 38.4167 | -121.523 | 9415144 | S | 1456 | 5 | Clarksburg | 2 | 0 | |||
9416024 | 38.5133 | -123.245 | 9414290 | S | 1450 | 8 | Fort Ross | 2 | 0 | |||
9416174 | 38.58 | -121.507 | 9415144 | S | 1456 | 6 | Sacramento | 2 | 0 | |||
9416409 | 38.70433333333333 | -123.4493888888889 | R | 1450 | 9 | Green Cove | 2 | 1 | ||||
9416841 | 38.91455555555556 | -123.7110833333333 | R | 1450 | 10 | ARENA COVE | 2 | 1 | ||||
9417426 | 39.42577777777778 | -123.8051111111111 | R | 1450 | 12 | NOYO HARBOR | 2 | 1 | ||||
9417624 | 39.6333 | -123.783 | 9416841 | S | 1450 | 15 | Westport | 2 | 0 | |||
9418024 | 40.025001525878906 | -124.05799865722656 | R | 1450 | 16 | Shelter Cove | 2 | 1 | ||||
9418637 | 40.63719940185547 | -124.2822036743164 | R | 1450 | 17 | Cockrobin Island Bridge, Eel River | 2 | 1 | ||||
9418686 | 40.6867 | -124.222 | 9418767 | S | 1678 | 2 | Hookton Slough | 3 | 0 | |||
9418723 | 40.7233 | -124.222 | R | 1678 | 1 | Fields Landing | 3 | 1 | ||||
9418757 | 40.7567 | -124.193 | 9418767 | S | 1678 | 3 | Elk River Railroad Bridge | 3 | 0 | |||
9418767 | 40.76690555555555 | -124.2173444444445 | R | 1678 | 0 | HUMBOLDT BAY (North Spit) | 3 | 1 | ||||
9418778 | 40.7783 | -124.197 | 9418767 | S | 1678 | 4 | Bucksport | 3 | 0 | |||
9418801 | 40.8067 | -124.167 | 9418767 | S | 1678 | 5 | Eureka | 3 | 0 | |||
9418802 | 40.8067 | -124.142 | 9418767 | S | 1678 | 6 | Eureka Slough Bridge | 3 | 0 | |||
9418817 | 40.8267 | -124.18 | R | 1678 | 7 | Samoa | 3 | 1 | ||||
9418851 | 40.85 | -124.117 | 9418767 | S | 1678 | 8 | Arcata Wharf | 3 | 0 | |||
9418865 | 40.865 | -124.148 | 9418767 | S | 1678 | 9 | Mad River Slough, Arcata Bay | 3 | 0 | |||
9419059 | 41.0567 | -124.147 | 9419750 | S | 1450 | 19 | Trinidad Harbor | 2 | 0 | |||
9419750 | 41.74561111111111 | -124.1843888888889 | R | 1450 | 20 | CRESCENT CITY | 2 | 1 | ||||
9419945 | 41.94525 | -124.2009166666667 | R | 1450 | 21 | Pyramid Point, Smith River | 2 | 1 | ||||
TWC0399 | 24.78333333333299 | -112.11666666666996 | 9410170 | S | 1446 | 0 | San Carlos | 2 | 0 | |||
TWC0401 | 28.883333333332992 | -116.3 | 9410170 | S | 1446 | 1 | Isla Guadalupe | 2 | 0 | |||
TWC0403 | 31.85 | -116.63333333333004 | 9410170 | S | 1446 | 2 | Ensenada, Todos Santos Bay | 2 | 0 | |||
TWC0405 | 32.666666666667005 | -117.23333333333005 | 9410170 | S | 1751 | 1 | Point Loma | 2 | 0 | |||
TWC0413 | 32.76666666666701 | -117.23333333333005 | 9410170 | S | 1751 | 6 | Quivira Basin, Mission Bay | 2 | 0 | |||
TWC0419 | 33.416666666667005 | -117.61666666666996 | 9410170 | S | 1751 | 9 | San Clemente | 2 | 0 | |||
TWC0427 | 33.71666666666701 | -118.05 | 9410660 | S | 1447 | 3 | Los Patos (highway bridge) | 2 | 0 | |||
TWC0439 | 33.75 | -118.26666666666995 | 9410660 | S | 1447 | 8 | Los Angeles Harbor, Mormon Island | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [noaa_stations] ( [stationId] TEXT PRIMARY KEY, [lat] FLOAT, [lon] FLOAT, [refStationId] TEXT, [stationType] TEXT, [parentGeoGroupId] TEXT, [seq] TEXT, [geoGroupId] TEXT, [geoGroupName] TEXT, [level] TEXT, [geoGroupType] TEXT, [abbrev] TEXT , [good] INTEGER);