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 UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
8644 | 8644 | 8643 | {"type": "Polygon", "coordinates": [[[-121.62329, 36.69175], [-121.62139, 36.69476], [-121.62267, 36.69557], [-121.62305, 36.69583], [-121.62239, 36.69593], [-121.62224, 36.69599], [-121.62208, 36.69612], [-121.62156, 36.69684], [-121.62114, 36.69815], [-121.61922, 36.69881], [-121.61535, 36.69667], [-121.61887, 36.69401], [-121.61838, 36.69346], [-121.61979, 36.69213], [-121.62135, 36.69028], [-121.623, 36.69156], [-121.62329, 36.69175]]]} | Restricted Access 2 | 1466 | Twin Creeks Golf Course | 32997 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 76.277 | Twin Creeks GC | 0 | Local Recreation Area 3 | 4 | |
15663 | 15663 | 15662 | {"type": "Polygon", "coordinates": [[[-118.40577, 33.76235], [-118.40543, 33.76277], [-118.40476, 33.76288], [-118.40115, 33.76183], [-118.40043, 33.76139], [-118.39873, 33.75821], [-118.39882, 33.75812], [-118.3989, 33.758], [-118.39899, 33.7578], [-118.39901, 33.75768], [-118.39901, 33.75754], [-118.39898, 33.75742], [-118.39888, 33.75722], [-118.39883, 33.75706], [-118.39879, 33.75691], [-118.39878, 33.75667], [-118.39884, 33.75634], [-118.39895, 33.75609], [-118.39942, 33.7554], [-118.39929, 33.75534], [-118.3988, 33.75604], [-118.39865, 33.75639], [-118.39861, 33.75662], [-118.39862, 33.7568], [-118.39833, 33.75685], [-118.3983, 33.75674], [-118.39837, 33.75604], [-118.39856, 33.7544], [-118.40003, 33.75192], [-118.39994, 33.75125], [-118.39987, 33.75101], [-118.39978, 33.75086], [-118.39962, 33.75068], [-118.39956, 33.75063], [-118.3993, 33.75049], [-118.39909, 33.75043], [-118.3989, 33.75041], [-118.39871, 33.75041], [-118.39843, 33.75047], [-118.3983, 33.75051], [-118.39609, 33.75167], [-118.3959, 33.75181], [-118.3958, 33.75191], [-118.39569, 33.75208], [-118.3957, 33.75216], [-118.3956, 33.75209], [-118.39539, 33.752], [-118.39546, 33.75197], [-118.39555, 33.75184], [-118.39507, 33.75161], [-118.39476, 33.7508], [-118.39504, 33.75018], [-118.39573, 33.74968], [-118.39552, 33.74935], [-118.39672, 33.74876], [-118.39875, 33.74843], [-118.39979, 33.74782], [-118.40117, 33.74652], [-118.40172, 33.74643], [-118.40231, 33.74691], [-118.40191, 33.74915], [-118.403, 33.75085], [-118.40334, 33.75309], [-118.404, 33.75374], [-118.40391, 33.75506], [-118.40227, 33.75588], [-118.40141, 33.75658], [-118.40141, 33.75804], [-118.40296, 33.76003], [-118.40533, 33.76169], [-118.40577, 33.76235]]]} | Restricted Access 2 | 5866 | Los Verdes Golf Course | 33003 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 162.838 | Los Verdes GC | 0 | Local Recreation Area 3 | 4 | |
15666 | 15666 | 15665 | {"type": "Polygon", "coordinates": [[[-118.31767, 33.91768], [-118.31766, 33.92154], [-118.31756, 33.92157], [-118.31241, 33.9237], [-118.3092, 33.9237], [-118.30923, 33.91674], [-118.30926, 33.91673], [-118.30926, 33.91662], [-118.30931, 33.91658], [-118.31432, 33.91659], [-118.31444, 33.91781], [-118.3146, 33.91784], [-118.31459, 33.91818], [-118.31461, 33.91853], [-118.31533, 33.91853], [-118.31681, 33.91768], [-118.31767, 33.91768]]]} | Restricted Access 2 | 6207 | Chester L Washington Golf Course | 33007 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 125.616 | Chester L Washington GC | 0 | Local Recreation Area 3 | 4 | |
2202 | 2202 | 2201 | {"type": "Polygon", "coordinates": [[[-118.27588, 33.85284], [-118.2733, 33.85587], [-118.27289, 33.855], [-118.27131, 33.85628], [-118.27096, 33.85622], [-118.27087, 33.85665], [-118.26832, 33.85666], [-118.26831, 33.85663], [-118.26621, 33.85662], [-118.26616, 33.85657], [-118.26515, 33.84858], [-118.26738, 33.84759], [-118.26891, 33.84731], [-118.26947, 33.84787], [-118.26991, 33.84825], [-118.26994, 33.84841], [-118.27012, 33.84858], [-118.2705, 33.84889], [-118.27057, 33.84885], [-118.2725, 33.85028], [-118.2731, 33.85068], [-118.27588, 33.85284]]]} | Restricted Access 2 | 6243 | Victoria Golf Course | 33008 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 167.229 | Victoria GC | 0 | Local Recreation Area 3 | 4 | |
7368 | 7368 | 7367 | {"type": "Polygon", "coordinates": [[[-118.05801, 33.90814], [-118.05748, 33.90772], [-118.0555, 33.90773], [-118.05549, 33.906], [-118.05799, 33.90598], [-118.05801, 33.90814]]]} | Restricted Access 2 | 6773 | Don Knabe Golf Center and Junior Academy | 32519 | 1225 | Norwalk, City of 239 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | https://www.playknabegolf.com/ | Los Angeles 6 | 11.277 | Don Knabe Golf Ctr. and Junior Academy | None 610 | ||
1070 | 1070 | 1069 | {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.12109, 34.18492], [-118.12098, 34.18506], [-118.12057, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18574], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18334], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11782, 34.18092], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18009], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.18319], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12162, 34.18407], [-118.12169, 34.18412]]]} | Restricted Access 2 | 6971 | Altadena Golf Course | 33022 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 57.739 | Altadena GC | 0 | Local Recreation Area 3 | 4 | |
7496 | 7496 | 7495 | {"type": "Polygon", "coordinates": [[[-118.04347, 34.13092], [-118.04339, 34.13133], [-118.0426, 34.13196], [-118.04287, 34.13232], [-118.04246, 34.13254], [-118.04197, 34.13285], [-118.0416, 34.13314], [-118.04112, 34.13356], [-118.04211, 34.13249], [-118.04222, 34.13228], [-118.04225, 34.13218], [-118.04224, 34.13217], [-118.04223, 34.13217], [-118.03927, 34.13536], [-118.03909, 34.13561], [-118.03898, 34.13586], [-118.0383, 34.1366], [-118.03775, 34.13635], [-118.03681, 34.13613], [-118.03624, 34.13619], [-118.03571, 34.13614], [-118.0349, 34.13614], [-118.03405, 34.13627], [-118.03343, 34.13635], [-118.03292, 34.13634], [-118.03259, 34.13625], [-118.03227, 34.13601], [-118.03198, 34.13576], [-118.03151, 34.13565], [-118.03143, 34.1309], [-118.03583, 34.13086], [-118.04244, 34.13075], [-118.04347, 34.13092]], [[-118.04259, 34.13197], [-118.04251, 34.13188], [-118.04241, 34.13199], [-118.04249, 34.13208], [-118.04259, 34.13197]]]} | Restricted Access 2 | 7018 | Santa Anita Golf Course | 33023 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 130.957 | Santa Anita GC | 0 | Local Recreation Area 3 | 4 | |
7995 | 7995 | 7994 | {"type": "MultiPolygon", "coordinates": [[[[-117.85104, 33.66409], [-117.85056, 33.66457], [-117.85039, 33.66479], [-117.84631, 33.66889], [-117.84585, 33.66943], [-117.84565, 33.66972], [-117.84503, 33.67081], [-117.84484, 33.67084], [-117.84412, 33.67062], [-117.84355, 33.67048], [-117.84327, 33.67042], [-117.84269, 33.67034], [-117.84197, 33.67028], [-117.84123, 33.67027], [-117.83645, 33.6705], [-117.83635, 33.66901], [-117.83652, 33.66899], [-117.83642, 33.66747], [-117.8364, 33.66689], [-117.83644, 33.66642], [-117.83657, 33.66573], [-117.83714, 33.666], [-117.83906, 33.66736], [-117.8446, 33.66183], [-117.8446, 33.66181], [-117.84162, 33.65973], [-117.84575, 33.65589], [-117.8462, 33.65622], [-117.84645, 33.65643], [-117.84675, 33.65673], [-117.84713, 33.65719], [-117.8473, 33.65742], [-117.84745, 33.65769], [-117.84757, 33.65796], [-117.84767, 33.65824], [-117.84851, 33.66087], [-117.84871, 33.66139], [-117.84903, 33.662], [-117.84935, 33.66247], [-117.84958, 33.66275], [-117.85011, 33.66327], [-117.85059, 33.66366], [-117.85104, 33.66398], [-117.85104, 33.66409]]], [[[-117.86095, 33.65401], [-117.86078, 33.6542], [-117.86051, 33.65429], [-117.86026, 33.65441], [-117.8598, 33.65467], [-117.85946, 33.65494], [-117.85934, 33.65506], [-117.85902, 33.65504], [-117.8585, 33.65477], [-117.85822, 33.65469], [-117.85779, 33.65464], [-117.85729, 33.65455], [-117.85688, 33.65444], [-117.85636, 33.65413], [-117.85617, 33.65399], [-117.8559, 33.65387], [-117.85583, 33.65381], [-117.85571, 33.65361], [-117.85295, 33.65099], [-117.85325, 33.65094], [-117.85983, 33.6509], [-117.85988, 33.65115], [-117.85998, 33.65155], [-117.86004, 33.6518], [-117.86013, 33.65205], [-117.86013, 33.6521], [-117.8601, 33.65216], [-117.86012, 33.65247], [-117.86022, 33.65247], [-117.86042, 33.6532], [-117.86058, 33.65354], [-117.86075, 33.65379], [-117.86095, 33.65401]]]]} | Restricted Access 2 | 11112 | San Joaquin Freshwater Marsh Reserve | 24910 | 2346 | Irvine Ranch Water District 884 | Special District 4 | Water District 13 | http://www.irwd.com/ | Special District 4 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 309.259 | San Joaquin Freshwater Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
6056 | 6056 | 6055 | {"type": "Polygon", "coordinates": [[[-118.65875, 34.07333], [-118.65821, 34.07334], [-118.6582, 34.07327], [-118.65765, 34.07327], [-118.65765, 34.07272], [-118.65786, 34.07272], [-118.65786, 34.0725], [-118.65875, 34.07256], [-118.65875, 34.07333]]]} | Restricted Access 2 | 12780 | Santa Monica Mountains National Recreation Area | 29657 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 2.045 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
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 | |
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 | |
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 | |
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 | |
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 | |
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]);