units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
75 rows where DES_TP = 2 and MNG_AG_TYP = 6 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, LAYER, MNG_AG_ID, COUNTY, YR_EST
AGNCY_WEB 13 ✖
- http://www.mrca.ca.gov/ 43
- http://www.smmc.ca.gov 15
- http://palosverdes.com/rpv/recreationparks/index.cfm 2
- http://www.conejo-openspace.org/ 2
- http://www.sdrp.org/ 2
- http://lacity.org/ 1
- http://smmc.ca.gov/BHRCA.asp 1
- http://www.cityofwhittier.org/depts/prcs/default.asp 1
- http://www.crpd.org/ 1
- http://www.dmca.ca.gov/ 1
- http://www.dot.ca.gov/ 1
- http://www.ladwp.com/ 1
- http://www.ventura.org/general-services-agency/parks-department 1
MNG_AGENCY 5
ACCESS_TYP 3
MNG_AG_TYP 1
- Open Space District · 75 ✖
DES_TP 1
- Local Park · 75 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5641 | 5641 | 5640 | {"type": "Polygon", "coordinates": [[[-118.22852, 34.08438], [-118.2285, 34.0844], [-118.22844, 34.0843], [-118.22835, 34.08422], [-118.22833, 34.08418], [-118.22835, 34.08399], [-118.22852, 34.08438]]]} | Open Access 1 | 46908 | Egret Park | 30449 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.055 | Egret Park | 0 | Local Park 2 | 4 | |
7412 | 7412 | 7411 | {"type": "Polygon", "coordinates": [[[-118.22982, 34.08555], [-118.22966, 34.08568], [-118.22908, 34.08522], [-118.22911, 34.08519], [-118.22943, 34.08538], [-118.22981, 34.08552], [-118.22982, 34.08555]]]} | Open Access 1 | 6926 | Oso Park | 23235 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.218 | Oso Park | 0 | Local Park 2 | 4 | |
7447 | 7447 | 7446 | {"type": "MultiPolygon", "coordinates": [[[[-118.22877, 34.08683], [-118.22866, 34.08675], [-118.22875, 34.08668], [-118.22875, 34.08668], [-118.22877, 34.08683]]], [[[-118.22915, 34.08683], [-118.22891, 34.08704], [-118.22889, 34.08693], [-118.22882, 34.08688], [-118.22879, 34.08664], [-118.22885, 34.08659], [-118.22915, 34.08683]]]]} | No Public Access 3 | 6921 | Steelhead Park | 25823 | 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 | 0.219 | Steelhead Park | 0 | Local Park 2 | 4 | |
7446 | 7446 | 7445 | {"type": "MultiPolygon", "coordinates": [[[[-118.24291, 34.10283], [-118.24291, 34.10283], [-118.2429, 34.10308], [-118.24276, 34.10294], [-118.24291, 34.10283]]], [[[-118.24334, 34.103], [-118.24304, 34.10321], [-118.24295, 34.10313], [-118.24296, 34.1028], [-118.24306, 34.10272], [-118.24334, 34.103]]]]} | Open Access 1 | 6919 | Elysian Valley Gateway Park | 18608 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.321 | Elysian Valley Gateway Park | 0 | Local Park 2 | 4 | |
15240 | 15240 | 15239 | {"type": "Polygon", "coordinates": [[[-118.62073, 34.19735], [-118.62041, 34.19737], [-118.6201, 34.19741], [-118.6198, 34.19749], [-118.6194, 34.19763], [-118.6194, 34.19749], [-118.6193, 34.19749], [-118.6193, 34.19743], [-118.61926, 34.19743], [-118.61925, 34.19737], [-118.6188, 34.19737], [-118.6188, 34.19735], [-118.62073, 34.19735]]]} | Unknown Access 4 | 46238 | Bell Creek Park | 29516 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.384 | Bell Creek Park | 0 | Local Park 2 | 4 | |
7428 | 7428 | 7427 | {"type": "Polygon", "coordinates": [[[-118.22601, 34.0822], [-118.22554, 34.08201], [-118.22525, 34.08188], [-118.22546, 34.08173], [-118.22558, 34.08171], [-118.22568, 34.08174], [-118.22578, 34.08182], [-118.22601, 34.0822]]]} | No Public Access 3 | 6924 | Confluence Park | 29794 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.393 | Confluence Park | 2003 | Local Park 2 | 4 | |
15267 | 15267 | 15266 | {"type": "Polygon", "coordinates": [[[-118.39447, 34.12764], [-118.39428, 34.12782], [-118.39414, 34.12791], [-118.39396, 34.12797], [-118.39376, 34.12798], [-118.39355, 34.12794], [-118.39338, 34.12786], [-118.39328, 34.12777], [-118.39311, 34.12755], [-118.39321, 34.1275], [-118.39337, 34.12771], [-118.39347, 34.12779], [-118.39358, 34.12784], [-118.39376, 34.12789], [-118.39396, 34.12787], [-118.39408, 34.12783], [-118.39418, 34.12776], [-118.39438, 34.12758], [-118.39447, 34.12764]]]} | Open Access 1 | 46331 | Fryman Canyon Park | 29621 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.403 | Fryman Canyon Park | 0 | Local Park 2 | 4 | |
15272 | 15272 | 15271 | {"type": "Polygon", "coordinates": [[[-118.60349, 34.03929], [-118.60304, 34.03933], [-118.60253, 34.03932], [-118.60254, 34.03911], [-118.60277, 34.03913], [-118.60296, 34.03912], [-118.60331, 34.03908], [-118.60345, 34.03903], [-118.60349, 34.03929]]]} | Unknown Access 4 | 46353 | Las Tunas Beach | 29634 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.511 | Las Tunas Beach | 0 | Local Park 2 | 4 | |
13118 | 13118 | 13117 | {"type": "Polygon", "coordinates": [[[-118.32897, 34.10547], [-118.32877, 34.10597], [-118.32865, 34.10616], [-118.32806, 34.1056], [-118.32807, 34.10559], [-118.32819, 34.10555], [-118.32853, 34.1055], [-118.32891, 34.10541], [-118.32895, 34.10543], [-118.32897, 34.10547]]]} | Open Access 1 | 45044 | Franklin Ivar Park | 19059 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.862 | Franklin Ivar Park | 0 | Local Park 2 | 4 | |
15201 | 15201 | 15200 | {"type": "Polygon", "coordinates": [[[-118.41981, 33.98441], [-118.4179, 33.98583], [-118.41786, 33.98591], [-118.41784, 33.98601], [-118.41786, 33.98605], [-118.41782, 33.98606], [-118.41773, 33.98597], [-118.41734, 33.98624], [-118.41726, 33.98615], [-118.41972, 33.98432], [-118.41981, 33.98441]]]} | Open Access 1 | 46080 | Milton Street Park | 29422 | 500 | Baldwin Hills Regional Conservation Authority 1140 | Joint 8 | Joint Powers Authority 24 | http://smmc.ca.gov/BHRCA.asp | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.029 | Milton Street Park | 0 | Local Park 2 | 4 | |
14719 | 14719 | 14718 | {"type": "Polygon", "coordinates": [[[-118.43673, 34.27426], [-118.43631, 34.27511], [-118.43575, 34.27622], [-118.43553, 34.27602], [-118.43556, 34.27597], [-118.43552, 34.27593], [-118.43595, 34.2753], [-118.43628, 34.27472], [-118.4367, 34.27423], [-118.43673, 34.27426]]]} | Open Access 1 | 45067 | Pacoima Wash Greenway - El Dorado Park | 28071 | 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.197 | Pacoima Wash Greenway - El Dorado Park | 0 | Local Park 2 | 4 | |
15258 | 15258 | 15257 | {"type": "Polygon", "coordinates": [[[-118.22167, 34.10123], [-118.22164, 34.10136], [-118.22162, 34.10133], [-118.2215, 34.10138], [-118.22152, 34.10147], [-118.22133, 34.10152], [-118.22133, 34.10135], [-118.22132, 34.10134], [-118.22045, 34.1016], [-118.22027, 34.1012], [-118.22067, 34.10102], [-118.2211, 34.10072], [-118.22167, 34.10123]]]} | Open Access 1 | 46322 | Elyria Canyon Park | 18607 | 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 | 1.644 | Elyria Canyon Park | 0 | Local Park 2 | 4 | |
6576 | 6576 | 6575 | {"type": "MultiPolygon", "coordinates": [[[[-118.86601, 34.03617], [-118.86592, 34.03642], [-118.86581, 34.03642], [-118.86573, 34.03683], [-118.86572, 34.03685], [-118.86569, 34.03684], [-118.86578, 34.03639], [-118.8659, 34.03639], [-118.86597, 34.03617], [-118.86601, 34.03617]]], [[[-118.86946, 34.03654], [-118.86936, 34.03691], [-118.86885, 34.03681], [-118.86829, 34.03667], [-118.86709, 34.03629], [-118.86632, 34.0361], [-118.86629, 34.03604], [-118.86583, 34.03594], [-118.86592, 34.03571], [-118.86878, 34.03637], [-118.86946, 34.03654]]], [[[-118.86709, 34.03642], [-118.86702, 34.03661], [-118.86684, 34.03656], [-118.86691, 34.03636], [-118.86709, 34.03642]]]]} | Open Access 1 | 3873 | Lechuza Beach | 21128 | 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.287 | Lechuza Beach | 0 | Local Park 2 | 4 | |
7419 | 7419 | 7418 | {"type": "MultiPolygon", "coordinates": [[[[-118.21146, 34.09879], [-118.21115, 34.09901], [-118.21029, 34.09818], [-118.21037, 34.0981], [-118.21019, 34.09794], [-118.21044, 34.09773], [-118.21054, 34.0978], [-118.21078, 34.0979], [-118.21109, 34.09815], [-118.21137, 34.09856], [-118.21146, 34.09879]]], [[[-118.21383, 34.10142], [-118.21382, 34.10174], [-118.21354, 34.10186], [-118.21353, 34.10171], [-118.2133, 34.10134], [-118.21263, 34.10094], [-118.21266, 34.10092], [-118.21253, 34.10075], [-118.21251, 34.10076], [-118.21242, 34.10048], [-118.21257, 34.10041], [-118.21253, 34.10028], [-118.21246, 34.10017], [-118.21231, 34.10022], [-118.21215, 34.09998], [-118.21181, 34.09966], [-118.21142, 34.09952], [-118.21125, 34.09928], [-118.21127, 34.09904], [-118.21147, 34.09898], [-118.2116, 34.09914], [-118.21263, 34.10009], [-118.21291, 34.10074], [-118.21365, 34.10135], [-118.21371, 34.10147], [-118.21383, 34.10142]]], [[[-118.2138, 34.10064], [-118.21391, 34.10081], [-118.21392, 34.10086], [-118.21386, 34.1012], [-118.21385, 34.10121], [-118.21383, 34.1012], [-118.2136, 34.10071], [-118.2138, 34.10064]]]]} | Open Access 1 | 6859 | Rainbow Canyon Park | 24084 | 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.762 | Rainbow Canyon Park | 0 | Local Park 2 | 4 | |
8430 | 8430 | 8429 | {"type": "Polygon", "coordinates": [[[-118.24826, 34.10728], [-118.24782, 34.10776], [-118.24662, 34.10738], [-118.24607, 34.10715], [-118.24571, 34.10698], [-118.24595, 34.10654], [-118.24634, 34.10669], [-118.24658, 34.10644], [-118.2469, 34.10665], [-118.24736, 34.10618], [-118.24816, 34.10671], [-118.24788, 34.10706], [-118.24826, 34.10728]]]} | Open Access 1 | 47966 | Lewis MacAdams Riverfront Park | 32845 | 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 | 5.449 | Lewis MacAdams Riverfront Park | 0 | Local Park 2 | 4 | |
6944 | 6944 | 6943 | {"type": "Polygon", "coordinates": [[[-118.51425, 34.12874], [-118.51314, 34.12885], [-118.51295, 34.12889], [-118.51277, 34.12897], [-118.51247, 34.12916], [-118.51234, 34.12922], [-118.5122, 34.12925], [-118.51188, 34.12928], [-118.51171, 34.12932], [-118.51174, 34.12898], [-118.51348, 34.12757], [-118.51357, 34.12725], [-118.51425, 34.12725], [-118.51425, 34.12874]]]} | Open Access 1 | 6365 | San Vicente Mountain Park | 29687 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 6.37 | San Vicente Mtn. Park | 0 | Local Park 2 | 4 | |
7438 | 7438 | 7437 | {"type": "Polygon", "coordinates": [[[-118.22577, 34.08439], [-118.22566, 34.08489], [-118.22559, 34.0853], [-118.22555, 34.08575], [-118.22553, 34.08633], [-118.22551, 34.08637], [-118.22547, 34.08639], [-118.22539, 34.08637], [-118.22356, 34.08469], [-118.22388, 34.08444], [-118.22366, 34.08423], [-118.2238, 34.08412], [-118.22386, 34.08411], [-118.22391, 34.08411], [-118.22436, 34.08452], [-118.22478, 34.08421], [-118.22577, 34.08439]]]} | Open Access 1 | 6923 | Los Angeles River Center and Gardens | 21500 | 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 | 6.707 | Los Angeles River Ctr. and Gardens | 0 | Local Park 2 | 4 | |
6417 | 6417 | 6416 | {"type": "MultiPolygon", "coordinates": [[[[-118.89473, 34.21447], [-118.89445, 34.2146], [-118.89465, 34.21486], [-118.89456, 34.2149], [-118.89436, 34.21465], [-118.89319, 34.21474], [-118.8928, 34.21512], [-118.8925, 34.21513], [-118.89204, 34.21538], [-118.89186, 34.21598], [-118.89239, 34.21615], [-118.89262, 34.21624], [-118.89253, 34.21641], [-118.89193, 34.21619], [-118.89148, 34.21609], [-118.89124, 34.21606], [-118.89211, 34.21436], [-118.89399, 34.21415], [-118.89473, 34.21447]]], [[[-118.89674, 34.22032], [-118.89639, 34.22051], [-118.89655, 34.22071], [-118.89649, 34.22074], [-118.89633, 34.22055], [-118.89604, 34.22071], [-118.8962, 34.22103], [-118.89609, 34.22114], [-118.89592, 34.22102], [-118.89575, 34.22106], [-118.89541, 34.2212], [-118.89534, 34.22135], [-118.89552, 34.22202], [-118.89583, 34.22198], [-118.89584, 34.22208], [-118.89553, 34.2221], [-118.89358, 34.22214], [-118.89264, 34.22258], [-118.89254, 34.22244], [-118.89371, 34.22194], [-118.89415, 34.2218], [-118.89493, 34.22129], [-118.89529, 34.22103], [-118.89628, 34.22042], [-118.89651, 34.22037], [-118.89669, 34.22026], [-118.89674, 34.22032]]]]} | Open Access 1 | 1888 | Wildwood Park | 2635 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.crpd.org/parkfac/parks/wildwood.asp | Ventura 8 | 9.944 | Wildwood Park | 0 | Local Park 2 | 4 |
9484 | 9484 | 9483 | {"type": "MultiPolygon", "coordinates": [[[[-118.3565, 34.11322], [-118.35646, 34.11335], [-118.35625, 34.11361], [-118.35628, 34.11372], [-118.35595, 34.11393], [-118.35588, 34.11402], [-118.35578, 34.11422], [-118.35564, 34.11432], [-118.35397, 34.11366], [-118.35456, 34.11268], [-118.35482, 34.11246], [-118.35648, 34.11247], [-118.35643, 34.11269], [-118.35634, 34.11317], [-118.3565, 34.11322]]], [[[-118.35543, 34.11456], [-118.35533, 34.11513], [-118.35528, 34.11523], [-118.35444, 34.11562], [-118.35425, 34.11566], [-118.35417, 34.11565], [-118.35426, 34.11513], [-118.35482, 34.11485], [-118.35486, 34.11459], [-118.35493, 34.11444], [-118.35515, 34.11442], [-118.35543, 34.11456]]]]} | Open Access 1 | 47827 | Runyon Canyon Park | 24732 | 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 | 10.167 | Runyon Canyon Park | 0 | Local Park 2 | 4 | |
115 | 115 | 114 | {"type": "Polygon", "coordinates": [[[-118.77562, 34.03262], [-118.77533, 34.03337], [-118.77526, 34.03417], [-118.77391, 34.03402], [-118.77397, 34.03297], [-118.77225, 34.0325], [-118.77235, 34.03205], [-118.77242, 34.03192], [-118.7725, 34.03184], [-118.7726, 34.03179], [-118.77271, 34.03175], [-118.77283, 34.03174], [-118.773, 34.03177], [-118.77369, 34.03203], [-118.77383, 34.03206], [-118.77404, 34.03206], [-118.77425, 34.03201], [-118.77476, 34.03219], [-118.77512, 34.0325], [-118.77562, 34.03262]]]} | Open Access 1 | 345 | Escondido Canyon Park | 29611 | 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 | 10.379 | Escondido Canyon Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);