units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,921 rows where COUNTY = 6 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
MNG_AGENCY >30
- Los Angeles, City of 491
- Mountains Recreation and Conservation Authority 336
- 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 34
- Santa Monica, City of 31
- Pomona, City of 30
- Palmdale, City of 30
- Mountains Restoration Trust 30
- 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 24
- 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,649
- Local Recreation Area 504
- 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
- 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,983
- Open Space District 336
- County Agency 175
- 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,326
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
660 | 660 | 659 | {"type": "MultiPolygon", "coordinates": [[[[-118.47757, 34.17694], [-118.47653, 34.17753], [-118.47638, 34.17727], [-118.47491, 34.17726], [-118.47488, 34.17866], [-118.47404, 34.17875], [-118.4726, 34.17833], [-118.47255, 34.17833], [-118.47049, 34.17932], [-118.46982, 34.17835], [-118.46942, 34.17769], [-118.46908, 34.17704], [-118.46886, 34.17653], [-118.46876, 34.17623], [-118.46858, 34.17554], [-118.46851, 34.17511], [-118.46844, 34.1746], [-118.46841, 34.17384], [-118.46841, 34.17257], [-118.46879, 34.17257], [-118.46895, 34.17247], [-118.47109, 34.17243], [-118.4711, 34.1725], [-118.47273, 34.1725], [-118.47327, 34.17247], [-118.47381, 34.17242], [-118.47429, 34.17235], [-118.4747, 34.17228], [-118.4754, 34.17212], [-118.47554, 34.17212], [-118.47694, 34.17548], [-118.47723, 34.17608], [-118.47722, 34.17631], [-118.4774, 34.17666], [-118.47757, 34.17694]]], [[[-118.47739, 34.17084], [-118.4769, 34.17105], [-118.47556, 34.17153], [-118.47499, 34.17158], [-118.47358, 34.17183], [-118.47208, 34.17194], [-118.46878, 34.17196], [-118.46878, 34.17102], [-118.46911, 34.17021], [-118.46977, 34.16964], [-118.47092, 34.16895], [-118.4726, 34.16817], [-118.47276, 34.16826], [-118.47323, 34.1681], [-118.47413, 34.16763], [-118.47438, 34.16819], [-118.47571, 34.16965], [-118.47622, 34.1701], [-118.47659, 34.17037], [-118.47706, 34.17067], [-118.47739, 34.17084]]], [[[-118.48363, 34.18069], [-118.48361, 34.18069], [-118.4834, 34.1804], [-118.48315, 34.18014], [-118.47855, 34.17705], [-118.47836, 34.1769], [-118.47815, 34.17669], [-118.47799, 34.17649], [-118.47783, 34.1762], [-118.47595, 34.17177], [-118.47741, 34.17146], [-118.478, 34.17119], [-118.48123, 34.17251], [-118.48092, 34.17304], [-118.48094, 34.17432], [-118.48076, 34.17439], [-118.48075, 34.1744], [-118.48207, 34.1758], [-118.48338, 34.17578], [-118.48342, 34.17774], [-118.48359, 34.17867], [-118.48363, 34.18069]]], [[[-118.50099, 34.18172], [-118.50099, 34.18456], [-118.50095, 34.1855], [-118.50094, 34.18587], [-118.49857, 34.18587], [-118.49856, 34.18608], [-118.49253, 34.18608], [-118.49254, 34.18527], [-118.49305, 34.18528], [-118.49331, 34.18519], [-118.49344, 34.18507], [-118.49351, 34.18486], [-118.49351, 34.18461], [-118.49346, 34.18436], [-118.49679, 34.18321], [-118.49715, 34.18293], [-118.49763, 34.18229], [-118.49761, 34.18051], [-118.49826, 34.18052], [-118.49842, 34.18053], [-118.49856, 34.18058], [-118.49941, 34.18129], [-118.49962, 34.18137], [-118.50004, 34.18139], [-118.50016, 34.18144], [-118.50064, 34.18171], [-118.50079, 34.18175], [-118.50093, 34.18174], [-118.50099, 34.18172]]]]} | Open Access 1 | 3261 | Sepulveda Basin Wildlife Reserve | 13591 | 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 | http://sepulvedabasinwildlife.org/ | Los Angeles 6 | 327.332 | Sepulveda Basin Wildlife Reserve | 0 | Conservation Area 13 | 2 |
1162 | 1162 | 1161 | {"type": "Polygon", "coordinates": [[[-117.68625, 34.15373], [-117.68578, 34.15427], [-117.68557, 34.15448], [-117.68493, 34.15499], [-117.6846, 34.15528], [-117.6843, 34.15564], [-117.68412, 34.15595], [-117.684, 34.15622], [-117.6839, 34.1566], [-117.68388, 34.15675], [-117.68382, 34.15766], [-117.68376, 34.15794], [-117.68368, 34.15812], [-117.68357, 34.15832], [-117.68344, 34.15847], [-117.68287, 34.15907], [-117.68274, 34.15924], [-117.68258, 34.15954], [-117.68245, 34.15995], [-117.68242, 34.16023], [-117.68245, 34.16069], [-117.68245, 34.16105], [-117.68208, 34.16106], [-117.68184, 34.16148], [-117.68206, 34.16189], [-117.68218, 34.16224], [-117.68202, 34.16262], [-117.6817, 34.16279], [-117.68157, 34.16302], [-117.68115, 34.16313], [-117.68121, 34.16295], [-117.68133, 34.1628], [-117.68117, 34.1626], [-117.68101, 34.16231], [-117.68074, 34.16231], [-117.68054, 34.16287], [-117.6798, 34.16408], [-117.6797, 34.16453], [-117.67949, 34.16491], [-117.67921, 34.16514], [-117.67876, 34.1658], [-117.67853, 34.1662], [-117.67814, 34.16752], [-117.67796, 34.16804], [-117.67739, 34.17048], [-117.67647, 34.17048], [-117.67648, 34.17002], [-117.67851, 34.16199], [-117.68171, 34.15583], [-117.68322, 34.15063], [-117.68362, 34.15063], [-117.68354, 34.15367], [-117.68625, 34.15373]]]} | No Public Access 3 | 6785 | San Antonio Channel & Dam | 24827 | 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 | 102.402 | San Antonio Channel & Dam | 0 | Resource Management Area 82 | 3 | |
1526 | 1526 | 1525 | {"type": "Polygon", "coordinates": [[[-118.50099, 34.17906], [-118.49854, 34.17803], [-118.49442, 34.17649], [-118.48937, 34.17455], [-118.47912, 34.17066], [-118.48, 34.17022], [-118.48079, 34.16993], [-118.48155, 34.16969], [-118.48232, 34.16949], [-118.48336, 34.16927], [-118.48464, 34.16886], [-118.48587, 34.16861], [-118.48659, 34.16843], [-118.48732, 34.16823], [-118.48784, 34.16822], [-118.48841, 34.16791], [-118.48987, 34.16748], [-118.49042, 34.16735], [-118.49087, 34.16727], [-118.49143, 34.16721], [-118.492, 34.1672], [-118.49256, 34.16722], [-118.49313, 34.16728], [-118.49369, 34.16739], [-118.49412, 34.1675], [-118.49465, 34.16768], [-118.49526, 34.16794], [-118.49583, 34.16825], [-118.49636, 34.16861], [-118.49669, 34.16888], [-118.49692, 34.16909], [-118.49738, 34.16963], [-118.49767, 34.1701], [-118.49815, 34.17079], [-118.49842, 34.17144], [-118.49856, 34.17168], [-118.49871, 34.17186], [-118.49887, 34.17201], [-118.49905, 34.17213], [-118.49927, 34.17223], [-118.49953, 34.17249], [-118.50001, 34.17249], [-118.50089, 34.17236], [-118.50092, 34.17238], [-118.50093, 34.17592], [-118.50098, 34.17593], [-118.50099, 34.17906]]]} | Restricted Access 2 | 12883 | Balboa Golf Course & Encino Golf Course | 33032 | 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 | 320.852 | Balboa GC & Encino GC | 0 | Recreation Management Area 49 | 4 | |
4884 | 4884 | 4883 | {"type": "MultiPolygon", "coordinates": [[[[-118.08173, 34.04994], [-118.0805, 34.04993], [-118.07751, 34.04834], [-118.07751, 34.04837], [-118.08049, 34.04996], [-118.08013, 34.04996], [-118.08012, 34.04997], [-118.08074, 34.05031], [-118.08073, 34.05157], [-118.07969, 34.05156], [-118.07753, 34.05168], [-118.07752, 34.05165], [-118.07733, 34.05166], [-118.07732, 34.05169], [-118.07317, 34.05171], [-118.07316, 34.05168], [-118.07307, 34.05168], [-118.07312, 34.04139], [-118.07467, 34.04125], [-118.07526, 34.04117], [-118.07525, 34.04275], [-118.07528, 34.04276], [-118.07529, 34.04116], [-118.07647, 34.04099], [-118.07643, 34.0414], [-118.07572, 34.04156], [-118.07534, 34.04238], [-118.07559, 34.04268], [-118.0763, 34.04268], [-118.07649, 34.04247], [-118.07747, 34.04247], [-118.07748, 34.04209], [-118.07802, 34.04182], [-118.07839, 34.04182], [-118.0791, 34.04225], [-118.07943, 34.04272], [-118.07964, 34.04272], [-118.07965, 34.04362], [-118.08009, 34.04362], [-118.0801, 34.04407], [-118.08087, 34.04407], [-118.08088, 34.04451], [-118.08114, 34.04452], [-118.08114, 34.04512], [-118.0817, 34.04512], [-118.08173, 34.04994]], [[-118.07717, 34.04812], [-118.07728, 34.04818], [-118.0773, 34.04818], [-118.07729, 34.04815], [-118.07602, 34.04748], [-118.07556, 34.04718], [-118.07541, 34.04706], [-118.07513, 34.04677], [-118.07499, 34.04658], [-118.07485, 34.04634], [-118.07471, 34.04603], [-118.07464, 34.04577], [-118.07528, 34.04458], [-118.07528, 34.04449], [-118.07525, 34.04449], [-118.07524, 34.04457], [-118.07434, 34.04628], [-118.07421, 34.04779], [-118.07318, 34.04991], [-118.07318, 34.04997], [-118.0732, 34.04997], [-118.07425, 34.0478], [-118.07437, 34.04628], [-118.07462, 34.04582], [-118.07468, 34.04603], [-118.07475, 34.04621], [-118.0749, 34.0465], [-118.07504, 34.0467], [-118.07538, 34.04707], [-118.07565, 34.04729], [-118.07595, 34.04747], [-118.07717, 34.04812]]], [[[-118.08027, 34.05174], [-118.08023, 34.05182], [-118.07834, 34.05181], [-118.07833, 34.05424], [-118.07813, 34.05438], [-118.07758, 34.05533], [-118.07756, 34.05534], [-118.07753, 34.05542], [-118.07671, 34.05543], [-118.07671, 34.05634], [-118.07648, 34.05719], [-118.0757, 34.05687], [-118.07535, 34.05699], [-118.07486, 34.05751], [-118.07467, 34.05792], [-118.07424, 34.05812], [-118.07362, 34.05794], [-118.07302, 34.05794], [-118.07301, 34.05872], [-118.0719, 34.05755], [-118.07222, 34.05543], [-118.073, 34.05542], [-118.07299, 34.0519], [-118.07318, 34.0519], [-118.07318, 34.05187], [-118.07743, 34.05185], [-118.07965, 34.05174], [-118.08027, 34.05174]]]]} | Restricted Access 2 | 6566 | Whittier Narrows Golf Course | 33010 | 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 | 268.099 | Whittier Narrows GC | 0 | Recreation Management Area 49 | 4 | |
5413 | 5413 | 5412 | {"type": "MultiPolygon", "coordinates": [[[[-118.22858, 33.88759], [-118.22857, 33.88759], [-118.22835, 33.88727], [-118.22846, 33.88739], [-118.22858, 33.88759]]], [[[-118.24226, 33.90419], [-118.24209, 33.90423], [-118.24193, 33.90397], [-118.24191, 33.9036], [-118.24216, 33.90405], [-118.24226, 33.90419]]], [[[-118.24858, 33.91176], [-118.24841, 33.91176], [-118.24735, 33.91049], [-118.24755, 33.9105], [-118.24857, 33.91171], [-118.24858, 33.91176]]]]} | Open Access 1 | 7202 | Compton Creek & Bike Path | 17571 | 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 | 0.849 | Compton Creek & Bike Path | 0 | Recreation Management Area 49 | 4 | |
6010 | 6010 | 6009 | {"type": "Polygon", "coordinates": [[[-118.50547, 34.18013], [-118.50135, 34.18014], [-118.50135, 34.17454], [-118.5013, 34.17234], [-118.50547, 34.17239], [-118.50547, 34.18013]]]} | Open Access 1 | 665 | Balboa Sports Center | 15773 | 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 | 81.108 | Balboa Sports Ctr. | 0 | Recreation Management Area 49 | 4 | |
6150 | 6150 | 6149 | {"type": "Polygon", "coordinates": [[[-117.97651, 34.11555], [-117.97637, 34.11573], [-117.97627, 34.11571], [-117.97575, 34.11619], [-117.97526, 34.11658], [-117.97501, 34.11677], [-117.97438, 34.11716], [-117.97327, 34.11691], [-117.97332, 34.11662], [-117.97332, 34.11632], [-117.97327, 34.11607], [-117.9731, 34.11575], [-117.97295, 34.11554], [-117.97288, 34.1153], [-117.97216, 34.11418], [-117.97253, 34.11436], [-117.97307, 34.11458], [-117.97392, 34.11484], [-117.9745, 34.11498], [-117.9751, 34.11509], [-117.97581, 34.11516], [-117.97581, 34.11527], [-117.97631, 34.11528], [-117.97649, 34.11546], [-117.97651, 34.11555]]]} | Open Access 1 | 48340 | Kare Park | 32904 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 7025 | Kare Youth League 808 | Non Profit 6 | Non Profit - Other 20 | https://kyl.org/KarePark/ | Los Angeles 6 | 14.769 | Kare Park | 2017 | None 496 | |
6412 | 6412 | 6411 | {"type": "MultiPolygon", "coordinates": [[[[-118.49126, 34.18526], [-118.49096, 34.18527], [-118.48979, 34.1852], [-118.48979, 34.18557], [-118.48918, 34.18558], [-118.48917, 34.18609], [-118.48587, 34.18609], [-118.48586, 34.18521], [-118.48387, 34.1852], [-118.48387, 34.18494], [-118.48458, 34.18493], [-118.48647, 34.18422], [-118.48811, 34.18393], [-118.48813, 34.18462], [-118.49122, 34.18458], [-118.49126, 34.18526]]], [[[-118.50099, 34.18172], [-118.50093, 34.18174], [-118.50079, 34.18175], [-118.50064, 34.18171], [-118.50016, 34.18144], [-118.50004, 34.18139], [-118.49962, 34.18137], [-118.49941, 34.18129], [-118.49856, 34.18058], [-118.49842, 34.18053], [-118.49826, 34.18052], [-118.49761, 34.18051], [-118.49763, 34.18229], [-118.49715, 34.18294], [-118.49679, 34.18321], [-118.49347, 34.18436], [-118.49351, 34.18461], [-118.49351, 34.18487], [-118.49344, 34.18507], [-118.49331, 34.18519], [-118.49305, 34.18528], [-118.49246, 34.18527], [-118.49251, 34.1807], [-118.49249, 34.18068], [-118.4925, 34.17711], [-118.49395, 34.17767], [-118.49604, 34.17826], [-118.50099, 34.18021], [-118.50099, 34.18172]]]]} | Open Access 1 | 3334 | Lake Balboa Park | 20875 | 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 | 110.991 | Lake Balboa Park | 0 | Recreation Management Area 49 | 4 | |
7058 | 7058 | 7057 | {"type": "Polygon", "coordinates": [[[-118.06181, 34.02017], [-118.06089, 34.02054], [-118.06107, 34.02082], [-118.06117, 34.02082], [-118.06121, 34.02141], [-118.05671, 34.02154], [-118.0577, 34.02122], [-118.05703, 34.01992], [-118.05747, 34.01907], [-118.05897, 34.01802], [-118.06078, 34.01739], [-118.06033, 34.01796], [-118.05961, 34.01857], [-118.0607, 34.02026], [-118.06181, 34.02017]]]} | Restricted Access 2 | 6569 | Pico Rivera Golf Course | 33017 | 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 | 26.31 | Pico Rivera GC | 0 | Recreation Management Area 49 | 4 | |
7280 | 7280 | 7279 | {"type": "MultiPolygon", "coordinates": [[[[-118.07223, 34.05905], [-118.07151, 34.05982], [-118.07104, 34.06086], [-118.07094, 34.06104], [-118.06981, 34.06232], [-118.06997, 34.06256], [-118.06964, 34.06256], [-118.07093, 34.06059], [-118.07092, 34.06052], [-118.06959, 34.06256], [-118.06763, 34.06256], [-118.06906, 34.06137], [-118.06934, 34.06104], [-118.06956, 34.06068], [-118.06965, 34.06049], [-118.06976, 34.06012], [-118.07026, 34.05725], [-118.07195, 34.05724], [-118.0719, 34.05755], [-118.07187, 34.05754], [-118.07164, 34.05893], [-118.07223, 34.05893], [-118.07223, 34.05905]]], [[[-118.06908, 34.06284], [-118.06876, 34.06313], [-118.06883, 34.06321], [-118.06867, 34.06332], [-118.06859, 34.06326], [-118.0681, 34.06363], [-118.06805, 34.06415], [-118.06797, 34.06422], [-118.06775, 34.06427], [-118.06774, 34.06391], [-118.06773, 34.0639], [-118.06717, 34.06433], [-118.06717, 34.06434], [-118.06721, 34.06437], [-118.06718, 34.06438], [-118.06632, 34.06357], [-118.06714, 34.06297], [-118.06715, 34.06292], [-118.06725, 34.06284], [-118.06908, 34.06284]]], [[[-118.06672, 34.06464], [-118.06662, 34.06466], [-118.06572, 34.06519], [-118.0656, 34.06508], [-118.06526, 34.06526], [-118.0646, 34.06571], [-118.06381, 34.06571], [-118.06493, 34.06491], [-118.06518, 34.06471], [-118.06559, 34.06431], [-118.06572, 34.06421], [-118.06605, 34.064], [-118.06672, 34.06464]]], [[[-118.06408, 34.06584], [-118.06348, 34.06628], [-118.06328, 34.06608], [-118.06362, 34.06584], [-118.06408, 34.06584]]]]} | Open Access 1 | 6565 | Rio Hondo | 24379 | 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 | 33.327 | Rio Hondo | 0 | None 601 | ||
7289 | 7289 | 7288 | {"type": "MultiPolygon", "coordinates": [[[[-118.06004, 34.01551], [-118.05873, 34.0164], [-118.05805, 34.01692], [-118.0576, 34.0173], [-118.05827, 34.01767], [-118.05897, 34.01802], [-118.05747, 34.01907], [-118.05703, 34.01992], [-118.05593, 34.02051], [-118.0549, 34.02084], [-118.05395, 34.02158], [-118.05387, 34.02199], [-118.05295, 34.02135], [-118.05295, 34.02132], [-118.05137, 34.02026], [-118.05138, 34.02024], [-118.05053, 34.01967], [-118.0522, 34.01846], [-118.05317, 34.01829], [-118.05338, 34.01842], [-118.054, 34.01837], [-118.05434, 34.01784], [-118.0559, 34.01773], [-118.0575, 34.01641], [-118.05641, 34.01534], [-118.05752, 34.01455], [-118.05859, 34.01559], [-118.05927, 34.01514], [-118.06004, 34.01551]]], [[[-118.07861, 34.01711], [-118.07843, 34.01748], [-118.07832, 34.01765], [-118.07816, 34.01788], [-118.07791, 34.01819], [-118.07766, 34.01848], [-118.07744, 34.01869], [-118.0769, 34.01914], [-118.07637, 34.01948], [-118.07315, 34.02126], [-118.07286, 34.02143], [-118.07234, 34.02179], [-118.07178, 34.02229], [-118.0715, 34.02259], [-118.07118, 34.023], [-118.07101, 34.02324], [-118.06794, 34.02829], [-118.06785, 34.02831], [-118.06734, 34.02812], [-118.06696, 34.02802], [-118.06645, 34.02795], [-118.05777, 34.02462], [-118.05458, 34.02336], [-118.05406, 34.02414], [-118.0539, 34.02251], [-118.05402, 34.02209], [-118.05438, 34.02235], [-118.05503, 34.02278], [-118.05571, 34.02199], [-118.05622, 34.0217], [-118.05671, 34.02154], [-118.0612, 34.02141], [-118.06117, 34.02082], [-118.06902, 34.02046], [-118.06905, 34.02101], [-118.07253, 34.02084], [-118.07409, 34.02003], [-118.07431, 34.02006], [-118.07583, 34.01928], [-118.07629, 34.01901], [-118.07663, 34.01877], [-118.07688, 34.01858], [-118.07712, 34.01838], [-118.07748, 34.01803], [-118.0779, 34.01751], [-118.07825, 34.01698], [-118.07858, 34.01705], [-118.07861, 34.01711]]], [[[-118.061, 34.01708], [-118.06078, 34.01739], [-118.06049, 34.01666], [-118.06078, 34.01689], [-118.061, 34.01708]]], [[[-118.08765, 34.02294], [-118.08759, 34.02301], [-118.08732, 34.02322], [-118.08691, 34.02347], [-118.086, 34.02381], [-118.08518, 34.02419], [-118.08318, 34.02537], [-118.08275, 34.02555], [-118.08236, 34.02565], [-118.08211, 34.02568], [-118.08176, 34.02568], [-118.08063, 34.02561], [-118.07954, 34.02604], [-118.07683, 34.02666], [-118.0758, 34.02683], [-118.07506, 34.02709], [-118.07491, 34.02727], [-118.07484, 34.02752], [-118.07463, 34.02807], [-118.07407, 34.02903], [-118.07397, 34.02927], [-118.07388, 34.02937], [-118.07209, 34.02923], [-118.07201, 34.02963], [-118.07129, 34.02955], [-118.07151, 34.02914], [-118.07279, 34.02772], [-118.07565, 34.0256], [-118.07771, 34.02455], [-118.07809, 34.02411], [-118.07806, 34.02411], [-118.07769, 34.02454], [-118.07562, 34.02558], [-118.07277, 34.0277], [-118.07148, 34.02913], [-118.07125, 34.02954], [-118.07048, 34.02946], [-118.06906, 34.02892], [-118.06911, 34.02881], [-118.06831, 34.0285], [-118.06828, 34.02844], [-118.07138, 34.02337], [-118.07188, 34.02273], [-118.07241, 34.02222], [-118.07283, 34.02189], [-118.07328, 34.02159], [-118.07651, 34.0198], [-118.0769, 34.01956], [-118.07735, 34.01924], [-118.07785, 34.0188], [-118.07822, 34.0184], [-118.07842, 34.01815], [-118.07872, 34.01772], [-118.07888, 34.01744], [-118.07908, 34.01704], [-118.08031, 34.01676], [-118.07951, 34.017], [-118.07938, 34.01705], [-118.07918, 34.01749], [-118.07892, 34.01793], [-118.07893, 34.01794], [-118.07958, 34.01783], [-118.08009, 34.01779], [-118.08078, 34.0178], [-118.08127, 34.01786], [-118.08179, 34.01797], [-118.08204, 34.01804], [-118.08267, 34.01828], [-118.08318, 34.01854], [-118.08365, 34.01886], [-118.08493, 34.01795], [-118.08599, 34.019], [-118.08475, 34.01988], [-118.08504, 34.0202], [-118.08531, 34.02055], [-118.08551, 34.02088], [-118.08549, 34.0209], [-118.08553, 34.02092], [-118.08567, 34.02118], [-118.08582, 34.02151], [-118.08594, 34.02187], [-118.08602, 34.02218], [-118.08572, 34.02214], [-118.0858, 34.02267], [-118.08609, 34.02274], [-118.08612, 34.02311], [-118.08728, 34.02311], [-118.08744, 34.02298], [-118.08754, 34.02288], [-118.08765, 34.02294]]], [[[-118.07973, 34.01611], [-118.07954, 34.01674], [-118.07924, 34.01681], [-118.07921, 34.0168], [-118.0792, 34.01676], [-118.07931, 34.01638], [-118.07934, 34.01637], [-118.07936, 34.01633], [-118.07933, 34.01631], [-118.07936, 34.01624], [-118.07946, 34.01618], [-118.07973, 34.01611]]], [[[-118.08786, 34.02308], [-118.08756, 34.02334], [-118.08718, 34.02359], [-118.08683, 34.02375], [-118.08612, 34.02401], [-118.08548, 34.02438], [-118.08553, 34.02444], [-118.08495, 34.02492], [-118.0853, 34.02531], [-118.08535, 34.02563], [-118.08466, 34.02594], [-118.08411, 34.02502], [-118.08516, 34.0244], [-118.08556, 34.02419], [-118.08598, 34.02401], [-118.08684, 34.02369], [-118.08711, 34.02357], [-118.08748, 34.02334], [-118.08781, 34.02305], [-118.08786, 34.02308]]]]} | Restricted Access 2 | 6568 | Whittier Narrows Dam | 27479 | 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 | 568.969 | Whittier Narrows Dam | 0 | Resource Management Area 82 | 3 | |
7293 | 7293 | 7292 | {"type": "MultiPolygon", "coordinates": [[[[-118.01784, 34.03317], [-118.01637, 34.03369], [-118.01597, 34.03343], [-118.01578, 34.03332], [-118.01537, 34.03313], [-118.01494, 34.03296], [-118.01452, 34.03284], [-118.01405, 34.03273], [-118.0137, 34.03268], [-118.01324, 34.03264], [-118.01251, 34.03265], [-118.00974, 34.03282], [-118.00678, 34.03311], [-118.00624, 34.03311], [-118.00493, 34.03305], [-118.00415, 34.03306], [-118.0047, 34.03204], [-118.00526, 34.03207], [-118.00593, 34.03205], [-118.01346, 34.0313], [-118.01347, 34.03152], [-118.014, 34.03159], [-118.01473, 34.03174], [-118.01539, 34.03193], [-118.01594, 34.03213], [-118.01646, 34.03237], [-118.01676, 34.03253], [-118.01784, 34.03317]]], [[[-118.02359, 34.03666], [-118.0233, 34.03661], [-118.02246, 34.03717], [-118.01999, 34.03569], [-118.01964, 34.03556], [-118.019, 34.03519], [-118.01847, 34.03488], [-118.01846, 34.03483], [-118.01676, 34.03384], [-118.01816, 34.03334], [-118.02047, 34.03471], [-118.02066, 34.03491], [-118.02335, 34.0365], [-118.02359, 34.03666]]]]} | Open Access 1 | 6572 | San Jose Creek | 24914 | 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 | http://www.usace.army.mil/ | Los Angeles 6 | 55.286 | San Jose Creek | None 603 | ||
7294 | 7294 | 7293 | {"type": "Polygon", "coordinates": [[[-118.07409, 34.02003], [-118.07253, 34.02084], [-118.06905, 34.02101], [-118.06903, 34.02046], [-118.06945, 34.01932], [-118.06976, 34.01935], [-118.0698, 34.01927], [-118.07064, 34.01943], [-118.07024, 34.02012], [-118.0702, 34.02012], [-118.07003, 34.02041], [-118.07017, 34.02048], [-118.0708, 34.01943], [-118.07409, 34.02003]]]} | Open Access 1 | 6573 | Streamland Park | 32518 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 14.075 | Streamland Park | 0 | Local Park 2 | 4 | |
7478 | 7478 | 7477 | {"type": "Polygon", "coordinates": [[[-117.95999, 34.10704], [-117.9599, 34.11834], [-117.95943, 34.11891], [-117.95858, 34.11969], [-117.95755, 34.12058], [-117.95639, 34.12138], [-117.95542, 34.12235], [-117.95497, 34.12298], [-117.95388, 34.12367], [-117.95313, 34.12443], [-117.95266, 34.1252], [-117.9525, 34.12614], [-117.95196, 34.12642], [-117.95133, 34.12694], [-117.95091, 34.12769], [-117.95066, 34.12822], [-117.95053, 34.12906], [-117.95015, 34.13], [-117.94872, 34.13114], [-117.94844, 34.13138], [-117.94805, 34.1319], [-117.94765, 34.13216], [-117.94567, 34.13364], [-117.94402, 34.13482], [-117.94341, 34.13538], [-117.94279, 34.13606], [-117.94249, 34.13642], [-117.93973, 34.13462], [-117.94295, 34.13132], [-117.94585, 34.12985], [-117.9469, 34.12888], [-117.94687, 34.12161], [-117.94251, 34.12163], [-117.94262, 34.118], [-117.93818, 34.11798], [-117.93817, 34.11927], [-117.93609, 34.11925], [-117.93609, 34.11897], [-117.93615, 34.11857], [-117.93688, 34.11521], [-117.93704, 34.11478], [-117.93726, 34.11441], [-117.94023, 34.11089], [-117.9404, 34.11063], [-117.94096, 34.11063], [-117.94293, 34.10827], [-117.94297, 34.1072], [-117.95999, 34.10704]]]} | Open Access 1 | 6999 | Santa Fe Dam Recreation Area | 32698 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/santa-fe-dam-recreational-area/ | Los Angeles 6 | 912.515 | Santa Fe Dam Rec. Area | 0 | Local Recreation Area 3 | 4 |
7560 | 7560 | 7559 | {"type": "MultiPolygon", "coordinates": [[[[-117.94229, 34.13664], [-117.9421, 34.13679], [-117.94137, 34.1372], [-117.94117, 34.1373], [-117.94031, 34.13764], [-117.93932, 34.138], [-117.9386, 34.1383], [-117.93794, 34.13857], [-117.93747, 34.13882], [-117.93682, 34.13925], [-117.93592, 34.14006], [-117.93508, 34.1411], [-117.9344, 34.14184], [-117.93412, 34.14179], [-117.93422, 34.14139], [-117.93331, 34.14123], [-117.93347, 34.14106], [-117.93378, 34.14105], [-117.93408, 34.14099], [-117.93435, 34.14088], [-117.93459, 34.14074], [-117.93754, 34.13815], [-117.93754, 34.13814], [-117.93733, 34.13814], [-117.93445, 34.14066], [-117.93433, 34.14074], [-117.93407, 34.14085], [-117.93378, 34.14091], [-117.93358, 34.14092], [-117.93953, 34.13483], [-117.94229, 34.13664]]], [[[-117.93852, 34.14177], [-117.93791, 34.14249], [-117.93468, 34.14189], [-117.93496, 34.1416], [-117.93526, 34.14116], [-117.93852, 34.14177]]], [[[-117.93154, 34.14925], [-117.93138, 34.14956], [-117.93031, 34.15081], [-117.9302, 34.15095], [-117.9302, 34.15097], [-117.9297, 34.15096], [-117.92984, 34.15081], [-117.93154, 34.14925]]], [[[-117.93088, 34.14369], [-117.92715, 34.14751], [-117.92645, 34.15071], [-117.9232, 34.15069], [-117.91761, 34.15518], [-117.9208, 34.15208], [-117.92326, 34.14947], [-117.92813, 34.14533], [-117.93088, 34.14369]]], [[[-117.92495, 34.15451], [-117.92447, 34.15451], [-117.92446, 34.15494], [-117.92389, 34.15495], [-117.92388, 34.15529], [-117.92338, 34.1553], [-117.92337, 34.15562], [-117.92288, 34.15562], [-117.92287, 34.15569], [-117.92271, 34.1557], [-117.92274, 34.15444], [-117.92495, 34.15443], [-117.92495, 34.15451]]], [[[-117.92224, 34.15624], [-117.92053, 34.15798], [-117.92053, 34.15798], [-117.92058, 34.15624], [-117.92224, 34.15624]]], [[[-117.91608, 34.15641], [-117.9142, 34.15792], [-117.90997, 34.16133], [-117.91028, 34.15932], [-117.91033, 34.15929], [-117.91141, 34.15894], [-117.91249, 34.15851], [-117.91372, 34.15792], [-117.91397, 34.15779], [-117.91492, 34.15723], [-117.9156, 34.15678], [-117.91608, 34.15641]]]]} | Open Access 1 | 7258 | Lario Staging Area | 28955 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Lario_Staging_Area | Los Angeles 6 | 103.71 | Lario Staging Area | 0 | Recreation Management Area 49 | 4 |
8114 | 8114 | 8113 | {"type": "MultiPolygon", "coordinates": [[[[-118.49444, 34.16485], [-118.49256, 34.16484], [-118.49252, 34.16479], [-118.49252, 34.16402], [-118.49444, 34.16402], [-118.49444, 34.16485]]], [[[-118.49868, 34.16866], [-118.49868, 34.16878], [-118.49696, 34.16775], [-118.49431, 34.16604], [-118.49381, 34.16578], [-118.4935, 34.16564], [-118.49295, 34.16543], [-118.49252, 34.1653], [-118.49253, 34.16504], [-118.49257, 34.16501], [-118.49601, 34.16502], [-118.49602, 34.16639], [-118.49867, 34.16641], [-118.49868, 34.16866]]]]} | Open Access 1 | 12239 | Sepulveda Garden Center | 25304 | 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 | 24.1 | Sepulveda Garden Ctr. | None 677 | |||
8199 | 8199 | 8198 | {"type": "MultiPolygon", "coordinates": [[[[-118.41192, 34.30466], [-118.41068, 34.30557], [-118.40898, 34.30398], [-118.40892, 34.30416], [-118.41053, 34.30568], [-118.40755, 34.30785], [-118.40753, 34.3079], [-118.40684, 34.30791], [-118.40702, 34.30699], [-118.40687, 34.30638], [-118.40668, 34.30644], [-118.40655, 34.30641], [-118.40685, 34.30618], [-118.40733, 34.30605], [-118.40767, 34.3052], [-118.40766, 34.30519], [-118.40753, 34.30518], [-118.40761, 34.30442], [-118.40774, 34.30388], [-118.40879, 34.30236], [-118.40906, 34.30219], [-118.40936, 34.30229], [-118.40954, 34.30196], [-118.40968, 34.30176], [-118.41031, 34.30204], [-118.41001, 34.30253], [-118.41191, 34.30338], [-118.4117, 34.30415], [-118.41192, 34.30466]]], [[[-118.41297, 34.30697], [-118.41202, 34.30909], [-118.41195, 34.30938], [-118.41166, 34.30947], [-118.4113, 34.30955], [-118.41094, 34.3096], [-118.41057, 34.30961], [-118.40749, 34.3094], [-118.40745, 34.30938], [-118.40743, 34.30868], [-118.40746, 34.30848], [-118.4076, 34.30811], [-118.40756, 34.30807], [-118.41066, 34.3058], [-118.41184, 34.30691], [-118.41185, 34.30691], [-118.41187, 34.30669], [-118.41081, 34.30569], [-118.41208, 34.30477], [-118.4123, 34.30503], [-118.4125, 34.30531], [-118.41297, 34.30697]]], [[[-118.412, 34.31043], [-118.41147, 34.31141], [-118.4113, 34.31165], [-118.41041, 34.31081], [-118.4119, 34.30973], [-118.412, 34.31043]]], [[[-118.41175, 34.30962], [-118.4109, 34.31024], [-118.40853, 34.31197], [-118.40856, 34.30964], [-118.41057, 34.30978], [-118.41115, 34.30974], [-118.41141, 34.3097], [-118.41175, 34.30962]]], [[[-118.4089, 34.31192], [-118.40887, 34.31212], [-118.40862, 34.31212], [-118.4089, 34.31192], [-118.4089, 34.31192]]]]} | No Public Access 3 | 12454 | Lopez Reservoir and Dam | 21465 | 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 | 92.431 | Lopez Reservoir and Dam | 0 | Resource Management Area 82 | 3 | |
9292 | 9292 | 9291 | {"type": "Polygon", "coordinates": [[[-118.48334, 34.18454], [-118.48156, 34.18453], [-118.48146, 34.18002], [-118.47682, 34.18003], [-118.4768, 34.18277], [-118.47502, 34.18278], [-118.47502, 34.1843], [-118.47497, 34.18431], [-118.47497, 34.18582], [-118.4748, 34.18577], [-118.47414, 34.18547], [-118.47379, 34.18465], [-118.47356, 34.18422], [-118.47335, 34.18389], [-118.47311, 34.18357], [-118.47286, 34.18327], [-118.47009, 34.17951], [-118.47255, 34.17833], [-118.47407, 34.17877], [-118.47488, 34.17867], [-118.47491, 34.17728], [-118.47636, 34.17727], [-118.47652, 34.17755], [-118.47764, 34.17695], [-118.47783, 34.17716], [-118.4782, 34.17745], [-118.47851, 34.17758], [-118.48012, 34.17868], [-118.48017, 34.17865], [-118.48195, 34.17984], [-118.48198, 34.17982], [-118.48274, 34.18035], [-118.48301, 34.18063], [-118.48315, 34.1808], [-118.48328, 34.18103], [-118.48335, 34.1812], [-118.48343, 34.18154], [-118.48344, 34.18362], [-118.48335, 34.18389], [-118.48334, 34.18454]]]} | Open Access 1 | 15480 | Woodley Avenue Park | 27729 | 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 | 119.888 | Woodley Avenue Park | 0 | Recreation Management Area 49 | 4 | |
10059 | 10059 | 10058 | {"type": "Polygon", "coordinates": [[[-118.49219, 34.16366], [-118.49127, 34.1647], [-118.49126, 34.16484], [-118.48809, 34.16482], [-118.48809, 34.16062], [-118.48813, 34.16046], [-118.48931, 34.16046], [-118.48932, 34.1631], [-118.49219, 34.16311], [-118.49219, 34.16366]]]} | Open Access 1 | 17417 | Libbit Park | 21202 | 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 | 24.58 | Libbit Park | 0 | Recreation Management Area 49 | 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]);