superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,091 rows where MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
PARK_URL >30 ✖
- http://www.openspaceauthority.org 8
- http://www.openspaceauthority.org/ 7
- https://www.tuolumnerecreation.com/TPRD_facilities.html 6
- http://www.bcrpd.org/#!parks/ccjp 2
- http://www.ebparks.org/parks/bishop 2
- http://www.ebparks.org/parks/black_diamond 2
- http://www.ebparks.org/parks/eastshore 2
- http://www.ebparks.org/parks/garin 2
- http://www.ebparks.org/parks/las_trampas 2
- http://www.ebparks.org/parks/wildcat 2
- http://www.gdrd.org/Parks___Facilities.html 2
- http://www.gdrd.org/parks---facilities.html 2
- http://www.openspace.org/preserves/pr_coal_creek.asp 2
- http://www.openspace.org/preserves/pr_ecdm.asp 2
- http://www.openspace.org/preserves/pr_el_sereno.asp 2
- http://www.openspace.org/preserves/pr_monte_bello.asp 2
- http://www.openspace.org/preserves/pr_purisima.asp 2
- http://www.openspace.org/preserves/pr_russian_ridge.asp 2
- http://www.openspace.org/preserves/pr_saratoga_gap.asp 2
- http://www.openspace.org/preserves/pr_sierra_azul.asp 2
- http://www.openspace.org/preserves/pr_skyline_ridge.asp 2
- http://www.openspace.org/preserves/pr_thornewood.asp 2
- http://www.openspace.org/preserves/pr_windy_hill.asp 2
- http://carmichaelpark.com/odonnell-heritage-park/ 1
- http://crpd.com/parks/argonaut-park/ 1
- http://crpd.com/parks/eagles-nest-park/ 1
- http://crpd.com/parks/village-green-park/ 1
- http://frrpd.com/parks-facilities/parks/ 1
- http://msrec.org/city-park/youth-sports-field/ 1
- http://rim-rec.org/parks-facilities/ 1
- …
MNG_AGENCY >30
- East Bay Regional Park District 112
- Hayward Area Recreation and Park District 75
- Rancho Simi Recreation and Park District 46
- Midpeninsula Regional Open Space District 43
- Conejo Recreation and Park District 41
- Marin County Open Space District 37
- Southgate Recreation and Park District 36
- Sunrise Recreation and Park District 36
- Greater Vallejo Recreation and Park District 33
- Cordova Recreation and Park District 32
- Valley-Wide Recreation and Park District 26
- North of the River Recreation and Park District 25
- Monterey Peninsula Regional Park District 23
- Sonoma County Agricultural Preservation and Open Space District 20
- Santa Clara Valley Open Space Authority 20
- Pleasant Valley Recreation and Park District 19
- Jurupa Area Recreation and Park District 16
- Desert Recreation District 14
- Isla Vista Recreation and Park District 13
- Apple Valley Recreation and Park District 13
- Mission Oaks 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 9
- Livermore Area Recreation and Park District 9
- Auburn Area Recreation and Park District 9
- Tuolumne Park and Recreation District 9
- Rio Linda Elverta Recreation and Park District 8
- Hesperia Recreation and Park District 8
- …
ACCESS_TYP 4
- Open Access 785
- No Public Access 91
- Restricted Access 57
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 934 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1987 | 1987 | 1986 | {"type": "Polygon", "coordinates": [[[-122.22737, 38.08113], [-122.22737, 38.08127], [-122.22732, 38.0813], [-122.22665, 38.0811], [-122.22659, 38.0812], [-122.22732, 38.08142], [-122.22736, 38.08146], [-122.22736, 38.08153], [-122.22528, 38.08137], [-122.22508, 38.0818], [-122.22533, 38.08199], [-122.22562, 38.08233], [-122.2258, 38.08248], [-122.22596, 38.08257], [-122.22615, 38.08265], [-122.22657, 38.08278], [-122.22737, 38.08289], [-122.22736, 38.08356], [-122.22733, 38.0836], [-122.22727, 38.08363], [-122.22714, 38.08359], [-122.22705, 38.08366], [-122.22731, 38.08391], [-122.22736, 38.08398], [-122.22736, 38.08407], [-122.22734, 38.08418], [-122.2273, 38.08424], [-122.22719, 38.08431], [-122.22705, 38.08411], [-122.22645, 38.08357], [-122.2252, 38.08307], [-122.22521, 38.08267], [-122.22519, 38.0825], [-122.22483, 38.08248], [-122.22482, 38.08238], [-122.22468, 38.08238], [-122.22468, 38.0822], [-122.2246, 38.08215], [-122.22442, 38.08215], [-122.22438, 38.08187], [-122.2243, 38.08155], [-122.22427, 38.08139], [-122.22417, 38.08109], [-122.22401, 38.08111], [-122.22378, 38.08066], [-122.22419, 38.08059], [-122.22434, 38.08062], [-122.22518, 38.08067], [-122.22519, 38.0808], [-122.2257, 38.08086], [-122.22572, 38.08082], [-122.22704, 38.08094], [-122.22706, 38.08112], [-122.22737, 38.08113]]]} | Open Access 1 | Beverly Hills Park | http://www.gvrd.org/?page=Beverly_Hills_Park | 16056 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 11.782 | Beverly Hills Park | |
1990 | 1990 | 1989 | {"type": "Polygon", "coordinates": [[[-122.04353, 37.6184], [-122.04178, 37.61966], [-122.04028, 37.61836], [-122.04197, 37.61708], [-122.04353, 37.6184]]]} | Open Access 1 | Bidwell Park | 16069 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 10.154 | Bidwell Park | ||
1994 | 1994 | 1993 | {"type": "Polygon", "coordinates": [[[-116.84618, 34.26482], [-116.84437, 34.26482], [-116.84437, 34.26376], [-116.84458, 34.26376], [-116.84475, 34.26357], [-116.84509, 34.26291], [-116.8452, 34.26282], [-116.84548, 34.26282], [-116.84618, 34.26482]]]} | Open Access 1 | Big Bear City Park | 16073 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 6.163 | Big Bear City Park | ||
2007 | 2007 | 2006 | {"type": "Polygon", "coordinates": [[[-118.75503, 34.31017], [-118.755, 34.31038], [-118.75436, 34.31114], [-118.75424, 34.31146], [-118.7541, 34.31133], [-118.75389, 34.31143], [-118.75346, 34.31152], [-118.75342, 34.31145], [-118.7532, 34.3115], [-118.75314, 34.31153], [-118.75307, 34.31161], [-118.75304, 34.31171], [-118.75275, 34.31095], [-118.7526, 34.31063], [-118.75242, 34.31053], [-118.75243, 34.31051], [-118.7525, 34.31055], [-118.75258, 34.31057], [-118.75266, 34.31051], [-118.75252, 34.31024], [-118.75237, 34.31004], [-118.7523, 34.30995], [-118.7521, 34.30985], [-118.75209, 34.30982], [-118.75211, 34.3098], [-118.75239, 34.30974], [-118.7527, 34.30974], [-118.75311, 34.30964], [-118.75382, 34.30937], [-118.75389, 34.30939], [-118.75408, 34.30957], [-118.75412, 34.30962], [-118.75411, 34.30966], [-118.75421, 34.30966], [-118.75423, 34.30963], [-118.75423, 34.30959], [-118.75413, 34.30946], [-118.75402, 34.30927], [-118.75395, 34.30916], [-118.75407, 34.30911], [-118.75417, 34.30925], [-118.75427, 34.30949], [-118.75439, 34.30964], [-118.75443, 34.30966], [-118.75449, 34.30963], [-118.75474, 34.30983], [-118.75503, 34.31017]]]} | Open Access 1 | Big Sky Park | 16091 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 10.08 | Big Sky Park | ||
2014 | 2014 | 2013 | {"type": "Polygon", "coordinates": [[[-116.91484, 33.75491], [-116.91479, 33.75495], [-116.91369, 33.75495], [-116.91368, 33.75334], [-116.9141, 33.7533], [-116.91482, 33.7533], [-116.91484, 33.75491]]]} | Open Access 1 | Bill Gray Park | 16105 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 4.761 | Bill Gray Park | ||
2017 | 2017 | 2016 | {"type": "Polygon", "coordinates": [[[-121.63593, 39.77761], [-121.63218, 39.77763], [-121.63219, 39.77495], [-121.63308, 39.77383], [-121.63173, 39.7738], [-121.63278, 39.77294], [-121.63294, 39.77293], [-121.63295, 39.7728], [-121.63365, 39.77224], [-121.63365, 39.77252], [-121.63359, 39.77253], [-121.63359, 39.77266], [-121.63317, 39.77267], [-121.63316, 39.77272], [-121.63305, 39.77273], [-121.63306, 39.77308], [-121.63589, 39.77309], [-121.63593, 39.77761]]]} | Open Access 1 | Bill Park Expansion | 16108 | 2250 | Paradise Recreation and Park District 572 | Special District 4 | Recreation/Parks District 4 | http://www.paradiseprpd.com/ | Special District 4 | 38.95 | Bill Park Expansion | ||
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 | ||
2023 | 2023 | 2022 | {"type": "Polygon", "coordinates": [[[-121.63305, 39.77263], [-121.63295, 39.77265], [-121.63295, 39.77294], [-121.63122, 39.77294], [-121.63122, 39.7705], [-121.63303, 39.77051], [-121.63305, 39.77263]]]} | Open Access 1 | Bille Park | 16114 | 2250 | Paradise Recreation and Park District 572 | Special District 4 | Recreation/Parks District 4 | http://www.paradiseprpd.com/ | Special District 4 | 10.366 | Bille Park | ||
2028 | 2028 | 2027 | {"type": "Polygon", "coordinates": [[[-122.09878, 37.65729], [-122.09825, 37.6575], [-122.09773, 37.65671], [-122.09751, 37.65644], [-122.09709, 37.65605], [-122.09672, 37.65574], [-122.09648, 37.65547], [-122.09632, 37.6551], [-122.09726, 37.65473], [-122.09878, 37.65729]]]} | Open Access 1 | Birchfield Park | 16118 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 5.571 | Birchfield Park | ||
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 | ||
2031 | 2031 | 2030 | {"type": "Polygon", "coordinates": [[[-121.3002, 38.65722], [-121.2998, 38.65714], [-121.29978, 38.65699], [-121.29972, 38.65688], [-121.2996, 38.65675], [-121.29948, 38.65669], [-121.29974, 38.65631], [-121.30018, 38.65631], [-121.3002, 38.65722]]]} | Open Access 1 | Bird Track Park | 16122 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 1.083 | Bird Track Park | ||
2080 | 2080 | 2079 | {"type": "Polygon", "coordinates": [[[-117.12889, 33.61282], [-117.12852, 33.61291], [-117.12886, 33.61428], [-117.12859, 33.61432], [-117.12851, 33.61411], [-117.12842, 33.61354], [-117.1283, 33.61315], [-117.1283, 33.61293], [-117.12828, 33.61272], [-117.12798, 33.6127], [-117.128, 33.61263], [-117.12799, 33.61259], [-117.12794, 33.61253], [-117.12789, 33.61251], [-117.1278, 33.61251], [-117.12774, 33.61254], [-117.12769, 33.61249], [-117.12733, 33.61255], [-117.12733, 33.61251], [-117.12788, 33.61241], [-117.12845, 33.61224], [-117.12854, 33.61226], [-117.12889, 33.61282]]]} | Open Access 1 | Linear Workout Park | 32968 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2.079 | Linear Workout Park | ||
2085 | 2085 | 2084 | {"type": "Polygon", "coordinates": [[[-122.20351, 38.11873], [-122.20328, 38.11883], [-122.20313, 38.11904], [-122.20284, 38.11927], [-122.20219, 38.11961], [-122.20174, 38.11972], [-122.20122, 38.12015], [-122.20077, 38.1204], [-122.20056, 38.12044], [-122.20036, 38.12056], [-122.20022, 38.12088], [-122.19972, 38.12161], [-122.19969, 38.12201], [-122.19851, 38.12033], [-122.19913, 38.12062], [-122.20048, 38.12015], [-122.2031, 38.11852], [-122.20351, 38.11873]]]} | Open Access 1 | Blue Rock Springs Corridor | 16188 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 6.572 | Blue Rock Springs Corridor | ||
2102 | 2102 | 2101 | {"type": "Polygon", "coordinates": [[[-119.03029, 34.22936], [-119.02945, 34.22936], [-119.02945, 34.23037], [-119.02932, 34.23047], [-119.02885, 34.23003], [-119.02813, 34.23004], [-119.02813, 34.22755], [-119.03015, 34.22755], [-119.03015, 34.22886], [-119.0302, 34.22911], [-119.03029, 34.22936]]]} | Open Access 1 | Bob Kildee Community Park | 16209 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 11.967 | Bob Kildee Community Park | ||
2131 | 2131 | 2130 | {"type": "Polygon", "coordinates": [[[-122.06741, 37.97231], [-122.06681, 37.97235], [-122.06681, 37.97255], [-122.06594, 37.97257], [-122.06679, 37.97165], [-122.0674, 37.97163], [-122.06741, 37.97231]]]} | Open Access 1 | Chilpancingo Park | 17201 | 2112 | Pleasant Hill Recreation and Park District 459 | Special District 4 | Recreation/Parks District 4 | http://www.pleasanthillrec.com | Special District 4 | 1.967 | Chilpancingo Park | ||
2156 | 2156 | 2155 | {"type": "Polygon", "coordinates": [[[-118.95325, 34.18233], [-118.94954, 34.18265], [-118.94921, 34.18001], [-118.94982, 34.17958], [-118.95014, 34.17942], [-118.95045, 34.17932], [-118.95086, 34.17926], [-118.95165, 34.17922], [-118.9523, 34.17926], [-118.95325, 34.18233]]]} | Open Access 1 | Borchard Park | 16277 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 27.261 | Borchard Park | ||
2159 | 2159 | 2158 | {"type": "Polygon", "coordinates": [[[-122.23158, 38.15129], [-122.23134, 38.15166], [-122.2313, 38.1517], [-122.23122, 38.15172], [-122.23115, 38.15172], [-122.22964, 38.15153], [-122.22958, 38.1515], [-122.22956, 38.15146], [-122.22963, 38.15108], [-122.22967, 38.15093], [-122.22976, 38.15069], [-122.22982, 38.15065], [-122.2301, 38.15071], [-122.23062, 38.15087], [-122.23115, 38.15107], [-122.23154, 38.15124], [-122.23158, 38.15129]]]} | Open Access 1 | Borges Ranch Park | http://www.gvrd.org/?page=Borges_Ranch_Park | 16284 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 3.378 | Borges Ranch Park | |
2165 | 2165 | 2164 | {"type": "Polygon", "coordinates": [[[-117.47044, 34.01823], [-117.46999, 34.0192], [-117.46848, 34.01888], [-117.46878, 34.0179], [-117.47044, 34.01823]]]} | Open Access 1 | Boulder Hill Park | 16296 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 4.194 | Boulder Hill Park | ||
2182 | 2182 | 2181 | {"type": "Polygon", "coordinates": [[[-121.46013, 38.50773], [-121.45932, 38.50774], [-121.45933, 38.50852], [-121.45855, 38.50763], [-121.45817, 38.50721], [-121.45703, 38.50611], [-121.45794, 38.50611], [-121.4579, 38.50626], [-121.45791, 38.50632], [-121.45798, 38.5064], [-121.45808, 38.50643], [-121.45815, 38.50643], [-121.4583, 38.50639], [-121.4593, 38.50638], [-121.45932, 38.50679], [-121.46012, 38.5068], [-121.46013, 38.50773]]]} | Open Access 1 | Bowling Green Park | 16311 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 7.166 | Bowling Green Park | ||
2245 | 2245 | 2244 | {"type": "Polygon", "coordinates": [[[-122.50552, 37.8807], [-122.50414, 37.88257], [-122.50418, 37.88264], [-122.5035, 37.88285], [-122.50283, 37.8829], [-122.50283, 37.88277], [-122.5035, 37.88273], [-122.50349, 37.88257], [-122.50357, 37.88256], [-122.50358, 37.88245], [-122.5035, 37.88243], [-122.50348, 37.882], [-122.50365, 37.88166], [-122.50394, 37.88126], [-122.50415, 37.88114], [-122.50412, 37.88089], [-122.50325, 37.88052], [-122.50295, 37.88049], [-122.50274, 37.88057], [-122.50252, 37.8806], [-122.50214, 37.88051], [-122.50196, 37.88037], [-122.50139, 37.88007], [-122.50114, 37.8799], [-122.50091, 37.8797], [-122.50052, 37.87927], [-122.50039, 37.87907], [-122.49979, 37.87846], [-122.49961, 37.87831], [-122.49942, 37.87822], [-122.49905, 37.8781], [-122.4986, 37.87792], [-122.49789, 37.87748], [-122.49761, 37.87748], [-122.49731, 37.87746], [-122.49717, 37.87742], [-122.49782, 37.8774], [-122.49895, 37.87798], [-122.49964, 37.87821], [-122.49985, 37.87793], [-122.50177, 37.87906], [-122.50552, 37.8807]]]} | Open Access 1 | Brickyard Park | 16375 | 2162 | Strawberry Recreation District 650 | Special District 4 | Recreation/Parks District 4 | http://strawberry.marin.org/ | Special District 4 | 17.376 | Brickyard Park |
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]);