superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,091 rows where MNG_AG_TYP = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- East Bay Regional Park District 132
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 67
- Rancho Simi Recreation and Park District 53
- Conejo Recreation and Park District 44
- Midpeninsula Regional Open Space District 43
- Southgate Recreation and Park District 40
- Marin County Open Space District 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
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 24
- Santa Clara Valley Open Space Authority 23
- Sonoma County Agricultural Preservation and Open Space District 21
- Jurupa Area Recreation and Park District 18
- Desert Recreation District 15
- Isla Vista Recreation and Park District 14
- Mission Oaks Recreation and Park District 14
- Apple Valley Recreation and Park District 13
- Livermore Area Recreation and Park 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
- Napa County Regional Park and Open Space District 10
- Hesperia Recreation and Park District 10
- Miraleste Recreation and Park District 10
- Rio Linda Elverta Recreation and Park District 9
- …
ACCESS_TYP 4
- Open Access 931
- No Public Access 97
- Restricted Access 62
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 1,091 ✖
LAYER 1 ✖
- Special District 1,091
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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 | ||
1406 | 1406 | 1405 | {"type": "Polygon", "coordinates": [[[-117.1093, 33.59153], [-117.1089, 33.59184], [-117.10882, 33.59184], [-117.10882, 33.59154], [-117.10914, 33.59157], [-117.10922, 33.59155], [-117.10929, 33.59152], [-117.1093, 33.59153]]]} | Open Access 1 | Pompei Pocket Park | https://www.gorecreation.org/pompei-pocket-park | 32947 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.197 | Pompei PP | |
1818 | 1818 | 1817 | {"type": "Polygon", "coordinates": [[[-117.10035, 33.59259], [-117.10035, 33.59281], [-117.09998, 33.59281], [-117.09998, 33.59259], [-117.10035, 33.59259]]]} | Open Access 1 | Watermill Park | https://www.gorecreation.org/watermill-park | 32956 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.202 | Watermill Park | |
164 | 164 | 163 | {"type": "Polygon", "coordinates": [[[-121.74145, 37.61399], [-121.74132, 37.61413], [-121.74116, 37.61418], [-121.74067, 37.61426], [-121.74045, 37.61437], [-121.74047, 37.61426], [-121.74145, 37.61399]]]} | Open Access 1 | Lake Del Valle SRA | http://www.parks.ca.gov/?page_id=537 | 1594 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.204 | Lake Del Valle SRA | 2000 |
1774 | 1774 | 1773 | {"type": "Polygon", "coordinates": [[[-117.10569, 33.59244], [-117.10566, 33.59249], [-117.10549, 33.59255], [-117.10527, 33.59259], [-117.10527, 33.59237], [-117.10566, 33.59232], [-117.10569, 33.59244]]]} | Open Access 1 | Sicily Pocket Park | https://www.gorecreation.org/sicily-pocket-park | 32952 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.212 | Sicily PP | |
11060 | 11060 | 11059 | {"type": "Polygon", "coordinates": [[[-121.28286, 38.5753], [-121.28275, 38.57551], [-121.28263, 38.57548], [-121.2824, 38.57529], [-121.28262, 38.57514], [-121.28271, 38.57522], [-121.28286, 38.5753]]]} | Open Access 1 | Waterbrook Park | 27299 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 0.214 | Waterbrook Park | ||
13960 | 13960 | 13959 | {"type": "Polygon", "coordinates": [[[-120.23679, 37.96123], [-120.23635, 37.96123], [-120.23635, 37.96102], [-120.23679, 37.96102], [-120.23679, 37.96123]]]} | Open Access 1 | Reid Park | https://www.tuolumnerecreation.com/TPRD_facilities.html | 32551 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 0.215 | Reid Park | 1997 |
5835 | 5835 | 5834 | {"type": "Polygon", "coordinates": [[[-122.10386, 37.66497], [-122.10343, 37.66497], [-122.10343, 37.66475], [-122.10385, 37.66475], [-122.10386, 37.66497]]]} | Open Access 1 | La Placita Mini Park | 20788 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 0.229 | La Placita MP | ||
11862 | 11862 | 11861 | {"type": "Polygon", "coordinates": [[[-122.11963, 37.1255], [-122.11902, 37.12573], [-122.11902, 37.12573], [-122.11903, 37.12536], [-122.11963, 37.1255]]]} | Open Access 1 | Barbara Day Park | 28528 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 0.272 | Barbara Day Park | ||
2020 | 2020 | 2019 | {"type": "Polygon", "coordinates": [[[-120.20197, 39.32434], [-120.20196, 39.32475], [-120.20172, 39.32478], [-120.20165, 39.32437], [-120.20197, 39.32434]]]} | Open Access 1 | Bill Rose Park | 16111 | 2263 | Truckee-Donner Recreation and Park District 568 | Special District 4 | Recreation/Parks District 4 | http://www.tdrpd.com/ | Special District 4 | 0.273 | Bill Rose Park | ||
10282 | 10282 | 10281 | {"type": "Polygon", "coordinates": [[[-121.8613, 36.93786], [-121.86128, 36.9379], [-121.86099, 36.93813], [-121.86095, 36.93813], [-121.86093, 36.9381], [-121.86095, 36.93798], [-121.86093, 36.93765], [-121.86096, 36.93761], [-121.86102, 36.93762], [-121.86128, 36.93782], [-121.8613, 36.93786]]]} | Open Access 1 | Unknown park - La Selva Beach Recreation District | 28639 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 0.278 | |||
3545 | 3545 | 3544 | {"type": "Polygon", "coordinates": [[[-117.55346, 33.96127], [-117.55339, 33.96134], [-117.5529, 33.96113], [-117.55289, 33.96099], [-117.55294, 33.96096], [-117.55314, 33.96096], [-117.55346, 33.96127]]]} | Open Access 1 | Delaware Greenbelt | 18064 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 0.28 | Delaware Greenbelt | ||
1356 | 1356 | 1355 | {"type": "Polygon", "coordinates": [[[-117.14454, 33.70443], [-117.14404, 33.70443], [-117.14404, 33.70421], [-117.14454, 33.70421], [-117.14454, 33.70443]]]} | Open Access 1 | Mahogany Creek Pocket Park | 32944 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.281 | Mahogany Creek PP |
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]);