units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
651 rows where DES_TP = 2 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- El Dorado, County of 31
- Los Angeles, County of 20
- San Diego, County of 13
- Orange, County of 11
- Monterey, County of 5
- Placer, County of 5
- San Bernardino, County of 5
- Lake, County of 4
- Riverside, County of 3
- Kern, County of 3
- Humboldt, County of 3
- Mendocino, County of 3
- Lassen, County of 3
- Contra Costa, County of 3
- San Luis Obispo, County of 2
- Ventura, County of 2
- San Joaquin, County of 2
- Stanislaus, County of 2
- Tehama, County of 2
- Calaveras, County of 2
- Imperial, County of 1
- Merced, County of 1
- Yolo, County of 1
- Sacramento, County of 1
- Siskiyou, County of 1
- Modoc, County of 1
- Plumas, County of 1
- Tuolumne, County of 1
- Butte, County of 1
- Glenn, County of 1
- …
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 137 ✖
DES_TP 1
- Local Park · 137 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
13454 | 13454 | 13453 | {"type": "Polygon", "coordinates": [[[-116.39879, 33.82366], [-116.39697, 33.82366], [-116.39696, 33.82193], [-116.39701, 33.82189], [-116.39701, 33.82177], [-116.39697, 33.82173], [-116.39696, 33.8216], [-116.39701, 33.82156], [-116.39701, 33.82145], [-116.39697, 33.82139], [-116.39697, 33.82105], [-116.39702, 33.821], [-116.39702, 33.82089], [-116.39697, 33.82084], [-116.39697, 33.8205], [-116.39702, 33.82045], [-116.39701, 33.82032], [-116.39697, 33.82028], [-116.39698, 33.82013], [-116.39701, 33.8201], [-116.39879, 33.8201], [-116.39879, 33.82366]]]} | Restricted Access 2 | 35667 | Thousand Palms Community Park | 31650 | 2318 | Palm Springs Unified School District 1058 | Special District 4 | School District 14 | http://www.psusd.us/ | Special District 4 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 16.4 | Thousand Palms Community Park | 0 | Local Park 2 | 4 | |
13498 | 13498 | 13497 | {"type": "Polygon", "coordinates": [[[-117.99482, 34.0355], [-117.99427, 34.03605], [-117.99393, 34.03583], [-117.99375, 34.036], [-117.99242, 34.03508], [-117.99314, 34.03435], [-117.99482, 34.0355]]]} | Open Access 1 | 45698 | Avenue Park | 28597 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Avenue_Park | Los Angeles 6 | 4.957 | Avenue Park | 0 | Local Park 2 | 4 |
13592 | 13592 | 13591 | {"type": "Polygon", "coordinates": [[[-122.67605, 39.02326], [-122.67603, 39.0234], [-122.67559, 39.02335], [-122.67556, 39.02348], [-122.67511, 39.02344], [-122.67522, 39.02283], [-122.67546, 39.02268], [-122.67605, 39.02326]]]} | Open Access 1 | 35927 | Nylander County Park | 31180 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.079 | Nylander County Park | 0 | Local Park 2 | 4 | |
13600 | 13600 | 13599 | {"type": "Polygon", "coordinates": [[[-122.63516, 38.74947], [-122.63921, 38.75517], [-122.63967, 38.75585], [-122.63994, 38.75632], [-122.64033, 38.75706], [-122.6411, 38.75872], [-122.64111, 38.75882], [-122.64108, 38.75887], [-122.64102, 38.75892], [-122.64095, 38.75895], [-122.64084, 38.75895], [-122.64033, 38.75884], [-122.63064, 38.75622], [-122.63516, 38.74947]]]} | Open Access 1 | 35941 | Middleton Trailside Park | 31182 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 106.712 | Middleton Trailside Park | 0 | Local Park 2 | 4 | |
13630 | 13630 | 13629 | {"type": "Polygon", "coordinates": [[[-122.86885, 39.12496], [-122.86874, 39.1253], [-122.86734, 39.12488], [-122.86722, 39.12495], [-122.867, 39.12504], [-122.86675, 39.12513], [-122.86661, 39.1252], [-122.86634, 39.12572], [-122.86476, 39.12547], [-122.8655, 39.12316], [-122.86581, 39.12261], [-122.86586, 39.12261], [-122.86608, 39.12222], [-122.86677, 39.12251], [-122.86602, 39.12361], [-122.86717, 39.12424], [-122.86885, 39.12496]]]} | Open Access 1 | 35982 | Hammond Avenue Park | 31181 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 12.675 | Hammond Avenue Park | 0 | Local Park 2 | 4 | |
13639 | 13639 | 13638 | {"type": "Polygon", "coordinates": [[[-121.26874, 38.53018], [-121.2687, 38.53502], [-121.26111, 38.53501], [-121.26109, 38.54475], [-121.26089, 38.54464], [-121.26088, 38.54413], [-121.25886, 38.54414], [-121.25633, 38.54454], [-121.25597, 38.54464], [-121.25564, 38.54479], [-121.25542, 38.54493], [-121.25426, 38.54579], [-121.2541, 38.54594], [-121.25402, 38.54608], [-121.25397, 38.54623], [-121.25397, 38.54664], [-121.25227, 38.54904], [-121.2513, 38.55025], [-121.25199, 38.55103], [-121.25238, 38.55116], [-121.25363, 38.55257], [-121.25416, 38.55259], [-121.25423, 38.55434], [-121.25474, 38.55457], [-121.25778, 38.55443], [-121.25843, 38.55461], [-121.25845, 38.55481], [-121.25864, 38.55486], [-121.25868, 38.55468], [-121.25898, 38.55476], [-121.25975, 38.55439], [-121.26094, 38.5544], [-121.26093, 38.55672], [-121.26216, 38.55957], [-121.26093, 38.55956], [-121.26092, 38.55945], [-121.25463, 38.5594], [-121.25465, 38.55926], [-121.25464, 38.55909], [-121.2546, 38.55895], [-121.25454, 38.55879], [-121.25444, 38.55864], [-121.25434, 38.55852], [-121.2542, 38.55839], [-121.25404, 38.55828], [-121.25374, 38.55814], [-121.25337, 38.55805], [-121.2528, 38.55794], [-121.251, 38.55763], [-121.25056, 38.5575], [-121.25019, 38.55734], [-121.24995, 38.55721], [-121.24972, 38.55706], [-121.24562, 38.55413], [-121.24536, 38.5539], [-121.24523, 38.55376], [-121.24482, 38.55281], [-121.24492, 38.55137], [-121.24467, 38.54633], [-121.24474, 38.5401], [-121.2446, 38.53844], [-121.24457, 38.52893], [-121.24472, 38.52761], [-121.24488, 38.52634], [-121.24503, 38.52572], [-121.25171, 38.52563], [-121.25181, 38.52564], [-121.26099, 38.52833], [-121.26874, 38.53018]]]} | Open Access 1 | 36000 | Mather Regional Park | 9992 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.regionalparks.saccounty.net/Parks/RegionalParksDetails/Pages/MatherRegionalPark.aspx | Sacramento 41 | 1144.635 | Mather 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 | |
13686 | 13686 | 13685 | {"type": "Polygon", "coordinates": [[[-121.3073, 37.78699], [-121.30725, 37.78709], [-121.30726, 37.78716], [-121.30443, 37.78792], [-121.30469, 37.78763], [-121.30484, 37.7875], [-121.30653, 37.7863], [-121.30659, 37.78638], [-121.3073, 37.78699]]]} | Open Access 1 | 36070 | Mossdale Crossing Park | 22513 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 4.049 | Mossdale Crossing Park | 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 | |
13926 | 13926 | 13925 | {"type": "Polygon", "coordinates": [[[-121.64339, 36.88847], [-121.64319, 36.88849], [-121.64313, 36.88847], [-121.6431, 36.88843], [-121.64306, 36.88816], [-121.64333, 36.88813], [-121.64339, 36.88847]]]} | Open Access 1 | 36553 | Aromas Community Park | 28587 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 0.23 | Aromas Community Park | 0 | Local Park 2 | 4 | |
14193 | 14193 | 14192 | {"type": "Polygon", "coordinates": [[[-120.8994, 35.44501], [-120.89928, 35.44513], [-120.89917, 35.44528], [-120.8991, 35.44542], [-120.89902, 35.44564], [-120.89897, 35.44571], [-120.89886, 35.44584], [-120.89882, 35.44596], [-120.89867, 35.44589], [-120.89871, 35.44576], [-120.89885, 35.44561], [-120.89897, 35.4453], [-120.89912, 35.44507], [-120.89925, 35.44494], [-120.8994, 35.44501]]]} | Open Access 1 | 44028 | Paul Andrew Park | 33176 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | https://slocountyparks.com/day-use-parks/paul-andrew-park/ | San Luis Obispo 1 | 0.448 | Paul Andrew Park | 0 | Local Park 2 | 4 |
14206 | 14206 | 14205 | {"type": "MultiPolygon", "coordinates": [[[[-120.64475, 35.29287], [-120.64465, 35.29305], [-120.64413, 35.29433], [-120.64404, 35.29441], [-120.64389, 35.29445], [-120.64286, 35.29441], [-120.64292, 35.29421], [-120.6425, 35.29418], [-120.64267, 35.29411], [-120.64372, 35.29308], [-120.64418, 35.29278], [-120.64434, 35.29269], [-120.64475, 35.29287]]], [[[-120.64377, 35.29458], [-120.6437, 35.29472], [-120.64281, 35.29519], [-120.64277, 35.29455], [-120.64377, 35.29458]]]]} | Open Access 1 | 44067 | Cuesta Canyon County Park | 17849 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 5.731 | Cuesta Canyon County Park | 0 | Local Park 2 | 4 | |
14225 | 14225 | 14224 | {"type": "Polygon", "coordinates": [[[-121.20513, 38.75006], [-121.2051, 38.75074], [-121.20505, 38.75091], [-121.20505, 38.75097], [-121.20469, 38.75097], [-121.20469, 38.75085], [-121.20425, 38.75085], [-121.20424, 38.75095], [-121.20296, 38.75098], [-121.20298, 38.75003], [-121.20359, 38.75003], [-121.20394, 38.75008], [-121.20513, 38.75006]]]} | Open Access 1 | 44180 | Douglas Ranch Park | 18247 | 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 | Placer 35 | 4.525 | Douglas Ranch Park | 0 | Local Park 2 | 4 | |
14245 | 14245 | 14244 | {"type": "Polygon", "coordinates": [[[-118.03024, 34.15973], [-118.02975, 34.15977], [-118.0297, 34.1602], [-118.02916, 34.16008], [-118.02882, 34.16003], [-118.02852, 34.16], [-118.02806, 34.16001], [-118.02952, 34.15919], [-118.03012, 34.15918], [-118.03024, 34.15973]]]} | Restricted Access 2 | 44142 | Highland Oaks Park | 19930 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.851 | Highland Oaks Park | 0 | Local Park 2 | 4 | |
14261 | 14261 | 14260 | {"type": "Polygon", "coordinates": [[[-120.17516, 41.52787], [-120.17516, 41.5291], [-120.17369, 41.52908], [-120.1737, 41.52786], [-120.17516, 41.52787]]]} | Open Access 1 | 44218 | Modoc Park | 22346 | 341 | Modoc, County of 629 | County 3 | County Agency 3 | http://www.co.modoc.ca.us/departments/parks-recreation | County 3 | 341 | Modoc, County of 618 | County 3 | County Agency 3 | Modoc 56 | 4.118 | Modoc Park | 0 | Local Park 2 | 4 | |
14262 | 14262 | 14261 | {"type": "Polygon", "coordinates": [[[-120.88547, 38.99559], [-120.88476, 38.99803], [-120.88426, 38.99987], [-120.88414, 39.00024], [-120.88399, 39.00062], [-120.88211, 39.00029], [-120.88091, 39.00005], [-120.88049, 38.99993], [-120.87854, 38.99932], [-120.87858, 38.99925], [-120.87857, 38.99923], [-120.87529, 38.99813], [-120.87506, 38.99807], [-120.87516, 38.99801], [-120.87515, 38.99796], [-120.87786, 38.99721], [-120.87802, 38.9971], [-120.87996, 38.99662], [-120.88336, 38.99558], [-120.88347, 38.99558], [-120.88348, 38.99571], [-120.8839, 38.99572], [-120.88431, 38.99558], [-120.88547, 38.99559]]]} | Open Access 1 | 44181 | Todd Valley Pond Park | 26386 | 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 | Placer 35 | 67.976 | Todd Valley Pond Park | 0 | Local Park 2 | 4 | |
14292 | 14292 | 14291 | {"type": "Polygon", "coordinates": [[[-121.20948, 38.73356], [-121.20744, 38.73356], [-121.20743, 38.73275], [-121.20753, 38.73277], [-121.20762, 38.73275], [-121.20768, 38.7327], [-121.20772, 38.73262], [-121.20769, 38.73253], [-121.20756, 38.73245], [-121.20752, 38.73237], [-121.20748, 38.72982], [-121.20749, 38.72978], [-121.20751, 38.72976], [-121.20782, 38.72973], [-121.2081, 38.72968], [-121.20831, 38.7296], [-121.20865, 38.72945], [-121.20887, 38.72939], [-121.20912, 38.72935], [-121.20944, 38.72934], [-121.20948, 38.73356]]]} | Open Access 1 | 44226 | Ronald L. Feist Park | 24588 | 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 | Placer 35 | 18.832 | Ronald L. Feist Park | 0 | Local Park 2 | 4 | |
14293 | 14293 | 14292 | {"type": "Polygon", "coordinates": [[[-124.23254, 40.26773], [-124.2322, 40.26879], [-124.2322, 40.26882], [-124.23085, 40.26907], [-124.23083, 40.26963], [-124.22952, 40.26963], [-124.22932, 40.26935], [-124.22906, 40.2691], [-124.22878, 40.26892], [-124.22853, 40.2688], [-124.22824, 40.26872], [-124.22783, 40.26872], [-124.22766, 40.26887], [-124.22753, 40.26908], [-124.22742, 40.2694], [-124.22737, 40.26964], [-124.22653, 40.26964], [-124.22663, 40.26911], [-124.22669, 40.2689], [-124.22677, 40.26883], [-124.22695, 40.26874], [-124.22713, 40.26859], [-124.22729, 40.26842], [-124.22743, 40.26818], [-124.22764, 40.26797], [-124.22769, 40.2677], [-124.22769, 40.26741], [-124.22774, 40.26713], [-124.22776, 40.26676], [-124.22796, 40.2665], [-124.22833, 40.26628], [-124.22869, 40.2662], [-124.23016, 40.26621], [-124.23062, 40.26624], [-124.23162, 40.26643], [-124.23196, 40.26648], [-124.2323, 40.26669], [-124.23243, 40.2669], [-124.23252, 40.26726], [-124.23254, 40.26773]]]} | Open Access 1 | 44227 | Arthur W. Way Park | 15641 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 33.368 | Arthur W. Way Park | 0 | Local Park 2 | 4 | |
14295 | 14295 | 14294 | {"type": "Polygon", "coordinates": [[[-121.61997, 37.90654], [-121.61837, 37.90657], [-121.61747, 37.90656], [-121.61748, 37.90592], [-121.61867, 37.90531], [-121.61898, 37.90506], [-121.61898, 37.90495], [-121.61947, 37.90532], [-121.61964, 37.90549], [-121.61976, 37.90565], [-121.61987, 37.90588], [-121.61992, 37.90603], [-121.61995, 37.90619], [-121.61997, 37.90654]]]} | Open Access 1 | 44229 | Slifer Park | 25558 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | Contra Costa 12 | 6.525 | Slifer 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]);