units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,490 rows where MNG_AG_LEV = 3 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER
MNG_AGENCY >30
- Los Angeles, County of 175
- San Diego, County of 123
- Santa Barbara, County of 119
- Orange, County of 95
- Los Angeles - Department of Parks and Recreation, County of 65
- Lake, County of 56
- Sacramento, County of 56
- Santa Clara County Parks and Recreation Dept., County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Sonoma County Regional Parks Dept., County of 50
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 44
- Riverside, County of 39
- Marin County Parks Department, County of 34
- San Luis Obispo, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 25
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- San Bernardino, County of 20
- Yolo, County of 18
- Fresno, County of 17
- Merced, County of 16
- Tulare, County of 15
- San Francisco - Public Utilities Commission, City and County of 14
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 11
- …
DES_TP >30
- Local Park 812
- Local Other or Unknown 221
- Local Recreation Area 158
- Local Conservation Area 117
- Local Historic or Cultural Area 21
- Local Resource Management Area 8
- National Recreation Area 3
- National Forest 2
- National Monument or Landmark 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,324
- Restricted Access 82
- No Public Access 47
- Unknown Access 37
MNG_AG_TYP 3
- County Agency 1,219
- County Agency - Parks 236
- County Agency - Other 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2232 | 2232 | 2231 | {"type": "Polygon", "coordinates": [[[-121.88455, 38.68187], [-121.88395, 38.68408], [-121.88098, 38.68409], [-121.88058, 38.68408], [-121.88163, 38.68168], [-121.88308, 38.68183], [-121.88416, 38.68178], [-121.88455, 38.68187]]]} | Open Access 1 | 47879 | Wild Wings Park | 31823 | 380 | Yolo County Parks, County of 497 | County 3 | County Agency - Parks 7 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 380 | Yolo County Parks, County of 488 | County 3 | County Agency - Parks 7 | https://www.yolocounty.org/general-government/general-government-departments/parks/parks-information/wild-wings-park | Yolo 33 | 17.528 | Wild Wings Park | 0 | Local Park 2 | 4 |
3956 | 3956 | 3955 | {"type": "Polygon", "coordinates": [[[-121.84533, 37.26464], [-121.84499, 37.26587], [-121.8333, 37.26597], [-121.8323, 37.26586], [-121.83182, 37.26587], [-121.83147, 37.26583], [-121.83147, 37.2658], [-121.8314, 37.26579], [-121.83136, 37.26576], [-121.83132, 37.26569], [-121.83129, 37.2657], [-121.83126, 37.26541], [-121.83111, 37.26459], [-121.83109, 37.26311], [-121.83104, 37.2625], [-121.83102, 37.2602], [-121.83107, 37.25982], [-121.83111, 37.25919], [-121.83617, 37.25916], [-121.83639, 37.25952], [-121.83773, 37.26158], [-121.8397, 37.26155], [-121.84206, 37.26469], [-121.84533, 37.26464]]]} | Open Access 1 | 46978 | Martial Cottle Park | 30611 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 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 | 150.454 | Martial Cottle Park | 1963 | 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 |
3378 | 3378 | 3377 | {"type": "Polygon", "coordinates": [[[-121.6646, 36.99929], [-121.66395, 36.99962], [-121.66372, 36.99914], [-121.6607, 36.99998], [-121.64336, 36.99825], [-121.64237, 36.99706], [-121.64103, 36.99558], [-121.63962, 36.99342], [-121.63959, 36.99328], [-121.63974, 36.99263], [-121.64976, 36.98879], [-121.64998, 36.98865], [-121.65387, 36.98718], [-121.65444, 36.98739], [-121.65526, 36.98798], [-121.65768, 36.98858], [-121.65796, 36.98868], [-121.65926, 36.98898], [-121.65924, 36.98906], [-121.65915, 36.98927], [-121.65869, 36.98944], [-121.65852, 36.98982], [-121.65814, 36.99001], [-121.65802, 36.99034], [-121.65782, 36.99051], [-121.6576, 36.99095], [-121.65718, 36.99132], [-121.657, 36.99169], [-121.65616, 36.99213], [-121.65585, 36.99264], [-121.65576, 36.9929], [-121.65573, 36.9932], [-121.65619, 36.9935], [-121.65642, 36.99384], [-121.65658, 36.99397], [-121.65726, 36.99401], [-121.65742, 36.99461], [-121.65783, 36.99478], [-121.65806, 36.99509], [-121.65843, 36.99523], [-121.65842, 36.99555], [-121.65873, 36.99572], [-121.65856, 36.99611], [-121.65867, 36.99631], [-121.65934, 36.99662], [-121.66013, 36.99723], [-121.66134, 36.99737], [-121.66267, 36.99781], [-121.66332, 36.99812], [-121.6646, 36.99929]], [[-121.65455, 36.99628], [-121.65454, 36.99626], [-121.6541, 36.99606], [-121.65394, 36.9963], [-121.65438, 36.9965], [-121.65455, 36.99628]]]} | No Public Access 3 | 24434 | Mount Madonna County Park | 29288 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 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 | 423.185 | Mount Madonna County 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 |
5769 | 5769 | 5768 | {"type": "MultiPolygon", "coordinates": [[[[-121.68672, 36.99803], [-121.68674, 36.99859], [-121.68661, 36.99896], [-121.68643, 36.99936], [-121.6863, 36.9998], [-121.68549, 37.00119], [-121.6854, 37.0018], [-121.68518, 37.00212], [-121.68487, 37.00246], [-121.68471, 37.00262], [-121.68441, 37.00278], [-121.68384, 37.00298], [-121.68341, 37.00311], [-121.68281, 37.00343], [-121.68237, 37.0037], [-121.68199, 37.00385], [-121.68126, 37.00395], [-121.68062, 37.00388], [-121.68004, 37.0037], [-121.67943, 37.00359], [-121.67871, 37.00351], [-121.67689, 37.0034], [-121.67629, 37.00332], [-121.67587, 37.0032], [-121.67521, 37.00309], [-121.67512, 37.00291], [-121.6747, 37.00217], [-121.67447, 37.00187], [-121.67356, 37.00185], [-121.67306, 37.00116], [-121.67214, 37.00075], [-121.67159, 37.00067], [-121.67134, 37.00042], [-121.67088, 36.99909], [-121.66987, 36.99904], [-121.66916, 36.99843], [-121.66876, 36.99825], [-121.66483, 36.99911], [-121.66455, 36.98429], [-121.66813, 36.98641], [-121.68672, 36.99803]]], [[[-121.71358, 37.02718], [-121.70911, 37.02723], [-121.70928, 37.03286], [-121.70996, 37.03332], [-121.70988, 37.03335], [-121.70972, 37.03333], [-121.7096, 37.03334], [-121.70945, 37.03341], [-121.7089, 37.03404], [-121.70885, 37.03408], [-121.70828, 37.03421], [-121.70784, 37.03422], [-121.7076, 37.03425], [-121.70647, 37.0346], [-121.70632, 37.03463], [-121.70616, 37.03463], [-121.70601, 37.0346], [-121.70587, 37.03455], [-121.70573, 37.03446], [-121.70561, 37.03436], [-121.70548, 37.03418], [-121.70533, 37.03394], [-121.70527, 37.03382], [-121.70514, 37.03352], [-121.70509, 37.03342], [-121.70486, 37.03318], [-121.70472, 37.0331], [-121.70461, 37.03307], [-121.70408, 37.03302], [-121.70399, 37.033], [-121.70389, 37.03293], [-121.70373, 37.03277], [-121.70364, 37.03271], [-121.70354, 37.03269], [-121.70248, 37.03265], [-121.70224, 37.03263], [-121.70178, 37.03256], [-121.70108, 37.03239], [-121.70101, 37.03235], [-121.70095, 37.03226], [-121.70088, 37.03219], [-121.70078, 37.03213], [-121.70066, 37.03209], [-121.70054, 37.03207], [-121.70041, 37.03207], [-121.70013, 37.03214], [-121.69996, 37.03214], [-121.69963, 37.032], [-121.69954, 37.03197], [-121.69934, 37.03195], [-121.69917, 37.0319], [-121.69891, 37.03176], [-121.69879, 37.03172], [-121.69867, 37.03171], [-121.69854, 37.03173], [-121.69828, 37.03181], [-121.69804, 37.03193], [-121.69794, 37.03195], [-121.69785, 37.03194], [-121.69776, 37.03191], [-121.69726, 37.03162], [-121.69676, 37.0314], [-121.69677, 37.03137], [-121.69548, 37.03058], [-121.69537, 37.03053], [-121.69525, 37.0305], [-121.69506, 37.0305], [-121.69486, 37.03055], [-121.69477, 37.03055], [-121.69249, 37.03023], [-121.69194, 37.03018], [-121.6914, 37.03015], [-121.69085, 37.03013], [-121.69018, 37.03013], [-121.68919, 37.03024], [-121.68892, 37.03028], [-121.68849, 37.0304], [-121.68825, 37.03044], [-121.68792, 37.03049], [-121.68742, 37.03052], [-121.6871, 37.03063], [-121.68688, 37.03074], [-121.6865, 37.03101], [-121.68561, 37.0317], [-121.68385, 37.0269], [-121.68064, 37.02881], [-121.67665, 37.02709], [-121.67403, 37.02297], [-121.675, 37.02246], [-121.67552, 37.02128], [-121.67558, 37.02068], [-121.676, 37.02025], [-121.67636, 37.02005], [-121.67689, 37.01985], [-121.67803, 37.01968], [-121.67837, 37.01899], [-121.67873, 37.01863], [-121.6793, 37.0179], [-121.67931, 37.01745], [-121.67946, 37.01733], [-121.67982, 37.01735], [-121.68038, 37.01748], [-121.68096, 37.01751], [-121.68219, 37.01829], [-121.68285, 37.01856], [-121.68319, 37.01853], [-121.6839, 37.01867], [-121.68431, 37.01873], [-121.68521, 37.01909], [-121.68796, 37.02053], [-121.68866, 37.02026], [-121.6934, 37.02305], [-121.71353, 37.01979], [-121.71358, 37.02718]]], [[[-121.73523, 37.0163], [-121.73072, 37.02292], [-121.73026, 37.02356], [-121.73013, 37.02352], [-121.7306, 37.02279], [-121.7309, 37.02184], [-121.72859, 37.02092], [-121.72772, 37.0209], [-121.72688, 37.02196], [-121.72662, 37.02169], [-121.72638, 37.02141], [-121.72622, 37.02119], [-121.72608, 37.02095], [-121.7259, 37.02055], [-121.7258, 37.02026], [-121.72555, 37.01921], [-121.72542, 37.01876], [-121.72521, 37.01839], [-121.72494, 37.01805], [-121.72474, 37.01786], [-121.72452, 37.01769], [-121.72427, 37.01753], [-121.72389, 37.01735], [-121.72363, 37.01727], [-121.72336, 37.01721], [-121.72223, 37.01703], [-121.72176, 37.01693], [-121.72133, 37.01679], [-121.72106, 37.01668], [-121.72081, 37.01655], [-121.72057, 37.01639], [-121.72035, 37.01621], [-121.72016, 37.01602], [-121.71912, 37.01475], [-121.71821, 37.01369], [-121.71826, 37.01358], [-121.71827, 37.01345], [-121.7181, 37.01308], [-121.718, 37.0129], [-121.71786, 37.01273], [-121.7177, 37.01258], [-121.71729, 37.01231], [-121.71724, 37.01223], [-121.71724, 37.01215], [-121.71729, 37.01206], [-121.71738, 37.01197], [-121.71748, 37.0119], [-121.71761, 37.01185], [-121.71822, 37.01174], [-121.719, 37.01167], [-121.71923, 37.01163], [-121.71945, 37.01157], [-121.71966, 37.01147], [-121.71985, 37.01136], [-121.72023, 37.01107], [-121.72042, 37.01084], [-121.72065, 37.01038], [-121.72073, 37.01028], [-121.72089, 37.01015], [-121.72116, 37.01002], [-121.72128, 37.00993], [-121.72139, 37.00983], [-121.72147, 37.00971], [-121.72152, 37.00958], [-121.72154, 37.00945], [-121.72155, 37.00931], [-121.72152, 37.00917], [-121.72147, 37.00901], [-121.72119, 37.00864], [-121.7217, 37.00769], [-121.72196, 37.00744], [-121.72557, 37.01114], [-121.72673, 37.01494], [-121.73044, 37.01336], [-121.73523, 37.0163]]]]} | No Public Access 3 | 37026 | Mount Madonna County Park | 29288 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 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 | 1720.675 | Mount Madonna County Park | 0 | Local Park 2 | 4 |
8878 | 8878 | 8877 | {"type": "Polygon", "coordinates": [[[-121.73579, 36.99015], [-121.73447, 36.99077], [-121.73447, 36.99079], [-121.73464, 36.99099], [-121.73457, 36.99126], [-121.73408, 36.99167], [-121.73226, 36.99191], [-121.73204, 36.9918], [-121.73132, 36.99174], [-121.73019, 36.99221], [-121.72997, 36.99226], [-121.72902, 36.99271], [-121.72846, 36.99279], [-121.72811, 36.99317], [-121.72789, 36.99327], [-121.72671, 36.99458], [-121.72662, 36.99507], [-121.72646, 36.99525], [-121.72637, 36.99585], [-121.72581, 36.99653], [-121.72795, 36.99801], [-121.72066, 37.00505], [-121.71733, 37.00769], [-121.71733, 37.0077], [-121.72141, 37.00934], [-121.72141, 37.00944], [-121.72136, 37.00963], [-121.72125, 37.0098], [-121.72108, 37.00993], [-121.72075, 37.01011], [-121.72062, 37.01021], [-121.72053, 37.01034], [-121.72034, 37.01071], [-121.72024, 37.01086], [-121.72005, 37.01106], [-121.71977, 37.01128], [-121.71949, 37.01143], [-121.71919, 37.01153], [-121.71887, 37.01158], [-121.71809, 37.01164], [-121.71757, 37.01175], [-121.71743, 37.0118], [-121.71731, 37.01187], [-121.71721, 37.01196], [-121.71711, 37.01212], [-121.7171, 37.01224], [-121.71716, 37.01235], [-121.7176, 37.01266], [-121.71782, 37.01287], [-121.71797, 37.01312], [-121.71814, 37.0135], [-121.71813, 37.01355], [-121.71787, 37.01384], [-121.71727, 37.01407], [-121.71714, 37.0147], [-121.71699, 37.01521], [-121.71676, 37.0155], [-121.71649, 37.01569], [-121.71652, 37.01589], [-121.7169, 37.01609], [-121.71687, 37.01655], [-121.71677, 37.01679], [-121.7169, 37.01703], [-121.71701, 37.0171], [-121.71706, 37.01719], [-121.71685, 37.01755], [-121.71702, 37.01791], [-121.71702, 37.0181], [-121.71725, 37.01843], [-121.71776, 37.01886], [-121.71856, 37.01889], [-121.71861, 37.01938], [-121.7191, 37.01981], [-121.71921, 37.02015], [-121.71921, 37.02019], [-121.71917, 37.02032], [-121.7191, 37.02039], [-121.71812, 37.0211], [-121.71806, 37.02119], [-121.71798, 37.02138], [-121.71763, 37.02145], [-121.71736, 37.02156], [-121.71642, 37.02213], [-121.71631, 37.02222], [-121.71623, 37.02232], [-121.71619, 37.02244], [-121.71617, 37.02256], [-121.71619, 37.02277], [-121.71615, 37.023], [-121.71607, 37.02315], [-121.71586, 37.02342], [-121.71578, 37.02357], [-121.71356, 37.02358], [-121.71352, 37.01979], [-121.6934, 37.02305], [-121.68866, 37.02026], [-121.67729, 37.01335], [-121.6772, 37.00495], [-121.66942, 37.00492], [-121.66959, 37.00486], [-121.67192, 37.00422], [-121.67208, 37.00414], [-121.67228, 37.00399], [-121.67239, 37.00387], [-121.67264, 37.00352], [-121.67274, 37.00342], [-121.67293, 37.00332], [-121.67307, 37.00329], [-121.67321, 37.00328], [-121.67364, 37.0033], [-121.67392, 37.00328], [-121.6742, 37.00325], [-121.67456, 37.00317], [-121.67479, 37.00315], [-121.67502, 37.00316], [-121.67525, 37.00319], [-121.67521, 37.00309], [-121.67587, 37.0032], [-121.67629, 37.00332], [-121.67689, 37.0034], [-121.67871, 37.00351], [-121.67943, 37.00359], [-121.68004, 37.0037], [-121.68062, 37.00388], [-121.68126, 37.00395], [-121.68199, 37.00385], [-121.68237, 37.0037], [-121.68281, 37.00343], [-121.68341, 37.00311], [-121.68384, 37.00298], [-121.68441, 37.00278], [-121.68471, 37.00262], [-121.68518, 37.00212], [-121.6854, 37.0018], [-121.68549, 37.00119], [-121.6863, 36.9998], [-121.68643, 36.99936], [-121.68661, 36.99896], [-121.68674, 36.99859], [-121.68672, 36.99802], [-121.68675, 36.99781], [-121.68685, 36.99752], [-121.68691, 36.9974], [-121.68744, 36.99676], [-121.68762, 36.9966], [-121.68793, 36.99645], [-121.68806, 36.99632], [-121.68817, 36.99618], [-121.68839, 36.99583], [-121.68842, 36.99573], [-121.68842, 36.99563], [-121.68825, 36.99514], [-121.68824, 36.99496], [-121.68827, 36.99485], [-121.68847, 36.99458], [-121.68854, 36.99446], [-121.68858, 36.99435], [-121.6886, 36.99416], [-121.69764, 36.99405], [-121.69869, 36.99486], [-121.7093, 37.00138], [-121.70936, 37.0011], [-121.70968, 37.00069], [-121.71149, 36.99954], [-121.71207, 36.99878], [-121.71285, 36.99842], [-121.71386, 36.99802], [-121.71541, 36.99709], [-121.71607, 36.99662], [-121.71641, 36.99633], [-121.71704, 36.9962], [-121.71707, 36.99622], [-121.71705, 36.99625], [-121.71707, 36.99626], [-121.7228, 36.99324], [-121.7302, 36.99108], [-121.73207, 36.99031], [-121.7342, 36.99045], [-121.73435, 36.99034], [-121.73459, 36.99038], [-121.73496, 36.99037], [-121.73521, 36.99011], [-121.73579, 36.99015]]]} | Open Access 1 | 14504 | Mount Madonna County Park | 29287 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 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 | 2465.622 | Mount Madonna County Park | 0 | Local Park 2 | 4 |
7368 | 7368 | 7367 | {"type": "Polygon", "coordinates": [[[-118.05801, 33.90814], [-118.05748, 33.90772], [-118.0555, 33.90773], [-118.05549, 33.906], [-118.05799, 33.90598], [-118.05801, 33.90814]]]} | Restricted Access 2 | 6773 | Don Knabe Golf Center and Junior Academy | 32519 | 1225 | Norwalk, City of 239 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | https://www.playknabegolf.com/ | Los Angeles 6 | 11.277 | Don Knabe Golf Ctr. and Junior Academy | None 610 | ||
4449 | 4449 | 4448 | {"type": "Polygon", "coordinates": [[[-121.17178, 38.78981], [-121.1705, 38.79009], [-121.17044, 38.79009], [-121.17038, 38.79007], [-121.17033, 38.79002], [-121.1699, 38.7888], [-121.17148, 38.78877], [-121.17178, 38.78981]]]} | Open Access 1 | 49000 | Franklin Community School Park | 33699 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | https://www.placer.ca.gov/6045/Franklin-Community-School-Park | Placer 35 | 4.349 | Franklin Community School Park | 0 | Local Park 2 | 4 |
10043 | 10043 | 10042 | {"type": "Polygon", "coordinates": [[[-121.09452, 38.93839], [-121.09416, 38.93839], [-121.09416, 38.93785], [-121.09452, 38.93839], [-121.09452, 38.93839]]]} | Open Access 1 | 49023 | Auburn Plaza Park | 33724 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | https://www.placer.ca.gov/6005/Plaza-Park | Placer 35 | 0.231 | Auburn Plaza Park | 0 | Local Park 2 | 4 |
10047 | 10047 | 10046 | {"type": "Polygon", "coordinates": [[[-120.81909, 39.02277], [-120.81495, 39.02381], [-120.81432, 39.02209], [-120.81557, 39.02184], [-120.81585, 39.02263], [-120.81674, 39.02246], [-120.81675, 39.02244], [-120.81647, 39.02165], [-120.81844, 39.02125], [-120.81899, 39.02269], [-120.81909, 39.02277]]]} | Open Access 1 | 49024 | Foresthill Leroy E. Botts Memorial Park | 33725 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | https://www.placer.ca.gov/6000/Foresthill-Leroy-E-Botts-Memorial-Park | Placer 35 | 15.352 | Foresthill Leroy E. Botts Memorial Park | 0 | Local Park 2 | 4 |
4186 | 4186 | 4185 | {"type": "Polygon", "coordinates": [[[-123.20725, 39.27079], [-123.2067, 39.27099], [-123.20635, 39.27092], [-123.20581, 39.27127], [-123.2057, 39.27079], [-123.20565, 39.27078], [-123.20548, 39.27018], [-123.20624, 39.27012], [-123.20625, 39.2701], [-123.20614, 39.26983], [-123.20541, 39.2699], [-123.2054, 39.26983], [-123.20702, 39.26969], [-123.20725, 39.27079]]]} | Open Access 1 | 48864 | Redwood Valley Lions Club Park | 33588 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/redwood-valley-lions-club-park | Mendocino 24 | 4.164 | Redwood Valley Lions Club Park | 0 | Local Park 2 | 4 |
16421 | 16421 | 16420 | {"type": "Polygon", "coordinates": [[[-123.23328, 39.16378], [-123.23272, 39.16366], [-123.23249, 39.16358], [-123.23241, 39.16352], [-123.23233, 39.16328], [-123.2323, 39.16324], [-123.23211, 39.16311], [-123.23206, 39.16309], [-123.23199, 39.16309], [-123.23188, 39.16317], [-123.23167, 39.16327], [-123.23156, 39.1633], [-123.23146, 39.16329], [-123.2313, 39.16323], [-123.23112, 39.16307], [-123.2309, 39.16297], [-123.23075, 39.16294], [-123.23045, 39.16293], [-123.22986, 39.16285], [-123.22963, 39.16284], [-123.22955, 39.16285], [-123.2295, 39.16289], [-123.22933, 39.16306], [-123.22914, 39.16322], [-123.22907, 39.16326], [-123.22883, 39.16333], [-123.22863, 39.16335], [-123.22854, 39.16334], [-123.22842, 39.1633], [-123.22833, 39.16323], [-123.22782, 39.16311], [-123.2276, 39.16289], [-123.22709, 39.16268], [-123.22695, 39.1624], [-123.22695, 39.16232], [-123.22659, 39.16202], [-123.22625, 39.16195], [-123.22552, 39.16209], [-123.22492, 39.16238], [-123.22307, 39.16188], [-123.22318, 39.1616], [-123.22241, 39.16113], [-123.22206, 39.16105], [-123.22201, 39.16068], [-123.22693, 39.16069], [-123.22694, 39.16039], [-123.22886, 39.16039], [-123.23313, 39.16044], [-123.23328, 39.16378]]]} | Open Access 1 | 44977 | Low Gap Regional Park | 21551 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/low-gap-park | Mendocino 24 | 54.974 | Low Gap RP | 0 | Local Park 2 | 4 |
9402 | 9402 | 9401 | {"type": "Polygon", "coordinates": [[[-123.4405, 39.05938], [-123.44049, 39.05965], [-123.44041, 39.05975], [-123.44021, 39.05983], [-123.43997, 39.0601], [-123.43987, 39.06018], [-123.43962, 39.06044], [-123.4395, 39.06053], [-123.43949, 39.06058], [-123.4393, 39.06079], [-123.43906, 39.06087], [-123.43892, 39.06095], [-123.43876, 39.06095], [-123.43795, 39.06072], [-123.43766, 39.0607], [-123.4375, 39.06076], [-123.43727, 39.06098], [-123.43715, 39.06109], [-123.43686, 39.06123], [-123.43655, 39.06093], [-123.43605, 39.06052], [-123.43589, 39.0604], [-123.43528, 39.06002], [-123.43639, 39.05958], [-123.43805, 39.05866], [-123.4405, 39.05938]]]} | Open Access 1 | 49017 | Indian Creek County Park | 33715 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/indian-creek | Mendocino 24 | 17.437 | Indian Creek County Park | 1973 | Local Park 2 | 4 |
15380 | 15380 | 15379 | {"type": "Polygon", "coordinates": [[[-123.4074, 39.00408], [-123.40742, 39.00624], [-123.40739, 39.00777], [-123.40276, 39.00769], [-123.40285, 39.004], [-123.4074, 39.00408]]]} | Open Access 1 | 49011 | Faulkner Park | 33709 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/faulkner-park | Mendocino 24 | 40.36 | Faulkner Park | 1930 | Local Park 2 | 4 |
1719 | 1719 | 1718 | {"type": "Polygon", "coordinates": [[[-120.58203, 38.77208], [-120.58176, 38.77203], [-120.57991, 38.772], [-120.58004, 38.76833], [-120.58042, 38.76844], [-120.58081, 38.76858], [-120.5813, 38.76903], [-120.58158, 38.7696], [-120.58168, 38.77008], [-120.58144, 38.77071], [-120.58152, 38.77159], [-120.58172, 38.77186], [-120.58203, 38.77208]]]} | Open Access 1 | 48466 | Forebay Park | 33175 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | https://www.edcgov.us/Government/Parks/Pages/forebay_park.aspx | El Dorado 34 | 12.621 | Forebay Park | 0 | Local Park 2 | 4 |
17029 | 17029 | 17028 | {"type": "MultiPolygon", "coordinates": [[[[-118.10512, 34.19263], [-118.10495, 34.19317], [-118.1048, 34.19329], [-118.10424, 34.19328], [-118.10399, 34.19293], [-118.10371, 34.19231], [-118.10354, 34.19237], [-118.1038, 34.193], [-118.104, 34.19328], [-118.10044, 34.19324], [-118.10041, 34.1896], [-118.10041, 34.18951], [-118.10037, 34.18595], [-118.10038, 34.18582], [-118.10173, 34.18646], [-118.10183, 34.18719], [-118.1017, 34.1876], [-118.10216, 34.18872], [-118.10269, 34.18896], [-118.10291, 34.18931], [-118.10293, 34.18951], [-118.10319, 34.19046], [-118.10314, 34.19063], [-118.10327, 34.19076], [-118.10336, 34.19121], [-118.10395, 34.19177], [-118.10426, 34.19224], [-118.10479, 34.19236], [-118.10512, 34.19263]]], [[[-118.10571, 34.19254], [-118.10563, 34.19268], [-118.10553, 34.1927], [-118.10502, 34.19312], [-118.10516, 34.19262], [-118.10481, 34.19233], [-118.10428, 34.19222], [-118.10398, 34.19175], [-118.10339, 34.1912], [-118.10331, 34.19075], [-118.10319, 34.19062], [-118.10324, 34.19046], [-118.10298, 34.18951], [-118.10295, 34.1893], [-118.10272, 34.18893], [-118.1022, 34.1887], [-118.10175, 34.18759], [-118.10186, 34.1872], [-118.10176, 34.18644], [-118.10069, 34.18594], [-118.10038, 34.18578], [-118.10038, 34.18574], [-118.10068, 34.18593], [-118.10069, 34.18592], [-118.10079, 34.18485], [-118.10155, 34.18475], [-118.101, 34.18412], [-118.10077, 34.18394], [-118.10058, 34.18376], [-118.10078, 34.1839], [-118.10092, 34.18397], [-118.10117, 34.18406], [-118.10152, 34.18424], [-118.10166, 34.18435], [-118.10214, 34.1848], [-118.10237, 34.18498], [-118.10214, 34.18519], [-118.10241, 34.18574], [-118.10243, 34.18574], [-118.10251, 34.18568], [-118.10281, 34.18591], [-118.10321, 34.18648], [-118.10296, 34.18664], [-118.10296, 34.18666], [-118.10326, 34.18664], [-118.10359, 34.18659], [-118.10361, 34.18666], [-118.10381, 34.18697], [-118.10372, 34.18768], [-118.10397, 34.18819], [-118.10412, 34.18822], [-118.10441, 34.18852], [-118.10486, 34.18921], [-118.10493, 34.18974], [-118.10492, 34.19033], [-118.10482, 34.19037], [-118.10459, 34.19071], [-118.10473, 34.19087], [-118.10491, 34.19087], [-118.10491, 34.19109], [-118.10516, 34.19141], [-118.10541, 34.19194], [-118.10545, 34.19211], [-118.10571, 34.19254]]], [[[-118.10683, 34.19331], [-118.1061, 34.19332], [-118.10604, 34.1933], [-118.1053, 34.1933], [-118.10529, 34.19326], [-118.10508, 34.1933], [-118.10505, 34.19327], [-118.10561, 34.19283], [-118.10575, 34.1928], [-118.10589, 34.19253], [-118.10561, 34.19205], [-118.10558, 34.19192], [-118.10588, 34.19227], [-118.10683, 34.19331]]]]} | Open Access 1 | 48133 | Eaton Canyon Natural Area Park and Nature Center | 32658 | 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 | https://www.ecnca.org/index.php | Los Angeles 6 | 82.896 | Eaton Canyon Natural Area Park and Nature Ctr. | 0 | Local Park 2 | 4 |
9797 | 9797 | 9796 | {"type": "Polygon", "coordinates": [[[-120.62079, 34.9228], [-120.61833, 34.92572], [-120.61614, 34.92667], [-120.61284, 34.92723], [-120.61082, 34.9285], [-120.60801, 34.92843], [-120.60579, 34.92913], [-120.60323, 34.92864], [-120.6034, 34.92007], [-120.60505, 34.91213], [-120.60601, 34.91131], [-120.61581, 34.91629], [-120.61728, 34.9197], [-120.62079, 34.9228]]]} | Open Access 1 | 16700 | Guadalupe Dunes County Park | 11773 | 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 | https://www.countyofsb.org/parks/parks02.aspx?id=13422 | Santa Barbara 7 | 505.539 | Guadalupe Dunes County Park | 0 | Local Park 2 | 4 |
9798 | 9798 | 9797 | {"type": "Polygon", "coordinates": [[[-120.65717, 34.9522], [-120.65432, 34.95978], [-120.6519, 34.96646], [-120.65078, 34.97051], [-120.64878, 34.96944], [-120.64914, 34.96875], [-120.64889, 34.96826], [-120.64937, 34.96772], [-120.64677, 34.96656], [-120.64661, 34.96442], [-120.64568, 34.96166], [-120.64502, 34.96078], [-120.64471, 34.96016], [-120.64403, 34.95965], [-120.64345, 34.95932], [-120.64321, 34.9592], [-120.64235, 34.95893], [-120.64056, 34.95849], [-120.64021, 34.95863], [-120.63876, 34.95838], [-120.63834, 34.95875], [-120.6378, 34.9583], [-120.63663, 34.9577], [-120.63662, 34.95771], [-120.63659, 34.95879], [-120.63347, 34.95834], [-120.63251, 34.95793], [-120.63144, 34.95778], [-120.63125, 34.95708], [-120.6326, 34.95643], [-120.63361, 34.95661], [-120.63361, 34.95605], [-120.63038, 34.95437], [-120.63021, 34.95408], [-120.63031, 34.95324], [-120.62935, 34.95269], [-120.62838, 34.95091], [-120.6414, 34.95112], [-120.64138, 34.95191], [-120.65717, 34.9522]]]} | Open Access 1 | 16704 | Guadalupe-Nipomo Dunes Preserve Forest | 28194 | 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 | https://www.countyofsb.org/parks/parks02.aspx?id=13422 | Santa Barbara 7 | 611.44 | Guadalupe-Nipomo Dunes Preserve Forest | 0 | Local Conservation Area 4 | 2 |
3487 | 3487 | 3486 | {"type": "Polygon", "coordinates": [[[-120.42216, 34.84972], [-120.42192, 34.85046], [-120.42153, 34.85094], [-120.42161, 34.85109], [-120.42151, 34.85123], [-120.42113, 34.85129], [-120.42097, 34.852], [-120.4202, 34.85238], [-120.42045, 34.85272], [-120.42027, 34.85283], [-120.41993, 34.85247], [-120.41927, 34.85288], [-120.41925, 34.85304], [-120.41877, 34.85301], [-120.4185, 34.85298], [-120.41851, 34.85295], [-120.41878, 34.85272], [-120.41876, 34.85243], [-120.41873, 34.85237], [-120.41785, 34.85177], [-120.41792, 34.85149], [-120.41769, 34.85134], [-120.41774, 34.85092], [-120.4174, 34.85061], [-120.41773, 34.85045], [-120.41787, 34.85016], [-120.41891, 34.85012], [-120.41919, 34.84959], [-120.4196, 34.84947], [-120.42048, 34.84963], [-120.42153, 34.84925], [-120.422, 34.8495], [-120.42216, 34.84972]]]} | Open Access 1 | 48769 | Orcutt Community Park | 33496 | 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 | https://www.countyofsb.org/parks/asset.c/581 | Santa Barbara 7 | 26.01 | Orcutt Community 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]);