units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
991 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP
MNG_AGENCY 86
- East Bay Regional Park District 101
- Hayward Area Recreation and Park District 77
- Valley-Wide Recreation and Park District 66
- Rancho Simi Recreation and Park District 52
- Conejo Recreation and Park District 47
- Marin County Open Space District 40
- Southgate Recreation and Park District 39
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 38
- Greater Vallejo Recreation and Park District 32
- Pleasant Valley Recreation and Park District 31
- Midpeninsula Regional Open Space District 30
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 18
- Isla Vista Recreation and Park District 18
- Jurupa Area Recreation and Park District 18
- Desert Recreation District 14
- Mission Oaks Recreation and Park District 14
- Apple Valley Recreation and Park District 13
- Pleasant Hill Recreation and Park District 12
- Carmichael Recreation and Park District 12
- Auburn Area Recreation and Park District 11
- Hesperia Recreation and Park District 11
- North Highland Recreation and Park District 11
- Miraleste Recreation and Park District 10
- Livermore Area Recreation and Park District 9
- Rio Linda Elverta Recreation and Park District 9
- Orangevale Recreation and Park District 9
- Fair Oaks Recreation and Park District 9
- Riverside County Regional Park and Open Space District 8
- Tuolumne Park and Recreation District 8
- La Selva Beach Recreation District 8
- Feather River Recreation and Park District 7
- West Side Recreation and Park District 7
- Big Bear Valley Recreation and Park District 7
- Truckee-Donner Recreation and Park District 6
- Paradise Recreation and Park District 6
- Strawberry Recreation District 6
- Boulder Creek Recreation and Park District 5
- North County Recreation and Park District 5
- Tehachapi Valley Recreation and Parks District 5
- Georgetown Divide Recreation District 5
- Coalinga-Huron Recreation and Park District 4
- Shafter Recreation and Park District 4
- Wasco Recreation and Park District 4
- Monte Rio Recreation and Park District 4
- Arbuckle Parks and Recreation District 4
- Arden Manor Recreation and Park District 4
- Russian River Recreation and Park District 4
- Ambrose Recreation and Park District 3
- Santa Clara Valley Open Space Authority 3
- McFarland Recreation and Park District 3
- Joshua Tree Park and Recreation District 3
- Arcade Creek Recreation and Park District 3
- Valley Center Parks and Recreation 3
- Durham Recreation and Park District 3
- Barstow Recreation and Park District 2
- Napa County Regional Park and Open Space District 2
- Rim of the World Recreation and Park District 2
- Sonoma County Agricultural Preservation and Open Space District 2
- Twentynine Palms Park and Recreation District 2
- Mt. Shasta Recreation and Park District 2
- Beaumont-Cherry Valley Recreation and Park District 2
- Westfield Recreation and Park District 2
- Arden Park Recreation and Park District 2
- Weaverville - Douglas City Recreation District 2
- Weed Recreation and Parks District 2
- Bear Mountain Recreation and Park District 2
- Chico Area Recreation and Park District 1
- Monterey Peninsula Recreational Trail Joint Powers 1
- Greenfield Public Recreation District 1
- Camp Meeker Recreation and Parks District 1
- Jenny Lind Veterans Memorial District 1
- Soledad-Mission Recreation District 1
- Almanor Recreation and Park District 1
- Lake Cuyamaca Park and Recreation District 1
- Dunsmuir Recreation and Park District 1
- Central Plumas Recreation and Parks District 1
- Opal Cliffs Recreation District 1
- San Andreas Recreation and Park District 1
- Carmel Valley Recreation Park District 1
- Western Gateway Recreation and Park District 1
- Ridgecrest Ranchos Recreation and Park District 1
- Highlands Recreation District 1
- Ladera Recreation District 1
- Rancho Rinconada Recreation and Park District 1
DES_TP 62
- Local Park 659
- Local Recreation Area 150
- Local Conservation Area 102
- Local Other or Unknown 21
- Local Historic or Cultural Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- Recreation/Parks District · 991 ✖
ACCESS_TYP 1
- Open Access · 991 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5079 | 5079 | 5078 | {"type": "Polygon", "coordinates": [[[-119.01469, 34.22393], [-119.01462, 34.2239], [-119.01463, 34.22384], [-119.01461, 34.22379], [-119.01469, 34.22376], [-119.01469, 34.22393]]]} | Open Access 1 | 15062 | Pleasant Valley Recreation and Park District | 23802 | 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 | 0.025 | Pleasant Valley Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
15921 | 15921 | 15920 | {"type": "Polygon", "coordinates": [[[-122.34943, 37.42376], [-122.34901, 37.4238], [-122.34867, 37.42379], [-122.34867, 37.42379], [-122.34943, 37.42376]]]} | Open Access 1 | 17888 | Purisima Creek Redwoods Open Space Preserve | 6528 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_purisima.asp | San Mateo 15 | 0.029 | Purisima Creek Redwoods OSP | 1982 | Local Conservation Area 4 | 2 |
11403 | 11403 | 11402 | {"type": "Polygon", "coordinates": [[[-122.26076, 37.8998], [-122.26076, 37.8998], [-122.2605, 37.89989], [-122.26062, 37.89973], [-122.26076, 37.8998]]]} | Open Access 1 | 23017 | Tilden Regional Park | 3324 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/tilden | Alameda 17 | 0.038 | Tilden RP | 1936 | Local Park 2 | 4 |
5083 | 5083 | 5082 | {"type": "Polygon", "coordinates": [[[-118.89482, 34.22828], [-118.89475, 34.22845], [-118.8946, 34.2284], [-118.8946, 34.22839], [-118.89482, 34.22828]]]} | Open Access 1 | 15581 | Conejo Recreation and Park District | 17586 | 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 | 0.041 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
16801 | 16801 | 16800 | {"type": "Polygon", "coordinates": [[[-119.86959, 34.41246], [-119.86959, 34.4126], [-119.86943, 34.41258], [-119.86943, 34.41245], [-119.86959, 34.41246]]]} | Open Access 1 | 13879 | Isla Vista Recreation and Park District | 20280 | 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.058 | Isla Vista Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
6994 | 6994 | 6993 | {"type": "Polygon", "coordinates": [[[-121.07803, 38.89568], [-121.07803, 38.89571], [-121.07746, 38.8957], [-121.07748, 38.89564], [-121.07803, 38.89568]]]} | Open Access 1 | 47558 | Herschel Young Park | 31275 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | Placer 35 | 0.061 | Herschel Young Park | 0 | Local Park 2 | 4 | |
16805 | 16805 | 16804 | {"type": "Polygon", "coordinates": [[[-118.90091, 34.2165], [-118.90088, 34.21655], [-118.90042, 34.2164], [-118.90045, 34.21635], [-118.90091, 34.2165]]]} | Open Access 1 | 15583 | Conejo Recreation and Park District | 17586 | 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 | 0.068 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
4673 | 4673 | 4672 | {"type": "Polygon", "coordinates": [[[-121.86411, 36.93794], [-121.86404, 36.93797], [-121.86384, 36.93798], [-121.86379, 36.93797], [-121.86377, 36.93793], [-121.86383, 36.93779], [-121.86393, 36.93787], [-121.86398, 36.93783], [-121.86411, 36.93794]]]} | Open Access 1 | 36646 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.092 | 0 | Local Other or Unknown 14 | 4 | ||
12628 | 12628 | 12627 | {"type": "Polygon", "coordinates": [[[-117.35578, 34.42283], [-117.35576, 34.4229], [-117.35578, 34.42299], [-117.35577, 34.42306], [-117.35568, 34.42309], [-117.35563, 34.42305], [-117.35562, 34.42299], [-117.35559, 34.42289], [-117.35562, 34.42278], [-117.35572, 34.42277], [-117.35578, 34.42283]]]} | Open Access 1 | 29427 | Sapphire Park | 25154 | 2227 | Hesperia Recreation and Park District 609 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 0.12 | Sapphire Park | 0 | Local Park 2 | 4 | |
13189 | 13189 | 13188 | {"type": "Polygon", "coordinates": [[[-122.1211, 37.12664], [-122.12089, 37.12679], [-122.12081, 37.12657], [-122.12102, 37.12645], [-122.1211, 37.12664]]]} | Open Access 1 | 35180 | Junction Park | 28529 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 0.129 | Junction Park | 0 | Local Park 2 | 4 |
8543 | 8543 | 8542 | {"type": "MultiPolygon", "coordinates": [[[[-119.09761, 35.40048], [-119.09761, 35.40048], [-119.0976, 35.40055], [-119.09755, 35.40051], [-119.09761, 35.40048]]], [[[-119.09798, 35.40118], [-119.09789, 35.40109], [-119.09783, 35.40095], [-119.0979, 35.401], [-119.09794, 35.40106], [-119.09798, 35.40118]]], [[[-119.09823, 35.4015], [-119.0981, 35.40149], [-119.09804, 35.40138], [-119.09808, 35.40132], [-119.09823, 35.4015]]], [[[-119.09895, 35.39986], [-119.09895, 35.39986], [-119.09864, 35.39995], [-119.09889, 35.3998], [-119.09895, 35.39986]]], [[[-119.09949, 35.40115], [-119.09931, 35.40122], [-119.09921, 35.40121], [-119.09937, 35.40109], [-119.09947, 35.40107], [-119.09949, 35.40115]]]]} | Open Access 1 | 13462 | River Lakes Ranch Community Park | 24410 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 0.141 | River Lakes Ranch Community Park | 0 | Local Park 2 | 4 | |
14442 | 14442 | 14441 | {"type": "Polygon", "coordinates": [[[-117.09337, 33.59269], [-117.09337, 33.59287], [-117.09303, 33.59287], [-117.09303, 33.59269], [-117.09337, 33.59269]]]} | Open Access 1 | 48260 | Northfield Park | 32814 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/northfield-park | Riverside 10 | 0.152 | Northfield Park | 0 | Local Park 2 | 4 |
11316 | 11316 | 11315 | {"type": "Polygon", "coordinates": [[[-120.23983, 37.96099], [-120.23982, 37.96122], [-120.23954, 37.96122], [-120.23954, 37.96099], [-120.23983, 37.96099]]]} | Open Access 1 | 48052 | Bay Street Tot Lot | 32546 | 2169 | Tuolumne Park and Recreation District 741 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | https://www.tuolumnerecreation.com/TPRD_facilities.html | Tuolumne 21 | 0.163 | Bay Street Tot Lot | 2011 | Local Recreation Area 3 | 4 |
15485 | 15485 | 15484 | {"type": "Polygon", "coordinates": [[[-121.8621, 36.93337], [-121.86183, 36.93378], [-121.86183, 36.93423], [-121.86175, 36.93427], [-121.86176, 36.93376], [-121.86206, 36.93332], [-121.8621, 36.93337]]]} | Open Access 1 | 43087 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.166 | 0 | Local Other or Unknown 14 | 4 | ||
15006 | 15006 | 15005 | {"type": "Polygon", "coordinates": [[[-122.05718, 37.94618], [-122.05718, 37.94618], [-122.057, 37.94673], [-122.05698, 37.94654], [-122.05696, 37.94645], [-122.05688, 37.94625], [-122.05716, 37.94615], [-122.05718, 37.94618]]]} | Open Access 1 | 45656 | Sherman Acres Neighborhood Park | 28472 | 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 | Contra Costa 12 | 0.171 | Sherman Acres Neighborhood Park | 0 | Local Park 2 | 4 | |
16603 | 16603 | 16602 | {"type": "Polygon", "coordinates": [[[-119.85461, 34.41319], [-119.85461, 34.41344], [-119.85433, 34.41344], [-119.85433, 34.41319], [-119.85461, 34.41319]]]} | Open Access 1 | 13888 | Isla Vista Recreation and Park District | 20280 | 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.178 | Isla Vista Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5258 | 5258 | 5257 | {"type": "Polygon", "coordinates": [[[-117.1093, 33.59153], [-117.1089, 33.59184], [-117.10882, 33.59184], [-117.10882, 33.59154], [-117.10915, 33.59157], [-117.10922, 33.59155], [-117.10929, 33.59152], [-117.1093, 33.59153]]]} | Open Access 1 | 48383 | Pompei Pocket Park | 32947 | 6123 | Brindisi Owners Association 763 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/pompei-pocket-park | Riverside 10 | 0.197 | Pompei PP | 0 | Local Park 2 | 4 | |
6465 | 6465 | 6464 | {"type": "Polygon", "coordinates": [[[-117.10035, 33.59259], [-117.10035, 33.59281], [-117.09998, 33.59281], [-117.09998, 33.59259], [-117.10035, 33.59259]]]} | Open Access 1 | 48392 | Watermill Park | 32956 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/watermill-park | Riverside 10 | 0.202 | Watermill Park | 0 | Local Park 2 | 4 |
13066 | 13066 | 13065 | {"type": "Polygon", "coordinates": [[[-121.74145, 37.61399], [-121.74132, 37.61413], [-121.74116, 37.61418], [-121.74067, 37.61426], [-121.74045, 37.61437], [-121.74047, 37.61426], [-121.74145, 37.61399]]]} | Open Access 1 | 34939 | Lake Del Valle SRA | 1594 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.parks.ca.gov/?page_id=537 | Alameda 17 | 0.204 | Lake Del Valle SRA | 2000 | None 1132 | |
6391 | 6391 | 6390 | {"type": "Polygon", "coordinates": [[[-117.10569, 33.59244], [-117.10566, 33.59249], [-117.10549, 33.59255], [-117.10527, 33.59259], [-117.10527, 33.59237], [-117.10566, 33.59232], [-117.10569, 33.59244]]]} | Open Access 1 | 48388 | Sicily Pocket Park | 32952 | 6123 | Brindisi Owners Association 763 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/sicily-pocket-park | Riverside 10 | 0.212 | Sicily PP | 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]);