units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where ACCESS_TYP = 2, DES_TP = 2 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, COUNTY, YR_EST
MNG_AGENCY >30
- Whittier, City of 20
- San Ramon, City of 13
- Los Angeles, City of 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
- Pasadena, City of 4
- Lawndale, City of 4
- Modesto, City of 4
- Glendora, City of 3
- Carlsbad, City of 3
- Palmdale, City of 3
- Mountain View, City of 3
- Garden Grove, City of 2
- Oceanside, City of 2
- Lake Elsinore, City of 2
- Cerritos, City of 2
- Bell Gardens, City of 2
- Long Beach, City of 2
- Sierra Madre, City of 2
- Sacramento, City of 2
- South El Monte, City of 2
- San Gabriel, City of 2
- Watsonville, City of 1
- Fresno, City of 1
- Santa Ana, City of 1
- …
MNG_AG_TYP 1
- City Agency · 151 ✖
DES_TP 1
- Local Park · 151 ✖
ACCESS_TYP 1
- Restricted Access · 151 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7199 | 7199 | 7198 | {"type": "Polygon", "coordinates": [[[-120.97533, 37.62623], [-120.97481, 37.62623], [-120.97482, 37.62608], [-120.97533, 37.62607], [-120.97533, 37.62623]]]} | Restricted Access 2 | 34894 | Legion Park | 21143 | 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 | 0.197 | Legion Park | 0 | Local Park 2 | 4 | |
11571 | 11571 | 11570 | {"type": "Polygon", "coordinates": [[[-118.08661, 34.0972], [-118.0861, 34.09721], [-118.0861, 34.09691], [-118.08661, 34.09691], [-118.08661, 34.0972]]]} | Restricted Access 2 | 24526 | Roosevelt Park | 31646 | 2393 | San Gabriel Unified School District 706 | Special District 4 | School District 14 | http://www.sgusd.k12.ca.us/ | Special District 4 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | Los Angeles 6 | 0.381 | Roosevelt Park | 0 | Local Park 2 | 4 | |
7274 | 7274 | 7273 | {"type": "Polygon", "coordinates": [[[-118.03194, 33.98457], [-118.03194, 33.98501], [-118.03164, 33.98513], [-118.03164, 33.98457], [-118.03194, 33.98457]]]} | Restricted Access 2 | 6517 | Bailey Ranch House and Park | 29859 | 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.383 | Bailey Ranch House and Park | 0 | Local Park 2 | 4 | |
15395 | 15395 | 15394 | {"type": "Polygon", "coordinates": [[[-118.39514, 33.8615], [-118.39468, 33.86158], [-118.39458, 33.86123], [-118.39504, 33.86114], [-118.39514, 33.8615]]]} | Restricted Access 2 | 46635 | Lawn Bowling Green | 29962 | 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 | http://www.hermosabch.org/index.aspx?page=262 | Los Angeles 6 | 0.443 | Lawn Bowling Green | 1958 | Local Park 2 | 4 |
4212 | 4212 | 4211 | {"type": "Polygon", "coordinates": [[[-118.35177, 33.8854], [-118.35106, 33.8854], [-118.35104, 33.88537], [-118.35099, 33.88502], [-118.35116, 33.88502], [-118.35131, 33.88511], [-118.35148, 33.88516], [-118.35162, 33.88518], [-118.35177, 33.88517], [-118.35177, 33.8854]]]} | Restricted Access 2 | 44962 | Dan McKenzie Community Gardens | 29797 | 1172 | Lawndale, City of 484 | City 2 | City Agency 2 | http://www.lawndalecity.org/ | City 2 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/html/depthtml/csd/McKenzieGarden.html | Los Angeles 6 | 0.544 | Dan McKenzie Community Gardens | 0 | Local Park 2 | 4 |
11515 | 11515 | 11514 | {"type": "Polygon", "coordinates": [[[-118.17797, 33.79308], [-118.17745, 33.79307], [-118.17745, 33.79266], [-118.17796, 33.79266], [-118.17797, 33.79275], [-118.17797, 33.79308]]]} | Restricted Access 2 | 48221 | Martin Luther King Jr. Park | 32772 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.547 | Martin Luther King Jr. Park | 0 | Local Park 2 | 4 | |
5696 | 5696 | 5695 | {"type": "Polygon", "coordinates": [[[-118.29818, 34.06162], [-118.29723, 34.06162], [-118.29617, 34.06163], [-118.29617, 34.06159], [-118.29669, 34.06159], [-118.2967, 34.06149], [-118.29818, 34.06147], [-118.29818, 34.06162]]]} | Restricted Access 2 | 45735 | Robert F Kennedy Inspiration Park | 31643 | 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 | http://www.laparks.org/commissionerhtm/pdf2010/oct06/10-266.pdf | Los Angeles 6 | 0.574 | Robert F Kennedy Inspiration 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 | |
15126 | 15126 | 15125 | {"type": "Polygon", "coordinates": [[[-118.14136, 34.15891], [-118.14137, 34.15954], [-118.14136, 34.15957], [-118.14132, 34.15958], [-118.14069, 34.15958], [-118.14069, 34.15892], [-118.14136, 34.15891]]]} | Restricted Access 2 | 45946 | James Madison Park | 29094 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://pasadenacsp.org/pcsp/site/joint_use/ | Los Angeles 6 | 1.131 | James Madison Park | 0 | Local Park 2 | 4 |
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 | |
4407 | 4407 | 4406 | {"type": "Polygon", "coordinates": [[[-118.14787, 33.95964], [-118.14683, 33.9602], [-118.14653, 33.95978], [-118.14761, 33.9592], [-118.14787, 33.95964]]]} | Restricted Access 2 | 46199 | Community Garden | 32757 | 1023 | Bell Gardens, City of 226 | City 2 | City Agency 2 | http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx | City 2 | 1023 | Bell Gardens, City of 222 | City 2 | City Agency 2 | Los Angeles 6 | 1.546 | Community Garden | 0 | Local Park 2 | 4 | |
824 | 824 | 823 | {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.18411], [-118.29645, 34.18412], [-118.29561, 34.18351], [-118.2956, 34.18348], [-118.296, 34.18308], [-118.29685, 34.1837], [-118.29688, 34.18375]]]} | Restricted Access 2 | 5370 | Miller Park | 29568 | 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/miller-park | Los Angeles 6 | 1.599 | Miller Park | 0 | Local Park 2 | 4 |
4264 | 4264 | 4263 | {"type": "Polygon", "coordinates": [[[-118.10522, 34.07637], [-118.10463, 34.07637], [-118.10463, 34.07569], [-118.1044, 34.07568], [-118.10441, 34.07532], [-118.10455, 34.0753], [-118.10521, 34.07529], [-118.10522, 34.07637]]]} | Restricted Access 2 | 45322 | Marshall Community Park | 32836 | 1301 | San Gabriel, City of 740 | City 2 | City Agency 2 | http://www.sangabrielcity.com/ | City 2 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | http://www.sangabrielcity.com/539/Marshall-Park | Los Angeles 6 | 1.81 | Marshall Community Park | 0 | Local Park 2 | 4 |
14235 | 14235 | 14234 | {"type": "Polygon", "coordinates": [[[-117.95912, 33.85653], [-117.95701, 33.85656], [-117.957, 33.85652], [-117.95681, 33.85652], [-117.95681, 33.85643], [-117.95683, 33.85632], [-117.95687, 33.85621], [-117.95692, 33.85617], [-117.95779, 33.85624], [-117.95908, 33.85624], [-117.95911, 33.85624], [-117.95912, 33.85626], [-117.95912, 33.85653]]]} | Restricted Access 2 | 44113 | Orangethorpe School Park | 31634 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 1.856 | Orangethorpe School Park | 0 | Local Park 2 | 4 | |
10693 | 10693 | 10692 | {"type": "Polygon", "coordinates": [[[-117.04937, 33.13247], [-117.04883, 33.13273], [-117.0484, 33.13207], [-117.04842, 33.13205], [-117.04818, 33.13167], [-117.04871, 33.13143], [-117.04937, 33.13247]]]} | Restricted Access 2 | 19848 | Oak Hill City Park | 31522 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 1.876 | Oak Hill City Park | 0 | Local Park 2 | 4 | |
14247 | 14247 | 14246 | {"type": "Polygon", "coordinates": [[[-117.96771, 34.13677], [-117.96771, 34.13691], [-117.96675, 34.13692], [-117.96675, 34.13615], [-117.96679, 34.13612], [-117.96768, 34.13611], [-117.96768, 34.13636], [-117.96771, 34.13663], [-117.96771, 34.13677]]]} | Restricted Access 2 | 44144 | Northview Park | 31584 | 2316 | Duarte Unified School District 978 | Special District 4 | School District 14 | http://www.duarte.k12.ca.us/ | Special District 4 | 1089 | Duarte, City of 325 | City 2 | City Agency 2 | Los Angeles 6 | 1.908 | Northview Park | 0 | Local Park 2 | 4 | |
3978 | 3978 | 3977 | {"type": "Polygon", "coordinates": [[[-118.05658, 34.16669], [-118.05578, 34.16669], [-118.05577, 34.16573], [-118.05657, 34.16571], [-118.05658, 34.16669]]]} | Restricted Access 2 | 46602 | Sierra Madre Elementary School Park | 31924 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 1.948 | Sierra Madre Elementary School Park | 0 | Local Park 2 | 4 | |
15127 | 15127 | 15126 | {"type": "Polygon", "coordinates": [[[-118.17896, 34.16949], [-118.17802, 34.16949], [-118.17798, 34.1694], [-118.17765, 34.1694], [-118.17765, 34.16937], [-118.17745, 34.16924], [-118.17743, 34.16921], [-118.17744, 34.16919], [-118.17742, 34.16917], [-118.17731, 34.1689], [-118.17725, 34.16889], [-118.17724, 34.16868], [-118.17682, 34.16868], [-118.17682, 34.1686], [-118.1774, 34.1686], [-118.17741, 34.16854], [-118.17892, 34.16941], [-118.17896, 34.16949]]]} | Restricted Access 2 | 45947 | Linda Vista Park | 29095 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.lvaa.net/linda-vista-park.html | Los Angeles 6 | 2.012 | Linda Vista Park | 0 | Local Park 2 | 4 |
15354 | 15354 | 15353 | {"type": "Polygon", "coordinates": [[[-118.41174, 33.895], [-118.41119, 33.89534], [-118.41102, 33.89519], [-118.41023, 33.89479], [-118.41014, 33.89462], [-118.41067, 33.89448], [-118.41069, 33.89451], [-118.41147, 33.8943], [-118.41174, 33.895]]]} | Restricted Access 2 | 46541 | Grand View Elementary School Park | 31904 | 2380 | Manhattan Beach Unified School District 971 | Special District 4 | School District 14 | http://www.mbusd.org/ | Special District 4 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | Los Angeles 6 | 2.292 | Grand View Elementary School Park | 0 | Local Park 2 | 4 | |
5724 | 5724 | 5723 | {"type": "Polygon", "coordinates": [[[-118.02929, 33.94516], [-118.02862, 33.94584], [-118.02768, 33.94519], [-118.02852, 33.94479], [-118.02853, 33.94477], [-118.02849, 33.94475], [-118.02862, 33.94468], [-118.02929, 33.94516]]]} | Restricted Access 2 | 46579 | Mulberry Elementary School Park | 31917 | 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 | 2.31 | Mulberry 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]);