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 ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER
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 57
- 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
- …
AGNCY_TYP 27 ✖
- City Agency 7,352
- County Agency 687
- Recreation/Parks District 670
- Community Services District 173
- School District 128
- County Agency - Parks 103
- Open Space District 51
- Water District 48
- State Agency 36
- Flood District 28
- Port/Harbor District 24
- Home Owners Association 11
- Commercial 11
- Utility 9
- Special District - Other 9
- Federal Agency 8
- County Agency - Other 8
- Other 4
- Cemetery District 3
- Non Profit - Conservation 2
- Sanitation District 2
- Non Profit - Other 2
- Joint Powers Authority 2
- Transportation Agency 2
- Non Profit - Land Trust 1
- Irrigation District 1
- Education 1
MNG_AG_TYP 16
- City Agency 7,486
- Recreation/Parks District 704
- County Agency 651
- Community Services District 173
- County Agency - Parks 154
- Open Space District 75
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 9,084
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,376 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15316 | 15316 | 15315 | {"type": "Polygon", "coordinates": [[[-118.3888, 33.86582], [-118.38873, 33.86578], [-118.38873, 33.86578], [-118.38878, 33.86576], [-118.3888, 33.86582]]]} | Open Access 1 | 46498 | Scout Park | 29783 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.004 | Scout Park | 0 | Local Park 2 | 4 | |
4443 | 4443 | 4442 | {"type": "Polygon", "coordinates": [[[-118.38594, 33.85816], [-118.38592, 33.85821], [-118.38575, 33.85816], [-118.38594, 33.85816], [-118.38594, 33.85816]]]} | Open Access 1 | 46502 | Third Street & Prospect Avenue Park | 29786 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.012 | Third Street & Prospect Avenue Park | 0 | Local Park 2 | 4 | |
461 | 461 | 460 | {"type": "Polygon", "coordinates": [[[-117.87133, 33.59796], [-117.87133, 33.59796], [-117.87119, 33.59799], [-117.8713, 33.59788], [-117.87133, 33.59796]]]} | Open Access 1 | 47411 | Corona del Mar Pocket Park | 31210 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.015 | Corona del Mar PP | 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 | |
5027 | 5027 | 5026 | {"type": "Polygon", "coordinates": [[[-119.80571, 36.72831], [-119.8057, 36.72842], [-119.80555, 36.72842], [-119.80571, 36.72831], [-119.80571, 36.72831]]]} | Open Access 1 | 47319 | Merced and Pickford Pocket Park | 31025 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.022 | Merced and Pickford PP | 0 | Local Park 2 | 4 | |
5497 | 5497 | 5496 | {"type": "Polygon", "coordinates": [[[-118.39276, 34.11874], [-118.39267, 34.11881], [-118.3926, 34.11875], [-118.39271, 34.11867], [-118.39276, 34.11874]]]} | No Public Access 3 | 12821 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.028 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5944 | 5944 | 5943 | {"type": "Polygon", "coordinates": [[[-119.74575, 36.73906], [-119.74575, 36.73914], [-119.74558, 36.73914], [-119.74558, 36.73906], [-119.74575, 36.73906]]]} | Open Access 1 | 47318 | Maple and Blach Pocket Park | 31024 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.032 | Maple and Blach PP | 0 | Local Park 2 | 4 | |
8712 | 8712 | 8711 | {"type": "Polygon", "coordinates": [[[-121.95422, 37.3521], [-121.95419, 37.35217], [-121.95414, 37.3522], [-121.9539, 37.35222], [-121.95422, 37.3521]]]} | Open Access 1 | 14150 | Sesquicentennial Park | 25322 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 0.032 | Sesquicentennial Park | 0 | Local Park 2 | 4 | |
9522 | 9522 | 9521 | {"type": "Polygon", "coordinates": [[[-122.41296, 37.79709], [-122.41291, 37.7971], [-122.41288, 37.797], [-122.41284, 37.797], [-122.41282, 37.79693], [-122.41292, 37.79692], [-122.41296, 37.79709]]]} | Open Access 1 | 15958 | Broadway Tunnel east Mini Park | 16410 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.033 | Broadway Tunnel east MP | 0 | Local Park 2 | 4 | |
11122 | 11122 | 11121 | {"type": "MultiPolygon", "coordinates": [[[[-121.52266, 38.59411], [-121.52266, 38.59411], [-121.5217, 38.59399], [-121.5217, 38.59399], [-121.52266, 38.59411]]], [[[-121.52228, 38.59583], [-121.52227, 38.59588], [-121.52195, 38.59572], [-121.52228, 38.59582], [-121.52228, 38.59583]]]]} | Open Access 1 | 21392 | Elkhorn Park | 18567 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 0.034 | Elkhorn Park | 0 | Local Park 2 | 4 | |
9632 | 9632 | 9631 | {"type": "Polygon", "coordinates": [[[-122.56097, 37.90679], [-122.56094, 37.90682], [-122.56065, 37.90675], [-122.56067, 37.90669], [-122.56095, 37.90677], [-122.56097, 37.90679]]]} | Open Access 1 | 16234 | Earnscliffe Park | 18358 | 1204 | Mill Valley, City of 227 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | Marin 23 | 0.038 | Earnscliffe Park | 0 | Local Park 2 | 4 | |
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 |
2059 | 2059 | 2058 | {"type": "Polygon", "coordinates": [[[-122.412, 37.74019], [-122.41199, 37.74026], [-122.41175, 37.74024], [-122.41175, 37.74018], [-122.412, 37.74019]]]} | Open Access 1 | 15688 | Prentiss Mini Park | 23985 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.04 | Prentiss MP | 0 | Local Park 2 | 4 | |
14052 | 14052 | 14051 | {"type": "Polygon", "coordinates": [[[-122.48777, 37.85715], [-122.48774, 37.85721], [-122.48754, 37.8571], [-122.48753, 37.85703], [-122.48777, 37.85715]]]} | Open Access 1 | 38053 | Cazneau Park | 16987 | 1327 | Sausalito, City of 445 | City 2 | City Agency 2 | http://www.ci.sausalito.ca.us/index.aspx?page=156 | City 2 | 1327 | Sausalito, City of 439 | City 2 | City Agency 2 | Marin 23 | 0.04 | Cazneau Park | 0 | Local Park 2 | 4 | |
4418 | 4418 | 4417 | {"type": "Polygon", "coordinates": [[[-118.30925, 34.17173], [-118.30908, 34.1716], [-118.30919, 34.17149], [-118.30919, 34.17149], [-118.30925, 34.17173]]]} | Open Access 1 | 46273 | Compass Tree Park | 29556 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/compass-tree-park | Los Angeles 6 | 0.044 | Compass Tree Park | 0 | Local Park 2 | 4 |
449 | 449 | 448 | {"type": "Polygon", "coordinates": [[[-118.18446, 34.11514], [-118.1843, 34.11529], [-118.18412, 34.11522], [-118.1843, 34.11518], [-118.18446, 34.11514]]]} | Open Access 1 | 1807 | Highland Park | 19932 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.045 | Highland Park | 0 | Local Park 2 | 4 | |
4288 | 4288 | 4287 | {"type": "Polygon", "coordinates": [[[-121.55987, 37.00582], [-121.55987, 37.00582], [-121.55949, 37.00582], [-121.55983, 37.00572], [-121.55987, 37.00582]]]} | Open Access 1 | 14538 | Butcher Park | 16546 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | Santa Clara 19 | 0.046 | Butcher Park | 0 | Local Park 2 | 4 | |
5225 | 5225 | 5224 | {"type": "Polygon", "coordinates": [[[-117.89511, 33.61062], [-117.89508, 33.61063], [-117.89507, 33.61067], [-117.89499, 33.61066], [-117.89481, 33.61061], [-117.89479, 33.61058], [-117.89491, 33.61057], [-117.89511, 33.61061], [-117.89511, 33.61062]]]} | Open Access 1 | 47420 | Myrtle Park | 31137 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.047 | Myrtle Park | 0 | Local Park 2 | 4 | |
7954 | 7954 | 7953 | {"type": "Polygon", "coordinates": [[[-122.40734, 37.80463], [-122.40687, 37.80468], [-122.40687, 37.80464], [-122.40733, 37.80459], [-122.40734, 37.80463]]]} | Open Access 1 | 6593 | Chesnut/kearny Mini Park | 17178 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.047 | Chesnut/kearny MP | 0 | Local Park 2 | 4 | |
8164 | 8164 | 8163 | {"type": "Polygon", "coordinates": [[[-119.8072, 36.72725], [-119.80719, 36.72742], [-119.80696, 36.72742], [-119.8072, 36.72725], [-119.8072, 36.72725]]]} | Open Access 1 | 47302 | Merced & Stevens Pocket Park | 31009 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.047 | Merced & Stevens 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]);