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 62
- 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
- Sunrise Recreation and Park District 31
- Cordova Recreation and Park District 30
- Southgate Recreation and Park District 26
- Greater Vallejo Recreation and Park District 24
- North of the River Recreation and Park District 24
- Valley-Wide Recreation and Park District 22
- Monterey Peninsula Regional Park District 21
- 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 668
- No Public Access 86
- Restricted Access 51
MNG_AG_TYP 1
- Recreation/Parks District · 805 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3842 | 3842 | 3841 | {"type": "MultiPolygon", "coordinates": [[[[-122.09248, 37.63911], [-122.0841, 37.6505], [-122.08146, 37.65183], [-122.07932, 37.65272], [-122.07692, 37.65391], [-122.07795, 37.65562], [-122.07648, 37.65631], [-122.07596, 37.6575], [-122.07548, 37.65686], [-122.0758, 37.65603], [-122.07718, 37.65544], [-122.07612, 37.65385], [-122.07844, 37.65278], [-122.07985, 37.65207], [-122.08117, 37.65159], [-122.08237, 37.65106], [-122.0835, 37.65035], [-122.09167, 37.63886], [-122.09176, 37.63896], [-122.09222, 37.63911], [-122.09248, 37.63911]]], [[[-122.09853, 37.63425], [-122.09587, 37.63524], [-122.0951, 37.63524], [-122.09477, 37.63517], [-122.09827, 37.63389], [-122.09853, 37.63425]]], [[[-122.10894, 37.62975], [-122.10565, 37.63124], [-122.0989, 37.63411], [-122.09867, 37.63374], [-122.10872, 37.62921], [-122.10894, 37.62975]]]]} | Open Access 1 | Eden Greenway | 18427 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 54.771 | Eden Greenway | 1970 | |
3844 | 3844 | 3843 | {"type": "Polygon", "coordinates": [[[-122.11882, 37.69374], [-122.1188, 37.69506], [-122.11701, 37.69506], [-122.117, 37.6955], [-122.11632, 37.69548], [-122.11631, 37.6952], [-122.11528, 37.69519], [-122.11529, 37.6942], [-122.11632, 37.69421], [-122.11633, 37.69398], [-122.11716, 37.69399], [-122.11718, 37.69373], [-122.11882, 37.69374]]]} | Open Access 1 | Edendale Park | 18430 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 10.685 | Edendale Park | ||
3847 | 3847 | 3846 | {"type": "Polygon", "coordinates": [[[-116.97601, 33.97243], [-116.97466, 33.97406], [-116.97417, 33.97481], [-116.97355, 33.97529], [-116.97366, 33.97499], [-116.97373, 33.97474], [-116.97393, 33.97458], [-116.9744, 33.97369], [-116.97557, 33.97245], [-116.97558, 33.97244], [-116.97601, 33.97243]]]} | Open Access 1 | Edgar Canyon Nature Park | 18432 | 2205 | Beaumont-Cherry Valley Recreation and Park District 636 | Special District 4 | Recreation/Parks District 4 | http://www.bcvparks.com/ | Special District 4 | 3.12 | Edgar Canyon Nature Park | ||
3850 | 3850 | 3849 | {"type": "MultiPolygon", "coordinates": [[[[-121.25745, 38.71827], [-121.25706, 38.71836], [-121.25661, 38.71824], [-121.25604, 38.71835], [-121.25531, 38.7183], [-121.25481, 38.7183], [-121.25457, 38.71785], [-121.25377, 38.71788], [-121.25328, 38.7182], [-121.25312, 38.71819], [-121.25286, 38.71813], [-121.25264, 38.71812], [-121.25257, 38.71784], [-121.25237, 38.71788], [-121.25149, 38.71703], [-121.25155, 38.71699], [-121.25163, 38.71645], [-121.25132, 38.71635], [-121.25131, 38.71616], [-121.2509, 38.71615], [-121.25093, 38.71604], [-121.25088, 38.71596], [-121.25078, 38.71592], [-121.25061, 38.71591], [-121.25061, 38.71554], [-121.25014, 38.71543], [-121.25015, 38.71537], [-121.24977, 38.71477], [-121.24969, 38.71478], [-121.24951, 38.71459], [-121.24941, 38.71442], [-121.24946, 38.71417], [-121.24989, 38.714], [-121.24981, 38.71437], [-121.25022, 38.71465], [-121.25022, 38.71501], [-121.25049, 38.71539], [-121.25132, 38.71542], [-121.25177, 38.71557], [-121.25215, 38.71577], [-121.2526, 38.71618], [-121.25276, 38.71637], [-121.25277, 38.71658], [-121.25261, 38.71688], [-121.25297, 38.71734], [-121.25333, 38.71738], [-121.25374, 38.71722], [-121.25376, 38.71752], [-121.25438, 38.71751], [-121.25463, 38.71726], [-121.2548, 38.71733], [-121.25492, 38.71737], [-121.2551, 38.7178], [-121.25531, 38.7178], [-121.25609, 38.71779], [-121.25611, 38.71739], [-121.25646, 38.71738], [-121.25695, 38.7173], [-121.25697, 38.71737], [-121.25722, 38.71769], [-121.2574, 38.71774], [-121.25738, 38.71787], [-121.25739, 38.71803], [-121.25745, 38.71827]]], [[[-121.26254, 38.71961], [-121.26116, 38.71952], [-121.26128, 38.71921], [-121.26101, 38.71881], [-121.26072, 38.71861], [-121.26024, 38.71858], [-121.26019, 38.71897], [-121.25863, 38.71886], [-121.25863, 38.71854], [-121.25823, 38.71839], [-121.25818, 38.71824], [-121.25771, 38.7182], [-121.25763, 38.71822], [-121.25758, 38.71806], [-121.25757, 38.71792], [-121.25758, 38.71779], [-121.25762, 38.71768], [-121.25763, 38.71764], [-121.25811, 38.71778], [-121.25821, 38.71765], [-121.25843, 38.7178], [-121.25868, 38.71794], [-121.25895, 38.71806], [-121.25924, 38.71814], [-121.25971, 38.71822], [-121.26008, 38.71788], [-121.2606, 38.71806], [-121.26089, 38.71821], [-121.26131, 38.71847], [-121.26162, 38.71861], [-121.26184, 38.71867], [-121.26209, 38.71872], [-121.26253, 38.71873], [-121.26254, 38.71961]]]]} | Open Access 1 | Edgecliff/Cripple Creek Open Space | 18434 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 24.526 | Edgecliff/Cripple Creek OS | ||
3876 | 3876 | 3875 | {"type": "Polygon", "coordinates": [[[-122.08654, 37.6351], [-122.08475, 37.63514], [-122.08474, 37.63456], [-122.08469, 37.63432], [-122.08496, 37.63427], [-122.08515, 37.63417], [-122.08532, 37.63415], [-122.08538, 37.63412], [-122.0854, 37.63406], [-122.08573, 37.63402], [-122.08623, 37.63465], [-122.08654, 37.6351]]]} | Open Access 1 | Eldridge Park | 18554 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.445 | Eldridge Park | ||
3892 | 3892 | 3891 | {"type": "Polygon", "coordinates": [[[-117.14763, 33.70309], [-117.14757, 33.70315], [-117.14622, 33.70314], [-117.14544, 33.70307], [-117.14539, 33.70302], [-117.14538, 33.70279], [-117.14577, 33.70264], [-117.14604, 33.70252], [-117.14638, 33.70233], [-117.14665, 33.70216], [-117.1468, 33.70229], [-117.14703, 33.70238], [-117.1471, 33.70244], [-117.14715, 33.70251], [-117.14719, 33.70262], [-117.14724, 33.70309], [-117.14763, 33.70309]]]} | Open Access 1 | Eldorado Park | 18552 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 3.13 | Eldorado 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 | ||
3912 | 3912 | 3911 | {"type": "Polygon", "coordinates": [[[-122.22416, 38.11808], [-122.22408, 38.11815], [-122.2239, 38.11838], [-122.22355, 38.11889], [-122.22324, 38.11915], [-122.22282, 38.11985], [-122.22299, 38.12066], [-122.22381, 38.12082], [-122.22312, 38.12224], [-122.22307, 38.12229], [-122.22299, 38.12229], [-122.22143, 38.12204], [-122.22149, 38.11819], [-122.22205, 38.11811], [-122.22269, 38.11779], [-122.2228, 38.11773], [-122.22276, 38.11768], [-122.22303, 38.11754], [-122.22317, 38.11756], [-122.22341, 38.11764], [-122.2236, 38.11774], [-122.22416, 38.11808]]]} | Open Access 1 | Hanns Park | http://www.gvrd.org/?page=Hanns_Park | 19645 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 19.958 | Hanns Park | |
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 |
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]);