units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, DES_TP = 3 and LABEL_NAME = "Black Mtn. Ranch OS"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2825 | 2825 | 2824 | {"type": "MultiPolygon", "coordinates": [[[[-117.16552, 32.98511], [-117.16551, 32.98602], [-117.1655, 32.98942], [-117.1653, 32.98936], [-117.16526, 32.98935], [-117.16525, 32.98932], [-117.16534, 32.98905], [-117.16538, 32.98882], [-117.16537, 32.98859], [-117.16528, 32.98808], [-117.16528, 32.98775], [-117.1653, 32.98759], [-117.16537, 32.98735], [-117.1654, 32.98709], [-117.1654, 32.98514], [-117.16545, 32.98511], [-117.16552, 32.98511]]], [[[-117.16611, 32.99288], [-117.16557, 32.99287], [-117.16538, 32.99289], [-117.16539, 32.98957], [-117.16549, 32.98959], [-117.16547, 32.99274], [-117.16611, 32.99275], [-117.16611, 32.99288]]]]} | Open Access 1 | 18687 | Black Mountain Ranch Open Space | 16134 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.646 | Black Mtn. Ranch OS | 0 | Local Recreation Area 3 | 4 | |
5509 | 5509 | 5508 | {"type": "MultiPolygon", "coordinates": [[[[-117.16987, 33.00435], [-117.16765, 33.00446], [-117.16763, 33.00432], [-117.16747, 33.00433], [-117.16749, 33.00365], [-117.16752, 33.00363], [-117.16757, 33.00362], [-117.16768, 33.00368], [-117.16781, 33.0037], [-117.16795, 33.0037], [-117.16813, 33.00366], [-117.16828, 33.00357], [-117.16843, 33.0038], [-117.16857, 33.00373], [-117.16846, 33.00357], [-117.16861, 33.00357], [-117.16878, 33.00352], [-117.16896, 33.0034], [-117.16901, 33.00334], [-117.16907, 33.00324], [-117.1691, 33.00308], [-117.16907, 33.00293], [-117.16897, 33.00278], [-117.16884, 33.00268], [-117.16877, 33.00266], [-117.16877, 33.0026], [-117.16884, 33.00253], [-117.16892, 33.00237], [-117.16893, 33.00222], [-117.1689, 33.00213], [-117.16885, 33.00203], [-117.16878, 33.00195], [-117.1686, 33.00184], [-117.16842, 33.00179], [-117.16823, 33.0018], [-117.16805, 33.00186], [-117.16791, 33.00198], [-117.16777, 33.00172], [-117.16763, 33.00177], [-117.16775, 33.00202], [-117.16763, 33.00202], [-117.16755, 33.00204], [-117.16741, 33.00209], [-117.16736, 33.00212], [-117.16732, 33.00212], [-117.16718, 33.00206], [-117.16709, 33.00205], [-117.16694, 33.00205], [-117.16681, 33.00207], [-117.1667, 33.00213], [-117.16665, 33.00212], [-117.1665, 33.00203], [-117.16638, 33.00199], [-117.16618, 33.00198], [-117.16601, 33.00203], [-117.16597, 33.00202], [-117.16588, 33.00196], [-117.16574, 33.00191], [-117.16554, 33.0019], [-117.16551, 33.00174], [-117.16536, 33.00176], [-117.16538, 33.00194], [-117.16523, 33.00202], [-117.16518, 33.00202], [-117.16501, 33.00198], [-117.16488, 33.00198], [-117.1647, 33.00202], [-117.16458, 33.00209], [-117.16452, 33.00207], [-117.16462, 33.00192], [-117.16479, 33.00189], [-117.16497, 33.00179], [-117.16506, 33.0017], [-117.1651, 33.0016], [-117.16516, 33.00159], [-117.16524, 33.00162], [-117.16535, 33.00164], [-117.16557, 33.00162], [-117.16575, 33.00155], [-117.16583, 33.00149], [-117.16589, 33.00142], [-117.16618, 33.00141], [-117.16635, 33.00135], [-117.16648, 33.00125], [-117.16649, 33.00122], [-117.16676, 33.00121], [-117.16691, 33.00117], [-117.16703, 33.0011], [-117.16712, 33.00101], [-117.1672, 33.00086], [-117.16723, 33.00068], [-117.1673, 33.00059], [-117.16734, 33.00057], [-117.16785, 33.00095], [-117.16794, 33.00085], [-117.1675, 33.00049], [-117.16868, 33.00005], [-117.16881, 32.99995], [-117.16887, 32.99989], [-117.16893, 32.99977], [-117.16895, 32.99965], [-117.16894, 32.99955], [-117.1689, 32.99943], [-117.16885, 32.99937], [-117.16876, 32.99928], [-117.16861, 32.99919], [-117.16846, 32.99916], [-117.16827, 32.99916], [-117.16833, 32.99901], [-117.16845, 32.99907], [-117.16906, 32.99907], [-117.16906, 32.99947], [-117.1696, 32.99947], [-117.1696, 32.99872], [-117.16947, 32.99862], [-117.16851, 32.99838], [-117.16788, 32.99838], [-117.16787, 32.99864], [-117.16766, 32.99868], [-117.16743, 32.99862], [-117.16688, 32.99817], [-117.16683, 32.99811], [-117.16668, 32.99789], [-117.1666, 32.99782], [-117.16651, 32.99776], [-117.16637, 32.99771], [-117.16626, 32.99769], [-117.16609, 32.99771], [-117.16605, 32.99768], [-117.16604, 32.9976], [-117.16599, 32.9975], [-117.16589, 32.99738], [-117.16581, 32.99732], [-117.16567, 32.99726], [-117.16552, 32.99723], [-117.16536, 32.99724], [-117.1652, 32.99729], [-117.16516, 32.99729], [-117.1651, 32.99724], [-117.16502, 32.9972], [-117.16482, 32.99716], [-117.16466, 32.99717], [-117.16453, 32.99721], [-117.1644, 32.99728], [-117.16429, 32.99737], [-117.16424, 32.99747], [-117.16421, 32.99757], [-117.16421, 32.99772], [-117.16425, 32.99783], [-117.16425, 32.99788], [-117.16422, 32.99793], [-117.16415, 32.99796], [-117.16409, 32.99796], [-117.16397, 32.99792], [-117.16387, 32.9979], [-117.16368, 32.99791], [-117.16355, 32.99795], [-117.1635, 32.99795], [-117.16334, 32.99784], [-117.16316, 32.99778], [-117.16291, 32.99779], [-117.16274, 32.99786], [-117.16268, 32.9979], [-117.16263, 32.9979], [-117.16255, 32.99785], [-117.16243, 32.9978], [-117.16229, 32.99778], [-117.16217, 32.99773], [-117.16189, 32.99767], [-117.16169, 32.99767], [-117.16143, 32.99772], [-117.16133, 32.99776], [-117.16114, 32.99787], [-117.161, 32.998], [-117.16091, 32.99813], [-117.16078, 32.99809], [-117.1606, 32.99809], [-117.16048, 32.99812], [-117.16032, 32.9982], [-117.16022, 32.9983], [-117.16013, 32.99847], [-117.16012, 32.99863], [-117.16016, 32.99875], [-117.16008, 32.99875], [-117.16001, 32.99872], [-117.15998, 32.99853], [-117.1599, 32.99838], [-117.15959, 32.99793], [-117.15939, 32.9977], [-117.15955, 32.99766], [-117.15967, 32.99759], [-117.15973, 32.99753], [-117.15981, 32.99742], [-117.15984, 32.99731], [-117.15984, 32.9972], [-117.15987, 32.99717], [-117.15999, 32.99719], [-117.1601, 32.99718], [-117.16027, 32.99713], [-117.16034, 32.99709], [-117.16045, 32.99699], [-117.16053, 32.99683], [-117.1606, 32.99679], [-117.16064, 32.99678], [-117.16073, 32.99679], [-117.16086, 32.99687], [-117.161, 32.99691], [-117.16117, 32.99692], [-117.16128, 32.99689], [-117.16147, 32.99699], [-117.16162, 32.99703], [-117.16175, 32.99703], [-117.16184, 32.99701], [-117.16203, 32.99692], [-117.16209, 32.99692], [-117.16224, 32.99703], [-117.16236, 32.99708], [-117.16245, 32.9971], [-117.16264, 32.99709], [-117.16282, 32.99702], [-117.16294, 32.99693], [-117.16299, 32.99686], [-117.16304, 32.99677], [-117.16306, 32.99666], [-117.16303, 32.99649], [-117.16298, 32.99641], [-117.16291, 32.99633], [-117.16308, 32.99619], [-117.16293, 32.99602], [-117.16325, 32.99583], [-117.1634, 32.99571], [-117.16348, 32.99561], [-117.16349, 32.99561], [-117.16348, 32.99568], [-117.16349, 32.99575], [-117.16353, 32.99585], [-117.1636, 32.99594], [-117.16371, 32.99602], [-117.1639, 32.99609], [-117.16408, 32.99609], [-117.16423, 32.99604], [-117.16439, 32.99592], [-117.16444, 32.99595], [-117.16444, 32.99607], [-117.16447, 32.99617], [-117.16456, 32.9963], [-117.16464, 32.99636], [-117.16481, 32.99645], [-117.16505, 32.99648], [-117.16509, 32.99655], [-117.16519, 32.99665], [-117.16537, 32.99673], [-117.16569, 32.99674], [-117.16583, 32.9967], [-117.16598, 32.99659], [-117.16605, 32.9965], [-117.16608, 32.99643], [-117.16613, 32.99642], [-117.16627, 32.99646], [-117.16642, 32.99647], [-117.16653, 32.99645], [-117.16662, 32.99642], [-117.16667, 32.99643], [-117.16675, 32.9965], [-117.16687, 32.99656], [-117.167, 32.9966], [-117.16706, 32.9966], [-117.1671, 32.99662], [-117.16715, 32.99675], [-117.16724, 32.99684], [-117.16743, 32.99694], [-117.16754, 32.99696], [-117.16765, 32.99697], [-117.16768, 32.99698], [-117.16771, 32.99704], [-117.16778, 32.99713], [-117.16796, 32.99724], [-117.16808, 32.99728], [-117.16826, 32.99729], [-117.16845, 32.99724], [-117.16853, 32.9972], [-117.16863, 32.99711], [-117.1687, 32.99703], [-117.16874, 32.99693], [-117.16875, 32.99677], [-117.1687, 32.99662], [-117.16861, 32.99651], [-117.16844, 32.9964], [-117.16846, 32.99635], [-117.16859, 32.9963], [-117.1687, 32.99625], [-117.16879, 32.99615], [-117.16885, 32.99606], [-117.16888, 32.99596], [-117.16888, 32.99583], [-117.16885, 32.99572], [-117.16881, 32.99565], [-117.16872, 32.99556], [-117.1686, 32.99549], [-117.16847, 32.99544], [-117.16835, 32.99543], [-117.1683, 32.99539], [-117.16824, 32.99527], [-117.16816, 32.9952], [-117.16807, 32.99514], [-117.16792, 32.99509], [-117.16779, 32.99508], [-117.16776, 32.99506], [-117.1677, 32.99495], [-117.16765, 32.99488], [-117.16752, 32.99479], [-117.16736, 32.99474], [-117.16714, 32.99473], [-117.16748, 32.99447], [-117.16741, 32.99439], [-117.16702, 32.99467], [-117.16693, 32.99459], [-117.16685, 32.99454], [-117.1667, 32.99449], [-117.16658, 32.99448], [-117.16654, 32.99443], [-117.16653, 32.99439], [-117.16649, 32.99428], [-117.16633, 32.99406], [-117.16632, 32.99377], [-117.16665, 32.99378], [-117.16668, 32.99384], [-117.16678, 32.99395], [-117.16689, 32.99402], [-117.167, 32.99405], [-117.16708, 32.99407], [-117.16723, 32.99407], [-117.16737, 32.99403], [-117.16741, 32.99404], [-117.16753, 32.99412], [-117.16759, 32.99447], [-117.16765, 32.99448], [-117.16761, 32.99416], [-117.16774, 32.9942], [-117.16796, 32.99419], [-117.16811, 32.99413], [-117.16824, 32.99404], [-117.16843, 32.99421], [-117.16852, 32.99414], [-117.16831, 32.99395], [-117.16837, 32.9938], [-117.16837, 32.99365], [-117.16834, 32.99358], [-117.16834, 32.99353], [-117.16845, 32.99342], [-117.1685, 32.99333], [-117.16852, 32.99325], [-117.16852, 32.9931], [-117.1685, 32.99302], [-117.16846, 32.99294], [-117.16839, 32.99288], [-117.16758, 32.99287], [-117.16755, 32.99292], [-117.16634, 32.99288], [-117.16634, 32.99275], [-117.16976, 32.99276], [-117.16987, 33.00435]], [[-117.16968, 32.99564], [-117.16969, 32.99496], [-117.16903, 32.99497], [-117.16903, 32.99563], [-117.16968, 32.99564]]], [[[-117.16787, 32.99899], [-117.16775, 32.99927], [-117.16756, 32.99927], [-117.16748, 32.99928], [-117.16734, 32.99934], [-117.16722, 32.99943], [-117.1673, 32.99912], [-117.16716, 32.99907], [-117.16693, 32.99948], [-117.16683, 32.99947], [-117.16671, 32.99947], [-117.16661, 32.99948], [-117.16642, 32.99957], [-117.1663, 32.99968], [-117.16626, 32.99969], [-117.16613, 32.99966], [-117.16602, 32.99967], [-117.16586, 32.9997], [-117.16568, 32.9998], [-117.16557, 32.99994], [-117.16552, 32.99996], [-117.16545, 32.99993], [-117.16532, 32.99989], [-117.16518, 32.99988], [-117.16503, 32.99991], [-117.16491, 32.99996], [-117.16482, 33.00002], [-117.16473, 33.00011], [-117.16467, 33.00022], [-117.16462, 33.00024], [-117.1645, 33.00022], [-117.16432, 33.00022], [-117.16415, 33.00026], [-117.16299, 33.0009], [-117.16285, 33.00102], [-117.16277, 33.00114], [-117.16274, 33.00116], [-117.16256, 33.00119], [-117.16239, 33.00127], [-117.16226, 33.00141], [-117.1622, 33.00154], [-117.16219, 33.00167], [-117.16222, 33.0018], [-117.16228, 33.0019], [-117.1624, 33.00201], [-117.16282, 33.00223], [-117.16273, 33.00238], [-117.16258, 33.00267], [-117.16234, 33.00255], [-117.16226, 33.00258], [-117.16231, 33.00281], [-117.16219, 33.00281], [-117.16209, 33.00277], [-117.16178, 33.00251], [-117.1616, 33.00241], [-117.16139, 33.00237], [-117.16094, 33.00235], [-117.16086, 33.00232], [-117.16078, 33.00228], [-117.16069, 33.00217], [-117.16067, 33.00211], [-117.16067, 33.002], [-117.1607, 33.0019], [-117.16098, 33.00192], [-117.16103, 33.00178], [-117.16079, 33.00164], [-117.16088, 33.00137], [-117.16091, 33.00121], [-117.16095, 33.00114], [-117.16095, 33.0011], [-117.16093, 33.00104], [-117.16085, 33.00097], [-117.16082, 33.0009], [-117.16073, 33.00079], [-117.16039, 33.00053], [-117.16072, 33.00022], [-117.16063, 33.00014], [-117.16073, 33.00003], [-117.16078, 32.99994], [-117.1608, 32.99987], [-117.16079, 32.9997], [-117.16083, 32.99965], [-117.16094, 32.99958], [-117.16103, 32.99946], [-117.16108, 32.99946], [-117.1612, 32.99956], [-117.16131, 32.99962], [-117.16142, 32.99966], [-117.16155, 32.99968], [-117.16168, 32.99967], [-117.16183, 32.99962], [-117.16193, 32.99957], [-117.16204, 32.99946], [-117.16209, 32.99945], [-117.16217, 32.99949], [-117.1623, 32.99952], [-117.16244, 32.99952], [-117.16262, 32.99947], [-117.16271, 32.99942], [-117.16277, 32.99942], [-117.16286, 32.99948], [-117.16306, 32.99954], [-117.16325, 32.99954], [-117.16339, 32.99951], [-117.16347, 32.99946], [-117.16351, 32.99946], [-117.16356, 32.9995], [-117.16369, 32.99954], [-117.16388, 32.99956], [-117.16406, 32.99952], [-117.1642, 32.99945], [-117.16435, 32.99952], [-117.16447, 32.99956], [-117.16469, 32.99957], [-117.16479, 32.99955], [-117.1649, 32.9995], [-117.16507, 32.99938], [-117.16511, 32.99937], [-117.16522, 32.99942], [-117.16534, 32.99945], [-117.16553, 32.99945], [-117.16572, 32.99938], [-117.16586, 32.99929], [-117.16592, 32.99928], [-117.16597, 32.99929], [-117.16612, 32.9993], [-117.1663, 32.99927], [-117.16642, 32.99921], [-117.16656, 32.9991], [-117.16659, 32.99909], [-117.16681, 32.9991], [-117.16695, 32.99908], [-117.16706, 32.99903], [-117.16717, 32.99895], [-117.16727, 32.99883], [-117.16731, 32.99873], [-117.16731, 32.9987], [-117.16756, 32.9989], [-117.16787, 32.99899]]], [[[-117.16739, 33.00447], [-117.16644, 33.00451], [-117.16595, 33.0045], [-117.16498, 33.00441], [-117.16428, 33.0043], [-117.16441, 33.00378], [-117.16452, 33.00377], [-117.16465, 33.00374], [-117.16486, 33.00361], [-117.16503, 33.00363], [-117.16516, 33.00362], [-117.1653, 33.00358], [-117.16542, 33.00352], [-117.16562, 33.00358], [-117.16575, 33.0036], [-117.16589, 33.00358], [-117.16606, 33.00353], [-117.16627, 33.00363], [-117.16641, 33.00367], [-117.16662, 33.00367], [-117.16679, 33.00361], [-117.16698, 33.00369], [-117.1671, 33.00371], [-117.16726, 33.00372], [-117.16739, 33.0037], [-117.16738, 33.00412], [-117.16739, 33.00447]]]]} | Open Access 1 | 18684 | Black Mountain Ranch Open Space | 16134 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 103.353 | Black Mtn. Ranch OS | 0 | Local Recreation Area 3 | 4 | |
16956 | 16956 | 16955 | {"type": "Polygon", "coordinates": [[[-117.16031, 32.9844], [-117.15965, 32.9845], [-117.15957, 32.98453], [-117.15945, 32.98441], [-117.15936, 32.98447], [-117.15935, 32.98448], [-117.15945, 32.98458], [-117.15939, 32.98464], [-117.15935, 32.98472], [-117.15931, 32.98481], [-117.15931, 32.98488], [-117.15927, 32.98491], [-117.15906, 32.98493], [-117.15891, 32.98501], [-117.15884, 32.98507], [-117.1588, 32.98514], [-117.15878, 32.98522], [-117.15879, 32.9853], [-117.15875, 32.98533], [-117.15852, 32.98535], [-117.15838, 32.98541], [-117.1583, 32.98549], [-117.15825, 32.98559], [-117.15823, 32.98567], [-117.15824, 32.98576], [-117.15821, 32.98579], [-117.15804, 32.98585], [-117.15793, 32.98594], [-117.15785, 32.98605], [-117.15784, 32.98621], [-117.15781, 32.98624], [-117.15772, 32.98624], [-117.15753, 32.98633], [-117.15744, 32.98642], [-117.15739, 32.98655], [-117.15736, 32.98657], [-117.1572, 32.98658], [-117.157, 32.98667], [-117.15691, 32.98678], [-117.15688, 32.98685], [-117.15683, 32.98687], [-117.15671, 32.98686], [-117.15662, 32.98688], [-117.15655, 32.9869], [-117.15647, 32.98694], [-117.1564, 32.98699], [-117.15634, 32.98707], [-117.15631, 32.98725], [-117.15627, 32.98727], [-117.15617, 32.98727], [-117.15605, 32.98729], [-117.15601, 32.98726], [-117.15597, 32.98717], [-117.15591, 32.9871], [-117.15574, 32.987], [-117.15556, 32.98698], [-117.15535, 32.98703], [-117.1553, 32.98702], [-117.15525, 32.98695], [-117.15538, 32.98682], [-117.15568, 32.98672], [-117.15581, 32.98661], [-117.15587, 32.98648], [-117.15587, 32.98632], [-117.15543, 32.98569], [-117.15555, 32.98562], [-117.15595, 32.98555], [-117.15638, 32.98529], [-117.1573, 32.985], [-117.158, 32.98464], [-117.15846, 32.98436], [-117.15869, 32.98408], [-117.15896, 32.98392], [-117.15958, 32.98399], [-117.15984, 32.98389], [-117.16004, 32.98356], [-117.16014, 32.98354], [-117.16019, 32.98368], [-117.16017, 32.9839], [-117.16031, 32.9844]]]} | Open Access 1 | 18693 | Black Mountain Ranch Open Space | 16134 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 14.839 | Black Mtn. Ranch OS | 0 | Local Recreation Area 3 | 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]);