units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where ACCESS_TYP = 4 and MNG_AG_TYP = 6 sorted by LAYER
This data as json, copyable, CSV (advanced)
DES_TP 20
- Local Other or Unknown 103
- Local Recreation Area 6
- Local Park 3
- Local Conservation Area 3
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 3
MNG_AG_TYP 1
- Open Space District · 131 ✖
ACCESS_TYP 1
- Unknown Access · 131 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4703 | 4703 | 4702 | {"type": "Polygon", "coordinates": [[[-118.64426, 34.07586], [-118.64423, 34.07588], [-118.64417, 34.07584], [-118.64348, 34.07617], [-118.64335, 34.07628], [-118.64303, 34.07617], [-118.64305, 34.07606], [-118.64293, 34.07601], [-118.64303, 34.07542], [-118.64122, 34.0752], [-118.64122, 34.07483], [-118.6432, 34.07483], [-118.6432, 34.07538], [-118.64307, 34.07614], [-118.64333, 34.07624], [-118.64346, 34.07615], [-118.64418, 34.0758], [-118.64426, 34.07586]]]} | Unknown Access 4 | 46149 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 2.803 | 0 | Local Other or Unknown 14 | 4 | ||
4705 | 4705 | 4704 | {"type": "MultiPolygon", "coordinates": [[[[-118.34235, 34.73867], [-118.34237, 34.73912], [-118.34225, 34.73958], [-118.34129, 34.73959], [-118.34125, 34.73868], [-118.34235, 34.73867]]], [[[-118.34563, 34.73773], [-118.34452, 34.73774], [-118.34448, 34.73683], [-118.34558, 34.73683], [-118.34563, 34.73773]]], [[[-118.35357, 34.74131], [-118.35136, 34.74133], [-118.35131, 34.74042], [-118.35352, 34.7404], [-118.35357, 34.74131]]]]} | Unknown Access 4 | 46178 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.004 | 0 | Local Other or Unknown 14 | 4 | ||
4706 | 4706 | 4705 | {"type": "MultiPolygon", "coordinates": [[[[-118.36306, 34.69952], [-118.36255, 34.69995], [-118.36134, 34.69907], [-118.36169, 34.69893], [-118.36161, 34.69877], [-118.36177, 34.69869], [-118.36191, 34.69859], [-118.36306, 34.69952]]], [[[-118.36395, 34.67891], [-118.36285, 34.67895], [-118.36284, 34.67803], [-118.36394, 34.67799], [-118.36395, 34.67891]]], [[[-118.37499, 34.69955], [-118.37457, 34.70039], [-118.37355, 34.70004], [-118.37398, 34.6992], [-118.37499, 34.69955]]]]} | Unknown Access 4 | 46179 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 7.563 | 0 | Local Other or Unknown 14 | 4 | ||
4707 | 4707 | 4706 | {"type": "MultiPolygon", "coordinates": [[[[-118.45404, 34.80937], [-118.45382, 34.80958], [-118.45366, 34.80984], [-118.45293, 34.8096], [-118.45239, 34.80907], [-118.45318, 34.80853], [-118.45404, 34.80937]]], [[[-118.45543, 34.8084], [-118.45473, 34.80888], [-118.45388, 34.80805], [-118.45371, 34.80815], [-118.45285, 34.80731], [-118.45357, 34.80682], [-118.45442, 34.80765], [-118.45457, 34.80756], [-118.45543, 34.8084]]], [[[-118.47005, 34.80115], [-118.46989, 34.80117], [-118.46966, 34.80115], [-118.4695, 34.80111], [-118.46935, 34.80105], [-118.46916, 34.80091], [-118.46881, 34.80053], [-118.47004, 34.79978], [-118.47005, 34.80115]]]]} | Unknown Access 4 | 46180 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.506 | 0 | Local Other or Unknown 14 | 4 | ||
4708 | 4708 | 4707 | {"type": "MultiPolygon", "coordinates": [[[[-118.22898, 34.11301], [-118.22892, 34.11313], [-118.22861, 34.11303], [-118.22866, 34.11291], [-118.22866, 34.1126], [-118.22868, 34.11254], [-118.22894, 34.11265], [-118.22877, 34.11291], [-118.22898, 34.11301]]], [[[-118.23051, 34.11336], [-118.23045, 34.11346], [-118.23005, 34.11334], [-118.23022, 34.11324], [-118.23051, 34.11336]]]]} | Unknown Access 4 | 46182 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.409 | 0 | Local Other or Unknown 14 | 4 | ||
4709 | 4709 | 4708 | {"type": "Polygon", "coordinates": [[[-118.38733, 34.76821], [-118.38594, 34.76821], [-118.38593, 34.76763], [-118.38732, 34.76764], [-118.38733, 34.76821]]]} | Unknown Access 4 | 46187 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 2.001 | 0 | Local Other or Unknown 14 | 4 | ||
4710 | 4710 | 4709 | {"type": "Polygon", "coordinates": [[[-118.35225, 34.27148], [-118.35164, 34.27143], [-118.35019, 34.27137], [-118.35132, 34.27105], [-118.3521, 34.27136], [-118.35225, 34.27148]]]} | Unknown Access 4 | 46188 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.997 | 0 | Local Other or Unknown 14 | 4 | ||
4711 | 4711 | 4710 | {"type": "MultiPolygon", "coordinates": [[[[-118.33135, 34.47091], [-118.32554, 34.47086], [-118.32558, 34.46797], [-118.32824, 34.46768], [-118.33024, 34.46772], [-118.33048, 34.4682], [-118.33059, 34.46854], [-118.33064, 34.46882], [-118.33072, 34.46952], [-118.33081, 34.46994], [-118.33098, 34.47034], [-118.33128, 34.47084], [-118.33135, 34.47091]]], [[[-118.33088, 34.46918], [-118.33082, 34.46867], [-118.33072, 34.46827], [-118.33058, 34.46795], [-118.33022, 34.46727], [-118.33055, 34.4672], [-118.33063, 34.46781], [-118.33069, 34.46804], [-118.33084, 34.46849], [-118.33088, 34.46866], [-118.3309, 34.46885], [-118.33088, 34.46918]]], [[[-118.33212, 34.46786], [-118.33139, 34.46786], [-118.33163, 34.46853], [-118.33145, 34.46989], [-118.33165, 34.47052], [-118.3317, 34.471], [-118.33167, 34.471], [-118.33139, 34.47067], [-118.33125, 34.47046], [-118.3311, 34.47014], [-118.33104, 34.46994], [-118.33101, 34.46965], [-118.33107, 34.46887], [-118.33105, 34.46866], [-118.33101, 34.46846], [-118.33081, 34.46789], [-118.33076, 34.46757], [-118.33072, 34.46757], [-118.33068, 34.46717], [-118.33089, 34.46713], [-118.33138, 34.46749], [-118.33211, 34.4674], [-118.33212, 34.46786]]]]} | Unknown Access 4 | 46210 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 46.474 | 0 | Local Other or Unknown 14 | 4 | ||
4712 | 4712 | 4711 | {"type": "Polygon", "coordinates": [[[-118.3348, 34.47457], [-118.33031, 34.47454], [-118.33057, 34.47368], [-118.33068, 34.47342], [-118.33085, 34.47319], [-118.33177, 34.47219], [-118.33185, 34.47206], [-118.33189, 34.47193], [-118.33191, 34.47178], [-118.33188, 34.47164], [-118.33164, 34.47101], [-118.33169, 34.47099], [-118.33165, 34.47051], [-118.33145, 34.46989], [-118.33163, 34.46853], [-118.33139, 34.46785], [-118.33212, 34.46785], [-118.33211, 34.4674], [-118.33438, 34.46714], [-118.33437, 34.4673], [-118.3348, 34.47457]]]} | Unknown Access 4 | 46211 | Unnamed site - Santa Clarita Watershed Recreation and Conservation Authority | 29506 | 2390 | Santa Clarita Watershed Recreation and Conservation Authority 776 | Special District 4 | Recreation/Parks District 4 | http://smmc.ca.gov/SCWRCA.asp | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 58.139 | 0 | Local Other or Unknown 14 | 4 | ||
4713 | 4713 | 4712 | {"type": "MultiPolygon", "coordinates": [[[[-118.22834, 34.46304], [-118.21967, 34.46267], [-118.21965, 34.45974], [-118.22184, 34.4597], [-118.22185, 34.46123], [-118.22399, 34.46126], [-118.224, 34.46125], [-118.22399, 34.45966], [-118.22834, 34.45957], [-118.22834, 34.46304]]], [[[-118.25353, 34.4727], [-118.25349, 34.47452], [-118.24931, 34.47452], [-118.24936, 34.47271], [-118.25353, 34.4727]]], [[[-118.26253, 34.47437], [-118.26244, 34.47625], [-118.26019, 34.47627], [-118.26027, 34.47441], [-118.26253, 34.47437]]]]} | Unknown Access 4 | 46220 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 91.095 | 0 | Local Other or Unknown 14 | 4 | ||
4714 | 4714 | 4713 | {"type": "MultiPolygon", "coordinates": [[[[-117.70087, 34.64609], [-117.7008, 34.64792], [-117.70025, 34.64792], [-117.70031, 34.64609], [-117.70087, 34.64609]]], [[[-117.77844, 34.67386], [-117.77404, 34.67393], [-117.77402, 34.67208], [-117.77843, 34.67202], [-117.77844, 34.67386]]], [[[-117.78112, 34.66184], [-117.78056, 34.66185], [-117.78056, 34.66092], [-117.78111, 34.66092], [-117.78112, 34.66184]]]]} | Unknown Access 4 | 46223 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 24.238 | 0 | Local Other or Unknown 14 | 4 | ||
4715 | 4715 | 4714 | {"type": "Polygon", "coordinates": [[[-118.23063, 34.61645], [-118.23009, 34.61744], [-118.22997, 34.6177], [-118.22994, 34.6177], [-118.22981, 34.61794], [-118.22977, 34.61793], [-118.22965, 34.61815], [-118.22951, 34.61845], [-118.22939, 34.61843], [-118.2291, 34.6188], [-118.22877, 34.6188], [-118.22856, 34.61872], [-118.22848, 34.61873], [-118.22842, 34.61876], [-118.22838, 34.61883], [-118.22773, 34.61926], [-118.22752, 34.61926], [-118.22751, 34.61704], [-118.22832, 34.61645], [-118.23063, 34.61645]]]} | Unknown Access 4 | 46225 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 14.389 | 0 | Local Other or Unknown 14 | 4 | ||
4717 | 4717 | 4716 | {"type": "MultiPolygon", "coordinates": [[[[-118.28411, 34.2281], [-118.27538, 34.22816], [-118.27531, 34.22178], [-118.28404, 34.22172], [-118.28411, 34.2281]]], [[[-118.28844, 34.22398], [-118.28698, 34.22399], [-118.28696, 34.22261], [-118.28842, 34.2226], [-118.28844, 34.22398]]]]} | Unknown Access 4 | 46232 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 145.787 | 0 | Local Other or Unknown 14 | 4 | ||
4719 | 4719 | 4718 | {"type": "Polygon", "coordinates": [[[-118.74907, 34.06809], [-118.74798, 34.0681], [-118.74796, 34.06714], [-118.74905, 34.06714], [-118.74907, 34.06809]]]} | Unknown Access 4 | 46299 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 2.649 | 0 | Local Other or Unknown 14 | 4 | ||
4720 | 4720 | 4719 | {"type": "MultiPolygon", "coordinates": [[[[-118.56182, 34.13031], [-118.56164, 34.13032], [-118.56143, 34.13032], [-118.56123, 34.13029], [-118.56106, 34.13025], [-118.56165, 34.13023], [-118.56182, 34.13031]]], [[[-118.56397, 34.13076], [-118.56369, 34.1306], [-118.56322, 34.13042], [-118.56305, 34.13032], [-118.56291, 34.13028], [-118.56277, 34.13028], [-118.56259, 34.13021], [-118.56397, 34.13019], [-118.56397, 34.13076]]]]} | Unknown Access 4 | 46300 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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.975 | 0 | Local Other or Unknown 14 | 4 | ||
4721 | 4721 | 4720 | {"type": "Polygon", "coordinates": [[[-118.601, 34.12191], [-118.60099, 34.12209], [-118.60081, 34.12214], [-118.60084, 34.12191], [-118.60091, 34.12192], [-118.601, 34.12191]]]} | Unknown Access 4 | 46346 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.085 | 0 | Local Other or Unknown 14 | 4 | ||
4722 | 4722 | 4721 | {"type": "Polygon", "coordinates": [[[-118.31733, 34.27955], [-118.31732, 34.28397], [-118.31513, 34.28396], [-118.31513, 34.28339], [-118.31655, 34.28231], [-118.31632, 34.2815], [-118.31277, 34.28366], [-118.31278, 34.28092], [-118.31618, 34.27996], [-118.31613, 34.28034], [-118.31633, 34.28036], [-118.31643, 34.28035], [-118.31696, 34.28014], [-118.31714, 34.28002], [-118.31723, 34.27991], [-118.31728, 34.27979], [-118.31733, 34.27955]]]} | Unknown Access 4 | 46313 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 31.653 | 0 | Local Other or Unknown 14 | 4 | ||
4723 | 4723 | 4722 | {"type": "Polygon", "coordinates": [[[-118.50663, 34.13797], [-118.50613, 34.13864], [-118.50518, 34.14064], [-118.50475, 34.14069], [-118.50477, 34.14017], [-118.50488, 34.13984], [-118.50491, 34.13986], [-118.50492, 34.1399], [-118.50499, 34.13992], [-118.50503, 34.13989], [-118.50508, 34.13988], [-118.50511, 34.13978], [-118.50507, 34.13976], [-118.50532, 34.1393], [-118.50484, 34.13897], [-118.5051, 34.13819], [-118.50408, 34.13792], [-118.50474, 34.13618], [-118.50489, 34.13538], [-118.50493, 34.13376], [-118.5059, 34.13377], [-118.50663, 34.13351], [-118.50663, 34.13797]]]} | Unknown Access 4 | 46323 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 27.007 | 0 | Local Other or Unknown 14 | 4 | ||
4724 | 4724 | 4723 | {"type": "Polygon", "coordinates": [[[-118.37172, 34.10321], [-118.37135, 34.10341], [-118.37119, 34.10336], [-118.37126, 34.10321], [-118.37172, 34.10321]]]} | Unknown Access 4 | 46333 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.149 | 0 | Local Other or Unknown 14 | 4 | ||
4725 | 4725 | 4724 | {"type": "MultiPolygon", "coordinates": [[[[-118.60336, 34.12324], [-118.60346, 34.12329], [-118.60347, 34.12333], [-118.60345, 34.12337], [-118.60339, 34.12342], [-118.60315, 34.12351], [-118.6031, 34.1234], [-118.60319, 34.12337], [-118.60321, 34.12333], [-118.60336, 34.12324]]], [[[-118.60346, 34.12362], [-118.6033, 34.12361], [-118.6033, 34.12348], [-118.60346, 34.1234], [-118.60346, 34.12362]]]]} | Unknown Access 4 | 46335 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.199 | 0 | Local Other or Unknown 14 | 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]);