units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24
This data as json, copyable, CSV (advanced)
DES_TP 14
- Local Park 96
- Local Recreation Area 59
- Local Other or Unknown 6
- National Forest 1
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
- Open Access 151
- Restricted Access 12
- No Public Access 9
MNG_AG_TYP 1
- City Agency 172
MNG_AGENCY 1
- Los Angeles, City of · 172 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8208 | 8208 | 8207 | {"type": "MultiPolygon", "coordinates": [[[[-118.34152, 34.1213], [-118.34152, 34.12134], [-118.34148, 34.12139], [-118.34142, 34.1215], [-118.34141, 34.12163], [-118.34115, 34.12183], [-118.34097, 34.12159], [-118.34146, 34.12124], [-118.34152, 34.1213]]], [[[-118.34202, 34.12109], [-118.34195, 34.12117], [-118.3418, 34.12119], [-118.34166, 34.12124], [-118.34159, 34.12124], [-118.34154, 34.12118], [-118.34192, 34.1209], [-118.34202, 34.121], [-118.34202, 34.12109]]]]} | No Public Access 3 | 12463 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.578 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8209 | 8209 | 8208 | {"type": "Polygon", "coordinates": [[[-118.34266, 34.12073], [-118.34239, 34.12092], [-118.34236, 34.12088], [-118.34217, 34.12072], [-118.3424, 34.12055], [-118.34256, 34.12064], [-118.34266, 34.12073]]]} | No Public Access 3 | 12464 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.23 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8211 | 8211 | 8210 | {"type": "MultiPolygon", "coordinates": [[[[-118.22394, 34.01724], [-118.22332, 34.01724], [-118.22326, 34.01718], [-118.22339, 34.01692], [-118.22343, 34.01692], [-118.22354, 34.01703], [-118.22355, 34.01702], [-118.22353, 34.01692], [-118.22386, 34.01691], [-118.22394, 34.01724]]], [[[-118.22583, 34.0794], [-118.22575, 34.07921], [-118.22576, 34.0792], [-118.2258, 34.07917], [-118.22584, 34.0794], [-118.22601, 34.07938], [-118.22623, 34.07981], [-118.2261, 34.07992], [-118.22583, 34.0794]]]]} | No Public Access 3 | 12471 | Los Angeles River | 21498 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.706 | Los Angeles River | 0 | None 684 | ||
8264 | 8264 | 8263 | {"type": "Polygon", "coordinates": [[[-118.38077, 34.1079], [-118.38075, 34.10838], [-118.38056, 34.10851], [-118.3804, 34.10844], [-118.38058, 34.10801], [-118.38077, 34.1079]]]} | No Public Access 3 | 12810 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.337 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
8271 | 8271 | 8270 | {"type": "Polygon", "coordinates": [[[-118.26732, 34.09326], [-118.26728, 34.09328], [-118.26706, 34.09327], [-118.26693, 34.09329], [-118.26678, 34.09335], [-118.26666, 34.09344], [-118.26648, 34.09369], [-118.26625, 34.09394], [-118.26615, 34.0941], [-118.26608, 34.09428], [-118.26604, 34.09456], [-118.26599, 34.09467], [-118.26588, 34.0948], [-118.26568, 34.09491], [-118.2656, 34.09498], [-118.26552, 34.09509], [-118.26549, 34.09521], [-118.26551, 34.09537], [-118.26555, 34.09546], [-118.26562, 34.09553], [-118.26574, 34.09561], [-118.26592, 34.09568], [-118.26592, 34.09572], [-118.266, 34.09572], [-118.2661, 34.09577], [-118.26628, 34.09592], [-118.26639, 34.0961], [-118.26644, 34.09629], [-118.26645, 34.1041], [-118.26392, 34.1041], [-118.26111, 34.10034], [-118.26118, 34.10018], [-118.26119, 34.10003], [-118.2614, 34.09995], [-118.26172, 34.09933], [-118.26178, 34.09924], [-118.26189, 34.09916], [-118.26213, 34.09908], [-118.26229, 34.09907], [-118.2627, 34.09926], [-118.26271, 34.09926], [-118.26209, 34.09818], [-118.26187, 34.09749], [-118.26183, 34.09659], [-118.26229, 34.09573], [-118.26228, 34.09572], [-118.262, 34.09572], [-118.26233, 34.09515], [-118.26246, 34.09497], [-118.26262, 34.0948], [-118.2633, 34.09419], [-118.26345, 34.09402], [-118.26357, 34.09385], [-118.26372, 34.09356], [-118.2638, 34.09327], [-118.26383, 34.093], [-118.2638, 34.09263], [-118.26381, 34.09255], [-118.26402, 34.09221], [-118.26412, 34.09212], [-118.26425, 34.09204], [-118.26445, 34.09198], [-118.26462, 34.09197], [-118.26478, 34.092], [-118.26503, 34.09209], [-118.26517, 34.09212], [-118.26539, 34.09214], [-118.26559, 34.09211], [-118.26636, 34.09242], [-118.26676, 34.09258], [-118.26671, 34.09269], [-118.26672, 34.09272], [-118.26675, 34.09275], [-118.26741, 34.09302], [-118.26743, 34.09306], [-118.26743, 34.09311], [-118.26732, 34.09326]]]} | Open Access 1 | 12660 | Silver Lake Reservoir | 25489 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 117.771 | Silver Lake Reservoir | 0 | Local Recreation Area 3 | 4 | |
8277 | 8277 | 8276 | {"type": "Polygon", "coordinates": [[[-118.26691, 34.09233], [-118.26691, 34.09236], [-118.26676, 34.09258], [-118.2656, 34.09211], [-118.26575, 34.09207], [-118.26597, 34.09195], [-118.26602, 34.09195], [-118.26688, 34.09229], [-118.26691, 34.09233]]]} | Open Access 1 | 12659 | Silver Lake Recreation Center | 25488 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.877 | Silver Lake Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
8289 | 8289 | 8288 | {"type": "Polygon", "coordinates": [[[-118.24419, 34.05298], [-118.24418, 34.05301], [-118.24369, 34.05354], [-118.24285, 34.053], [-118.24336, 34.05246], [-118.24339, 34.05245], [-118.24343, 34.05246], [-118.24418, 34.05295], [-118.24419, 34.05298]]]} | Open Access 1 | 12890 | City Hall Park | 17295 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.917 | City Hall Park | 0 | Local Park 2 | 4 | |
8315 | 8315 | 8314 | {"type": "Polygon", "coordinates": [[[-118.24766, 33.99401], [-118.24764, 33.99479], [-118.24576, 33.99477], [-118.24571, 33.99393], [-118.24766, 33.99401]]]} | Open Access 1 | 12785 | Slauson Playground | 25554 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.929 | Slauson Playground | 0 | Local Recreation Area 3 | 4 | |
8326 | 8326 | 8325 | {"type": "Polygon", "coordinates": [[[-118.38131, 34.10838], [-118.38103, 34.10855], [-118.38075, 34.10838], [-118.38077, 34.1079], [-118.38091, 34.10781], [-118.38131, 34.10838]]]} | No Public Access 3 | 12808 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.602 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
8327 | 8327 | 8326 | {"type": "Polygon", "coordinates": [[[-118.38766, 34.10102], [-118.38766, 34.10162], [-118.38733, 34.10162], [-118.38682, 34.10136], [-118.38679, 34.10134], [-118.3867, 34.10118], [-118.38646, 34.10102], [-118.38651, 34.10098], [-118.38678, 34.10116], [-118.38686, 34.10109], [-118.38711, 34.10102], [-118.38766, 34.10102]]]} | No Public Access 3 | 12811 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.168 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
8333 | 8333 | 8332 | {"type": "Polygon", "coordinates": [[[-118.28001, 34.03946], [-118.27946, 34.0403], [-118.27869, 34.03995], [-118.27897, 34.03953], [-118.27851, 34.03931], [-118.27878, 34.0389], [-118.28001, 34.03946]]]} | Open Access 1 | 14768 | Toberman Playground | 26380 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.743 | Toberman Playground | 0 | Local Recreation Area 3 | 4 | |
8354 | 8354 | 8353 | {"type": "MultiPolygon", "coordinates": [[[[-118.23804, 34.05665], [-118.23761, 34.05703], [-118.23757, 34.05704], [-118.23752, 34.05703], [-118.23751, 34.05698], [-118.23761, 34.05653], [-118.23783, 34.05657], [-118.23804, 34.05665]]], [[[-118.23804, 34.05645], [-118.23761, 34.05638], [-118.23763, 34.05623], [-118.23763, 34.05623], [-118.23804, 34.05645]]], [[[-118.23843, 34.05598], [-118.23816, 34.05631], [-118.23813, 34.05632], [-118.23806, 34.05631], [-118.23784, 34.05617], [-118.23768, 34.05611], [-118.23767, 34.05608], [-118.23775, 34.05566], [-118.23786, 34.05564], [-118.23797, 34.05568], [-118.23843, 34.05598]]], [[[-118.23875, 34.05625], [-118.23891, 34.05628], [-118.23901, 34.05635], [-118.23907, 34.05644], [-118.23909, 34.05655], [-118.23906, 34.05667], [-118.23897, 34.05676], [-118.23885, 34.05682], [-118.23872, 34.05683], [-118.23858, 34.0568], [-118.23849, 34.05673], [-118.23842, 34.05664], [-118.2384, 34.05653], [-118.23842, 34.05643], [-118.2385, 34.05634], [-118.23861, 34.05627], [-118.23875, 34.05625]]]]} | Open Access 1 | 12941 | El Pueblo de Los Angeles Historic Monument | 28788 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.002 | El Pueblo de Los Angeles Historic Monument | 0 | Local Historic or Cultural Area 19 | 4 | |
8362 | 8362 | 8361 | {"type": "Polygon", "coordinates": [[[-118.44535, 34.19576], [-118.44445, 34.19576], [-118.44445, 34.19409], [-118.44448, 34.19406], [-118.44451, 34.19405], [-118.44531, 34.19405], [-118.44534, 34.19407], [-118.44535, 34.19576]]]} | Open Access 1 | 14973 | Van Nuys Recreation Area | 26832 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.883 | Van Nuys Rec. Area | 0 | Local Recreation Area 3 | 4 | |
8716 | 8716 | 8715 | {"type": "MultiPolygon", "coordinates": [[[[-118.45874, 34.28886], [-118.45873, 34.2889], [-118.45862, 34.28897], [-118.45854, 34.28905], [-118.45848, 34.28915], [-118.45846, 34.28925], [-118.45846, 34.28935], [-118.45849, 34.28946], [-118.45874, 34.28981], [-118.45877, 34.2899], [-118.45877, 34.28999], [-118.45874, 34.29007], [-118.45868, 34.29014], [-118.45862, 34.29018], [-118.45807, 34.28943], [-118.45772, 34.28885], [-118.45786, 34.28811], [-118.45867, 34.28809], [-118.45865, 34.28839], [-118.45865, 34.28856], [-118.45868, 34.2887], [-118.45874, 34.28886]]], [[[-118.45951, 34.29016], [-118.45885, 34.2905], [-118.45872, 34.29032], [-118.45882, 34.29025], [-118.45891, 34.29015], [-118.45896, 34.29005], [-118.45897, 34.28995], [-118.45896, 34.28986], [-118.45893, 34.28977], [-118.4587, 34.28945], [-118.45866, 34.28935], [-118.45865, 34.28928], [-118.45867, 34.2892], [-118.45871, 34.28913], [-118.45878, 34.28907], [-118.45882, 34.28906], [-118.45886, 34.28908], [-118.45923, 34.2898], [-118.45936, 34.28998], [-118.45951, 34.29016]]], [[[-118.46323, 34.28869], [-118.46238, 34.28939], [-118.4623, 34.28936], [-118.46224, 34.28936], [-118.46217, 34.2892], [-118.46196, 34.28918], [-118.46128, 34.2895], [-118.4611, 34.28944], [-118.46074, 34.28949], [-118.4606, 34.28929], [-118.45965, 34.28971], [-118.45969, 34.29007], [-118.45954, 34.28992], [-118.45939, 34.2897], [-118.45891, 34.28877], [-118.45887, 34.28864], [-118.45885, 34.2885], [-118.45887, 34.28815], [-118.4589, 34.28812], [-118.4591, 34.28809], [-118.45928, 34.28802], [-118.45989, 34.28766], [-118.46004, 34.28759], [-118.46026, 34.28753], [-118.46094, 34.28746], [-118.46114, 34.28739], [-118.46128, 34.28732], [-118.46137, 34.28724], [-118.46143, 34.28723], [-118.46202, 34.28767], [-118.46323, 34.28869]]]]} | Open Access 1 | 14155 | Carey Ranch Park | 16849 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 21.694 | Carey Ranch Park | 0 | Local Park 2 | 4 | |
8727 | 8727 | 8726 | {"type": "Polygon", "coordinates": [[[-118.39038, 33.95618], [-118.38829, 33.95742], [-118.38755, 33.95655], [-118.38738, 33.95638], [-118.38718, 33.95624], [-118.38924, 33.95493], [-118.39038, 33.95618]]]} | Open Access 1 | 14169 | Carl E. Nielson Youth Park | 16852 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.lacity.org/ | Los Angeles 6 | 9.891 | Carl E. Nielson Youth Park | 0 | Local Park 2 | 4 |
8876 | 8876 | 8875 | {"type": "Polygon", "coordinates": [[[-118.40865, 34.21786], [-118.40539, 34.21786], [-118.4054, 34.21588], [-118.40546, 34.21584], [-118.40688, 34.21585], [-118.40856, 34.21746], [-118.40865, 34.21786]]]} | Open Access 1 | 14515 | Strathern Park North | 25909 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 12.718 | Strathern Park North | 0 | Local Park 2 | 4 | |
8882 | 8882 | 8881 | {"type": "Polygon", "coordinates": [[[-118.60611, 34.26878], [-118.60611, 34.26934], [-118.60608, 34.26959], [-118.60594, 34.27024], [-118.60589, 34.2704], [-118.60577, 34.27068], [-118.60558, 34.27109], [-118.60541, 34.27132], [-118.60497, 34.27197], [-118.60492, 34.27207], [-118.60295, 34.27218], [-118.60241, 34.27215], [-118.60187, 34.27206], [-118.60196, 34.27125], [-118.60202, 34.27092], [-118.60211, 34.2706], [-118.60224, 34.27028], [-118.60244, 34.26991], [-118.60264, 34.26961], [-118.60297, 34.2692], [-118.60317, 34.26902], [-118.60357, 34.26878], [-118.60611, 34.26878]]]} | Open Access 1 | 14510 | Stoney Point Park | 25899 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 28.627 | Stoney Point Park | 0 | Local Park 2 | 4 | |
8919 | 8919 | 8918 | {"type": "Polygon", "coordinates": [[[-118.44815, 34.30886], [-118.44673, 34.31012], [-118.44338, 34.30753], [-118.44481, 34.30626], [-118.44557, 34.30686], [-118.44815, 34.30886]]]} | Open Access 1 | 14632 | Sylmar Park | 26148 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 20.028 | Sylmar Park | 0 | Local Park 2 | 4 | |
8930 | 8930 | 8929 | {"type": "Polygon", "coordinates": [[[-118.63871, 34.21307], [-118.63869, 34.21311], [-118.63866, 34.21313], [-118.63789, 34.21313], [-118.63786, 34.2131], [-118.63785, 34.21263], [-118.63787, 34.21258], [-118.63794, 34.21251], [-118.63796, 34.21245], [-118.63794, 34.21239], [-118.63788, 34.21235], [-118.63788, 34.21192], [-118.63813, 34.21192], [-118.63863, 34.21197], [-118.63868, 34.21199], [-118.63871, 34.21307]]]} | Open Access 1 | 14674 | Taxco Trails Park | 26200 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.46 | Taxco Trails Park | 0 | Local Park 2 | 4 | |
8958 | 8958 | 8957 | {"type": "Polygon", "coordinates": [[[-118.65406, 34.20676], [-118.65402, 34.20707], [-118.65383, 34.20781], [-118.65381, 34.20784], [-118.65377, 34.20785], [-118.65337, 34.20778], [-118.65319, 34.20777], [-118.65295, 34.2078], [-118.65273, 34.20785], [-118.65253, 34.20746], [-118.65282, 34.20727], [-118.65308, 34.20706], [-118.65331, 34.20683], [-118.65352, 34.20659], [-118.65359, 34.20658], [-118.65381, 34.20667], [-118.65403, 34.20673], [-118.65406, 34.20676]]]} | Open Access 1 | 14757 | Castle Peak Park | 16953 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.037 | Castle Peak 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]);