units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7,486 rows where DES_TP = 2 and MNG_AG_TYP = 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
- Fresno, City of 83
- Modesto, City of 76
- Huntington Beach, City of 74
- Tracy, City of 69
- Santa Rosa, City of 68
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- 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
- Napa, City of 46
- San Ramon, City of 45
- Fremont, City of 44
- Berkeley, City of 43
- Fullerton, City of 41
- Murrieta, City of 41
- Redding, City of 41
- …
ACCESS_TYP 3
- Open Access 7,297
- Restricted Access 151
- No Public Access 38
MNG_AG_TYP 1
- City Agency · 7,486 ✖
DES_TP 1
- Local Park · 7,486 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
378 | 378 | 377 | {"type": "Polygon", "coordinates": [[[-119.20947, 36.30166], [-119.20848, 36.30166], [-119.20849, 36.30084], [-119.20946, 36.30084], [-119.20947, 36.30166]]]} | Open Access 1 | 1136 | Jennings Park | 20389 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 1.978 | Jennings Park | 0 | Local Park 2 | 4 | ||
381 | 381 | 380 | {"type": "Polygon", "coordinates": [[[-119.21304, 36.31701], [-119.213, 36.31821], [-119.20857, 36.31818], [-119.20859, 36.31659], [-119.20864, 36.31665], [-119.20877, 36.31669], [-119.20887, 36.31664], [-119.21059, 36.31665], [-119.21139, 36.31671], [-119.21209, 36.31679], [-119.21304, 36.31701]]]} | Open Access 1 | 1141 | Liberty Park | 21210 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 16.086 | Liberty Park | 0 | Local Park 2 | 4 | ||
384 | 384 | 383 | {"type": "Polygon", "coordinates": [[[-119.20715, 36.29112], [-119.20714, 36.29174], [-119.20533, 36.29176], [-119.20533, 36.29057], [-119.20679, 36.29058], [-119.20679, 36.29112], [-119.20715, 36.29112]]]} | Open Access 1 | 1151 | Roy Park | 24712 | 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.789 | Roy Park | 0 | Local Park 2 | 4 | ||
516 | 516 | 515 | {"type": "Polygon", "coordinates": [[[-120.62395, 36.98985], [-120.62208, 36.98986], [-120.62208, 36.98902], [-120.62395, 36.98902], [-120.62395, 36.98985]]]} | Open Access 1 | 25989 | Pierini Park | 23664 | 1460 | Dos Palos, City of 194 | City 2 | City Agency 2 | City 2 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | Merced 37 | 3.824 | Pierini Park | 0 | Local Park 2 | 4 | ||
527 | 527 | 526 | {"type": "Polygon", "coordinates": [[[-120.63533, 36.98758], [-120.63434, 36.98758], [-120.63433, 36.98728], [-120.63533, 36.98728], [-120.63533, 36.98758]]]} | Open Access 1 | 25990 | Des Park | 18106 | 1460 | Dos Palos, City of 194 | City 2 | City Agency 2 | City 2 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | Merced 37 | 0.735 | Des Park | 0 | Local Park 2 | 4 | ||
2104 | 2104 | 2103 | {"type": "Polygon", "coordinates": [[[-120.57389, 34.97384], [-120.57321, 34.97483], [-120.57204, 34.97432], [-120.57273, 34.97333], [-120.57389, 34.97384]]]} | Open Access 1 | 17330 | Leroy Park | 21178 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 3.784 | Leroy Park | 0 | Local Park 2 | 4 | ||
2317 | 2317 | 2316 | {"type": "Polygon", "coordinates": [[[-120.59124, 34.95777], [-120.59116, 34.96061], [-120.58835, 34.96058], [-120.58837, 34.96035], [-120.58852, 34.95999], [-120.58868, 34.9598], [-120.58886, 34.95964], [-120.5892, 34.95938], [-120.58939, 34.95916], [-120.58958, 34.95879], [-120.58962, 34.9586], [-120.58965, 34.95785], [-120.58967, 34.9578], [-120.58974, 34.95777], [-120.59124, 34.95777]]]} | Open Access 1 | 16995 | Jack O'Conell Park | 20306 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 14.461 | Jack O'Conell Park | 0 | Local Park 2 | 4 | ||
2506 | 2506 | 2505 | {"type": "Polygon", "coordinates": [[[-117.3015, 33.61798], [-117.3012, 33.61831], [-117.29877, 33.61679], [-117.29902, 33.61646], [-117.3015, 33.61798]]]} | Open Access 1 | 48910 | Regency-Heritage Park | 33631 | 2437 | Ortega Trail Recreation and Park District 529 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1706 | Wildomar, City of 522 | City 2 | City Agency 2 | http://www.cityofwildomar.org/community/parks_trails/parks/regency-heritage_park | Riverside 10 | 3.114 | Regency-Heritage Park | 0 | Local Park 2 | 4 | |
3110 | 3110 | 3109 | {"type": "Polygon", "coordinates": [[[-118.368, 34.09588], [-118.36753, 34.09588], [-118.36753, 34.09577], [-118.36799, 34.09577], [-118.368, 34.09588]]]} | Open Access 1 | 47991 | Havenhurst Park | 32412 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/19/773 | Los Angeles 6 | 0.129 | Havenhurst Park | 0 | Local Park 2 | 4 | |
4061 | 4061 | 4060 | {"type": "Polygon", "coordinates": [[[-121.47735, 41.95551], [-121.47721, 41.95551], [-121.4772, 41.95545], [-121.4769, 41.95545], [-121.4769, 41.95537], [-121.47735, 41.95536], [-121.47735, 41.95551]]]} | Open Access 1 | 45609 | Mike Bunch Park | 28435 | 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.11 | Mike Bunch Park | 0 | Local Park 2 | 4 | ||
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 | ||
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 | |
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 | ||
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 | ||
8372 | 8372 | 8371 | {"type": "Polygon", "coordinates": [[[-121.13806, 36.21648], [-121.13809, 36.21658], [-121.13804, 36.21705], [-121.138, 36.21722], [-121.13792, 36.21739], [-121.13781, 36.21754], [-121.13767, 36.21767], [-121.13751, 36.21779], [-121.13718, 36.21797], [-121.13712, 36.21799], [-121.13705, 36.21799], [-121.13694, 36.21794], [-121.13639, 36.21725], [-121.13787, 36.21647], [-121.13806, 36.21648]]]} | Open Access 1 | 48506 | CreekBridge Baseball Park | 33217 | 7033 | Creekbridge Homes LLC 892 | Private 7 | Home Owners Association 16 | Private 14 | 1152 | King City, City of 473 | City 2 | City Agency 2 | Monterey 14 | 3.565 | CreekBridge Baseball 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]);