units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
96 rows where ACCESS_TYP = 3 and DES_TP = 14 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, COUNTY, YR_EST
MNG_AGENCY >30
- Los Angeles, City of 12
- Los Angeles County Flood Control District 10
- Escondido, City of 9
- San Diego, City of 8
- Napa, City of 8
- Rocklin, City of 6
- Mountains Recreation and Conservation Authority 4
- Santa Barbara Flood Control and Water Conserv. District 3
- San Diego, County of 3
- Natomas Basin Conservancy 3
- Los Angeles - Department of Water and Power, City of 2
- Rancho Palos Verdes, City of 2
- Torrance, City of 2
- Santa Barbara, County of 1
- Watsonville, City of 1
- Los Angeles, County of 1
- Monterey, County of 1
- Napa County Regional Park and Open Space District 1
- Chula Vista, City of 1
- Petaluma, City of 1
- Davis, City of 1
- San Marcos, City of 1
- Paramount, City of 1
- Diamond Bar, City of 1
- Sonoma County Agricultural Preservation and Open Space District 1
- American Canyon, City of 1
- Santa Clara Valley Open Space Authority 1
- Soledad, City of 1
- Napa, County of 1
- Sacramento, City of 1
- …
MNG_AG_TYP 6
DES_TP 1
- Local Other or Unknown · 96 ✖
ACCESS_TYP 1
- No Public Access · 96 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1339 | 1339 | 1338 | {"type": "Polygon", "coordinates": [[[-116.73714, 32.58342], [-116.74114, 32.58362], [-116.74116, 32.57636], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.5691], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76217, 32.58046], [-116.76212, 32.58426], [-116.75374, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74513, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58732], [-116.7329, 32.5834], [-116.73714, 32.58342]]]} | No Public Access 3 | 7398 | Marron Valley Mitigation Bank | 21885 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2644.0 | Marron Valley Mitigation Bank | 0 | Local Other or Unknown 14 | 4 | |
4532 | 4532 | 4531 | {"type": "MultiPolygon", "coordinates": [[[[-117.21241, 32.80723], [-117.21239, 32.80731], [-117.21232, 32.80734], [-117.2111, 32.80742], [-117.21111, 32.80697], [-117.21157, 32.80696], [-117.21172, 32.80698], [-117.21219, 32.80709], [-117.21237, 32.80716], [-117.21241, 32.80723]]], [[[-117.21219, 32.80689], [-117.21219, 32.80695], [-117.21195, 32.80689], [-117.21219, 32.80689], [-117.21219, 32.80689]]]]} | No Public Access 3 | 18410 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.217 | 0 | Local Other or Unknown 14 | 4 | ||
4535 | 4535 | 4534 | {"type": "Polygon", "coordinates": [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]} | No Public Access 3 | 19896 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.273 | 0 | Local Other or Unknown 14 | 4 | ||
4536 | 4536 | 4535 | {"type": "Polygon", "coordinates": [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]]} | No Public Access 3 | 19905 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.196 | 0 | Local Other or Unknown 14 | 4 | ||
4537 | 4537 | 4536 | {"type": "Polygon", "coordinates": [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76969], [-117.10461, 32.76969]]]} | No Public Access 3 | 19907 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.035 | 0 | Local Other or Unknown 14 | 4 | ||
4785 | 4785 | 4784 | {"type": "Polygon", "coordinates": [[[-117.23137, 32.88833], [-117.22878, 32.89057], [-117.22879, 32.89385], [-117.22675, 32.89645], [-117.22675, 32.89619], [-117.22726, 32.89551], [-117.22708, 32.8954], [-117.22721, 32.89514], [-117.22753, 32.89435], [-117.22772, 32.89381], [-117.22795, 32.89294], [-117.22797, 32.89271], [-117.22797, 32.89157], [-117.22795, 32.89107], [-117.22798, 32.89083], [-117.22816, 32.89009], [-117.22833, 32.89009], [-117.22872, 32.88902], [-117.22917, 32.88808], [-117.22989, 32.8883], [-117.23011, 32.88786], [-117.23073, 32.88808], [-117.23137, 32.88833]]]} | No Public Access 3 | 47655 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 20.801 | 0 | Local Other or Unknown 14 | 4 | ||
4786 | 4786 | 4785 | {"type": "MultiPolygon", "coordinates": [[[[-116.87263, 32.64332], [-116.87061, 32.64522], [-116.87029, 32.64505], [-116.87093, 32.64366], [-116.87252, 32.64297], [-116.87263, 32.64332]]], [[[-116.87285, 32.64414], [-116.87285, 32.64414], [-116.87206, 32.64428], [-116.87271, 32.64366], [-116.87285, 32.64414]]]]} | No Public Access 3 | 47661 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.302 | 0 | Local Other or Unknown 14 | 4 | ||
9993 | 9993 | 9992 | {"type": "Polygon", "coordinates": [[[-117.00987, 32.55768], [-117.00557, 32.5576], [-117.00555, 32.56025], [-117.00128, 32.56018], [-117.00126, 32.55751], [-116.99834, 32.55745], [-116.99769, 32.55743], [-116.99699, 32.55743], [-116.99699, 32.55385], [-116.99614, 32.55382], [-116.99588, 32.55353], [-116.99536, 32.55264], [-116.99513, 32.55248], [-116.99481, 32.55243], [-116.99449, 32.55257], [-116.99356, 32.55323], [-116.993, 32.55322], [-116.99287, 32.55313], [-116.99284, 32.55268], [-116.99337, 32.55212], [-116.99346, 32.55187], [-116.99337, 32.55162], [-116.99317, 32.55135], [-116.9927, 32.55115], [-116.99269, 32.55005], [-116.99912, 32.55022], [-116.99914, 32.55328], [-116.99985, 32.5533], [-116.99986, 32.55391], [-117.00986, 32.55413], [-117.00985, 32.55619], [-117.00987, 32.55768]]]} | No Public Access 3 | 47971 | Otay Mitigation Site | 32285 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 200.028 | Otay Mitigation Site | 0 | Local Other or Unknown 14 | 4 | |
4574 | 4574 | 4573 | {"type": "Polygon", "coordinates": [[[-120.41847, 34.87892], [-120.41847, 34.87914], [-120.41845, 34.87917], [-120.41794, 34.87923], [-120.41794, 34.87885], [-120.418, 34.87884], [-120.41807, 34.8788], [-120.41847, 34.87892]]]} | No Public Access 3 | 35227 | Unnamed site - Santa Barbara, County of | 28691 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.465 | 0 | Local Other or Unknown 14 | 4 | ||
15478 | 15478 | 15477 | {"type": "Polygon", "coordinates": [[[-121.79324, 36.88092], [-121.79324, 36.88092], [-121.78808, 36.88474], [-121.78767, 36.88399], [-121.79284, 36.88016], [-121.79324, 36.88092]]]} | No Public Access 3 | 36631 | Unnamed site - Watsonville, City of | 28700 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 13.356 | 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 | ||
4640 | 4640 | 4639 | {"type": "Polygon", "coordinates": [[[-121.76878, 36.88577], [-121.76854, 36.88632], [-121.76869, 36.88648], [-121.76648, 36.88819], [-121.76471, 36.88798], [-121.7647, 36.88784], [-121.76557, 36.88755], [-121.76873, 36.88508], [-121.76878, 36.88577]]]} | No Public Access 3 | 36489 | Unnamed site - Monterey, County of | 28701 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 10.195 | 0 | Local Other or Unknown 14 | 4 | ||
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 | |
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 | |
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]);