units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
126 rows where AGNCY_TYP = 3 and DES_TP = 3 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, MNG_AG_ID, MNG_AG_LEV, COUNTY, YR_EST
MNG_AGENCY 28
- Los Angeles, County of 25
- Santa Barbara, County of 18
- Los Angeles - Department of Parks and Recreation, County of 13
- Sacramento, County of 9
- San Diego, County of 7
- Santa Cruz, County of 5
- San Luis Obispo, County of 5
- Monterey, County of 5
- Orange, County of 5
- Riverside, County of 5
- Ventura, County of 4
- Fresno, County of 3
- Kern, County of 3
- Placer, County of 2
- San Joaquin, County of 2
- Stanislaus, County of 2
- Yolo, County of 2
- Valley-Wide Recreation and Park District 1
- Cerritos, City of 1
- Lake, County of 1
- Desert Recreation District 1
- Torrance, City of 1
- Long Beach, City of 1
- San Bernardino, County of 1
- Humboldt, County of 1
- Siskiyou, County of 1
- Amador, County of 1
- Sutter, County of 1
MNG_AG_TYP 4
ACCESS_TYP 4
DES_TP 1
- Local Recreation Area · 126 ✖
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 | |
15974 | 15974 | 15973 | {"type": "MultiPolygon", "coordinates": [[[[-119.81332, 34.45598], [-119.81288, 34.45617], [-119.81225, 34.45579], [-119.81214, 34.45568], [-119.81209, 34.45571], [-119.81199, 34.45548], [-119.81194, 34.45517], [-119.81158, 34.45496], [-119.81142, 34.45533], [-119.81138, 34.45536], [-119.81135, 34.45542], [-119.81137, 34.4555], [-119.81145, 34.45559], [-119.8115, 34.45578], [-119.81148, 34.45592], [-119.8114, 34.45609], [-119.81136, 34.45621], [-119.81136, 34.45643], [-119.81134, 34.45646], [-119.81119, 34.45654], [-119.81111, 34.45662], [-119.81093, 34.45692], [-119.81062, 34.45753], [-119.8103, 34.45739], [-119.81042, 34.4569], [-119.80997, 34.45714], [-119.80956, 34.45682], [-119.80933, 34.45651], [-119.80908, 34.4565], [-119.80894, 34.45612], [-119.80929, 34.45603], [-119.80957, 34.45575], [-119.80968, 34.4558], [-119.80969, 34.4561], [-119.81035, 34.4561], [-119.81047, 34.45579], [-119.81042, 34.45575], [-119.81048, 34.45568], [-119.8105, 34.45559], [-119.8105, 34.45431], [-119.81053, 34.45429], [-119.81115, 34.45429], [-119.81129, 34.45426], [-119.81139, 34.45421], [-119.81146, 34.45416], [-119.81153, 34.45407], [-119.81158, 34.45396], [-119.81159, 34.45408], [-119.81196, 34.45403], [-119.81204, 34.45397], [-119.81207, 34.45383], [-119.81229, 34.45385], [-119.81229, 34.45306], [-119.81384, 34.45306], [-119.81408, 34.45307], [-119.81411, 34.4531], [-119.81412, 34.45313], [-119.81401, 34.45326], [-119.81387, 34.45335], [-119.81367, 34.45343], [-119.81356, 34.45348], [-119.81346, 34.45357], [-119.81339, 34.45366], [-119.81331, 34.45385], [-119.81322, 34.45435], [-119.81289, 34.45432], [-119.81286, 34.45461], [-119.81251, 34.45474], [-119.81236, 34.45497], [-119.81251, 34.45525], [-119.81269, 34.45538], [-119.81294, 34.45543], [-119.81309, 34.45578], [-119.81332, 34.45598]]], [[[-119.81048, 34.45784], [-119.81042, 34.45797], [-119.81006, 34.45793], [-119.80996, 34.45812], [-119.80972, 34.45833], [-119.80961, 34.45878], [-119.80941, 34.45916], [-119.80963, 34.45934], [-119.80984, 34.45945], [-119.81, 34.4595], [-119.80999, 34.45955], [-119.80985, 34.45956], [-119.8098, 34.4595], [-119.80931, 34.45923], [-119.80912, 34.45888], [-119.80925, 34.4583], [-119.80955, 34.45781], [-119.81004, 34.45766], [-119.81042, 34.45785], [-119.81048, 34.45784]]], [[[-119.81501, 34.458], [-119.815, 34.45855], [-119.81493, 34.45851], [-119.81494, 34.45848], [-119.81485, 34.45842], [-119.81481, 34.45845], [-119.81458, 34.45833], [-119.81417, 34.45818], [-119.81412, 34.45791], [-119.81387, 34.45777], [-119.81367, 34.45716], [-119.81363, 34.45682], [-119.81339, 34.45641], [-119.8131, 34.45626], [-119.81363, 34.45603], [-119.81367, 34.45604], [-119.81376, 34.4562], [-119.81383, 34.45639], [-119.81407, 34.45734], [-119.81419, 34.45756], [-119.81434, 34.45772], [-119.81452, 34.45785], [-119.81478, 34.45796], [-119.81501, 34.458]]], [[[-119.8154, 34.45898], [-119.81531, 34.45912], [-119.81528, 34.45914], [-119.81495, 34.45882], [-119.81494, 34.45878], [-119.81462, 34.45852], [-119.8154, 34.45898]]]]} | Unknown Access 4 | 339 | San Jose Creek Open Space | 24915 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 23.422 | San Jose Creek OS | 0 | Local Recreation Area 3 | 4 | |
15963 | 15963 | 15962 | {"type": "MultiPolygon", "coordinates": [[[[-119.90372, 34.44055], [-119.90337, 34.44064], [-119.90304, 34.44075], [-119.90228, 34.44082], [-119.90212, 34.44081], [-119.9019, 34.44074], [-119.9018, 34.44071], [-119.90159, 34.44072], [-119.90141, 34.4408], [-119.90103, 34.44128], [-119.90044, 34.44129], [-119.90044, 34.44119], [-119.90054, 34.44119], [-119.90067, 34.44116], [-119.90084, 34.44107], [-119.90091, 34.441], [-119.90125, 34.44054], [-119.9014, 34.44043], [-119.90154, 34.44038], [-119.90164, 34.44037], [-119.90178, 34.44039], [-119.90217, 34.44055], [-119.90229, 34.44058], [-119.90243, 34.44059], [-119.90262, 34.44056], [-119.90312, 34.44039], [-119.90321, 34.44038], [-119.90344, 34.44039], [-119.90363, 34.44036], [-119.90367, 34.44038], [-119.90372, 34.44055]]], [[[-119.90635, 34.43896], [-119.90632, 34.43909], [-119.90622, 34.43924], [-119.90594, 34.43954], [-119.90539, 34.43967], [-119.90513, 34.43993], [-119.90497, 34.4404], [-119.90465, 34.44068], [-119.90455, 34.44101], [-119.90449, 34.44101], [-119.90448, 34.44078], [-119.90438, 34.44049], [-119.90389, 34.44046], [-119.90385, 34.44035], [-119.90389, 34.44031], [-119.90399, 34.44031], [-119.90417, 34.44034], [-119.90427, 34.44034], [-119.90442, 34.4403], [-119.90455, 34.44022], [-119.90469, 34.44007], [-119.90481, 34.43981], [-119.90508, 34.4395], [-119.90518, 34.43942], [-119.90535, 34.43934], [-119.90543, 34.43927], [-119.90548, 34.43918], [-119.90549, 34.43905], [-119.90547, 34.43895], [-119.90539, 34.43885], [-119.90549, 34.43857], [-119.90613, 34.43873], [-119.9063, 34.43887], [-119.90635, 34.43896]]]]} | Open Access 1 | 403 | San Miguel Open Space | 24956 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 5.809 | San Miguel OS | 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 | |
4991 | 4991 | 4990 | {"type": "Polygon", "coordinates": [[[-116.11014, 32.64478], [-116.108, 32.64477], [-116.10711, 32.64478], [-116.10763, 32.64374], [-116.10765, 32.64374], [-116.11013, 32.64378], [-116.11014, 32.64478]]]} | Open Access 1 | 793 | In-Ko-Pah County Open Space | 20184 | 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 | 7.223 | In-Ko-Pah County OS | 0 | Local Recreation Area 3 | 4 | |
414 | 414 | 413 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96794], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | 830 | Simpkins Swim Center | 25513 | 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 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
5504 | 5504 | 5503 | {"type": "Polygon", "coordinates": [[[-120.44562, 34.87516], [-120.4456, 34.87591], [-120.44401, 34.87591], [-120.44401, 34.87511], [-120.44418, 34.87512], [-120.44458, 34.87515], [-120.44562, 34.87516]]]} | Open Access 1 | 1135 | Stonebrook Open Space | 25882 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.08 | Stonebrook OS | 0 | Local Recreation Area 3 | 4 | |
15835 | 15835 | 15834 | {"type": "Polygon", "coordinates": [[[-119.84074, 34.4486], [-119.84062, 34.44862], [-119.84007, 34.44831], [-119.83956, 34.44809], [-119.83937, 34.44757], [-119.83959, 34.4473], [-119.83992, 34.44739], [-119.84009, 34.44716], [-119.84018, 34.44719], [-119.8403, 34.4472], [-119.84054, 34.44726], [-119.84032, 34.44792], [-119.84042, 34.44822], [-119.84063, 34.44831], [-119.84069, 34.44831], [-119.84074, 34.4486]]]} | Open Access 1 | 1150 | Stow Canyon Open Space | 25904 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.596 | Stow Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15989 | 15989 | 15988 | {"type": "Polygon", "coordinates": [[[-118.83946, 34.24946], [-118.83926, 34.24994], [-118.83054, 34.24995], [-118.83088, 34.24987], [-118.83099, 34.24983], [-118.83165, 34.24954], [-118.83188, 34.24941], [-118.83227, 34.24914], [-118.83247, 34.24897], [-118.83283, 34.2486], [-118.83303, 34.24836], [-118.83365, 34.24841], [-118.83379, 34.24837], [-118.8341, 34.24821], [-118.83431, 34.2482], [-118.83453, 34.24827], [-118.83468, 34.24841], [-118.83486, 34.2485], [-118.83509, 34.2485], [-118.83529, 34.24844], [-118.83542, 34.24832], [-118.8355, 34.24816], [-118.83555, 34.24796], [-118.83572, 34.24786], [-118.83589, 34.24769], [-118.83618, 34.24723], [-118.83626, 34.24705], [-118.83628, 34.24668], [-118.83712, 34.24662], [-118.8375, 34.24662], [-118.83776, 34.24651], [-118.83788, 34.24635], [-118.83782, 34.24616], [-118.83784, 34.24596], [-118.83779, 34.24578], [-118.83782, 34.24558], [-118.83776, 34.24524], [-118.83761, 34.24509], [-118.83736, 34.24506], [-118.83692, 34.2451], [-118.83666, 34.2451], [-118.8364, 34.24516], [-118.83566, 34.24518], [-118.83516, 34.24514], [-118.83475, 34.24506], [-118.83468, 34.24502], [-118.83489, 34.24478], [-118.83507, 34.24461], [-118.83547, 34.24429], [-118.83574, 34.24411], [-118.839, 34.24411], [-118.83906, 34.24414], [-118.83867, 34.24452], [-118.83864, 34.24469], [-118.83921, 34.24531], [-118.83912, 34.24685], [-118.83845, 34.24721], [-118.83863, 34.24856], [-118.83929, 34.24906], [-118.83946, 34.24946]]]} | Open Access 1 | 1216 | Sunset Hills - Olsen Road Open Space | 26047 | 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 | 54.712 | Sunset Hills - Olsen Road OS | 0 | Local Recreation Area 3 | 4 | |
6125 | 6125 | 6124 | {"type": "MultiPolygon", "coordinates": [[[[-121.9654, 36.95968], [-121.96527, 36.95978], [-121.96488, 36.96008], [-121.96489, 36.9599], [-121.96496, 36.95985], [-121.96516, 36.95981], [-121.96528, 36.95971], [-121.96532, 36.95963], [-121.96534, 36.95945], [-121.9654, 36.95935], [-121.9654, 36.95968]]], [[[-121.96554, 36.96051], [-121.96499, 36.96051], [-121.96499, 36.96023], [-121.96554, 36.9598], [-121.96554, 36.96051]]]]} | Open Access 1 | 1336 | The Hook Beach Access | 26285 | 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 | 0.827 | The Hook Beach Access | 0 | Local Recreation Area 3 | 4 | |
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 | |
6333 | 6333 | 6332 | {"type": "MultiPolygon", "coordinates": [[[[-119.81783, 34.44343], [-119.81777, 34.44362], [-119.81759, 34.44372], [-119.81675, 34.44373], [-119.81574, 34.44462], [-119.81576, 34.44491], [-119.81593, 34.4456], [-119.81594, 34.44587], [-119.81525, 34.44586], [-119.81511, 34.44584], [-119.81508, 34.44583], [-119.81506, 34.44578], [-119.81514, 34.44535], [-119.81518, 34.44473], [-119.8152, 34.44462], [-119.81527, 34.44446], [-119.81546, 34.44422], [-119.81556, 34.44403], [-119.81563, 34.4438], [-119.81568, 34.44357], [-119.81735, 34.44366], [-119.81742, 34.44341], [-119.81783, 34.44343]]], [[[-119.81606, 34.4464], [-119.81623, 34.44693], [-119.81622, 34.44703], [-119.81614, 34.44723], [-119.81604, 34.44766], [-119.81591, 34.4481], [-119.8159, 34.44838], [-119.816, 34.44868], [-119.81541, 34.44868], [-119.81543, 34.44863], [-119.81542, 34.44862], [-119.81444, 34.44862], [-119.81443, 34.44848], [-119.81445, 34.44835], [-119.81449, 34.44821], [-119.81456, 34.44809], [-119.81464, 34.44798], [-119.81475, 34.44789], [-119.815, 34.44774], [-119.8151, 34.44766], [-119.81521, 34.44752], [-119.81527, 34.44736], [-119.81529, 34.44719], [-119.81525, 34.44681], [-119.81518, 34.44658], [-119.81504, 34.44629], [-119.81501, 34.44616], [-119.81502, 34.44603], [-119.81506, 34.44601], [-119.81526, 34.44603], [-119.81573, 34.44602], [-119.81573, 34.4463], [-119.816, 34.44635], [-119.81606, 34.4464]]]]} | Open Access 1 | 1578 | University Circle Open Space | 26673 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 11.722 | University Circle OS | 0 | Local Recreation Area 3 | 4 | |
2864 | 2864 | 2863 | {"type": "Polygon", "coordinates": [[[-119.8955, 34.43359], [-119.89489, 34.4336], [-119.89507, 34.4334], [-119.89518, 34.43315], [-119.89502, 34.43276], [-119.89396, 34.43277], [-119.89349, 34.43308], [-119.89327, 34.43291], [-119.89312, 34.43283], [-119.89296, 34.43279], [-119.89279, 34.43277], [-119.89158, 34.43278], [-119.89147, 34.43278], [-119.89124, 34.43274], [-119.89246, 34.43273], [-119.89311, 34.43267], [-119.89548, 34.43263], [-119.8955, 34.43359]]]} | Open Access 1 | 1923 | Winchester I Open Space | 27618 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.191 | Winchester I OS | 0 | Local Recreation Area 3 | 4 | |
567 | 567 | 566 | {"type": "Polygon", "coordinates": [[[-116.28545, 33.64926], [-116.27605, 33.6493], [-116.27598, 33.64886], [-116.27585, 33.64695], [-116.27557, 33.64484], [-116.27553, 33.64464], [-116.2754, 33.64431], [-116.27531, 33.64417], [-116.27517, 33.64399], [-116.2749, 33.64373], [-116.27445, 33.64342], [-116.27439, 33.64335], [-116.27436, 33.64326], [-116.27435, 33.64317], [-116.27438, 33.64308], [-116.27467, 33.64262], [-116.27478, 33.64236], [-116.27486, 33.64209], [-116.27489, 33.64208], [-116.27489, 33.64181], [-116.27485, 33.64155], [-116.27478, 33.64134], [-116.27444, 33.6407], [-116.27435, 33.64045], [-116.2741, 33.63907], [-116.27415, 33.63896], [-116.27423, 33.6389], [-116.27463, 33.63883], [-116.27495, 33.63873], [-116.27516, 33.63865], [-116.2755, 33.63848], [-116.2757, 33.63841], [-116.27604, 33.63834], [-116.27679, 33.6383], [-116.27679, 33.63793], [-116.27606, 33.63794], [-116.27575, 33.63799], [-116.27547, 33.63807], [-116.27523, 33.63815], [-116.27487, 33.63832], [-116.27471, 33.63838], [-116.27451, 33.63844], [-116.27408, 33.63852], [-116.27397, 33.63856], [-116.27385, 33.63862], [-116.27376, 33.6387], [-116.27369, 33.6388], [-116.27365, 33.63888], [-116.27322, 33.63867], [-116.273, 33.63852], [-116.27277, 33.63831], [-116.27259, 33.63807], [-116.27246, 33.63778], [-116.27241, 33.63747], [-116.27242, 33.63233], [-116.27236, 33.63209], [-116.27227, 33.63189], [-116.27213, 33.6317], [-116.27194, 33.63152], [-116.27176, 33.6314], [-116.27151, 33.63128], [-116.27134, 33.63123], [-116.27114, 33.6312], [-116.26991, 33.63119], [-116.26969, 33.63117], [-116.26945, 33.63112], [-116.2691, 33.63099], [-116.26892, 33.63089], [-116.26877, 33.63079], [-116.26854, 33.63057], [-116.26836, 33.63031], [-116.26811, 33.63031], [-116.26811, 33.62777], [-116.26796, 33.62763], [-116.26793, 33.62282], [-116.26835, 33.62284], [-116.26846, 33.62308], [-116.26867, 33.62343], [-116.26903, 33.62371], [-116.26946, 33.62391], [-116.27001, 33.62436], [-116.27227, 33.62528], [-116.27348, 33.62589], [-116.27578, 33.62758], [-116.28097, 33.62756], [-116.28101, 33.63121], [-116.28107, 33.64207], [-116.28542, 33.64205], [-116.28545, 33.64926]]]} | Open Access 1 | 3338 | Lake Cahuilla Recreation Area | 9500 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/parks/lake-cahuilla/lake-cahuilla-recreation-area-home/ | Riverside 10 | 566.48 | Lake Cahuilla Rec. Area | 0 | Local Recreation Area 3 | 4 |
6566 | 6566 | 6565 | {"type": "Polygon", "coordinates": [[[-117.08361, 33.58364], [-117.0836, 33.58803], [-117.08006, 33.59822], [-117.08147, 33.59823], [-117.08148, 33.60003], [-117.08081, 33.60004], [-117.08089, 33.60146], [-117.08085, 33.60184], [-117.08358, 33.60186], [-117.08358, 33.60197], [-117.08081, 33.60196], [-117.08067, 33.60225], [-117.08053, 33.60245], [-117.07925, 33.60384], [-117.07965, 33.60551], [-117.07797, 33.60552], [-117.07755, 33.60378], [-117.07755, 33.60366], [-117.07759, 33.60346], [-117.0777, 33.60325], [-117.07777, 33.60316], [-117.07898, 33.60186], [-117.07898, 33.60185], [-117.06635, 33.60189], [-117.06628, 33.59819], [-117.05773, 33.59814], [-117.04902, 33.59818], [-117.04883, 33.61249], [-117.03161, 33.61285], [-117.01468, 33.61301], [-117.01468, 33.60891], [-117.01458, 33.60247], [-117.01446, 33.59845], [-117.01477, 33.58748], [-117.01474, 33.58014], [-117.01467, 33.57292], [-117.01468, 33.56634], [-117.01848, 33.56629], [-117.01848, 33.56572], [-117.03106, 33.56554], [-117.03111, 33.57278], [-117.04895, 33.5727], [-117.06647, 33.57272], [-117.07725, 33.5727], [-117.07727, 33.57634], [-117.08343, 33.57634], [-117.08347, 33.57664], [-117.08348, 33.57699], [-117.08345, 33.58362], [-117.08361, 33.58364]]]} | Open Access 1 | 3485 | Lake Skinner Recreation Area | 9501 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/parks/lake-skinner/lake-skinner-home/ | Riverside 10 | 6079.529 | Lake Skinner Rec. Area | 0 | Local Recreation Area 3 | 4 |
6543 | 6543 | 6542 | {"type": "MultiPolygon", "coordinates": [[[[-116.91618, 32.84986], [-116.9158, 32.84995], [-116.91515, 32.85059], [-116.91472, 32.8507], [-116.91484, 32.85107], [-116.91525, 32.85324], [-116.914, 32.85341], [-116.91334, 32.84972], [-116.91177, 32.85009], [-116.91176, 32.8484], [-116.91061, 32.84865], [-116.91064, 32.84184], [-116.91071, 32.84181], [-116.91116, 32.84154], [-116.91129, 32.84149], [-116.91356, 32.84095], [-116.91405, 32.84103], [-116.91448, 32.84114], [-116.91479, 32.84146], [-116.915, 32.84173], [-116.91513, 32.84194], [-116.91535, 32.84238], [-116.91387, 32.84275], [-116.91387, 32.8431], [-116.91389, 32.84327], [-116.91385, 32.84344], [-116.91387, 32.84357], [-116.91404, 32.84404], [-116.91344, 32.84419], [-116.91364, 32.84485], [-116.91326, 32.84494], [-116.91351, 32.84573], [-116.9139, 32.84565], [-116.91406, 32.84614], [-116.91209, 32.84661], [-116.91189, 32.84834], [-116.9119, 32.84835], [-116.91259, 32.8482], [-116.91322, 32.84866], [-116.91397, 32.84868], [-116.91489, 32.84935], [-116.91522, 32.84928], [-116.91542, 32.84981], [-116.91562, 32.84978], [-116.91611, 32.84965], [-116.91618, 32.84986]]], [[[-116.91703, 32.84504], [-116.91654, 32.84516], [-116.91648, 32.845], [-116.91697, 32.84488], [-116.91703, 32.84504]]], [[[-116.92242, 32.84101], [-116.92235, 32.84257], [-116.92092, 32.84275], [-116.92092, 32.84281], [-116.9208, 32.84282], [-116.92081, 32.84283], [-116.92096, 32.84286], [-116.91974, 32.84281], [-116.9197, 32.84288], [-116.91955, 32.84329], [-116.91951, 32.84385], [-116.91966, 32.84457], [-116.92002, 32.84461], [-116.92028, 32.84451], [-116.92094, 32.84452], [-116.92115, 32.84448], [-116.92125, 32.84507], [-116.92138, 32.84613], [-116.91821, 32.84687], [-116.91757, 32.84492], [-116.91719, 32.845], [-116.91704, 32.84458], [-116.91742, 32.84449], [-116.91717, 32.8437], [-116.91815, 32.84346], [-116.918, 32.84236], [-116.92076, 32.84171], [-116.92055, 32.84013], [-116.9205, 32.83964], [-116.92053, 32.83965], [-116.92219, 32.83949], [-116.92242, 32.84101]]]]} | Open Access 1 | 5015 | Lakeside Archipelago Open Space | 20975 | 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 | 122.828 | Lakeside Archipelago OS | 0 | Local Recreation Area 3 | 4 | |
6729 | 6729 | 6728 | {"type": "MultiPolygon", "coordinates": [[[[-119.77531, 34.45209], [-119.77531, 34.45312], [-119.7686, 34.454], [-119.76861, 34.45071], [-119.76859, 34.44934], [-119.77006, 34.44971], [-119.77438, 34.45153], [-119.77495, 34.45195], [-119.77531, 34.45209]], [[-119.76965, 34.45139], [-119.76974, 34.4514], [-119.76981, 34.45116], [-119.76932, 34.4508], [-119.76873, 34.45061], [-119.76873, 34.45135], [-119.76877, 34.45142], [-119.7692, 34.45152], [-119.76925, 34.45137], [-119.76929, 34.45138], [-119.7693, 34.45136], [-119.76933, 34.45136], [-119.76934, 34.45134], [-119.76959, 34.45138], [-119.76963, 34.4514], [-119.76965, 34.45139]]], [[[-119.77683, 34.45222], [-119.77667, 34.45302], [-119.77675, 34.45338], [-119.77595, 34.45341], [-119.7759, 34.45326], [-119.77589, 34.45311], [-119.77602, 34.45211], [-119.77683, 34.45222]]]]} | Unknown Access 4 | 5091 | Cathedral Oaks Fire Center | 16974 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 51.634 | Cathedral Oaks Fire Ctr. | 0 | Local Recreation Area 3 | 4 | |
6739 | 6739 | 6738 | {"type": "Polygon", "coordinates": [[[-116.1145, 32.65367], [-116.10581, 32.65366], [-116.10581, 32.64737], [-116.10624, 32.6465], [-116.11446, 32.64653], [-116.1145, 32.65367]]]} | Open Access 1 | 5151 | County Open Space | 29240 | 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 | 158.984 | County OS | 0 | Local Recreation Area 3 | 4 | |
6795 | 6795 | 6794 | {"type": "MultiPolygon", "coordinates": [[[[-117.23538, 33.37666], [-117.23537, 33.37797], [-117.23496, 33.37797], [-117.23496, 33.37696], [-117.23431, 33.37695], [-117.23431, 33.37662], [-117.2353, 33.37661], [-117.23535, 33.37663], [-117.23538, 33.37666]]], [[[-117.23748, 33.37662], [-117.23725, 33.37715], [-117.23745, 33.37724], [-117.23724, 33.37765], [-117.23639, 33.37765], [-117.23639, 33.37853], [-117.23556, 33.37853], [-117.23557, 33.37665], [-117.23562, 33.37661], [-117.23748, 33.37662]]]]} | Open Access 1 | 5294 | Fallbrook Park and Community Center | 18835 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/FallbrookCommunityCenter.html | San Diego 4 | 8.565 | Fallbrook Park and Community Ctr. | 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 |
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]);