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)
MNG_AGENCY >30
- East Bay Regional Park District 102
- Hayward Area Recreation and Park District 59
- Midpeninsula Regional Open Space District 43
- Rancho Simi Recreation and Park District 37
- Marin County Open Space District 36
- Conejo Recreation and Park District 34
- Cordova Recreation and Park District 30
- Sunrise Recreation and Park District 30
- Southgate Recreation and Park District 26
- North of the River Recreation and Park District 24
- Greater Vallejo Recreation and Park District 23
- Monterey Peninsula Regional Park District 21
- Valley-Wide Recreation and Park District 20
- Santa Clara Valley Open Space Authority 20
- Sonoma County Agricultural Preservation and Open Space District 18
- Pleasant Valley Recreation and Park District 13
- Isla Vista Recreation and Park District 12
- Desert Recreation District 12
- Apple Valley Recreation and Park District 11
- Jurupa Area Recreation and Park District 11
- Pleasant Hill Recreation and Park District 10
- Mission Oaks Recreation and Park District 10
- Tuolumne Park and Recreation District 9
- Napa County Regional Park and Open Space District 8
- Auburn Area Recreation and Park District 8
- Rio Linda Elverta Recreation and Park District 8
- Hesperia Recreation and Park District 8
- Carmichael Recreation and Park District 8
- Orangevale Recreation and Park District 8
- North Highland Recreation and Park District 8
- …
ACCESS_TYP 3
- Open Access 660
- No Public Access 86
- Restricted Access 51
MNG_AG_TYP 1
- Recreation/Parks District · 797 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3916 | 3916 | 3915 | {"type": "Polygon", "coordinates": [[[-118.84318, 34.17165], [-118.84311, 34.1721], [-118.84216, 34.17297], [-118.84216, 34.17295], [-118.84101, 34.17208], [-118.84133, 34.17181], [-118.84163, 34.17167], [-118.8419, 34.1716], [-118.84222, 34.17156], [-118.84268, 34.17158], [-118.84318, 34.17165]]]} | Open Access 1 | El Parque de la Paz | 18525 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 4.571 | El Parque de la Paz | ||
3956 | 3956 | 3955 | {"type": "Polygon", "coordinates": [[[-117.17155, 33.74421], [-117.16954, 33.74422], [-117.16953, 33.74303], [-117.17041, 33.74301], [-117.17154, 33.7437], [-117.17155, 33.74421]]]} | Open Access 1 | Eller Park | 18585 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 5.13 | Eller Park | ||
3977 | 3977 | 3976 | {"type": "Polygon", "coordinates": [[[-119.85696, 34.41183], [-119.85695, 34.41279], [-119.85545, 34.41278], [-119.85546, 34.4124], [-119.85612, 34.41239], [-119.85612, 34.41183], [-119.8555, 34.41182], [-119.85551, 34.41148], [-119.85554, 34.41136], [-119.85564, 34.41119], [-119.85579, 34.41106], [-119.85598, 34.41098], [-119.85617, 34.41095], [-119.8564, 34.41097], [-119.85658, 34.41103], [-119.85622, 34.41154], [-119.85621, 34.41181], [-119.85696, 34.41183]]]} | Open Access 1 | Embarcadero Park | 18612 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 4.303 | Embarcadero Park | ||
3979 | 3979 | 3978 | {"type": "Polygon", "coordinates": [[[-119.08491, 35.40132], [-119.08461, 35.40134], [-119.08421, 35.40131], [-119.08354, 35.40131], [-119.08346, 35.40125], [-119.08344, 35.39843], [-119.08349, 35.39838], [-119.08459, 35.39842], [-119.08461, 35.39892], [-119.08458, 35.39901], [-119.08458, 35.39909], [-119.08463, 35.39919], [-119.08475, 35.39924], [-119.08485, 35.39927], [-119.0849, 35.39975], [-119.08491, 35.40132]]]} | Open Access 1 | Emerald Cove Park | 18613 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 9.921 | Emerald Cove Park | ||
4002 | 4002 | 4001 | {"type": "Polygon", "coordinates": [[[-118.99649, 34.22147], [-118.99625, 34.22157], [-118.99619, 34.22163], [-118.99616, 34.22169], [-118.99518, 34.22206], [-118.99471, 34.22128], [-118.9961, 34.22075], [-118.99649, 34.22147]]]} | Open Access 1 | Encanto Park - PVRPD | 18639 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 3.246 | Encanto Park - PVRPD | ||
4052 | 4052 | 4051 | {"type": "Polygon", "coordinates": [[[-116.80514, 34.23956], [-116.80401, 34.23957], [-116.80401, 34.23911], [-116.80513, 34.23911], [-116.80514, 34.23956]]]} | Open Access 1 | Erwin Lake Park | 18700 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 1.292 | Erwin Lake Park | ||
4062 | 4062 | 4061 | {"type": "Polygon", "coordinates": [[[-118.84808, 34.18053], [-118.84789, 34.18078], [-118.84725, 34.18056], [-118.84696, 34.18068], [-118.84674, 34.18092], [-118.84648, 34.1808], [-118.84699, 34.18001], [-118.84808, 34.18053]]]} | Open Access 1 | Estella Park | 18723 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 1.605 | Estella Park | ||
4071 | 4071 | 4070 | {"type": "Polygon", "coordinates": [[[-119.86643, 34.41435], [-119.86641, 34.41438], [-119.86593, 34.41438], [-119.86592, 34.41405], [-119.86446, 34.41405], [-119.86444, 34.41398], [-119.86264, 34.41397], [-119.86265, 34.41314], [-119.86354, 34.41315], [-119.86356, 34.41274], [-119.86402, 34.41274], [-119.86403, 34.41315], [-119.86494, 34.41316], [-119.86494, 34.41352], [-119.86478, 34.41351], [-119.86464, 34.41346], [-119.86454, 34.41348], [-119.86448, 34.41353], [-119.86446, 34.41361], [-119.86449, 34.41368], [-119.86454, 34.41373], [-119.86465, 34.41374], [-119.86476, 34.4137], [-119.86486, 34.41368], [-119.86631, 34.41369], [-119.86633, 34.41384], [-119.86641, 34.41405], [-119.86643, 34.41422], [-119.86643, 34.41435]]]} | Open Access 1 | Estero Park | 18726 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 6.806 | Estero Park | ||
4101 | 4101 | 4100 | {"type": "Polygon", "coordinates": [[[-118.83634, 34.15327], [-118.83465, 34.1532], [-118.83495, 34.15262], [-118.83501, 34.15232], [-118.835, 34.15207], [-118.8353, 34.15199], [-118.8356, 34.15199], [-118.83615, 34.15185], [-118.83612, 34.15261], [-118.83634, 34.15327]]]} | Open Access 1 | Evenstar Park | 18760 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 4.109 | Evenstar Park | ||
4124 | 4124 | 4123 | {"type": "Polygon", "coordinates": [[[-121.2662, 38.66382], [-121.26373, 38.66386], [-121.26369, 38.6623], [-121.26389, 38.66229], [-121.26389, 38.66219], [-121.26226, 38.66221], [-121.26225, 38.66057], [-121.26226, 38.66033], [-121.2623, 38.66015], [-121.26237, 38.66015], [-121.26235, 38.6603], [-121.26249, 38.6603], [-121.26251, 38.66015], [-121.26617, 38.6601], [-121.2662, 38.66382]], [[-121.26539, 38.66175], [-121.26539, 38.66164], [-121.26526, 38.66165], [-121.26526, 38.66175], [-121.26539, 38.66175]]]} | Open Access 1 | Fair Oaks Park | 18787 | 2221 | Fair Oaks Recreation and Park District 940 | Special District 4 | Recreation/Parks District 4 | http://www.fairoakspark.org/ | Special District 4 | 29.046 | Fair Oaks Park | ||
4125 | 4125 | 4124 | {"type": "Polygon", "coordinates": [[[-121.27008, 38.64241], [-121.27007, 38.64269], [-121.27001, 38.64271], [-121.26947, 38.64272], [-121.26947, 38.64236], [-121.26971, 38.64239], [-121.27, 38.64235], [-121.27005, 38.64236], [-121.27008, 38.64241]]]} | Open Access 1 | Fair Oaks Plaza Park | 18788 | 2221 | Fair Oaks Recreation and Park District 940 | Special District 4 | Recreation/Parks District 4 | http://www.fairoakspark.org/ | Special District 4 | 0.495 | Fair Oaks Plaza Park | ||
4127 | 4127 | 4126 | {"type": "Polygon", "coordinates": [[[-121.26899, 38.64206], [-121.26899, 38.6423], [-121.26893, 38.64232], [-121.26893, 38.64271], [-121.26784, 38.64272], [-121.26759, 38.64241], [-121.2679, 38.64212], [-121.26822, 38.64212], [-121.26832, 38.64204], [-121.26846, 38.64198], [-121.26857, 38.64197], [-121.26879, 38.64198], [-121.2689, 38.64201], [-121.26899, 38.64206]]]} | Open Access 1 | Fair Oaks Recreation and Park District 1 | 18789 | 2221 | Fair Oaks Recreation and Park District 940 | Special District 4 | Recreation/Parks District 4 | http://www.fairoakspark.org/ | Special District 4 | 1.942 | Fair Oaks Rec. and Park District 1 | ||
4139 | 4139 | 4138 | {"type": "Polygon", "coordinates": [[[-122.12555, 37.70411], [-122.12363, 37.70561], [-122.12363, 37.70562], [-122.12383, 37.70583], [-122.12339, 37.70622], [-122.12336, 37.70621], [-122.12346, 37.7058], [-122.12372, 37.70538], [-122.12391, 37.70519], [-122.12547, 37.70402], [-122.12555, 37.70411]]]} | Open Access 1 | Fairmont Linear Park | 18804 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 1.132 | Fairmont Linear Park | ||
4142 | 4142 | 4141 | {"type": "Polygon", "coordinates": [[[-122.23434, 38.11875], [-122.23434, 38.11929], [-122.23391, 38.11929], [-122.23391, 38.11901], [-122.23344, 38.11901], [-122.23344, 38.11874], [-122.23434, 38.11875]]]} | Open Access 1 | Fairmont Park | http://www.gvrd.org/?page=Fairmont_Park | 18808 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 0.874 | Fairmont Park | |
4143 | 4143 | 4142 | {"type": "Polygon", "coordinates": [[[-122.11417, 37.70787], [-122.11417, 37.70787], [-122.11329, 37.70866], [-122.11332, 37.70842], [-122.11328, 37.70824], [-122.1132, 37.70811], [-122.11301, 37.70804], [-122.11304, 37.70766], [-122.11417, 37.70787]]]} | Open Access 1 | Fairmont Terrace Park | 18809 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 1.269 | Fairmont Terrace Park | ||
4158 | 4158 | 4157 | {"type": "Polygon", "coordinates": [[[-122.05436, 37.68017], [-122.05423, 37.68062], [-122.05412, 37.68067], [-122.05414, 37.68057], [-122.05389, 37.68045], [-122.0531, 37.68083], [-122.05273, 37.68038], [-122.05255, 37.6796], [-122.05317, 37.67967], [-122.05318, 37.67971], [-122.05436, 37.68017]]]} | Open Access 1 | Fairview Park | 18818 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.055 | Fairview Park | ||
4188 | 4188 | 4187 | {"type": "MultiPolygon", "coordinates": [[[[-122.02333, 37.19756], [-122.02325, 37.19766], [-122.02301, 37.19811], [-122.02238, 37.19796], [-122.02208, 37.19785], [-122.02182, 37.19761], [-122.0173, 37.1977], [-122.01727, 37.19751], [-122.01692, 37.19761], [-122.01668, 37.19778], [-122.01644, 37.19787], [-122.0163, 37.19798], [-122.01615, 37.19813], [-122.01578, 37.19826], [-122.01548, 37.19846], [-122.01526, 37.19855], [-122.01503, 37.19871], [-122.01502, 37.19818], [-122.01502, 37.19504], [-122.01667, 37.19514], [-122.01668, 37.19532], [-122.01729, 37.19533], [-122.01732, 37.19579], [-122.02184, 37.19575], [-122.02297, 37.19568], [-122.02299, 37.19646], [-122.02265, 37.19648], [-122.02273, 37.19697], [-122.02285, 37.19728], [-122.02295, 37.19737], [-122.02333, 37.19756]]], [[[-122.02645, 37.19546], [-122.02612, 37.19596], [-122.02553, 37.19591], [-122.02544, 37.19612], [-122.02523, 37.19615], [-122.02499, 37.19555], [-122.02645, 37.19546]]]]} | No Public Access 3 | Felton Station | 18871 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 44.462 | Felton Station | 2000 | |
4197 | 4197 | 4196 | {"type": "Polygon", "coordinates": [[[-121.29372, 38.59969], [-121.2937, 38.59987], [-121.29369, 38.60011], [-121.29362, 38.60011], [-121.29329, 38.6005], [-121.29325, 38.60071], [-121.29244, 38.60167], [-121.29222, 38.60166], [-121.29222, 38.60129], [-121.29235, 38.60126], [-121.29244, 38.60117], [-121.29247, 38.60106], [-121.29268, 38.60058], [-121.29278, 38.60033], [-121.29299, 38.59957], [-121.29304, 38.59954], [-121.29366, 38.59964], [-121.2937, 38.59966], [-121.29372, 38.59969]]]} | Open Access 1 | Federspiel Park (Rancho Pk) | 18862 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2.955 | Federspiel Park (Rancho Pk) | ||
4253 | 4253 | 4252 | {"type": "Polygon", "coordinates": [[[-122.04308, 37.68652], [-122.04287, 37.68656], [-122.04248, 37.68602], [-122.04086, 37.68619], [-122.04068, 37.68582], [-122.04091, 37.68578], [-122.04108, 37.68544], [-122.041, 37.68517], [-122.04087, 37.68423], [-122.04073, 37.68369], [-122.04069, 37.68286], [-122.04054, 37.682], [-122.04028, 37.68125], [-122.03894, 37.68066], [-122.03881, 37.68018], [-122.03817, 37.68023], [-122.03823, 37.6797], [-122.03637, 37.68023], [-122.03604, 37.67954], [-122.03613, 37.67873], [-122.03264, 37.67776], [-122.03309, 37.67686], [-122.0338, 37.67677], [-122.0343, 37.67623], [-122.03509, 37.67612], [-122.03518, 37.67667], [-122.03535, 37.67714], [-122.03573, 37.67764], [-122.03624, 37.67795], [-122.03704, 37.67824], [-122.03739, 37.67839], [-122.03772, 37.67857], [-122.03834, 37.67893], [-122.03878, 37.67871], [-122.03935, 37.679], [-122.04007, 37.67865], [-122.04036, 37.67781], [-122.04075, 37.6793], [-122.04214, 37.68386], [-122.04308, 37.68652]]]} | Restricted Access 2 | Five Canyons trail corridor | 18933 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 50.727 | Five Canyons trail corridor | ||
4277 | 4277 | 4276 | {"type": "Polygon", "coordinates": [[[-121.44096, 38.48746], [-121.43882, 38.48746], [-121.43884, 38.48537], [-121.44086, 38.48501], [-121.44096, 38.48746]]]} | Open Access 1 | Florin Creek Park | 18964 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 11.319 | Florin Creek 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]);