superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,000 rows where MNG_AG_LEV = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 181
- East Bay Regional Park District 132
- Consumnes Community Services District 92
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 67
- Rancho Simi Recreation and Park District 53
- Yuba County Water Agency 50
- Conejo Recreation and Park District 44
- Midpeninsula Regional Open Space District 43
- Southgate Recreation and Park District 40
- Marin County Open Space District 39
- Conejo Open Space Conservation Agency 39
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 36
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 31
- Fresno Metropolitan Flood Control District 29
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 24
- El Dorado Hills Community Service District 24
- Santa Clara Valley Open Space Authority 23
- Olivehurst Public Utility District 23
- Sonoma County Agricultural Preservation and Open Space District 21
- Natomas Basin Conservancy 20
- San Diego Unified Port District 19
- Jurupa Area Recreation and Park District 18
- Santa Barbara Flood Control and Water Conserv. District 16
- Los Angeles County Flood Control District 16
- Los Angeles Unified School District 16
- Desert Recreation District 15
- …
MNG_AG_TYP 17
- Recreation/Parks District 1,091
- Open Space District 241
- Community Services District 193
- Water District 187
- Flood District 94
- Cemetery District 61
- School District 38
- Port/Harbor District 32
- Irrigation District 24
- Special District - Other 15
- Sanitation District 9
- Conservation District 5
- Transportation Agency 5
- Metropolitan Planning Organization 2
- Airport District 1
- Joint Powers Authority 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,567
- No Public Access 194
- Restricted Access 135
- Unknown Access 104
LAYER 1 ✖
- Special District 2,000
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2457 | 2457 | 2456 | {"type": "Polygon", "coordinates": [[[-118.23627, 33.89605], [-118.23616, 33.89604], [-118.23608, 33.89598], [-118.2362, 33.89598], [-118.23627, 33.89605]]]} | Open Access 1 | Compton Creek & Bike Path | 17572 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 0.02 | Compton Creek & Bike Path | ||
14115 | 14115 | 14114 | {"type": "Polygon", "coordinates": [[[-120.94993, 40.13923], [-120.94987, 40.13929], [-120.94983, 40.13929], [-120.94982, 40.13916], [-120.94993, 40.13923]]]} | Open Access 1 | Triangle Park | http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf | 33659 | 2229 | Indian Valley Community Services District 848 | Special District 4 | Community Services District 17 | Special District 4 | 0.02 | Triangle Park | ||
8259 | 8259 | 8258 | {"type": "Polygon", "coordinates": [[[-119.01469, 34.22393], [-119.01462, 34.2239], [-119.01463, 34.22384], [-119.01461, 34.22379], [-119.01469, 34.22376], [-119.01469, 34.22393]]]} | Open Access 1 | Pleasant Valley Recreation and Park District | 23802 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 0.025 | Pleasant Valley Rec. and Park District | ||
12638 | 12638 | 12637 | {"type": "Polygon", "coordinates": [[[-118.23978, 34.20471], [-118.23978, 34.2048], [-118.23976, 34.20488], [-118.23962, 34.20472], [-118.23978, 34.20471]]]} | Open Access 1 | Verdugo Mountains Open Space Preserve | 29734 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.036 | Verdugo Mtns. OSP | ||
13156 | 13156 | 13155 | {"type": "Polygon", "coordinates": [[[-118.22852, 34.08438], [-118.2285, 34.0844], [-118.22844, 34.0843], [-118.22835, 34.08422], [-118.22833, 34.08418], [-118.22835, 34.08399], [-118.22852, 34.08438]]]} | Open Access 1 | Egret Park | 30449 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.055 | Egret Park | ||
13767 | 13767 | 13766 | {"type": "Polygon", "coordinates": [[[-121.07803, 38.89568], [-121.07803, 38.89571], [-121.07746, 38.8957], [-121.07748, 38.89564], [-121.07803, 38.89568]]]} | Open Access 1 | Herschel Young Park | 31275 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 0.061 | Herschel Young Park | ||
2820 | 2820 | 2819 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | Chabot - Garin Trail Corridor | 17108 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.064 | Chabot - Garin Trail Corridor | ||
13464 | 13464 | 13463 | {"type": "Polygon", "coordinates": [[[-122.5342, 37.88202], [-122.53409, 37.88226], [-122.53409, 37.88227], [-122.53403, 37.88222], [-122.53403, 37.882], [-122.5342, 37.88202]]]} | Open Access 1 | Kott Park | 30876 | 2261 | Tamalpais Community Services District 708 | Special District 4 | Community Services District 17 | http://www.tcsd.us/ | Special District 4 | 0.068 | Kott Park | ||
9196 | 9196 | 9195 | {"type": "MultiPolygon", "coordinates": [[[[-118.07211, 33.98316], [-118.0721, 33.98317], [-118.07151, 33.98276], [-118.07152, 33.98275], [-118.07211, 33.98316]]], [[[-118.07278, 33.98341], [-118.07277, 33.98343], [-118.07221, 33.98304], [-118.07222, 33.98303], [-118.07278, 33.98341]]], [[[-118.07399, 33.98445], [-118.07398, 33.98447], [-118.07355, 33.98418], [-118.07356, 33.98416], [-118.07399, 33.98445]]]]} | Open Access 1 | San Gabriel River & Bike Trail | 24897 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 0.082 | San Gabriel River & Bike Trail | ||
7046 | 7046 | 7045 | {"type": "Polygon", "coordinates": [[[-118.39025, 33.81526], [-118.39021, 33.81551], [-118.3901, 33.81537], [-118.38993, 33.81522], [-118.39025, 33.81526]]]} | Open Access 1 | Miramar Park | 22287 | 2158 | South Bay Cities Sanitation District 449 | Special District 4 | Sanitation District 19 | http://www.lacsd.org/ | Special District 4 | 0.094 | Miramar Park | ||
9355 | 9355 | 9354 | {"type": "Polygon", "coordinates": [[[-117.35578, 34.42283], [-117.35576, 34.4229], [-117.35578, 34.42299], [-117.35577, 34.42306], [-117.35568, 34.42309], [-117.35563, 34.42305], [-117.35562, 34.42299], [-117.35559, 34.42289], [-117.35562, 34.42278], [-117.35572, 34.42277], [-117.35578, 34.42283]]]} | Open Access 1 | Sapphire Park | 25154 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 0.12 | Sapphire Park | ||
5108 | 5108 | 5107 | {"type": "Polygon", "coordinates": [[[-121.88826, 36.95785], [-121.88809, 36.95809], [-121.88786, 36.95841], [-121.88803, 36.95793], [-121.88826, 36.95785]]]} | Open Access 1 | Hidden Beach Park - SCCSD | 19904 | 2144 | Santa Cruz County Sanitation District 904 | Special District 4 | Sanitation District 19 | http://www.dpw.co.santa-cruz.ca.us/Sanitation.htm#SCCSD | Special District 4 | 0.121 | Hidden Beach Park - SCCSD | ||
8751 | 8751 | 8750 | {"type": "MultiPolygon", "coordinates": [[[[-119.09761, 35.40048], [-119.09761, 35.40048], [-119.0976, 35.40055], [-119.09755, 35.40051], [-119.09761, 35.40048]]], [[[-119.09798, 35.40118], [-119.09789, 35.40109], [-119.09783, 35.40095], [-119.09789, 35.401], [-119.09794, 35.40106], [-119.09798, 35.40118]]], [[[-119.09823, 35.4015], [-119.0981, 35.40149], [-119.09804, 35.40138], [-119.09808, 35.40132], [-119.09823, 35.4015]]], [[[-119.09895, 35.39986], [-119.09895, 35.39986], [-119.09864, 35.39995], [-119.09889, 35.3998], [-119.09895, 35.39986]]], [[[-119.09949, 35.40115], [-119.09931, 35.40122], [-119.09921, 35.40121], [-119.09937, 35.40109], [-119.09947, 35.40107], [-119.09949, 35.40115]]]]} | Open Access 1 | River Lakes Ranch Community Park | 24410 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 0.141 | River Lakes Ranch Community Park | ||
13706 | 13706 | 13705 | {"type": "Polygon", "coordinates": [[[-117.2247, 32.72492], [-117.22467, 32.72521], [-117.22448, 32.72521], [-117.22451, 32.72491], [-117.2247, 32.72492]]]} | Open Access 1 | Point Loma Marina Park | https://www.portofsandiego.org/point-loma-marina-park.html | 31205 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 0.142 | Point Loma Marina Park | |
9283 | 9283 | 9282 | {"type": "Polygon", "coordinates": [[[-119.7122, 34.45864], [-119.71219, 34.45865], [-119.71206, 34.45871], [-119.71176, 34.45871], [-119.71175, 34.45848], [-119.71185, 34.45854], [-119.7122, 34.45864]]]} | Open Access 1 | Santa Barbara Botanic Gardens | 25037 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 0.145 | Santa Barbara Botanic Gardens | ||
1043 | 1043 | 1042 | {"type": "Polygon", "coordinates": [[[-117.09337, 33.59269], [-117.09337, 33.59287], [-117.09303, 33.59287], [-117.09303, 33.59269], [-117.09337, 33.59269]]]} | Open Access 1 | Northfield Park | https://www.gorecreation.org/northfield-park | 32814 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.152 | Northfield Park | |
13953 | 13953 | 13952 | {"type": "Polygon", "coordinates": [[[-120.23983, 37.96099], [-120.23982, 37.96122], [-120.23954, 37.96122], [-120.23954, 37.96099], [-120.23983, 37.96099]]]} | Open Access 1 | Bay Street Tot Lot | https://www.tuolumnerecreation.com/TPRD_facilities.html | 32546 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 0.163 | Bay Street Tot Lot | 2011 |
14704 | 14704 | 14703 | {"type": "Polygon", "coordinates": [[[-118.59318, 34.11022], [-118.59279, 34.1103], [-118.59258, 34.11025], [-118.59278, 34.11018], [-118.59292, 34.11008], [-118.59301, 34.11007], [-118.59318, 34.11022]]]} | Open Access 1 | Topanga Open Space | 26408 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.17 | Topanga OS | ||
11828 | 11828 | 11827 | {"type": "Polygon", "coordinates": [[[-122.05718, 37.94618], [-122.05718, 37.94618], [-122.057, 37.94673], [-122.05698, 37.94654], [-122.05696, 37.94645], [-122.05688, 37.94625], [-122.05716, 37.94615], [-122.05718, 37.94618]]]} | Open Access 1 | Sherman Acres Neighborhood Park | 28472 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 0.171 | Sherman Acres Neighborhood Park | ||
6011 | 6011 | 6010 | {"type": "Polygon", "coordinates": [[[-118.54326, 34.04416], [-118.54305, 34.04417], [-118.54302, 34.0442], [-118.54286, 34.04405], [-118.54306, 34.04392], [-118.54313, 34.04389], [-118.54316, 34.04389], [-118.54323, 34.04403], [-118.54326, 34.04416]]]} | Unknown Access 4 | Las Casas - Grenola | 21045 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.186 | Las Casas - Grenola |
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]);