units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,212 rows where GAP_STS = 4 and MNG_AG_LEV = 3 sorted by AGNCY_TYP
This data as json, copyable, CSV (advanced)
Suggested facets: LAYER
MNG_AGENCY >30
- Los Angeles, County of 138
- Santa Barbara, County of 100
- San Diego, County of 80
- Orange, County of 71
- Los Angeles - Department of Parks and Recreation, County of 59
- Lake, County of 55
- Butte, County of 53
- Kern, County of 45
- Santa Cruz, County of 42
- El Dorado, County of 42
- Santa Clara County Parks and Recreation Dept., County of 42
- Monterey, County of 41
- Sonoma County Regional Parks Dept., County of 38
- Riverside, County of 29
- Marin County Parks Department, County of 26
- San Luis Obispo, County of 25
- Ventura, County of 24
- Stanislaus, County of 24
- Placer, County of 22
- Sacramento, County of 22
- San Mateo County Parks and Recreation Dept., County of 21
- San Joaquin, County of 20
- San Bernardino, County of 18
- Merced, County of 15
- Yolo, County of 15
- Tulare, County of 14
- Fresno, County of 14
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 8
- Mono, County of 7
- …
DES_TP 4
ACCESS_TYP 4
- Open Access 1,131
- Restricted Access 45
- No Public Access 21
- Unknown Access 15
MNG_AG_TYP 3
- County Agency 1,003
- County Agency - Parks 192
- County Agency - Other 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7478 | 7478 | 7477 | {"type": "Polygon", "coordinates": [[[-117.95999, 34.10704], [-117.9599, 34.11834], [-117.95943, 34.11891], [-117.95858, 34.11969], [-117.95755, 34.12058], [-117.95639, 34.12138], [-117.95542, 34.12235], [-117.95497, 34.12298], [-117.95388, 34.12367], [-117.95313, 34.12443], [-117.95266, 34.1252], [-117.9525, 34.12614], [-117.95196, 34.12642], [-117.95133, 34.12694], [-117.95091, 34.12769], [-117.95066, 34.12822], [-117.95053, 34.12906], [-117.95015, 34.13], [-117.94872, 34.13114], [-117.94844, 34.13138], [-117.94805, 34.1319], [-117.94765, 34.13216], [-117.94567, 34.13364], [-117.94402, 34.13482], [-117.94341, 34.13538], [-117.94279, 34.13606], [-117.94249, 34.13642], [-117.93973, 34.13462], [-117.94295, 34.13132], [-117.94585, 34.12985], [-117.9469, 34.12888], [-117.94687, 34.12161], [-117.94251, 34.12163], [-117.94262, 34.118], [-117.93818, 34.11798], [-117.93817, 34.11927], [-117.93609, 34.11925], [-117.93609, 34.11897], [-117.93615, 34.11857], [-117.93688, 34.11521], [-117.93704, 34.11478], [-117.93726, 34.11441], [-117.94023, 34.11089], [-117.9404, 34.11063], [-117.94096, 34.11063], [-117.94293, 34.10827], [-117.94297, 34.1072], [-117.95999, 34.10704]]]} | Open Access 1 | 6999 | Santa Fe Dam Recreation Area | 32698 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/santa-fe-dam-recreational-area/ | Los Angeles 6 | 912.515 | Santa Fe Dam Rec. Area | 0 | Local Recreation Area 3 | 4 |
13224 | 13224 | 13223 | {"type": "MultiPolygon", "coordinates": [[[[-117.09269, 32.55829], [-117.09263, 32.56415], [-117.09055, 32.56414], [-117.09051, 32.56369], [-117.08947, 32.56369], [-117.08949, 32.56007], [-117.09055, 32.56006], [-117.09056, 32.55828], [-117.09269, 32.55829]]], [[[-117.10137, 32.56011], [-117.10133, 32.56544], [-117.09793, 32.56548], [-117.0971, 32.56548], [-117.09709, 32.56469], [-117.09388, 32.56469], [-117.09387, 32.56424], [-117.09282, 32.56424], [-117.09285, 32.55829], [-117.09377, 32.55829], [-117.09567, 32.559], [-117.09568, 32.55829], [-117.09604, 32.55829], [-117.09604, 32.55914], [-117.09819, 32.55915], [-117.09819, 32.55956], [-117.09926, 32.55957], [-117.09926, 32.56009], [-117.10137, 32.56011]]]]} | Open Access 1 | 45246 | Tijuana River Valley Regional Park | 13879 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 169.576 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
14458 | 14458 | 14457 | {"type": "Polygon", "coordinates": [[[-122.52636, 39.31903], [-122.52637, 39.31943], [-122.5251, 39.32296], [-122.52302, 39.32853], [-122.52303, 39.32854], [-122.52363, 39.32846], [-122.52301, 39.33189], [-122.5221, 39.33213], [-122.52146, 39.33351], [-122.52147, 39.33352], [-122.52615, 39.33354], [-122.52618, 39.34106], [-122.52153, 39.34078], [-122.52151, 39.34079], [-122.52166, 39.34795], [-122.52124, 39.35165], [-122.52558, 39.35156], [-122.52505, 39.35517], [-122.51546, 39.35536], [-122.51509, 39.35543], [-122.51507, 39.35551], [-122.51507, 39.35552], [-122.52086, 39.35545], [-122.52011, 39.35957], [-122.51765, 39.35917], [-122.51725, 39.36293], [-122.51262, 39.36292], [-122.51273, 39.36466], [-122.51209, 39.36462], [-122.51208, 39.36463], [-122.51212, 39.36627], [-122.51216, 39.37706], [-122.50724, 39.37681], [-122.49639, 39.37713], [-122.49613, 39.37347], [-122.49333, 39.37343], [-122.49328, 39.36618], [-122.48982, 39.36607], [-122.48974, 39.36264], [-122.4979, 39.36258], [-122.49749, 39.35637], [-122.49597, 39.3563], [-122.49588, 39.35551], [-122.48838, 39.35532], [-122.48843, 39.34826], [-122.48842, 39.33347], [-122.48846, 39.33111], [-122.48844, 39.33083], [-122.48853, 39.31922], [-122.48858, 39.30481], [-122.48873, 39.30475], [-122.4932, 39.30468], [-122.49319, 39.30527], [-122.49324, 39.30836], [-122.49341, 39.31258], [-122.4934, 39.31363], [-122.4944, 39.31557], [-122.49816, 39.31564], [-122.49811, 39.3192], [-122.50313, 39.31914], [-122.52636, 39.31903]]]} | Open Access 1 | 47088 | East Park Reservoir | 30742 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 358 | Colusa, County of 1068 | County 3 | County Agency 3 | Colusa 49 | 4263.017 | East Park Reservoir | 0 | Local Recreation Area 3 | 4 | |
16314 | 16314 | 16313 | {"type": "Polygon", "coordinates": [[[-117.28945, 34.33654], [-117.28507, 34.33656], [-117.2851, 34.34012], [-117.27636, 34.34019], [-117.27198, 34.34026], [-117.27199, 34.34382], [-117.25304, 34.3441], [-117.25384, 34.3436], [-117.25441, 34.34318], [-117.25912, 34.33904], [-117.25935, 34.33878], [-117.25943, 34.33867], [-117.25952, 34.33849], [-117.25956, 34.33836], [-117.2596, 34.33818], [-117.25962, 34.33797], [-117.25959, 34.33685], [-117.25828, 34.33686], [-117.25829, 34.33802], [-117.25825, 34.33816], [-117.25815, 34.33829], [-117.25357, 34.34232], [-117.25315, 34.34265], [-117.25283, 34.34287], [-117.25183, 34.34348], [-117.25163, 34.34326], [-117.2487, 34.34503], [-117.249, 34.34536], [-117.24879, 34.3455], [-117.24854, 34.34569], [-117.24823, 34.34599], [-117.24794, 34.34636], [-117.24771, 34.34677], [-117.2476, 34.34703], [-117.24752, 34.3473], [-117.24746, 34.34758], [-117.24744, 34.3478], [-117.24748, 34.35136], [-117.24585, 34.3514], [-117.24591, 34.36404], [-117.24152, 34.36413], [-117.24147, 34.35697], [-117.23941, 34.3571], [-117.23945, 34.35004], [-117.23311, 34.3505], [-117.23296, 34.34672], [-117.23284, 34.34305], [-117.23714, 34.34288], [-117.24164, 34.34291], [-117.24167, 34.34027], [-117.24586, 34.34043], [-117.24591, 34.33855], [-117.24381, 34.33848], [-117.24389, 34.33473], [-117.24494, 34.33477], [-117.24492, 34.33554], [-117.24545, 34.33556], [-117.24543, 34.33665], [-117.24594, 34.33667], [-117.24597, 34.33557], [-117.2465, 34.33558], [-117.24652, 34.33481], [-117.24678, 34.33481], [-117.2468, 34.33388], [-117.24785, 34.33391], [-117.24787, 34.33297], [-117.25023, 34.33303], [-117.25028, 34.33119], [-117.2524, 34.33125], [-117.25242, 34.33033], [-117.25352, 34.32761], [-117.25879, 34.32779], [-117.25929, 34.32596], [-117.26315, 34.32593], [-117.26316, 34.32609], [-117.26641, 34.32606], [-117.26642, 34.3268], [-117.26749, 34.3268], [-117.2675, 34.32588], [-117.2762, 34.32579], [-117.27627, 34.33308], [-117.28942, 34.33296], [-117.28945, 34.33654]]]} | Open Access 1 | 3195 | Mojave River Forks Regional Park | 13576 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Parks/MojaveRiverForksRegionalPark.aspx | San Bernardino 22 | 1866.795 | Mojave River Forks RP | 0 | Local Park 2 | 4 |
16340 | 16340 | 16339 | {"type": "MultiPolygon", "coordinates": [[[[-117.6664, 33.93913], [-117.66482, 33.93912], [-117.66308, 33.93745], [-117.66057, 33.93495], [-117.65676, 33.93497], [-117.65664, 33.93484], [-117.6577, 33.93194], [-117.66023, 33.93195], [-117.66035, 33.93204], [-117.6604, 33.9323], [-117.66086, 33.93285], [-117.66136, 33.9333], [-117.66165, 33.9335], [-117.66216, 33.9341], [-117.66247, 33.93525], [-117.66309, 33.93548], [-117.66308, 33.93716], [-117.66469, 33.93718], [-117.66521, 33.93789], [-117.6654, 33.93813], [-117.6664, 33.93913]]], [[[-117.67181, 33.94502], [-117.6718, 33.94627], [-117.66839, 33.94626], [-117.66809, 33.9459], [-117.66689, 33.94268], [-117.6699, 33.9427], [-117.6701, 33.94292], [-117.67034, 33.94332], [-117.67067, 33.94358], [-117.67105, 33.94403], [-117.67129, 33.94439], [-117.67164, 33.94476], [-117.67181, 33.94502]]], [[[-117.65508, 33.93913], [-117.6565, 33.93524], [-117.65671, 33.93511], [-117.6605, 33.93509], [-117.66307, 33.9377], [-117.66454, 33.93911], [-117.66306, 33.93911], [-117.66304, 33.94185], [-117.66612, 33.94145], [-117.66618, 33.94161], [-117.66629, 33.94159], [-117.66731, 33.9444], [-117.66789, 33.94593], [-117.66815, 33.94626], [-117.66817, 33.94626], [-117.66969, 33.94802], [-117.66298, 33.94983], [-117.66297, 33.94656], [-117.66296, 33.94655], [-117.66278, 33.94988], [-117.65744, 33.95133], [-117.65748, 33.94787], [-117.65784, 33.94786], [-117.65805, 33.94622], [-117.65484, 33.9462], [-117.65476, 33.94966], [-117.65125, 33.94963], [-117.65135, 33.94931], [-117.65256, 33.9462], [-117.65255, 33.94619], [-117.6525, 33.94619], [-117.65492, 33.93955], [-117.65506, 33.93917], [-117.65508, 33.93913]]], [[[-117.66683, 33.95388], [-117.66257, 33.9539], [-117.66256, 33.95392], [-117.6582, 33.95395], [-117.65817, 33.9513], [-117.66189, 33.9503], [-117.66251, 33.95029], [-117.66252, 33.95027], [-117.66449, 33.95027], [-117.66682, 33.95291], [-117.66683, 33.95388]]], [[[-117.65679, 33.93193], [-117.65572, 33.93485], [-117.65552, 33.93498], [-117.65555, 33.93512], [-117.65566, 33.93525], [-117.65168, 33.94617], [-117.65173, 33.94618], [-117.6506, 33.94911], [-117.65067, 33.94914], [-117.65051, 33.94963], [-117.64604, 33.94961], [-117.64604, 33.9513], [-117.64559, 33.95145], [-117.6435, 33.95068], [-117.64283, 33.95091], [-117.64222, 33.95125], [-117.64114, 33.95147], [-117.64077, 33.9521], [-117.64039, 33.95259], [-117.63979, 33.95316], [-117.63913, 33.95348], [-117.63889, 33.95415], [-117.6385, 33.95449], [-117.63798, 33.95399], [-117.63766, 33.95352], [-117.63758, 33.95322], [-117.63777, 33.95293], [-117.63801, 33.95268], [-117.6383, 33.95213], [-117.63866, 33.95181], [-117.63951, 33.95063], [-117.63974, 33.94992], [-117.63992, 33.94958], [-117.64063, 33.94878], [-117.64073, 33.9482], [-117.64103, 33.94736], [-117.64145, 33.94713], [-117.64176, 33.94705], [-117.64201, 33.94684], [-117.64228, 33.94647], [-117.64231, 33.94569], [-117.64196, 33.9452], [-117.64161, 33.94489], [-117.64129, 33.94479], [-117.64377, 33.94336], [-117.64599, 33.94346], [-117.64599, 33.94021], [-117.63971, 33.94], [-117.63971, 33.93961], [-117.63331, 33.93958], [-117.63346, 33.93118], [-117.6288, 33.93123], [-117.62881, 33.93135], [-117.6333, 33.93132], [-117.63323, 33.93536], [-117.62098, 33.93536], [-117.62167, 33.93416], [-117.62208, 33.93371], [-117.62262, 33.93338], [-117.62293, 33.93327], [-117.62418, 33.93238], [-117.62463, 33.93132], [-117.62461, 33.93099], [-117.62434, 33.9307], [-117.62401, 33.93047], [-117.62325, 33.9302], [-117.62253, 33.92987], [-117.62228, 33.92966], [-117.62527, 33.92659], [-117.63215, 33.92645], [-117.63212, 33.9245], [-117.65515, 33.92486], [-117.65531, 33.92521], [-117.65519, 33.93015], [-117.65517, 33.93191], [-117.65679, 33.93193]]], [[[-117.67131, 33.9593], [-117.66704, 33.95933], [-117.66699, 33.95388], [-117.66767, 33.95388], [-117.6713, 33.958], [-117.67131, 33.9593]]], [[[-117.67941, 33.96241], [-117.67861, 33.96236], [-117.67863, 33.96284], [-117.6784, 33.96334], [-117.67836, 33.96367], [-117.67802, 33.96419], [-117.67797, 33.96433], [-117.67746, 33.96463], [-117.6771, 33.96421], [-117.67701, 33.96404], [-117.67727, 33.96348], [-117.6771, 33.96252], [-117.6768, 33.96222], [-117.67631, 33.96189], [-117.67616, 33.96142], [-117.67561, 33.96106], [-117.67544, 33.9611], [-117.67517, 33.96132], [-117.67466, 33.96083], [-117.67411, 33.96075], [-117.67412, 33.96046], [-117.67392, 33.96015], [-117.67333, 33.96003], [-117.66421, 33.94967], [-117.66985, 33.94815], [-117.67702, 33.95364], [-117.67327, 33.95592], [-117.67354, 33.95699], [-117.67429, 33.95766], [-117.6739, 33.95841], [-117.67438, 33.95864], [-117.67462, 33.95873], [-117.67481, 33.95998], [-117.67531, 33.9602], [-117.67571, 33.96078], [-117.67644, 33.96096], [-117.67698, 33.96152], [-117.67797, 33.96158], [-117.67941, 33.96241]]]]} | Open Access 1 | 8883 | Prado Regional Park | 13583 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Parks/PradoRegionalPark.aspx | San Bernardino 22 | 2110.592 | Prado RP | 0 | Local Park 2 | 4 |
16794 | 16794 | 16793 | {"type": "MultiPolygon", "coordinates": [[[[-119.97088, 34.57189], [-119.97081, 34.57555], [-119.96345, 34.57212], [-119.96131, 34.57212], [-119.95957, 34.57273], [-119.95752, 34.57276], [-119.95604, 34.57194], [-119.95586, 34.57186], [-119.95497, 34.571], [-119.95426, 34.57048], [-119.95351, 34.56824], [-119.9528, 34.56792], [-119.95129, 34.5676], [-119.94677, 34.56768], [-119.94599, 34.56766], [-119.94512, 34.56768], [-119.94432, 34.5676], [-119.94367, 34.56748], [-119.94283, 34.5672], [-119.94202, 34.56686], [-119.94125, 34.56645], [-119.94051, 34.56597], [-119.93941, 34.56546], [-119.93902, 34.56479], [-119.937, 34.5638], [-119.93474, 34.56292], [-119.93242, 34.56224], [-119.93187, 34.56236], [-119.92686, 34.56093], [-119.92652, 34.56061], [-119.92132, 34.56097], [-119.9182, 34.55879], [-119.91682, 34.55878], [-119.91612, 34.55828], [-119.91406, 34.55809], [-119.91253, 34.55737], [-119.91134, 34.55487], [-119.91163, 34.55481], [-119.91162, 34.55397], [-119.91133, 34.55395], [-119.91108, 34.55267], [-119.91031, 34.55148], [-119.9185, 34.55565], [-119.92625, 34.5595], [-119.92637, 34.55904], [-119.92651, 34.5586], [-119.9267, 34.55816], [-119.92692, 34.55774], [-119.92718, 34.55735], [-119.92747, 34.55698], [-119.92779, 34.55663], [-119.92946, 34.55451], [-119.96358, 34.56898], [-119.97088, 34.57189]]], [[[-119.99132, 34.59119], [-119.98816, 34.59127], [-119.98659, 34.59205], [-119.98333, 34.59359], [-119.98332, 34.59811], [-119.97942, 34.59803], [-119.97811, 34.60042], [-119.97742, 34.60031], [-119.97691, 34.60042], [-119.97542, 34.60026], [-119.96854, 34.59772], [-119.96456, 34.6004], [-119.95458, 34.60706], [-119.95415, 34.60664], [-119.9519, 34.60453], [-119.95046, 34.60182], [-119.94671, 34.6002], [-119.94116, 34.60658], [-119.93649, 34.60979], [-119.93093, 34.60736], [-119.93417, 34.59869], [-119.9275, 34.59674], [-119.92304, 34.59788], [-119.9188, 34.59933], [-119.91526, 34.60181], [-119.90414, 34.59401], [-119.89889, 34.59025], [-119.89809, 34.58208], [-119.89816, 34.57735], [-119.87591, 34.5662], [-119.86647, 34.54994], [-119.86598, 34.54924], [-119.86526, 34.54889], [-119.86486, 34.54848], [-119.8648, 34.54784], [-119.86433, 34.54732], [-119.86412, 34.54695], [-119.86403, 34.5467], [-119.864, 34.54637], [-119.86427, 34.54579], [-119.86446, 34.54632], [-119.86443, 34.54657], [-119.86507, 34.54753], [-119.86558, 34.54856], [-119.8662, 34.54868], [-119.86746, 34.54549], [-119.87126, 34.54659], [-119.87386, 34.54855], [-119.87472, 34.54891], [-119.87501, 34.54896], [-119.8777, 34.55085], [-119.87901, 34.55108], [-119.8824, 34.5523], [-119.8827, 34.55351], [-119.8848, 34.55303], [-119.8848, 34.55301], [-119.88461, 34.55295], [-119.88446, 34.55287], [-119.88428, 34.55271], [-119.88415, 34.55251], [-119.88409, 34.55236], [-119.88406, 34.5522], [-119.88456, 34.5523], [-119.88556, 34.55215], [-119.88657, 34.54923], [-119.88742, 34.54922], [-119.88963, 34.54808], [-119.89002, 34.54726], [-119.89033, 34.54738], [-119.89185, 34.54716], [-119.89297, 34.54714], [-119.89334, 34.54711], [-119.89472, 34.54741], [-119.89547, 34.54734], [-119.89716, 34.54781], [-119.90053, 34.54832], [-119.89991, 34.54854], [-119.89991, 34.54971], [-119.90159, 34.55183], [-119.90243, 34.55396], [-119.90261, 34.5542], [-119.90322, 34.55452], [-119.90338, 34.55508], [-119.90311, 34.55533], [-119.90227, 34.55555], [-119.90186, 34.55611], [-119.90228, 34.55686], [-119.90294, 34.55702], [-119.90321, 34.55673], [-119.90351, 34.55661], [-119.90601, 34.5578], [-119.90873, 34.55683], [-119.9093, 34.55482], [-119.90979, 34.55299], [-119.9105, 34.55477], [-119.91025, 34.55527], [-119.91082, 34.55585], [-119.91139, 34.55834], [-119.92188, 34.56233], [-119.92257, 34.56229], [-119.92343, 34.56247], [-119.92424, 34.56208], [-119.92568, 34.56212], [-119.92645, 34.56259], [-119.92947, 34.56293], [-119.92941, 34.56307], [-119.93108, 34.56332], [-119.93221, 34.56398], [-119.93378, 34.56418], [-119.93761, 34.56551], [-119.93834, 34.5658], [-119.93881, 34.56634], [-119.93923, 34.56655], [-119.9397, 34.56654], [-119.94062, 34.56691], [-119.94138, 34.56736], [-119.94217, 34.56774], [-119.94299, 34.56806], [-119.94384, 34.56829], [-119.9447, 34.56846], [-119.94557, 34.56855], [-119.94645, 34.56856], [-119.95193, 34.56815], [-119.95271, 34.56913], [-119.95326, 34.57125], [-119.95552, 34.57279], [-119.95769, 34.57362], [-119.96073, 34.57329], [-119.96299, 34.57264], [-119.96638, 34.57395], [-119.96885, 34.57511], [-119.97082, 34.57592], [-119.97291, 34.57654], [-119.97328, 34.57693], [-119.9736, 34.57701], [-119.97388, 34.57674], [-119.97546, 34.57717], [-119.97541, 34.57729], [-119.97542, 34.57731], [-119.97587, 34.57743], [-119.97593, 34.5773], [-119.98107, 34.5787], [-119.98202, 34.58108], [-119.98497, 34.58333], [-119.9867, 34.5857], [-119.98673, 34.58669], [-119.98993, 34.58837], [-119.99126, 34.58835], [-119.99132, 34.59119]], [[-119.96003, 34.57872], [-119.96001, 34.57871], [-119.95999, 34.57874], [-119.96001, 34.57874], [-119.96003, 34.57872]], [[-119.9602, 34.57863], [-119.96019, 34.57861], [-119.96011, 34.57862], [-119.96009, 34.57865], [-119.9602, 34.57863]]]]} | Open Access 1 | 1340 | Cachuma Lake Recreation Area | 13798 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 9563.006 | Cachuma Lake Rec. Area | 0 | Local Recreation Area 3 | 4 | |
3724 | 3724 | 3723 | {"type": "Polygon", "coordinates": [[[-118.20363, 36.80669], [-118.20289, 36.807], [-118.20237, 36.80627], [-118.20224, 36.80618], [-118.20303, 36.80585], [-118.20363, 36.80669]]]} | Open Access 1 | 44705 | Dehy Park | 18020 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 360 | Inyo, County of 662 | County 3 | County Agency 3 | Inyo 43 | 1.985 | Dehy Park | 0 | Local Park 2 | 4 | |
3971 | 3971 | 3970 | {"type": "Polygon", "coordinates": [[[-121.68844, 36.99391], [-121.68834, 36.99433], [-121.68829, 36.99445], [-121.6881, 36.99477], [-121.68806, 36.99491], [-121.68805, 36.99504], [-121.68808, 36.99518], [-121.68824, 36.99549], [-121.68824, 36.99564], [-121.68821, 36.99576], [-121.68799, 36.99607], [-121.68785, 36.99624], [-121.68778, 36.99632], [-121.68747, 36.99652], [-121.68723, 36.99676], [-121.68792, 36.99542], [-121.68787, 36.99477], [-121.68815, 36.99388], [-121.68844, 36.99391]]]} | Open Access 1 | 38002 | Mount Madonna County Park | 29287 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/MtMadonna.aspx | Santa Clara 19 | 1.998 | Mount Madonna County Park | 0 | Local Park 2 | 4 |
4433 | 4433 | 4432 | {"type": "MultiPolygon", "coordinates": [[[[-118.2896, 34.44511], [-118.28959, 34.44876], [-118.2854, 34.44869], [-118.28535, 34.44505], [-118.2896, 34.44511]]], [[[-118.29626, 34.44876], [-118.29406, 34.44876], [-118.29404, 34.44571], [-118.29402, 34.44509], [-118.29623, 34.44508], [-118.29626, 34.44876]]], [[[-118.32311, 34.4672], [-118.32304, 34.46725], [-118.32117, 34.46822], [-118.32115, 34.46719], [-118.32311, 34.4672]]]]} | Open Access 1 | 46400 | Agua Dulce Canyon Parkland | 29553 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 61.59 | Agua Dulce Canyon Parkland | 0 | Local Park 2 | 4 | |
5626 | 5626 | 5625 | {"type": "Polygon", "coordinates": [[[-118.41054, 34.22709], [-118.4103, 34.22778], [-118.40776, 34.22897], [-118.40741, 34.22916], [-118.40705, 34.2294], [-118.407, 34.22941], [-118.40696, 34.22939], [-118.404, 34.22662], [-118.40712, 34.22434], [-118.40755, 34.22467], [-118.40844, 34.22521], [-118.40886, 34.2255], [-118.41022, 34.22678], [-118.41054, 34.22709]]]} | Open Access 1 | 45413 | Sheldon-Arleta Park | 28186 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.laparks.org/dos/parks/facility/devonshireArletaPk.htm | Los Angeles 6 | 45.127 | Sheldon-Arleta Park | 2016 | Local Park 2 | 4 |
7296 | 7296 | 7295 | {"type": "MultiPolygon", "coordinates": [[[[-118.09001, 33.80323], [-118.08973, 33.80323], [-118.08972, 33.80318], [-118.08943, 33.79703], [-118.0896, 33.79703], [-118.08976, 33.79762], [-118.09001, 33.80323]]], [[[-118.09035, 33.80941], [-118.09002, 33.8094], [-118.08982, 33.80517], [-118.09014, 33.80517], [-118.09035, 33.80941]]], [[[-118.09387, 33.78866], [-118.09152, 33.79346], [-118.09152, 33.79349], [-118.09142, 33.79369], [-118.09128, 33.7941], [-118.09112, 33.79469], [-118.09104, 33.7952], [-118.09101, 33.79591], [-118.0914, 33.80399], [-118.09119, 33.80398], [-118.09108, 33.80402], [-118.09108, 33.80406], [-118.09077, 33.80406], [-118.09035, 33.79591], [-118.09068, 33.7959], [-118.09069, 33.79548], [-118.09072, 33.79515], [-118.09082, 33.79456], [-118.0909, 33.79422], [-118.091, 33.79389], [-118.09124, 33.79331], [-118.09351, 33.78865], [-118.09387, 33.78866]]], [[[-118.09172, 33.81023], [-118.09119, 33.81024], [-118.09091, 33.80678], [-118.09078, 33.80436], [-118.09109, 33.80437], [-118.0911, 33.8044], [-118.09119, 33.80445], [-118.09143, 33.80444], [-118.09172, 33.81023]]]]} | Open Access 1 | 6580 | San Gabriel River Trail | 29917 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 36.911 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
9945 | 9945 | 9944 | {"type": "Polygon", "coordinates": [[[-117.75367, 33.87309], [-117.7534, 33.8731], [-117.75323, 33.87313], [-117.75305, 33.87321], [-117.75276, 33.87329], [-117.75249, 33.8734], [-117.7522, 33.87353], [-117.75193, 33.87367], [-117.75157, 33.87392], [-117.75115, 33.87428], [-117.75095, 33.87452], [-117.7508, 33.87474], [-117.7507, 33.87478], [-117.74982, 33.87457], [-117.75063, 33.8741], [-117.75188, 33.87343], [-117.75274, 33.87301], [-117.75361, 33.87262], [-117.75367, 33.87309]]]} | Open Access 1 | 47963 | Yorba Regional Park | 27778 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 3.53 | Yorba RP | 0 | Local Park 2 | 4 |
11924 | 11924 | 11923 | {"type": "Polygon", "coordinates": [[[-118.50387, 34.02695], [-118.50386, 34.02706], [-118.5038, 34.02717], [-118.50371, 34.02726], [-118.5036, 34.02732], [-118.50347, 34.02736], [-118.50337, 34.02737], [-118.50327, 34.02733], [-118.50321, 34.02727], [-118.50319, 34.02722], [-118.5032, 34.02716], [-118.50325, 34.02704], [-118.50335, 34.02693], [-118.50346, 34.02686], [-118.50361, 34.02682], [-118.50373, 34.02681], [-118.50382, 34.02686], [-118.50387, 34.02695]]]} | Open Access 1 | 24529 | Goose Egg Park | 19406 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.674 | Goose Egg Park | 0 | Local Park 2 | 4 | |
11927 | 11927 | 11926 | {"type": "Polygon", "coordinates": [[[-118.3351, 33.89621], [-118.33509, 33.89639], [-118.33509, 33.89752], [-118.33391, 33.89739], [-118.33393, 33.89724], [-118.33319, 33.89717], [-118.33315, 33.89718], [-118.33305, 33.89734], [-118.33158, 33.89734], [-118.33197, 33.89699], [-118.33221, 33.89672], [-118.33335, 33.89514], [-118.33409, 33.89545], [-118.33411, 33.89592], [-118.33482, 33.89592], [-118.33483, 33.8962], [-118.3351, 33.89621]]]} | Open Access 1 | 24532 | Bodger Park | 16222 | 1130 | Hawthorne, City of 299 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 11.866 | Bodger Park | 0 | Local Park 2 | 4 | |
14043 | 14043 | 14042 | {"type": "Polygon", "coordinates": [[[-122.52894, 37.92555], [-122.5287, 37.92554], [-122.52852, 37.9251], [-122.52838, 37.92462], [-122.52834, 37.92435], [-122.52836, 37.92395], [-122.52835, 37.92375], [-122.52841, 37.9233], [-122.52841, 37.92304], [-122.52834, 37.9227], [-122.52806, 37.92203], [-122.52792, 37.92202], [-122.52785, 37.92191], [-122.52791, 37.92188], [-122.52742, 37.92065], [-122.52722, 37.92036], [-122.52676, 37.91948], [-122.52677, 37.91915], [-122.52681, 37.91931], [-122.52704, 37.91928], [-122.52728, 37.91946], [-122.52764, 37.92033], [-122.52817, 37.92153], [-122.5281, 37.92157], [-122.52821, 37.92186], [-122.52833, 37.92208], [-122.52845, 37.92237], [-122.52851, 37.92255], [-122.52861, 37.92306], [-122.52855, 37.92425], [-122.5286, 37.92467], [-122.52873, 37.92511], [-122.52882, 37.92534], [-122.52894, 37.92555]]]} | Open Access 1 | 38043 | Corte Madera Bike Path | 17658 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 4.52 | Corte Madera Bike Path | 0 | Local Recreation Area 3 | 4 | |
14860 | 14860 | 14859 | {"type": "Polygon", "coordinates": [[[-121.58753, 36.99436], [-121.58738, 36.99554], [-121.58732, 36.99577], [-121.58721, 36.996], [-121.58706, 36.99622], [-121.58583, 36.9976], [-121.58544, 36.99808], [-121.58541, 36.99807], [-121.58494, 36.99872], [-121.58458, 36.99926], [-121.58332, 36.99837], [-121.58303, 36.99813], [-121.58286, 36.99795], [-121.58272, 36.99776], [-121.58257, 36.99753], [-121.58236, 36.9971], [-121.58221, 36.99689], [-121.58205, 36.9967], [-121.58183, 36.99649], [-121.58133, 36.99607], [-121.58054, 36.99548], [-121.58128, 36.99477], [-121.58177, 36.99424], [-121.58184, 36.99425], [-121.58305, 36.99325], [-121.58319, 36.99311], [-121.58336, 36.99293], [-121.58354, 36.9927], [-121.58371, 36.99244], [-121.58384, 36.99218], [-121.58549, 36.99277], [-121.587, 36.99287], [-121.58713, 36.99346], [-121.58753, 36.99436]]]} | Open Access 1 | 45370 | Christmas Hill Park | 17228 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 68.847 | Christmas Hill Park | 0 | Local Park 2 | 4 | |
15389 | 15389 | 15388 | {"type": "Polygon", "coordinates": [[[-118.09413, 33.83158], [-118.09346, 33.83146], [-118.093, 33.82842], [-118.09369, 33.82863], [-118.09413, 33.83158]]]} | Open Access 1 | 46608 | San Gabriel River Trail | 29917 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 5.002 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
16239 | 16239 | 16238 | {"type": "Polygon", "coordinates": [[[-118.43979, 34.37452], [-118.43975, 34.37721], [-118.43642, 34.3772], [-118.43641, 34.3763], [-118.4342, 34.37628], [-118.4342, 34.37538], [-118.43309, 34.37537], [-118.4331, 34.37448], [-118.43979, 34.37452]]]} | Open Access 1 | 46271 | Placerita Golden Valley Ranch Open Space | 29557 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 35.339 | Placerita Golden Valley Ranch OS | 0 | Local Recreation Area 3 | 4 | |
16243 | 16243 | 16242 | {"type": "MultiPolygon", "coordinates": [[[[-118.36323, 34.43458], [-118.36322, 34.43457], [-118.36055, 34.43457], [-118.36051, 34.43809], [-118.36055, 34.44182], [-118.35619, 34.44135], [-118.35629, 34.44514], [-118.35199, 34.44471], [-118.35227, 34.45054], [-118.35121, 34.45123], [-118.34996, 34.45259], [-118.34943, 34.4556], [-118.34819, 34.45706], [-118.34734, 34.45754], [-118.34664, 34.45788], [-118.3451, 34.45882], [-118.34452, 34.4592], [-118.34411, 34.45949], [-118.34382, 34.45973], [-118.3431, 34.46042], [-118.34271, 34.461], [-118.34243, 34.46151], [-118.3421, 34.46221], [-118.34198, 34.46265], [-118.34153, 34.46301], [-118.34126, 34.46327], [-118.34096, 34.46349], [-118.33781, 34.46547], [-118.33439, 34.46541], [-118.33449, 34.45261], [-118.34343, 34.45164], [-118.34291, 34.43993], [-118.33652, 34.44005], [-118.33649, 34.4381], [-118.3369, 34.43822], [-118.33718, 34.43826], [-118.33746, 34.43827], [-118.33775, 34.43826], [-118.33803, 34.43822], [-118.33831, 34.43815], [-118.3394, 34.43775], [-118.33977, 34.43754], [-118.33997, 34.43738], [-118.34015, 34.43721], [-118.34031, 34.43701], [-118.3407, 34.43641], [-118.34081, 34.43628], [-118.34103, 34.43612], [-118.34131, 34.436], [-118.34273, 34.43601], [-118.34717, 34.43652], [-118.34715, 34.43365], [-118.34813, 34.43301], [-118.36054, 34.43456], [-118.36056, 34.43364], [-118.36089, 34.4336], [-118.3618, 34.43334], [-118.36205, 34.43328], [-118.36223, 34.43328], [-118.36241, 34.43329], [-118.36262, 34.43336], [-118.36287, 34.4335], [-118.36299, 34.43361], [-118.36312, 34.43381], [-118.36318, 34.43401], [-118.36321, 34.43414], [-118.36323, 34.43458]]], [[[-118.3409, 34.436], [-118.34069, 34.43615], [-118.34057, 34.43627], [-118.34013, 34.43694], [-118.33998, 34.43712], [-118.3398, 34.43729], [-118.3396, 34.43744], [-118.33939, 34.43756], [-118.3386, 34.43787], [-118.33858, 34.43737], [-118.33899, 34.43721], [-118.33931, 34.43703], [-118.34058, 34.436], [-118.3409, 34.436]]], [[[-118.36127, 34.45283], [-118.36122, 34.45645], [-118.35676, 34.45623], [-118.35673, 34.45849], [-118.35673, 34.45992], [-118.35224, 34.45977], [-118.35219, 34.46359], [-118.34774, 34.46348], [-118.34779, 34.45962], [-118.34587, 34.45955], [-118.34862, 34.45799], [-118.34875, 34.45789], [-118.35028, 34.45631], [-118.35134, 34.45393], [-118.35263, 34.45225], [-118.36127, 34.45283]]], [[[-118.36511, 34.43459], [-118.36365, 34.43458], [-118.36348, 34.43384], [-118.36335, 34.43357], [-118.36309, 34.43329], [-118.36283, 34.43313], [-118.36253, 34.43304], [-118.36221, 34.433], [-118.36195, 34.43302], [-118.36098, 34.43329], [-118.36057, 34.43336], [-118.36058, 34.43254], [-118.36187, 34.43258], [-118.3638, 34.43301], [-118.36414, 34.43315], [-118.36505, 34.43362], [-118.36511, 34.43459]]], [[[-118.36502, 34.43312], [-118.36439, 34.43279], [-118.36405, 34.43265], [-118.36345, 34.4325], [-118.36195, 34.43217], [-118.36058, 34.43212], [-118.36059, 34.43104], [-118.36489, 34.43103], [-118.36502, 34.43312]]]]} | Open Access 1 | 46243 | Eastern Greenbelt Open Space | 29554 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1243.079 | Eastern Greenbelt OS | 0 | Local Recreation Area 3 | 4 | |
16246 | 16246 | 16245 | {"type": "MultiPolygon", "coordinates": [[[[-118.55666, 34.36353], [-118.55638, 34.36353], [-118.55606, 34.36251], [-118.55601, 34.36229], [-118.5559, 34.36205], [-118.55584, 34.36184], [-118.55603, 34.36154], [-118.55616, 34.36122], [-118.5562, 34.36102], [-118.55622, 34.36086], [-118.55622, 34.36066], [-118.55619, 34.36047], [-118.55624, 34.36041], [-118.55647, 34.36049], [-118.55666, 34.36063], [-118.5568, 34.36081], [-118.55687, 34.36101], [-118.55687, 34.36112], [-118.55686, 34.36123], [-118.55644, 34.36285], [-118.55666, 34.36353]]], [[[-118.5637, 34.36721], [-118.55864, 34.36719], [-118.55799, 34.36633], [-118.55783, 34.36608], [-118.55762, 34.36568], [-118.55724, 34.36447], [-118.55731, 34.36444], [-118.55715, 34.36394], [-118.55707, 34.36395], [-118.55678, 34.36302], [-118.55681, 34.36242], [-118.55734, 34.36199], [-118.55741, 34.36171], [-118.55717, 34.36119], [-118.55718, 34.36099], [-118.55713, 34.36079], [-118.55702, 34.36058], [-118.55685, 34.36041], [-118.55671, 34.36031], [-118.55654, 34.36023], [-118.55615, 34.36014], [-118.55597, 34.35986], [-118.56368, 34.35989], [-118.5637, 34.36721]]], [[[-118.58964, 34.37075], [-118.58812, 34.37037], [-118.58532, 34.37075], [-118.58102, 34.37074], [-118.58107, 34.37367], [-118.58021, 34.37368], [-118.57873, 34.37313], [-118.5763, 34.37189], [-118.57482, 34.37037], [-118.57234, 34.36904], [-118.57228, 34.36716], [-118.58094, 34.36723], [-118.58962, 34.36713], [-118.58964, 34.37075]]]]} | Open Access 1 | 46255 | Rivendale Ranch Open Space | 29537 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 297.561 | Rivendale Ranch OS | 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]);