units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,921 rows where COUNTY = 6 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 484
- Mountains Recreation and Conservation Authority 333
- Los Angeles, County of 175
- Long Beach, City of 148
- Torrance, City of 73
- Los Angeles - Department of Parks and Recreation, County of 65
- Glendale, City of 61
- Santa Clarita, City of 51
- Whittier, City of 48
- Redondo Beach, City of 37
- Pasadena, City of 37
- Burbank, City of 33
- Santa Monica, City of 31
- Pomona, City of 30
- Palmdale, City of 30
- Mountains Restoration Trust 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
- Las Virgenes Municipal Water District 25
- Claremont, City of 24
- Arcadia, City of 23
- Cerritos, City of 22
- Los Angeles County Flood Control District 22
- South Pasadena, City of 22
- United States Army Corps of Engineers 21
- Beverly Hills, City of 21
- Culver City, City of 20
- …
DES_TP >30
- Local Park 1,645
- Local Recreation Area 498
- Local Other or Unknown 214
- Local Conservation Area 85
- Private Recreation or Education 43
- 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
- None 1
- National Monument or Landmark 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 26
- City Agency 1,972
- Open Space District 333
- County Agency 175
- County Agency - Parks 65
- Federal Agency 61
- State Agency 55
- Non Profit - Conservation 33
- School District 33
- Water District 30
- Irrigation District 27
- Flood District 22
- 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,314
- Restricted Access 244
- No Public Access 196
- Unknown Access 147
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4693 | 4693 | 4692 | {"type": "Polygon", "coordinates": [[[-118.42279, 34.08006], [-118.42271, 34.08009], [-118.4227, 34.0798], [-118.42279, 34.07993], [-118.42279, 34.08006]]]} | Open Access 1 | 45802 | Gateway Triangle | 28822 | 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.044 | Gateway Triangle | 0 | Local Other or Unknown 14 | 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 | |
7220 | 7220 | 7219 | {"type": "Polygon", "coordinates": [[[-118.3724, 34.10748], [-118.37214, 34.10757], [-118.3721, 34.1075], [-118.37219, 34.10747], [-118.37231, 34.10745], [-118.3724, 34.10748]]]} | Open Access 1 | 6885 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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 | 0.045 | 0 | Local Other or Unknown 14 | 4 | ||
8267 | 8267 | 8266 | {"type": "Polygon", "coordinates": [[[-118.04203, 34.17256], [-118.04202, 34.17268], [-118.04184, 34.17269], [-118.04181, 34.17267], [-118.04187, 34.17258], [-118.04201, 34.17259], [-118.04203, 34.17256]]]} | Open Access 1 | 12650 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 0.047 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
11234 | 11234 | 11233 | {"type": "Polygon", "coordinates": [[[-118.15695, 34.11034], [-118.157, 34.11035], [-118.15703, 34.11042], [-118.15701, 34.11047], [-118.15695, 34.1105], [-118.1569, 34.11048], [-118.15687, 34.11042], [-118.15688, 34.11037], [-118.15695, 34.11034]]]} | Open Access 1 | 48040 | El Cerrito Circle Park | 32533 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 0.048 | El Cerrito Circle Park | 0 | Local Park 2 | 4 | |
9404 | 9404 | 9403 | {"type": "Polygon", "coordinates": [[[-118.67423, 34.13343], [-118.67408, 34.13345], [-118.67407, 34.13332], [-118.67422, 34.13331], [-118.67423, 34.13343]]]} | No Public Access 3 | 12423 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.05 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
793 | 793 | 792 | {"type": "Polygon", "coordinates": [[[-118.43173, 33.99148], [-118.43157, 33.99155], [-118.43154, 33.99132], [-118.43173, 33.99148], [-118.43173, 33.99148]]]} | Open Access 1 | 5165 | Maxella Parkette | 21967 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 0.051 | Maxella Parkette | 0 | Local Park 2 | 4 | |
6967 | 6967 | 6966 | {"type": "Polygon", "coordinates": [[[-118.38992, 33.85746], [-118.38985, 33.85749], [-118.38978, 33.85725], [-118.38985, 33.85722], [-118.38992, 33.85746]]]} | Open Access 1 | 6104 | Ocean View Parkette | 29776 | 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 | Los Angeles 6 | 0.051 | Ocean View Parkette | 0 | Local Park 2 | 4 | |
4092 | 4092 | 4091 | {"type": "Polygon", "coordinates": [[[-118.518, 34.05167], [-118.51753, 34.05174], [-118.51751, 34.0517], [-118.51798, 34.05163], [-118.518, 34.05167]]]} | No Public Access 3 | 47493 | Chautauqua Blvd Access to Will Rogers State Historic Preserve | 31212 | 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.053 | Chautauqua Blvd Access to Will Rogers SHPr | None 355 | |||
5641 | 5641 | 5640 | {"type": "Polygon", "coordinates": [[[-118.22852, 34.08438], [-118.2285, 34.0844], [-118.22844, 34.0843], [-118.22835, 34.08422], [-118.22833, 34.08418], [-118.22835, 34.08399], [-118.22852, 34.08438]]]} | Open Access 1 | 46908 | Egret Park | 30449 | 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 | 0.055 | Egret Park | 0 | Local Park 2 | 4 | |
2878 | 2878 | 2877 | {"type": "Polygon", "coordinates": [[[-118.31233, 34.03401], [-118.31231, 34.03394], [-118.31235, 34.03388], [-118.31242, 34.03384], [-118.31252, 34.03386], [-118.31252, 34.03389], [-118.31239, 34.03402], [-118.31236, 34.03402], [-118.31233, 34.03401]]]} | Open Access 1 | 18875 | Gramercy Park | 29322 | 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.056 | Gramercy Park | 0 | Local Park 2 | 4 | |
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 |
4495 | 4495 | 4494 | {"type": "Polygon", "coordinates": [[[-118.43891, 34.09306], [-118.43861, 34.0933], [-118.43858, 34.0933], [-118.43856, 34.09326], [-118.43886, 34.09303], [-118.43891, 34.09306]]]} | Open Access 1 | 6391 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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 | 0.059 | 0 | Local Other or Unknown 14 | 4 | ||
13518 | 13518 | 13517 | {"type": "Polygon", "coordinates": [[[-118.37289, 33.82747], [-118.37259, 33.82737], [-118.37257, 33.82732], [-118.37286, 33.82735], [-118.37289, 33.82747]]]} | Open Access 1 | 35830 | Torrance holding 6 | 26464 | 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 | Los Angeles 6 | 0.06 | Torrance holding 6 | 0 | Local Other or Unknown 14 | 4 | |
15414 | 15414 | 15413 | {"type": "Polygon", "coordinates": [[[-118.36138, 34.08051], [-118.36127, 34.08051], [-118.36128, 34.08027], [-118.36137, 34.08028], [-118.36138, 34.08051]]]} | Open Access 1 | 46642 | Rosewood Gardens Park | 29970 | 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.06 | Rosewood Gardens Park | 0 | Local Park 2 | 4 | |
1269 | 1269 | 1268 | {"type": "Polygon", "coordinates": [[[-118.26461, 34.17807], [-118.26461, 34.17807], [-118.26442, 34.17818], [-118.2644, 34.17805], [-118.26441, 34.17804], [-118.26459, 34.17797], [-118.26461, 34.17807]]]} | Open Access 1 | 7148 | City of Glendale Verdugo Mountains Open Space | 4153 | 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 | 0.061 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
4698 | 4698 | 4697 | {"type": "Polygon", "coordinates": [[[-118.44773, 34.10525], [-118.4477, 34.10553], [-118.44762, 34.10554], [-118.44765, 34.10524], [-118.44773, 34.10525]]]} | Unknown Access 4 | 46110 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 0.061 | 0 | Local Other or Unknown 14 | 4 | ||
5704 | 5704 | 5703 | {"type": "Polygon", "coordinates": [[[-118.27079, 34.05157], [-118.27054, 34.05146], [-118.27065, 34.05131], [-118.27066, 34.05133], [-118.27079, 34.05157]]]} | Open Access 1 | 45766 | Valencia Triangle | 28772 | 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.063 | Valencia Triangle | 0 | Local Other or Unknown 14 | 4 | |
4018 | 4018 | 4017 | {"type": "Polygon", "coordinates": [[[-118.43109, 34.19476], [-118.43107, 34.19479], [-118.43103, 34.19481], [-118.4306, 34.19481], [-118.4306, 34.19476], [-118.43109, 34.19476]]]} | Open Access 1 | 1478 | Hartland Mini Park | 19710 | 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.065 | Hartland MP | 0 | Local Park 2 | 4 | |
15328 | 15328 | 15327 | {"type": "Polygon", "coordinates": [[[-118.39599, 33.85309], [-118.39592, 33.85328], [-118.39582, 33.85331], [-118.39579, 33.85324], [-118.39582, 33.85314], [-118.39599, 33.85309]]]} | Open Access 1 | 46504 | Kay Etow Parkette | 29788 | 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 | Los Angeles 6 | 0.065 | Kay Etow Parkette | 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]);