units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,099 rows where LAYER = 4 and MNG_AG_TYP = 4 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, GAP_STS
MNG_AGENCY >30
- East Bay Regional Park District 130
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 58
- Rancho Simi Recreation and Park District 53
- Conejo Recreation and Park District 50
- Midpeninsula Regional Open Space District 49
- Southgate Recreation and Park District 41
- Marin County Open Space District 40
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 38
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 30
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 25
- Santa Clara Valley Open Space Authority 22
- Sonoma County Agricultural Preservation and Open Space District 21
- Isla Vista Recreation and Park District 18
- Jurupa Area Recreation and Park District 18
- Mission Oaks Recreation and Park District 14
- Apple Valley Recreation and Park District 13
- Livermore Area Recreation and Park District 13
- Pleasant Hill Recreation and Park District 12
- Carmichael Recreation and Park District 12
- Desert Recreation District 11
- Hesperia Recreation and Park District 11
- North Highland Recreation and Park District 11
- Miraleste Recreation and Park District 10
- Napa County Regional Park and Open Space District 9
- Rio Linda Elverta Recreation and Park District 9
- Tuolumne Park and Recreation District 9
- …
DES_TP >30
- Local Park 669
- Local Conservation Area 163
- Local Recreation Area 155
- Local Other or Unknown 28
- Local Historic or Cultural Area 2
- Local Resource Management 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
- …
ACCESS_TYP 4
- Open Access 945
- No Public Access 97
- Restricted Access 56
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 1,099 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
195 | 195 | 194 | {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} | Open Access 1 | 569 | Foglesong Park/Eda Henderson Pool | 18966 | 2203 | Barstow Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2203 | Barstow Recreation and Park District 76 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 9.887 | Foglesong Park/Eda Henderson Pool | 0 | Local Recreation Area 3 | 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 | ||
910 | 910 | 909 | {"type": "Polygon", "coordinates": [[[-117.21458, 34.53082], [-117.21419, 34.53082], [-117.21418, 34.53128], [-117.21261, 34.53128], [-117.2126, 34.53013], [-117.21265, 34.53009], [-117.21457, 34.53009], [-117.21458, 34.53082]]]} | Open Access 1 | 5810 | Thunderbird Park | 26338 | 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 | 5.461 | Thunderbird Park | 0 | Local Park 2 | 4 | ||
2591 | 2591 | 2590 | {"type": "MultiPolygon", "coordinates": [[[[-121.89718, 36.61024], [-121.89709, 36.61029], [-121.89629, 36.60934], [-121.8964, 36.60932], [-121.89718, 36.61024]]], [[[-121.89804, 36.61126], [-121.89796, 36.61131], [-121.89719, 36.6104], [-121.89727, 36.61035], [-121.89804, 36.61126]]], [[[-121.89857, 36.61213], [-121.89845, 36.6122], [-121.89841, 36.61202], [-121.89831, 36.61179], [-121.89821, 36.61162], [-121.89805, 36.61143], [-121.89816, 36.61137], [-121.89831, 36.61155], [-121.89846, 36.6118], [-121.89852, 36.61194], [-121.89857, 36.61213]]], [[[-121.89976, 36.61454], [-121.8996, 36.61463], [-121.89874, 36.61359], [-121.89862, 36.61339], [-121.89853, 36.61314], [-121.8985, 36.61297], [-121.89847, 36.61266], [-121.89862, 36.61283], [-121.89864, 36.61302], [-121.89868, 36.61318], [-121.89875, 36.61336], [-121.89886, 36.61355], [-121.89942, 36.61422], [-121.89947, 36.6142], [-121.89976, 36.61454]]], [[[-121.90075, 36.61569], [-121.90057, 36.61579], [-121.89971, 36.61477], [-121.89987, 36.61468], [-121.90006, 36.61489], [-121.90008, 36.61489], [-121.90075, 36.61569]]], [[[-121.90167, 36.61684], [-121.90153, 36.61692], [-121.90067, 36.6159], [-121.9008, 36.61582], [-121.90167, 36.61684]]], [[[-121.90242, 36.6177], [-121.90225, 36.61776], [-121.90163, 36.61703], [-121.90177, 36.61695], [-121.90242, 36.6177]]], [[[-121.90324, 36.61833], [-121.90322, 36.61834], [-121.90314, 36.61831], [-121.903, 36.61821], [-121.90291, 36.61811], [-121.90302, 36.61806], [-121.90324, 36.61833]]]]} | Open Access 1 | 17932 | Monterey Bay Coastal Trail | 22417 | 2084 | Monterey Peninsula Recreational Trail Joint Powers 537 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2084 | Monterey Peninsula Recreational Trail Joint Powers 530 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.184 | Monterey Bay Coastal Trail | 0 | Local Recreation Area 3 | 4 | ||
2660 | 2660 | 2659 | {"type": "Polygon", "coordinates": [[[-117.25827, 34.54145], [-117.25718, 34.54179], [-117.25716, 34.54027], [-117.25826, 34.54028], [-117.25827, 34.54145]]]} | Open Access 1 | 18164 | Corwin Park | 17669 | 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.691 | Corwin Park | 0 | Local Park 2 | 4 | ||
2666 | 2666 | 2665 | {"type": "Polygon", "coordinates": [[[-121.21401, 36.33581], [-121.21125, 36.33739], [-121.2107, 36.33678], [-121.2099, 36.33723], [-121.2097, 36.3372], [-121.20858, 36.33591], [-121.21228, 36.33384], [-121.21401, 36.33581]]]} | Open Access 1 | 18207 | Oak Park | 30778 | 2042 | Greenfield Public Recreation District 542 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2042 | Greenfield Public Recreation District 535 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 24.875 | Oak Park | 0 | Local Park 2 | 4 | ||
3014 | 3014 | 3013 | {"type": "Polygon", "coordinates": [[[-116.03991, 34.14688], [-116.03988, 34.15024], [-116.03658, 34.15029], [-116.03661, 34.14692], [-116.03991, 34.14688]]]} | Open Access 1 | 24302 | Luckie Park | 21581 | 2265 | Twentynine Palms Park and Recreation District 571 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2265 | Twentynine Palms Park and Recreation District 563 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 28.066 | Luckie Park | 0 | Local Park 2 | 4 | ||
3362 | 3362 | 3361 | {"type": "Polygon", "coordinates": [[[-116.30843, 34.14128], [-116.30425, 34.14132], [-116.30424, 34.13951], [-116.30642, 34.1395], [-116.30643, 34.13956], [-116.30842, 34.13955], [-116.30843, 34.14128]]]} | Open Access 1 | 24295 | Sunburst Park | 25986 | 2230 | Joshua Tree Park and Recreation District 627 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 18.753 | Sunburst Park | 0 | Local Park 2 | 4 | ||
4374 | 4374 | 4373 | {"type": "Polygon", "coordinates": [[[-121.44728, 38.68325], [-121.44665, 38.68325], [-121.44664, 38.68384], [-121.44643, 38.68383], [-121.44643, 38.68325], [-121.444, 38.68323], [-121.44594, 38.6815], [-121.44594, 38.68149], [-121.44573, 38.68135], [-121.44599, 38.68134], [-121.44618, 38.68069], [-121.44629, 38.68061], [-121.44728, 38.68062], [-121.44728, 38.68325]]]} | Open Access 1 | 48538 | Central Park & Horse Arena | 33257 | 2187 | Solano Tri-City and County Cooperative Planning Group 74 | Special District 4 | Open Space District 6 | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 12.526 | Central Park & Horse Arena | None 388 | ||||
4492 | 4492 | 4491 | {"type": "Polygon", "coordinates": [[[-118.35128, 33.78024], [-118.35122, 33.78036], [-118.35108, 33.78051], [-118.35086, 33.78065], [-118.35069, 33.7807], [-118.35057, 33.78035], [-118.35093, 33.78032], [-118.35092, 33.78], [-118.35108, 33.78], [-118.35119, 33.78003], [-118.35127, 33.78011], [-118.35128, 33.78024]]]} | Open Access 1 | 5914 | Unnamed site - Westfield Recreation and Park District | 28676 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.653 | 0 | Local Other or Unknown 14 | 4 | |||
4493 | 4493 | 4492 | {"type": "Polygon", "coordinates": [[[-118.36086, 33.76832], [-118.3608, 33.76862], [-118.36056, 33.76861], [-118.36041, 33.76865], [-118.36031, 33.76842], [-118.36043, 33.76817], [-118.36086, 33.76832]]]} | Open Access 1 | 5915 | Unknown park - Westfield Recreation and Park District | 28677 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.462 | 0 | Local Other or Unknown 14 | 4 | |||
5404 | 5404 | 5403 | {"type": "Polygon", "coordinates": [[[-117.22181, 34.53488], [-117.22174, 34.535], [-117.2217, 34.53513], [-117.22168, 34.53527], [-117.22168, 34.53555], [-117.22166, 34.53558], [-117.22162, 34.5356], [-117.22091, 34.53561], [-117.2209, 34.53514], [-117.22017, 34.53515], [-117.22017, 34.53467], [-117.22045, 34.5346], [-117.22059, 34.53454], [-117.22074, 34.53444], [-117.22112, 34.53478], [-117.22124, 34.53468], [-117.22181, 34.53488]]]} | Open Access 1 | 12495 | Cramer Family Park | 17754 | 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 | 2.825 | Cramer Family Park | 0 | Local Park 2 | 4 | ||
6437 | 6437 | 6436 | {"type": "Polygon", "coordinates": [[[-117.13372, 34.48655], [-117.12931, 34.48651], [-117.12931, 34.48533], [-117.13037, 34.48459], [-117.13067, 34.48392], [-117.13217, 34.48391], [-117.1327, 34.48343], [-117.13274, 34.48292], [-117.13251, 34.48283], [-117.13251, 34.48129], [-117.13371, 34.48132], [-117.13372, 34.48655]]]} | Open Access 1 | 1957 | Horsemen's Center | 20096 | 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 | 33.691 | Horsemen's Ctr. | 0 | Local Recreation Area 3 | 4 | ||
6438 | 6438 | 6437 | {"type": "Polygon", "coordinates": [[[-117.1555, 34.55318], [-117.15316, 34.55317], [-117.15316, 34.55251], [-117.15326, 34.55248], [-117.1533, 34.55243], [-117.15331, 34.55239], [-117.1533, 34.55235], [-117.15324, 34.55222], [-117.15324, 34.55175], [-117.15329, 34.55171], [-117.15334, 34.55169], [-117.15537, 34.55167], [-117.15544, 34.55169], [-117.15548, 34.55175], [-117.1555, 34.55318]]]} | Open Access 1 | 1964 | Sycamore Rocks Park | 26142 | 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 | 8.579 | Sycamore Rocks Park | 0 | Local Park 2 | 4 | ||
6533 | 6533 | 6532 | {"type": "Polygon", "coordinates": [[[-116.08355, 34.12978], [-116.08208, 34.12979], [-116.08206, 34.12438], [-116.08353, 34.12437], [-116.08355, 34.12978]]]} | Open Access 1 | 2940 | Knott Sky Park | 20705 | 2265 | Twentynine Palms Park and Recreation District 571 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2265 | Twentynine Palms Park and Recreation District 563 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 20.118 | Knott Sky Park | 0 | Local Park 2 | 4 | ||
6619 | 6619 | 6618 | {"type": "Polygon", "coordinates": [[[-117.21166, 34.51739], [-117.21088, 34.51795], [-117.2105, 34.51759], [-117.21131, 34.51706], [-117.21142, 34.51709], [-117.2115, 34.51715], [-117.21159, 34.51725], [-117.21166, 34.51739]]]} | Open Access 1 | 4236 | Lion's Park | 21311 | 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 | 1.245 | Lion's Park | 0 | Local Park 2 | 4 | ||
6914 | 6914 | 6913 | {"type": "Polygon", "coordinates": [[[-117.21794, 34.50725], [-117.21794, 34.50766], [-117.2166, 34.50766], [-117.21659, 34.50655], [-117.21716, 34.50654], [-117.21716, 34.50697], [-117.21713, 34.5071], [-117.21716, 34.50719], [-117.21723, 34.50724], [-117.21735, 34.50728], [-117.2175, 34.50725], [-117.21794, 34.50725]]]} | Open Access 1 | 5805 | Norm Schmidt Park | 22794 | 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 | 2.378 | Norm Schmidt Park | 0 | Local Park 2 | 4 | ||
7932 | 7932 | 7931 | {"type": "Polygon", "coordinates": [[[-117.20598, 34.54853], [-117.2057, 34.54853], [-117.20553, 34.5484], [-117.20246, 34.5484], [-117.20244, 34.54399], [-117.20595, 34.54398], [-117.20598, 34.54853]]]} | Open Access 1 | 10719 | Lenny Brewster Sports Center | 21164 | 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 | 39.16 | Lenny Brewster Sports Ctr. | 0 | Local Recreation Area 3 | 4 | ||
9111 | 9111 | 9110 | {"type": "Polygon", "coordinates": [[[-117.17372, 34.56238], [-117.17371, 34.5633], [-117.17151, 34.5633], [-117.17152, 34.56283], [-117.17239, 34.56283], [-117.1724, 34.56238], [-117.17372, 34.56238]]]} | Open Access 1 | 15101 | Virginia Park | 27158 | 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 | 4.099 | Virginia Park | 0 | Local Park 2 | 4 | ||
9306 | 9306 | 9305 | {"type": "Polygon", "coordinates": [[[-117.19678, 34.49915], [-117.19678, 34.5004], [-117.19625, 34.5004], [-117.19623, 34.50005], [-117.19617, 34.49975], [-117.19609, 34.49945], [-117.19597, 34.49916], [-117.19678, 34.49915]]]} | Open Access 1 | 15512 | Yucca Loma Park | 27847 | 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 | 1.976 | Yucca Loma 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]);