units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where ACCESS_TYP = 3, COUNTY = 6 and DES_TP = 14
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV
MNG_AGENCY 10
- Los Angeles, City of 12
- Los Angeles County Flood Control District 10
- Mountains Recreation and Conservation Authority 4
- Los Angeles - Department of Water and Power, City of 2
- Rancho Palos Verdes, City of 2
- Torrance, City of 2
- Los Angeles, County of 1
- Paramount, City of 1
- Diamond Bar, City of 1
- Pasadena Department of Water and Power 1
MNG_AG_TYP 4
DES_TP 1
- Local Other or Unknown · 36 ✖
ACCESS_TYP 1
- No Public Access · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1437 | 1437 | 1436 | {"type": "MultiPolygon", "coordinates": [[[[-118.34031, 34.12245], [-118.33893, 34.12345], [-118.33872, 34.12325], [-118.34008, 34.12224], [-118.34031, 34.12245]]], [[[-118.33885, 34.12352], [-118.33618, 34.12548], [-118.33607, 34.12549], [-118.33599, 34.12546], [-118.33595, 34.12544], [-118.3359, 34.12532], [-118.33855, 34.12337], [-118.33863, 34.12331], [-118.33885, 34.12352]]]]} | No Public Access 3 | 12459 | Los Angeles Department of Water and Power | 21482 | 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 | 3.847 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
1634 | 1634 | 1633 | {"type": "Polygon", "coordinates": [[[-118.33735, 34.1239], [-118.33702, 34.12408], [-118.33683, 34.12383], [-118.33721, 34.12367], [-118.33731, 34.12385], [-118.33735, 34.1239]]]} | No Public Access 3 | 12456 | Los Angeles Department of Water and Power | 21482 | 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.284 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
1637 | 1637 | 1636 | {"type": "Polygon", "coordinates": [[[-118.34683, 34.11999], [-118.34463, 34.11999], [-118.34429, 34.11994], [-118.34428, 34.12], [-118.34364, 34.12], [-118.3434, 34.12018], [-118.34321, 34.11995], [-118.34352, 34.11973], [-118.34369, 34.11972], [-118.3438, 34.11978], [-118.34393, 34.11981], [-118.34412, 34.1198], [-118.34424, 34.11974], [-118.34427, 34.11972], [-118.34662, 34.11971], [-118.34683, 34.11999]]]} | No Public Access 3 | 12462 | Los Angeles Department of Water and Power | 21482 | 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.35 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
2461 | 2461 | 2460 | {"type": "Polygon", "coordinates": [[[-118.34315, 34.12036], [-118.34289, 34.12054], [-118.34274, 34.1204], [-118.34265, 34.12036], [-118.34296, 34.12013], [-118.34315, 34.12036]]]} | No Public Access 3 | 12465 | Los Angeles Department of Water and Power | 21482 | 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.255 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
2462 | 2462 | 2461 | {"type": "Polygon", "coordinates": [[[-118.35722, 34.10552], [-118.35702, 34.10564], [-118.35703, 34.10532], [-118.35722, 34.10533], [-118.35722, 34.10552]]]} | No Public Access 3 | 12466 | Los Angeles Department of Water and Power | 21482 | 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.129 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
3582 | 3582 | 3581 | {"type": "Polygon", "coordinates": [[[-118.32429, 33.80965], [-118.32389, 33.80965], [-118.32389, 33.80924], [-118.32429, 33.80924], [-118.32429, 33.80965]]]} | No Public Access 3 | 36688 | Empty Lot 237th and Vine | 29082 | 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.419 | Empty Lot 237th and Vine | 0 | Local Other or Unknown 14 | 4 | |
4613 | 4613 | 4612 | {"type": "Polygon", "coordinates": [[[-118.63997, 34.08326], [-118.63997, 34.08356], [-118.63947, 34.08386], [-118.6392, 34.08385], [-118.63897, 34.08343], [-118.63935, 34.08326], [-118.63997, 34.08326]]]} | No Public Access 3 | 35763 | Unnamed site - Los Angeles County Waterworks | 30320 | 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.128 | 0 | Local Other or Unknown 14 | 4 | ||
4661 | 4661 | 4660 | {"type": "Polygon", "coordinates": [[[-117.78588, 34.00726], [-117.78565, 34.00739], [-117.78506, 34.00701], [-117.78504, 34.00526], [-117.78514, 34.00526], [-117.78514, 34.0053], [-117.78517, 34.00534], [-117.78508, 34.00536], [-117.78509, 34.00642], [-117.78513, 34.00642], [-117.7853, 34.00662], [-117.78543, 34.00667], [-117.78578, 34.00669], [-117.78585, 34.00678], [-117.78583, 34.00699], [-117.78588, 34.00726]]]} | No Public Access 3 | 36593 | Unnamed site - Diamond Bar, City of | 31868 | 1085 | Diamond Bar, City of 315 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | Los Angeles 6 | 1.381 | 0 | Local Other or Unknown 14 | 4 | ||
4695 | 4695 | 4694 | {"type": "Polygon", "coordinates": [[[-118.83097, 34.10947], [-118.83097, 34.11083], [-118.82952, 34.11087], [-118.82952, 34.10951], [-118.83097, 34.10947]]]} | No Public Access 3 | 46094 | Unnamed site - Mountains Recreation and Conservation Authority | 29443 | 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 | 4.983 | 0 | Local Other or Unknown 14 | 4 | ||
4696 | 4696 | 4695 | {"type": "Polygon", "coordinates": [[[-118.35241, 34.12398], [-118.35222, 34.12417], [-118.35164, 34.12414], [-118.35161, 34.12403], [-118.35143, 34.12373], [-118.35165, 34.1237], [-118.35167, 34.12374], [-118.35217, 34.1238], [-118.35241, 34.12398]]]} | No Public Access 3 | 46099 | Unnamed site - Mountains Recreation and Conservation Authority | 29443 | 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.741 | 0 | Local Other or Unknown 14 | 4 | ||
4697 | 4697 | 4696 | {"type": "MultiPolygon", "coordinates": [[[[-118.59772, 34.10171], [-118.59584, 34.1017], [-118.59584, 34.1016], [-118.59592, 34.10153], [-118.59603, 34.10158], [-118.59614, 34.1016], [-118.59631, 34.10159], [-118.59642, 34.10155], [-118.59664, 34.10141], [-118.5977, 34.10064], [-118.59772, 34.10171]]], [[[-118.59873, 34.1003], [-118.59859, 34.10049], [-118.59819, 34.10047], [-118.59832, 34.10038], [-118.59833, 34.10034], [-118.59873, 34.1003]]], [[[-118.59918, 34.09989], [-118.59912, 34.09996], [-118.59848, 34.0997], [-118.59864, 34.09958], [-118.59918, 34.09989]]]]} | No Public Access 3 | 46101 | Unnamed site - Mountains Recreation and Conservation Authority | 29443 | 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 | 2.521 | 0 | Local Other or Unknown 14 | 4 | ||
4749 | 4749 | 4748 | {"type": "Polygon", "coordinates": [[[-118.25828, 33.88611], [-118.25795, 33.88612], [-118.25789, 33.88584], [-118.25805, 33.88581], [-118.25821, 33.88581], [-118.25828, 33.88611]]]} | No Public Access 3 | 46441 | Unnamed site - Carson, City of | 29713 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 0.248 | 0 | Local Other or Unknown 14 | 4 | ||
4756 | 4756 | 4755 | {"type": "Polygon", "coordinates": [[[-118.1743, 33.90349], [-118.17321, 33.9035], [-118.17318, 33.89977], [-118.17427, 33.89978], [-118.1743, 33.90349]]]} | No Public Access 3 | 46526 | Unnamed site - Paramount, City of | 29815 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | Los Angeles 6 | 10.254 | 0 | Local Other or Unknown 14 | 4 | ||
4780 | 4780 | 4779 | {"type": "Polygon", "coordinates": [[[-118.47366, 34.29783], [-118.47355, 34.29793], [-118.47333, 34.2977], [-118.47324, 34.29763], [-118.47288, 34.29749], [-118.47272, 34.29746], [-118.47223, 34.29752], [-118.47187, 34.29753], [-118.47171, 34.2975], [-118.47156, 34.29743], [-118.47049, 34.29842], [-118.47038, 34.29838], [-118.47028, 34.29842], [-118.47025, 34.29846], [-118.47024, 34.29851], [-118.47025, 34.29856], [-118.47029, 34.2986], [-118.46993, 34.29891], [-118.469, 34.29819], [-118.46832, 34.29879], [-118.46779, 34.29838], [-118.46751, 34.29861], [-118.46695, 34.29818], [-118.4664, 34.29866], [-118.46584, 34.29823], [-118.4659, 34.29817], [-118.4659, 34.29816], [-118.46567, 34.29798], [-118.4656, 34.29804], [-118.46529, 34.2978], [-118.46558, 34.29754], [-118.46494, 34.29704], [-118.46518, 34.29675], [-118.466, 34.29475], [-118.46893, 34.29378], [-118.46908, 34.29382], [-118.46937, 34.29407], [-118.47092, 34.29532], [-118.47113, 34.29569], [-118.47219, 34.29665], [-118.47274, 34.2972], [-118.47291, 34.29709], [-118.47366, 34.29783]]]} | No Public Access 3 | 47096 | Unnamed site - Los Angeles - Department of Water and Power, City of | 30755 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 61.962 | 0 | Local Other or Unknown 14 | 4 | ||
6952 | 6952 | 6951 | {"type": "MultiPolygon", "coordinates": [[[[-118.36586, 33.74172], [-118.36573, 33.74211], [-118.36423, 33.74199], [-118.36421, 33.74194], [-118.36354, 33.74194], [-118.36342, 33.7416], [-118.36408, 33.74169], [-118.36424, 33.74176], [-118.36433, 33.74168], [-118.36443, 33.74165], [-118.36534, 33.74164], [-118.36536, 33.74158], [-118.36536, 33.74124], [-118.36571, 33.74125], [-118.36574, 33.74162], [-118.36572, 33.74169], [-118.36586, 33.74172]]], [[[-118.36682, 33.74147], [-118.36644, 33.74187], [-118.36637, 33.74183], [-118.36622, 33.7418], [-118.36635, 33.74143], [-118.3663, 33.7412], [-118.36673, 33.74113], [-118.36682, 33.74147]]]]} | No Public Access 3 | 5857 | Cherry Hill Lots | 29428 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 3.173 | Cherry Hill Lots | 0 | Local Other or Unknown 14 | 4 | |
6995 | 6995 | 6994 | {"type": "Polygon", "coordinates": [[[-118.36582, 33.77009], [-118.36565, 33.7707], [-118.36519, 33.7703], [-118.36438, 33.76974], [-118.36407, 33.76975], [-118.36455, 33.7693], [-118.36507, 33.76969], [-118.36541, 33.7699], [-118.36582, 33.77009]]]} | No Public Access 3 | 5928 | McKay Property Open Space - RPV | 29430 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 2.037 | McKay Property OS - RPV | 0 | Local Other or Unknown 14 | 4 | |
7024 | 7024 | 7023 | {"type": "MultiPolygon", "coordinates": [[[[-118.29936, 33.76462], [-118.29901, 33.76463], [-118.2977, 33.76459], [-118.29684, 33.76458], [-118.29636, 33.76464], [-118.29634, 33.7645], [-118.29695, 33.76443], [-118.29897, 33.76449], [-118.29936, 33.76447], [-118.29936, 33.76462]]], [[[-118.30254, 33.76446], [-118.30187, 33.76451], [-118.29974, 33.76461], [-118.29957, 33.76461], [-118.29955, 33.76452], [-118.29957, 33.76448], [-118.30224, 33.76435], [-118.30244, 33.7643], [-118.3025, 33.76432], [-118.30254, 33.76446]]], [[[-118.30313, 33.76447], [-118.30304, 33.76446], [-118.30276, 33.76452], [-118.30271, 33.76437], [-118.3028, 33.76437], [-118.30307, 33.76431], [-118.30313, 33.76447]]]]} | No Public Access 3 | 5974 | City of Los Angeles Flood Control | 17320 | 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.225 | City of Los Angeles Flood Control | 0 | Local Other or Unknown 14 | 4 | |
7111 | 7111 | 7110 | {"type": "MultiPolygon", "coordinates": [[[[-118.28809, 33.79111], [-118.28789, 33.79151], [-118.28789, 33.79271], [-118.28758, 33.79273], [-118.28759, 33.79285], [-118.28789, 33.79286], [-118.28788, 33.79407], [-118.28758, 33.79355], [-118.28712, 33.79355], [-118.28703, 33.79257], [-118.28728, 33.79176], [-118.2873, 33.79163], [-118.2873, 33.79112], [-118.28809, 33.79111]]], [[[-118.28884, 33.79414], [-118.28884, 33.79461], [-118.2882, 33.79461], [-118.28805, 33.79435], [-118.28806, 33.79285], [-118.28837, 33.79285], [-118.28836, 33.79318], [-118.28845, 33.79318], [-118.28844, 33.794], [-118.28884, 33.79401], [-118.28884, 33.79414]]], [[[-118.28884, 33.79478], [-118.28884, 33.79511], [-118.28883, 33.7957], [-118.2883, 33.79478], [-118.28884, 33.79478]]], [[[-118.28979, 33.79607], [-118.28978, 33.79731], [-118.28946, 33.79732], [-118.28947, 33.79761], [-118.28899, 33.79761], [-118.289, 33.79539], [-118.28939, 33.79538], [-118.2894, 33.79552], [-118.28978, 33.79552], [-118.28979, 33.79607]]], [[[-118.28994, 33.79789], [-118.28993, 33.79899], [-118.28916, 33.80024], [-118.28897, 33.80024], [-118.28891, 33.80001], [-118.28877, 33.79965], [-118.28852, 33.79913], [-118.28826, 33.79876], [-118.28819, 33.79867], [-118.28837, 33.79789], [-118.28994, 33.79789]]]]} | No Public Access 3 | 6187 | Canada de Palos Verdes Creek | 16791 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 18.831 | Canada de Palos Verdes Creek | 0 | Local Other or Unknown 14 | 4 | |
8200 | 8200 | 8199 | {"type": "MultiPolygon", "coordinates": [[[[-118.33463, 34.12624], [-118.33405, 34.12668], [-118.33375, 34.13173], [-118.33423, 34.13423], [-118.33134, 34.13425], [-118.33127, 34.12836], [-118.33126, 34.12624], [-118.3314, 34.12622], [-118.33151, 34.12623], [-118.33199, 34.12651], [-118.33206, 34.12654], [-118.3322, 34.12653], [-118.33229, 34.12646], [-118.33233, 34.1264], [-118.33231, 34.12629], [-118.33189, 34.12568], [-118.33186, 34.12556], [-118.33185, 34.12534], [-118.33189, 34.12527], [-118.33198, 34.12521], [-118.33226, 34.1252], [-118.33236, 34.12517], [-118.33241, 34.12512], [-118.33246, 34.12505], [-118.33247, 34.12491], [-118.3325, 34.12483], [-118.33258, 34.12473], [-118.33266, 34.12471], [-118.33271, 34.1247], [-118.33281, 34.12475], [-118.33288, 34.12486], [-118.33294, 34.12491], [-118.33301, 34.12494], [-118.33318, 34.12493], [-118.33321, 34.12493], [-118.33327, 34.12498], [-118.33328, 34.12505], [-118.33322, 34.1254], [-118.33325, 34.1255], [-118.33335, 34.12558], [-118.33341, 34.1256], [-118.33351, 34.1256], [-118.3338, 34.12547], [-118.33393, 34.12544], [-118.33422, 34.12543], [-118.33431, 34.12547], [-118.33435, 34.12552], [-118.33437, 34.12561], [-118.33421, 34.12606], [-118.33422, 34.12616], [-118.33429, 34.12624], [-118.33439, 34.12627], [-118.33463, 34.12624]]], [[[-118.34284, 34.1246], [-118.34175, 34.12562], [-118.34119, 34.12633], [-118.3416, 34.12668], [-118.34143, 34.12682], [-118.34141, 34.12682], [-118.34113, 34.12705], [-118.34105, 34.12717], [-118.34101, 34.12744], [-118.34101, 34.12754], [-118.3411, 34.12786], [-118.3411, 34.12797], [-118.34101, 34.12831], [-118.34098, 34.12834], [-118.3409, 34.12834], [-118.34052, 34.12814], [-118.34048, 34.12809], [-118.34041, 34.12807], [-118.34037, 34.12807], [-118.34024, 34.12822], [-118.34033, 34.12828], [-118.34028, 34.12827], [-118.33996, 34.1283], [-118.33987, 34.12837], [-118.33987, 34.12839], [-118.3403, 34.12878], [-118.34018, 34.12884], [-118.34025, 34.12909], [-118.34014, 34.12929], [-118.3393, 34.12926], [-118.33936, 34.12981], [-118.33931, 34.13018], [-118.33901, 34.13021], [-118.339, 34.13027], [-118.33897, 34.13033], [-118.33882, 34.13046], [-118.33869, 34.13065], [-118.33862, 34.13071], [-118.33836, 34.13081], [-118.33831, 34.13087], [-118.3383, 34.13091], [-118.33834, 34.13103], [-118.33835, 34.13111], [-118.33832, 34.13123], [-118.33825, 34.13137], [-118.33824, 34.13145], [-118.33825, 34.13153], [-118.33837, 34.13154], [-118.33834, 34.13175], [-118.33836, 34.13205], [-118.338, 34.13208], [-118.33796, 34.13204], [-118.33785, 34.131], [-118.33779, 34.13068], [-118.33772, 34.13043], [-118.33763, 34.13019], [-118.33731, 34.12941], [-118.33723, 34.12926], [-118.3371, 34.12911], [-118.33697, 34.12901], [-118.33678, 34.12891], [-118.33638, 34.12896], [-118.33638, 34.12897], [-118.33653, 34.12899], [-118.33665, 34.12903], [-118.33687, 34.12913], [-118.33703, 34.12927], [-118.33716, 34.12947], [-118.33747, 34.13022], [-118.33762, 34.13065], [-118.33768, 34.13095], [-118.33779, 34.1321], [-118.33774, 34.13213], [-118.33741, 34.13225], [-118.33733, 34.13226], [-118.33728, 34.13224], [-118.33722, 34.13219], [-118.33718, 34.1321], [-118.3371, 34.13203], [-118.33705, 34.13201], [-118.33695, 34.13201], [-118.33688, 34.13204], [-118.33682, 34.13209], [-118.33672, 34.13225], [-118.33663, 34.13233], [-118.33647, 34.1324], [-118.33641, 34.13248], [-118.3364, 34.13258], [-118.33644, 34.13272], [-118.33644, 34.13284], [-118.3364, 34.13298], [-118.3363, 34.13313], [-118.33616, 34.13322], [-118.33592, 34.13325], [-118.33568, 34.1334], [-118.33556, 34.13345], [-118.33532, 34.1335], [-118.33497, 34.13349], [-118.33486, 34.13353], [-118.33478, 34.13359], [-118.33468, 34.13377], [-118.33454, 34.13412], [-118.33408, 34.13172], [-118.33437, 34.1268], [-118.335, 34.12634], [-118.33512, 34.1268], [-118.33512, 34.1269], [-118.33508, 34.12699], [-118.33502, 34.12703], [-118.33485, 34.12713], [-118.33479, 34.12718], [-118.33476, 34.12725], [-118.33477, 34.12734], [-118.33482, 34.1274], [-118.33489, 34.12746], [-118.33492, 34.12751], [-118.33495, 34.1276], [-118.33494, 34.12767], [-118.33477, 34.12796], [-118.33467, 34.12805], [-118.33448, 34.12815], [-118.33441, 34.12822], [-118.33437, 34.12829], [-118.33437, 34.12836], [-118.33442, 34.12845], [-118.33452, 34.12853], [-118.33466, 34.12857], [-118.33474, 34.12863], [-118.33478, 34.1287], [-118.3348, 34.12882], [-118.33485, 34.12888], [-118.33491, 34.12894], [-118.33503, 34.12898], [-118.33515, 34.12898], [-118.33524, 34.12895], [-118.33532, 34.12889], [-118.33542, 34.12878], [-118.33555, 34.12873], [-118.33562, 34.12873], [-118.3357, 34.12876], [-118.3358, 34.12883], [-118.33589, 34.12888], [-118.33598, 34.1289], [-118.33609, 34.12889], [-118.33617, 34.12886], [-118.33624, 34.12881], [-118.33632, 34.12868], [-118.33632, 34.12856], [-118.33622, 34.12827], [-118.33619, 34.12816], [-118.33619, 34.12796], [-118.33633, 34.12742], [-118.33643, 34.12732], [-118.33649, 34.1273], [-118.33669, 34.12728], [-118.33675, 34.12726], [-118.3368, 34.12722], [-118.33685, 34.12714], [-118.33685, 34.12706], [-118.3368, 34.12699], [-118.33635, 34.12672], [-118.33621, 34.12657], [-118.33621, 34.12649], [-118.33627, 34.12643], [-118.33631, 34.12634], [-118.33631, 34.12625], [-118.33627, 34.12602], [-118.33626, 34.12601], [-118.33626, 34.12593], [-118.33629, 34.12585], [-118.33639, 34.12573], [-118.3364, 34.12562], [-118.33637, 34.12555], [-118.33631, 34.12551], [-118.33624, 34.12548], [-118.33618, 34.12548], [-118.33827, 34.12394], [-118.3384, 34.1244], [-118.3385, 34.12457], [-118.33865, 34.12471], [-118.33881, 34.12458], [-118.33906, 34.1248], [-118.33947, 34.12448], [-118.33986, 34.12462], [-118.33996, 34.1242], [-118.34003, 34.12419], [-118.34016, 34.12414], [-118.34024, 34.1241], [-118.34042, 34.12395], [-118.34048, 34.12383], [-118.34049, 34.12365], [-118.34051, 34.12361], [-118.34075, 34.12347], [-118.34101, 34.12347], [-118.34111, 34.1235], [-118.3414, 34.12367], [-118.34176, 34.12397], [-118.3418, 34.12402], [-118.34179, 34.12407], [-118.34174, 34.12411], [-118.34171, 34.12415], [-118.34174, 34.12467], [-118.34182, 34.12466], [-118.3418, 34.12415], [-118.34183, 34.12414], [-118.34186, 34.12415], [-118.34191, 34.12423], [-118.34197, 34.12428], [-118.34211, 34.12433], [-118.34228, 34.12432], [-118.34242, 34.12425], [-118.34284, 34.1246]]], [[[-118.33549, 34.13381], [-118.33545, 34.13405], [-118.3354, 34.13414], [-118.3354, 34.13422], [-118.33457, 34.13422], [-118.33484, 34.13365], [-118.3349, 34.13359], [-118.33497, 34.13356], [-118.33531, 34.13358], [-118.33549, 34.13381]]]]} | No Public Access 3 | 12455 | Los Angeles Department of Water and Power | 21482 | 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 | 166.66 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8202 | 8202 | 8201 | {"type": "Polygon", "coordinates": [[[-118.33726, 34.1416], [-118.33447, 34.14462], [-118.33195, 34.14673], [-118.33158, 34.14719], [-118.33121, 34.14736], [-118.33087, 34.14757], [-118.33172, 34.14655], [-118.33181, 34.14647], [-118.33421, 34.14444], [-118.33691, 34.14153], [-118.33594, 34.1372], [-118.33525, 34.13611], [-118.33514, 34.1361], [-118.33504, 34.13595], [-118.33491, 34.13583], [-118.3349, 34.13579], [-118.33491, 34.13557], [-118.3348, 34.13541], [-118.33462, 34.1353], [-118.33461, 34.13527], [-118.33462, 34.13512], [-118.33431, 34.13463], [-118.33375, 34.13174], [-118.33405, 34.12667], [-118.33463, 34.12624], [-118.33474, 34.12622], [-118.33484, 34.12622], [-118.33491, 34.12625], [-118.335, 34.12634], [-118.33437, 34.1268], [-118.33408, 34.13172], [-118.33454, 34.13412], [-118.33449, 34.13422], [-118.33457, 34.13423], [-118.33464, 34.13456], [-118.33626, 34.13712], [-118.33726, 34.1416]]]} | No Public Access 3 | 12457 | Los Angeles Department of Water and Power | 21482 | 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 | 19.655 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 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]);