units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where MNG_AGENCY = 143 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15170 | 15170 | 15169 | {"type": "Polygon", "coordinates": [[[-117.9074, 34.13175], [-117.9074, 34.13191], [-117.90694, 34.13191], [-117.90694, 34.13175], [-117.9074, 34.13175]]]} | Open Access 1 | 46032 | Edwards Park | 29357 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?nid=1230 | Los Angeles 6 | 0.189 | Edwards Park | 0 | Local Park 2 | 4 |
15190 | 15190 | 15189 | {"type": "Polygon", "coordinates": [[[-117.89233, 34.14306], [-117.89203, 34.14329], [-117.89181, 34.14353], [-117.89179, 34.14351], [-117.89178, 34.14347], [-117.89175, 34.14344], [-117.89176, 34.14342], [-117.8917, 34.14336], [-117.89168, 34.14331], [-117.89168, 34.14322], [-117.89174, 34.14315], [-117.89192, 34.14308], [-117.89222, 34.14306], [-117.89231, 34.14304], [-117.89233, 34.14306]]]} | Open Access 1 | 46061 | Olive Hill Park | 29403 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?nid=1260 | Los Angeles 6 | 0.349 | Olive Hill Park | 0 | Local Park 2 | 4 |
15189 | 15189 | 15188 | {"type": "Polygon", "coordinates": [[[-117.89697, 34.14633], [-117.89703, 34.14636], [-117.89704, 34.14639], [-117.89704, 34.14643], [-117.89699, 34.14652], [-117.89686, 34.14663], [-117.89668, 34.1467], [-117.8965, 34.1467], [-117.89637, 34.14666], [-117.89625, 34.14659], [-117.89621, 34.14655], [-117.89618, 34.1465], [-117.89619, 34.14646], [-117.89622, 34.14644], [-117.89643, 34.14637], [-117.89669, 34.14633], [-117.89697, 34.14633]]]} | Open Access 1 | 46060 | Oak Hill Park | 29402 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 0.593 | Oak Hill Park | 0 | Local Park 2 | 4 | |
15186 | 15186 | 15185 | {"type": "Polygon", "coordinates": [[[-117.90027, 34.14511], [-117.90027, 34.14515], [-117.90025, 34.14517], [-117.89993, 34.14529], [-117.89972, 34.14534], [-117.89967, 34.14532], [-117.89968, 34.14523], [-117.89983, 34.14464], [-117.89986, 34.14463], [-117.89993, 34.14464], [-117.90004, 34.1447], [-117.90027, 34.14511]]]} | Open Access 1 | 46057 | Citrus Grove Park | 29397 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?nid=1229 | Los Angeles 6 | 0.656 | Citrus Grove Park | 0 | Local Park 2 | 4 |
15185 | 15185 | 15184 | {"type": "Polygon", "coordinates": [[[-117.92597, 34.147], [-117.92573, 34.14717], [-117.9255, 34.14736], [-117.92514, 34.14778], [-117.92517, 34.14784], [-117.92511, 34.14789], [-117.92501, 34.14781], [-117.92472, 34.14769], [-117.92525, 34.1473], [-117.92536, 34.1472], [-117.92551, 34.14714], [-117.92559, 34.14715], [-117.9257, 34.14709], [-117.92597, 34.147]]]} | Open Access 1 | 46056 | Azusa Rockery | 29396 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/documentcenter/view/30083 | Los Angeles 6 | 0.67 | Azusa Rockery | None 1326 | ||
15180 | 15180 | 15179 | {"type": "Polygon", "coordinates": [[[-117.90199, 34.14495], [-117.9019, 34.14501], [-117.90172, 34.14521], [-117.90151, 34.14503], [-117.90138, 34.14481], [-117.90099, 34.14377], [-117.90127, 34.14368], [-117.90127, 34.14369], [-117.90118, 34.14374], [-117.90114, 34.14383], [-117.90122, 34.14412], [-117.9012, 34.14414], [-117.9012, 34.14423], [-117.90126, 34.14431], [-117.90125, 34.14437], [-117.90127, 34.14446], [-117.90134, 34.14451], [-117.90144, 34.14454], [-117.90179, 34.14443], [-117.90182, 34.14443], [-117.90185, 34.14447], [-117.90183, 34.14453], [-117.90167, 34.14466], [-117.90154, 34.14484], [-117.90155, 34.14492], [-117.90159, 34.145], [-117.90164, 34.14503], [-117.90168, 34.14503], [-117.9019, 34.14489], [-117.90195, 34.14489], [-117.90199, 34.14495]]]} | Open Access 1 | 46062 | Ridgeview Park | 29404 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?nid=1232 | Los Angeles 6 | 0.676 | Ridgeview Park | 0 | Local Park 2 | 4 |
4400 | 4400 | 4399 | {"type": "Polygon", "coordinates": [[[-117.90951, 34.14686], [-117.9095, 34.1481], [-117.90942, 34.14811], [-117.90929, 34.14758], [-117.90916, 34.14691], [-117.9092, 34.14685], [-117.90928, 34.14683], [-117.90951, 34.14683], [-117.90951, 34.14686]]]} | Open Access 1 | 46030 | Canyon Park | 29355 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 0.735 | Canyon Park | 0 | Local Park 2 | 4 | |
15187 | 15187 | 15186 | {"type": "Polygon", "coordinates": [[[-117.89078, 34.14552], [-117.89073, 34.14555], [-117.89071, 34.14558], [-117.89077, 34.14575], [-117.8907, 34.14574], [-117.89066, 34.14576], [-117.89061, 34.14581], [-117.89059, 34.14587], [-117.8906, 34.14594], [-117.89067, 34.146], [-117.89078, 34.14638], [-117.89071, 34.1464], [-117.89071, 34.14643], [-117.89054, 34.14644], [-117.89044, 34.1464], [-117.89038, 34.14635], [-117.89028, 34.14619], [-117.89024, 34.146], [-117.89026, 34.1458], [-117.89035, 34.14558], [-117.89053, 34.14536], [-117.89078, 34.14552]]]} | Open Access 1 | 46058 | Rancho Park | 29398 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?nid=1231 | Los Angeles 6 | 0.977 | Rancho Park | 0 | Local Park 2 | 4 |
15192 | 15192 | 15191 | {"type": "Polygon", "coordinates": [[[-117.89744, 34.14257], [-117.89752, 34.14257], [-117.89773, 34.14263], [-117.89788, 34.14272], [-117.89798, 34.14281], [-117.89807, 34.14294], [-117.8981, 34.14303], [-117.89809, 34.14314], [-117.89806, 34.14319], [-117.89802, 34.14324], [-117.89793, 34.14329], [-117.89784, 34.14331], [-117.89767, 34.14329], [-117.89747, 34.14323], [-117.89735, 34.14315], [-117.89726, 34.14307], [-117.89716, 34.14289], [-117.89714, 34.14283], [-117.89715, 34.14275], [-117.89719, 34.14267], [-117.89726, 34.14261], [-117.89735, 34.14258], [-117.89744, 34.14257]]]} | Open Access 1 | 46065 | Alisal Park | 29407 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?nid=1228 | Los Angeles 6 | 1.292 | Alisal Park | 0 | Local Park 2 | 4 |
15188 | 15188 | 15187 | {"type": "Polygon", "coordinates": [[[-117.90005, 34.14647], [-117.90002, 34.14658], [-117.89992, 34.14659], [-117.89981, 34.14669], [-117.89972, 34.14671], [-117.89884, 34.14671], [-117.89865, 34.14666], [-117.89864, 34.14658], [-117.89879, 34.14643], [-117.89904, 34.14612], [-117.89908, 34.1461], [-117.89968, 34.14636], [-117.90005, 34.14647]]]} | Open Access 1 | 46059 | Sierra Madre Park | 29400 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 1.326 | Sierra Madre Park | 0 | Local Park 2 | 4 | |
15270 | 15270 | 15269 | {"type": "Polygon", "coordinates": [[[-117.90259, 34.14702], [-117.90257, 34.14752], [-117.9016, 34.14798], [-117.9016, 34.14772], [-117.90149, 34.14756], [-117.90205, 34.14721], [-117.90234, 34.14708], [-117.90234, 34.14681], [-117.9024, 34.14683], [-117.90249, 34.14689], [-117.90253, 34.14694], [-117.90254, 34.14702], [-117.90259, 34.14702]]]} | Open Access 1 | 46455 | Craftsman Park | 32769 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 1.452 | Craftsman Park | 0 | Local Park 2 | 4 | |
15176 | 15176 | 15175 | {"type": "Polygon", "coordinates": [[[-117.91348, 34.12749], [-117.91348, 34.12799], [-117.91226, 34.12798], [-117.91226, 34.12749], [-117.91348, 34.12749]]]} | Open Access 1 | 46028 | Memorial Park North Recreation Center (NRC) | 29353 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=988 | Los Angeles 6 | 1.53 | Memorial Park North Rec. Ctr. (NRC) | 0 | Local Recreation Area 3 | 4 |
15279 | 15279 | 15278 | {"type": "Polygon", "coordinates": [[[-117.89601, 34.14862], [-117.89599, 34.14889], [-117.89594, 34.14888], [-117.8959, 34.14896], [-117.89536, 34.14884], [-117.8953, 34.1488], [-117.89525, 34.14888], [-117.8951, 34.14884], [-117.89497, 34.14883], [-117.89441, 34.14861], [-117.89423, 34.14849], [-117.89399, 34.14824], [-117.89408, 34.14822], [-117.89417, 34.14823], [-117.89529, 34.14852], [-117.89578, 34.1486], [-117.89601, 34.14862]]]} | Open Access 1 | 46456 | Summit Park | 32768 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 1.598 | Summit Park | 0 | Local Park 2 | 4 | |
3641 | 3641 | 3640 | {"type": "Polygon", "coordinates": [[[-117.89406, 34.16397], [-117.89267, 34.16401], [-117.89233, 34.1637], [-117.89222, 34.16349], [-117.89221, 34.16311], [-117.89406, 34.16397]]]} | Open Access 1 | 29516 | River Wilderness Park | 24431 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 1.847 | River Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
6923 | 6923 | 6922 | {"type": "MultiPolygon", "coordinates": [[[[-117.90605, 34.13526], [-117.90605, 34.13552], [-117.90506, 34.13579], [-117.90506, 34.1351], [-117.90559, 34.13511], [-117.9056, 34.13526], [-117.90605, 34.13526]]], [[[-117.90606, 34.13366], [-117.90606, 34.13407], [-117.90507, 34.13407], [-117.90507, 34.13366], [-117.90606, 34.13366]]]]} | Open Access 1 | 5817 | Veterans Freedom Park | 27020 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 2.22 | Veterans Freedom Park | 0 | Local Park 2 | 4 | |
1678 | 1678 | 1677 | {"type": "Polygon", "coordinates": [[[-117.90234, 34.13098], [-117.90097, 34.13097], [-117.90096, 34.13044], [-117.90019, 34.13043], [-117.9002, 34.13022], [-117.90096, 34.13023], [-117.90097, 34.12991], [-117.90234, 34.12992], [-117.90234, 34.13098]]]} | Open Access 1 | 12775 | Slauson Park | 25553 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 4.076 | Slauson Park | 0 | Local Park 2 | 4 | |
893 | 893 | 892 | {"type": "Polygon", "coordinates": [[[-117.90512, 34.14554], [-117.9051, 34.14659], [-117.90507, 34.14664], [-117.90497, 34.14665], [-117.90332, 34.14665], [-117.90332, 34.1466], [-117.90342, 34.14629], [-117.90377, 34.14598], [-117.90382, 34.14597], [-117.90387, 34.14587], [-117.904, 34.14577], [-117.90401, 34.14566], [-117.90398, 34.14557], [-117.904, 34.14553], [-117.90512, 34.14554]]]} | Open Access 1 | 5754 | Pioneer Park | 23718 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 4.093 | Pioneer Park | 0 | Local Park 2 | 4 | |
357 | 357 | 356 | {"type": "Polygon", "coordinates": [[[-117.90242, 34.11526], [-117.90241, 34.11696], [-117.90124, 34.11696], [-117.90125, 34.11535], [-117.90158, 34.11535], [-117.90207, 34.11526], [-117.90242, 34.11526]]]} | Open Access 1 | 1002 | Gladstone Park | 19305 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 4.901 | Gladstone Park | 0 | Local Park 2 | 4 | |
15172 | 15172 | 15171 | {"type": "MultiPolygon", "coordinates": [[[[-117.89442, 34.14248], [-117.89454, 34.14509], [-117.89452, 34.14512], [-117.89448, 34.14514], [-117.89397, 34.14515], [-117.89383, 34.14345], [-117.89388, 34.14339], [-117.89389, 34.14332], [-117.89387, 34.14326], [-117.89382, 34.14322], [-117.89371, 34.14297], [-117.89382, 34.14268], [-117.89379, 34.14245], [-117.89434, 34.14244], [-117.89442, 34.14248]]], [[[-117.89451, 34.14173], [-117.89441, 34.14199], [-117.89438, 34.14225], [-117.89433, 34.14229], [-117.89397, 34.14229], [-117.89392, 34.14225], [-117.8939, 34.14173], [-117.89451, 34.14173]]]]} | Open Access 1 | 46044 | Arroyo Park South | 29366 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 4.947 | Arroyo Park South | 0 | Local Park 2 | 4 | |
11455 | 11455 | 11454 | {"type": "MultiPolygon", "coordinates": [[[[-117.89231, 34.14567], [-117.89232, 34.14572], [-117.8923, 34.14577], [-117.89142, 34.14625], [-117.89109, 34.14638], [-117.89071, 34.14645], [-117.8907, 34.1464], [-117.89103, 34.14632], [-117.89133, 34.1462], [-117.89231, 34.14567]]], [[[-117.89398, 34.14516], [-117.89359, 34.14522], [-117.89327, 34.1453], [-117.89286, 34.14547], [-117.89251, 34.14565], [-117.89244, 34.14566], [-117.8924, 34.14562], [-117.89292, 34.14535], [-117.89329, 34.14521], [-117.89356, 34.14514], [-117.89398, 34.14508], [-117.89398, 34.14516]]], [[[-117.89576, 34.14528], [-117.89574, 34.14534], [-117.89568, 34.14536], [-117.89471, 34.14518], [-117.89471, 34.14509], [-117.89576, 34.14528]]], [[[-117.89689, 34.14547], [-117.89687, 34.14551], [-117.89683, 34.14554], [-117.89667, 34.14552], [-117.89591, 34.14538], [-117.89586, 34.14535], [-117.89585, 34.14531], [-117.89585, 34.14529], [-117.89689, 34.14547]]], [[[-117.90254, 34.14631], [-117.90253, 34.14657], [-117.9025, 34.14662], [-117.90232, 34.14665], [-117.90191, 34.14664], [-117.9005, 34.14647], [-117.90014, 34.1464], [-117.89976, 34.14628], [-117.89897, 34.14594], [-117.89854, 34.1458], [-117.89799, 34.14568], [-117.89706, 34.14557], [-117.89701, 34.14555], [-117.897, 34.1455], [-117.89703, 34.14549], [-117.89704, 34.14545], [-117.89839, 34.14551], [-117.8988, 34.1456], [-117.8993, 34.14573], [-117.89949, 34.14575], [-117.89971, 34.14575], [-117.8999, 34.14571], [-117.9001, 34.14566], [-117.90052, 34.14549], [-117.90053, 34.14551], [-117.90048, 34.14556], [-117.90024, 34.14565], [-117.90007, 34.1458], [-117.90006, 34.146], [-117.90009, 34.14604], [-117.90054, 34.14621], [-117.90061, 34.14626], [-117.90082, 34.14635], [-117.90087, 34.14629], [-117.90192, 34.14656], [-117.90237, 34.14653], [-117.90247, 34.14645], [-117.9025, 34.14635], [-117.90254, 34.14631]]], [[[-117.90512, 34.1467], [-117.90333, 34.14671], [-117.90319, 34.14669], [-117.9029, 34.14665], [-117.90281, 34.14655], [-117.90276, 34.14644], [-117.90281, 34.14643], [-117.90288, 34.14653], [-117.90298, 34.14659], [-117.90322, 34.14661], [-117.90335, 34.14655], [-117.90333, 34.14661], [-117.90334, 34.14665], [-117.90505, 34.14666], [-117.90509, 34.14664], [-117.90512, 34.1466], [-117.90512, 34.1467]]]]} | Open Access 1 | 48143 | Sierra Madre Walking Trail | 32674 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 4.955 | Sierra Madre Walking Trail | 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]);