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 AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
4163 | 4163 | 4162 | {"type": "Polygon", "coordinates": [[[-117.13273, 33.61299], [-117.13267, 33.61334], [-117.13238, 33.61333], [-117.13235, 33.61297], [-117.13273, 33.61299]]]} | Open Access 1 | 48381 | Mahogany Meadows Pocket Park | 32945 | 6124 | Mahogany Hills Home Owner Association 727 | 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/mahogany-meadows-pocket-park | Riverside 10 | 0.3 | Mahogany Meadows PP | 0 | Local Park 2 | 4 | |
4456 | 4456 | 4455 | {"type": "Polygon", "coordinates": [[[-117.1099, 33.59108], [-117.10987, 33.59122], [-117.10982, 33.59131], [-117.10976, 33.59136], [-117.10963, 33.59141], [-117.10945, 33.59141], [-117.1093, 33.59153], [-117.10929, 33.59152], [-117.10934, 33.59147], [-117.10936, 33.5914], [-117.10933, 33.59112], [-117.10941, 33.59108], [-117.1099, 33.59108]]]} | Open Access 1 | 48396 | Capri Park | 32961 | 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/capri-pocket-park | Riverside 10 | 0.419 | Capri Park | 0 | Local Park 2 | 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 | |
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 | ||
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 | |
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 | ||
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 | ||
11857 | 11857 | 11856 | {"type": "Polygon", "coordinates": [[[-116.33702, 34.11024], [-116.33643, 34.11074], [-116.33563, 34.11215], [-116.33564, 34.11023], [-116.33702, 34.11024]]]} | Open Access 1 | 24300 | Friendly Hills Park | 19115 | 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 | 2.814 | Friendly Hills Park | 0 | Local Park 2 | 4 | ||
11861 | 11861 | 11860 | {"type": "Polygon", "coordinates": [[[-117.21516, 34.52544], [-117.2149, 34.52567], [-117.21459, 34.52587], [-117.21431, 34.52599], [-117.21392, 34.52613], [-117.21357, 34.5263], [-117.21326, 34.52651], [-117.21302, 34.52673], [-117.21227, 34.52624], [-117.2121, 34.52604], [-117.21002, 34.52408], [-117.21079, 34.52352], [-117.21273, 34.5235], [-117.21274, 34.52388], [-117.21516, 34.52544]]]} | Open Access 1 | 24298 | Civic Center Park | 17368 | 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 | 21.171 | Civic Ctr. Park | 0 | Local Park 2 | 4 | ||
14427 | 14427 | 14426 | {"type": "Polygon", "coordinates": [[[-121.73742, 36.48206], [-121.73572, 36.4827], [-121.73546, 36.48248], [-121.73614, 36.48154], [-121.73566, 36.48131], [-121.73587, 36.48102], [-121.7362, 36.4812], [-121.73668, 36.48141], [-121.73694, 36.48155], [-121.7372, 36.48177], [-121.73734, 36.48193], [-121.73742, 36.48206]]]} | Open Access 1 | 44596 | Carmel Valley Park | 16876 | 2337 | Carmel Valley Recreation Park District 1111 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2337 | Carmel Valley Recreation Park District 1065 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.852 | Carmel Valley 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]);