units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 314
- San Diego, City of 281
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 118
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 95
- Consumnes Community Services District 92
- Fresno, City of 83
- East Bay Regional Park District 76
- Modesto, City of 76
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Mountains Recreation and Conservation Authority 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 56
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- …
MNG_AG_TYP 16
- City Agency 7,476
- Recreation/Parks District 697
- County Agency 651
- Community Services District 173
- County Agency - Parks 154
- Open Space District 73
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 2
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
LAYER 10 ✖
ACCESS_TYP 4
- Open Access 9,064
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,356 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4234 | 4234 | 4233 | {"type": "Polygon", "coordinates": [[[-120.13118, 35.99946], [-120.13084, 35.99947], [-120.13084, 35.99912], [-120.13117, 35.99912], [-120.13118, 35.99946]]]} | Open Access 1 | 45105 | Avenal Neighborhood Park | 32506 | 1017 | Avenal, City of 735 | City 2 | City Agency 2 | City 2 | 1017 | Avenal, City of 719 | City 2 | City Agency 2 | https://www.cityofavenal.com/Facilities/Facility/Details/Avenal-Neighborhood-Park-3 | Kings 44 | 0.287 | Avenal Neighborhood Park | 0 | Local Park 2 | 4 | |
4348 | 4348 | 4347 | {"type": "Polygon", "coordinates": [[[-121.47463, 41.94817], [-121.47463, 41.94844], [-121.47419, 41.94844], [-121.47419, 41.94817], [-121.47463, 41.94817]]]} | Open Access 1 | 45654 | Ridgeview Park | 28470 | 1704 | Tulelake, City of 719 | City 2 | City Agency 2 | City 2 | 1704 | Tulelake, City of 702 | City 2 | City Agency 2 | Siskiyou 28 | 0.275 | Ridgeview Park | 0 | Local Park 2 | 4 | ||
4353 | 4353 | 4352 | {"type": "Polygon", "coordinates": [[[-121.47657, 41.95688], [-121.47601, 41.95688], [-121.47601, 41.95673], [-121.47656, 41.95673], [-121.47657, 41.95688]]]} | Open Access 1 | 45682 | Veterans Memorial Park | 28496 | 1704 | Tulelake, City of 719 | City 2 | City Agency 2 | City 2 | 1704 | Tulelake, City of 702 | City 2 | City Agency 2 | Siskiyou 28 | 0.189 | Veterans Memorial Park | 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 | ||
5438 | 5438 | 5437 | {"type": "Polygon", "coordinates": [[[-116.49934, 33.94046], [-116.49924, 33.94316], [-116.49819, 33.94316], [-116.49818, 33.94225], [-116.4971, 33.94225], [-116.49718, 33.94045], [-116.49934, 33.94046]]]} | Open Access 1 | 47920 | Mission Springs Park | 32032 | 2330 | Mission Springs Water District 806 | Special District 4 | Water District 13 | Special District 4 | 1670 | Desert Hot Springs, City of 630 | City 2 | City Agency 2 | Riverside 10 | 12.328 | Mission Springs Park | 0 | Local Park 2 | 4 | ||
5576 | 5576 | 5575 | {"type": "Polygon", "coordinates": [[[-115.38799, 32.80773], [-115.38799, 32.80773], [-115.38527, 32.80861], [-115.38529, 32.80805], [-115.38575, 32.80776], [-115.38593, 32.80758], [-115.38606, 32.80752], [-115.38613, 32.80752], [-115.38626, 32.80747], [-115.38633, 32.80732], [-115.38658, 32.80735], [-115.38676, 32.80729], [-115.38696, 32.80727], [-115.3875, 32.80728], [-115.38775, 32.80735], [-115.38787, 32.80744], [-115.38799, 32.80773]]]} | Open Access 1 | 48782 | Earl Walker Park | 33508 | 2436 | Holtville Community Redevelopment Agency 810 | City 2 | City Agency 2 | City 2 | 1139 | Holtville, City of 209 | City 2 | City Agency 2 | http://www.holtville.ca.gov/section.php?id=61 | Imperial 20 | 4.792 | Earl Walker Park | 0 | Local Park 2 | 4 | |
6011 | 6011 | 6010 | {"type": "Polygon", "coordinates": [[[-118.99501, 36.06561], [-118.99069, 36.06572], [-118.99063, 36.06396], [-118.99499, 36.06385], [-118.99501, 36.06561]]]} | Open Access 1 | 812 | Hillcrest Memorial Park | 19967 | 2115 | Porterville Public Cemetery District 823 | Special District 4 | Cemetery District 11 | Special District 4 | 2115 | Porterville Public Cemetery District 801 | Special District 4 | Cemetery District 11 | Tulare 29 | 18.954 | Hillcrest Memorial Park | 0 | Local Park 2 | 4 | ||
6132 | 6132 | 6131 | {"type": "Polygon", "coordinates": [[[-119.20262, 36.30185], [-119.2026, 36.30265], [-119.20192, 36.3026], [-119.20185, 36.30252], [-119.20175, 36.30248], [-119.20153, 36.30251], [-119.20151, 36.30182], [-119.20257, 36.30181], [-119.20262, 36.30185]]]} | Open Access 1 | 1120 | Armstrong Park | 15595 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 2.065 | Armstrong Park | 0 | Local Park 2 | 4 | ||
6146 | 6146 | 6145 | {"type": "Polygon", "coordinates": [[[-119.20698, 36.30827], [-119.20697, 36.30938], [-119.20663, 36.30949], [-119.2063, 36.30958], [-119.20595, 36.30965], [-119.20552, 36.30971], [-119.20556, 36.30825], [-119.20572, 36.30826], [-119.20698, 36.30827]]]} | Open Access 1 | 1146 | Lone Oak Park | 21439 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 4.622 | Lone Oak Park | 0 | Local Park 2 | 4 | ||
6151 | 6151 | 6150 | {"type": "Polygon", "coordinates": [[[-121.92056, 41.96329], [-121.92015, 41.9633], [-121.92014, 41.96304], [-121.92012, 41.96303], [-121.92011, 41.96278], [-121.92056, 41.96277], [-121.92056, 41.96329]]]} | Open Access 1 | 48342 | Dorris Park | 32906 | 1699 | Dorris, City of 829 | City 2 | City Agency 2 | City 2 | 1699 | Dorris, City of 809 | City 2 | City Agency 2 | Siskiyou 28 | 0.509 | Dorris 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 | ||
7492 | 7492 | 7491 | {"type": "Polygon", "coordinates": [[[-120.94993, 40.13923], [-120.94987, 40.13929], [-120.94983, 40.13929], [-120.94982, 40.13916], [-120.94993, 40.13923]]]} | Open Access 1 | 48943 | Triangle Park | 33659 | 2229 | Indian Valley Community Services District 869 | Special District 4 | Community Services District 19 | Special District 4 | 2229 | Indian Valley Community Services District 848 | Special District 4 | Community Services District 17 | http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf | Plumas 57 | 0.02 | Triangle Park | 0 | Local Park 2 | 4 | |
7518 | 7518 | 7517 | {"type": "Polygon", "coordinates": [[[-120.83763, 40.07496], [-120.83763, 40.07516], [-120.837, 40.07515], [-120.837, 40.07495], [-120.83763, 40.07496]]]} | Open Access 1 | 48944 | Chuck Clay Memorial Park | 33660 | 2229 | Indian Valley Community Services District 869 | Special District 4 | Community Services District 19 | Special District 4 | 2229 | Indian Valley Community Services District 848 | Special District 4 | Community Services District 17 | http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf | Plumas 57 | 0.296 | Chuck Clay Memorial Park | 0 | Local Park 2 | 4 | |
7869 | 7869 | 7868 | {"type": "Polygon", "coordinates": [[[-120.12771, 36.00901], [-120.12558, 36.00898], [-120.12556, 36.00807], [-120.1277, 36.00811], [-120.12771, 36.00901]]]} | Open Access 1 | 9869 | Floyd Rice Park | 18965 | 1017 | Avenal, City of 735 | City 2 | City Agency 2 | City 2 | 1017 | Avenal, City of 719 | City 2 | City Agency 2 | Kings 44 | 4.787 | Floyd Rice 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]);