units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 3 sorted by MNG_AG_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, LAYER, COUNTY, YR_EST
DES_TP 18
- Local Recreation Area 21
- Local Conservation Area 12
- Local Park 6
- Local Other or Unknown 6
- National 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
MNG_AGENCY 15
- Sacramento, County of 23
- Los Angeles, County of 14
- Orange, County of 5
- San Diego, County of 3
- Santa Cruz, County of 2
- San Luis Obispo, County of 2
- Ventura, County of 2
- Monterey, County of 1
- Tulare, County of 1
- Riverside, County of 1
- Placer, County of 1
- Fresno, County of 1
- Kern, County of 1
- Humboldt, County of 1
- Shasta, County of 1
MNG_AG_TYP 1
- County Agency · 59 ✖
ACCESS_TYP 1
- Restricted Access · 59 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4758 | 4758 | 4757 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | 46661 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 19.487 | 0 | Local Other or Unknown 14 | 4 | ||
4057 | 4057 | 4056 | {"type": "Polygon", "coordinates": [[[-122.40231, 40.58043], [-122.40172, 40.58057], [-122.40131, 40.57969], [-122.40194, 40.57953], [-122.40231, 40.58043]]]} | Restricted Access 2 | 44420 | Magnolia Park | 21676 | 343 | Shasta, County of 717 | County 3 | County Agency 3 | http://www.co.shasta.ca.us/index.aspx | County 3 | 343 | Shasta, County of 700 | County 3 | County Agency 3 | Shasta 27 | 1.399 | Magnolia Park | 0 | Local Park 2 | 4 | |
5855 | 5855 | 5854 | {"type": "Polygon", "coordinates": [[[-118.87212, 34.31513], [-118.86601, 34.31512], [-118.86602, 34.31149], [-118.86145, 34.31148], [-118.85913, 34.30851], [-118.85892, 34.3046], [-118.85829, 34.30065], [-118.86599, 34.30066], [-118.86602, 34.30788], [-118.86833, 34.30788], [-118.87066, 34.30982], [-118.87207, 34.31343], [-118.87212, 34.31513]]]} | Restricted Access 2 | 224 | Rustic Canyon Golf Course | 32984 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 277.113 | Rustic Canyon GC | 0 | Local Recreation Area 3 | 4 | |
6002 | 6002 | 6001 | {"type": "Polygon", "coordinates": [[[-119.16058, 34.28227], [-119.1606, 34.28232], [-119.16056, 34.28237], [-119.1576, 34.28415], [-119.15733, 34.28384], [-119.15656, 34.2843], [-119.15656, 34.28431], [-119.15682, 34.28462], [-119.15395, 34.28635], [-119.15198, 34.28407], [-119.15254, 34.28373], [-119.15218, 34.28332], [-119.15296, 34.28284], [-119.15581, 34.28113], [-119.15737, 34.28293], [-119.16005, 34.28166], [-119.16058, 34.28227]]]} | Restricted Access 2 | 646 | Saticoy Regional Golf Course | 32989 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 48.962 | Saticoy Reg. GC | 0 | Local Recreation Area 3 | 4 | |
262 | 262 | 261 | {"type": "MultiPolygon", "coordinates": [[[[-119.51628, 36.5064], [-119.51628, 36.50687], [-119.51596, 36.50697], [-119.5159, 36.50697], [-119.51578, 36.50704], [-119.51571, 36.50706], [-119.51541, 36.50717], [-119.51519, 36.50722], [-119.51504, 36.50729], [-119.5146, 36.50739], [-119.51446, 36.5074], [-119.51416, 36.5074], [-119.51366, 36.50732], [-119.51344, 36.50726], [-119.51285, 36.50704], [-119.51229, 36.5069], [-119.51198, 36.50687], [-119.5116, 36.50688], [-119.51097, 36.50675], [-119.51085, 36.50679], [-119.51073, 36.50687], [-119.51069, 36.50704], [-119.51062, 36.50717], [-119.51053, 36.50724], [-119.51037, 36.50734], [-119.5101, 36.50745], [-119.50998, 36.50746], [-119.50976, 36.5076], [-119.50924, 36.50769], [-119.50894, 36.5078], [-119.50879, 36.50781], [-119.50838, 36.5078], [-119.50839, 36.5066], [-119.50732, 36.50658], [-119.50733, 36.50532], [-119.50718, 36.50531], [-119.50723, 36.50332], [-119.51176, 36.50332], [-119.51176, 36.50188], [-119.51343, 36.50219], [-119.51503, 36.50228], [-119.51505, 36.50638], [-119.51628, 36.5064]]], [[[-119.51651, 36.50754], [-119.5165, 36.50802], [-119.51522, 36.50835], [-119.51522, 36.5079], [-119.5154, 36.50788], [-119.51546, 36.50784], [-119.51651, 36.50754]]]]} | Restricted Access 2 | 733 | Kings River Nature Preserve | 20663 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 86.678 | Kings River Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
9135 | 9135 | 9134 | {"type": "Polygon", "coordinates": [[[-121.8062, 36.9086], [-121.80603, 36.90929], [-121.80576, 36.90997], [-121.80555, 36.91066], [-121.80541, 36.91092], [-121.80506, 36.91124], [-121.8049, 36.9115], [-121.80481, 36.91148], [-121.80472, 36.91147], [-121.80272, 36.91153], [-121.80291, 36.90858], [-121.8062, 36.9086]]]} | Restricted Access 2 | 16765 | Harkins Slough | 28149 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 20.48 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
9698 | 9698 | 9697 | {"type": "MultiPolygon", "coordinates": [[[[-121.81062, 36.91], [-121.81032, 36.90991], [-121.81001, 36.91005], [-121.80937, 36.91143], [-121.80919, 36.91137], [-121.8094, 36.9109], [-121.80963, 36.91001], [-121.80983, 36.90957], [-121.80981, 36.90862], [-121.81062, 36.91]]], [[[-121.8208, 36.91677], [-121.81946, 36.91684], [-121.8184, 36.91715], [-121.81784, 36.91788], [-121.81749, 36.91791], [-121.81589, 36.91711], [-121.81536, 36.91645], [-121.8149, 36.91595], [-121.81467, 36.91595], [-121.81398, 36.91524], [-121.81264, 36.91331], [-121.81191, 36.9127], [-121.81154, 36.9117], [-121.81148, 36.91147], [-121.81215, 36.91259], [-121.81332, 36.91179], [-121.8138, 36.91263], [-121.81399, 36.91289], [-121.81422, 36.91312], [-121.81616, 36.91481], [-121.81662, 36.91515], [-121.81714, 36.91542], [-121.8177, 36.91562], [-121.8183, 36.91574], [-121.81892, 36.91578], [-121.81954, 36.91574], [-121.82052, 36.91553], [-121.8208, 36.91677]]]]} | Restricted Access 2 | 16385 | Gallighan Slough | 28152 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 41.877 | Gallighan Slough | 0 | Local Conservation Area 4 | 2 | |
16433 | 16433 | 16432 | {"type": "Polygon", "coordinates": [[[-120.74154, 35.3331], [-120.73974, 35.33628], [-120.73643, 35.3387], [-120.73575, 35.33844], [-120.73517, 35.33868], [-120.73285, 35.3378], [-120.72967, 35.33978], [-120.72435, 35.34033], [-120.72421, 35.34083], [-120.72439, 35.34155], [-120.72495, 35.34214], [-120.72174, 35.3459], [-120.71513, 35.35322], [-120.71224, 35.35091], [-120.72459, 35.32556], [-120.72558, 35.3253], [-120.72633, 35.32599], [-120.72988, 35.32905], [-120.73035, 35.3294], [-120.73084, 35.32971], [-120.73136, 35.33], [-120.73191, 35.33026], [-120.73247, 35.33048], [-120.73305, 35.33067], [-120.73498, 35.33122], [-120.7373, 35.33191], [-120.73941, 35.33243], [-120.74154, 35.3331]]]} | Restricted Access 2 | 14529 | El Chorro Regional Park and Dairy Creek Golf Course | 33039 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 684.123 | El Chorro RP and Dairy Creek GC | 0 | Local Recreation Area 3 | 4 | |
16927 | 16927 | 16926 | {"type": "MultiPolygon", "coordinates": [[[[-120.6486, 35.47827], [-120.64691, 35.47993], [-120.64474, 35.48211], [-120.64314, 35.47842], [-120.64254, 35.47751], [-120.64174, 35.47671], [-120.64078, 35.47603], [-120.63969, 35.47551], [-120.63961, 35.47559], [-120.63571, 35.47391], [-120.63519, 35.47363], [-120.63473, 35.47327], [-120.63438, 35.47285], [-120.63412, 35.47237], [-120.64037, 35.46871], [-120.6405, 35.46878], [-120.64087, 35.4689], [-120.6417, 35.46914], [-120.64319, 35.46938], [-120.64348, 35.4694], [-120.64491, 35.46934], [-120.64506, 35.46931], [-120.64513, 35.47088], [-120.64566, 35.47188], [-120.64588, 35.47365], [-120.6459, 35.47365], [-120.647, 35.47288], [-120.64704, 35.47299], [-120.64715, 35.47313], [-120.64723, 35.47319], [-120.64742, 35.47326], [-120.64749, 35.47332], [-120.64761, 35.47347], [-120.64684, 35.47375], [-120.64621, 35.47385], [-120.64521, 35.47416], [-120.64491, 35.47415], [-120.6449, 35.47417], [-120.64525, 35.47453], [-120.6486, 35.47827]]], [[[-120.64709, 35.47263], [-120.64603, 35.47336], [-120.64582, 35.47184], [-120.64531, 35.47085], [-120.64525, 35.46978], [-120.64704, 35.46978], [-120.64709, 35.47263]]], [[[-120.64864, 35.47105], [-120.64865, 35.47288], [-120.64863, 35.47292], [-120.64856, 35.47299], [-120.64843, 35.47307], [-120.64824, 35.47314], [-120.64786, 35.47317], [-120.64769, 35.4732], [-120.6475, 35.47317], [-120.64741, 35.47312], [-120.64725, 35.473], [-120.6472, 35.47292], [-120.64718, 35.47285], [-120.64718, 35.47278], [-120.6472, 35.47274], [-120.64728, 35.47267], [-120.64717, 35.47257], [-120.64713, 35.47259], [-120.64711, 35.47107], [-120.64864, 35.47105]]]]} | Restricted Access 2 | 48426 | Chalk Mountain Golf Course | 33050 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 227.705 | Chalk Mtn. GC | 0 | Local Recreation Area 3 | 4 | |
6086 | 6086 | 6085 | {"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]} | Restricted Access 2 | 891 | Blue Sky Ecological Reserve | 29220 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 83.938 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
7963 | 7963 | 7962 | {"type": "MultiPolygon", "coordinates": [[[[-116.96231, 32.5888], [-116.95891, 32.58979], [-116.96013, 32.59278], [-116.95959, 32.59293], [-116.95911, 32.5929], [-116.95864, 32.593], [-116.95789, 32.59309], [-116.95733, 32.59319], [-116.95703, 32.59325], [-116.95686, 32.59339], [-116.95657, 32.59347], [-116.95598, 32.59351], [-116.95514, 32.59365], [-116.95421, 32.59393], [-116.95377, 32.59419], [-116.95265, 32.59474], [-116.95221, 32.59489], [-116.95194, 32.59494], [-116.9508, 32.59216], [-116.95833, 32.58995], [-116.95639, 32.58888], [-116.95595, 32.58857], [-116.9523, 32.58586], [-116.95369, 32.58588], [-116.96222, 32.58619], [-116.96231, 32.5888]]], [[[-116.96197, 32.5973], [-116.96128, 32.5975], [-116.96123, 32.59737], [-116.96109, 32.59724], [-116.96094, 32.5972], [-116.96072, 32.59721], [-116.96053, 32.59726], [-116.96038, 32.59735], [-116.96029, 32.59743], [-116.96024, 32.59751], [-116.9602, 32.59766], [-116.96014, 32.59775], [-116.96003, 32.59785], [-116.95988, 32.59786], [-116.95969, 32.5978], [-116.95952, 32.59771], [-116.95914, 32.59765], [-116.95898, 32.59758], [-116.95875, 32.59759], [-116.95844, 32.59767], [-116.95811, 32.59787], [-116.95753, 32.5982], [-116.95669, 32.59855], [-116.95642, 32.59876], [-116.95623, 32.59892], [-116.95384, 32.59959], [-116.95285, 32.59719], [-116.95353, 32.59743], [-116.95424, 32.59722], [-116.95498, 32.59694], [-116.95604, 32.59641], [-116.95638, 32.5962], [-116.95675, 32.59608], [-116.95783, 32.59581], [-116.9586, 32.59566], [-116.95917, 32.59523], [-116.95938, 32.59502], [-116.96077, 32.59435], [-116.96197, 32.5973]]]]} | Restricted Access 2 | 47729 | Otay Ranch Preserve | 31529 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html | San Diego 4 | 179.037 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
14809 | 14809 | 14808 | {"type": "Polygon", "coordinates": [[[-117.14066, 33.25449], [-117.14028, 33.2546], [-117.14032, 33.2547], [-117.14037, 33.25475], [-117.14057, 33.25543], [-117.1406, 33.25571], [-117.14058, 33.2559], [-117.14028, 33.25665], [-117.14037, 33.25683], [-117.13807, 33.25672], [-117.13802, 33.25307], [-117.13827, 33.25307], [-117.13853, 33.25318], [-117.13868, 33.25322], [-117.13897, 33.25337], [-117.13918, 33.25314], [-117.13955, 33.25349], [-117.14011, 33.25382], [-117.14025, 33.25392], [-117.14035, 33.25403], [-117.14066, 33.25449]]]} | Restricted Access 2 | 45227 | Knollwood Preserve | 31493 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 20.712 | Knollwood Preserve | 0 | Local Conservation Area 4 | 2 | |
2734 | 2734 | 2733 | {"type": "Polygon", "coordinates": [[[-121.33438, 38.34361], [-121.33319, 38.34464], [-121.33304, 38.34475], [-121.33156, 38.34376], [-121.32059, 38.34373], [-121.31587, 38.3413], [-121.31593, 38.33691], [-121.31584, 38.33662], [-121.33219, 38.33672], [-121.33217, 38.33698], [-121.33427, 38.34166], [-121.33351, 38.34218], [-121.33376, 38.3427], [-121.33414, 38.34327], [-121.33438, 38.34361]]]} | Restricted Access 2 | 21422 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 286.086 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
2735 | 2735 | 2734 | {"type": "Polygon", "coordinates": [[[-121.37929, 38.26206], [-121.37925, 38.26667], [-121.36993, 38.26662], [-121.36997, 38.26204], [-121.37929, 38.26206]]]} | Restricted Access 2 | 21423 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 102.78 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
2877 | 2877 | 2876 | {"type": "Polygon", "coordinates": [[[-121.2872, 38.42303], [-121.28685, 38.42315], [-121.28643, 38.42337], [-121.28619, 38.42353], [-121.2858, 38.42385], [-121.28542, 38.42359], [-121.28471, 38.42421], [-121.28261, 38.42406], [-121.28154, 38.42496], [-121.28143, 38.42489], [-121.28175, 38.42462], [-121.28187, 38.42447], [-121.28205, 38.42431], [-121.28253, 38.42403], [-121.28272, 38.42397], [-121.28303, 38.42393], [-121.28323, 38.42385], [-121.28393, 38.42367], [-121.28429, 38.4236], [-121.28452, 38.42349], [-121.28487, 38.42338], [-121.28505, 38.42325], [-121.28543, 38.42302], [-121.286, 38.42263], [-121.28628, 38.42252], [-121.28663, 38.42231], [-121.2872, 38.42303]]]} | Restricted Access 2 | 22244 | Preston Hanford | 23996 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.909 | Preston Hanford | None 241 | |||
3118 | 3118 | 3117 | {"type": "Polygon", "coordinates": [[[-121.45011, 38.40646], [-121.45004, 38.40688], [-121.4499, 38.40688], [-121.44976, 38.40685], [-121.44963, 38.40679], [-121.44953, 38.40671], [-121.44945, 38.40661], [-121.44942, 38.40654], [-121.44941, 38.40643], [-121.44944, 38.40612], [-121.44612, 38.40611], [-121.44612, 38.40534], [-121.44083, 38.40532], [-121.44083, 38.405], [-121.44983, 38.40499], [-121.44995, 38.40507], [-121.45002, 38.40514], [-121.4501, 38.40525], [-121.45014, 38.40538], [-121.45014, 38.40551], [-121.45, 38.40639], [-121.45004, 38.40645], [-121.45011, 38.40646]]]} | Restricted Access 2 | 21488 | Laguna Lake Drainage | 20858 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 15.913 | Laguna Lake Drainage | None 255 | |||
3224 | 3224 | 3223 | {"type": "Polygon", "coordinates": [[[-121.45044, 38.37471], [-121.44978, 38.3747], [-121.44966, 38.37342], [-121.45028, 38.37338], [-121.45044, 38.37471]]]} | Restricted Access 2 | 22246 | Hood-Franklin Drainage | 20071 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.025 | Hood-Franklin Drainage | None 266 | |||
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | 43001 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
11132 | 11132 | 11131 | {"type": "MultiPolygon", "coordinates": [[[[-121.09148, 38.49227], [-121.09125, 38.49243], [-121.09091, 38.49263], [-121.09073, 38.49271], [-121.09048, 38.49267], [-121.09013, 38.49268], [-121.0895, 38.49277], [-121.08916, 38.49278], [-121.08856, 38.49271], [-121.08839, 38.49288], [-121.08806, 38.49299], [-121.08776, 38.49324], [-121.08758, 38.49346], [-121.08736, 38.49369], [-121.08706, 38.49389], [-121.08684, 38.49411], [-121.08668, 38.49447], [-121.08635, 38.49468], [-121.08587, 38.4948], [-121.08548, 38.49497], [-121.08494, 38.49507], [-121.08444, 38.49513], [-121.08401, 38.49522], [-121.08368, 38.4954], [-121.08321, 38.49533], [-121.08263, 38.4952], [-121.08218, 38.49516], [-121.08186, 38.49517], [-121.08155, 38.49514], [-121.08119, 38.49514], [-121.08085, 38.49518], [-121.08048, 38.49518], [-121.07954, 38.49521], [-121.07918, 38.4953], [-121.07885, 38.49527], [-121.07803, 38.49512], [-121.07721, 38.49518], [-121.07672, 38.49507], [-121.07643, 38.49489], [-121.07601, 38.49485], [-121.07561, 38.49479], [-121.07506, 38.49468], [-121.0745, 38.49467], [-121.07387, 38.49457], [-121.07313, 38.4944], [-121.07188, 38.49433], [-121.07136, 38.49445], [-121.0709, 38.49468], [-121.07057, 38.49491], [-121.07008, 38.49571], [-121.06978, 38.49606], [-121.06879, 38.4965], [-121.0684, 38.49662], [-121.06787, 38.4969], [-121.06772, 38.49747], [-121.06745, 38.49789], [-121.06741, 38.4964], [-121.0678, 38.49625], [-121.06829, 38.49619], [-121.0692, 38.4956], [-121.06938, 38.49529], [-121.06934, 38.49511], [-121.06944, 38.49477], [-121.06956, 38.4945], [-121.07004, 38.4941], [-121.07124, 38.49356], [-121.07312, 38.49317], [-121.07514, 38.49348], [-121.07693, 38.49402], [-121.08244, 38.49408], [-121.08245, 38.49418], [-121.08279, 38.49418], [-121.08281, 38.49409], [-121.083, 38.49409], [-121.08466, 38.49399], [-121.08601, 38.4936], [-121.08706, 38.49299], [-121.08713, 38.49306], [-121.08756, 38.49279], [-121.08806, 38.49236], [-121.08926, 38.49218], [-121.0898, 38.49205], [-121.09063, 38.49184], [-121.09106, 38.49171], [-121.09128, 38.49189], [-121.09127, 38.49191], [-121.09133, 38.49195], [-121.09148, 38.49227]]], [[[-121.11462, 38.48233], [-121.11316, 38.48204], [-121.10939, 38.48209], [-121.10861, 38.48241], [-121.10763, 38.483], [-121.10532, 38.48394], [-121.10435, 38.48511], [-121.10083, 38.48719], [-121.10067, 38.48782], [-121.09651, 38.49026], [-121.09674, 38.49053], [-121.09379, 38.49339], [-121.09281, 38.49263], [-121.09319, 38.49205], [-121.09333, 38.49171], [-121.09343, 38.49155], [-121.09393, 38.48993], [-121.09485, 38.48922], [-121.09593, 38.48922], [-121.09595, 38.48641], [-121.09858, 38.48505], [-121.09983, 38.48505], [-121.09985, 38.48438], [-121.10456, 38.4818], [-121.11192, 38.48073], [-121.1122, 38.4807], [-121.1146, 38.48154], [-121.11462, 38.48233]]]]} | Restricted Access 2 | 21421 | Cosumnes River Parkway | 17677 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 188.683 | Cosumnes River Parkway | 0 | Local Recreation Area 3 | 4 | |
11133 | 11133 | 11132 | {"type": "Polygon", "coordinates": [[[-121.51691, 38.25947], [-121.50965, 38.26426], [-121.5083, 38.26215], [-121.50771, 38.26135], [-121.5073, 38.26083], [-121.50498, 38.25966], [-121.50269, 38.25821], [-121.5029, 38.25787], [-121.50312, 38.25794], [-121.50676, 38.25202], [-121.50862, 38.25131], [-121.50878, 38.25131], [-121.50893, 38.25149], [-121.50982, 38.25136], [-121.5103, 38.25196], [-121.51058, 38.25188], [-121.51111, 38.25283], [-121.51144, 38.25331], [-121.5121, 38.2541], [-121.51264, 38.25478], [-121.51317, 38.25533], [-121.51401, 38.25612], [-121.51486, 38.25683], [-121.51562, 38.2574], [-121.51648, 38.25796], [-121.51562, 38.25854], [-121.51691, 38.25947]]]} | Restricted Access 2 | 21424 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 229.043 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 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]);