units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
704 rows where DES_TP = 2 and MNG_AG_TYP = 4 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, COUNTY, YR_EST
MNG_AGENCY >30
- East Bay Regional Park District 76
- Hayward Area Recreation and Park District 74
- Valley-Wide Recreation and Park District 57
- Rancho Simi Recreation and Park District 42
- Cordova Recreation and Park District 37
- Southgate Recreation and Park District 34
- Greater Vallejo Recreation and Park District 29
- Conejo Recreation and Park District 25
- Pleasant Valley Recreation and Park District 25
- Sunrise Recreation and Park District 25
- North of the River Recreation and Park District 24
- Jurupa Area Recreation and Park District 16
- Mission Oaks Recreation and Park District 14
- Isla Vista Recreation and Park District 12
- Apple Valley Recreation and Park District 10
- Carmichael Recreation and Park District 10
- North Highland Recreation and Park District 10
- Auburn Area Recreation and Park District 9
- Pleasant Hill Recreation and Park District 9
- Hesperia Recreation and Park District 9
- Monterey Peninsula Regional Park District 8
- Desert Recreation District 8
- Fair Oaks Recreation and Park District 8
- Livermore Area Recreation and Park District 7
- Rio Linda Elverta Recreation and Park District 7
- Big Bear Valley Recreation and Park District 7
- Feather River Recreation and Park District 6
- Boulder Creek Recreation and Park District 5
- Miraleste Recreation and Park District 5
- Orangevale Recreation and Park District 5
- …
ACCESS_TYP 3
- Open Access 659
- No Public Access 27
- Restricted Access 18
MNG_AG_TYP 1
- Recreation/Parks District · 704 ✖
DES_TP 1
- Local Park · 704 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL ▼ | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18 | 18 | 17 | {"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 | 58 | Borchard Park | 16277 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 27.263 | Borchard Park | 0 | Local Park 2 | 4 | |
112 | 112 | 111 | {"type": "MultiPolygon", "coordinates": [[[[-121.89676, 36.61064], [-121.89648, 36.61079], [-121.89639, 36.61069], [-121.8964, 36.61049], [-121.89638, 36.61044], [-121.89628, 36.61029], [-121.89611, 36.6101], [-121.89602, 36.61002], [-121.89595, 36.61], [-121.8958, 36.61], [-121.89572, 36.60995], [-121.8956, 36.60978], [-121.89551, 36.6097], [-121.89543, 36.60948], [-121.89573, 36.60943], [-121.89676, 36.61064]]], [[[-121.89709, 36.61029], [-121.89683, 36.61043], [-121.89595, 36.60939], [-121.89629, 36.60934], [-121.89709, 36.61029]]]]} | Open Access 1 | 327 | San Carlos Beach Park | 24846 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 1.92 | San Carlos Beach Park | 0 | Local Park 2 | 4 | |
197 | 197 | 196 | {"type": "Polygon", "coordinates": [[[-118.66428, 34.25904], [-118.66428, 34.26108], [-118.66395, 34.26099], [-118.66351, 34.2609], [-118.66306, 34.26083], [-118.66261, 34.26078], [-118.66216, 34.26077], [-118.66178, 34.26077], [-118.66094, 34.26084], [-118.66094, 34.25904], [-118.66428, 34.25904]]]} | Open Access 1 | 615 | Santa Susana Park | 25139 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 15.254 | Santa Susana Park | 0 | Local Park 2 | 4 | |
303 | 303 | 302 | {"type": "Polygon", "coordinates": [[[-118.87425, 34.22586], [-118.87258, 34.2261], [-118.87258, 34.22433], [-118.87408, 34.22434], [-118.87409, 34.22539], [-118.87418, 34.22551], [-118.87425, 34.22586]]]} | Open Access 1 | 1040 | Spring Meadow Park | 25741 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 6.467 | Spring Meadow Park | 0 | Local Park 2 | 4 | |
358 | 358 | 357 | {"type": "Polygon", "coordinates": [[[-118.84164, 34.14351], [-118.84162, 34.14361], [-118.84153, 34.1437], [-118.84153, 34.14379], [-118.84163, 34.14385], [-118.84147, 34.14417], [-118.84155, 34.14456], [-118.8412, 34.14464], [-118.84027, 34.14465], [-118.83984, 34.1442], [-118.83987, 34.14412], [-118.84004, 34.14402], [-118.84058, 34.14361], [-118.84113, 34.14306], [-118.84128, 34.14315], [-118.84155, 34.14336], [-118.84164, 34.14351]]]} | Open Access 1 | 1009 | Southshore Hills Park | 25696 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.475 | Southshore Hills Park | 0 | Local Park 2 | 4 | |
365 | 365 | 364 | {"type": "MultiPolygon", "coordinates": [[[[-119.08732, 34.22541], [-119.08716, 34.2256], [-119.08697, 34.22573], [-119.08674, 34.22581], [-119.08637, 34.22589], [-119.08621, 34.22533], [-119.08622, 34.22508], [-119.08664, 34.22498], [-119.08731, 34.22537], [-119.08732, 34.22541]]], [[[-119.08846, 34.22607], [-119.08817, 34.22634], [-119.0866, 34.22666], [-119.08642, 34.22605], [-119.08683, 34.22596], [-119.08707, 34.22587], [-119.08725, 34.22575], [-119.08748, 34.22552], [-119.08752, 34.22551], [-119.08846, 34.22607]]]]} | Open Access 1 | 1045 | Springville Park | 25752 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.87 | Springville Park | 0 | Local Park 2 | 4 | |
368 | 368 | 367 | {"type": "Polygon", "coordinates": [[[-118.91305, 34.18088], [-118.91256, 34.18067], [-118.912, 34.18037], [-118.91123, 34.18041], [-118.91136, 34.17666], [-118.91295, 34.17687], [-118.91305, 34.18088]]]} | Open Access 1 | 1056 | Stagecoach Inn Park | 25777 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 16.214 | Stagecoach Inn Park | 0 | Local Park 2 | 4 | |
447 | 447 | 446 | {"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 | 1418 | Trigo Pasado Park | 26535 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.344 | Trigo Pasado Park | 0 | Local Park 2 | 4 | |
484 | 484 | 483 | {"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 | 1943 | Window to the Sea Park | 27630 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.344 | Window to the Sea Park | 0 | Local Park 2 | 4 | |
487 | 487 | 486 | {"type": "Polygon", "coordinates": [[[-119.05827, 34.22788], [-119.05689, 34.22789], [-119.05662, 34.22786], [-119.05661, 34.22533], [-119.05785, 34.22532], [-119.05785, 34.22557], [-119.05784, 34.22566], [-119.05788, 34.22578], [-119.05795, 34.22584], [-119.05803, 34.22588], [-119.05815, 34.2259], [-119.05826, 34.22588], [-119.05827, 34.22788]]]} | Open Access 1 | 1684 | Valle Lindo Park | 26770 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 10.069 | Valle Lindo Park | 0 | Local Park 2 | 4 | |
491 | 491 | 490 | {"type": "Polygon", "coordinates": [[[-119.00089, 34.23254], [-119.0007, 34.23357], [-118.99913, 34.23337], [-118.99889, 34.23332], [-118.99884, 34.23328], [-118.99892, 34.23277], [-118.99894, 34.23232], [-119.00089, 34.23254]]]} | Open Access 1 | 1963 | Woodcreek Park | 27704 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.956 | Woodcreek Park | 0 | Local Park 2 | 4 | |
515 | 515 | 514 | {"type": "Polygon", "coordinates": [[[-118.67368, 34.2754], [-118.67345, 34.2754], [-118.67293, 34.27548], [-118.67292, 34.27601], [-118.67213, 34.2753], [-118.67207, 34.27515], [-118.67207, 34.27372], [-118.67302, 34.27372], [-118.67356, 34.27375], [-118.67356, 34.27402], [-118.67368, 34.27412], [-118.67368, 34.2754]]]} | Open Access 1 | 1716 | Verde Park | 26986 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 7.268 | Verde Park | 0 | Local Park 2 | 4 | |
540 | 540 | 539 | {"type": "Polygon", "coordinates": [[[-118.8993, 34.1842], [-118.89897, 34.18424], [-118.89814, 34.18437], [-118.89767, 34.18434], [-118.89715, 34.18448], [-118.89638, 34.18443], [-118.89611, 34.18408], [-118.89593, 34.18404], [-118.89683, 34.18341], [-118.8969, 34.18346], [-118.89768, 34.18368], [-118.89819, 34.18346], [-118.89872, 34.18292], [-118.89889, 34.18303], [-118.89887, 34.18356], [-118.8993, 34.1842]]]} | Open Access 1 | 1801 | Walnut Grove Park | 27233 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 6.623 | Walnut Grove Park | 0 | Local Park 2 | 4 | |
544 | 544 | 543 | {"type": "Polygon", "coordinates": [[[-119.01467, 34.22283], [-119.01414, 34.22287], [-119.01409, 34.22258], [-119.01399, 34.22232], [-119.0138, 34.22197], [-119.0135, 34.22159], [-119.01349, 34.22154], [-119.01351, 34.2215], [-119.01392, 34.22133], [-119.01404, 34.2213], [-119.01415, 34.22121], [-119.01463, 34.22119], [-119.01467, 34.22283]]]} | Open Access 1 | 1813 | Calleguas Creek Park | 16738 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 3.236 | Calleguas Creek Park | 0 | Local Park 2 | 4 | |
547 | 547 | 546 | {"type": "Polygon", "coordinates": [[[-118.85957, 34.20397], [-118.85928, 34.20419], [-118.85956, 34.20468], [-118.85943, 34.20577], [-118.85902, 34.20577], [-118.85882, 34.2057], [-118.85753, 34.20575], [-118.85776, 34.20423], [-118.85881, 34.20412], [-118.85882, 34.20405], [-118.85957, 34.20397]]]} | Open Access 1 | 1822 | Waverly Park | 27320 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 7.419 | Waverly Park | 0 | Local Park 2 | 4 | |
592 | 592 | 591 | {"type": "Polygon", "coordinates": [[[-121.94024, 38.01658], [-121.93978, 38.01658], [-121.93977, 38.01672], [-121.93947, 38.01673], [-121.9395, 38.01832], [-121.93948, 38.01832], [-121.93914, 38.01842], [-121.93876, 38.01847], [-121.93842, 38.01836], [-121.93821, 38.01832], [-121.93821, 38.01825], [-121.93793, 38.01815], [-121.9373, 38.01768], [-121.93773, 38.01605], [-121.94023, 38.01603], [-121.94024, 38.01658]]]} | Open Access 1 | 2015 | Ambrose Park | 15445 | 2001 | Ambrose Recreation and Park District 217 | Special District 4 | Recreation/Parks District 4 | http://www.ambroserec.org/ | Special District 4 | 2001 | Ambrose Recreation and Park District 213 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 11.746 | Ambrose Park | 0 | Local Park 2 | 4 | |
783 | 783 | 782 | {"type": "Polygon", "coordinates": [[[-122.09551, 37.63544], [-122.09549, 37.63615], [-122.0955, 37.63682], [-122.09501, 37.63684], [-122.09505, 37.63746], [-122.09413, 37.63754], [-122.0942, 37.63815], [-122.09387, 37.63819], [-122.09387, 37.63901], [-122.09249, 37.63911], [-122.09222, 37.63912], [-122.0919, 37.63901], [-122.09449, 37.63532], [-122.09496, 37.63539], [-122.09551, 37.63544]]]} | Open Access 1 | 5069 | Southgate Park | 25689 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 14.46 | Southgate Park | 1965 | Local Park 2 | 4 | |
800 | 800 | 799 | {"type": "Polygon", "coordinates": [[[-116.73692, 33.70731], [-116.73692, 33.70798], [-116.73675, 33.71539], [-116.73248, 33.71537], [-116.73258, 33.70742], [-116.73272, 33.70733], [-116.73692, 33.70731]]]} | Open Access 1 | 5190 | McCall Memorial Park | 21990 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 88.363 | McCall Memorial Park | 0 | Local Park 2 | 4 | |
818 | 818 | 817 | {"type": "Polygon", "coordinates": [[[-117.1878, 34.44347], [-117.18605, 34.44348], [-117.18605, 34.44269], [-117.18779, 34.44268], [-117.1878, 34.44347]]]} | Open Access 1 | 5287 | Mendel Park | 22148 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 3.478 | Mendel Park | 0 | Local Park 2 | 4 | ||
872 | 872 | 871 | {"type": "Polygon", "coordinates": [[[-120.34928, 36.13978], [-120.34751, 36.13979], [-120.34749, 36.13797], [-120.34786, 36.13796], [-120.34785, 36.13675], [-120.34924, 36.13666], [-120.34928, 36.13978]]]} | Open Access 1 | 5613 | Olsen Park | 23139 | 2021 | Coalinga-Huron Recreation and Park District 275 | Special District 4 | Recreation/Parks District 4 | http://www.chrpd.org/ | Special District 4 | 2021 | Coalinga-Huron Recreation and Park District 270 | Special District 4 | Recreation/Parks District 4 | Fresno 9 | 12.316 | Olsen Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);