units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
58 rows where DES_TP = 3 and MNG_AGENCY = 27 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, COUNTY, YR_EST
LAYER 5 ✖
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 58 ✖
DES_TP 1
- Local Recreation Area · 58 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16018 | 16018 | 16017 | {"type": "MultiPolygon", "coordinates": [[[[-118.6668, 34.20731], [-118.6668, 34.20933], [-118.66277, 34.20935], [-118.66277, 34.21292], [-118.65817, 34.21293], [-118.65813, 34.21284], [-118.65899, 34.21229], [-118.65948, 34.21191], [-118.65946, 34.21178], [-118.65958, 34.2115], [-118.6598, 34.21116], [-118.65988, 34.21075], [-118.66004, 34.21049], [-118.66041, 34.20997], [-118.66039, 34.20968], [-118.66113, 34.20967], [-118.66123, 34.2095], [-118.66136, 34.20941], [-118.66145, 34.20937], [-118.6615, 34.20943], [-118.66172, 34.20944], [-118.66181, 34.20939], [-118.66192, 34.20926], [-118.66205, 34.20926], [-118.6622, 34.20904], [-118.66236, 34.20906], [-118.66242, 34.20897], [-118.66248, 34.20874], [-118.66261, 34.20877], [-118.66294, 34.20863], [-118.66277, 34.20833], [-118.66395, 34.20783], [-118.66414, 34.20773], [-118.66436, 34.20755], [-118.66464, 34.20717], [-118.66467, 34.20714], [-118.66474, 34.20714], [-118.6651, 34.20726], [-118.66537, 34.20733], [-118.66578, 34.20738], [-118.66633, 34.20738], [-118.6668, 34.20731]]], [[[-118.66376, 34.20651], [-118.66368, 34.20658], [-118.66361, 34.2068], [-118.6635, 34.20695], [-118.66336, 34.20702], [-118.66279, 34.20693], [-118.66253, 34.20714], [-118.66244, 34.20727], [-118.6624, 34.20744], [-118.66246, 34.20763], [-118.66239, 34.20772], [-118.66171, 34.20792], [-118.66129, 34.20798], [-118.66111, 34.20806], [-118.66095, 34.20825], [-118.66094, 34.20578], [-118.66321, 34.20579], [-118.6635, 34.20622], [-118.66376, 34.20651]]]]} | Open Access 1 | 3684 | Bell Canyon Open Space | 15969 | 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 | 57.419 | Bell Canyon OS | 0 | Local Recreation Area 3 | 4 | |
6864 | 6864 | 6863 | {"type": "Polygon", "coordinates": [[[-118.6568, 34.21294], [-118.65513, 34.21294], [-118.65513, 34.21258], [-118.65501, 34.21255], [-118.65501, 34.21249], [-118.65514, 34.21247], [-118.65521, 34.21216], [-118.65486, 34.21197], [-118.65513, 34.21137], [-118.65534, 34.21143], [-118.65627, 34.21214], [-118.65639, 34.21229], [-118.65654, 34.21258], [-118.6568, 34.21294]]]} | Open Access 1 | 5496 | Bell Canyon Open Space | 15969 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 4.298 | Bell Canyon OS | 0 | Local Recreation Area 3 | 4 | |
915 | 915 | 914 | {"type": "Polygon", "coordinates": [[[-118.40367, 33.76579], [-118.40172, 33.76579], [-118.40068, 33.76532], [-118.39944, 33.76548], [-118.39872, 33.76598], [-118.39851, 33.76599], [-118.39825, 33.76503], [-118.39697, 33.76527], [-118.39672, 33.76521], [-118.39662, 33.76442], [-118.39672, 33.7636], [-118.39634, 33.76316], [-118.39614, 33.76316], [-118.39577, 33.763], [-118.39552, 33.76295], [-118.39505, 33.76295], [-118.39475, 33.76286], [-118.39404, 33.76306], [-118.39345, 33.76309], [-118.39242, 33.76276], [-118.39324, 33.76159], [-118.39353, 33.76173], [-118.39386, 33.76157], [-118.394, 33.76132], [-118.39421, 33.76139], [-118.39443, 33.76143], [-118.39466, 33.76145], [-118.39504, 33.76145], [-118.3948, 33.76184], [-118.39634, 33.76183], [-118.3969, 33.7623], [-118.40024, 33.76452], [-118.40197, 33.76451], [-118.40218, 33.76489], [-118.40367, 33.76508], [-118.40367, 33.76579]]]} | Open Access 1 | 5862 | Agua Armaga Canyon Open Space | 29504 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 40.343 | Agua Armaga Canyon OS | 0 | Local Recreation Area 3 | 4 | |
6869 | 6869 | 6868 | {"type": "Polygon", "coordinates": [[[-118.50367, 34.10168], [-118.50057, 34.10248], [-118.50004, 34.10211], [-118.50262, 34.10136], [-118.50288, 34.10094], [-118.50293, 34.10121], [-118.5034, 34.10109], [-118.50341, 34.10111], [-118.50294, 34.10124], [-118.50307, 34.10152], [-118.50353, 34.10137], [-118.50354, 34.1014], [-118.50309, 34.10155], [-118.50312, 34.10179], [-118.50366, 34.10165], [-118.50367, 34.10168]]]} | Open Access 1 | 6375 | Mandeville East Open Space | 21741 | 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.165 | Mandeville East OS | 0 | Local Recreation Area 3 | 4 | |
16027 | 16027 | 16026 | {"type": "MultiPolygon", "coordinates": [[[[-118.50384, 34.08843], [-118.50318, 34.08848], [-118.50327, 34.08935], [-118.50312, 34.08974], [-118.50236, 34.08972], [-118.5023, 34.0909], [-118.50263, 34.09094], [-118.50225, 34.09178], [-118.50012, 34.09144], [-118.50023, 34.09288], [-118.49954, 34.09574], [-118.49868, 34.09591], [-118.49822, 34.09578], [-118.49783, 34.09526], [-118.49764, 34.09488], [-118.49781, 34.09407], [-118.49762, 34.09323], [-118.49767, 34.09284], [-118.49752, 34.09233], [-118.49756, 34.09207], [-118.49815, 34.0913], [-118.4981, 34.0908], [-118.49819, 34.09042], [-118.49818, 34.09017], [-118.49725, 34.08937], [-118.49689, 34.08849], [-118.49654, 34.08799], [-118.49644, 34.08791], [-118.49561, 34.08421], [-118.49554, 34.08374], [-118.49597, 34.08372], [-118.49595, 34.08383], [-118.49599, 34.08395], [-118.49605, 34.08402], [-118.49619, 34.0841], [-118.49624, 34.08415], [-118.49626, 34.0842], [-118.49626, 34.08425], [-118.49616, 34.08455], [-118.49618, 34.08463], [-118.49623, 34.0847], [-118.4962, 34.08485], [-118.49645, 34.08522], [-118.49769, 34.08467], [-118.49975, 34.08396], [-118.50069, 34.08418], [-118.50244, 34.0841], [-118.50252, 34.08529], [-118.50293, 34.08527], [-118.50296, 34.08591], [-118.5031, 34.08661], [-118.50313, 34.08797], [-118.5038, 34.08793], [-118.50384, 34.08843]]], [[[-118.49607, 34.08373], [-118.49607, 34.08373], [-118.49606, 34.0839], [-118.49604, 34.0838], [-118.49607, 34.08373]]], [[[-118.49629, 34.08408], [-118.49613, 34.08398], [-118.49608, 34.08392], [-118.49626, 34.08401], [-118.49629, 34.08408]]], [[[-118.49632, 34.08436], [-118.49626, 34.08459], [-118.49626, 34.08459], [-118.49626, 34.08453], [-118.49632, 34.08436]]], [[[-118.49636, 34.0842], [-118.49636, 34.0842], [-118.49635, 34.08423], [-118.49635, 34.08417], [-118.49636, 34.0842]]]]} | Open Access 1 | 6377 | Hilton Open Space | 19999 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 135.829 | Hilton OS | 0 | Local Recreation Area 3 | 4 | |
7242 | 7242 | 7241 | {"type": "Polygon", "coordinates": [[[-118.57098, 34.15161], [-118.5709, 34.1527], [-118.57041, 34.15261], [-118.57021, 34.15331], [-118.56909, 34.15368], [-118.56414, 34.15241], [-118.56436, 34.1514], [-118.56346, 34.15075], [-118.56364, 34.14998], [-118.566, 34.15044], [-118.57098, 34.15161]]]} | Open Access 1 | 6415 | Corbin Canyon Open Space | 17634 | 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 | 40.214 | Corbin Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16041 | 16041 | 16040 | {"type": "MultiPolygon", "coordinates": [[[[-118.64113, 34.05286], [-118.64113, 34.05487], [-118.64026, 34.05501], [-118.64029, 34.05494], [-118.6403, 34.05485], [-118.64028, 34.05478], [-118.64019, 34.05463], [-118.64017, 34.05445], [-118.64018, 34.05438], [-118.64025, 34.05429], [-118.64062, 34.05407], [-118.64067, 34.05398], [-118.64068, 34.05391], [-118.64064, 34.05382], [-118.64056, 34.05376], [-118.64048, 34.05373], [-118.64023, 34.05371], [-118.64013, 34.05366], [-118.63997, 34.05354], [-118.63986, 34.05351], [-118.63989, 34.0535], [-118.63989, 34.05286], [-118.64113, 34.05286]]], [[[-118.63816, 34.05318], [-118.63828, 34.05338], [-118.63764, 34.05419], [-118.63844, 34.05443], [-118.63877, 34.0544], [-118.63912, 34.05433], [-118.63921, 34.05429], [-118.63929, 34.05422], [-118.63937, 34.05426], [-118.63937, 34.05475], [-118.63844, 34.05491], [-118.63844, 34.05505], [-118.6384, 34.05495], [-118.63725, 34.05467], [-118.63707, 34.0549], [-118.63836, 34.05523], [-118.6384, 34.05523], [-118.63839, 34.05526], [-118.63834, 34.05532], [-118.63822, 34.05538], [-118.63812, 34.05544], [-118.63804, 34.05555], [-118.63802, 34.05564], [-118.63773, 34.05592], [-118.63763, 34.05595], [-118.63755, 34.05599], [-118.63739, 34.05617], [-118.63731, 34.05635], [-118.6372, 34.05654], [-118.63715, 34.05687], [-118.63716, 34.05694], [-118.63709, 34.05697], [-118.63704, 34.05708], [-118.63644, 34.05725], [-118.63646, 34.05793], [-118.63706, 34.05793], [-118.63688, 34.05846], [-118.63689, 34.05898], [-118.63735, 34.05968], [-118.63745, 34.06002], [-118.6374, 34.06002], [-118.6374, 34.06004], [-118.63763, 34.06083], [-118.63736, 34.06178], [-118.63733, 34.06256], [-118.63723, 34.06258], [-118.63723, 34.06348], [-118.6368, 34.06368], [-118.63444, 34.06368], [-118.63421, 34.06315], [-118.63383, 34.06264], [-118.63367, 34.06249], [-118.63334, 34.06229], [-118.63329, 34.06223], [-118.63326, 34.06217], [-118.63318, 34.0618], [-118.63455, 34.06144], [-118.63498, 34.06093], [-118.6344, 34.06005], [-118.63247, 34.06006], [-118.63249, 34.05288], [-118.63796, 34.05287], [-118.63816, 34.05318]]], [[[-118.6343, 34.06368], [-118.63248, 34.06368], [-118.63247, 34.06167], [-118.63261, 34.06161], [-118.63277, 34.06161], [-118.63291, 34.06167], [-118.63298, 34.06174], [-118.63302, 34.06182], [-118.63305, 34.06182], [-118.63313, 34.06219], [-118.63317, 34.06227], [-118.63326, 34.06237], [-118.63357, 34.06256], [-118.63371, 34.0627], [-118.63409, 34.0632], [-118.6343, 34.06368]]]]} | Open Access 1 | 6429 | Las Flores Canyon Open Space | 21048 | 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 | 131.468 | Las Flores Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16043 | 16043 | 16042 | {"type": "MultiPolygon", "coordinates": [[[[-118.63872, 34.06381], [-118.63873, 34.06394], [-118.63869, 34.06403], [-118.63859, 34.06413], [-118.6384, 34.06421], [-118.63832, 34.06427], [-118.63824, 34.06439], [-118.63822, 34.06452], [-118.63825, 34.06461], [-118.6383, 34.06469], [-118.63863, 34.06493], [-118.63869, 34.065], [-118.63872, 34.06508], [-118.63873, 34.06517], [-118.63871, 34.06525], [-118.63858, 34.06549], [-118.63853, 34.06563], [-118.63851, 34.06584], [-118.63854, 34.06598], [-118.63892, 34.06725], [-118.63893, 34.06745], [-118.6389, 34.06757], [-118.63884, 34.06769], [-118.6387, 34.06785], [-118.6381, 34.06827], [-118.638, 34.0683], [-118.63786, 34.0683], [-118.63773, 34.06823], [-118.63766, 34.06813], [-118.63756, 34.06745], [-118.63751, 34.06726], [-118.63743, 34.06707], [-118.63732, 34.06688], [-118.63682, 34.06615], [-118.6368, 34.0639], [-118.63872, 34.06381]]], [[[-118.6412, 34.07112], [-118.63685, 34.07104], [-118.63684, 34.06734], [-118.63682, 34.06638], [-118.6372, 34.06694], [-118.63734, 34.06719], [-118.63743, 34.06745], [-118.63753, 34.06815], [-118.63757, 34.06824], [-118.63769, 34.06835], [-118.63779, 34.06839], [-118.6379, 34.06842], [-118.63802, 34.06841], [-118.63813, 34.06838], [-118.63822, 34.06833], [-118.63873, 34.06798], [-118.63891, 34.06781], [-118.63899, 34.06768], [-118.63905, 34.06753], [-118.63907, 34.06739], [-118.63906, 34.06727], [-118.63866, 34.06595], [-118.63864, 34.06583], [-118.63865, 34.06571], [-118.63868, 34.06559], [-118.63881, 34.06534], [-118.63885, 34.06523], [-118.63885, 34.06506], [-118.63881, 34.06495], [-118.63873, 34.06486], [-118.63842, 34.06464], [-118.63837, 34.06458], [-118.63835, 34.06451], [-118.63837, 34.0644], [-118.63842, 34.06434], [-118.63869, 34.0642], [-118.63877, 34.06413], [-118.63883, 34.06405], [-118.64, 34.06447], [-118.63925, 34.0655], [-118.6393, 34.06626], [-118.64064, 34.06621], [-118.64081, 34.06651], [-118.6408, 34.06671], [-118.64082, 34.06681], [-118.64085, 34.06687], [-118.6409, 34.06691], [-118.641, 34.06695], [-118.64108, 34.06695], [-118.64117, 34.06692], [-118.6412, 34.07112]]]]} | Open Access 1 | 6431 | Las Flores Canyon Open Space | 21048 | 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 | 65.568 | Las Flores Canyon OS | 0 | Local Recreation Area 3 | 4 | |
1069 | 1069 | 1068 | {"type": "Polygon", "coordinates": [[[-118.64067, 34.06497], [-118.64065, 34.06495], [-118.64055, 34.065], [-118.6405, 34.06505], [-118.64048, 34.06512], [-118.6405, 34.06525], [-118.64059, 34.06544], [-118.63925, 34.0655], [-118.6403, 34.06406], [-118.64038, 34.06412], [-118.64057, 34.0642], [-118.64081, 34.06442], [-118.64085, 34.06449], [-118.64086, 34.06455], [-118.64083, 34.06472], [-118.64088, 34.06484], [-118.64087, 34.06487], [-118.64083, 34.06492], [-118.64067, 34.06497]]]} | Open Access 1 | 6433 | Las Flores Canyon Open Space | 21048 | 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 | 3.131 | Las Flores Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16045 | 16045 | 16044 | {"type": "MultiPolygon", "coordinates": [[[[-118.69358, 34.06729], [-118.69357, 34.0705], [-118.6932, 34.07055], [-118.69307, 34.07054], [-118.69296, 34.0705], [-118.69278, 34.07037], [-118.69263, 34.07018], [-118.69251, 34.07006], [-118.69228, 34.06992], [-118.69197, 34.0698], [-118.69188, 34.06973], [-118.69176, 34.06958], [-118.69168, 34.06951], [-118.69154, 34.06944], [-118.69141, 34.0694], [-118.69127, 34.06939], [-118.69113, 34.06939], [-118.69091, 34.06944], [-118.69081, 34.06943], [-118.69072, 34.0694], [-118.69065, 34.06935], [-118.69026, 34.06897], [-118.6901, 34.06878], [-118.68988, 34.06861], [-118.68987, 34.06705], [-118.69358, 34.06729]]], [[[-118.69357, 34.07067], [-118.69357, 34.07089], [-118.68918, 34.07074], [-118.68918, 34.06858], [-118.68959, 34.06869], [-118.68981, 34.06881], [-118.6905, 34.06946], [-118.69066, 34.06956], [-118.69078, 34.06959], [-118.69091, 34.0696], [-118.69127, 34.06955], [-118.69139, 34.06957], [-118.6915, 34.06961], [-118.69162, 34.06969], [-118.69172, 34.06982], [-118.69182, 34.06991], [-118.69187, 34.06994], [-118.69219, 34.07007], [-118.6924, 34.0702], [-118.69253, 34.07033], [-118.69256, 34.07039], [-118.6927, 34.07055], [-118.69287, 34.07065], [-118.69301, 34.0707], [-118.69315, 34.07072], [-118.69357, 34.07067]]]]} | Open Access 1 | 6465 | Malibu Canyon Piuma Ridge Open Space | 21704 | 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 | 35.873 | Malibu Canyon Piuma Ridge OS | 0 | Local Recreation Area 3 | 4 | |
16047 | 16047 | 16046 | {"type": "MultiPolygon", "coordinates": [[[[-118.70235, 34.07092], [-118.70224, 34.07455], [-118.69792, 34.0745], [-118.69589, 34.0745], [-118.69357, 34.07448], [-118.69357, 34.07293], [-118.6937, 34.07293], [-118.69401, 34.07288], [-118.69406, 34.07288], [-118.69417, 34.07292], [-118.69425, 34.07299], [-118.69427, 34.07305], [-118.69427, 34.0731], [-118.69422, 34.07323], [-118.69421, 34.07331], [-118.69425, 34.07345], [-118.69437, 34.07358], [-118.69447, 34.07363], [-118.69457, 34.07366], [-118.69532, 34.07369], [-118.69552, 34.07363], [-118.69562, 34.07353], [-118.6957, 34.07341], [-118.69577, 34.07336], [-118.69584, 34.07334], [-118.69651, 34.07338], [-118.69705, 34.07359], [-118.69714, 34.07365], [-118.69717, 34.07371], [-118.69716, 34.07389], [-118.69719, 34.07398], [-118.69726, 34.07408], [-118.69739, 34.07417], [-118.6975, 34.0742], [-118.69764, 34.07419], [-118.69771, 34.07418], [-118.69787, 34.07408], [-118.69791, 34.07403], [-118.69795, 34.07394], [-118.69796, 34.07384], [-118.69794, 34.07376], [-118.6979, 34.07369], [-118.69754, 34.07339], [-118.69733, 34.07327], [-118.69656, 34.07289], [-118.69642, 34.07284], [-118.69613, 34.07279], [-118.69607, 34.07276], [-118.6959, 34.07265], [-118.69579, 34.07261], [-118.69558, 34.0726], [-118.69547, 34.07257], [-118.69539, 34.07248], [-118.69518, 34.07205], [-118.69508, 34.07193], [-118.6949, 34.07183], [-118.69451, 34.07178], [-118.69443, 34.07176], [-118.69437, 34.07171], [-118.69433, 34.07165], [-118.69433, 34.07157], [-118.69442, 34.07111], [-118.69442, 34.07097], [-118.69439, 34.07089], [-118.70235, 34.07092]]], [[[-118.69776, 34.07391], [-118.69768, 34.074], [-118.69762, 34.07403], [-118.69751, 34.07403], [-118.69745, 34.07401], [-118.6974, 34.07397], [-118.69737, 34.07392], [-118.69735, 34.07365], [-118.69732, 34.07358], [-118.69724, 34.0735], [-118.69712, 34.07343], [-118.69661, 34.07324], [-118.69652, 34.07322], [-118.69593, 34.07317], [-118.69577, 34.07318], [-118.69562, 34.07325], [-118.69553, 34.07334], [-118.69543, 34.07347], [-118.69537, 34.07351], [-118.6953, 34.07353], [-118.6946, 34.0735], [-118.69452, 34.07347], [-118.69445, 34.07342], [-118.69442, 34.07335], [-118.69442, 34.07326], [-118.69447, 34.07313], [-118.69446, 34.07298], [-118.69441, 34.07289], [-118.69431, 34.0728], [-118.6942, 34.07275], [-118.69407, 34.07272], [-118.69358, 34.07277], [-118.69357, 34.07088], [-118.69418, 34.07088], [-118.69421, 34.07095], [-118.69422, 34.07108], [-118.69412, 34.07158], [-118.69414, 34.07168], [-118.6942, 34.07179], [-118.69431, 34.07189], [-118.69441, 34.07193], [-118.6948, 34.07198], [-118.69491, 34.07202], [-118.69497, 34.07207], [-118.69501, 34.07213], [-118.69523, 34.07258], [-118.69535, 34.07269], [-118.69544, 34.07274], [-118.69555, 34.07276], [-118.69575, 34.07277], [-118.69602, 34.07293], [-118.69634, 34.07299], [-118.6965, 34.07305], [-118.69728, 34.07344], [-118.69744, 34.07354], [-118.69771, 34.07375], [-118.69776, 34.07381], [-118.69776, 34.07391]]]]} | Open Access 1 | 6466 | Malibu Canyon Piuma Ridge Open Space | 21704 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 74.802 | Malibu Canyon Piuma Ridge OS | 0 | Local Recreation Area 3 | 4 | |
7006 | 7006 | 7005 | {"type": "Polygon", "coordinates": [[[-118.68703, 34.06893], [-118.68702, 34.07066], [-118.68603, 34.07063], [-118.68604, 34.06901], [-118.68673, 34.06901], [-118.68688, 34.06898], [-118.68703, 34.06893]]]} | Open Access 1 | 6467 | Malibu Canyon Piuma Ridge Open Space | 21704 | 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.135 | Malibu Canyon Piuma Ridge OS | 0 | Local Recreation Area 3 | 4 | |
7007 | 7007 | 7006 | {"type": "Polygon", "coordinates": [[[-118.68834, 34.06814], [-118.68825, 34.06823], [-118.68816, 34.06824], [-118.68824, 34.06815], [-118.68815, 34.06807], [-118.68809, 34.06805], [-118.68753, 34.06822], [-118.68752, 34.0673], [-118.68796, 34.06733], [-118.6882, 34.06803], [-118.68834, 34.06814]]]} | Open Access 1 | 6468 | Blue Onyx Open Space | 16185 | 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 | 1.211 | Blue Onyx OS | 0 | Local Recreation Area 3 | 4 | |
16039 | 16039 | 16038 | {"type": "Polygon", "coordinates": [[[-118.68902, 34.06837], [-118.68849, 34.06824], [-118.68825, 34.06823], [-118.68834, 34.06814], [-118.6882, 34.06803], [-118.68796, 34.06733], [-118.68796, 34.06719], [-118.689, 34.06726], [-118.68902, 34.06837]]]} | Open Access 1 | 6471 | Blue Onyx Open Space | 16185 | 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.384 | Blue Onyx OS | 0 | Local Recreation Area 3 | 4 | |
16053 | 16053 | 16052 | {"type": "MultiPolygon", "coordinates": [[[[-118.02124, 33.98973], [-118.01938, 33.99107], [-118.0193, 33.99111], [-118.01914, 33.99113], [-118.01881, 33.99105], [-118.01825, 33.99098], [-118.01817, 33.99099], [-118.01806, 33.99103], [-118.01801, 33.99109], [-118.01799, 33.99115], [-118.01798, 33.99122], [-118.01801, 33.99128], [-118.01806, 33.99134], [-118.01813, 33.99138], [-118.01834, 33.99141], [-118.01844, 33.99146], [-118.01848, 33.99151], [-118.0185, 33.99157], [-118.01849, 33.99163], [-118.01846, 33.99168], [-118.01838, 33.99174], [-118.01777, 33.99197], [-118.01761, 33.99207], [-118.01749, 33.99221], [-118.01745, 33.99232], [-118.01743, 33.99245], [-118.01739, 33.99251], [-118.01733, 33.99255], [-118.01699, 33.99269], [-118.01688, 33.99277], [-118.01675, 33.99292], [-118.01663, 33.99311], [-118.01655, 33.99321], [-118.01627, 33.99341], [-118.01594, 33.99366], [-118.01583, 33.99372], [-118.01548, 33.99379], [-118.01535, 33.9938], [-118.01522, 33.99379], [-118.01504, 33.99373], [-118.01494, 33.99366], [-118.01486, 33.99358], [-118.01433, 33.99283], [-118.01421, 33.99276], [-118.01412, 33.99274], [-118.01402, 33.99275], [-118.01394, 33.99278], [-118.01384, 33.99287], [-118.01381, 33.99295], [-118.01382, 33.99322], [-118.01388, 33.9935], [-118.01385, 33.99356], [-118.01377, 33.99359], [-118.01332, 33.99357], [-118.0132, 33.99358], [-118.01303, 33.99365], [-118.01291, 33.99377], [-118.01286, 33.99387], [-118.01284, 33.99397], [-118.01286, 33.99407], [-118.01289, 33.99415], [-118.013, 33.99428], [-118.01325, 33.99441], [-118.01328, 33.99446], [-118.01329, 33.99451], [-118.01326, 33.99456], [-118.0128, 33.99492], [-118.01271, 33.99497], [-118.01261, 33.99501], [-118.01246, 33.99501], [-118.01143, 33.9949], [-118.01127, 33.99491], [-118.01118, 33.99494], [-118.01103, 33.99502], [-118.01092, 33.99504], [-118.01081, 33.99502], [-118.01056, 33.99493], [-118.0104, 33.99491], [-118.00955, 33.99493], [-118.00949, 33.99491], [-118.00945, 33.99485], [-118.00944, 33.99481], [-118.00946, 33.99463], [-118.00941, 33.9945], [-118.00934, 33.99442], [-118.00925, 33.99437], [-118.00909, 33.99432], [-118.00892, 33.99434], [-118.00859, 33.99448], [-118.00843, 33.99456], [-118.00828, 33.99468], [-118.00823, 33.9947], [-118.00794, 33.99471], [-118.00777, 33.99478], [-118.00771, 33.99478], [-118.00767, 33.99476], [-118.00765, 33.99472], [-118.00767, 33.99442], [-118.00764, 33.99422], [-118.0075, 33.99388], [-118.00748, 33.99373], [-118.00745, 33.99362], [-118.00723, 33.99329], [-118.00715, 33.99324], [-118.007, 33.9932], [-118.00684, 33.99323], [-118.00676, 33.99328], [-118.0067, 33.99335], [-118.00667, 33.99343], [-118.00665, 33.99367], [-118.00662, 33.99373], [-118.00644, 33.99391], [-118.00641, 33.99399], [-118.00637, 33.99426], [-118.00631, 33.9943], [-118.00625, 33.99429], [-118.00604, 33.99416], [-118.00598, 33.99408], [-118.00576, 33.99336], [-118.00572, 33.99328], [-118.00565, 33.99322], [-118.00556, 33.99317], [-118.00541, 33.99315], [-118.00531, 33.99318], [-118.00522, 33.99322], [-118.00515, 33.9933], [-118.00505, 33.99344], [-118.00498, 33.99349], [-118.00489, 33.9935], [-118.00469, 33.99343], [-118.00459, 33.99343], [-118.00447, 33.99347], [-118.00437, 33.99355], [-118.00432, 33.99367], [-118.00434, 33.99398], [-118.00433, 33.99405], [-118.00429, 33.99412], [-118.00419, 33.99421], [-118.00413, 33.99434], [-118.00414, 33.99447], [-118.00424, 33.99463], [-118.00422, 33.99469], [-118.00417, 33.99473], [-118.004, 33.99475], [-118.00385, 33.99471], [-118.00362, 33.99458], [-118.00356, 33.99451], [-118.00286, 33.99423], [-118.00262, 33.99423], [-118.00249, 33.99428], [-118.00237, 33.99438], [-118.00218, 33.99415], [-118.00226, 33.98961], [-117.99339, 33.98965], [-117.99357, 33.98241], [-118.00675, 33.9824], [-118.00666, 33.98603], [-118.01101, 33.98603], [-118.01979, 33.98612], [-118.01973, 33.98968], [-118.02124, 33.98973]]], [[[-118.02863, 33.98995], [-118.02862, 33.99703], [-118.01632, 33.99904], [-118.01394, 34.0002], [-118.01117, 34.00059], [-118.0107, 34.0018], [-118.0098, 34.00224], [-118.00612, 33.99767], [-118.00524, 33.99916], [-118.00413, 33.99864], [-118.00401, 33.99855], [-118.00371, 33.99829], [-118.00297, 33.99793], [-118.00352, 33.99749], [-118.00324, 33.99706], [-118.0028, 33.99704], [-118.00252, 33.99745], [-118.00104, 33.99676], [-118.00161, 33.99657], [-118.00173, 33.9965], [-118.00181, 33.99641], [-118.00186, 33.99632], [-118.00189, 33.99618], [-118.00188, 33.99599], [-118.00182, 33.9958], [-118.00166, 33.99552], [-118.00165, 33.99537], [-118.00168, 33.99532], [-118.00176, 33.9953], [-118.00183, 33.99532], [-118.00208, 33.9951], [-118.00245, 33.99459], [-118.00254, 33.99449], [-118.00268, 33.99443], [-118.00285, 33.99443], [-118.00347, 33.99467], [-118.00385, 33.99486], [-118.00407, 33.99489], [-118.00424, 33.99486], [-118.00435, 33.99478], [-118.0044, 33.99467], [-118.0044, 33.99459], [-118.00431, 33.99444], [-118.0043, 33.99436], [-118.00433, 33.99428], [-118.00446, 33.99415], [-118.00449, 33.99407], [-118.0045, 33.99397], [-118.00448, 33.99369], [-118.00451, 33.99362], [-118.00456, 33.99358], [-118.00463, 33.99356], [-118.00489, 33.99363], [-118.00498, 33.99363], [-118.00507, 33.99361], [-118.00518, 33.99353], [-118.00531, 33.99333], [-118.00541, 33.99329], [-118.00552, 33.99331], [-118.00559, 33.99337], [-118.0058, 33.99408], [-118.00586, 33.9942], [-118.00592, 33.99425], [-118.00615, 33.9944], [-118.00622, 33.99443], [-118.0063, 33.99444], [-118.00642, 33.99442], [-118.00648, 33.99438], [-118.00652, 33.99432], [-118.00658, 33.99398], [-118.00675, 33.99381], [-118.00682, 33.99369], [-118.00683, 33.9936], [-118.00682, 33.99346], [-118.00684, 33.9934], [-118.00689, 33.99336], [-118.00696, 33.99333], [-118.00703, 33.99334], [-118.0071, 33.99337], [-118.00714, 33.99341], [-118.00729, 33.99369], [-118.00734, 33.99393], [-118.00747, 33.99424], [-118.00749, 33.99436], [-118.00748, 33.99471], [-118.0075, 33.99478], [-118.00757, 33.99486], [-118.00768, 33.99491], [-118.0078, 33.99491], [-118.00799, 33.99485], [-118.00818, 33.99485], [-118.00829, 33.99483], [-118.00838, 33.99479], [-118.00862, 33.99462], [-118.00896, 33.99448], [-118.00907, 33.99446], [-118.00918, 33.99449], [-118.00926, 33.99456], [-118.0093, 33.99465], [-118.00927, 33.99481], [-118.0093, 33.99492], [-118.00939, 33.99502], [-118.00952, 33.99507], [-118.01046, 33.99505], [-118.01058, 33.99507], [-118.01079, 33.99516], [-118.01092, 33.99518], [-118.01109, 33.99515], [-118.01127, 33.99506], [-118.0114, 33.99504], [-118.0125, 33.99516], [-118.01263, 33.99515], [-118.01275, 33.99512], [-118.01291, 33.99503], [-118.01335, 33.99467], [-118.01341, 33.99461], [-118.01345, 33.99453], [-118.01344, 33.99443], [-118.01339, 33.99434], [-118.01332, 33.99429], [-118.01313, 33.9942], [-118.01303, 33.99409], [-118.013, 33.99396], [-118.01303, 33.99388], [-118.01312, 33.99377], [-118.01326, 33.99371], [-118.01378, 33.99372], [-118.01387, 33.9937], [-118.01398, 33.99364], [-118.01402, 33.99357], [-118.01404, 33.99349], [-118.01399, 33.99324], [-118.01396, 33.99298], [-118.01398, 33.99294], [-118.01402, 33.9929], [-118.01411, 33.99288], [-118.01417, 33.99289], [-118.01421, 33.99292], [-118.01476, 33.9937], [-118.01487, 33.99379], [-118.01499, 33.99387], [-118.01521, 33.99393], [-118.01544, 33.99394], [-118.01582, 33.99387], [-118.01599, 33.9938], [-118.01665, 33.99332], [-118.01675, 33.99322], [-118.0169, 33.99297], [-118.01698, 33.99288], [-118.01708, 33.99281], [-118.01741, 33.99267], [-118.0175, 33.99261], [-118.01758, 33.9925], [-118.01761, 33.99234], [-118.01764, 33.99225], [-118.01775, 33.99215], [-118.01784, 33.9921], [-118.01848, 33.99185], [-118.0186, 33.99176], [-118.01864, 33.99167], [-118.01866, 33.99158], [-118.01864, 33.99149], [-118.0186, 33.99141], [-118.01852, 33.99134], [-118.01843, 33.99129], [-118.01818, 33.99124], [-118.01815, 33.99119], [-118.01817, 33.99114], [-118.01823, 33.99112], [-118.0187, 33.99117], [-118.01913, 33.99127], [-118.01932, 33.99125], [-118.01949, 33.99118], [-118.02156, 33.98967], [-118.02178, 33.98944], [-118.02201, 33.98909], [-118.02239, 33.98861], [-118.02252, 33.98851], [-118.02262, 33.98847], [-118.02279, 33.98847], [-118.0229, 33.98849], [-118.02326, 33.98872], [-118.02349, 33.98882], [-118.02365, 33.98885], [-118.02391, 33.98887], [-118.02432, 33.98883], [-118.025, 33.98864], [-118.02659, 33.9884], [-118.02664, 33.98989], [-118.02863, 33.98995]]]]} | Open Access 1 | 6494 | Turnbull Canyon Open Space | 29669 | 2332 | Puente Hills Habitat Preservation Authority 849 | Special District 4 | Conservation District 31 | http://www.habitatauthority.org | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.hillsforeveryone.org/visitors-guide/ph-access.html | Los Angeles 6 | 982.018 | Turnbull Canyon OS | 0 | Local Recreation Area 3 | 4 |
16054 | 16054 | 16053 | {"type": "Polygon", "coordinates": [[[-118.05598, 34.00404], [-118.05588, 34.00488], [-118.05517, 34.00482], [-118.05493, 34.00456], [-118.05489, 34.00458], [-118.05126, 34.00442], [-118.05104, 34.0045], [-118.05088, 34.0045], [-118.05078, 34.00439], [-118.05031, 34.00437], [-118.05032, 34.004], [-118.05083, 34.00384], [-118.05083, 34.00382], [-118.04981, 34.0035], [-118.04948, 34.00345], [-118.04626, 34.00323], [-118.04625, 34.00324], [-118.04641, 34.00445], [-118.04344, 34.00374], [-118.04201, 34.00324], [-118.04011, 34.0028], [-118.03994, 34.00383], [-118.03882, 34.00374], [-118.03737, 34.00312], [-118.03733, 34.00079], [-118.04593, 34.00089], [-118.04604, 34.0017], [-118.04899, 34.00174], [-118.04936, 34.00199], [-118.04959, 34.00206], [-118.05047, 34.00241], [-118.05049, 34.00175], [-118.05062, 34.00175], [-118.05396, 34.00349], [-118.05557, 34.00362], [-118.05553, 34.004], [-118.05598, 34.00404]]]} | Open Access 1 | 6495 | Sycamore Canyon Open Space | 26116 | 2332 | Puente Hills Habitat Preservation Authority 849 | Special District 4 | Conservation District 31 | http://www.habitatauthority.org | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 100.023 | Sycamore Canyon OS | 0 | Local Recreation Area 3 | 4 | |
7025 | 7025 | 7024 | {"type": "Polygon", "coordinates": [[[-118.00435, 34.00067], [-118.00072, 34.00684], [-117.99905, 34.00616], [-117.99865, 34.00604], [-117.99811, 34.00594], [-117.99769, 34.00592], [-117.9972, 34.00594], [-117.99674, 34.00602], [-117.99656, 34.00606], [-117.99617, 34.00619], [-117.99577, 34.00638], [-117.99538, 34.00662], [-117.995, 34.00693], [-117.99481, 34.00713], [-117.99462, 34.00739], [-117.99442, 34.00773], [-117.99436, 34.00788], [-117.99402, 34.00902], [-117.99395, 34.00922], [-117.99391, 34.0093], [-117.99494, 34.00555], [-117.99575, 34.0047], [-117.99784, 34.0031], [-117.99943, 34.00315], [-118.00071, 34.00186], [-118.00161, 34.00193], [-118.0024, 34.00178], [-118.00309, 34.0011], [-118.00371, 34.00108], [-118.00435, 34.00067]]]} | Unknown Access 4 | 6507 | Hacienda Hills Open Space | 29675 | 2332 | Puente Hills Habitat Preservation Authority 849 | Special District 4 | Conservation District 31 | http://www.habitatauthority.org | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 62.094 | Hacienda Hills OS | 0 | Local Recreation Area 3 | 4 | |
7235 | 7235 | 7234 | {"type": "MultiPolygon", "coordinates": [[[[-117.9711, 33.97414], [-117.97033, 33.97501], [-117.96902, 33.97501], [-117.96879, 33.97516], [-117.96856, 33.97495], [-117.96849, 33.97498], [-117.96757, 33.9742], [-117.96722, 33.9738], [-117.96704, 33.97344], [-117.96865, 33.97343], [-117.9711, 33.97414]]], [[[-118.00131, 33.96455], [-118.00116, 33.96476], [-118.00086, 33.96505], [-118.00056, 33.96529], [-118.00022, 33.9656], [-117.99995, 33.96573], [-117.99909, 33.96585], [-117.99817, 33.96629], [-117.99774, 33.96624], [-117.99667, 33.96659], [-117.99639, 33.96663], [-117.99593, 33.96712], [-117.99495, 33.96767], [-117.9948, 33.96769], [-117.99422, 33.96798], [-117.99409, 33.96831], [-117.99383, 33.96841], [-117.99382, 33.96849], [-117.99213, 33.96952], [-117.99173, 33.9698], [-117.99137, 33.97011], [-117.98983, 33.97173], [-117.9895, 33.97202], [-117.98906, 33.97235], [-117.98858, 33.97265], [-117.98818, 33.97286], [-117.98643, 33.97368], [-117.98598, 33.9739], [-117.9854, 33.97424], [-117.98516, 33.9744], [-117.98477, 33.97468], [-117.98422, 33.97511], [-117.97765, 33.97509], [-117.97666, 33.97483], [-117.97664, 33.97254], [-117.97665, 33.96784], [-117.98953, 33.96796], [-117.98955, 33.96635], [-117.98955, 33.96502], [-117.98981, 33.96474], [-117.98999, 33.96459], [-117.99016, 33.96448], [-117.99378, 33.96454], [-118.00131, 33.96455]]]]} | Open Access 1 | 6520 | Arroyo San Miguel Open Space | 29672 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 320.047 | Arroyo San Miguel OS | 0 | Local Recreation Area 3 | 4 | |
16057 | 16057 | 16056 | {"type": "Polygon", "coordinates": [[[-118.03735, 34.00383], [-118.02861, 34.00378], [-118.02862, 34.00033], [-118.03732, 34.00021], [-118.03737, 34.00312], [-118.03735, 34.00383]]]} | Open Access 1 | 6637 | Sycamore Canyon Open Space | 26116 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 78.242 | Sycamore Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16055 | 16055 | 16054 | {"type": "Polygon", "coordinates": [[[-118.41376, 34.13176], [-118.41291, 34.13177], [-118.41301, 34.13079], [-118.41376, 34.13074], [-118.41376, 34.13176]]]} | Open Access 1 | 6866 | Coldwater Canyon Open Space Park | 29574 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.034 | Coldwater Canyon OS Park | 0 | Local Recreation Area 3 | 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]);