units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,921 rows where COUNTY = 6
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 484
- Mountains Recreation and Conservation Authority 334
- Los Angeles, County of 173
- Long Beach, City of 148
- Torrance, City of 73
- Los Angeles - Department of Parks and Recreation, County of 65
- Glendale, City of 60
- Santa Clarita, City of 51
- Whittier, City of 48
- Redondo Beach, City of 37
- Pasadena, City of 37
- Burbank, City of 34
- Santa Monica, City of 31
- Palmdale, City of 30
- Mountains Restoration Trust 30
- Pomona, City of 29
- Las Virgenes Municipal Water District 28
- United States National Park Service 27
- California Department of Parks and Recreation 26
- Azusa, City of 26
- La Verne, City of 26
- Rancho Palos Verdes, City of 25
- Claremont, City of 23
- Los Angeles County Flood Control District 23
- Arcadia, City of 23
- Cerritos, City of 22
- Hermosa Beach, City of 22
- South Pasadena, City of 22
- United States Army Corps of Engineers 21
- Beverly Hills, City of 21
- …
DES_TP >30
- Local Park 1,631
- Local Recreation Area 503
- Local Other or Unknown 221
- Local Conservation Area 86
- Private Recreation or Education 45
- Recreation Management Area 28
- Private Conservation 20
- National Recreation Area 20
- State Recreation Area 15
- Local Historic or Cultural Area 11
- State Park 10
- State Historic or Cultural Area 6
- State Conservation Area 5
- National Forest 4
- Resource Management Area 4
- Private Historic or Cultural 4
- State Other or Unknown 3
- National Public Lands 2
- Conservation Area 2
- State Resource Management Area 2
- Federal Other or Unknown 2
- None 1
- None 1
- None 1
- National Monument or Landmark 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 26
- City Agency 1,967
- Open Space District 334
- County Agency 173
- County Agency - Parks 65
- Federal Agency 61
- State Agency 55
- Non Profit - Conservation 35
- Water District 33
- School District 33
- Irrigation District 27
- Flood District 23
- Non Profit - Land Trust 22
- Recreation/Parks District 15
- Non Profit - Other 10
- County Agency - Other 7
- Cemetery District 6
- Port/Harbor District 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Commercial 4
- Sanitation District 4
- Home Owners Association 3
- Other 3
- Special District - Other 2
- Non Profit - Education 2
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 2,306
- Restricted Access 244
- No Public Access 202
- Unknown Access 149
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
319 | 319 | 318 | {"type": "Polygon", "coordinates": [[[-118.18189, 34.12005], [-118.18189, 34.12005], [-118.17889, 34.12008], [-118.1804, 34.11888], [-118.18088, 34.11808], [-118.18153, 34.11815], [-118.18189, 34.12005]]]} | Open Access 1 | 855 | Garvanza Park | 19226 | 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 | 8.274 | Garvanza Park | 0 | Local Park 2 | 4 | |
324 | 324 | 323 | {"type": "Polygon", "coordinates": [[[-118.09816, 34.06798], [-118.09728, 34.06798], [-118.09727, 34.06805], [-118.09506, 34.06807], [-118.09504, 34.06635], [-118.09805, 34.06632], [-118.09806, 34.06711], [-118.09726, 34.06711], [-118.09726, 34.06738], [-118.09815, 34.06738], [-118.09816, 34.06798]]]} | Open Access 1 | 863 | Garvey Park | 19227 | 1284 | Rosemead, City of 130 | City 2 | City Agency 2 | http://www.cityofrosemead.org/index.aspx?page=74 | City 2 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 12.61 | Garvey Park | 0 | Local Park 2 | 4 | |
327 | 327 | 326 | {"type": "Polygon", "coordinates": [[[-118.11643, 34.05357], [-118.11612, 34.05357], [-118.11571, 34.05344], [-118.11533, 34.05395], [-118.11472, 34.05395], [-118.11472, 34.05415], [-118.1132, 34.05415], [-118.11324, 34.05404], [-118.11325, 34.0539], [-118.11322, 34.05366], [-118.11315, 34.05352], [-118.11294, 34.05326], [-118.11289, 34.05308], [-118.11289, 34.05142], [-118.11424, 34.05142], [-118.11452, 34.0518], [-118.11562, 34.05217], [-118.11642, 34.0526], [-118.11643, 34.05357]]]} | Open Access 1 | 870 | Garvey Ranch Park | 19228 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 18.252 | Garvey Ranch Park | 0 | Local Park 2 | 4 | |
331 | 331 | 330 | {"type": "Polygon", "coordinates": [[[-118.36901, 34.03598], [-118.36855, 34.03714], [-118.36689, 34.03694], [-118.36745, 34.03546], [-118.36901, 34.03598]]]} | Open Access 1 | 908 | Genesee Avenue Park | 19255 | 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 | 5.852 | Genesee Avenue Park | 0 | Local Park 2 | 4 | |
341 | 341 | 340 | {"type": "Polygon", "coordinates": [[[-118.32171, 34.1722], [-118.32168, 34.17224], [-118.31863, 34.17327], [-118.3181, 34.1722], [-118.32051, 34.1699], [-118.32055, 34.16989], [-118.3206, 34.16992], [-118.32171, 34.1722]]]} | Open Access 1 | 934 | George Izay Park | 19267 | 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 | Los Angeles 6 | 15.711 | George Izay Park | 0 | Local Park 2 | 4 | |
347 | 347 | 346 | {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} | Restricted Access 2 | 953 | George Manooshian Park | 29754 | 2312 | Glendora Unified School District 141 | Special District 4 | School District 14 | http://www.glendora.k12.ca.us/ | Special District 4 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 18.865 | George Manooshian Park | 0 | Local Park 2 | 4 | |
357 | 357 | 356 | {"type": "Polygon", "coordinates": [[[-117.90242, 34.11526], [-117.90241, 34.11696], [-117.90124, 34.11696], [-117.90125, 34.11535], [-117.90158, 34.11535], [-117.90207, 34.11526], [-117.90242, 34.11526]]]} | Open Access 1 | 1002 | Gladstone Park | 19305 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 4.901 | Gladstone Park | 0 | Local Park 2 | 4 | |
382 | 382 | 381 | {"type": "Polygon", "coordinates": [[[-118.14657, 34.06646], [-118.1466, 34.06955], [-118.14658, 34.06956], [-118.14533, 34.06957], [-118.14532, 34.0683], [-118.1453, 34.06825], [-118.14526, 34.06822], [-118.14521, 34.0682], [-118.14515, 34.06821], [-118.1451, 34.06825], [-118.14509, 34.0683], [-118.14511, 34.06835], [-118.14522, 34.06841], [-118.14525, 34.06845], [-118.14526, 34.06889], [-118.14433, 34.06889], [-118.14431, 34.06792], [-118.14418, 34.06779], [-118.14452, 34.06756], [-118.14467, 34.06737], [-118.14473, 34.06724], [-118.14477, 34.06711], [-118.14476, 34.06657], [-118.14478, 34.06637], [-118.14485, 34.06608], [-118.14487, 34.06604], [-118.14528, 34.06603], [-118.14529, 34.0662], [-118.14641, 34.06619], [-118.14641, 34.06646], [-118.14657, 34.06646]]]} | Open Access 1 | 1147 | Granada Park | 19418 | 1003 | Alhambra, City of 158 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | Los Angeles 6 | 16.051 | Granada Park | 0 | Local Park 2 | 4 | |
406 | 406 | 405 | {"type": "Polygon", "coordinates": [[[-118.29329, 34.16445], [-118.29239, 34.1653], [-118.29166, 34.16477], [-118.29256, 34.16391], [-118.29329, 34.16445]]]} | Open Access 1 | 1246 | Griffith Manor Park | 19516 | 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 | Los Angeles 6 | 2.805 | Griffith Manor Park | 0 | Local Park 2 | 4 | |
408 | 408 | 407 | {"type": "Polygon", "coordinates": [[[-117.74, 34.11611], [-117.73999, 34.11804], [-117.738, 34.11801], [-117.73801, 34.1178], [-117.73811, 34.11634], [-117.73813, 34.11613], [-117.73814, 34.1161], [-117.73818, 34.11609], [-117.73923, 34.11609], [-117.73975, 34.1161], [-117.73989, 34.11612], [-117.74, 34.11611]]]} | Open Access 1 | 1253 | Griffith Park | 19517 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | Los Angeles 6 | 9.444 | Griffith Park | 0 | Local Park 2 | 4 | |
413 | 413 | 412 | {"type": "Polygon", "coordinates": [[[-118.60477, 34.27717], [-118.60418, 34.27703], [-118.60318, 34.2767], [-118.60222, 34.27647], [-118.60128, 34.2759], [-118.59886, 34.27528], [-118.59773, 34.27477], [-118.5968, 34.27437], [-118.59644, 34.27429], [-118.59687, 34.27384], [-118.59763, 34.27384], [-118.59817, 34.27352], [-118.59822, 34.27339], [-118.59913, 34.27345], [-118.59979, 34.27347], [-118.60035, 34.2736], [-118.60064, 34.27325], [-118.60057, 34.27261], [-118.60272, 34.2726], [-118.60273, 34.27228], [-118.60457, 34.27224], [-118.60449, 34.27236], [-118.60431, 34.27294], [-118.60432, 34.27441], [-118.60439, 34.27467], [-118.60448, 34.27485], [-118.60448, 34.27491], [-118.60457, 34.27492], [-118.60477, 34.27613], [-118.60481, 34.27645], [-118.60482, 34.27667], [-118.6048, 34.27695], [-118.60477, 34.27717]]]} | Open Access 1 | 831 | Stoney Point Park | 30273 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 55.047 | Stoney Point Park | 0 | Local Park 2 | 4 | |
415 | 415 | 414 | {"type": "Polygon", "coordinates": [[[-118.21396, 34.10912], [-118.21373, 34.10945], [-118.21319, 34.10986], [-118.21289, 34.11018], [-118.21235, 34.11095], [-118.21288, 34.11156], [-118.21273, 34.11194], [-118.21216, 34.11203], [-118.21173, 34.11207], [-118.21061, 34.11072], [-118.21136, 34.11055], [-118.21098, 34.11009], [-118.21022, 34.11025], [-118.21011, 34.11013], [-118.21088, 34.10996], [-118.21117, 34.10978], [-118.2106, 34.10917], [-118.21198, 34.10827], [-118.21371, 34.10856], [-118.2137, 34.10865], [-118.21396, 34.10912]]]} | Open Access 1 | 1647 | Heidelberg Park | 19791 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 18.734 | Heidelberg Park | 0 | Local Park 2 | 4 | |
449 | 449 | 448 | {"type": "Polygon", "coordinates": [[[-118.18446, 34.11514], [-118.1843, 34.11529], [-118.18412, 34.11522], [-118.1843, 34.11518], [-118.18446, 34.11514]]]} | Open Access 1 | 1807 | Highland Park | 19932 | 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.045 | Highland Park | 0 | Local Park 2 | 4 | |
465 | 465 | 464 | {"type": "Polygon", "coordinates": [[[-118.48671, 34.16591], [-118.48664, 34.16649], [-118.48663, 34.16717], [-118.48664, 34.16724], [-118.48669, 34.16733], [-118.48656, 34.1675], [-118.48638, 34.16753], [-118.48622, 34.16759], [-118.48616, 34.16766], [-118.48614, 34.16773], [-118.4862, 34.16804], [-118.48623, 34.16809], [-118.48628, 34.16811], [-118.48608, 34.16815], [-118.4861, 34.1681], [-118.48604, 34.16774], [-118.48591, 34.16777], [-118.48581, 34.1677], [-118.48557, 34.16772], [-118.48516, 34.16783], [-118.48494, 34.16787], [-118.48445, 34.16789], [-118.48418, 34.16787], [-118.48385, 34.1678], [-118.48369, 34.16772], [-118.48359, 34.1676], [-118.48357, 34.16755], [-118.48351, 34.1671], [-118.48355, 34.16638], [-118.48357, 34.16623], [-118.48362, 34.16609], [-118.48368, 34.16599], [-118.48374, 34.16594], [-118.48387, 34.1659], [-118.4853, 34.16589], [-118.48633, 34.16583], [-118.48634, 34.16591], [-118.48639, 34.16594], [-118.48671, 34.16591]]]} | Open Access 1 | 1861 | Hjelte Sports Center | 20010 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 14.721 | Hjelte Sports Ctr. | 0 | Recreation Management Area 49 | 4 | |
472 | 472 | 471 | {"type": "Polygon", "coordinates": [[[-118.60788, 34.06942], [-118.60718, 34.06977], [-118.60688, 34.06935], [-118.60758, 34.069], [-118.60788, 34.06942]]]} | Open Access 1 | 35762 | Los Angeles holding 8 | 21495 | 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 | 1.024 | Los Angeles holding 8 | 0 | Local Other or Unknown 14 | 4 | |
474 | 474 | 473 | {"type": "Polygon", "coordinates": [[[-118.12741, 34.05935], [-118.12683, 34.05934], [-118.12682, 34.05887], [-118.12559, 34.05887], [-118.12556, 34.05667], [-118.12621, 34.05666], [-118.12622, 34.05665], [-118.12636, 34.05664], [-118.12637, 34.05666], [-118.12738, 34.05665], [-118.12741, 34.05935]]]} | Open Access 1 | 1522 | Barnes Park | 15822 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 10.866 | Barnes Park | 0 | Local Park 2 | 4 | |
492 | 492 | 491 | {"type": "Polygon", "coordinates": [[[-118.48488, 34.0059], [-118.48412, 34.00642], [-118.48348, 34.00578], [-118.48423, 34.00526], [-118.48488, 34.0059]]]} | Open Access 1 | 1976 | Hotchkiss Park | 20105 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.08 | Hotchkiss Park | 0 | Local Park 2 | 4 | |
493 | 493 | 492 | {"type": "Polygon", "coordinates": [[[-118.40813, 34.28144], [-118.40657, 34.28258], [-118.40505, 34.28116], [-118.40662, 34.28002], [-118.40813, 34.28144]]]} | Open Access 1 | 1998 | Hubert H. Humphrey Memorial Park | 20130 | 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 | 9.987 | Hubert H. Humphrey Memorial Park | 0 | Local Park 2 | 4 | |
511 | 511 | 510 | {"type": "Polygon", "coordinates": [[[-118.19601, 34.05796], [-118.19489, 34.05976], [-118.19436, 34.05954], [-118.19513, 34.0583], [-118.1952, 34.05834], [-118.19523, 34.05833], [-118.19532, 34.05836], [-118.19542, 34.05832], [-118.19563, 34.05796], [-118.19573, 34.058], [-118.19601, 34.05796]]]} | Open Access 1 | 1704 | Henry Alvarez Memorial Park | 19822 | 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 | 2.566 | Henry Alvarez Memorial Park | 0 | Local Park 2 | 4 | |
514 | 514 | 513 | {"type": "Polygon", "coordinates": [[[-118.29549, 34.09994], [-118.29552, 34.10008], [-118.29552, 34.10036], [-118.2955, 34.10049], [-118.29546, 34.10058], [-118.29538, 34.10069], [-118.29515, 34.10094], [-118.29543, 34.10117], [-118.29519, 34.10127], [-118.2953, 34.10134], [-118.2953, 34.10166], [-118.29326, 34.10167], [-118.29326, 34.10131], [-118.29305, 34.10119], [-118.29296, 34.10103], [-118.29294, 34.10094], [-118.29294, 34.10085], [-118.29299, 34.10075], [-118.29298, 34.09918], [-118.29357, 34.0992], [-118.29358, 34.09919], [-118.29391, 34.09915], [-118.29454, 34.09916], [-118.29462, 34.0992], [-118.29469, 34.09919], [-118.29473, 34.09923], [-118.29489, 34.09928], [-118.29489, 34.09935], [-118.29492, 34.09941], [-118.29518, 34.0996], [-118.29539, 34.09978], [-118.29549, 34.09994]]]} | Open Access 1 | 1713 | Barnsdall Park | 15825 | 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 | 14.293 | Barnsdall 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]);