units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where COUNTY = 4, DES_TP = 3 and MNG_AG_ID = 1262
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2778 | 2778 | 2777 | {"type": "Polygon", "coordinates": [[[-117.04655, 32.98981], [-117.04644, 32.99002], [-117.04624, 32.98988], [-117.04549, 32.99], [-117.04438, 32.98961], [-117.04432, 32.98956], [-117.04366, 32.98955], [-117.04282, 32.99048], [-117.04281, 32.99102], [-117.04207, 32.99065], [-117.04173, 32.99079], [-117.04172, 32.99156], [-117.04071, 32.99164], [-117.04067, 32.98935], [-117.04001, 32.98937], [-117.03979, 32.9893], [-117.03874, 32.9893], [-117.03872, 32.98932], [-117.0387, 32.98932], [-117.03452, 32.98928], [-117.03447, 32.98902], [-117.03441, 32.98896], [-117.03432, 32.98895], [-117.03425, 32.98881], [-117.03424, 32.98875], [-117.03456, 32.98881], [-117.03497, 32.98871], [-117.03501, 32.9882], [-117.03501, 32.98798], [-117.0346, 32.98742], [-117.03455, 32.98719], [-117.03413, 32.98665], [-117.03405, 32.9862], [-117.03378, 32.98578], [-117.03374, 32.98563], [-117.03632, 32.98566], [-117.03637, 32.9884], [-117.04066, 32.98844], [-117.04062, 32.98567], [-117.04493, 32.98579], [-117.04494, 32.98939], [-117.04639, 32.98941], [-117.04636, 32.98975], [-117.04655, 32.98981]]]} | Open Access 1 | 18531 | Twin Peaks Open Space | 26620 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://powaytrails.com/trails/TwinPeaksTrail/ | San Diego 4 | 81.613 | Twin Peaks OS | 0 | Local Recreation Area 3 | 4 |
2780 | 2780 | 2779 | {"type": "MultiPolygon", "coordinates": [[[[-116.97064, 32.98874], [-116.97048, 32.99571], [-116.97003, 32.99569], [-116.96974, 32.9957], [-116.96935, 32.99576], [-116.96907, 32.99583], [-116.96869, 32.99598], [-116.96747, 32.99662], [-116.96603, 32.99716], [-116.96572, 32.99726], [-116.96537, 32.99735], [-116.965, 32.99742], [-116.9641, 32.99752], [-116.96409, 32.99739], [-116.96193, 32.99737], [-116.96202, 32.99245], [-116.95777, 32.99241], [-116.95776, 32.9887], [-116.96204, 32.98869], [-116.97064, 32.98874]]], [[[-116.97043, 32.99718], [-116.97037, 33.00014], [-116.96611, 33.0001], [-116.96618, 32.99841], [-116.96646, 32.99827], [-116.968, 32.99778], [-116.96936, 32.99733], [-116.97043, 32.99718]]]]} | Open Access 1 | 18539 | Rock Haven Spring Open Space | 24509 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 244.004 | Rock Haven Spring OS | 0 | Local Recreation Area 3 | 4 | |
5097 | 5097 | 5096 | {"type": "Polygon", "coordinates": [[[-116.9621, 32.96655], [-116.96206, 32.97747], [-116.95777, 32.97762], [-116.95777, 32.98135], [-116.95346, 32.98146], [-116.95344, 32.9887], [-116.94488, 32.98869], [-116.94483, 32.98514], [-116.94043, 32.9852], [-116.94037, 32.97069], [-116.94486, 32.97075], [-116.95348, 32.97048], [-116.95351, 32.96324], [-116.9578, 32.9631], [-116.9578, 32.9667], [-116.9621, 32.96655]]]} | Open Access 1 | 12109 | Iron Mountain Open Space | 8834 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://powaytrails.com/trails/IronMountainPeakTrail/index.html | San Diego 4 | 884.734 | Iron Mtn. OS | 0 | Local Recreation Area 3 | 4 |
7816 | 7816 | 7815 | {"type": "MultiPolygon", "coordinates": [[[[-117.0238, 32.94716], [-117.02334, 32.94716], [-117.02334, 32.94677], [-117.0238, 32.94716], [-117.0238, 32.94716]]], [[[-117.02744, 32.94658], [-117.02719, 32.94638], [-117.02698, 32.94607], [-117.02686, 32.94597], [-117.02666, 32.94591], [-117.02635, 32.94586], [-117.02634, 32.94595], [-117.02591, 32.94584], [-117.02519, 32.94576], [-117.02518, 32.94566], [-117.02466, 32.94565], [-117.02465, 32.94555], [-117.02432, 32.94554], [-117.0241, 32.94551], [-117.02409, 32.94572], [-117.02373, 32.94561], [-117.02335, 32.94552], [-117.02335, 32.94532], [-117.02743, 32.94536], [-117.02744, 32.94658]]]]} | Open Access 1 | 45218 | City of Poway Open Space | 17328 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 5.096 | City of Poway OS | 0 | Local Recreation Area 3 | 4 | |
7819 | 7819 | 7818 | {"type": "Polygon", "coordinates": [[[-117.03972, 33.04402], [-117.03943, 33.0444], [-117.03888, 33.04486], [-117.03845, 33.04501], [-117.03841, 33.04513], [-117.03859, 33.04512], [-117.03865, 33.04535], [-117.03844, 33.04562], [-117.03814, 33.04572], [-117.03826, 33.04578], [-117.03836, 33.04591], [-117.03828, 33.04624], [-117.03818, 33.04641], [-117.03827, 33.04668], [-117.03823, 33.04682], [-117.03792, 33.04698], [-117.03759, 33.047], [-117.03783, 33.04722], [-117.03797, 33.04745], [-117.03789, 33.048], [-117.03771, 33.04806], [-117.0377, 33.04816], [-117.03778, 33.04815], [-117.03782, 33.04825], [-117.03805, 33.04818], [-117.03825, 33.0486], [-117.03828, 33.04894], [-117.03825, 33.04912], [-117.03773, 33.05005], [-117.03685, 33.05007], [-117.03641, 33.0508], [-117.03551, 33.05159], [-117.03526, 33.05167], [-117.03535, 33.05175], [-117.03535, 33.05196], [-117.03492, 33.05207], [-117.03493, 33.05208], [-117.03535, 33.05209], [-117.03564, 33.05265], [-117.03564, 33.05294], [-117.03546, 33.0533], [-117.03525, 33.05341], [-117.03491, 33.05349], [-117.03449, 33.05379], [-117.03405, 33.05399], [-117.03372, 33.05402], [-117.03355, 33.05395], [-117.0332, 33.0535], [-117.03299, 33.0536], [-117.03251, 33.05366], [-117.0322, 33.05358], [-117.0319, 33.05323], [-117.0317, 33.05276], [-117.03172, 33.0526], [-117.03161, 33.05254], [-117.03152, 33.05235], [-117.03142, 33.05222], [-117.03121, 33.05205], [-117.03118, 33.05189], [-117.031, 33.05176], [-117.03082, 33.05168], [-117.03078, 33.05199], [-117.03021, 33.05221], [-117.03018, 33.05235], [-117.03005, 33.05247], [-117.0298, 33.05251], [-117.02974, 33.05266], [-117.02965, 33.05275], [-117.02977, 33.05283], [-117.02994, 33.05303], [-117.02985, 33.05319], [-117.03003, 33.0532], [-117.03029, 33.05356], [-117.02997, 33.05366], [-117.03029, 33.05384], [-117.03015, 33.05422], [-117.02991, 33.05429], [-117.03009, 33.05449], [-117.0301, 33.0548], [-117.02958, 33.05524], [-117.02954, 33.05553], [-117.02843, 33.05665], [-117.02719, 33.05498], [-117.02941, 33.05187], [-117.02865, 33.05038], [-117.02823, 33.05039], [-117.02836, 33.05023], [-117.0285, 33.04996], [-117.02865, 33.04978], [-117.03273, 33.04973], [-117.03274, 33.04972], [-117.0327, 33.04686], [-117.03187, 33.04596], [-117.03187, 33.04407], [-117.0268, 33.04408], [-117.02681, 33.04403], [-117.02936, 33.04402], [-117.02925, 33.04297], [-117.02982, 33.0424], [-117.03205, 33.04177], [-117.03183, 33.03683], [-117.03128, 33.03703], [-117.03115, 33.03705], [-117.03105, 33.03702], [-117.03078, 33.03701], [-117.03029, 33.03705], [-117.03004, 33.03693], [-117.03, 33.03687], [-117.02993, 33.03669], [-117.02962, 33.03636], [-117.0295, 33.03605], [-117.02942, 33.03576], [-117.02934, 33.03565], [-117.02929, 33.03539], [-117.02918, 33.03537], [-117.0287, 33.03495], [-117.02858, 33.03483], [-117.02838, 33.03472], [-117.02919, 33.03406], [-117.02919, 33.03422], [-117.02916, 33.03453], [-117.02944, 33.03467], [-117.03002, 33.03461], [-117.03033, 33.03469], [-117.03025, 33.03518], [-117.02965, 33.03624], [-117.03035, 33.03686], [-117.03087, 33.03678], [-117.03125, 33.0362], [-117.03135, 33.03618], [-117.0315, 33.03609], [-117.03161, 33.03599], [-117.03171, 33.03587], [-117.03179, 33.03561], [-117.03179, 33.03547], [-117.03175, 33.03535], [-117.03168, 33.0352], [-117.03157, 33.03508], [-117.03066, 33.03436], [-117.03054, 33.03421], [-117.03048, 33.03405], [-117.03071, 33.034], [-117.03078, 33.03386], [-117.0313, 33.03387], [-117.03106, 33.03315], [-117.03106, 33.03288], [-117.03202, 33.03289], [-117.03187, 33.03648], [-117.03222, 33.04407], [-117.03972, 33.04402]]]} | No Public Access 3 | 45249 | City of Poway Open Space | 17327 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 193.801 | City of Poway OS | 0 | Local Recreation Area 3 | 4 | |
10532 | 10532 | 10531 | {"type": "Polygon", "coordinates": [[[-117.05671, 32.95304], [-117.05614, 32.95389], [-117.05578, 32.95413], [-117.05577, 32.95408], [-117.05583, 32.954], [-117.05584, 32.95393], [-117.05578, 32.95385], [-117.05568, 32.95383], [-117.05559, 32.95385], [-117.05553, 32.95393], [-117.05553, 32.954], [-117.0556, 32.95414], [-117.05469, 32.95412], [-117.05472, 32.95331], [-117.05528, 32.95332], [-117.05529, 32.95302], [-117.05671, 32.95304]]]} | Open Access 1 | 18728 | Kumeyaay-Ipai Interpretive Center | 20730 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/369/Kumeyaay-Ipai-Interpretive-Center-at-Pau | San Diego 4 | 3.976 | Kumeyaay-Ipai Interpretive Ctr. | 0 | Local Recreation Area 3 | 4 |
15124 | 15124 | 15123 | {"type": "Polygon", "coordinates": [[[-117.04737, 32.9529], [-117.04734, 32.95404], [-117.04654, 32.95403], [-117.04656, 32.95289], [-117.04737, 32.9529]]]} | Open Access 1 | 45988 | Valley Soccer Field | 29157 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/Facilities/Facility/Details/Valley-Soccer-Field-56 | San Diego 4 | 2.335 | Valley Soccer Field | 0 | Local Recreation Area 3 | 4 |
15147 | 15147 | 15146 | {"type": "Polygon", "coordinates": [[[-117.06234, 32.97546], [-117.06232, 32.97691], [-117.06225, 32.97692], [-117.06223, 32.97788], [-117.0613, 32.97786], [-117.0613, 32.97764], [-117.06135, 32.9775], [-117.06136, 32.97709], [-117.06132, 32.97698], [-117.06131, 32.97586], [-117.06151, 32.97583], [-117.06157, 32.97545], [-117.06234, 32.97546]]]} | Open Access 1 | 45981 | Arbolitos Sports Field | 29149 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/Facilities/Facility/Details/Arbolitos-Sports-Fields-54 | San Diego 4 | 5.82 | Arbolitos Sports Field | 0 | Local Recreation Area 3 | 4 |
15981 | 15981 | 15980 | {"type": "MultiPolygon", "coordinates": [[[[-117.00783, 32.9815], [-117.00555, 32.98149], [-117.001, 32.98141], [-117.00106, 32.98524], [-117.00045, 32.98523], [-117.00039, 32.98326], [-116.99861, 32.9819], [-116.99807, 32.98189], [-116.99806, 32.98292], [-116.99648, 32.98272], [-116.99645, 32.98134], [-117.00099, 32.98141], [-117.00094, 32.97758], [-117.00554, 32.97769], [-117.00565, 32.97649], [-117.00627, 32.97651], [-117.00622, 32.97771], [-117.00782, 32.97775], [-117.00783, 32.9815]]], [[[-117.00985, 32.97663], [-117.00979, 32.97779], [-117.00848, 32.97776], [-117.00855, 32.97659], [-117.00887, 32.97659], [-117.0089, 32.976], [-117.00956, 32.97602], [-117.00953, 32.97661], [-117.00985, 32.97663]]], [[[-117.01083, 32.97545], [-117.01082, 32.97665], [-117.01018, 32.97663], [-117.01024, 32.97543], [-117.01083, 32.97545]]], [[[-117.01212, 32.97608], [-117.01212, 32.97667], [-117.01147, 32.97666], [-117.01147, 32.97607], [-117.01212, 32.97608]]]]} | Open Access 1 | 871 | Rattlesnake Canyon Open Space | 24193 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://powaytrails.com/trails/RattlesnakeCanyonTrail/ | San Diego 4 | 94.949 | Rattlesnake Canyon OS | 0 | Local Recreation Area 3 | 4 |
15984 | 15984 | 15983 | {"type": "MultiPolygon", "coordinates": [[[[-117.01745, 32.97317], [-117.01673, 32.97377], [-117.01616, 32.97367], [-117.0147, 32.97437], [-117.01469, 32.97117], [-117.01603, 32.9703], [-117.01612, 32.97046], [-117.01672, 32.97243], [-117.01677, 32.97256], [-117.01688, 32.97275], [-117.01705, 32.97293], [-117.01726, 32.97308], [-117.01745, 32.97317]]], [[[-117.02324, 32.97449], [-117.02117, 32.97444], [-117.0206, 32.97421], [-117.02056, 32.97425], [-117.01967, 32.97394], [-117.01919, 32.97374], [-117.01744, 32.97297], [-117.01714, 32.97277], [-117.01698, 32.97256], [-117.01694, 32.97247], [-117.01632, 32.97046], [-117.01634, 32.97023], [-117.01633, 32.97019], [-117.01676, 32.9699], [-117.01863, 32.96989], [-117.01857, 32.96994], [-117.01835, 32.97001], [-117.01819, 32.9701], [-117.0181, 32.97017], [-117.01791, 32.97039], [-117.01781, 32.97069], [-117.01781, 32.97085], [-117.01785, 32.971], [-117.01791, 32.97115], [-117.01801, 32.97128], [-117.01814, 32.9714], [-117.01829, 32.97149], [-117.01829, 32.97223], [-117.01854, 32.97243], [-117.01913, 32.97247], [-117.01989, 32.97239], [-117.02069, 32.97245], [-117.02147, 32.97268], [-117.02213, 32.97268], [-117.02273, 32.97236], [-117.02272, 32.9717], [-117.02324, 32.97153], [-117.02323, 32.9728], [-117.02324, 32.97449]]]]} | Open Access 1 | 874 | Kent Hill Open Space | 20617 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 50.693 | Kent Hill OS | 0 | Local Recreation Area 3 | 4 | |
16009 | 16009 | 16008 | {"type": "Polygon", "coordinates": [[[-117.08418, 32.96087], [-117.07554, 32.96077], [-117.07544, 32.95335], [-117.08186, 32.95344], [-117.0818, 32.94971], [-117.08397, 32.94974], [-117.08418, 32.96087]]]} | Open Access 1 | 1755 | Van Dam Peak Open Space | 26824 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 184.238 | Van Dam Peak OS | 0 | Local Recreation Area 3 | 4 | |
16793 | 16793 | 16792 | {"type": "Polygon", "coordinates": [[[-117.02024, 33.0132], [-117.01973, 33.01329], [-117.0196, 33.01327], [-117.01881, 33.01276], [-117.018, 33.01241], [-117.01699, 33.01269], [-117.01603, 33.01335], [-117.0148, 33.01197], [-117.01092, 33.01197], [-117.01053, 33.01217], [-117.01035, 33.01452], [-117.00984, 33.01458], [-117.00983, 33.01471], [-117.00833, 33.01476], [-117.00624, 33.01481], [-117.00662, 33.00841], [-117.00447, 33.0083], [-117.0041, 33.00787], [-117.00411, 33.00748], [-117.0041, 33.00747], [-116.99613, 33.00752], [-116.99177, 33.00753], [-116.99176, 33.00754], [-116.9918, 33.01127], [-116.98318, 33.01121], [-116.98315, 33.01495], [-116.97885, 33.01493], [-116.97017, 33.01493], [-116.9702, 33.0112], [-116.9788, 33.01115], [-116.97875, 33.00754], [-116.9793, 33.00015], [-116.99639, 33.00024], [-117.00082, 33.0003], [-117.00071, 33.00386], [-117.00072, 33.00387], [-117.00323, 33.00389], [-117.00335, 33.00307], [-117.00395, 33.00205], [-117.00488, 33.00136], [-117.00515, 33.00129], [-117.0052, 33.00035], [-117.00982, 33.00045], [-117.01302, 33.00155], [-117.013, 33.0022], [-117.01471, 33.00223], [-117.01512, 33.00498], [-117.01486, 33.00487], [-117.01466, 33.00484], [-117.01433, 33.00461], [-117.01429, 33.00438], [-117.01365, 33.00411], [-117.01328, 33.00425], [-117.01277, 33.00428], [-117.0125, 33.00436], [-117.01219, 33.00453], [-117.01208, 33.00455], [-117.0117, 33.00453], [-117.01146, 33.00478], [-117.01165, 33.00521], [-117.01182, 33.00566], [-117.012, 33.006], [-117.01222, 33.00624], [-117.01252, 33.00648], [-117.01283, 33.00659], [-117.01299, 33.0066], [-117.01312, 33.00668], [-117.01322, 33.00686], [-117.01302, 33.00707], [-117.01262, 33.00736], [-117.01255, 33.00743], [-117.01258, 33.00747], [-117.01271, 33.00748], [-117.01322, 33.00711], [-117.01354, 33.0068], [-117.01373, 33.0068], [-117.01388, 33.00715], [-117.01392, 33.00721], [-117.01462, 33.00698], [-117.01499, 33.00722], [-117.01517, 33.0073], [-117.01536, 33.00733], [-117.01537, 33.00741], [-117.01711, 33.00742], [-117.01752, 33.00747], [-117.01811, 33.00749], [-117.01833, 33.00748], [-117.01751, 33.00817], [-117.01851, 33.00899], [-117.01915, 33.009], [-117.01873, 33.01011], [-117.0188, 33.01053], [-117.01946, 33.01161], [-117.01963, 33.01217], [-117.01992, 33.01273], [-117.02024, 33.0132]]]} | Open Access 1 | 5420 | Lake Poway Recreation Area | 8838 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/401/Lake-Poway | San Diego 4 | 1034.046 | Lake Poway Rec. Area | 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]);