units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,219 rows where MNG_AG_TYP = 3 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, COUNTY, YR_EST
DES_TP 114
- Local Park 651
- Local Other or Unknown 214
- Local Recreation Area 117
- Local Conservation Area 103
- Local Historic or Cultural Area 21
- 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
- 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
- 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
- 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
- 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
- None 1
MNG_AGENCY 51
- Los Angeles, County of 175
- San Diego, County of 123
- Santa Barbara, County of 119
- Orange, County of 95
- Lake, County of 56
- Sacramento, County of 56
- Butte, County of 53
- Santa Cruz, County of 51
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 44
- Riverside, County of 39
- San Luis Obispo, County of 31
- Placer, County of 28
- 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
- Humboldt, County of 12
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- Napa, County of 5
- Modoc, County of 5
- San Benito, County of 4
- Kings, County of 4
- Yuba, County of 4
- Plumas, County of 4
- Contra Costa, County of 3
- Siskiyou, County of 2
- Tuolumne, County of 2
- Glenn, County of 2
- Amador, County of 2
- Trinity, County of 2
- Sutter, County of 2
- Calaveras, County of 2
- Inyo, County of 1
- Shasta, County of 1
- Madera, County of 1
- Marin, County of 1
- Solano, County of 1
- Colusa, County of 1
- Sierra, County of 1
- Nevada, County of 1
ACCESS_TYP 4
- Open Access 1,098
- Restricted Access 59
- Unknown Access 36
- No Public Access 26
MNG_AG_TYP 1
- County Agency · 1,219 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10194 | 10194 | 10193 | {"type": "Polygon", "coordinates": [[[-121.50093, 38.38366], [-121.50055, 38.40726], [-121.48383, 38.4073], [-121.48084, 38.39263], [-121.48044, 38.39052], [-121.48034, 38.38942], [-121.48005, 38.38793], [-121.47955, 38.38591], [-121.47905, 38.38352], [-121.50093, 38.38366]]]} | Open Access 1 | 20523 | Stone Lakes | 1757 | 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 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.regionalparks.saccounty.net/Parks/OpenSpaces/Pages/StoneLakesNationalWildlifeRefuge.aspx | Sacramento 41 | 1095.222 | Stone Lakes | None 886 | ||
3859 | 3859 | 3858 | {"type": "Polygon", "coordinates": [[[-121.07323, 38.69837], [-121.07321, 38.6984], [-121.07313, 38.70002], [-121.06967, 38.70001], [-121.06953, 38.6998], [-121.06985, 38.69961], [-121.06969, 38.69932], [-121.06892, 38.69873], [-121.06847, 38.69873], [-121.06847, 38.69719], [-121.06916, 38.69701], [-121.07064, 38.69704], [-121.07077, 38.69706], [-121.0719, 38.6973], [-121.07303, 38.69718], [-121.07311, 38.69721], [-121.07316, 38.69744], [-121.07321, 38.69791], [-121.07323, 38.69837]]]} | Open Access 1 | 35586 | Regional Park | 3446 | 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 | El Dorado 34 | 29.185 | RP | 0 | Local Park 2 | 4 | |
3882 | 3882 | 3881 | {"type": "Polygon", "coordinates": [[[-121.05744, 38.6923], [-121.05686, 38.69256], [-121.05671, 38.69203], [-121.05697, 38.69203], [-121.05725, 38.69199], [-121.05729, 38.69201], [-121.05744, 38.6923]]]} | Open Access 1 | 35716 | Regional Park | 3446 | 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 | El Dorado 34 | 0.621 | RP | 0 | Local Park 2 | 4 | |
4941 | 4941 | 4940 | {"type": "Polygon", "coordinates": [[[-121.07045, 38.671], [-121.07044, 38.67105], [-121.07017, 38.67151], [-121.07012, 38.67153], [-121.06933, 38.67126], [-121.06923, 38.67118], [-121.0692, 38.67109], [-121.06921, 38.67095], [-121.06927, 38.67084], [-121.06939, 38.67073], [-121.06953, 38.67069], [-121.06965, 38.67071], [-121.07037, 38.67096], [-121.07045, 38.671]]]} | Open Access 1 | 36177 | Regional Park | 3446 | 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 | El Dorado 34 | 1.592 | RP | 0 | Local Park 2 | 4 | |
4999 | 4999 | 4998 | {"type": "Polygon", "coordinates": [[[-121.10284, 38.70346], [-121.1008, 38.70493], [-121.09984, 38.70559], [-121.09959, 38.70573], [-121.09878, 38.70631], [-121.0987, 38.7063], [-121.09854, 38.70613], [-121.09823, 38.70593], [-121.09863, 38.70546], [-121.09791, 38.70516], [-121.09839, 38.70299], [-121.0996, 38.70294], [-121.10033, 38.70258], [-121.10062, 38.70226], [-121.10065, 38.70178], [-121.10041, 38.70147], [-121.09999, 38.70143], [-121.098, 38.70176], [-121.09805, 38.70154], [-121.09838, 38.70118], [-121.09916, 38.70061], [-121.09952, 38.70029], [-121.09944, 38.69988], [-121.10089, 38.69989], [-121.10167, 38.70086], [-121.10202, 38.70147], [-121.10272, 38.70215], [-121.10187, 38.7028], [-121.10284, 38.70346]]]} | Open Access 1 | 35583 | Regional Park | 3446 | 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 | El Dorado 34 | 39.43 | RP | 0 | Local Park 2 | 4 | |
5001 | 5001 | 5000 | {"type": "Polygon", "coordinates": [[[-121.04869, 38.68669], [-121.04729, 38.68674], [-121.0448, 38.68651], [-121.04586, 38.68586], [-121.04702, 38.68637], [-121.04817, 38.68632], [-121.0483, 38.68644], [-121.04865, 38.68664], [-121.04869, 38.68669]]]} | Open Access 1 | 35595 | Regional Park | 3446 | 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 | El Dorado 34 | 3.777 | RP | 0 | Local Park 2 | 4 | |
12696 | 12696 | 12695 | {"type": "Polygon", "coordinates": [[[-121.0719, 38.67814], [-121.07125, 38.67814], [-121.07105, 38.67682], [-121.06976, 38.67683], [-121.06915, 38.6752], [-121.06924, 38.67517], [-121.06929, 38.67514], [-121.06934, 38.67507], [-121.06935, 38.675], [-121.0693, 38.67491], [-121.06916, 38.67483], [-121.06914, 38.67481], [-121.06889, 38.67414], [-121.06892, 38.67408], [-121.06921, 38.67401], [-121.06925, 38.67401], [-121.06929, 38.67404], [-121.06892, 38.67413], [-121.069, 38.67433], [-121.06921, 38.67479], [-121.06933, 38.67486], [-121.0694, 38.67497], [-121.0694, 38.67506], [-121.06937, 38.67514], [-121.06926, 38.67522], [-121.06961, 38.67617], [-121.06969, 38.67644], [-121.06978, 38.67665], [-121.06983, 38.67669], [-121.06991, 38.67675], [-121.07001, 38.67677], [-121.07014, 38.67678], [-121.07018, 38.67648], [-121.07022, 38.67649], [-121.07022, 38.67677], [-121.07119, 38.67676], [-121.07122, 38.67688], [-121.0713, 38.67766], [-121.07134, 38.67786], [-121.0714, 38.67806], [-121.07178, 38.678], [-121.0718, 38.67806], [-121.0719, 38.67814]]]} | Open Access 1 | 35750 | Regional Park | 3446 | 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 | El Dorado 34 | 1.364 | RP | 0 | Local Park 2 | 4 | |
13452 | 13452 | 13451 | {"type": "Polygon", "coordinates": [[[-121.05734, 38.6586], [-121.05697, 38.65922], [-121.05661, 38.65869], [-121.05709, 38.65863], [-121.05734, 38.6586]]]} | Open Access 1 | 35646 | Regional Park | 3446 | 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 | El Dorado 34 | 0.505 | RP | 0 | Local Park 2 | 4 | |
13645 | 13645 | 13644 | {"type": "Polygon", "coordinates": [[[-120.98031, 38.61693], [-120.98021, 38.62778], [-120.97558, 38.62784], [-120.97572, 38.61698], [-120.98031, 38.61693]]]} | Open Access 1 | 36004 | Regional Park | 3446 | 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 | El Dorado 34 | 119.729 | RP | 0 | Local Park 2 | 4 | |
13742 | 13742 | 13741 | {"type": "Polygon", "coordinates": [[[-121.05662, 38.69141], [-121.05642, 38.69185], [-121.05575, 38.69165], [-121.05573, 38.69161], [-121.05582, 38.69135], [-121.05583, 38.69114], [-121.05578, 38.69094], [-121.05569, 38.69078], [-121.05569, 38.69074], [-121.05633, 38.69113], [-121.05662, 38.69141]]]} | Open Access 1 | 36231 | Regional Park | 3446 | 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 | El Dorado 34 | 1.288 | RP | 0 | Local Park 2 | 4 | |
15922 | 15922 | 15921 | {"type": "Polygon", "coordinates": [[[-121.06556, 38.67259], [-121.06499, 38.6728], [-121.06499, 38.67301], [-121.06459, 38.67315], [-121.06427, 38.67325], [-121.06375, 38.67338], [-121.06288, 38.67357], [-121.06272, 38.67359], [-121.06266, 38.67361], [-121.06261, 38.67368], [-121.06243, 38.67372], [-121.06232, 38.67376], [-121.06063, 38.67427], [-121.06069, 38.67449], [-121.05988, 38.67448], [-121.06, 38.67429], [-121.06016, 38.67397], [-121.06047, 38.67312], [-121.06059, 38.67286], [-121.06088, 38.6724], [-121.06112, 38.6721], [-121.06142, 38.6718], [-121.06148, 38.6718], [-121.06156, 38.67184], [-121.06176, 38.67167], [-121.0617, 38.67159], [-121.06172, 38.67155], [-121.06231, 38.6711], [-121.06301, 38.67066], [-121.06361, 38.67034], [-121.06367, 38.67035], [-121.06372, 38.67038], [-121.0646, 38.67144], [-121.06459, 38.67148], [-121.06452, 38.67154], [-121.06468, 38.67173], [-121.06479, 38.6717], [-121.06484, 38.67172], [-121.06556, 38.67259]]]} | Open Access 1 | 36092 | Regional Park | 3446 | 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 | El Dorado 34 | 26.653 | RP | 0 | Local Park 2 | 4 | |
15954 | 15954 | 15953 | {"type": "Polygon", "coordinates": [[[-121.05668, 38.65716], [-121.05575, 38.65747], [-121.05336, 38.6575], [-121.05293, 38.65629], [-121.05425, 38.65629], [-121.05425, 38.65536], [-121.05463, 38.65525], [-121.05522, 38.65497], [-121.05577, 38.65442], [-121.05556, 38.65493], [-121.05554, 38.65524], [-121.05582, 38.65559], [-121.05668, 38.65716]]]} | Open Access 1 | 36171 | Regional Park | 3446 | 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 | El Dorado 34 | 13.896 | RP | 0 | Local Park 2 | 4 | |
15955 | 15955 | 15954 | {"type": "Polygon", "coordinates": [[[-121.07146, 38.66759], [-121.07144, 38.66762], [-121.07138, 38.66763], [-121.0708, 38.66758], [-121.07072, 38.66757], [-121.07068, 38.66754], [-121.07067, 38.66751], [-121.07146, 38.66759]]]} | Open Access 1 | 36172 | Regional Park | 3446 | 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 | El Dorado 34 | 0.089 | RP | 0 | Local Park 2 | 4 | |
15977 | 15977 | 15976 | {"type": "Polygon", "coordinates": [[[-121.06264, 38.65516], [-121.05708, 38.65702], [-121.05667, 38.65629], [-121.05631, 38.65573], [-121.05615, 38.6554], [-121.05596, 38.65444], [-121.05597, 38.6544], [-121.05612, 38.65433], [-121.05667, 38.65297], [-121.05777, 38.65173], [-121.05826, 38.65113], [-121.05869, 38.65075], [-121.0587, 38.65398], [-121.06105, 38.65445], [-121.06106, 38.65385], [-121.06199, 38.65386], [-121.062, 38.65468], [-121.06264, 38.65516]]]} | Open Access 1 | 36657 | Regional Park | 3446 | 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 | El Dorado 34 | 41.608 | RP | 0 | Local Park 2 | 4 | |
16289 | 16289 | 16288 | {"type": "Polygon", "coordinates": [[[-121.05513, 38.69049], [-121.0554, 38.69073], [-121.05549, 38.69078], [-121.05557, 38.69088], [-121.05563, 38.691], [-121.05567, 38.69112], [-121.05567, 38.69127], [-121.05564, 38.69141], [-121.05557, 38.69155], [-121.05555, 38.69157], [-121.05549, 38.69157], [-121.05446, 38.69138], [-121.0542, 38.6913], [-121.05396, 38.6912], [-121.05363, 38.69101], [-121.05244, 38.69012], [-121.0522, 38.69], [-121.05197, 38.68993], [-121.05178, 38.68989], [-121.05154, 38.68988], [-121.05095, 38.68992], [-121.05055, 38.68998], [-121.04989, 38.69013], [-121.04947, 38.68943], [-121.05126, 38.68838], [-121.05124, 38.68772], [-121.05038, 38.68721], [-121.04919, 38.6867], [-121.04884, 38.6867], [-121.04869, 38.68656], [-121.04838, 38.68637], [-121.04831, 38.68631], [-121.04855, 38.6863], [-121.04879, 38.68604], [-121.04843, 38.68549], [-121.04912, 38.68512], [-121.0495, 38.68544], [-121.04917, 38.68586], [-121.04997, 38.68622], [-121.05115, 38.68635], [-121.05125, 38.68587], [-121.05146, 38.6859], [-121.0514, 38.68641], [-121.05224, 38.68703], [-121.05243, 38.68766], [-121.05249, 38.68826], [-121.05257, 38.68865], [-121.05275, 38.68902], [-121.05305, 38.68939], [-121.05441, 38.69058], [-121.0547, 38.69082], [-121.05513, 38.69049]]]} | Open Access 1 | 35605 | Regional Park | 3446 | 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 | El Dorado 34 | 28.5 | RP | 0 | Local Park 2 | 4 | |
16293 | 16293 | 16292 | {"type": "MultiPolygon", "coordinates": [[[[-121.06093, 38.67132], [-121.06085, 38.67139], [-121.06073, 38.67131], [-121.06076, 38.67126], [-121.06083, 38.67125], [-121.06093, 38.67132]]], [[[-121.06114, 38.67115], [-121.06106, 38.67123], [-121.06097, 38.67114], [-121.06099, 38.6711], [-121.06103, 38.67107], [-121.06114, 38.67115]]]]} | Open Access 1 | 35747 | Regional Park | 3446 | 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 | El Dorado 34 | 0.07 | RP | 0 | Local Park 2 | 4 | |
16303 | 16303 | 16302 | {"type": "Polygon", "coordinates": [[[-121.05729, 38.65827], [-121.05645, 38.65846], [-121.05615, 38.65803], [-121.05704, 38.65778], [-121.05729, 38.65827]]]} | Open Access 1 | 35748 | Regional Park | 3446 | 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 | El Dorado 34 | 1.092 | RP | 0 | Local Park 2 | 4 | |
16386 | 16386 | 16385 | {"type": "Polygon", "coordinates": [[[-121.05687, 38.66352], [-121.05668, 38.66357], [-121.05641, 38.6636], [-121.05543, 38.66361], [-121.05519, 38.66358], [-121.05513, 38.66355], [-121.05687, 38.66352]]]} | Open Access 1 | 35695 | Regional Park | 3446 | 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 | El Dorado 34 | 0.233 | RP | 0 | Local Park 2 | 4 | |
16387 | 16387 | 16386 | {"type": "MultiPolygon", "coordinates": [[[[-121.05229, 38.68426], [-121.0523, 38.68435], [-121.05233, 38.68444], [-121.05229, 38.68449], [-121.05222, 38.6845], [-121.05206, 38.68449], [-121.05189, 38.68444], [-121.0517, 38.68441], [-121.05154, 38.68441], [-121.05137, 38.68444], [-121.0512, 38.68449], [-121.051, 38.6846], [-121.05089, 38.68468], [-121.05072, 38.68487], [-121.05049, 38.68437], [-121.05057, 38.68434], [-121.05073, 38.68461], [-121.05078, 38.68459], [-121.05105, 38.6844], [-121.05134, 38.68431], [-121.05177, 38.68431], [-121.05201, 38.68437], [-121.05202, 38.68442], [-121.05227, 38.68445], [-121.05226, 38.68422], [-121.05229, 38.68426]]], [[[-121.0531, 38.68377], [-121.05313, 38.68416], [-121.05309, 38.68419], [-121.05298, 38.68422], [-121.05297, 38.68418], [-121.05301, 38.68417], [-121.05304, 38.68413], [-121.05296, 38.68392], [-121.05295, 38.68383], [-121.05296, 38.68375], [-121.0531, 38.68377]]], [[[-121.05327, 38.68461], [-121.05317, 38.68466], [-121.05315, 38.68457], [-121.05303, 38.68433], [-121.05311, 38.68432], [-121.05317, 38.68435], [-121.05327, 38.68461]]]]} | Open Access 1 | 35603 | Regional Park | 3446 | 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 | El Dorado 34 | 0.803 | RP | 0 | Local Park 2 | 4 | |
16388 | 16388 | 16387 | {"type": "MultiPolygon", "coordinates": [[[[-121.08281, 38.69679], [-121.0827, 38.69681], [-121.08262, 38.69656], [-121.08179, 38.69565], [-121.08202, 38.69553], [-121.08216, 38.69543], [-121.08223, 38.69525], [-121.08224, 38.69511], [-121.08178, 38.69355], [-121.0817, 38.69342], [-121.08158, 38.69336], [-121.08142, 38.69332], [-121.08125, 38.69333], [-121.08106, 38.69337], [-121.08095, 38.69307], [-121.07872, 38.69349], [-121.07894, 38.69311], [-121.079, 38.69292], [-121.07898, 38.69266], [-121.07955, 38.69254], [-121.07971, 38.69249], [-121.07975, 38.69244], [-121.08147, 38.69211], [-121.08281, 38.69679]]], [[[-121.08743, 38.69182], [-121.08539, 38.69223], [-121.08511, 38.69225], [-121.08486, 38.69232], [-121.08291, 38.69269], [-121.08285, 38.69269], [-121.08207, 38.69285], [-121.08203, 38.69273], [-121.08212, 38.6927], [-121.08202, 38.69269], [-121.08184, 38.69204], [-121.08716, 38.69104], [-121.08743, 38.69182]]], [[[-121.10511, 38.68893], [-121.10487, 38.68906], [-121.10399, 38.68921], [-121.10386, 38.68875], [-121.10202, 38.68903], [-121.09413, 38.69054], [-121.09406, 38.69047], [-121.09402, 38.69045], [-121.09254, 38.69069], [-121.09243, 38.68986], [-121.10218, 38.68825], [-121.10217, 38.68823], [-121.09935, 38.68706], [-121.09897, 38.68683], [-121.09882, 38.68668], [-121.09865, 38.68653], [-121.09837, 38.68642], [-121.09884, 38.6859], [-121.09884, 38.68573], [-121.10051, 38.68671], [-121.10072, 38.68685], [-121.10101, 38.68692], [-121.10121, 38.68699], [-121.10141, 38.68702], [-121.10205, 38.68706], [-121.10276, 38.68721], [-121.10315, 38.68734], [-121.10364, 38.68746], [-121.10445, 38.68755], [-121.10511, 38.68893]]]]} | Open Access 1 | 35579 | Regional Park | 3446 | 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 | El Dorado 34 | 56.222 | RP | 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]);