units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where ACCESS_TYP = 1, COUNTY = 11, LAYER = 5 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 8
ACCESS_TYP 1
- Open Access · 13 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
426 | 426 | 425 | {"type": "MultiPolygon", "coordinates": [[[[-122.54467, 38.63634], [-122.54012, 38.63646], [-122.54006, 38.65103], [-122.53546, 38.65099], [-122.53551, 38.64373], [-122.52645, 38.64367], [-122.52656, 38.64004], [-122.52204, 38.64003], [-122.52219, 38.63641], [-122.5214, 38.6255], [-122.52598, 38.62553], [-122.52577, 38.62209], [-122.52841, 38.62192], [-122.53977, 38.62201], [-122.54003, 38.62199], [-122.54431, 38.62189], [-122.5444, 38.62378], [-122.54448, 38.62912], [-122.54467, 38.63634]], [[-122.54011, 38.63644], [-122.54012, 38.63643], [-122.53988, 38.62923], [-122.52622, 38.62917], [-122.52645, 38.63279], [-122.53549, 38.63283], [-122.53564, 38.63643], [-122.54008, 38.63642], [-122.54011, 38.63644]]], [[[-122.56278, 38.61434], [-122.55805, 38.61443], [-122.5534, 38.6145], [-122.55346, 38.61809], [-122.54883, 38.61821], [-122.54419, 38.6183], [-122.54405, 38.61108], [-122.54868, 38.611], [-122.54863, 38.60741], [-122.55798, 38.6073], [-122.56112, 38.60719], [-122.5627, 38.60725], [-122.56278, 38.61434]]]]} | Open Access 1 | 1318 | Swartz Canyon | 1994 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Napa 11 | 1307.545 | Swartz Canyon | None 43 | |||
434 | 434 | 433 | {"type": "Polygon", "coordinates": [[[-122.3521, 38.44442], [-122.34572, 38.4492], [-122.34565, 38.44615], [-122.3358, 38.44548], [-122.3314, 38.44557], [-122.33138, 38.4492], [-122.3184, 38.44966], [-122.29917, 38.448], [-122.29908, 38.44438], [-122.31821, 38.44584], [-122.31804, 38.44201], [-122.33143, 38.44194], [-122.33145, 38.43832], [-122.32239, 38.43823], [-122.32228, 38.43447], [-122.33607, 38.43482], [-122.34065, 38.43479], [-122.34065, 38.43521], [-122.34066, 38.43522], [-122.3429, 38.43515], [-122.34817, 38.43528], [-122.34848, 38.43602], [-122.34809, 38.44201], [-122.3521, 38.44442]]]} | Open Access 1 | 837 | Silverado Trail Rector Dam Watershed | 1818 | 206 | California Department of Veterans Affairs 170 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 206 | California Department of Veterans Affairs 166 | State 5 | State Agency 5 | Napa 11 | 959.679 | Silverado Trail Rector Dam Watershed | None 44 | |||
820 | 820 | 819 | {"type": "Polygon", "coordinates": [[[-122.46024, 38.4015], [-122.45904, 38.40373], [-122.45593, 38.40443], [-122.45662, 38.40573], [-122.45384, 38.40685], [-122.45383, 38.40697], [-122.45093, 38.40569], [-122.45012, 38.40836], [-122.44677, 38.40831], [-122.44613, 38.40284], [-122.44659, 38.40275], [-122.44716, 38.40269], [-122.44742, 38.40261], [-122.44761, 38.40251], [-122.44766, 38.40247], [-122.44768, 38.40235], [-122.44764, 38.4023], [-122.44757, 38.40227], [-122.44797, 38.40183], [-122.44828, 38.40157], [-122.46024, 38.4015]]]} | Open Access 1 | 4582 | Bumpy Camp Nature Preserve | 16503 | 223 | Napa Valley College 268 | State 5 | State Agency 5 | http://www.napavalley.edu/ | Other State 5 | 223 | Napa Valley College 263 | State 5 | State Agency 5 | Napa 11 | 148.027 | Bumpy Camp Nature Preserve | 0 | State Conservation Area 8 | 2 | |
4590 | 4590 | 4589 | {"type": "Polygon", "coordinates": [[[-122.53085, 38.65457], [-122.52623, 38.65454], [-122.52626, 38.66281], [-122.52163, 38.66281], [-122.52162, 38.65813], [-122.52159, 38.65443], [-122.5216, 38.65086], [-122.52621, 38.65092], [-122.53085, 38.65095], [-122.53085, 38.65457]]]} | Open Access 1 | 35477 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 171.758 | 0 | State Other or Unknown 104 | 4 | ||
4604 | 4604 | 4603 | {"type": "Polygon", "coordinates": [[[-122.52162, 38.65813], [-122.51683, 38.65816], [-122.51708, 38.65772], [-122.517, 38.65768], [-122.51701, 38.65454], [-122.51243, 38.65456], [-122.51247, 38.65095], [-122.5216, 38.65086], [-122.52159, 38.65443], [-122.52162, 38.65813]]]} | Open Access 1 | 35702 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 119.087 | 0 | State Other or Unknown 104 | 4 | ||
5657 | 5657 | 5656 | {"type": "Polygon", "coordinates": [[[-122.55331, 38.60735], [-122.54863, 38.60741], [-122.54854, 38.60384], [-122.55324, 38.60379], [-122.55331, 38.60735]]]} | Open Access 1 | 43096 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 40.016 | 0 | State Other or Unknown 104 | 4 | ||
6141 | 6141 | 6140 | {"type": "Polygon", "coordinates": [[[-122.52219, 38.63641], [-122.50388, 38.63646], [-122.50364, 38.62913], [-122.50339, 38.62105], [-122.51918, 38.62181], [-122.52113, 38.62186], [-122.52112, 38.62188], [-122.52119, 38.62321], [-122.5214, 38.6255], [-122.52219, 38.63641]]]} | Open Access 1 | 1162 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Napa 11 | 643.448 | SLC | 0 | State Resource Management Area 55 | 3 | |
6641 | 6641 | 6640 | {"type": "Polygon", "coordinates": [[[-122.30898, 38.21963], [-122.30854, 38.22266], [-122.30777, 38.22425], [-122.30621, 38.22585], [-122.30316, 38.22649], [-122.30295, 38.22545], [-122.30208, 38.22003], [-122.29915, 38.22007], [-122.29928, 38.2196], [-122.30072, 38.21846], [-122.3028, 38.21904], [-122.30898, 38.21963]]]} | Open Access 1 | 4492 | Bull Island | 16501 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Napa 11 | 100.348 | Bull Island | None 537 | |||
6750 | 6750 | 6749 | {"type": "Polygon", "coordinates": [[[-122.20351, 38.39474], [-122.20319, 38.39454], [-122.20286, 38.39422], [-122.20272, 38.39405], [-122.20259, 38.39383], [-122.20236, 38.3935], [-122.20227, 38.39332], [-122.20224, 38.39304], [-122.20227, 38.39292], [-122.20234, 38.39283], [-122.20237, 38.39269], [-122.20236, 38.39256], [-122.2023, 38.39242], [-122.20223, 38.3923], [-122.20209, 38.39217], [-122.20207, 38.3921], [-122.20208, 38.392], [-122.20213, 38.39192], [-122.20226, 38.3916], [-122.20266, 38.39133], [-122.20249, 38.39094], [-122.20223, 38.39075], [-122.20181, 38.39006], [-122.20176, 38.38991], [-122.20181, 38.38973], [-122.20189, 38.38957], [-122.20196, 38.38931], [-122.20185, 38.38897], [-122.20163, 38.38873], [-122.20152, 38.38847], [-122.20151, 38.38838], [-122.20155, 38.38829], [-122.20162, 38.38801], [-122.20178, 38.38753], [-122.20178, 38.38737], [-122.20176, 38.38726], [-122.20165, 38.38706], [-122.20158, 38.38698], [-122.20153, 38.38687], [-122.20158, 38.38645], [-122.20157, 38.38591], [-122.20153, 38.38561], [-122.20147, 38.38547], [-122.20134, 38.38522], [-122.20117, 38.38497], [-122.2033, 38.38496], [-122.20351, 38.39474]]]} | Open Access 1 | 5115 | Department Of Transportation | 18098 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 32.678 | Department Of Transportation | None 548 | |||
9535 | 9535 | 9534 | {"type": "Polygon", "coordinates": [[[-122.38699, 38.39466], [-122.37714, 38.39469], [-122.37938, 38.38742], [-122.38029, 38.38436], [-122.37717, 38.39444], [-122.37409, 38.39566], [-122.37335, 38.39398], [-122.37121, 38.39263], [-122.3693, 38.39221], [-122.36874, 38.39053], [-122.36846, 38.38914], [-122.36755, 38.38821], [-122.366, 38.38782], [-122.37008, 38.38595], [-122.37392, 38.39097], [-122.37515, 38.39047], [-122.37727, 38.38728], [-122.37763, 38.38706], [-122.37758, 38.38599], [-122.37775, 38.3841], [-122.3772, 38.38216], [-122.37717, 38.38217], [-122.37531, 38.38163], [-122.37518, 38.38087], [-122.37591, 38.37813], [-122.3817, 38.37932], [-122.38186, 38.37922], [-122.38154, 38.38027], [-122.38184, 38.38028], [-122.38222, 38.39106], [-122.38683, 38.39105], [-122.38699, 38.39466]]]} | Open Access 1 | 15987 | Veterans Home Open Space | 1819 | 206 | California Department of Veterans Affairs 170 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 206 | California Department of Veterans Affairs 166 | State 5 | State Agency 5 | Napa 11 | 347.642 | Veterans Home OS | 0 | State Recreation Area 39 | 4 | |
11176 | 11176 | 11175 | {"type": "MultiPolygon", "coordinates": [[[[-122.28776, 38.1555], [-122.28693, 38.16063], [-122.28682, 38.16141], [-122.26686, 38.16148], [-122.26672, 38.16113], [-122.26472, 38.16077], [-122.26477, 38.15542], [-122.27349, 38.15548], [-122.28776, 38.1555]]], [[[-122.32898, 38.1936], [-122.3289, 38.19408], [-122.32869, 38.19458], [-122.32562, 38.20049], [-122.3254, 38.2006], [-122.32482, 38.20049], [-122.3228, 38.19815], [-122.32253, 38.19809], [-122.32103, 38.19646], [-122.31788, 38.19266], [-122.31725, 38.19211], [-122.31698, 38.19165], [-122.31684, 38.1911], [-122.31683, 38.19062], [-122.31693, 38.19011], [-122.31695, 38.18973], [-122.31722, 38.18931], [-122.31728, 38.18808], [-122.31719, 38.18758], [-122.31732, 38.18662], [-122.31822, 38.18643], [-122.31895, 38.18637], [-122.31981, 38.18601], [-122.32251, 38.18536], [-122.32282, 38.18534], [-122.32565, 38.18704], [-122.32593, 38.18714], [-122.32734, 38.19124], [-122.32772, 38.19219], [-122.32898, 38.1936]]]]} | Open Access 1 | 25326 | Napa-Sonoma Marshes Wildlife Area | 30478 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Napa-Sonoma-Marshes-WA | Napa 11 | 590.74 | Napa-Sonoma Marshes Wildlife Area | 1953 | State Conservation Area 8 | 2 |
12264 | 12264 | 12263 | {"type": "Polygon", "coordinates": [[[-122.34065, 38.43479], [-122.33607, 38.43482], [-122.3342, 38.43477], [-122.33024, 38.43188], [-122.31255, 38.42754], [-122.31252, 38.42674], [-122.30773, 38.42655], [-122.30763, 38.4229], [-122.30341, 38.42274], [-122.30339, 38.41911], [-122.30753, 38.41926], [-122.31223, 38.4194], [-122.31238, 38.42307], [-122.31712, 38.42325], [-122.31731, 38.42695], [-122.32649, 38.42714], [-122.3313, 38.42785], [-122.3314, 38.43135], [-122.33603, 38.4315], [-122.33604, 38.43157], [-122.33849, 38.43177], [-122.34057, 38.43186], [-122.34065, 38.43479]]]} | Open Access 1 | 25818 | Rector Reservoir Wildlife Area | 30490 | 206 | California Department of Veterans Affairs 170 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Napa 11 | 349.564 | Rector Reservoir Wildlife Area | 1998 | State Conservation Area 8 | 2 | |
16593 | 16593 | 16592 | {"type": "MultiPolygon", "coordinates": [[[[-122.5586, 38.6838], [-122.55473, 38.68451], [-122.55398, 38.68451], [-122.55398, 38.68085], [-122.55859, 38.68086], [-122.5586, 38.6838]]], [[[-122.58595, 38.67705], [-122.58595, 38.67735], [-122.57684, 38.67946], [-122.57685, 38.67727], [-122.58595, 38.67705]]]]} | Open Access 1 | 44758 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Napa 11 | 64.112 | SLC | 0 | State Resource Management Area 55 | 3 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);