superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,567 rows where ACCESS_TYP = 1 and MNG_AG_LEV = 4 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 139
- Consumnes Community Services District 92
- Hayward Area Recreation and Park District 77
- East Bay Regional Park District 73
- Valley-Wide Recreation and Park District 66
- Rancho Simi Recreation and Park District 51
- Conejo Recreation and Park District 41
- Sunrise Recreation and Park District 39
- Marin County Open Space District 38
- Southgate Recreation and Park District 38
- Cordova Recreation and Park District 36
- Greater Vallejo Recreation and Park District 32
- Conejo Open Space Conservation Agency 32
- Pleasant Valley Recreation and Park District 31
- North of the River Recreation and Park District 27
- El Dorado Hills Community Service District 24
- Midpeninsula Regional Open Space District 24
- Olivehurst Public Utility District 23
- San Diego Unified Port District 19
- Jurupa Area Recreation and Park District 18
- Monterey Peninsula Regional Park District 17
- Isla Vista Recreation and Park District 14
- Desert Recreation District 14
- Mission Oaks Recreation and Park District 14
- Apple Valley Recreation and Park District 13
- Fresno Metropolitan Flood Control District 13
- Pleasant Hill Recreation and Park District 12
- Carmichael Recreation and Park District 12
- Auburn Area Recreation and Park District 11
- North Highland Recreation and Park District 11
- …
MNG_AG_TYP 15
- Recreation/Parks District 931
- Community Services District 190
- Open Space District 182
- Water District 93
- Cemetery District 61
- Flood District 37
- Port/Harbor District 32
- Special District - Other 15
- Irrigation District 14
- Sanitation District 6
- Conservation District 2
- Airport District 1
- Metropolitan Planning Organization 1
- Fire District 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 1,567 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB ▼ | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
843 | 843 | 842 | {"type": "MultiPolygon", "coordinates": [[[[-118.63657, 34.26504], [-118.63633, 34.26516], [-118.63617, 34.26526], [-118.63601, 34.2654], [-118.63587, 34.26558], [-118.6358, 34.26572], [-118.63574, 34.26588], [-118.63571, 34.26605], [-118.63569, 34.26628], [-118.63564, 34.26647], [-118.63554, 34.26667], [-118.63539, 34.26684], [-118.63447, 34.26759], [-118.63418, 34.26779], [-118.63386, 34.26798], [-118.63327, 34.26823], [-118.63273, 34.2646], [-118.63657, 34.26504]]], [[[-118.63485, 34.26765], [-118.63449, 34.26821], [-118.63372, 34.26845], [-118.63334, 34.26871], [-118.63329, 34.2684], [-118.6338, 34.26819], [-118.63416, 34.26801], [-118.63449, 34.2678], [-118.63477, 34.26758], [-118.63485, 34.26765]]], [[[-118.65762, 34.27232], [-118.65772, 34.2726], [-118.65771, 34.27281], [-118.65769, 34.27297], [-118.65755, 34.27344], [-118.65753, 34.27346], [-118.65749, 34.27338], [-118.65642, 34.27257], [-118.65573, 34.27221], [-118.6555, 34.27195], [-118.65574, 34.2717], [-118.65574, 34.27168], [-118.65499, 34.27151], [-118.65408, 34.27081], [-118.65349, 34.27065], [-118.65242, 34.27019], [-118.65185, 34.27015], [-118.65094, 34.26998], [-118.65002, 34.26966], [-118.65005, 34.26918], [-118.64922, 34.26888], [-118.64886, 34.26879], [-118.64706, 34.26807], [-118.64679, 34.26814], [-118.64604, 34.26809], [-118.6458, 34.26796], [-118.64547, 34.26785], [-118.64495, 34.26758], [-118.64462, 34.26755], [-118.64414, 34.26724], [-118.64391, 34.26694], [-118.64358, 34.26675], [-118.64244, 34.26649], [-118.64221, 34.26578], [-118.64206, 34.2657], [-118.64022, 34.26616], [-118.63857, 34.266], [-118.63825, 34.26619], [-118.63802, 34.26604], [-118.63773, 34.26595], [-118.63661, 34.26612], [-118.63614, 34.26631], [-118.6356, 34.26704], [-118.6354, 34.2672], [-118.63532, 34.26713], [-118.6356, 34.26688], [-118.6357, 34.26676], [-118.63579, 34.26662], [-118.63588, 34.26636], [-118.63591, 34.26604], [-118.63594, 34.26588], [-118.636, 34.26574], [-118.63609, 34.2656], [-118.63624, 34.26544], [-118.63642, 34.2653], [-118.63663, 34.2652], [-118.63687, 34.26513], [-118.63725, 34.26529], [-118.63763, 34.2653], [-118.63817, 34.26541], [-118.6387, 34.26529], [-118.64734, 34.26629], [-118.64784, 34.26632], [-118.6482, 34.26631], [-118.64863, 34.26625], [-118.64905, 34.26617], [-118.64946, 34.26604], [-118.64985, 34.26589], [-118.65022, 34.26569], [-118.65061, 34.26543], [-118.65172, 34.26447], [-118.65208, 34.26407], [-118.65307, 34.2632], [-118.65352, 34.26283], [-118.65404, 34.26249], [-118.65457, 34.26292], [-118.65468, 34.26296], [-118.65481, 34.26299], [-118.65467, 34.26301], [-118.65448, 34.26298], [-118.6544, 34.26301], [-118.65435, 34.26305], [-118.65433, 34.2631], [-118.65433, 34.26316], [-118.65435, 34.2632], [-118.65288, 34.26389], [-118.65203, 34.26446], [-118.65231, 34.26447], [-118.65299, 34.26403], [-118.65496, 34.2631], [-118.65568, 34.26311], [-118.65571, 34.26352], [-118.65601, 34.26352], [-118.65602, 34.26311], [-118.65619, 34.26311], [-118.65614, 34.26652], [-118.6561, 34.26669], [-118.65643, 34.26684], [-118.65636, 34.26696], [-118.65626, 34.2677], [-118.65595, 34.26774], [-118.65595, 34.26944], [-118.6562, 34.26962], [-118.6563, 34.26981], [-118.65688, 34.27019], [-118.65701, 34.27046], [-118.65718, 34.27077], [-118.65734, 34.27095], [-118.6567, 34.2711], [-118.65679, 34.2714], [-118.65666, 34.27168], [-118.65762, 34.27232]]]]} | Open Access 1 | Corriganville Park | http://www.rsrpd.org/park/corrignavilleparkandtrail/corrignavilleparkandtrail.html | 8979 | 2117 | Rancho Simi Open Space Conservation Agency 342 | Special District 4 | Open Space District 6 | Special District 4 | 178.619 | Corriganville Park | ||
1511 | 1511 | 1510 | {"type": "Polygon", "coordinates": [[[-119.10787, 36.41389], [-119.10786, 36.41561], [-119.10573, 36.41561], [-119.10572, 36.4146], [-119.10643, 36.4146], [-119.10644, 36.41385], [-119.10787, 36.41389]]]} | Open Access 1 | Antelope Cemetery | 15507 | 2184 | Woodlake Public Cemetery District 121 | Special District 4 | Cemetery District 11 | Special District 4 | 7.882 | Antelope Cemetery | |||
1982 | 1982 | 1981 | {"type": "Polygon", "coordinates": [[[-119.5816, 36.67854], [-119.58049, 36.67855], [-119.58052, 36.67774], [-119.58158, 36.67773], [-119.5816, 36.6778], [-119.5816, 36.67854]]]} | Open Access 1 | Bethel Cemetery | 16047 | 2138 | Sanger/Del Rey Cemetery District 794 | Special District 4 | Cemetery District 11 | Special District 4 | 2.179 | Bethel Cemetery | |||
2068 | 2068 | 2067 | {"type": "Polygon", "coordinates": [[[-118.90503, 36.42081], [-118.90499, 36.42148], [-118.90499, 36.42203], [-118.90271, 36.42198], [-118.90281, 36.42075], [-118.90503, 36.42081]]]} | Open Access 1 | Blossom Peak Cemetery | 16174 | 2165 | Three Rivers Public Cemetery District 779 | Special District 4 | Cemetery District 11 | Special District 4 | 6.761 | Blossom Peak Cemetery | |||
2101 | 2101 | 2100 | {"type": "Polygon", "coordinates": [[[-120.63928, 36.98336], [-120.63928, 36.98477], [-120.63698, 36.98476], [-120.63697, 36.98408], [-120.63568, 36.98408], [-120.63567, 36.98192], [-120.63822, 36.98193], [-120.63823, 36.98335], [-120.63928, 36.98336]]]} | Open Access 1 | Cemetery | 17009 | 2029 | Dos Palos Cemetery District 905 | Special District 4 | Cemetery District 11 | Special District 4 | 19.168 | Cemetery | |||
2210 | 2210 | 2209 | {"type": "Polygon", "coordinates": [[[-121.04115, 37.18702], [-121.04113, 37.18781], [-121.03979, 37.18782], [-121.03981, 37.18701], [-121.04115, 37.18702]]]} | Open Access 1 | Cemetery | 17010 | 2047 | Hills Ferry Cemetery District 907 | Special District 4 | Cemetery District 11 | Special District 4 | 2.605 | Cemetery | |||
2639 | 2639 | 2638 | {"type": "Polygon", "coordinates": [[[-121.73742, 36.48206], [-121.73572, 36.4827], [-121.73546, 36.48248], [-121.73613, 36.48154], [-121.73566, 36.48131], [-121.73587, 36.48102], [-121.7362, 36.4812], [-121.73668, 36.48141], [-121.73694, 36.48155], [-121.7372, 36.48177], [-121.73734, 36.48193], [-121.73742, 36.48206]]]} | Open Access 1 | Carmel Valley Park | 16876 | 2337 | Carmel Valley Recreation Park District 1065 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 3.858 | Carmel Valley Park | |||
2700 | 2700 | 2699 | {"type": "Polygon", "coordinates": [[[-121.7877, 36.79149], [-121.78737, 36.79341], [-121.785, 36.79391], [-121.78428, 36.79221], [-121.7877, 36.79149]]]} | Open Access 1 | Castroville Cemetery | 16967 | 2015 | Castroville Cemetery District 820 | Special District 4 | Cemetery District 11 | Special District 4 | 13.067 | Castroville Cemetery | |||
2736 | 2736 | 2735 | {"type": "Polygon", "coordinates": [[[-120.4259, 37.94699], [-120.42564, 37.9476], [-120.4255, 37.94811], [-120.42551, 37.94822], [-120.42504, 37.94841], [-120.42471, 37.94817], [-120.42435, 37.94782], [-120.42412, 37.94745], [-120.42349, 37.94692], [-120.42464, 37.94646], [-120.42483, 37.94684], [-120.42539, 37.94659], [-120.42558, 37.94679], [-120.4259, 37.94699]]]} | Open Access 1 | Cemetery | 17011 | 2050 | Jamestown Cemetery District 64 | Special District 4 | Cemetery District 11 | Special District 4 | 6.085 | Cemetery | |||
2739 | 2739 | 2738 | {"type": "Polygon", "coordinates": [[[-120.2455, 37.82767], [-120.24545, 37.82809], [-120.24528, 37.82907], [-120.24525, 37.82917], [-120.24352, 37.82889], [-120.24371, 37.82745], [-120.2455, 37.82767]]]} | Open Access 1 | Cemetery | 17014 | 2098 | Oak Grove Cemetery District 69 | Special District 4 | Cemetery District 11 | Special District 4 | 6.427 | Cemetery | |||
2740 | 2740 | 2739 | {"type": "Polygon", "coordinates": [[[-120.40136, 38.00555], [-120.40072, 38.00607], [-120.40064, 38.00615], [-120.40061, 38.00621], [-120.40038, 38.00615], [-120.40036, 38.00603], [-120.39992, 38.00605], [-120.39963, 38.00604], [-120.40009, 38.00557], [-120.40036, 38.00524], [-120.40055, 38.00505], [-120.40073, 38.00515], [-120.40136, 38.00555]]]} | Open Access 1 | Cemetery | 17015 | 2150 | Shaws Flat Cemetery District 67 | Special District 4 | Cemetery District 11 | Special District 4 | 2.302 | Cemetery | |||
3206 | 3206 | 3205 | {"type": "Polygon", "coordinates": [[[-117.25827, 34.54145], [-117.25718, 34.54179], [-117.25716, 34.54027], [-117.25826, 34.54028], [-117.25827, 34.54145]]]} | Open Access 1 | Corwin Park | 17669 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 3.69 | Corwin Park | |||
3283 | 3283 | 3282 | {"type": "Polygon", "coordinates": [[[-117.22181, 34.53488], [-117.22174, 34.535], [-117.2217, 34.53513], [-117.22168, 34.53527], [-117.22168, 34.53555], [-117.22166, 34.53558], [-117.22162, 34.5356], [-117.22091, 34.53561], [-117.22089, 34.53514], [-117.22017, 34.53515], [-117.22017, 34.53467], [-117.22046, 34.5346], [-117.22059, 34.53454], [-117.22074, 34.53444], [-117.22112, 34.53478], [-117.22124, 34.53468], [-117.22181, 34.53488]]]} | Open Access 1 | Cramer Family Park | 17754 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2.83 | Cramer Family Park | |||
3501 | 3501 | 3500 | {"type": "Polygon", "coordinates": [[[-119.19796, 36.31684], [-119.19795, 36.31782], [-119.19604, 36.31789], [-119.196, 36.31689], [-119.19796, 36.31684]]]} | Open Access 1 | Deep Creek Cemetery | 17988 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Special District 4 | 4.704 | Deep Creek Cemetery | |||
3895 | 3895 | 3894 | {"type": "Polygon", "coordinates": [[[-119.10764, 36.34977], [-119.10762, 36.35107], [-119.1054, 36.35107], [-119.10542, 36.34976], [-119.10764, 36.34977]]]} | Open Access 1 | Hamilton Cemetery | 19616 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Special District 4 | 7.138 | Hamilton Cemetery | |||
4112 | 4112 | 4111 | {"type": "Polygon", "coordinates": [[[-119.13521, 36.30947], [-119.1351, 36.31147], [-119.13075, 36.31143], [-119.13077, 36.31043], [-119.1323, 36.31043], [-119.13238, 36.30936], [-119.13521, 36.30947]]]} | Open Access 1 | Exeter Cemetery | 18773 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Special District 4 | 18.077 | Exeter Cemetery | |||
4271 | 4271 | 4270 | {"type": "Polygon", "coordinates": [[[-119.62216, 36.57616], [-119.61991, 36.57617], [-119.61986, 36.57615], [-119.61984, 36.57612], [-119.61982, 36.57405], [-119.62216, 36.57616]]]} | Open Access 1 | Floral Memorial Cemetery | 18958 | 2148 | Selma Cemetery District 247 | Special District 4 | Cemetery District 11 | Special District 4 | 6.038 | Floral Memorial Cemetery | |||
4278 | 4278 | 4277 | {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} | Open Access 1 | Foglesong Park/Eda Henderson Pool | 18966 | 2203 | Barstow Recreation and Park District 76 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 9.886 | Foglesong Park/Eda Henderson Pool | |||
4348 | 4348 | 4347 | {"type": "Polygon", "coordinates": [[[-119.68461, 36.60967], [-119.68459, 36.61269], [-119.68239, 36.61268], [-119.68238, 36.60964], [-119.68461, 36.60967]]]} | Open Access 1 | Fowler Cemetery | 19028 | 2035 | Fowler Cemetery District 394 | Special District 4 | Cemetery District 11 | Special District 4 | 16.465 | Fowler Cemetery | |||
4367 | 4367 | 4366 | {"type": "Polygon", "coordinates": [[[-118.95592, 36.14627], [-118.95521, 36.14626], [-118.9552, 36.14479], [-118.95589, 36.1448], [-118.95592, 36.14627]]]} | Open Access 1 | Frazier Valley Cemetery | 19071 | 2060 | Lindsay-Strathmore Cemetery District 119 | Special District 4 | Cemetery District 11 | Special District 4 | 2.538 | Frazier Valley Cemetery |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);