units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
137 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 5 sorted by LAYER
This data as json, copyable, CSV (advanced)
DES_TP 23
- State Resource Management Area 62
- State Conservation Area 20
- State Other or Unknown 9
- State Park 5
- State Historic or Cultural Area 3
- None 1
- State Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 13
- California Department of Fish and Wildlife 78
- California Department of Parks and Recreation 15
- California Department of Water Resources 7
- California Department of Transportation 4
- California Department of General Services 2
- California Wildlife Conservation Board 2
- Coachella Valley Mountains Conservancy 2
- California Tahoe Conservancy 2
- California State Lands Commission 1
- Napa Valley College 1
- San Diego State University 1
- California State University 1
- California State Coastal Conservancy 1
MNG_AG_TYP 1
- State Agency · 117 ✖
ACCESS_TYP 1
- No Public Access · 117 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5656 | 5656 | 5655 | {"type": "Polygon", "coordinates": [[[-122.27035, 38.24032], [-122.27033, 38.24039], [-122.27027, 38.24044], [-122.26924, 38.24035], [-122.2691, 38.24036], [-122.26909, 38.24025], [-122.27035, 38.24032]]]} | No Public Access 3 | 43095 | Unnamed site - California Department of General Services | 28625 | 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 | 0.336 | 0 | State Other or Unknown 104 | 4 | ||
6493 | 6493 | 6492 | {"type": "Polygon", "coordinates": [[[-120.12173, 36.2483], [-120.12148, 36.2483], [-120.12147, 36.24807], [-120.10457, 36.24812], [-120.10456, 36.24822], [-120.10395, 36.24822], [-120.10394, 36.2482], [-120.10338, 36.24816], [-120.10321, 36.24807], [-120.08575, 36.24814], [-120.08572, 36.25219], [-120.08397, 36.25081], [-120.08324, 36.25055], [-120.08275, 36.25016], [-120.08242, 36.2498], [-120.07876, 36.24666], [-120.07738, 36.24531], [-120.07628, 36.2438], [-120.07409, 36.24039], [-120.07219, 36.23723], [-120.06988, 36.23366], [-120.06783, 36.23367], [-120.06784, 36.23047], [-120.06518, 36.22639], [-120.06119, 36.22002], [-120.05967, 36.22059], [-120.05947, 36.22022], [-120.06106, 36.2196], [-120.06106, 36.21959], [-120.05979, 36.21789], [-120.05716, 36.21086], [-120.05712, 36.21066], [-120.05696, 36.21019], [-120.05185, 36.1961], [-120.05042, 36.19239], [-120.04902, 36.18883], [-120.0482, 36.18882], [-120.0484, 36.18167], [-120.05002, 36.18159], [-120.05751, 36.18176], [-120.05747, 36.18776], [-120.05533, 36.18777], [-120.05526, 36.18884], [-120.05085, 36.18883], [-120.05084, 36.18884], [-120.05225, 36.19238], [-120.05722, 36.19239], [-120.05722, 36.196], [-120.05384, 36.19606], [-120.05383, 36.19608], [-120.05892, 36.21036], [-120.0594, 36.21066], [-120.06768, 36.21071], [-120.06771, 36.21712], [-120.08038, 36.21218], [-120.08246, 36.21139], [-120.08563, 36.21136], [-120.08582, 36.22637], [-120.091, 36.22637], [-120.10353, 36.22642], [-120.12169, 36.22629], [-120.12169, 36.2408], [-120.12173, 36.2483]]]} | No Public Access 3 | 2352 | Arroyo Pasajero Westside Detention Basin | 15624 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Fresno 9 | 3819.876 | Arroyo Pasajero Westside Detention Basin | None 524 | |||
6759 | 6759 | 6758 | {"type": "Polygon", "coordinates": [[[-122.22476, 38.22438], [-122.22475, 38.22525], [-122.2237, 38.22526], [-122.2237, 38.22472], [-122.22307, 38.22433], [-122.2222, 38.22245], [-122.22221, 38.22188], [-122.22324, 38.22127], [-122.22322, 38.22152], [-122.22316, 38.22152], [-122.22316, 38.22161], [-122.22261, 38.22185], [-122.22242, 38.22209], [-122.22241, 38.22244], [-122.22307, 38.22385], [-122.22384, 38.22431], [-122.22415, 38.22431], [-122.22452, 38.22437], [-122.22476, 38.22438]]]} | No Public Access 3 | 5145 | Department Of Water Resourses | 18099 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Napa 11 | 4.793 | Department Of Water Resourses | None 549 | |||
6778 | 6778 | 6777 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | 5258 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Napa 11 | 0.163 | Dept Of Transportation/Paul Kenny | None 551 | |||
7312 | 7312 | 7311 | {"type": "Polygon", "coordinates": [[[-122.27901, 38.29895], [-122.27868, 38.299], [-122.27861, 38.29876], [-122.27894, 38.2987], [-122.27901, 38.29895]]]} | No Public Access 3 | 6623 | 575 Third St | 15206 | 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 | 0.21 | 575 Third St | None 604 | |||
7841 | 7841 | 7840 | {"type": "Polygon", "coordinates": [[[-116.95835, 32.58995], [-116.95155, 32.59194], [-116.94918, 32.59009], [-116.947, 32.58786], [-116.94582, 32.58582], [-116.94542, 32.58527], [-116.94808, 32.58424], [-116.94748, 32.58333], [-116.94716, 32.58293], [-116.94705, 32.58296], [-116.94672, 32.58291], [-116.94635, 32.58283], [-116.94603, 32.58271], [-116.94582, 32.58248], [-116.9458, 32.58217], [-116.94581, 32.58211], [-116.94962, 32.58217], [-116.95013, 32.5831], [-116.95155, 32.5844], [-116.95157, 32.58584], [-116.9523, 32.58586], [-116.95595, 32.58857], [-116.95639, 32.58888], [-116.95835, 32.58995]]]} | No Public Access 3 | 47716 | Otay Valley Regional Park | 31498 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | San Diego 4 | 146.674 | Otay Valley RP | None 656 | ||
7862 | 7862 | 7861 | {"type": "MultiPolygon", "coordinates": [[[[-116.94813, 32.58902], [-116.9452, 32.5891], [-116.94513, 32.5821], [-116.94581, 32.58211], [-116.9458, 32.58217], [-116.94582, 32.58248], [-116.94603, 32.58271], [-116.94635, 32.58283], [-116.94672, 32.58291], [-116.94705, 32.58296], [-116.94715, 32.58293], [-116.94748, 32.58333], [-116.94808, 32.58424], [-116.94542, 32.58527], [-116.94582, 32.58582], [-116.947, 32.58786], [-116.94813, 32.58902]]], [[[-116.96324, 32.58239], [-116.96221, 32.58238], [-116.96223, 32.58109], [-116.96255, 32.58146], [-116.96287, 32.58187], [-116.96324, 32.58239]]], [[[-116.97107, 32.58246], [-116.96665, 32.58242], [-116.96664, 32.58433], [-116.9656, 32.58432], [-116.96528, 32.5838], [-116.96527, 32.58366], [-116.96504, 32.58323], [-116.96479, 32.58282], [-116.96439, 32.58227], [-116.96379, 32.5813], [-116.96318, 32.58026], [-116.96293, 32.57991], [-116.96267, 32.57957], [-116.96225, 32.57912], [-116.96225, 32.57881], [-116.96235, 32.5788], [-116.96238, 32.57507], [-116.97088, 32.57514], [-116.97107, 32.58246]]]]} | No Public Access 3 | 47715 | Lonestar Ridge TransNet Environmental Mitigation | 31496 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 191.623 | Lonestar Ridge TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
8625 | 8625 | 8624 | {"type": "Polygon", "coordinates": [[[-120.1217, 34.50899], [-120.1215, 34.51982], [-120.12123, 34.53056], [-120.11243, 34.53048], [-120.11238, 34.5342], [-120.10805, 34.53417], [-120.108, 34.53779], [-120.10865, 34.5378], [-120.09496, 34.53782], [-120.095, 34.53396], [-120.09499, 34.53395], [-120.09504, 34.53037], [-120.09508, 34.5298], [-120.09469, 34.52938], [-120.0943, 34.529], [-120.09418, 34.52877], [-120.09451, 34.52685], [-120.09508, 34.52678], [-120.09515, 34.52404], [-120.09518, 34.52331], [-120.09512, 34.51591], [-120.11291, 34.516], [-120.11298, 34.50877], [-120.1217, 34.50899]]]} | No Public Access 3 | 13788 | Rancho Dos Vistas | 24143 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Santa Barbara 7 | 1402.81 | Rancho Dos Vistas | None 721 | |||
9163 | 9163 | 9162 | {"type": "Polygon", "coordinates": [[[-122.46839, 38.40869], [-122.46606, 38.40871], [-122.46603, 38.40487], [-122.46579, 38.40181], [-122.46609, 38.40194], [-122.46628, 38.402], [-122.46661, 38.40209], [-122.46676, 38.4021], [-122.4669, 38.40215], [-122.46726, 38.40233], [-122.4675, 38.40235], [-122.46761, 38.40231], [-122.46771, 38.40225], [-122.46801, 38.40199], [-122.46819, 38.40193], [-122.46832, 38.40179], [-122.46839, 38.40869]]]} | No Public Access 3 | 15212 | Dale Peters Clyde | 17895 | 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 | 37.395 | Dale Peters Clyde | None 758 | |||
9250 | 9250 | 9249 | {"type": "MultiPolygon", "coordinates": [[[[-116.44947, 33.88499], [-116.44723, 33.88499], [-116.44529, 33.88496], [-116.4457, 33.88489], [-116.44596, 33.88482], [-116.44707, 33.88443], [-116.44732, 33.88435], [-116.44773, 33.88427], [-116.44824, 33.8842], [-116.44946, 33.88418], [-116.44947, 33.88499]]], [[[-116.46255, 33.8886], [-116.46251, 33.89218], [-116.45813, 33.89218], [-116.45819, 33.88861], [-116.46255, 33.8886]]], [[[-116.47988, 33.89224], [-116.47985, 33.89496], [-116.47554, 33.89498], [-116.47555, 33.89223], [-116.47988, 33.89224]]]]} | No Public Access 3 | 15404 | Edom Hill-Willow Hole Preserve | 18453 | 214 | Coachella Valley Mountains Conservancy 767 | State 5 | State Agency 5 | http://www.cvmc.ca.gov/ | Other State 5 | 214 | Coachella Valley Mountains Conservancy 748 | State 5 | State Agency 5 | Riverside 10 | 75.092 | Edom Hill-Willow Hole Preserve | 0 | State Conservation Area 8 | 2 | |
9251 | 9251 | 9250 | {"type": "Polygon", "coordinates": [[[-116.47394, 33.88857], [-116.47122, 33.88857], [-116.47122, 33.88785], [-116.47129, 33.88596], [-116.47394, 33.88857]]]} | No Public Access 3 | 15407 | Edom Hill-Willow Hole Preserve | 18453 | 214 | Coachella Valley Mountains Conservancy 767 | State 5 | State Agency 5 | http://www.cvmc.ca.gov/ | Other State 5 | 214 | Coachella Valley Mountains Conservancy 748 | State 5 | State Agency 5 | Riverside 10 | 9.085 | Edom Hill-Willow Hole Preserve | 0 | State Conservation Area 8 | 2 | |
9361 | 9361 | 9360 | {"type": "MultiPolygon", "coordinates": [[[[-122.29969, 38.27466], [-122.29947, 38.27466], [-122.29946, 38.27356], [-122.29948, 38.27356], [-122.29969, 38.27466]]], [[[-122.46397, 38.50119], [-122.46394, 38.50121], [-122.46301, 38.50039], [-122.46304, 38.50037], [-122.46397, 38.50119]]]]} | No Public Access 3 | 15638 | Department of Transportation | 18097 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Napa 11 | 0.423 | Department of Transportation | None 770 | |||
11282 | 11282 | 11281 | {"type": "Polygon", "coordinates": [[[-121.41367, 38.23999], [-121.41393, 38.24073], [-121.41403, 38.24115], [-121.41401, 38.24182], [-121.41387, 38.2422], [-121.41372, 38.24252], [-121.41349, 38.24273], [-121.4134, 38.24305], [-121.41338, 38.24337], [-121.41318, 38.24429], [-121.41301, 38.24479], [-121.41253, 38.2454], [-121.41205, 38.2458], [-121.41183, 38.24594], [-121.41149, 38.2461], [-121.41107, 38.24659], [-121.41077, 38.24686], [-121.41051, 38.24724], [-121.41014, 38.24789], [-121.40986, 38.24824], [-121.4098, 38.24835], [-121.40967, 38.24845], [-121.40943, 38.24856], [-121.40929, 38.24867], [-121.40924, 38.24878], [-121.40917, 38.24913], [-121.40828, 38.25009], [-121.40789, 38.25041], [-121.40766, 38.25056], [-121.40722, 38.25103], [-121.40677, 38.25159], [-121.40616, 38.25214], [-121.40585, 38.25266], [-121.40583, 38.25277], [-121.40585, 38.25291], [-121.40612, 38.25307], [-121.40671, 38.25329], [-121.4067, 38.25337], [-121.4064, 38.25349], [-121.40605, 38.25368], [-121.40588, 38.2538], [-121.4057, 38.25401], [-121.40567, 38.25411], [-121.40595, 38.25412], [-121.40522, 38.25423], [-121.40433, 38.25417], [-121.4041, 38.25411], [-121.40216, 38.2541], [-121.40127, 38.25383], [-121.40146, 38.25112], [-121.40144, 38.25103], [-121.40136, 38.25096], [-121.40126, 38.25093], [-121.39906, 38.25089], [-121.39863, 38.25068], [-121.3983, 38.25048], [-121.39765, 38.24996], [-121.39734, 38.24974], [-121.39617, 38.24779], [-121.39663, 38.24661], [-121.39638, 38.24624], [-121.39618, 38.246], [-121.39563, 38.24543], [-121.39533, 38.24509], [-121.39504, 38.24486], [-121.39474, 38.24467], [-121.39269, 38.24467], [-121.39251, 38.2447], [-121.39178, 38.24494], [-121.39059, 38.24485], [-121.39026, 38.24475], [-121.38955, 38.24426], [-121.38627, 38.24134], [-121.38819, 38.24132], [-121.3925, 38.24131], [-121.39949, 38.24126], [-121.39985, 38.24123], [-121.40024, 38.24113], [-121.40047, 38.24103], [-121.40227, 38.24019], [-121.40258, 38.24009], [-121.40298, 38.24003], [-121.41367, 38.23999]]]} | No Public Access 3 | 21821 | Grizzly Slough | 30567 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Sacramento 41 | 487.047 | Grizzly Slough | 0 | State Conservation Area 8 | 2 | |
11524 | 11524 | 11523 | {"type": "MultiPolygon", "coordinates": [[[[-121.80139, 36.83624], [-121.80041, 36.83633], [-121.80027, 36.83636], [-121.80012, 36.83642], [-121.79995, 36.83655], [-121.79971, 36.83688], [-121.7995, 36.83724], [-121.79925, 36.83777], [-121.79919, 36.83784], [-121.7991, 36.83789], [-121.799, 36.83791], [-121.7982, 36.83791], [-121.79819, 36.83709], [-121.79848, 36.83654], [-121.79868, 36.83586], [-121.79866, 36.83518], [-121.79844, 36.8349], [-121.79817, 36.83491], [-121.79813, 36.83074], [-121.79879, 36.83073], [-121.79899, 36.83093], [-121.79913, 36.83112], [-121.80064, 36.83479], [-121.80093, 36.83538], [-121.80139, 36.83624]]], [[[-121.80217, 36.83804], [-121.80217, 36.83804], [-121.79919, 36.83804], [-121.7993, 36.83798], [-121.7994, 36.83788], [-121.79964, 36.83739], [-121.7998, 36.8371], [-121.80005, 36.83671], [-121.80016, 36.8366], [-121.80029, 36.83654], [-121.80043, 36.8365], [-121.80148, 36.83639], [-121.8017, 36.83677], [-121.80189, 36.83717], [-121.80204, 36.83758], [-121.80217, 36.83804]]]]} | No Public Access 3 | 48235 | McClusky Slough | 32792 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Monterey 14 | 38.897 | McClusky Slough | 1996 | State Conservation Area 8 | 2 | |
11529 | 11529 | 11528 | {"type": "MultiPolygon", "coordinates": [[[[-118.64078, 37.50286], [-118.6391, 37.50286], [-118.63785, 37.50235], [-118.637, 37.50228], [-118.63677, 37.50201], [-118.63603, 37.50216], [-118.63607, 37.49933], [-118.63603, 37.49932], [-118.63601, 37.50215], [-118.63398, 37.50327], [-118.63386, 37.50338], [-118.63381, 37.50347], [-118.6338, 37.50357], [-118.63384, 37.50371], [-118.63394, 37.50383], [-118.63397, 37.50392], [-118.63398, 37.50453], [-118.63395, 37.50469], [-118.63387, 37.50489], [-118.63383, 37.505], [-118.63382, 37.50545], [-118.63376, 37.50545], [-118.63374, 37.49934], [-118.63378, 37.49576], [-118.63149, 37.49576], [-118.6315, 37.49396], [-118.6338, 37.49396], [-118.63383, 37.49216], [-118.64077, 37.49217], [-118.64077, 37.49928], [-118.64076, 37.50283], [-118.64078, 37.50286]]], [[[-118.63498, 37.50563], [-118.63496, 37.50642], [-118.63375, 37.50642], [-118.63375, 37.50562], [-118.63498, 37.50563]]], [[[-118.636, 37.50234], [-118.63598, 37.50626], [-118.63517, 37.50626], [-118.63517, 37.50546], [-118.63403, 37.50545], [-118.63404, 37.50501], [-118.63417, 37.50467], [-118.63419, 37.5045], [-118.63418, 37.50387], [-118.63414, 37.50378], [-118.63403, 37.50364], [-118.63401, 37.50354], [-118.63403, 37.50347], [-118.6341, 37.50341], [-118.636, 37.50234]]]]} | No Public Access 3 | 48236 | Round Valley Wildlife Area | 33312 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Mono 32 | 203.625 | Round Valley Wildlife Area | 1993 | State Conservation Area 8 | 2 | |
12265 | 12265 | 12264 | {"type": "Polygon", "coordinates": [[[-122.53034, 38.61119], [-122.52572, 38.61121], [-122.52574, 38.61484], [-122.52112, 38.61486], [-122.52091, 38.614], [-122.52089, 38.61399], [-122.52101, 38.61821], [-122.51659, 38.61803], [-122.51647, 38.6144], [-122.51625, 38.60714], [-122.52067, 38.60732], [-122.52401, 38.60734], [-122.53031, 38.60743], [-122.53034, 38.61119]]]} | No Public Access 3 | 25816 | California State Lands Commission | 16723 | 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 | 245.258 | SLC | 0 | State Resource Management Area 55 | 3 | |
12480 | 12480 | 12479 | {"type": "MultiPolygon", "coordinates": [[[[-122.25932, 37.07222], [-122.2477, 37.07952], [-122.24783, 37.07973], [-122.24768, 37.08009], [-122.24745, 37.08032], [-122.24739, 37.08069], [-122.24722, 37.08094], [-122.24707, 37.08113], [-122.24726, 37.08134], [-122.24731, 37.08166], [-122.24766, 37.08181], [-122.24799, 37.082], [-122.24828, 37.0823], [-122.24863, 37.08254], [-122.24897, 37.08316], [-122.24965, 37.08265], [-122.25006, 37.0833], [-122.25039, 37.0843], [-122.25054, 37.08454], [-122.2508, 37.08473], [-122.25112, 37.08475], [-122.25207, 37.08536], [-122.25255, 37.08587], [-122.25274, 37.08618], [-122.25295, 37.08632], [-122.24433, 37.09295], [-122.23879, 37.0858], [-122.23897, 37.08567], [-122.23907, 37.08552], [-122.2389, 37.08547], [-122.23889, 37.08528], [-122.23878, 37.085], [-122.23898, 37.08496], [-122.23926, 37.085], [-122.23952, 37.08488], [-122.23957, 37.08447], [-122.23968, 37.08419], [-122.23957, 37.08404], [-122.23964, 37.08379], [-122.23985, 37.08369], [-122.23975, 37.08353], [-122.24001, 37.0832], [-122.24018, 37.08319], [-122.24027, 37.08286], [-122.24047, 37.0826], [-122.2404, 37.0824], [-122.24054, 37.0821], [-122.24083, 37.0821], [-122.24103, 37.08214], [-122.24115, 37.08194], [-122.24125, 37.08152], [-122.24194, 37.08099], [-122.24225, 37.08093], [-122.24241, 37.08081], [-122.24246, 37.08071], [-122.24235, 37.08056], [-122.24267, 37.08043], [-122.24279, 37.08003], [-122.24328, 37.07974], [-122.24346, 37.07987], [-122.24368, 37.07986], [-122.24383, 37.07959], [-122.24376, 37.07944], [-122.24339, 37.07936], [-122.24348, 37.07907], [-122.24379, 37.07912], [-122.24386, 37.07891], [-122.2437, 37.07876], [-122.24429, 37.07864], [-122.24429, 37.07862], [-122.24415, 37.07853], [-122.24422, 37.07837], [-122.24453, 37.07821], [-122.24527, 37.07747], [-122.24509, 37.07716], [-122.24464, 37.07674], [-122.24407, 37.07677], [-122.24374, 37.07656], [-122.24331, 37.0764], [-122.24251, 37.07647], [-122.24244, 37.07596], [-122.24219, 37.07562], [-122.24173, 37.07536], [-122.24094, 37.07535], [-122.24062, 37.07472], [-122.24018, 37.07449], [-122.23971, 37.07454], [-122.23887, 37.07392], [-122.23808, 37.07439], [-122.23772, 37.07418], [-122.23742, 37.07379], [-122.23674, 37.07385], [-122.23602, 37.07367], [-122.23567, 37.07302], [-122.23522, 37.073], [-122.23532, 37.07263], [-122.23568, 37.07241], [-122.23569, 37.07217], [-122.2352, 37.07187], [-122.23472, 37.07121], [-122.23418, 37.071], [-122.23371, 37.07114], [-122.23306, 37.07075], [-122.2323, 37.07072], [-122.23185, 37.07024], [-122.23131, 37.06949], [-122.23143, 37.06912], [-122.23119, 37.0686], [-122.23157, 37.06806], [-122.23076, 37.06739], [-122.23052, 37.06711], [-122.23043, 37.06692], [-122.23042, 37.0668], [-122.23013, 37.06664], [-122.2296, 37.06605], [-122.22956, 37.06595], [-122.22946, 37.06513], [-122.22951, 37.06502], [-122.22955, 37.06498], [-122.2298, 37.06441], [-122.22986, 37.06426], [-122.22986, 37.06423], [-122.22984, 37.06419], [-122.22982, 37.06412], [-122.22929, 37.06326], [-122.229, 37.06309], [-122.22884, 37.06302], [-122.22831, 37.06262], [-122.22799, 37.0624], [-122.22785, 37.06224], [-122.2278, 37.06197], [-122.22758, 37.06214], [-122.22753, 37.06233], [-122.2275, 37.06236], [-122.22684, 37.06277], [-122.22643, 37.0628], [-122.22678, 37.06318], [-122.22605, 37.06326], [-122.22583, 37.06301], [-122.22522, 37.06043], [-122.22527, 37.05851], [-122.22499, 37.05703], [-122.22557, 37.05361], [-122.22511, 37.05011], [-122.22388, 37.04905], [-122.22366, 37.04909], [-122.22365, 37.04911], [-122.22493, 37.05017], [-122.22539, 37.0537], [-122.22481, 37.05705], [-122.22509, 37.0585], [-122.22503, 37.06048], [-122.22571, 37.06306], [-122.22573, 37.06308], [-122.22513, 37.06342], [-122.22499, 37.06401], [-122.22431, 37.06432], [-122.2225, 37.06477], [-122.22379, 37.06645], [-122.22114, 37.06783], [-122.22101, 37.06916], [-122.21937, 37.06917], [-122.21481, 37.06924], [-122.21483, 37.07309], [-122.21029, 37.07307], [-122.21033, 37.0767], [-122.20578, 37.0767], [-122.20577, 37.0804], [-122.20572, 37.08394], [-122.19866, 37.084], [-122.20206, 37.06942], [-122.2148, 37.06923], [-122.21478, 37.06698], [-122.20262, 37.067], [-122.2054, 37.05526], [-122.20568, 37.05899], [-122.21012, 37.05896], [-122.21013, 37.0586], [-122.21073, 37.05856], [-122.21131, 37.05849], [-122.21175, 37.0584], [-122.21234, 37.05809], [-122.2132, 37.05748], [-122.21442, 37.05622], [-122.2149, 37.05582], [-122.21527, 37.05548], [-122.21538, 37.05542], [-122.20885, 37.04683], [-122.20996, 37.0465], [-122.21079, 37.04617], [-122.21145, 37.04605], [-122.21236, 37.04611], [-122.21313, 37.04579], [-122.21394, 37.04525], [-122.21397, 37.04466], [-122.21556, 37.04427], [-122.21629, 37.04419], [-122.21929, 37.04322], [-122.22024, 37.04316], [-122.22188, 37.04241], [-122.2223, 37.04216], [-122.22279, 37.04177], [-122.22399, 37.04085], [-122.226, 37.04065], [-122.22594, 37.03993], [-122.22635, 37.03878], [-122.22656, 37.03863], [-122.22733, 37.03926], [-122.22782, 37.03984], [-122.22991, 37.04165], [-122.23083, 37.04275], [-122.23222, 37.04368], [-122.23367, 37.04491], [-122.23433, 37.04571], [-122.23609, 37.04724], [-122.23689, 37.04778], [-122.24179, 37.052], [-122.24307, 37.05325], [-122.2432, 37.0534], [-122.2433, 37.05356], [-122.24344, 37.05375], [-122.24361, 37.05391], [-122.24375, 37.05399], [-122.24386, 37.05409], [-122.24395, 37.05421], [-122.2446, 37.05496], [-122.24513, 37.05544], [-122.24543, 37.05573], [-122.24584, 37.0562], [-122.24673, 37.05716], [-122.24746, 37.05789], [-122.25088, 37.06081], [-122.25149, 37.06138], [-122.25204, 37.06199], [-122.25237, 37.06241], [-122.25431, 37.06517], [-122.25411, 37.06528], [-122.25425, 37.0655], [-122.25457, 37.06578], [-122.25539, 37.06695], [-122.25554, 37.06735], [-122.25616, 37.06795], [-122.25795, 37.07081], [-122.2585, 37.07123], [-122.25932, 37.07222]]], [[[-122.23804, 37.047], [-122.23732, 37.04754], [-122.2372, 37.04744], [-122.23703, 37.04718], [-122.23689, 37.04702], [-122.23662, 37.04683], [-122.23631, 37.04668], [-122.23579, 37.04621], [-122.23673, 37.04552], [-122.23688, 37.0456], [-122.23755, 37.04645], [-122.23804, 37.047]]], [[[-122.25551, 37.06408], [-122.25505, 37.06463], [-122.25468, 37.065], [-122.25273, 37.06223], [-122.25238, 37.0618], [-122.25201, 37.06138], [-122.25161, 37.06097], [-122.25098, 37.0604], [-122.25049, 37.05992], [-122.24946, 37.05918], [-122.24805, 37.05803], [-122.24781, 37.05759], [-122.24713, 37.05694], [-122.24536, 37.05496], [-122.24596, 37.05447], [-122.24644, 37.05502], [-122.24718, 37.05603], [-122.24741, 37.05626], [-122.24838, 37.05674], [-122.24987, 37.05744], [-122.25058, 37.0579], [-122.25123, 37.05841], [-122.25156, 37.05878], [-122.25287, 37.0608], [-122.25315, 37.0612], [-122.25347, 37.06154], [-122.25457, 37.06331], [-122.25497, 37.0637], [-122.25551, 37.06408]]]]} | No Public Access 3 | 28256 | Swanton Pacific Ranch | 26098 | 210 | California State University 778 | State 5 | State Agency 5 | http://www.calstate.edu/ | Other State 5 | 210 | California State University 758 | State 5 | State Agency 5 | Santa Cruz 5 | 3202.67 | Swanton Pacific Ranch | 0 | State Other or Unknown 104 | 4 | |
13158 | 13158 | 13157 | {"type": "Polygon", "coordinates": [[[-122.52495, 38.06971], [-122.52293, 38.06978], [-122.52096, 38.07133], [-122.51104, 38.06343], [-122.5006, 38.06098], [-122.49657, 38.06008], [-122.49222, 38.05907], [-122.49669, 38.05127], [-122.498, 38.04907], [-122.49841, 38.04941], [-122.49892, 38.04861], [-122.49891, 38.04859], [-122.49831, 38.04855], [-122.49847, 38.04828], [-122.49848, 38.04785], [-122.50668, 38.04784], [-122.50668, 38.04742], [-122.50731, 38.04741], [-122.50732, 38.0474], [-122.50668, 38.04689], [-122.50851, 38.04693], [-122.50972, 38.04814], [-122.51013, 38.04801], [-122.51102, 38.04913], [-122.51148, 38.05001], [-122.51052, 38.05012], [-122.51044, 38.05017], [-122.5105, 38.05049], [-122.50943, 38.05062], [-122.50805, 38.05113], [-122.50669, 38.0522], [-122.50669, 38.05222], [-122.5098, 38.05469], [-122.51448, 38.06081], [-122.51476, 38.06197], [-122.51638, 38.06325], [-122.51678, 38.06343], [-122.51743, 38.06392], [-122.51755, 38.06389], [-122.51761, 38.06395], [-122.5176, 38.06404], [-122.51799, 38.06436], [-122.51829, 38.06465], [-122.51843, 38.0647], [-122.51859, 38.06467], [-122.52495, 38.06971]]]} | No Public Access 3 | 35102 | Hamilton Wetlands | 19625 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Marin 23 | 632.955 | Hamilton Wetlands | 0 | State Conservation Area 8 | 2 | |
13160 | 13160 | 13159 | {"type": "Polygon", "coordinates": [[[-121.90786, 38.13955], [-121.90727, 38.13934], [-121.90599, 38.13665], [-121.90645, 38.13653], [-121.90641, 38.13642], [-121.9066, 38.13638], [-121.90648, 38.13613], [-121.90629, 38.13619], [-121.90601, 38.1357], [-121.9056, 38.13583], [-121.904, 38.13379], [-121.90321, 38.13336], [-121.89865, 38.13299], [-121.89825, 38.13297], [-121.89221, 38.13481], [-121.89275, 38.12979], [-121.89314, 38.12688], [-121.89373, 38.1269], [-121.89445, 38.12691], [-121.89521, 38.12686], [-121.8961, 38.12668], [-121.89703, 38.12634], [-121.89754, 38.12611], [-121.8983, 38.12565], [-121.89897, 38.12516], [-121.89966, 38.12462], [-121.90019, 38.1241], [-121.90056, 38.12365], [-121.901, 38.12305], [-121.90135, 38.12252], [-121.90163, 38.12216], [-121.90213, 38.12141], [-121.90248, 38.12095], [-121.9029, 38.12054], [-121.90329, 38.12021], [-121.9037, 38.1199], [-121.90423, 38.11965], [-121.90473, 38.11946], [-121.90576, 38.11926], [-121.90643, 38.11921], [-121.90724, 38.11922], [-121.90808, 38.1192], [-121.90927, 38.11932], [-121.90966, 38.11945], [-121.91014, 38.11955], [-121.911, 38.11989], [-121.91209, 38.12055], [-121.91256, 38.12094], [-121.91307, 38.12148], [-121.91323, 38.12171], [-121.9135, 38.12227], [-121.91378, 38.1227], [-121.91396, 38.1231], [-121.91408, 38.12356], [-121.91416, 38.12413], [-121.9145, 38.12563], [-121.91463, 38.12636], [-121.91485, 38.12827], [-121.91495, 38.12932], [-121.9148, 38.13117], [-121.91446, 38.13232], [-121.91387, 38.13336], [-121.91373, 38.13379], [-121.91316, 38.13454], [-121.91215, 38.13564], [-121.91157, 38.13636], [-121.91074, 38.13713], [-121.90906, 38.13887], [-121.90842, 38.13935], [-121.90786, 38.13955]]]} | No Public Access 3 | 35104 | Meins Landing | 22105 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Solano 26 | 661.018 | Meins Landing | None 1141 | |||
13162 | 13162 | 13161 | {"type": "Polygon", "coordinates": [[[-121.69523, 37.99864], [-121.69516, 37.99875], [-121.69492, 37.99898], [-121.69489, 37.99899], [-121.69479, 37.99908], [-121.6946, 37.99933], [-121.69451, 37.99949], [-121.69412, 38.00034], [-121.69357, 38.00137], [-121.69349, 38.00155], [-121.69341, 38.00178], [-121.69332, 38.00199], [-121.69256, 38.00334], [-121.69235, 38.00375], [-121.69214, 38.00408], [-121.69172, 38.00498], [-121.69157, 38.0052], [-121.6915, 38.00533], [-121.69134, 38.00615], [-121.6913, 38.00678], [-121.69131, 38.00698], [-121.69117, 38.00802], [-121.69114, 38.00835], [-121.69102, 38.00912], [-121.691, 38.00933], [-121.69101, 38.01008], [-121.69106, 38.01024], [-121.69104, 38.01035], [-121.69121, 38.01057], [-121.69102, 38.01082], [-121.69092, 38.01111], [-121.6909, 38.01129], [-121.69083, 38.01153], [-121.69057, 38.01169], [-121.69041, 38.01184], [-121.69042, 38.01202], [-121.69037, 38.01241], [-121.68974, 38.01329], [-121.68931, 38.01338], [-121.68885, 38.01329], [-121.68808, 38.0132], [-121.68616, 38.01353], [-121.68476, 38.01351], [-121.68233, 38.012], [-121.6797, 38.01151], [-121.6779, 38.01073], [-121.67466, 38.01191], [-121.67439, 38.01196], [-121.67438, 38.01228], [-121.66372, 38.01239], [-121.66372, 38.01234], [-121.66361, 38.01228], [-121.66332, 38.01219], [-121.66305, 38.01222], [-121.66269, 38.0124], [-121.66098, 38.01241], [-121.66075, 38.01191], [-121.66066, 38.01164], [-121.6605, 38.0114], [-121.65932, 38.0089], [-121.65922, 38.00863], [-121.65914, 38.00835], [-121.65911, 38.00795], [-121.65919, 37.99845], [-121.66012, 37.99845], [-121.66014, 37.99791], [-121.66013, 37.9979], [-121.6592, 37.9979], [-121.65925, 37.99124], [-121.66028, 37.99208], [-121.66047, 37.99221], [-121.66068, 37.99233], [-121.6609, 37.99243], [-121.66357, 37.99352], [-121.66415, 37.99377], [-121.67363, 37.99756], [-121.67366, 37.99754], [-121.67405, 37.99767], [-121.67431, 37.99772], [-121.67459, 37.99775], [-121.6759, 37.99776], [-121.67585, 37.99946], [-121.67687, 38.0005], [-121.67805, 38.00051], [-121.67798, 38.00067], [-121.67805, 38.00087], [-121.67806, 38.00179], [-121.67966, 38.00179], [-121.67966, 38.00051], [-121.68253, 38.00051], [-121.68379, 38.0001], [-121.68381, 37.99788], [-121.68397, 37.99792], [-121.6859, 37.99855], [-121.6862, 37.99862], [-121.68641, 37.99865], [-121.68662, 37.99866], [-121.69523, 37.99864]]]} | No Public Access 3 | 35110 | Dutch Slough | 18320 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Contra Costa 12 | 1185.171 | Dutch Slough | 0 | State Conservation Area 8 | 2 |
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]);