units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where DES_TP = 2 and MNG_AGENCY = 101 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3654 | 3654 | 3653 | {"type": "Polygon", "coordinates": [[[-117.11836, 33.00338], [-117.1183, 33.00374], [-117.11756, 33.00369], [-117.11751, 33.00406], [-117.11703, 33.00401], [-117.11707, 33.00365], [-117.11615, 33.00356], [-117.11606, 33.00392], [-117.11566, 33.00389], [-117.11564, 33.00395], [-117.11496, 33.0039], [-117.11475, 33.00393], [-117.11456, 33.00399], [-117.11441, 33.00379], [-117.11455, 33.00346], [-117.11463, 33.00323], [-117.1147, 33.00315], [-117.11495, 33.00295], [-117.11527, 33.00298], [-117.11538, 33.00296], [-117.11553, 33.00327], [-117.11583, 33.00319], [-117.11718, 33.00331], [-117.11741, 33.00327], [-117.11754, 33.0033], [-117.11808, 33.00337], [-117.11836, 33.00338]]]} | Open Access 1 | 29594 | 4S Ranch Community Park | 29225 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | San Diego 4 | 5.809 | 4S Ranch Community Park | 0 | Local Park 2 | 4 |
6239 | 6239 | 6238 | {"type": "Polygon", "coordinates": [[[-117.11773, 33.01502], [-117.1175, 33.01584], [-117.11707, 33.01618], [-117.11694, 33.01675], [-117.11621, 33.01663], [-117.11619, 33.01662], [-117.11626, 33.01623], [-117.11629, 33.01582], [-117.11618, 33.01481], [-117.11619, 33.01477], [-117.11623, 33.01474], [-117.11639, 33.01475], [-117.11773, 33.01502]]]} | Open Access 1 | 1304 | 4S Ranch Heritage Park | 29226 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.39 | 4S Ranch Heritage Park | 0 | Local Park 2 | 4 |
15157 | 15157 | 15156 | {"type": "Polygon", "coordinates": [[[-117.11743, 33.01151], [-117.11752, 33.01172], [-117.11755, 33.01187], [-117.11753, 33.01206], [-117.11751, 33.01214], [-117.11748, 33.01217], [-117.11743, 33.01217], [-117.11666, 33.01201], [-117.11662, 33.01199], [-117.11658, 33.01192], [-117.11651, 33.01189], [-117.11645, 33.01189], [-117.11638, 33.01191], [-117.11618, 33.0117], [-117.11606, 33.01182], [-117.11597, 33.01213], [-117.11604, 33.01169], [-117.11601, 33.0116], [-117.11591, 33.01148], [-117.11611, 33.0115], [-117.11631, 33.01148], [-117.11653, 33.01149], [-117.1168, 33.01156], [-117.11707, 33.01159], [-117.11743, 33.01151]]]} | Open Access 1 | 46006 | 4S Ranch Homestead Park | 29267 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchLiberty.html | San Diego 4 | 1.801 | 4S Ranch Homestead Park | 0 | Local Park 2 | 4 |
15150 | 15150 | 15149 | {"type": "Polygon", "coordinates": [[[-117.11446, 33.0364], [-117.11431, 33.03678], [-117.1142, 33.03696], [-117.11407, 33.03715], [-117.11377, 33.0375], [-117.11362, 33.03763], [-117.11341, 33.03775], [-117.11311, 33.03738], [-117.1126, 33.03682], [-117.11261, 33.03678], [-117.11303, 33.03641], [-117.11347, 33.0359], [-117.11376, 33.03607], [-117.11436, 33.03631], [-117.11446, 33.0364]]]} | Open Access 1 | 45993 | 4S Ranch Liberty Park | 29187 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 4.774 | 4S Ranch Liberty Park | 0 | Local Park 2 | 4 |
15156 | 15156 | 15155 | {"type": "Polygon", "coordinates": [[[-117.10945, 33.02613], [-117.1071, 33.02507], [-117.10729, 33.02431], [-117.10808, 33.02445], [-117.10808, 33.02453], [-117.10813, 33.02459], [-117.10823, 33.02463], [-117.10995, 33.02563], [-117.10997, 33.02568], [-117.10993, 33.02573], [-117.10955, 33.02601], [-117.10945, 33.02613]]]} | Open Access 1 | 46005 | 4S Ranch Patriot Park | 29266 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.762 | 4S Ranch Patriot Park | 0 | Local Park 2 | 4 |
16318 | 16318 | 16317 | {"type": "Polygon", "coordinates": [[[-116.31206, 32.9622], [-116.31195, 32.96223], [-116.30382, 32.96232], [-116.29498, 32.9623], [-116.29506, 32.95855], [-116.28653, 32.95866], [-116.28678, 32.95114], [-116.29521, 32.951], [-116.29529, 32.94721], [-116.30306, 32.94726], [-116.31135, 32.94726], [-116.31206, 32.9622]]]} | Open Access 1 | 5247 | Agua Caliente Regional Park | 29024 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/AguaCaliente.html | San Diego 4 | 802.564 | Agua Caliente RP | 0 | Local Park 2 | 4 |
763 | 763 | 762 | {"type": "Polygon", "coordinates": [[[-117.00133, 32.74581], [-117.00084, 32.74581], [-117.00081, 32.74585], [-117.00087, 32.74595], [-117.00053, 32.74629], [-117.00034, 32.74616], [-117.00008, 32.74645], [-116.99996, 32.74633], [-116.99954, 32.74618], [-116.99953, 32.74531], [-117.00019, 32.74531], [-117.0002, 32.74539], [-117.00067, 32.74538], [-117.00066, 32.74515], [-117.00083, 32.74497], [-117.00083, 32.74462], [-117.00132, 32.74461], [-117.00133, 32.74581]]]} | Open Access 1 | 4973 | Bancroft Park | 15792 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Bancroft.html | San Diego 4 | 4.676 | Bancroft Park | 0 | Local Park 2 | 4 |
6709 | 6709 | 6708 | {"type": "MultiPolygon", "coordinates": [[[[-116.91484, 32.86884], [-116.91485, 32.87034], [-116.91482, 32.87063], [-116.91469, 32.87097], [-116.91454, 32.87121], [-116.91438, 32.87142], [-116.91412, 32.87164], [-116.91342, 32.87076], [-116.91262, 32.87037], [-116.91096, 32.87045], [-116.91023, 32.86652], [-116.91402, 32.86599], [-116.91456, 32.86881], [-116.91484, 32.86884]]], [[[-116.91825, 32.86993], [-116.91733, 32.87197], [-116.91627, 32.87239], [-116.91504, 32.87239], [-116.91426, 32.87179], [-116.91425, 32.87177], [-116.91446, 32.87159], [-116.91462, 32.87141], [-116.91477, 32.8712], [-116.91487, 32.87103], [-116.91497, 32.87078], [-116.91502, 32.87058], [-116.91505, 32.87035], [-116.91505, 32.8701], [-116.91599, 32.87019], [-116.91531, 32.87033], [-116.91536, 32.87052], [-116.91825, 32.86993]]]]} | Open Access 1 | 5036 | Cactus Park | 16651 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Cactus.html | San Diego 4 | 61.039 | Cactus Park | 0 | Local Park 2 | 4 |
14928 | 14928 | 14927 | {"type": "Polygon", "coordinates": [[[-117.25461, 33.36874], [-117.2546, 33.3693], [-117.25423, 33.3693], [-117.25423, 33.36873], [-117.25461, 33.36874]]]} | Open Access 1 | 45505 | Clemmens Lane County Park | 28337 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Clemmens.html | San Diego 4 | 0.544 | Clemmens Lane County Park | 2009 | Local Park 2 | 4 |
601 | 601 | 600 | {"type": "Polygon", "coordinates": [[[-116.86232, 33.04283], [-116.86091, 33.04362], [-116.85968, 33.04204], [-116.8611, 33.04126], [-116.86164, 33.04196], [-116.86161, 33.04199], [-116.86171, 33.04211], [-116.86175, 33.04209], [-116.86232, 33.04283]]]} | Open Access 1 | 4174 | Collier Park | 17519 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Collier.html | San Diego 4 | 8.145 | Collier Park | 0 | Local Park 2 | 4 |
6700 | 6700 | 6699 | {"type": "Polygon", "coordinates": [[[-116.91742, 32.75157], [-116.91715, 32.75181], [-116.9163, 32.75233], [-116.91649, 32.75258], [-116.91616, 32.75277], [-116.91612, 32.75277], [-116.91608, 32.75275], [-116.91571, 32.75227], [-116.9156, 32.75217], [-116.91491, 32.75174], [-116.9151, 32.75147], [-116.91522, 32.75105], [-116.91702, 32.75139], [-116.91725, 32.75147], [-116.91742, 32.75157]]]} | Open Access 1 | 4985 | Cottonwood County Park | 29270 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Cottonwood.html | San Diego 4 | 5.47 | Cottonwood County Park | 0 | Local Park 2 | 4 |
6703 | 6703 | 6702 | {"type": "Polygon", "coordinates": [[[-116.94512, 32.75532], [-116.94511, 32.75706], [-116.94501, 32.75707], [-116.94501, 32.75859], [-116.94202, 32.75855], [-116.94197, 32.75818], [-116.94278, 32.7581], [-116.94286, 32.75813], [-116.94295, 32.75812], [-116.94301, 32.75808], [-116.94303, 32.75805], [-116.94303, 32.758], [-116.94301, 32.75794], [-116.94294, 32.75789], [-116.94297, 32.75783], [-116.94254, 32.75687], [-116.94212, 32.75672], [-116.94171, 32.75665], [-116.94122, 32.7557], [-116.94096, 32.75447], [-116.94109, 32.75444], [-116.94116, 32.75429], [-116.94127, 32.75428], [-116.94133, 32.75425], [-116.94136, 32.7542], [-116.94165, 32.75423], [-116.94281, 32.75501], [-116.94287, 32.75503], [-116.94512, 32.75532]]]} | Open Access 1 | 5000 | Damon Lane Park | 17902 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DamonLane.html | San Diego 4 | 29.5 | Damon Lane Park | 0 | Local Park 2 | 4 |
843 | 843 | 842 | {"type": "Polygon", "coordinates": [[[-116.9683, 32.73338], [-116.9683, 32.73465], [-116.96616, 32.73505], [-116.9659, 32.73378], [-116.96606, 32.73382], [-116.96615, 32.73378], [-116.96618, 32.73375], [-116.96619, 32.73366], [-116.96615, 32.73359], [-116.96606, 32.73356], [-116.96598, 32.73356], [-116.96587, 32.73363], [-116.96582, 32.73336], [-116.9683, 32.73338]]]} | Open Access 1 | 4978 | Del Parque Park | 18044 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 8.751 | Del Parque Park | 0 | Local Park 2 | 4 | |
819 | 819 | 818 | {"type": "Polygon", "coordinates": [[[-117.25791, 33.37491], [-117.25791, 33.37556], [-117.25754, 33.37556], [-117.25754, 33.3752], [-117.25724, 33.37489], [-117.25791, 33.37491]]]} | Open Access 1 | 5304 | Don Dussault Park | 18203 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DonDussault.html | San Diego 4 | 0.746 | Don Dussault Park | 0 | Local Park 2 | 4 |
10581 | 10581 | 10580 | {"type": "Polygon", "coordinates": [[[-116.94463, 32.99593], [-116.94441, 32.9987], [-116.94439, 32.99875], [-116.94439, 32.99899], [-116.94433, 32.9996], [-116.94028, 32.99968], [-116.93617, 32.99969], [-116.93612, 32.99608], [-116.94463, 32.99593]]]} | Open Access 1 | 18841 | Dos Picos Park | 18228 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DosPicos.html | San Diego 4 | 78.103 | Dos Picos Park | 0 | Local Park 2 | 4 |
4392 | 4392 | 4391 | {"type": "Polygon", "coordinates": [[[-117.00165, 32.68355], [-117.0004, 32.68385], [-117.00037, 32.6838], [-117.0005, 32.68375], [-117.00074, 32.68356], [-117.00061, 32.68345], [-117.00052, 32.68333], [-117.00036, 32.6829], [-116.99999, 32.68213], [-116.9997, 32.68168], [-117.00012, 32.68136], [-117.00066, 32.68121], [-117.00114, 32.68245], [-117.00116, 32.68249], [-117.00127, 32.68246], [-117.00165, 32.68355]]]} | Open Access 1 | 46008 | Eastview County Park | 29272 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Eastview.html | San Diego 4 | 6.275 | Eastview County Park | 0 | Local Park 2 | 4 |
6772 | 6772 | 6771 | {"type": "MultiPolygon", "coordinates": [[[[-116.85271, 32.89302], [-116.85016, 32.89317], [-116.85014, 32.89281], [-116.84423, 32.89275], [-116.84295, 32.89205], [-116.84351, 32.8922], [-116.84518, 32.89238], [-116.84573, 32.89242], [-116.84616, 32.89241], [-116.84661, 32.89238], [-116.84788, 32.89222], [-116.8482, 32.89215], [-116.84849, 32.89204], [-116.84878, 32.89189], [-116.84902, 32.89172], [-116.84923, 32.89151], [-116.84936, 32.89135], [-116.84947, 32.89115], [-116.84995, 32.89012], [-116.85271, 32.89302]]], [[[-116.85018, 32.88908], [-116.85003, 32.88947], [-116.84931, 32.89106], [-116.84921, 32.89122], [-116.84905, 32.89144], [-116.84886, 32.89162], [-116.84863, 32.89178], [-116.8484, 32.8919], [-116.84815, 32.89199], [-116.84785, 32.89205], [-116.8466, 32.89221], [-116.84599, 32.89225], [-116.84526, 32.89223], [-116.84343, 32.89201], [-116.84478, 32.88919], [-116.84558, 32.8872], [-116.84609, 32.88674], [-116.84638, 32.88601], [-116.84995, 32.88843], [-116.85002, 32.8885], [-116.85007, 32.88858], [-116.85018, 32.88908]]]]} | Open Access 1 | 5237 | El Monte Park | 18518 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/ElMonte.html | San Diego 4 | 87.505 | El Monte Park | 0 | Local Park 2 | 4 |
5190 | 5190 | 5189 | {"type": "Polygon", "coordinates": [[[-116.9854, 32.75274], [-116.98539, 32.75383], [-116.98392, 32.75381], [-116.98395, 32.75166], [-116.98499, 32.75167], [-116.98497, 32.75273], [-116.9854, 32.75274]]]} | Open Access 1 | 4996 | Estrella Park | 29276 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 6.925 | Estrella Park | 0 | Local Park 2 | 4 | |
6705 | 6705 | 6704 | {"type": "Polygon", "coordinates": [[[-117.00204, 32.76133], [-117.00199, 32.76124], [-117.00192, 32.76106], [-117.00179, 32.76094], [-117.00165, 32.76087], [-117.00111, 32.76077], [-117.00098, 32.76071], [-117.00094, 32.76067], [-117.0009, 32.76055], [-117.00109, 32.76047], [-117.00102, 32.76025], [-117.00045, 32.75882], [-117.00166, 32.75882], [-117.00223, 32.76019], [-117.00229, 32.76049], [-117.00228, 32.76074], [-117.00221, 32.76103], [-117.0021, 32.76124], [-117.00204, 32.76133]]]} | Open Access 1 | 5007 | Eucalyptus Park | 18739 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Eucalyptus.html | San Diego 4 | 6.737 | Eucalyptus Park | 0 | Local Park 2 | 4 |
6812 | 6812 | 6811 | {"type": "Polygon", "coordinates": [[[-117.08786, 33.07997], [-117.08663, 33.08481], [-117.0855, 33.08398], [-117.08509, 33.08399], [-117.08483, 33.08422], [-117.08478, 33.08422], [-117.08463, 33.08428], [-117.0845, 33.08425], [-117.08444, 33.08419], [-117.08339, 33.0828], [-117.08329, 33.08262], [-117.08314, 33.08231], [-117.083, 33.08184], [-117.08296, 33.08162], [-117.08294, 33.08128], [-117.08302, 33.08086], [-117.08394, 33.08103], [-117.084, 33.08091], [-117.08399, 33.0809], [-117.08305, 33.08074], [-117.0832, 33.08033], [-117.08426, 33.07827], [-117.08433, 33.07802], [-117.0844, 33.07797], [-117.08441, 33.07795], [-117.08443, 33.07795], [-117.08542, 33.07814], [-117.08571, 33.07944], [-117.08628, 33.07986], [-117.08671, 33.07998], [-117.08786, 33.07997]]]} | Open Access 1 | 5367 | Felicita Park | 18866 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Felicita.html | San Diego 4 | 51.878 | Felicita 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]);