units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where ACCESS_TYP = 2 and DES_TP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, YR_EST
MNG_AGENCY >30
- Los Angeles, City of 10
- Los Angeles, County of 9
- Santa Cruz, City of 7
- Los Angeles - Department of Parks and Recreation, County of 7
- San Diego, City of 5
- San Jose, City of 5
- Long Beach, City of 5
- Santa Ana, City of 4
- San Bernardino, City of 4
- San Luis Obispo, City of 3
- Carlsbad, City of 3
- Pomona, City of 3
- Needles, City of 3
- Torrance, City of 3
- El Segundo, City of 3
- Stockton, City of 3
- Modesto, City of 3
- Roseville, City of 3
- Sacramento, County of 3
- San Gabriel, City of 3
- San Luis Obispo, County of 2
- San Francisco, City and County of 2
- Santa Barbara, City of 2
- Rancho Simi Recreation and Park District 2
- Glendale, City of 2
- Coronado, City of 2
- Ventura, City of 2
- Burbank, City of 2
- Orange, County of 2
- Riverside, City of 2
- …
MNG_AG_TYP 11
DES_TP 1
- Local Recreation Area · 220 ✖
ACCESS_TYP 1
- Restricted Access · 220 ✖
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 |
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 |
15330 | 15330 | 15329 | {"type": "Polygon", "coordinates": [[[-118.2036, 34.20436], [-118.2036, 34.20462], [-118.20323, 34.20462], [-118.20323, 34.20436], [-118.2036, 34.20436]]]} | Restricted Access 2 | 46505 | Skate Park | 31585 | 2395 | La Canada Unified School District 1154 | Special District 4 | School District 14 | http://lcusd.net/site/default.aspx?PageID=1 | Special District 4 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks/skate | Los Angeles 6 | 0.246 | Skate Park | 0 | Local Recreation Area 3 | 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 |
13941 | 13941 | 13940 | {"type": "Polygon", "coordinates": [[[-118.08587, 34.09653], [-118.08587, 34.09696], [-118.08546, 34.09696], [-118.08547, 34.09653], [-118.08587, 34.09653]]]} | Restricted Access 2 | 46473 | Roosevelt Elementary Tennis Courts | 29746 | 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.443 | Roosevelt Elementary Tennis Courts | 0 | Local Recreation Area 3 | 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 | |
4411 | 4411 | 4410 | {"type": "Polygon", "coordinates": [[[-118.35352, 34.18058], [-118.3535, 34.18106], [-118.35346, 34.18107], [-118.35306, 34.18107], [-118.35307, 34.18057], [-118.35352, 34.18058]]]} | Restricted Access 2 | 46266 | Maple Street Playground | 31626 | 2391 | Burbank Unified School District 759 | Special District 4 | School District 14 | http://www.burbankusd.org/ | Special District 4 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground | Los Angeles 6 | 0.55 | Maple Street Playground | 0 | Local Recreation Area 3 | 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 | |
15164 | 15164 | 15163 | {"type": "Polygon", "coordinates": [[[-118.19697, 33.98506], [-118.19692, 33.98539], [-118.196, 33.9853], [-118.19606, 33.98497], [-118.19697, 33.98506]]]} | Restricted Access 2 | 46015 | Freedom Park Athletic Field | 29338 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1142 | Huntington Park, City of 83 | City 2 | City Agency 2 | Los Angeles 6 | 0.778 | Freedom Park Athletic Field | 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 | |
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 |
3250 | 3250 | 3249 | {"type": "Polygon", "coordinates": [[[-118.04684, 34.0465], [-118.04683, 34.0474], [-118.04642, 34.04739], [-118.04643, 34.0465], [-118.04684, 34.0465]]]} | Restricted Access 2 | 48154 | South El Monte Senior Center | 32691 | 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 | http://www.ci.south-el-monte.ca.us/CITYDEPARTMENTSSERVICES/CommunityServices/SeniorServices.aspx | Los Angeles 6 | 0.924 | South El Monte Senior Ctr. | 0 | Local Recreation Area 3 | 4 |
7453 | 7453 | 7452 | {"type": "Polygon", "coordinates": [[[-121.96985, 37.35893], [-121.96981, 37.35894], [-121.96977, 37.359], [-121.96974, 37.359], [-121.96972, 37.35903], [-121.96973, 37.35906], [-121.96901, 37.3589], [-121.96895, 37.35886], [-121.96892, 37.3588], [-121.96887, 37.35846], [-121.96961, 37.35847], [-121.96975, 37.3589], [-121.96985, 37.35888], [-121.96985, 37.35893]]]} | Restricted Access 2 | 48942 | Santa Clara Skate Park | 33658 | 2440 | Santa Clara Unified School District 865 | Special District 4 | School District 14 | https://www.santaclarausd.org/ | Special District 4 | 2440 | Santa Clara Unified School District 843 | Special District 4 | School District 21 | https://www.santaclaraca.gov/our-city/departments-g-z/parks-recreation/community-centers/skate-park | Santa Clara 19 | 0.964 | Santa Clara Skate Park | 0 | Local Recreation Area 3 | 4 |
16245 | 16245 | 16244 | {"type": "Polygon", "coordinates": [[[-118.32437, 33.83122], [-118.32371, 33.83123], [-118.32371, 33.83073], [-118.32329, 33.83036], [-118.32348, 33.83021], [-118.32436, 33.83102], [-118.32437, 33.83122]]]} | Restricted Access 2 | 35907 | ATTIC Teen Center | 32631 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | https://www.torranceca.gov/our-city/recreation/attic | Los Angeles 6 | 1.086 | ATTIC Teen Ctr. | 0 | Local Recreation Area 3 | 4 |
15306 | 15306 | 15305 | {"type": "Polygon", "coordinates": [[[-118.10197, 34.08439], [-118.10118, 34.08439], [-118.10117, 34.08387], [-118.10143, 34.08387], [-118.10145, 34.08376], [-118.10172, 34.08376], [-118.1019, 34.08387], [-118.10197, 34.08398], [-118.10197, 34.08439]]]} | Restricted Access 2 | 46475 | McKinley Baseball Field | 29748 | 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 | 1.141 | McKinley Baseball Field | 0 | Local Recreation Area 3 | 4 | |
15695 | 15695 | 15694 | {"type": "Polygon", "coordinates": [[[-114.6039, 34.84393], [-114.60287, 34.84392], [-114.60287, 34.84339], [-114.6039, 34.84339], [-114.6039, 34.84393]]]} | Restricted Access 2 | 49074 | River's Edge Golf Course | 33774 | 2442 | Needles Unified School District 1161 | Special District 4 | School District 14 | https://www.needlesusd.org/ | Special District 4 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/services/rivers-edge-golf-course/ | San Bernardino 22 | 1.368 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
14842 | 14842 | 14841 | {"type": "Polygon", "coordinates": [[[-117.84195, 34.02681], [-117.84059, 34.02721], [-117.84053, 34.02714], [-117.84053, 34.02709], [-117.84065, 34.02697], [-117.841, 34.02667], [-117.84138, 34.02642], [-117.84171, 34.02625], [-117.84195, 34.02681]]]} | Restricted Access 2 | 48150 | Walnut Senior Center | 32683 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 1.479 | Walnut Senior Ctr. | 0 | Local Recreation Area 3 | 4 | |
5702 | 5702 | 5701 | {"type": "Polygon", "coordinates": [[[-118.21106, 34.03932], [-118.21067, 34.03991], [-118.21062, 34.03994], [-118.21057, 34.03993], [-118.20993, 34.03964], [-118.21034, 34.03899], [-118.21106, 34.03932]]]} | Restricted Access 2 | 45762 | Roosevelt High School Pool | 28767 | 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/dos/aquatic/facility/rooseveltPool.htm | Los Angeles 6 | 1.493 | Roosevelt High School Pool | 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]);