units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
210 rows where ACCESS_TYP = 2 and DES_TP = 2 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, YR_EST
MNG_AGENCY >30
- Whittier, City of 20
- Los Angeles Unified School District 15
- San Ramon, City of 13
- Los Angeles, City of 7
- East Bay Regional Park District 7
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Beverly Hills, City of 5
- San Diego, City of 4
- Fullerton, City of 4
- Vacaville, City of 4
- Hollister, City of 4
- Hayward Area Recreation and Park District 4
- Pasadena, City of 4
- Lawndale, City of 4
- Modesto, City of 4
- Azusa Unified School District 4
- Glendora, City of 3
- Carlsbad, City of 3
- Palmdale, City of 3
- Mountain View, City of 3
- Conejo Valley Unified School District 3
- Los Angeles, County of 2
- Garden Grove, City of 2
- Oceanside, City of 2
- Orange, County of 2
- Lake Elsinore, City of 2
- Cerritos, City of 2
- Bell Gardens, City of 2
- Long Beach, City of 2
- …
MNG_AG_TYP 7
DES_TP 1
- Local Park · 210 ✖
ACCESS_TYP 1
- Restricted Access · 210 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5465 | 5465 | 5464 | {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.33699, 33.91011], [-118.33698, 33.91027], [-118.3365, 33.91027], [-118.3365, 33.90959], [-118.33727, 33.90959], [-118.33727, 33.9101]]]} | Restricted Access 2 | 6273 | Zela Davis Elementary School Park | 31892 | 2044 | Hawthorne School District 808 | Special District 4 | School District 14 | http://www.hawthorne.k12.ca.us/ | Special District 4 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 1.201 | Zela Davis Elementary School Park | 0 | Local Park 2 | 4 | |
3049 | 3049 | 3048 | {"type": "Polygon", "coordinates": [[[-118.16091, 34.13982], [-118.15954, 34.13982], [-118.15942, 34.13859], [-118.16072, 34.13858], [-118.16072, 34.13907], [-118.16084, 34.13908], [-118.16091, 34.13982]]]} | Restricted Access 2 | 24522 | Wrigley Gardens | 32656 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 4.163 | Wrigley Gardens | 0 | Local Park 2 | 4 | |
2216 | 2216 | 2215 | {"type": "Polygon", "coordinates": [[[-121.90955, 37.75216], [-121.90924, 37.75257], [-121.90894, 37.75304], [-121.90858, 37.75288], [-121.90819, 37.75274], [-121.90782, 37.75266], [-121.90741, 37.75261], [-121.90741, 37.7522], [-121.90735, 37.75209], [-121.90718, 37.752], [-121.90702, 37.75197], [-121.90676, 37.75208], [-121.9058, 37.75097], [-121.9068, 37.75041], [-121.90754, 37.75103], [-121.90769, 37.7511], [-121.90786, 37.75114], [-121.90802, 37.75114], [-121.90823, 37.75111], [-121.90845, 37.75099], [-121.90955, 37.75216]]]} | Restricted Access 2 | 47570 | Windemere Ranch School Park | 31295 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 11.225 | Windemere Ranch School Park | 0 | Local Park 2 | 4 | |
3663 | 3663 | 3662 | {"type": "Polygon", "coordinates": [[[-118.35756, 33.87843], [-118.35626, 33.87843], [-118.35625, 33.87755], [-118.3565, 33.87755], [-118.35651, 33.87731], [-118.35663, 33.87731], [-118.35663, 33.87709], [-118.35756, 33.87709], [-118.35756, 33.87843]]]} | Restricted Access 2 | 44123 | William Green Park | 27544 | 2396 | Lawndale Elementary School District 670 | Special District 4 | School District 14 | http://www.lawndale.k12.ca.us/ | Special District 4 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ASSETS/PDF/Parks/williamgreenpark.pdf | Los Angeles 6 | 4.064 | William Green Park | 0 | Local Park 2 | 4 |
15369 | 15369 | 15368 | {"type": "Polygon", "coordinates": [[[-118.04661, 33.98098], [-118.0466, 33.98257], [-118.04655, 33.98262], [-118.0434, 33.98262], [-118.04335, 33.98259], [-118.04335, 33.98089], [-118.0454, 33.98089], [-118.04541, 33.98097], [-118.04661, 33.98098]]]} | Restricted Access 2 | 46565 | Whittier High School Park | 31910 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 14.027 | Whittier High School Park | 0 | Local Park 2 | 4 | |
4432 | 4432 | 4431 | {"type": "Polygon", "coordinates": [[[-118.04648, 33.97899], [-118.04609, 33.979], [-118.04611, 33.97832], [-118.04619, 33.97833], [-118.04619, 33.97795], [-118.04624, 33.97795], [-118.04625, 33.97792], [-118.04643, 33.97792], [-118.04646, 33.97897], [-118.04648, 33.97899]]]} | Restricted Access 2 | 46559 | Whittier Dog Park | 29862 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 0.849 | Whittier Dog Park | 0 | Local Park 2 | 4 | |
14196 | 14196 | 14195 | {"type": "Polygon", "coordinates": [[[-122.06953, 37.40119], [-122.06593, 37.40177], [-122.06494, 37.40163], [-122.06507, 37.40148], [-122.06547, 37.40118], [-122.06561, 37.401], [-122.0657, 37.40083], [-122.06605, 37.39986], [-122.06654, 37.39998], [-122.06639, 37.40042], [-122.06652, 37.40052], [-122.06689, 37.40049], [-122.06693, 37.40043], [-122.06762, 37.40032], [-122.06767, 37.40038], [-122.06797, 37.40032], [-122.06799, 37.40034], [-122.0684, 37.40029], [-122.06841, 37.40028], [-122.06838, 37.40019], [-122.06951, 37.40004], [-122.06955, 37.40046], [-122.06955, 37.40081], [-122.06953, 37.40119]]]} | Restricted Access 2 | 44037 | Whisman School Park | 27456 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 12.378 | Whisman School Park | 0 | Local Park 2 | 4 | |
9726 | 9726 | 9725 | {"type": "Polygon", "coordinates": [[[-118.06976, 33.98789], [-118.06914, 33.98854], [-118.0683, 33.98797], [-118.06847, 33.9878], [-118.06824, 33.98766], [-118.06837, 33.98758], [-118.06832, 33.98754], [-118.06857, 33.98727], [-118.0682, 33.987], [-118.06838, 33.98685], [-118.06963, 33.98778], [-118.06963, 33.98779], [-118.06976, 33.98789]]]} | Restricted Access 2 | 47867 | West Whittier Elementary School Park | 31947 | 2371 | Whittier City School District 923 | Special District 4 | School District 14 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 2371 | Whittier City School District 896 | Special District 4 | School District 21 | Los Angeles 6 | 3.134 | West Whittier Elementary School Park | 0 | Local Park 2 | 4 | |
12459 | 12459 | 12458 | {"type": "Polygon", "coordinates": [[[-122.93948, 38.35579], [-122.93861, 38.35592], [-122.93857, 38.35592], [-122.93856, 38.35587], [-122.93847, 38.35577], [-122.93853, 38.35573], [-122.93849, 38.35551], [-122.93858, 38.35544], [-122.93913, 38.35514], [-122.93922, 38.35551], [-122.93948, 38.35579]]]} | Restricted Access 2 | 28220 | Watson School/ Wayside Park | 31655 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 1.062 | Watson School/ Wayside Park | 0 | Local Park 2 | 4 | |
3963 | 3963 | 3962 | {"type": "Polygon", "coordinates": [[[-118.10299, 34.1077], [-118.1021, 34.1077], [-118.10206, 34.10769], [-118.10203, 34.1063], [-118.10278, 34.10629], [-118.10278, 34.10728], [-118.10298, 34.10729], [-118.10299, 34.1077]]]} | Restricted Access 2 | 46471 | Washington School Park | 32680 | 2393 | San Gabriel Unified School District 706 | Special District 4 | School District 14 | http://www.sgusd.k12.ca.us/ | Special District 4 | 2393 | San Gabriel Unified School District 693 | Special District 4 | School District 21 | Los Angeles 6 | 2.827 | Washington School Park | 0 | Local Park 2 | 4 | |
12180 | 12180 | 12179 | {"type": "Polygon", "coordinates": [[[-118.24192, 34.11743], [-118.24122, 34.11792], [-118.24083, 34.11751], [-118.24084, 34.11749], [-118.24152, 34.11701], [-118.24192, 34.11743]]]} | Restricted Access 2 | 46849 | Washington Irving Middle School Park | 31926 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | Los Angeles 6 | 1.236 | Washington Irving Middle School Park | 0 | Local Park 2 | 4 | |
14009 | 14009 | 14008 | {"type": "Polygon", "coordinates": [[[-116.3736, 33.7155], [-116.3736, 33.71665], [-116.37357, 33.71669], [-116.37171, 33.71671], [-116.37166, 33.71668], [-116.37165, 33.7155], [-116.3736, 33.7155]]]} | Restricted Access 2 | 39070 | Washington Charter School Park | 31654 | 1240 | Palm Desert, City of 215 | City 2 | City Agency 2 | http://www.cityofpalmdesert.org/Index.aspx?page=174 | City 2 | 1240 | Palm Desert, City of 211 | City 2 | City Agency 2 | Riverside 10 | 5.945 | Washington Charter School Park | 0 | Local Park 2 | 4 | |
14234 | 14234 | 14233 | {"type": "Polygon", "coordinates": [[[-121.9381, 37.74068], [-121.93767, 37.74085], [-121.93742, 37.74094], [-121.93721, 37.74099], [-121.93699, 37.74102], [-121.93652, 37.74105], [-121.93627, 37.74109], [-121.93549, 37.7397], [-121.93684, 37.73917], [-121.9381, 37.74068]]]} | Restricted Access 2 | 44112 | Walt Disney School Park | 27245 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 6.985 | Walt Disney School Park | 0 | Local Park 2 | 4 | |
4372 | 4372 | 4371 | {"type": "Polygon", "coordinates": [[[-118.22505, 33.96758], [-118.22454, 33.96753], [-118.22448, 33.9675], [-118.22431, 33.96734], [-118.22437, 33.96694], [-118.22436, 33.96693], [-118.22415, 33.96711], [-118.22327, 33.96702], [-118.22323, 33.96723], [-118.22254, 33.96715], [-118.22254, 33.96649], [-118.22474, 33.96672], [-118.22469, 33.96704], [-118.22505, 33.96708], [-118.22505, 33.96758]]]} | Restricted Access 2 | 45864 | Walnut Nature Park | 28911 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.587 | Walnut Nature Park | 0 | Local Park 2 | 4 | |
4031 | 4031 | 4030 | {"type": "Polygon", "coordinates": [[[-122.01457, 37.93282], [-122.01322, 37.93363], [-122.01205, 37.93236], [-122.01398, 37.93158], [-122.01414, 37.93182], [-122.01456, 37.93195], [-122.01454, 37.93209], [-122.01455, 37.93222], [-122.01415, 37.93237], [-122.01457, 37.93282]]]} | Restricted Access 2 | 44198 | Valle Verde Park | 26771 | 2317 | Mount Diablo Unified School District 712 | Special District 4 | School District 14 | http://www.mdusd.org/ | Special District 4 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 6.862 | Valle Verde Park | 0 | Local Park 2 | 4 | |
14214 | 14214 | 14213 | {"type": "Polygon", "coordinates": [[[-121.9876, 37.76853], [-121.98744, 37.76865], [-121.98732, 37.76882], [-121.98698, 37.76998], [-121.98688, 37.7701], [-121.98675, 37.77019], [-121.98566, 37.76912], [-121.98609, 37.7689], [-121.98606, 37.76878], [-121.98611, 37.76873], [-121.98623, 37.76869], [-121.98634, 37.7685], [-121.98633, 37.76837], [-121.98622, 37.76824], [-121.98677, 37.76779], [-121.98701, 37.76794], [-121.9876, 37.76853]]]} | Restricted Access 2 | 44087 | Twin Creeks School Park | 26613 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 5.487 | Twin Creeks School Park | 0 | Local Park 2 | 4 | |
16267 | 16267 | 16266 | {"type": "MultiPolygon", "coordinates": [[[[-120.96798, 37.62431], [-120.9679, 37.62465], [-120.96772, 37.62462], [-120.9678, 37.62428], [-120.96798, 37.62431]]], [[[-120.96854, 37.6244], [-120.96834, 37.62437], [-120.96827, 37.6247], [-120.96809, 37.62467], [-120.96817, 37.62428], [-120.96853, 37.62433], [-120.96854, 37.6244]]], [[[-120.97082, 37.62484], [-120.97024, 37.62472], [-120.97023, 37.62482], [-120.96997, 37.62477], [-120.9698, 37.62476], [-120.96964, 37.62479], [-120.96944, 37.62487], [-120.96906, 37.62491], [-120.96905, 37.62476], [-120.96863, 37.62475], [-120.96864, 37.62414], [-120.9675, 37.62391], [-120.96745, 37.62417], [-120.96763, 37.6242], [-120.96754, 37.6246], [-120.96736, 37.62457], [-120.96744, 37.62418], [-120.96708, 37.62412], [-120.96672, 37.62408], [-120.96663, 37.62447], [-120.96632, 37.62442], [-120.96629, 37.6244], [-120.96626, 37.62432], [-120.96624, 37.6242], [-120.96623, 37.62277], [-120.96846, 37.62263], [-120.96924, 37.62277], [-120.97081, 37.62292], [-120.97082, 37.62484]]]]} | Restricted Access 2 | 34896 | Tuolumne River Regional Park | 6748 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 19.414 | Tuolumne River RP | 0 | Local Park 2 | 4 | |
16368 | 16368 | 16367 | {"type": "MultiPolygon", "coordinates": [[[[-120.96864, 37.62414], [-120.96864, 37.62434], [-120.96817, 37.62428], [-120.96808, 37.62467], [-120.9679, 37.62465], [-120.96799, 37.62426], [-120.96782, 37.62423], [-120.96772, 37.62462], [-120.96754, 37.6246], [-120.96762, 37.62421], [-120.96745, 37.62418], [-120.96736, 37.62457], [-120.96663, 37.62447], [-120.96672, 37.62407], [-120.9669, 37.6241], [-120.96689, 37.62415], [-120.96706, 37.62418], [-120.96708, 37.62412], [-120.96744, 37.62417], [-120.96749, 37.62391], [-120.96864, 37.62414]]], [[[-120.96854, 37.62474], [-120.96827, 37.6247], [-120.96834, 37.62437], [-120.96854, 37.6244], [-120.96854, 37.62474]]], [[[-120.9746, 37.62611], [-120.97324, 37.62554], [-120.97195, 37.62512], [-120.97082, 37.62484], [-120.97081, 37.62292], [-120.97343, 37.62388], [-120.97378, 37.62412], [-120.97459, 37.62461], [-120.9746, 37.62611]]]]} | Restricted Access 2 | 34897 | Tuolumne River Regional Park | 6748 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 17.831 | Tuolumne River RP | 0 | Local Park 2 | 4 | |
11333 | 11333 | 11332 | {"type": "Polygon", "coordinates": [[[-120.23597, 37.96677], [-120.23585, 37.96674], [-120.23549, 37.9667], [-120.23553, 37.96647], [-120.2356, 37.96631], [-120.2357, 37.96629], [-120.23571, 37.96618], [-120.2358, 37.96617], [-120.23586, 37.9663], [-120.23597, 37.96677]]]} | Restricted Access 2 | 48057 | Tuolumne Community Garden | 32549 | 2169 | Tuolumne Park and Recreation District 741 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | https://www.tuolumnerecreation.com/TPRD_facilities.html | Tuolumne 21 | 0.432 | Tuolumne Community Garden | 1996 | Local Park 2 | 4 |
12181 | 12181 | 12180 | {"type": "Polygon", "coordinates": [[[-118.26901, 34.01254], [-118.26854, 34.01333], [-118.26797, 34.01311], [-118.26846, 34.01233], [-118.26901, 34.01254]]]} | Restricted Access 2 | 46855 | Trinity Street Elementary School Park | 31927 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | Los Angeles 6 | 1.374 | Trinity Street Elementary School 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]);