units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
155 rows where COUNTY = 6, DES_TP = 2 and LAYER = 4
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 42
- Whittier, City of 18
- Los Angeles Unified School District 15
- Manhattan Beach, City of 8
- Arcadia, City of 7
- Beverly Hills, City of 5
- Miraleste Recreation and Park District 5
- Los Angeles, City of 4
- Azusa Unified School District 4
- Palmdale, City of 3
- Port of Los Angeles 3
- Pasadena, City of 3
- Santa Clarita, City of 3
- Lawndale, City of 3
- Glendora, City of 2
- Sierra Madre, City of 2
- Bellflower, City of 2
- South El Monte, City of 2
- San Gabriel Unified School District 2
- Los Nietos School District 2
- Los Angeles, County of 1
- Rosemead, City of 1
- Azusa, City of 1
- Los Angeles - Department of Parks and Recreation, County of 1
- Paramount, City of 1
- Rancho Palos Verdes, City of 1
- Hawthorne, City of 1
- Monrovia, City of 1
- Calabasas, City of 1
- Duarte, City of 1
- …
MNG_AG_TYP 10
ACCESS_TYP 4
DES_TP 1
- Local Park · 155 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
347 | 347 | 346 | {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} | Restricted Access 2 | 953 | George Manooshian Park | 29754 | 2312 | Glendora Unified School District 141 | Special District 4 | School District 14 | http://www.glendora.k12.ca.us/ | Special District 4 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 18.865 | George Manooshian Park | 0 | Local Park 2 | 4 | |
413 | 413 | 412 | {"type": "Polygon", "coordinates": [[[-118.60477, 34.27717], [-118.60418, 34.27703], [-118.60318, 34.2767], [-118.60222, 34.27647], [-118.60128, 34.2759], [-118.59886, 34.27528], [-118.59773, 34.27477], [-118.5968, 34.27437], [-118.59644, 34.27429], [-118.59687, 34.27384], [-118.59763, 34.27384], [-118.59817, 34.27352], [-118.59822, 34.27339], [-118.59913, 34.27345], [-118.59979, 34.27347], [-118.60035, 34.2736], [-118.60064, 34.27325], [-118.60057, 34.27261], [-118.60272, 34.2726], [-118.60273, 34.27228], [-118.60457, 34.27224], [-118.60449, 34.27236], [-118.60431, 34.27294], [-118.60432, 34.27441], [-118.60439, 34.27467], [-118.60448, 34.27485], [-118.60448, 34.27491], [-118.60457, 34.27492], [-118.60477, 34.27613], [-118.60481, 34.27645], [-118.60482, 34.27667], [-118.6048, 34.27695], [-118.60477, 34.27717]]]} | Open Access 1 | 831 | Stoney Point Park | 30273 | 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 | 55.047 | Stoney Point Park | 0 | Local Park 2 | 4 | |
415 | 415 | 414 | {"type": "Polygon", "coordinates": [[[-118.21396, 34.10912], [-118.21373, 34.10945], [-118.21319, 34.10986], [-118.21289, 34.11018], [-118.21235, 34.11095], [-118.21288, 34.11156], [-118.21273, 34.11194], [-118.21216, 34.11203], [-118.21173, 34.11207], [-118.21061, 34.11072], [-118.21136, 34.11055], [-118.21098, 34.11009], [-118.21022, 34.11025], [-118.21011, 34.11013], [-118.21088, 34.10996], [-118.21117, 34.10978], [-118.2106, 34.10917], [-118.21198, 34.10827], [-118.21371, 34.10856], [-118.2137, 34.10865], [-118.21396, 34.10912]]]} | Open Access 1 | 1647 | Heidelberg Park | 19791 | 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 | 18.734 | Heidelberg Park | 0 | Local Park 2 | 4 | |
938 | 938 | 937 | {"type": "MultiPolygon", "coordinates": [[[[-118.69792, 34.10714], [-118.69353, 34.10711], [-118.68501, 34.10711], [-118.68487, 34.09988], [-118.69337, 34.09987], [-118.69287, 34.10126], [-118.69282, 34.10153], [-118.69283, 34.10168], [-118.69285, 34.10183], [-118.69297, 34.10211], [-118.69307, 34.10225], [-118.69318, 34.10237], [-118.69338, 34.10253], [-118.69352, 34.10262], [-118.69383, 34.10273], [-118.69404, 34.10277], [-118.69426, 34.10279], [-118.69447, 34.10278], [-118.69662, 34.10254], [-118.69692, 34.10254], [-118.69721, 34.10256], [-118.69791, 34.10269], [-118.69792, 34.10714]]], [[[-118.71106, 34.10003], [-118.711, 34.10008], [-118.711, 34.1006], [-118.71099, 34.10061], [-118.71099, 34.10066], [-118.711, 34.10067], [-118.71101, 34.10229], [-118.70867, 34.10291], [-118.70755, 34.10261], [-118.70751, 34.10269], [-118.70732, 34.10264], [-118.70735, 34.10256], [-118.70735, 34.10227], [-118.70701, 34.10227], [-118.70646, 34.10285], [-118.70647, 34.10286], [-118.70927, 34.1046], [-118.70848, 34.10476], [-118.70774, 34.10486], [-118.70724, 34.10489], [-118.70674, 34.10489], [-118.706, 34.10485], [-118.70526, 34.10476], [-118.70453, 34.1046], [-118.70406, 34.10447], [-118.70337, 34.10423], [-118.70141, 34.10334], [-118.70104, 34.10319], [-118.70066, 34.10306], [-118.70008, 34.10291], [-118.69741, 34.10236], [-118.69709, 34.10233], [-118.69661, 34.10232], [-118.69444, 34.10256], [-118.69422, 34.10257], [-118.69401, 34.10254], [-118.69371, 34.10245], [-118.69353, 34.10235], [-118.69339, 34.10223], [-118.69327, 34.1021], [-118.69318, 34.10195], [-118.69312, 34.10179], [-118.6931, 34.10163], [-118.6931, 34.10146], [-118.69314, 34.1013], [-118.69364, 34.09988], [-118.70399, 34.09987], [-118.7067, 34.09985], [-118.71106, 34.0999], [-118.71106, 34.10003]]], [[[-118.70669, 34.09625], [-118.7023, 34.09625], [-118.70229, 34.09806], [-118.70011, 34.09807], [-118.7001, 34.09625], [-118.70228, 34.09625], [-118.70228, 34.09551], [-118.70342, 34.09546], [-118.70406, 34.09465], [-118.70491, 34.09451], [-118.70605, 34.09381], [-118.70636, 34.09308], [-118.70669, 34.09361], [-118.70669, 34.09625]]], [[[-118.70669, 34.09336], [-118.70649, 34.09304], [-118.70669, 34.09297], [-118.70669, 34.09329], [-118.70669, 34.09336]]]]} | Open Access 1 | 6489 | King Gillette Ranch | 7140 | 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 | http://www.lamountains.com/parks.asp?parkid=670 | Los Angeles 6 | 383.837 | King Gillette Ranch | 0 | Local Park 2 | 4 |
944 | 944 | 943 | {"type": "Polygon", "coordinates": [[[-118.31116, 33.76052], [-118.31051, 33.76273], [-118.30904, 33.76256], [-118.30904, 33.76051], [-118.31116, 33.76052]]]} | Open Access 1 | 5973 | Eastview Park | 18401 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 9.81 | Eastview Park | 0 | Local Park 2 | 4 | |
1082 | 1082 | 1081 | {"type": "Polygon", "coordinates": [[[-118.63078, 34.13573], [-118.63037, 34.13633], [-118.6238, 34.13634], [-118.6238, 34.13271], [-118.62865, 34.13271], [-118.62873, 34.1328], [-118.6287, 34.13306], [-118.62899, 34.1332], [-118.62924, 34.13362], [-118.62944, 34.13379], [-118.62951, 34.13395], [-118.6297, 34.13402], [-118.62991, 34.13418], [-118.63012, 34.13424], [-118.63017, 34.13442], [-118.63028, 34.13455], [-118.63032, 34.13484], [-118.63051, 34.13517], [-118.63078, 34.13573]]]} | Open Access 1 | 6457 | Dry Creek Canyon Park | 29796 | 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 | 56.278 | Dry Creek Canyon Park | 0 | Local Park 2 | 4 | |
1705 | 1705 | 1704 | {"type": "Polygon", "coordinates": [[[-118.06777, 33.99672], [-118.06723, 33.99773], [-118.06591, 33.99683], [-118.06669, 33.996], [-118.06777, 33.99672]]]} | Open Access 1 | 6543 | Guirado Park | 19564 | 2125 | Rose Hills Memorial Park Association 412 | Special District 4 | Cemetery District 11 | http://www.rosehills.com/ | Special District 4 | 2125 | Rose Hills Memorial Park Association 406 | Special District 4 | Cemetery District 11 | Los Angeles 6 | 4.169 | Guirado Park | 0 | Local Park 2 | 4 | |
1711 | 1711 | 1710 | {"type": "MultiPolygon", "coordinates": [[[[-117.75671, 34.13628], [-117.75616, 34.13503], [-117.75433, 34.13264], [-117.75496, 34.13229], [-117.75515, 34.13228], [-117.75538, 34.13231], [-117.75558, 34.13237], [-117.75577, 34.13247], [-117.7559, 34.13258], [-117.756, 34.1327], [-117.75602, 34.1327], [-117.75598, 34.13277], [-117.75599, 34.13287], [-117.75608, 34.13297], [-117.75617, 34.13316], [-117.75628, 34.13334], [-117.75649, 34.13358], [-117.75668, 34.13374], [-117.75692, 34.13388], [-117.75719, 34.13399], [-117.75749, 34.13408], [-117.75752, 34.1341], [-117.75671, 34.13628]]], [[[-117.75871, 34.13267], [-117.75854, 34.13285], [-117.75791, 34.13333], [-117.75789, 34.13339], [-117.7577, 34.13366], [-117.75762, 34.13385], [-117.75758, 34.13387], [-117.75731, 34.1338], [-117.75708, 34.1337], [-117.75687, 34.13358], [-117.75668, 34.13343], [-117.75651, 34.13324], [-117.75639, 34.13303], [-117.75634, 34.13292], [-117.75637, 34.13283], [-117.75637, 34.13278], [-117.75632, 34.1327], [-117.75737, 34.13269], [-117.75791, 34.13213], [-117.75871, 34.13267]]]]} | Open Access 1 | 12847 | Live Oak Park | 21373 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 2078 | Metropolitan Water District of Southern California 407 | Special District 4 | Water District 13 | Los Angeles 6 | 16.964 | Live Oak Park | 0 | Local Park 2 | 4 | |
1933 | 1933 | 1932 | {"type": "Polygon", "coordinates": [[[-118.39025, 33.81526], [-118.39021, 33.81551], [-118.3901, 33.81537], [-118.38993, 33.81522], [-118.39025, 33.81526]]]} | Open Access 1 | 5984 | Miramar Park | 22287 | 2158 | South Bay Cities Sanitation District 455 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 2158 | South Bay Cities Sanitation District 449 | Special District 4 | Sanitation District 19 | Los Angeles 6 | 0.094 | Miramar Park | 0 | Local Park 2 | 4 | |
2813 | 2813 | 2812 | {"type": "Polygon", "coordinates": [[[-118.60192, 34.30954], [-118.5977, 34.30949], [-118.59761, 34.30585], [-118.60185, 34.30584], [-118.60192, 34.30954]]]} | Open Access 1 | 12864 | MRCA Parkland | 22570 | 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 | 39.114 | MRCA Parkland | 0 | Local Park 2 | 4 | |
3314 | 3314 | 3313 | {"type": "Polygon", "coordinates": [[[-118.64407, 34.17777], [-118.64325, 34.17777], [-118.64319, 34.17773], [-118.64316, 34.17565], [-118.6432, 34.1756], [-118.64385, 34.17559], [-118.64406, 34.17557], [-118.64407, 34.17777]]]} | Restricted Access 2 | 46863 | Hale Middle School Park | 31933 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | Los Angeles 6 | 4.875 | Hale Middle School Park | 0 | Local Park 2 | 4 | |
3315 | 3315 | 3314 | {"type": "Polygon", "coordinates": [[[-118.64398, 34.17228], [-118.64364, 34.17254], [-118.64342, 34.17277], [-118.64336, 34.17279], [-118.64174, 34.17195], [-118.64141, 34.17184], [-118.64117, 34.17179], [-118.64091, 34.17176], [-118.64087, 34.17171], [-118.64087, 34.17063], [-118.64304, 34.17156], [-118.64323, 34.17156], [-118.64367, 34.17194], [-118.64398, 34.17228]]]} | Restricted Access 2 | 46867 | El Camino Real High School Park | 31936 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | Los Angeles 6 | 7.345 | El Camino Real High School Park | 0 | Local Park 2 | 4 | |
3545 | 3545 | 3544 | {"type": "Polygon", "coordinates": [[[-118.04485, 34.04282], [-118.04349, 34.04401], [-118.04261, 34.04329], [-118.04286, 34.04329], [-118.04283, 34.04288], [-118.04383, 34.04199], [-118.0448, 34.04278], [-118.04482, 34.04281], [-118.04485, 34.04282]]]} | Restricted Access 2 | 20607 | New Temple Park | 31632 | 2383 | Valle Lindo Unified School District 658 | Special District 4 | School District 14 | http://www.vallelindo.k12.ca.us/ | Special District 4 | 1402 | South El Monte, City of 595 | City 2 | City Agency 2 | Los Angeles 6 | 5.682 | New Temple Park | 0 | Local Park 2 | 4 | |
3663 | 3663 | 3662 | {"type": "Polygon", "coordinates": [[[-118.35756, 33.87843], [-118.35626, 33.87843], [-118.35625, 33.87755], [-118.3565, 33.87755], [-118.35651, 33.87731], [-118.35663, 33.87731], [-118.35663, 33.87709], [-118.35756, 33.87709], [-118.35756, 33.87843]]]} | Restricted Access 2 | 44123 | William Green Park | 27544 | 2396 | Lawndale Elementary School District 670 | Special District 4 | School District 14 | http://www.lawndale.k12.ca.us/ | Special District 4 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ASSETS/PDF/Parks/williamgreenpark.pdf | Los Angeles 6 | 4.064 | William Green Park | 0 | Local Park 2 | 4 |
3922 | 3922 | 3921 | {"type": "Polygon", "coordinates": [[[-118.17903, 34.59426], [-118.17429, 34.59426], [-118.17423, 34.59106], [-118.17426, 34.59084], [-118.17426, 34.59041], [-118.17434, 34.59034], [-118.17507, 34.59036], [-118.17509, 34.59034], [-118.17895, 34.59035], [-118.17903, 34.59426]]]} | Restricted Access 2 | 46141 | Highland High School Park | 31877 | 2388 | Antelope Valley Union High School District 698 | Special District 4 | School District 14 | http://www.avdistrict.org/ | Special District 4 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | Los Angeles 6 | 46.587 | Highland High School Park | 0 | Local Park 2 | 4 | |
3932 | 3932 | 3931 | {"type": "Polygon", "coordinates": [[[-118.4757, 34.42905], [-118.47423, 34.42905], [-118.4742, 34.42839], [-118.47412, 34.42835], [-118.47409, 34.42733], [-118.47558, 34.42732], [-118.47558, 34.42796], [-118.47557, 34.42802], [-118.47558, 34.42841], [-118.47568, 34.42842], [-118.4757, 34.42905]]]} | Restricted Access 2 | 46226 | North Oaks Park | 31633 | 2389 | William S. Hart Union High School District 702 | Special District 4 | School District 14 | http://www.hartdistrict.org/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=413 | Los Angeles 6 | 6.399 | North Oaks Park | 0 | Local Park 2 | 4 |
3963 | 3963 | 3962 | {"type": "Polygon", "coordinates": [[[-118.10299, 34.1077], [-118.1021, 34.1077], [-118.10206, 34.10769], [-118.10203, 34.1063], [-118.10278, 34.10629], [-118.10278, 34.10728], [-118.10298, 34.10729], [-118.10299, 34.1077]]]} | Restricted Access 2 | 46471 | Washington School Park | 32680 | 2393 | San Gabriel Unified School District 706 | Special District 4 | School District 14 | http://www.sgusd.k12.ca.us/ | Special District 4 | 2393 | San Gabriel Unified School District 693 | Special District 4 | School District 21 | Los Angeles 6 | 2.827 | Washington School Park | 0 | Local Park 2 | 4 | |
3975 | 3975 | 3974 | {"type": "Polygon", "coordinates": [[[-118.01891, 33.96032], [-118.01812, 33.96131], [-118.01618, 33.96022], [-118.01659, 33.95971], [-118.01891, 33.96032]]]} | Restricted Access 2 | 46582 | Ocean View Elementary School Park | 31920 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 5.333 | Ocean View Elementary School Park | 0 | Local Park 2 | 4 | |
3978 | 3978 | 3977 | {"type": "Polygon", "coordinates": [[[-118.05658, 34.16669], [-118.05578, 34.16669], [-118.05577, 34.16573], [-118.05657, 34.16571], [-118.05658, 34.16669]]]} | Restricted Access 2 | 46602 | Sierra Madre Elementary School Park | 31924 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 1.948 | Sierra Madre Elementary School Park | 0 | Local Park 2 | 4 | |
4236 | 4236 | 4235 | {"type": "Polygon", "coordinates": [[[-117.89955, 34.13086], [-117.89865, 34.13086], [-117.89864, 34.13131], [-117.89633, 34.1313], [-117.89633, 34.13075], [-117.89641, 34.13075], [-117.8965, 34.13064], [-117.89807, 34.12999], [-117.89819, 34.12996], [-117.89829, 34.1299], [-117.89904, 34.1299], [-117.89906, 34.13045], [-117.89953, 34.13046], [-117.89955, 34.13086]]]} | Restricted Access 2 | 47860 | Charles Lee Elementary School Park | 31944 | 2365 | Azusa Unified School District 736 | Special District 4 | School District 14 | https://ausd-ca.schoolloop.com/ | Special District 4 | 2365 | Azusa Unified School District 720 | Special District 4 | School District 21 | Los Angeles 6 | 7.662 | Charles Lee Elementary School 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]);