units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where DES_TP = 2 and MNG_AGENCY = 322 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 32
MNG_AGENCY 1
- Santa Clarita, City of · 32 ✖
DES_TP 1
- Local Park · 32 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1297 | 1297 | 1296 | {"type": "Polygon", "coordinates": [[[-118.5452, 34.39992], [-118.54518, 34.40007], [-118.54511, 34.40016], [-118.54512, 34.40031], [-118.54511, 34.40039], [-118.54481, 34.40102], [-118.54462, 34.4013], [-118.54457, 34.40143], [-118.54453, 34.40157], [-118.5444, 34.40157], [-118.54422, 34.40153], [-118.54382, 34.40139], [-118.54351, 34.40121], [-118.54338, 34.40112], [-118.5432, 34.40096], [-118.54313, 34.40089], [-118.54486, 34.39997], [-118.54492, 34.39998], [-118.54516, 34.3999], [-118.5452, 34.39992]]]} | Open Access 1 | 7271 | Almendra Park | 15395 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 4.337 | Almendra Park | 0 | Local Park 2 | 4 | |
7586 | 7586 | 7585 | {"type": "Polygon", "coordinates": [[[-118.39597, 34.43856], [-118.39415, 34.43852], [-118.39416, 34.43766], [-118.39535, 34.4373], [-118.39547, 34.43749], [-118.39559, 34.43762], [-118.39566, 34.43772], [-118.39571, 34.43786], [-118.39571, 34.43806], [-118.39573, 34.43819], [-118.39584, 34.43841], [-118.39597, 34.43856]]]} | Open Access 1 | 7286 | Begonias Lane Park | 15956 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 4.192 | Begonias Lane Park | 0 | Local Park 2 | 4 | |
1144 | 1144 | 1143 | {"type": "Polygon", "coordinates": [[[-118.50693, 34.45383], [-118.50419, 34.45385], [-118.50418, 34.45232], [-118.50691, 34.4523], [-118.50693, 34.45383]]]} | Open Access 1 | 7283 | Bouquet Canyon Park | 16302 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 10.567 | Bouquet Canyon Park | 0 | Local Park 2 | 4 | |
10860 | 10860 | 10859 | {"type": "Polygon", "coordinates": [[[-118.55086, 34.42777], [-118.55071, 34.42814], [-118.55003, 34.42806], [-118.54982, 34.42802], [-118.54982, 34.428], [-118.54977, 34.42799], [-118.54976, 34.42802], [-118.54855, 34.42796], [-118.54655, 34.42794], [-118.54585, 34.42615], [-118.54604, 34.42614], [-118.54672, 34.42619], [-118.54707, 34.42614], [-118.54709, 34.42619], [-118.54768, 34.42609], [-118.54894, 34.42607], [-118.54869, 34.42636], [-118.55086, 34.42777]]]} | Open Access 1 | 20658 | Bridgeport Park | 16380 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 16.763 | Bridgeport Park | 0 | Local Park 2 | 4 | |
7582 | 7582 | 7581 | {"type": "Polygon", "coordinates": [[[-118.44384, 34.41824], [-118.44384, 34.42005], [-118.44302, 34.42005], [-118.4434, 34.41864], [-118.4434, 34.41856], [-118.44299, 34.41855], [-118.44289, 34.41857], [-118.44114, 34.41916], [-118.44113, 34.41991], [-118.44113, 34.42005], [-118.44117, 34.42006], [-118.44116, 34.42057], [-118.44077, 34.42049], [-118.44047, 34.42047], [-118.43976, 34.42049], [-118.43946, 34.42053], [-118.43928, 34.42006], [-118.43969, 34.42005], [-118.44045, 34.41837], [-118.44071, 34.41825], [-118.44153, 34.41795], [-118.44178, 34.41784], [-118.44211, 34.41765], [-118.44281, 34.41717], [-118.44314, 34.41761], [-118.44349, 34.41772], [-118.44373, 34.41794], [-118.44374, 34.41822], [-118.44384, 34.41824]]]} | Open Access 1 | 7276 | Canyon Country Park | 16810 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 16.457 | Canyon Country Park | 0 | Local Park 2 | 4 | |
11922 | 11922 | 11921 | {"type": "Polygon", "coordinates": [[[-118.52735, 34.42936], [-118.52648, 34.4312], [-118.52377, 34.4344], [-118.52375, 34.4344], [-118.52373, 34.43438], [-118.52366, 34.4344], [-118.52366, 34.43443], [-118.52356, 34.43446], [-118.52356, 34.43443], [-118.52349, 34.43445], [-118.52292, 34.43464], [-118.52289, 34.43469], [-118.51956, 34.43606], [-118.51934, 34.43614], [-118.51921, 34.4362], [-118.51911, 34.43628], [-118.51872, 34.4365], [-118.51866, 34.43641], [-118.51824, 34.43627], [-118.51752, 34.43616], [-118.51675, 34.43564], [-118.51612, 34.43492], [-118.51601, 34.43454], [-118.51599, 34.43359], [-118.51617, 34.43263], [-118.51638, 34.43244], [-118.51689, 34.43217], [-118.51741, 34.43224], [-118.5181, 34.43224], [-118.51831, 34.43207], [-118.51831, 34.43205], [-118.51798, 34.43182], [-118.51716, 34.43158], [-118.51793, 34.43112], [-118.51839, 34.43118], [-118.51902, 34.43111], [-118.51991, 34.43113], [-118.52057, 34.43153], [-118.521, 34.43155], [-118.52124, 34.43111], [-118.52235, 34.4297], [-118.52232, 34.42936], [-118.52204, 34.42904], [-118.52188, 34.42879], [-118.52198, 34.42861], [-118.52249, 34.42859], [-118.52301, 34.42894], [-118.52339, 34.42892], [-118.52384, 34.42887], [-118.52422, 34.42833], [-118.52466, 34.42818], [-118.52512, 34.42828], [-118.5253, 34.42868], [-118.52648, 34.42868], [-118.52735, 34.42936]]]} | Open Access 1 | 24527 | Central Park | 5954 | 2340 | Castaic Lake Water Agency 1002 | Special District 4 | Water District 13 | http://clwa.org/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=409 | Los Angeles 6 | 122.849 | Central Park | 0 | Local Park 2 | 4 |
7585 | 7585 | 7584 | {"type": "Polygon", "coordinates": [[[-118.54852, 34.45524], [-118.54772, 34.45535], [-118.54673, 34.45561], [-118.5462, 34.45564], [-118.54608, 34.45561], [-118.54585, 34.45444], [-118.54639, 34.45436], [-118.54704, 34.4543], [-118.54743, 34.45429], [-118.54834, 34.45432], [-118.54837, 34.45434], [-118.54839, 34.45437], [-118.54845, 34.45489], [-118.54852, 34.45524]]]} | Open Access 1 | 7284 | Chesebrough Park | 29034 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/chesebroughpark | Los Angeles 6 | 7.137 | Chesebrough Park | 0 | Local Park 2 | 4 |
10861 | 10861 | 10860 | {"type": "Polygon", "coordinates": [[[-118.5352, 34.39926], [-118.53465, 34.39935], [-118.53487, 34.40053], [-118.53406, 34.40064], [-118.53387, 34.39968], [-118.53393, 34.39948], [-118.53438, 34.39903], [-118.53426, 34.39892], [-118.53412, 34.39903], [-118.5338, 34.39935], [-118.53374, 34.39902], [-118.5341, 34.39885], [-118.53451, 34.3986], [-118.53459, 34.39899], [-118.53464, 34.39893], [-118.53468, 34.39894], [-118.53475, 34.39884], [-118.53489, 34.39877], [-118.53505, 34.39864], [-118.53505, 34.39879], [-118.5352, 34.39926]]]} | Open Access 1 | 20659 | Circle J Ranch Park | 17263 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 4.091 | Circle J Ranch Park | 0 | Local Park 2 | 4 | |
15227 | 15227 | 15226 | {"type": "Polygon", "coordinates": [[[-118.50782, 34.46054], [-118.50706, 34.46107], [-118.50688, 34.46119], [-118.5066, 34.46133], [-118.5061, 34.46152], [-118.50581, 34.46159], [-118.50553, 34.46164], [-118.50552, 34.45964], [-118.50688, 34.45967], [-118.50703, 34.45993], [-118.50732, 34.46008], [-118.50739, 34.46008], [-118.50745, 34.46017], [-118.50763, 34.46029], [-118.50783, 34.46049], [-118.50784, 34.46051], [-118.50782, 34.46054]]]} | Open Access 1 | 46209 | Copper Hill Park | 29503 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=989 | Los Angeles 6 | 7.98 | Copper Hill Park | 0 | Local Park 2 | 4 |
10862 | 10862 | 10861 | {"type": "Polygon", "coordinates": [[[-118.52166, 34.37788], [-118.52155, 34.37794], [-118.5216, 34.37802], [-118.52101, 34.37832], [-118.51896, 34.37592], [-118.51945, 34.37515], [-118.52016, 34.37582], [-118.52058, 34.37646], [-118.52104, 34.37623], [-118.52134, 34.37749], [-118.52166, 34.37788]]]} | Open Access 1 | 20660 | Creekview Park | 17788 | 6102 | The Master's College 959 | Private 7 | Education 35 | http://www.masters.edu/ | Private 14 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=411 | Los Angeles 6 | 8.223 | Creekview Park | 0 | Local Park 2 | 4 |
7572 | 7572 | 7571 | {"type": "Polygon", "coordinates": [[[-118.4899, 34.44767], [-118.48977, 34.44785], [-118.48969, 34.44799], [-118.48943, 34.44865], [-118.48936, 34.44879], [-118.48926, 34.44893], [-118.48911, 34.44908], [-118.48801, 34.45001], [-118.48764, 34.45043], [-118.48749, 34.45034], [-118.48698, 34.44991], [-118.4868, 34.44979], [-118.48819, 34.44735], [-118.48876, 34.44752], [-118.48913, 34.44715], [-118.48988, 34.44762], [-118.4899, 34.44767]]]} | Open Access 1 | 7282 | David March Park | 29048 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 12.312 | David March Park | 0 | Local Park 2 | 4 | |
15000 | 15000 | 14999 | {"type": "Polygon", "coordinates": [[[-118.48504, 34.42509], [-118.48502, 34.42602], [-118.48083, 34.42607], [-118.48085, 34.42352], [-118.48385, 34.42351], [-118.48455, 34.42449], [-118.48504, 34.42509]]]} | Open Access 1 | 45648 | Discovery Park | 28464 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=778 | Los Angeles 6 | 24.282 | Discovery Park | 0 | Local Park 2 | 4 |
10868 | 10868 | 10867 | {"type": "Polygon", "coordinates": [[[-118.51608, 34.38791], [-118.51584, 34.3888], [-118.51372, 34.38841], [-118.51347, 34.3893], [-118.51227, 34.38908], [-118.51276, 34.3873], [-118.51608, 34.38791]]]} | Open Access 1 | 25035 | Emmaus Park | 18631 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 10.676 | Emmaus Park | 0 | Local Park 2 | 4 | |
15003 | 15003 | 15002 | {"type": "Polygon", "coordinates": [[[-118.43986, 34.40521], [-118.43984, 34.40534], [-118.43953, 34.40525], [-118.43935, 34.40522], [-118.43917, 34.40522], [-118.4389, 34.40527], [-118.43874, 34.40534], [-118.43846, 34.40555], [-118.43827, 34.40566], [-118.43757, 34.4059], [-118.43714, 34.40612], [-118.43711, 34.40611], [-118.437, 34.406], [-118.43702, 34.40597], [-118.43665, 34.40549], [-118.43641, 34.4052], [-118.43639, 34.40518], [-118.43639, 34.40512], [-118.43633, 34.4051], [-118.43633, 34.40506], [-118.43638, 34.40492], [-118.43652, 34.40487], [-118.43661, 34.40478], [-118.43674, 34.40445], [-118.43712, 34.40454], [-118.43851, 34.40493], [-118.43929, 34.40518], [-118.43966, 34.40522], [-118.43967, 34.40519], [-118.43977, 34.40518], [-118.43986, 34.40521]]]} | Open Access 1 | 45651 | Fair Oaks Park | 28467 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=986 | Los Angeles 6 | 6.299 | Fair Oaks Park | 0 | Local Park 2 | 4 |
15229 | 15229 | 15228 | {"type": "Polygon", "coordinates": [[[-118.50169, 34.43095], [-118.5016, 34.43099], [-118.501, 34.43113], [-118.50088, 34.43133], [-118.50101, 34.43147], [-118.50082, 34.43159], [-118.50064, 34.43166], [-118.50052, 34.432], [-118.50031, 34.43202], [-118.50019, 34.43207], [-118.50007, 34.432], [-118.49939, 34.43176], [-118.49947, 34.43157], [-118.49952, 34.43137], [-118.49953, 34.43117], [-118.49952, 34.43059], [-118.49975, 34.4306], [-118.49996, 34.43065], [-118.50014, 34.43067], [-118.50071, 34.43068], [-118.50117, 34.43073], [-118.50151, 34.43074], [-118.50169, 34.43095]]]} | Open Access 1 | 46218 | Golden Valley Park | 29512 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/Home/Components/FacilityDirectory/FacilityDirectory/54/1386 | Los Angeles 6 | 4.967 | Golden Valley Park | 0 | Local Park 2 | 4 |
3259 | 3259 | 3258 | {"type": "MultiPolygon", "coordinates": [[[[-118.53244, 34.46826], [-118.52928, 34.46833], [-118.52923, 34.46815], [-118.52921, 34.46799], [-118.52921, 34.46783], [-118.52923, 34.46767], [-118.52931, 34.46741], [-118.52962, 34.46667], [-118.53231, 34.46662], [-118.53235, 34.46664], [-118.5324, 34.4669], [-118.53256, 34.46743], [-118.53259, 34.46761], [-118.53259, 34.46776], [-118.53257, 34.46794], [-118.53252, 34.46809], [-118.53244, 34.46826]]], [[[-118.53427, 34.46657], [-118.53418, 34.46793], [-118.53413, 34.46822], [-118.53267, 34.46826], [-118.53274, 34.46811], [-118.53278, 34.46794], [-118.53281, 34.46776], [-118.53281, 34.46761], [-118.53277, 34.4674], [-118.53261, 34.46686], [-118.53256, 34.46661], [-118.53427, 34.46657]]]]} | Open Access 1 | 48184 | Mountain View Park | 32720 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 19.342 | Mtn. View Park | 0 | Local Park 2 | 4 | |
7580 | 7580 | 7579 | {"type": "Polygon", "coordinates": [[[-118.54181, 34.38614], [-118.5392, 34.38764], [-118.53914, 34.38762], [-118.53796, 34.38621], [-118.54059, 34.3847], [-118.54181, 34.38614]]]} | Open Access 1 | 7273 | Newhall Park | 22726 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 14.293 | Newhall 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 |
4020 | 4020 | 4019 | {"type": "Polygon", "coordinates": [[[-118.55199, 34.43912], [-118.55125, 34.43945], [-118.54943, 34.43532], [-118.54883, 34.43379], [-118.54922, 34.4338], [-118.55004, 34.43375], [-118.55053, 34.43501], [-118.55067, 34.43532], [-118.55037, 34.43541], [-118.55036, 34.43542], [-118.55199, 34.43912]]]} | Open Access 1 | 44058 | Northbridge Park | 22868 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=811 | Los Angeles 6 | 13.592 | Northbridge Park | 0 | Local Park 2 | 4 |
7568 | 7568 | 7567 | {"type": "Polygon", "coordinates": [[[-118.553, 34.43747], [-118.55301, 34.43773], [-118.55298, 34.43794], [-118.55289, 34.43823], [-118.5528, 34.43842], [-118.55263, 34.43864], [-118.55245, 34.43883], [-118.55225, 34.43898], [-118.552, 34.43912], [-118.55144, 34.43787], [-118.55267, 34.4375], [-118.553, 34.43747]]]} | Open Access 1 | 7279 | Northbridge Park | 22868 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=811 | Los Angeles 6 | 3.887 | Northbridge 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]);