units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
260 rows where ACCESS_TYP = 2 and AGNCY_LEV = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_LEV, PARK_URL, COUNTY, ACRES, YR_EST, GAP_STS
MNG_AGENCY 143
- Los Angeles, City of 17
- Long Beach, City of 9
- San Diego, City of 8
- Santa Cruz, City of 7
- Modesto, City of 7
- San Jose, City of 6
- Fullerton, City of 5
- Vacaville, City of 5
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- Watsonville, City of 3
- Carlsbad, City of 3
- Pomona, City of 3
- Cerritos, City of 3
- El Segundo, City of 3
- Pasadena, City of 3
- South Pasadena, City of 3
- American Canyon, City of 3
- Sacramento, City of 3
- Oakdale, City of 2
- Fresno, City of 2
- San Francisco, City and County of 2
- California Department of Fish and Wildlife 2
- Santa Barbara, City of 2
- Garden Grove, City of 2
- Glendora, City of 2
- Oceanside, City of 2
- Glendale, City of 2
- Coronado, City of 2
- Ventura, City of 2
- Seaside, City of 2
- Burbank, City of 2
- Dublin, City of 2
- San Bernardino, City of 2
- Davis, City of 2
- Riverside, City of 2
- Bell Gardens, City of 2
- El Monte, City of 2
- Whittier, City of 2
- Torrance, City of 2
- Gardena, City of 2
- Gilroy, City of 2
- Sunnyvale, City of 2
- Corte Madera, Town of 2
- Napa, City of 2
- California City, City of 2
- South El Monte, City of 2
- San Gabriel, City of 2
- Private Landowner 2
- Big League Dreams 2
- Elk Grove, City of 2
- South Lake Tahoe, City of 2
- American Golf 2
- Lancaster, City of 1
- Moreno Valley, City of 1
- Los Angeles, County of 1
- Richmond, City of 1
- San Luis Obispo, City of 1
- Mountains Recreation and Conservation Authority 1
- Santa Rosa, City of 1
- Pleasanton, City of 1
- Santa Maria, City of 1
- Encinitas, City of 1
- National City, City of 1
- Salinas, City of 1
- Carpinteria, City of 1
- El Cajon, City of 1
- Downey, City of 1
- Escondido, City of 1
- San Mateo, City of 1
- San Diego, County of 1
- Costa Mesa, City of 1
- Chula Vista, City of 1
- Ontario, City of 1
- Poway, City of 1
- Monterey Park, City of 1
- Buena Park, City of 1
- Porterville, City of 1
- Visalia, City of 1
- Alhambra, City of 1
- Palo Alto, City of 1
- Pacific Grove, City of 1
- Walnut Creek, City of 1
- San Leandro, City of 1
- Cupertino, City of 1
- Belmont, City of 1
- Fairfield, City of 1
- Palm Desert, City of 1
- Indio, City of 1
- Mill Valley, City of 1
- Brea, City of 1
- Lake Forest, City of 1
- Lafayette, City of 1
- San Dimas, City of 1
- Redondo Beach, City of 1
- Bakersfield, City of 1
- Montebello, City of 1
- Livermore, City of 1
- Lynwood, City of 1
- Compton, City of 1
- Needles, City of 1
- Los Angeles - Department of Water and Power, City of 1
- Palos Verdes Estates, City of 1
- Hermosa Beach, City of 1
- Arcadia, City of 1
- Monrovia, City of 1
- Rohnert Park, City of 1
- Walnut, City of 1
- La Mirada, City of 1
- Murrieta, City of 1
- Blythe, City of 1
- Antioch, City of 1
- San Rafael, City of 1
- Martinez, City of 1
- Healdsburg, City of 1
- Lemoore, City of 1
- Fremont, City of 1
- Concord, City of 1
- Milpitas, City of 1
- Thousand Oaks, City of 1
- Delano, City of 1
- Santa Clara Valley Open Space Authority 1
- King City, City of 1
- Lawndale, City of 1
- Tiburon, Town of 1
- Manteca, City of 1
- Manhattan Beach, City of 1
- Vallejo, City of 1
- Ripon, City of 1
- Marysville, City of 1
- West Sacramento, City of 1
- Rocklin, City of 1
- Lincoln, City of 1
- Galt, City of 1
- National Audubon Society 1
- Eureka, City of 1
- Los Angeles - Community Redevelopment Agency, City of 1
- Bay Club 1
- La Verne Heritage Foundation 1
- Silver Dollar BMX 1
- Los Angeles Golf Club 1
- JC Resorts 1
DES_TP 44
- Local Recreation Area 140
- Local Park 60
- Local Conservation Area 12
- Local Other or Unknown 6
- State Conservation Area 2
- Local Historic or Cultural Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 9
ACCESS_TYP 1
- Restricted Access · 260 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11460 | 11460 | 11459 | {"type": "Polygon", "coordinates": [[[-118.30636, 33.88501], [-118.306, 33.88501], [-118.306, 33.88495], [-118.30635, 33.88494], [-118.30636, 33.88501]]]} | Restricted Access 2 | 48160 | Rush Memorial Gymnasium | 32699 | 1117 | Gardena, City of 297 | City 2 | City Agency 2 | http://www.ci.gardena.ca.us/ | City 2 | 1117 | Gardena, City of 293 | City 2 | City Agency 2 | https://www.facebook.com/pages/Rush-Memorial-Gymnasium/1811050155861741 | Los Angeles 6 | 0.058 | Rush Memorial Gymnasium | 0 | Local Recreation Area 3 | 4 |
280 | 280 | 279 | {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} | Restricted Access 2 | 956 | South Monterey Dunes | 25664 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.07 | South Monterey Dunes | None 30 | |||
17051 | 17051 | 17050 | {"type": "Polygon", "coordinates": [[[-117.74578, 34.02877], [-117.74542, 34.02878], [-117.74539, 34.02875], [-117.74539, 34.02862], [-117.74577, 34.02861], [-117.74578, 34.02877]]]} | Restricted Access 2 | 46518 | Renacimiento Community Center | 29805 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/81-renacimiento-community-center | Los Angeles 6 | 0.157 | Renacimiento Community Ctr. | 0 | Local Recreation Area 3 | 4 |
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 | |
5708 | 5708 | 5707 | {"type": "Polygon", "coordinates": [[[-118.4631, 34.04049], [-118.4631, 34.04049], [-118.46238, 34.04081], [-118.46291, 34.04033], [-118.4631, 34.04049]]]} | Restricted Access 2 | 45779 | Bundy Triangle | 28785 | 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.22 | Bundy Triangle | 0 | Local Other or Unknown 14 | 4 | |
7127 | 7127 | 7126 | {"type": "Polygon", "coordinates": [[[-118.24292, 33.94311], [-118.24258, 33.94313], [-118.24261, 33.94276], [-118.24292, 33.94277], [-118.24292, 33.94311]]]} | Restricted Access 2 | 6216 | Watts Historic Train Station | 29326 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Watts Historic Train Station | 0 | Local Historic or Cultural Area 19 | 4 | |
15339 | 15339 | 15338 | {"type": "Polygon", "coordinates": [[[-118.04682, 34.05004], [-118.04634, 34.05004], [-118.04634, 34.0499], [-118.04661, 34.0499], [-118.0466, 34.04959], [-118.04682, 34.04959], [-118.04682, 34.05004]]]} | Restricted Access 2 | 46549 | Mini Center | 29846 | 1402 | South El Monte, City of 606 | City 2 | City Agency 2 | http://www.ci.south-el-monte.ca.us/CITYDEPARTMENTSSERVICES/CommunityServices/ParksandRecreationDivision.aspx | City 2 | 1402 | South El Monte, City of 595 | City 2 | City Agency 2 | Los Angeles 6 | 0.336 | Mini Ctr. | 0 | Local Recreation Area 3 | 4 | |
15294 | 15294 | 15293 | {"type": "Polygon", "coordinates": [[[-118.23026, 34.16966], [-118.23015, 34.16981], [-118.2301, 34.16985], [-118.23004, 34.16995], [-118.22998, 34.16996], [-118.2299, 34.16992], [-118.22991, 34.16982], [-118.22989, 34.16978], [-118.22982, 34.16973], [-118.22962, 34.1697], [-118.22975, 34.16956], [-118.2298, 34.16948], [-118.23026, 34.16966]]]} | Restricted Access 2 | 46426 | Verdugo Skate Park | 29697 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/verdugo-skate-park | Los Angeles 6 | 0.355 | Verdugo Skate Park | 2004 | Local Recreation Area 3 | 4 |
7105 | 7105 | 7104 | {"type": "Polygon", "coordinates": [[[-118.40261, 33.92509], [-118.40215, 33.92509], [-118.40215, 33.92477], [-118.40261, 33.92477], [-118.40261, 33.92509]]]} | Restricted Access 2 | 6158 | Camp Eucalyptus | 29706 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.378 | Camp Eucalyptus | None 581 | |||
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 |
4394 | 4394 | 4393 | {"type": "Polygon", "coordinates": [[[-118.23041, 34.19871], [-118.23092, 34.19917], [-118.23092, 34.19922], [-118.23089, 34.19923], [-118.23031, 34.19921], [-118.23026, 34.19919], [-118.23025, 34.19914], [-118.23034, 34.19874], [-118.23037, 34.19871], [-118.23041, 34.19871]]]} | Restricted Access 2 | 46024 | Sparr Heights Community Center | 29349 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/sparr-heights-community-center | Los Angeles 6 | 0.504 | Sparr Heights Community Ctr. | 0 | Local Recreation Area 3 | 4 |
17049 | 17049 | 17048 | {"type": "Polygon", "coordinates": [[[-118.10867, 34.09787], [-118.1084, 34.09799], [-118.10834, 34.09808], [-118.10827, 34.09805], [-118.10823, 34.0981], [-118.10818, 34.09809], [-118.10813, 34.09816], [-118.10801, 34.09811], [-118.1084, 34.09743], [-118.10867, 34.09787]]]} | Restricted Access 2 | 46476 | Grapevine Arbor Park and Adult Recreation Center | 29751 | 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 | Los Angeles 6 | 0.517 | Grapevine Arbor Park and Adult Rec. Ctr. | 0 | Local Recreation Area 3 | 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 |
13897 | 13897 | 13896 | {"type": "Polygon", "coordinates": [[[-118.03556, 34.06661], [-118.0355, 34.06666], [-118.03549, 34.0667], [-118.03547, 34.0667], [-118.03547, 34.06675], [-118.03544, 34.06676], [-118.03544, 34.06686], [-118.03528, 34.06686], [-118.03527, 34.06691], [-118.03478, 34.06691], [-118.03478, 34.06651], [-118.03525, 34.06652], [-118.03527, 34.06653], [-118.03556, 34.06654], [-118.03556, 34.06661]]]} | Restricted Access 2 | 46374 | El Monte Aquatic Center | 29652 | 1095 | El Monte, City of 240 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | Los Angeles 6 | 0.667 | El Monte Aquatic Ctr. | 0 | Local Recreation Area 3 | 4 | |
9130 | 9130 | 9129 | {"type": "Polygon", "coordinates": [[[-118.1982, 34.0513], [-118.19807, 34.0515], [-118.19808, 34.05158], [-118.19791, 34.05157], [-118.19774, 34.05153], [-118.19725, 34.05132], [-118.19747, 34.05098], [-118.1982, 34.0513]]]} | Restricted Access 2 | 15135 | Wabash Recreation Center | 28866 | 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.784 | Wabash Rec. Ctr. | 0 | Local Recreation Area 3 | 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 | |
16985 | 16985 | 16984 | {"type": "Polygon", "coordinates": [[[-118.00244, 34.14964], [-118.00161, 34.14965], [-118.0016, 34.14922], [-118.00243, 34.14921], [-118.00244, 34.14964]]]} | Restricted Access 2 | 47856 | Monrovia Community Center | 31802 | 1209 | Monrovia, City of 312 | City 2 | City Agency 2 | http://www.cityofmonrovia.org/publicworks/page/parks | City 2 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | https://www.cityofmonrovia.org/Home/Components/FacilityDirectory/FacilityDirectory/2/548 | Los Angeles 6 | 0.898 | Monrovia Community Ctr. | 0 | Local Recreation Area 3 | 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]);