units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 204
- San Diego, City of 166
- Sacramento, City of 158
- San Jose, City of 116
- Consumnes Community Services District 84
- Long Beach, City of 77
- Oakland, City of 73
- San Francisco, City and County of 70
- East Bay Regional Park District 68
- Los Angeles, County of 62
- Hayward Area Recreation and Park District 58
- Tracy, City of 55
- Mountains Recreation and Conservation Authority 54
- Valley-Wide Recreation and Park District 49
- Roseville, City of 48
- San Diego, County of 47
- Huntington Beach, City of 47
- Brentwood, City of 47
- Modesto, City of 47
- Chula Vista, City of 44
- Stockton, City of 43
- Napa, City of 43
- Manteca, City of 43
- San Ramon, City of 40
- Bakersfield, City of 39
- Murrieta, City of 39
- Fresno, City of 37
- El Dorado, County of 37
- Folsom, City of 35
- Davis, City of 34
- …
MNG_AG_TYP 15
- City Agency 5,001
- Recreation/Parks District 545
- County Agency 435
- Community Services District 143
- County Agency - Parks 120
- Open Space District 59
- Water District 30
- School District 27
- Port/Harbor District 17
- Flood District 13
- Special District - Other 9
- County Agency - Other 4
- Cemetery District 1
- Irrigation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 6,174
- Restricted Access 167
- No Public Access 61
- Unknown Access 4
DES_TP 1
- Local Park · 6,406 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4691 | 4691 | 4690 | {"type": "Polygon", "coordinates": [[[-124.08692, 40.86833], [-124.08671, 40.86888], [-124.08598, 40.86873], [-124.08619, 40.86818], [-124.08692, 40.86833]]]} | Open Access 1 | 44899 | Arcata Plaza | 15571 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.01 | Arcata Plaza | 0 | Local Park 2 | 4 | |
4787 | 4787 | 4786 | {"type": "Polygon", "coordinates": [[[-120.86036, 37.48086], [-120.85915, 37.48087], [-120.85916, 37.48008], [-120.86035, 37.48008], [-120.86036, 37.48086]]]} | Open Access 1 | 48062 | Montana Park | 32554 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 2.273 | Montana Park | 2016 | Local Park 2 | 4 | |
4789 | 4789 | 4788 | {"type": "Polygon", "coordinates": [[[-118.45483, 34.29538], [-118.45468, 34.29551], [-118.4543, 34.29522], [-118.45445, 34.29509], [-118.45483, 34.29538]]]} | Open Access 1 | 48105 | North San Fernando Park | 32610 | 1299 | San Fernando, City of 242 | City 2 | City Agency 2 | http://www.sfrcs.com/ | City 2 | 1299 | San Fernando, City of 238 | City 2 | City Agency 2 | Los Angeles 6 | 0.236 | North San Fernando Park | 0 | Local Park 2 | 4 | |
4792 | 4792 | 4791 | {"type": "Polygon", "coordinates": [[[-116.96266, 33.79047], [-116.96174, 33.79124], [-116.96034, 33.79008], [-116.96121, 33.78934], [-116.96266, 33.79047]]]} | Open Access 1 | 48267 | Sallee Park | 32819 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | Riverside 10 | 5.326 | Sallee Park | 0 | Local Park 2 | 4 | |
4794 | 4794 | 4793 | {"type": "Polygon", "coordinates": [[[-119.33362, 35.59357], [-119.33362, 35.59412], [-119.33338, 35.59412], [-119.33338, 35.59392], [-119.33336, 35.59391], [-119.33337, 35.59357], [-119.33362, 35.59357]]]} | Open Access 1 | 48296 | 7th Street Park | 32868 | 1693 | Wasco, City of 782 | City 2 | City Agency 2 | http://www.ci.wasco.ca.us/ | City 2 | 1693 | Wasco, City of 762 | City 2 | City Agency 2 | Kern 36 | 0.339 | 7th Street Park | 0 | Local Park 2 | 4 | |
4826 | 4826 | 4825 | {"type": "Polygon", "coordinates": [[[-118.31504, 34.05232], [-118.31497, 34.05239], [-118.31494, 34.05241], [-118.31469, 34.05242], [-118.31465, 34.0524], [-118.31463, 34.05237], [-118.31463, 34.05232], [-118.31504, 34.05232]]]} | Open Access 1 | 45733 | Wilton Place Park | 28736 | 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.082 | Wilton Place Park | 0 | Local Park 2 | 4 | |
4829 | 4829 | 4828 | {"type": "Polygon", "coordinates": [[[-118.49504, 34.00947], [-118.49495, 34.00953], [-118.49455, 34.00915], [-118.49465, 34.00908], [-118.4947, 34.0091], [-118.49498, 34.00936], [-118.49504, 34.00947]]]} | Open Access 1 | 46569 | Chess Park | 29873 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.191 | Chess Park | 0 | Local Park 2 | 4 | |
4830 | 4830 | 4829 | {"type": "Polygon", "coordinates": [[[-118.01607, 33.95413], [-118.01537, 33.95498], [-118.01511, 33.95485], [-118.01456, 33.95558], [-118.01606, 33.9564], [-118.01525, 33.95741], [-118.01384, 33.95663], [-118.01356, 33.9561], [-118.0145, 33.95494], [-118.0145, 33.95492], [-118.01435, 33.95484], [-118.01524, 33.9537], [-118.01607, 33.95413]]]} | Restricted Access 2 | 46570 | East Whittier Middle School Park | 31913 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 10.453 | East Whittier Middle School Park | 0 | Local Park 2 | 4 | |
4833 | 4833 | 4832 | {"type": "Polygon", "coordinates": [[[-117.22565, 32.94823], [-117.22556, 32.94851], [-117.22548, 32.94884], [-117.22537, 32.94883], [-117.22534, 32.94874], [-117.22529, 32.94871], [-117.22492, 32.94855], [-117.22507, 32.94829], [-117.22475, 32.94814], [-117.22487, 32.94786], [-117.22494, 32.94784], [-117.22564, 32.94821], [-117.22565, 32.94823]]]} | Open Access 1 | 46724 | Windwood Mini-Park | 30155 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.2 | Windwood Mini-Park | 0 | Local Park 2 | 4 | |
4834 | 4834 | 4833 | {"type": "MultiPolygon", "coordinates": [[[[-117.22199, 32.94617], [-117.22199, 32.94675], [-117.22194, 32.94777], [-117.22147, 32.9478], [-117.22144, 32.94779], [-117.22141, 32.94777], [-117.22136, 32.9473], [-117.22115, 32.94667], [-117.22112, 32.94649], [-117.22111, 32.94628], [-117.22112, 32.94624], [-117.22116, 32.94622], [-117.22199, 32.94617]]], [[[-117.22207, 32.94807], [-117.22204, 32.94836], [-117.22206, 32.94838], [-117.22203, 32.94844], [-117.22205, 32.9485], [-117.22201, 32.94882], [-117.22204, 32.94885], [-117.2214, 32.94883], [-117.22144, 32.94797], [-117.22193, 32.94794], [-117.22207, 32.94807]]]]} | Open Access 1 | 46725 | Carmel Mission Neighborhood Park | 30156 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.329 | Carmel Mission Neighborhood Park | 0 | Local Park 2 | 4 | |
4835 | 4835 | 4834 | {"type": "Polygon", "coordinates": [[[-117.16545, 32.71007], [-117.16544, 32.7103], [-117.16485, 32.7103], [-117.16486, 32.71017], [-117.16489, 32.71007], [-117.16496, 32.70999], [-117.16498, 32.70984], [-117.16545, 32.71007]]]} | Open Access 1 | 46726 | Children's Museum Park | 30173 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.499 | Children's Museum Park | 0 | Local Park 2 | 4 | |
4836 | 4836 | 4835 | {"type": "Polygon", "coordinates": [[[-117.16293, 32.73441], [-117.16293, 32.73463], [-117.16226, 32.73463], [-117.16226, 32.734], [-117.16259, 32.73399], [-117.1626, 32.73441], [-117.16293, 32.73441]]]} | Open Access 1 | 46727 | Olive Street Mini-Park | 30174 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.745 | Olive Street Mini-Park | 0 | Local Park 2 | 4 | |
4837 | 4837 | 4836 | {"type": "Polygon", "coordinates": [[[-116.40704, 34.09993], [-116.40701, 34.10044], [-116.40669, 34.10048], [-116.4059, 34.10067], [-116.40549, 34.10068], [-116.4055, 34.09916], [-116.40621, 34.09919], [-116.40642, 34.09925], [-116.40681, 34.09941], [-116.40686, 34.09947], [-116.40692, 34.09978], [-116.40704, 34.09993]]]} | Open Access 1 | 48501 | Essig Park | 33209 | 1356 | Yucca Valley, Town of 272 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | San Bernardino 22 | 4.998 | Essig Park | 0 | Local Park 2 | 4 | |
4839 | 4839 | 4838 | {"type": "Polygon", "coordinates": [[[-119.71553, 36.86337], [-119.71552, 36.86421], [-119.71506, 36.86414], [-119.71502, 36.8641], [-119.71503, 36.8633], [-119.71507, 36.86328], [-119.71553, 36.86337]]]} | Open Access 1 | 48576 | Pinnacles Park | 33286 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.026 | Pinnacles Park | 0 | Local Park 2 | 4 | |
4841 | 4841 | 4840 | {"type": "Polygon", "coordinates": [[[-116.95082, 33.76272], [-116.95023, 33.76243], [-116.95039, 33.76233], [-116.95042, 33.76227], [-116.95043, 33.76223], [-116.95039, 33.76215], [-116.94999, 33.76177], [-116.95014, 33.76153], [-116.95081, 33.76152], [-116.95082, 33.76272]]]} | Open Access 1 | 48398 | Hafliger Park | 32964 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304536 | Riverside 10 | 1.6 | Hafliger Park | 0 | Local Park 2 | 4 |
4844 | 4844 | 4843 | {"type": "Polygon", "coordinates": [[[-117.30042, 33.16416], [-117.30022, 33.16457], [-117.30007, 33.16511], [-117.30001, 33.16558], [-117.30001, 33.16585], [-117.30008, 33.16623], [-117.30014, 33.16643], [-117.30038, 33.16702], [-117.30038, 33.16706], [-117.30035, 33.1671], [-117.29881, 33.16761], [-117.29876, 33.1676], [-117.29872, 33.16755], [-117.29802, 33.16583], [-117.29797, 33.16563], [-117.29795, 33.16544], [-117.298, 33.16505], [-117.29814, 33.16471], [-117.29822, 33.16458], [-117.29833, 33.16445], [-117.29862, 33.16422], [-117.29889, 33.16405], [-117.29965, 33.16377], [-117.29974, 33.16387], [-117.30042, 33.16416]]]} | Open Access 1 | 1099 | Calavera Park | 29986 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/calavera.asp | San Diego 4 | 16.79 | Calavera Park | 0 | Local Park 2 | 4 |
4846 | 4846 | 4845 | {"type": "MultiPolygon", "coordinates": [[[[-119.73568, 34.45038], [-119.73544, 34.45039], [-119.73544, 34.45079], [-119.73524, 34.45095], [-119.73485, 34.45159], [-119.73481, 34.45214], [-119.73369, 34.45213], [-119.73436, 34.45153], [-119.73445, 34.45128], [-119.73426, 34.45121], [-119.73432, 34.45069], [-119.73489, 34.45026], [-119.73488, 34.44987], [-119.73564, 34.45003], [-119.73568, 34.45038]]], [[[-119.73562, 34.44978], [-119.73477, 34.44958], [-119.73475, 34.44943], [-119.73453, 34.4491], [-119.73428, 34.44881], [-119.73413, 34.44825], [-119.73413, 34.44798], [-119.73429, 34.44771], [-119.73453, 34.44745], [-119.73478, 34.44691], [-119.73504, 34.44659], [-119.7351, 34.44647], [-119.73546, 34.44662], [-119.73554, 34.4467], [-119.73559, 34.44682], [-119.73559, 34.44688], [-119.73527, 34.44708], [-119.73525, 34.44735], [-119.73516, 34.44757], [-119.73518, 34.44818], [-119.73517, 34.4484], [-119.73526, 34.44867], [-119.73549, 34.44928], [-119.73551, 34.44941], [-119.73562, 34.44964], [-119.73562, 34.44978]]]]} | Open Access 1 | 1101 | Stevens Park | 25842 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 11.199 | Stevens Park | 0 | Local Park 2 | 4 | |
4847 | 4847 | 4846 | {"type": "Polygon", "coordinates": [[[-117.86078, 33.8789], [-117.8606, 33.87928], [-117.86047, 33.87925], [-117.86035, 33.8795], [-117.86009, 33.87938], [-117.85998, 33.87937], [-117.85989, 33.8794], [-117.85983, 33.87945], [-117.85977, 33.87954], [-117.85919, 33.87936], [-117.85962, 33.87845], [-117.8607, 33.87881], [-117.86067, 33.87888], [-117.86078, 33.8789]]]} | Open Access 1 | 1103 | Goldenrod Park | 19377 | 1255 | Placentia, City of 241 | City 2 | City Agency 2 | http://www.placentia.org/ | City 2 | 1255 | Placentia, City of 237 | City 2 | City Agency 2 | Orange 3 | 2.658 | Goldenrod Park | 0 | Local Park 2 | 4 | |
4848 | 4848 | 4847 | {"type": "Polygon", "coordinates": [[[-117.93748, 33.62363], [-117.93728, 33.62371], [-117.9371, 33.62381], [-117.93693, 33.62393], [-117.9367, 33.62416], [-117.93646, 33.62403], [-117.93612, 33.6238], [-117.93624, 33.6237], [-117.93632, 33.62366], [-117.93648, 33.6236], [-117.93665, 33.62356], [-117.93691, 33.62355], [-117.93729, 33.62357], [-117.93748, 33.62359], [-117.93748, 33.62363]]]} | Open Access 1 | 47424 | Sunset Ridge Park | 31140 | 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 | 1.077 | Sunset Ridge Park | 0 | Local Park 2 | 4 | |
4849 | 4849 | 4848 | {"type": "Polygon", "coordinates": [[[-117.96882, 33.69825], [-117.96782, 33.69826], [-117.96781, 33.69814], [-117.96791, 33.6981], [-117.96795, 33.69803], [-117.96786, 33.6978], [-117.96785, 33.69704], [-117.96787, 33.697], [-117.96792, 33.69697], [-117.96846, 33.69698], [-117.96869, 33.69704], [-117.96871, 33.69765], [-117.96882, 33.69771], [-117.96879, 33.69775], [-117.96878, 33.69781], [-117.96882, 33.69799], [-117.96882, 33.69825]]]} | Open Access 1 | 1676 | Helm Park | 19808 | 1111 | Fountain Valley, City of 273 | City 2 | City Agency 2 | http://www.fountainvalley.org/visitors/parks/ | City 2 | 1111 | Fountain Valley, City of 268 | City 2 | City Agency 2 | Orange 3 | 2.86 | Helm 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]);