units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
812 rows where DES_TP = 2 and MNG_AG_LEV = 3 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP
MNG_AGENCY >30
- Los Angeles, County of 95
- San Diego, County of 68
- Los Angeles - Department of Parks and Recreation, County of 44
- Orange, County of 43
- El Dorado, County of 42
- Santa Barbara, County of 40
- Kern, County of 37
- Sonoma County Regional Parks Dept., County of 34
- Santa Cruz, County of 33
- Santa Clara County Parks and Recreation Dept., County of 32
- Stanislaus, County of 22
- Marin County Parks Department, County of 21
- San Luis Obispo, County of 20
- Riverside, County of 19
- Placer, County of 19
- San Mateo County Parks and Recreation Dept., County of 18
- Lake, County of 18
- San Joaquin, County of 18
- Monterey, County of 17
- Ventura, County of 15
- San Bernardino, County of 14
- Merced, County of 12
- Yolo, County of 12
- Tulare, County of 11
- Fresno, County of 11
- Humboldt, County of 10
- Sacramento, County of 7
- Contra Costa County Public Works Dept., County of 6
- Tehama, County of 6
- Mendocino, County of 6
- …
ACCESS_TYP 4
MNG_AG_TYP 3
DES_TP 1
- Local Park · 812 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
1086 | 1086 | 1085 | {"type": "MultiPolygon", "coordinates": [[[[-118.70777, 34.08133], [-118.70681, 34.0813], [-118.70623, 34.08114], [-118.70622, 34.08048], [-118.70776, 34.08048], [-118.70777, 34.08133]]], [[[-118.71107, 34.08337], [-118.71107, 34.08905], [-118.70501, 34.08902], [-118.70468, 34.08872], [-118.70458, 34.08871], [-118.70446, 34.08865], [-118.70384, 34.08818], [-118.70376, 34.08805], [-118.70405, 34.08651], [-118.70448, 34.08541], [-118.70225, 34.08541], [-118.70224, 34.08133], [-118.70325, 34.08192], [-118.70432, 34.0824], [-118.70448, 34.08253], [-118.7046, 34.08271], [-118.70472, 34.08318], [-118.70474, 34.08317], [-118.70472, 34.08304], [-118.70466, 34.08277], [-118.70458, 34.08252], [-118.70455, 34.08244], [-118.70452, 34.08241], [-118.70427, 34.08224], [-118.70329, 34.08181], [-118.70419, 34.08181], [-118.70421, 34.08184], [-118.70436, 34.0818], [-118.7069, 34.08182], [-118.70864, 34.08246], [-118.70839, 34.08293], [-118.7084, 34.08294], [-118.70854, 34.08298], [-118.70879, 34.08252], [-118.71107, 34.08337]]]]} | Open Access 1 | 6475 | Tapia Park | 26185 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 138.571 | Tapia Park | 0 | Local Park 2 | 4 | |
13921 | 13921 | 13920 | {"type": "Polygon", "coordinates": [[[-121.84833, 37.25563], [-121.84663, 37.25985], [-121.84562, 37.26362], [-121.84547, 37.26412], [-121.84533, 37.26464], [-121.84206, 37.26469], [-121.8397, 37.26156], [-121.83774, 37.26159], [-121.83639, 37.25952], [-121.83617, 37.25916], [-121.84291, 37.25912], [-121.84291, 37.25868], [-121.84339, 37.2577], [-121.84335, 37.2575], [-121.8432, 37.2571], [-121.84276, 37.25508], [-121.84294, 37.25507], [-121.84294, 37.25502], [-121.84498, 37.25499], [-121.84601, 37.25529], [-121.84678, 37.25546], [-121.84741, 37.25556], [-121.84833, 37.25563]]]} | Open Access 1 | 46977 | Martial Cottle Park | 30611 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 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/martialcottle.aspx | Santa Clara 19 | 137.123 | Martial Cottle Park | 1963 | Local Park 2 | 4 |
11442 | 11442 | 11441 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | 48138 | Lennox Community Garden | 32666 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.127 | Lennox Community Garden | 0 | Local Park 2 | 4 | |
1826 | 1826 | 1825 | {"type": "Polygon", "coordinates": [[[-121.59683, 37.91452], [-121.59681, 37.91464], [-121.59673, 37.91472], [-121.59644, 37.91528], [-121.59643, 37.91542], [-121.59661, 37.91574], [-121.5967, 37.9161], [-121.59664, 37.91618], [-121.59635, 37.91627], [-121.596, 37.91633], [-121.59546, 37.91637], [-121.59503, 37.91646], [-121.59462, 37.91649], [-121.59405, 37.91522], [-121.59426, 37.91509], [-121.5945, 37.91486], [-121.59474, 37.91466], [-121.59492, 37.91418], [-121.59501, 37.9138], [-121.59505, 37.91347], [-121.59532, 37.91343], [-121.59553, 37.91343], [-121.59577, 37.91346], [-121.59603, 37.91361], [-121.59619, 37.91376], [-121.59653, 37.91426], [-121.59673, 37.91442], [-121.59683, 37.91452]]]} | Open Access 1 | 15707 | Cornell Park | 32842 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 13.522 | Cornell Park | 0 | Local Park 2 | 4 | |
1963 | 1963 | 1962 | {"type": "Polygon", "coordinates": [[[-122.3308, 37.99984], [-122.32883, 38.00027], [-122.32826, 37.99972], [-122.32874, 37.99941], [-122.32795, 37.99863], [-122.32906, 37.99841], [-122.32936, 37.9984], [-122.33043, 37.9986], [-122.33057, 37.99918], [-122.33065, 37.99944], [-122.33072, 37.9996], [-122.3308, 37.99984]]]} | Open Access 1 | 15093 | Montalvin Park | 22382 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.497 | Montalvin Park | 0 | Local Park 2 | 4 | |
3257 | 3257 | 3256 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | 48179 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 0.053 | Kensington PP | 0 | Local Park 2 | 4 | |
11466 | 11466 | 11465 | {"type": "Polygon", "coordinates": [[[-122.28132, 37.9134], [-122.28121, 37.91335], [-122.28073, 37.91357], [-122.28038, 37.91363], [-122.28006, 37.91364], [-122.28059, 37.91414], [-122.28032, 37.91429], [-122.28033, 37.91433], [-122.28017, 37.91443], [-122.28013, 37.91447], [-122.28011, 37.91455], [-122.27999, 37.91464], [-122.27974, 37.91375], [-122.27977, 37.91354], [-122.27953, 37.91348], [-122.27932, 37.91337], [-122.27914, 37.9133], [-122.27894, 37.91332], [-122.27856, 37.91344], [-122.27849, 37.9134], [-122.27855, 37.91313], [-122.27855, 37.91292], [-122.28025, 37.91174], [-122.28106, 37.91239], [-122.2812, 37.91267], [-122.28074, 37.91276], [-122.28074, 37.91278], [-122.28092, 37.91335], [-122.28129, 37.91318], [-122.28132, 37.9134]]]} | Open Access 1 | 48178 | Kensington Park | 32713 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.459 | Kensington Park | 0 | Local Park 2 | 4 | |
12092 | 12092 | 12091 | {"type": "Polygon", "coordinates": [[[-122.02017, 37.86622], [-122.02016, 37.86639], [-122.01993, 37.86641], [-122.01969, 37.86648], [-122.01952, 37.86657], [-122.01934, 37.86672], [-122.0192, 37.86692], [-122.01905, 37.86733], [-122.01897, 37.86749], [-122.01882, 37.86767], [-122.01862, 37.86783], [-122.01852, 37.86783], [-122.01826, 37.8676], [-122.01798, 37.86742], [-122.01815, 37.86697], [-122.01795, 37.86683], [-122.0179, 37.86666], [-122.01792, 37.86629], [-122.01939, 37.86633], [-122.01944, 37.86632], [-122.0195, 37.86629], [-122.01953, 37.86625], [-122.01954, 37.8662], [-122.02017, 37.86622]]]} | Open Access 1 | 24911 | Livorna Park | 21386 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.387 | Livorna Park | 0 | Local Park 2 | 4 | |
12094 | 12094 | 12093 | {"type": "Polygon", "coordinates": [[[-121.95664, 38.0308], [-121.95557, 38.03164], [-121.95456, 38.03083], [-121.95562, 38.03], [-121.95664, 38.0308]]]} | Open Access 1 | 24917 | Lynbrook Park | 21606 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.143 | Lynbrook Park | 0 | Local Park 2 | 4 | |
958 | 958 | 957 | {"type": "Polygon", "coordinates": [[[-119.92531, 36.72346], [-119.92527, 36.72786], [-119.91225, 36.72797], [-119.91225, 36.72353], [-119.92531, 36.72346]]]} | Open Access 1 | 6028 | Kearney Park | 20564 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 141.05 | Kearney Park | 0 | Local Park 2 | 4 | |
1092 | 1092 | 1091 | {"type": "MultiPolygon", "coordinates": [[[[-120.06057, 36.82127], [-120.05812, 36.82206], [-120.05808, 36.82217], [-120.05765, 36.82219], [-120.05656, 36.82261], [-120.05645, 36.82149], [-120.05648, 36.82129], [-120.05672, 36.82121], [-120.05673, 36.82153], [-120.05751, 36.82123], [-120.05809, 36.82109], [-120.0581, 36.82122], [-120.06056, 36.82068], [-120.06057, 36.82127]]], [[[-120.06297, 36.81983], [-120.06296, 36.82016], [-120.06068, 36.82113], [-120.06069, 36.82058], [-120.06297, 36.81983]]]]} | Open Access 1 | 6501 | Skaggs Bridge Park | 25525 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 10.968 | Skaggs Bridge Park | 0 | Local Park 2 | 4 | |
4154 | 4154 | 4153 | {"type": "Polygon", "coordinates": [[[-119.81577, 36.82816], [-119.81567, 36.82823], [-119.81543, 36.8286], [-119.81534, 36.82863], [-119.81459, 36.82867], [-119.81452, 36.82859], [-119.81441, 36.82857], [-119.81437, 36.82825], [-119.81437, 36.82794], [-119.81444, 36.82792], [-119.8145, 36.82788], [-119.81531, 36.82788], [-119.81536, 36.82792], [-119.81542, 36.82795], [-119.81549, 36.82795], [-119.81556, 36.82793], [-119.81577, 36.82816]]]} | Open Access 1 | 47541 | Tenaya Park | 31249 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.tenayapark.org/home | Fresno 9 | 2.209 | Tenaya Park | 0 | Local Park 2 | 4 |
5462 | 5462 | 5461 | {"type": "Polygon", "coordinates": [[[-120.5772, 36.23014], [-120.576, 36.23388], [-120.57199, 36.23385], [-120.57199, 36.23372], [-120.57111, 36.23372], [-120.57112, 36.2293], [-120.57146, 36.22934], [-120.57203, 36.22947], [-120.57274, 36.22952], [-120.57507, 36.22999], [-120.57554, 36.23005], [-120.57601, 36.23004], [-120.5772, 36.23014]]]} | Open Access 1 | 6270 | Los Gatos Creek County Park | 21515 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 55.581 | Los Gatos Creek County Park | 0 | Local Park 2 | 4 | |
6986 | 6986 | 6985 | {"type": "Polygon", "coordinates": [[[-119.42108, 36.77855], [-119.42081, 36.78005], [-119.41857, 36.78242], [-119.41777, 36.78378], [-119.41743, 36.78552], [-119.41756, 36.78608], [-119.41728, 36.7867], [-119.41689, 36.78775], [-119.4136, 36.79017], [-119.41289, 36.79018], [-119.41291, 36.78956], [-119.41265, 36.78957], [-119.41264, 36.78953], [-119.41163, 36.78953], [-119.41163, 36.79007], [-119.41169, 36.79008], [-119.41169, 36.7902], [-119.41163, 36.79021], [-119.41163, 36.79075], [-119.41051, 36.79098], [-119.40972, 36.79183], [-119.4092, 36.79286], [-119.40806, 36.79282], [-119.40253, 36.79276], [-119.4029, 36.79203], [-119.40398, 36.79025], [-119.40444, 36.79042], [-119.40455, 36.79042], [-119.40454, 36.79034], [-119.4045, 36.79033], [-119.40438, 36.79018], [-119.40409, 36.79007], [-119.40466, 36.78911], [-119.40589, 36.7856], [-119.40683, 36.7856], [-119.40682, 36.78531], [-119.40608, 36.7853], [-119.40697, 36.78457], [-119.40753, 36.78396], [-119.40776, 36.78365], [-119.4092, 36.78367], [-119.40889, 36.78446], [-119.40818, 36.78559], [-119.40818, 36.78561], [-119.41158, 36.78567], [-119.41163, 36.78947], [-119.41293, 36.78906], [-119.41329, 36.78548], [-119.41363, 36.78401], [-119.41156, 36.78247], [-119.41151, 36.78205], [-119.41573, 36.78208], [-119.41818, 36.77991], [-119.41917, 36.78014], [-119.42026, 36.77852], [-119.42108, 36.77855]]]} | Open Access 1 | 5909 | Avocado Lake Park | 3936 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51947 | Fresno 9 | 225.777 | Avocado Lake Park | 0 | Local Park 2 | 4 |
7097 | 7097 | 7096 | {"type": "Polygon", "coordinates": [[[-119.69078, 36.4277], [-119.69074, 36.4293], [-119.69071, 36.42972], [-119.68743, 36.42975], [-119.6875, 36.42902], [-119.68794, 36.42907], [-119.68852, 36.42919], [-119.68938, 36.42931], [-119.6907, 36.42946], [-119.69073, 36.42931], [-119.6894, 36.42913], [-119.68851, 36.42901], [-119.68797, 36.42891], [-119.68748, 36.4288], [-119.68631, 36.42839], [-119.68641, 36.4269], [-119.68728, 36.42697], [-119.68779, 36.42691], [-119.68874, 36.42707], [-119.68941, 36.42695], [-119.69078, 36.4277]]]} | Open Access 1 | 6148 | Laton-Kingston Park | 21081 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 24.247 | Laton-Kingston Park | 0 | Local Park 2 | 4 | |
7225 | 7225 | 7224 | {"type": "Polygon", "coordinates": [[[-120.3761, 36.7807], [-120.37597, 36.7808], [-120.37571, 36.78105], [-120.37517, 36.78076], [-120.37455, 36.7806], [-120.37395, 36.78049], [-120.37328, 36.78048], [-120.37283, 36.78069], [-120.37245, 36.78082], [-120.3733, 36.78465], [-120.37121, 36.78454], [-120.37122, 36.78516], [-120.37026, 36.78491], [-120.36982, 36.78438], [-120.36952, 36.78374], [-120.36934, 36.78279], [-120.36939, 36.7821], [-120.36868, 36.78201], [-120.36858, 36.78167], [-120.36872, 36.78118], [-120.36855, 36.78059], [-120.36844, 36.78032], [-120.3689, 36.77975], [-120.36951, 36.7788], [-120.37032, 36.77791], [-120.37101, 36.77764], [-120.37204, 36.77738], [-120.37287, 36.77708], [-120.37248, 36.77796], [-120.37307, 36.77821], [-120.37357, 36.77857], [-120.37421, 36.77948], [-120.3754, 36.78023], [-120.3761, 36.7807]]]} | Open Access 1 | 6388 | Mendota Pool Park | 22152 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 72.242 | Mendota Pool Park | 0 | Local Park 2 | 4 | |
9453 | 9453 | 9452 | {"type": "MultiPolygon", "coordinates": [[[[-119.38326, 36.8181], [-119.3831, 36.81856], [-119.38303, 36.81856], [-119.38264, 36.81984], [-119.38193, 36.81963], [-119.38133, 36.8194], [-119.38067, 36.81912], [-119.38007, 36.81881], [-119.38007, 36.81813], [-119.38326, 36.8181]]], [[[-119.38697, 36.81641], [-119.38629, 36.81792], [-119.38469, 36.81923], [-119.38468, 36.81946], [-119.38457, 36.81953], [-119.38444, 36.81959], [-119.38406, 36.81964], [-119.38379, 36.81979], [-119.38354, 36.81989], [-119.38327, 36.81994], [-119.38307, 36.81994], [-119.38345, 36.81865], [-119.3834, 36.81863], [-119.38358, 36.8181], [-119.38367, 36.81809], [-119.38365, 36.81762], [-119.38373, 36.81712], [-119.38422, 36.81613], [-119.38451, 36.81438], [-119.38454, 36.81437], [-119.38449, 36.81163], [-119.38529, 36.81486], [-119.38697, 36.81641]]]]} | Open Access 1 | 15812 | Winton Park | 27659 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 37.979 | Winton Park | 0 | Local Park 2 | 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]);