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 130
- Hayward Area Recreation and Park District 83
- Valley-Wide Recreation and Park District 62
- 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 35
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 29
- North of the River Recreation and Park District 26
- 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 17
- 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
- North Highland Recreation and Park District 11
- Napa County Regional Park and Open Space District 10
- Auburn Area Recreation and Park District 10
- Miraleste Recreation and Park District 10
- Rio Linda Elverta Recreation and Park District 9
- Hesperia Recreation and Park District 9
- …
ACCESS_TYP 4
- Open Access 912
- No Public Access 97
- Restricted Access 61
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 1,071 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6934 | 6934 | 6933 | {"type": "Polygon", "coordinates": [[[-122.05725, 39.01739], [-122.05695, 39.0175], [-122.05674, 39.01718], [-122.05702, 39.01706], [-122.05725, 39.01739]]]} | Open Access 1 | Memorial Park | 22144 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 0.288 | Memorial Park | ||
11888 | 11888 | 11887 | {"type": "Polygon", "coordinates": [[[-121.96105, 36.96553], [-121.96093, 36.96566], [-121.9605, 36.9653], [-121.96048, 36.96524], [-121.96044, 36.96518], [-121.96044, 36.96515], [-121.96055, 36.96512], [-121.96105, 36.96553]]]} | Open Access 1 | Privates Beach Accessway | 28594 | 2103 | Opal Cliffs Recreation District 1054 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 0.289 | Privates Beach Accessway | |||
5418 | 5418 | 5417 | {"type": "Polygon", "coordinates": [[[-119.85998, 34.40901], [-119.85998, 34.40971], [-119.85981, 34.40971], [-119.85981, 34.409], [-119.85998, 34.40901]]]} | Open Access 1 | Isla Vista County Park | 20279 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 0.295 | Isla Vista County Park | ||
1357 | 1357 | 1356 | {"type": "Polygon", "coordinates": [[[-117.13273, 33.61299], [-117.13267, 33.61334], [-117.13238, 33.61333], [-117.13235, 33.61297], [-117.13273, 33.61299]]]} | Open Access 1 | Mahogany Meadows Pocket Park | https://www.gorecreation.org/mahogany-meadows-pocket-park | 32945 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.3 | Mahogany Meadows PP | |
8684 | 8684 | 8683 | {"type": "Polygon", "coordinates": [[[-117.14906, 33.69572], [-117.14903, 33.69575], [-117.14866, 33.69568], [-117.14869, 33.69561], [-117.14868, 33.69555], [-117.1486, 33.6954], [-117.14891, 33.69532], [-117.14906, 33.69572]]]} | Open Access 1 | Richmond Park | 24341 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.305 | Richmond Park | ||
10024 | 10024 | 10023 | {"type": "Polygon", "coordinates": [[[-122.51058, 37.88831], [-122.51016, 37.88805], [-122.50995, 37.88795], [-122.50973, 37.88786], [-122.50925, 37.88771], [-122.50936, 37.88764], [-122.50907, 37.8872], [-122.50896, 37.88657], [-122.50896, 37.88632], [-122.50902, 37.88628], [-122.509, 37.88658], [-122.50913, 37.88719], [-122.50949, 37.88772], [-122.51025, 37.88806], [-122.51058, 37.88831]]]} | Open Access 1 | Strawberry Point Tidal Area | 25919 | 2162 | Strawberry Recreation District 650 | Special District 4 | Recreation/Parks District 4 | http://strawberry.marin.org/ | Special District 4 | 0.327 | Strawberry Point Tidal Area | ||
1941 | 1941 | 1940 | {"type": "Polygon", "coordinates": [[[-117.35643, 34.42535], [-117.35633, 34.42549], [-117.35636, 34.42555], [-117.35633, 34.42563], [-117.35625, 34.42564], [-117.35616, 34.4256], [-117.35611, 34.42562], [-117.35602, 34.42562], [-117.35597, 34.4256], [-117.35595, 34.42557], [-117.35599, 34.42543], [-117.35597, 34.42532], [-117.356, 34.42528], [-117.3561, 34.42527], [-117.35618, 34.42529], [-117.35634, 34.42529], [-117.35643, 34.42535]]]} | Open Access 1 | Belmont Park | 15994 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 0.334 | Belmont Park | ||
10460 | 10460 | 10459 | {"type": "Polygon", "coordinates": [[[-119.86022, 34.41121], [-119.86022, 34.41162], [-119.85989, 34.41162], [-119.85989, 34.41121], [-119.86022, 34.41121]]]} | Open Access 1 | Trigo Pasado Park | 26535 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 0.344 | Trigo Pasado Park | ||
11323 | 11323 | 11322 | {"type": "Polygon", "coordinates": [[[-119.86222, 34.40916], [-119.86222, 34.40971], [-119.86197, 34.40971], [-119.86197, 34.40918], [-119.86222, 34.40916]]]} | Open Access 1 | Window to the Sea Park | 27630 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 0.344 | Window to the Sea Park | ||
7179 | 7179 | 7178 | {"type": "Polygon", "coordinates": [[[-117.55563, 33.96321], [-117.55525, 33.9634], [-117.55503, 33.96318], [-117.55544, 33.96296], [-117.55563, 33.96321]]]} | Open Access 1 | Moon River Tot Lot | 22450 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 0.347 | Moon River Tot Lot | ||
2029 | 2029 | 2028 | {"type": "Polygon", "coordinates": [[[-118.99237, 34.22873], [-118.99218, 34.22868], [-118.99202, 34.22862], [-118.99185, 34.22852], [-118.99183, 34.22847], [-118.992, 34.22836], [-118.99227, 34.22826], [-118.99237, 34.22873]]]} | Open Access 1 | Birchview Park | 16119 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 0.353 | Birchview Park | ||
2712 | 2712 | 2711 | {"type": "Polygon", "coordinates": [[[-121.74927, 36.76152], [-121.74899, 36.76175], [-121.74889, 36.76167], [-121.74878, 36.76135], [-121.74919, 36.76127], [-121.74927, 36.76152]]]} | Open Access 1 | Cato Phillips Park | 16979 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 0.363 | Cato Phillips Park | ||
3906 | 3906 | 3905 | {"type": "Polygon", "coordinates": [[[-117.14793, 33.70508], [-117.14765, 33.70532], [-117.14748, 33.70518], [-117.14733, 33.70503], [-117.14766, 33.70484], [-117.14793, 33.70508]]]} | Open Access 1 | Eldorado Pocket Park | 18553 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.371 | Eldorado PP | ||
8919 | 8919 | 8918 | {"type": "Polygon", "coordinates": [[[-117.15436, 33.65971], [-117.15425, 33.65986], [-117.15419, 33.66001], [-117.15416, 33.66016], [-117.15416, 33.66038], [-117.15407, 33.66045], [-117.15396, 33.66045], [-117.15397, 33.66005], [-117.15418, 33.65966], [-117.15431, 33.65967], [-117.15436, 33.65971]]]} | Open Access 1 | Rolling Hills Park | 24582 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.378 | Rolling Hills Park | ||
75 | 75 | 74 | {"type": "Polygon", "coordinates": [[[-118.319, 33.74614], [-118.31877, 33.74618], [-118.31864, 33.74623], [-118.31846, 33.74607], [-118.31846, 33.74603], [-118.31855, 33.74586], [-118.3188, 33.74581], [-118.31892, 33.74587], [-118.319, 33.74614]]]} | Open Access 1 | Miraleste Park | 31780 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 0.395 | Miraleste Park | ||
1514 | 1514 | 1513 | {"type": "Polygon", "coordinates": [[[-121.7508, 38.02106], [-121.75061, 38.02106], [-121.75061, 38.02096], [-121.75065, 38.02095], [-121.75065, 38.01964], [-121.75066, 38.01963], [-121.75067, 38.01953], [-121.75076, 38.01953], [-121.75075, 38.02094], [-121.7508, 38.02096], [-121.7508, 38.02106]]]} | Open Access 1 | Antioch Bridge Fishing Pier | 15522 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.397 | Antioch Bridge Fishing Pier | ||
10041 | 10041 | 10040 | {"type": "Polygon", "coordinates": [[[-119.86061, 34.41273], [-119.86061, 34.41313], [-119.86021, 34.41313], [-119.86022, 34.41273], [-119.86061, 34.41273]]]} | Open Access 1 | Sueno Park | 25942 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 0.402 | Sueno Park | ||
2607 | 2607 | 2606 | {"type": "Polygon", "coordinates": [[[-121.75105, 36.77086], [-121.75056, 36.77128], [-121.75044, 36.77119], [-121.75059, 36.77105], [-121.75051, 36.7709], [-121.75078, 36.77066], [-121.75105, 36.77086]]]} | Open Access 1 | Crane Street Park | 17759 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 0.406 | Crane Street Park | ||
1856 | 1856 | 1855 | {"type": "Polygon", "coordinates": [[[-117.1099, 33.59108], [-117.10987, 33.59122], [-117.10982, 33.59131], [-117.10976, 33.59136], [-117.10963, 33.59141], [-117.10945, 33.59141], [-117.1093, 33.59153], [-117.10929, 33.59152], [-117.10934, 33.59147], [-117.10936, 33.5914], [-117.10933, 33.59112], [-117.10941, 33.59108], [-117.1099, 33.59108]]]} | Open Access 1 | Capri Park | https://www.gorecreation.org/capri-pocket-park | 32961 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.419 | Capri Park | |
4984 | 4984 | 4983 | {"type": "Polygon", "coordinates": [[[-122.06832, 37.64878], [-122.0678, 37.64887], [-122.06776, 37.64853], [-122.06779, 37.64844], [-122.06798, 37.64835], [-122.06832, 37.64878]]]} | Open Access 1 | Haymont Mini Park | 19758 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 0.431 | Haymont MP |
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]);