units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
47 rows where MNG_AGENCY = 393 and MNG_AG_LEV = 3
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12860 | 12860 | 12859 | {"type": "Polygon", "coordinates": [[[-118.92094, 35.26064], [-118.92094, 35.26078], [-118.92083, 35.26117], [-118.9208, 35.26133], [-118.92079, 35.26238], [-118.92076, 35.2625], [-118.91898, 35.26249], [-118.91898, 35.26218], [-118.91879, 35.26218], [-118.91881, 35.2621], [-118.91881, 35.26185], [-118.91888, 35.26169], [-118.9189, 35.26159], [-118.91893, 35.26064], [-118.92094, 35.26064]]]} | Open Access 1 | 44540 | Bear Mountain Park | 15927 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 8.928 | Bear Mtn. Park | 0 | Local Park 2 | 4 | |
14405 | 14405 | 14404 | {"type": "Polygon", "coordinates": [[[-118.92234, 35.44163], [-118.92219, 35.44638], [-118.92126, 35.44628], [-118.92146, 35.44665], [-118.92159, 35.44693], [-118.92112, 35.44702], [-118.92068, 35.44717], [-118.9203, 35.44738], [-118.91994, 35.44765], [-118.91962, 35.44796], [-118.91919, 35.44851], [-118.91879, 35.4491], [-118.91878, 35.44916], [-118.91872, 35.44927], [-118.91845, 35.44971], [-118.91833, 35.44981], [-118.9183, 35.44982], [-118.91816, 35.44998], [-118.91798, 35.45014], [-118.9178, 35.45027], [-118.91763, 35.45037], [-118.91739, 35.45047], [-118.91723, 35.45051], [-118.917, 35.45054], [-118.9167, 35.45052], [-118.91548, 35.45084], [-118.91529, 35.45085], [-118.91424, 35.45079], [-118.91402, 35.45083], [-118.91379, 35.4509], [-118.9136, 35.45099], [-118.9134, 35.4511], [-118.91018, 35.45334], [-118.90997, 35.45345], [-118.90971, 35.45354], [-118.9095, 35.45359], [-118.90913, 35.45364], [-118.90894, 35.45362], [-118.90877, 35.45356], [-118.90823, 35.45324], [-118.9074, 35.45284], [-118.90623, 35.45205], [-118.90606, 35.45191], [-118.90591, 35.45176], [-118.90556, 35.45121], [-118.90548, 35.45113], [-118.90539, 35.45107], [-118.90524, 35.451], [-118.90508, 35.45098], [-118.90495, 35.45098], [-118.90455, 35.45105], [-118.90454, 35.44874], [-118.90448, 35.44871], [-118.90448, 35.44879], [-118.9044, 35.44866], [-118.90341, 35.44814], [-118.90267, 35.44759], [-118.90229, 35.44713], [-118.90156, 35.44537], [-118.90137, 35.44486], [-118.90137, 35.44416], [-118.90119, 35.44244], [-118.90097, 35.44183], [-118.90087, 35.44164], [-118.90313, 35.44162], [-118.90315, 35.44177], [-118.90442, 35.44176], [-118.9141, 35.44165], [-118.92115, 35.4416], [-118.92116, 35.44164], [-118.92234, 35.44163]]]} | Open Access 1 | 44511 | Hart Memorial Park | 4798 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/hart.asp | Kern 36 | 452.604 | Hart Memorial Park | 0 | Local Park 2 | 4 |
14423 | 14423 | 14422 | {"type": "Polygon", "coordinates": [[[-118.89503, 35.43798], [-118.8932, 35.43744], [-118.8921, 35.43698], [-118.89108, 35.43666], [-118.88971, 35.43648], [-118.88774, 35.43601], [-118.88634, 35.43587], [-118.8853, 35.43568], [-118.88447, 35.43566], [-118.88384, 35.43552], [-118.88345, 35.43532], [-118.88285, 35.43512], [-118.8823, 35.43512], [-118.88181, 35.43521], [-118.88064, 35.43561], [-118.87884, 35.43595], [-118.87878, 35.43599], [-118.87872, 35.436], [-118.87859, 35.4361], [-118.87849, 35.43613], [-118.87832, 35.43627], [-118.87806, 35.4364], [-118.87778, 35.43659], [-118.87743, 35.43674], [-118.87721, 35.43681], [-118.87713, 35.4368], [-118.87708, 35.43682], [-118.87701, 35.43694], [-118.8769, 35.43695], [-118.87683, 35.437], [-118.8768, 35.43705], [-118.87664, 35.43711], [-118.87656, 35.43717], [-118.87648, 35.43722], [-118.87638, 35.43724], [-118.87625, 35.43734], [-118.87623, 35.43739], [-118.87605, 35.43746], [-118.87595, 35.43756], [-118.87576, 35.43766], [-118.87559, 35.43768], [-118.87553, 35.43767], [-118.87541, 35.43771], [-118.87532, 35.43785], [-118.87517, 35.43791], [-118.87508, 35.43799], [-118.87493, 35.43804], [-118.87444, 35.4383], [-118.87429, 35.43835], [-118.87399, 35.43851], [-118.87393, 35.43852], [-118.87375, 35.43861], [-118.87368, 35.43867], [-118.87354, 35.43872], [-118.87335, 35.43885], [-118.87325, 35.43889], [-118.87313, 35.439], [-118.87291, 35.43912], [-118.87277, 35.43913], [-118.87248, 35.43931], [-118.87229, 35.43937], [-118.87152, 35.43985], [-118.87145, 35.43988], [-118.87128, 35.44002], [-118.87106, 35.4401], [-118.87095, 35.44019], [-118.87085, 35.44021], [-118.87072, 35.44029], [-118.87053, 35.44045], [-118.87019, 35.44063], [-118.86968, 35.44099], [-118.86945, 35.44112], [-118.86932, 35.44123], [-118.86906, 35.44134], [-118.86895, 35.44143], [-118.86885, 35.44145], [-118.86875, 35.44151], [-118.8677, 35.44167], [-118.86747, 35.4419], [-118.86394, 35.44271], [-118.86275, 35.44311], [-118.86178, 35.44324], [-118.86038, 35.44326], [-118.8596, 35.44317], [-118.85867, 35.44332], [-118.8579, 35.44322], [-118.85729, 35.4433], [-118.8594, 35.44002], [-118.85983, 35.4394], [-118.86002, 35.43896], [-118.86016, 35.4381], [-118.86048, 35.43724], [-118.86031, 35.43629], [-118.86022, 35.43526], [-118.85964, 35.43288], [-118.86038, 35.43265], [-118.86056, 35.43256], [-118.86067, 35.43249], [-118.8608, 35.43236], [-118.86089, 35.43221], [-118.86095, 35.43204], [-118.86099, 35.43182], [-118.86108, 35.432], [-118.86119, 35.43216], [-118.86133, 35.43231], [-118.8614, 35.43232], [-118.8614, 35.43253], [-118.86408, 35.43304], [-118.86534, 35.43316], [-118.86558, 35.43321], [-118.86576, 35.43326], [-118.86597, 35.43336], [-118.86725, 35.43416], [-118.8674, 35.43424], [-118.86756, 35.43429], [-118.86785, 35.43433], [-118.86986, 35.43433], [-118.87018, 35.43437], [-118.87037, 35.43443], [-118.87054, 35.43452], [-118.87154, 35.4353], [-118.87178, 35.43542], [-118.87199, 35.43542], [-118.87434, 35.43556], [-118.87453, 35.43553], [-118.8747, 35.43547], [-118.87484, 35.43537], [-118.87493, 35.43526], [-118.87499, 35.43512], [-118.87518, 35.43422], [-118.87523, 35.43411], [-118.87532, 35.43399], [-118.87706, 35.43257], [-118.87726, 35.43245], [-118.87745, 35.43238], [-118.87884, 35.43214], [-118.88119, 35.43152], [-118.88136, 35.43149], [-118.88157, 35.43149], [-118.88183, 35.43153], [-118.88199, 35.43159], [-118.88242, 35.43183], [-118.88258, 35.4319], [-118.8828, 35.43195], [-118.88302, 35.43196], [-118.88371, 35.43187], [-118.88569, 35.43167], [-118.88774, 35.43136], [-118.88827, 35.43089], [-118.88977, 35.43097], [-118.8905, 35.43106], [-118.89101, 35.43118], [-118.8915, 35.43133], [-118.89386, 35.43222], [-118.89387, 35.43251], [-118.89375, 35.4332], [-118.89361, 35.4339], [-118.89361, 35.43438], [-118.89384, 35.43522], [-118.8939, 35.43612], [-118.89446, 35.43696], [-118.89497, 35.4379], [-118.89503, 35.43798]]]} | Open Access 1 | 44539 | Lake Ming | 20954 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ming.asp | Kern 36 | 496.587 | Lake Ming | None 1227 | ||
15718 | 15718 | 15717 | {"type": "Polygon", "coordinates": [[[-118.86048, 35.43724], [-118.86016, 35.4381], [-118.86002, 35.43895], [-118.85983, 35.4394], [-118.8594, 35.44002], [-118.85729, 35.4433], [-118.85404, 35.44375], [-118.85191, 35.44323], [-118.85136, 35.44191], [-118.85208, 35.44189], [-118.85209, 35.44188], [-118.85187, 35.44165], [-118.85179, 35.44152], [-118.8517, 35.44143], [-118.85151, 35.44114], [-118.85136, 35.4408], [-118.85127, 35.44037], [-118.85124, 35.4397], [-118.85125, 35.43952], [-118.85142, 35.43847], [-118.85168, 35.4376], [-118.85179, 35.43699], [-118.85188, 35.43672], [-118.85194, 35.43629], [-118.85201, 35.43606], [-118.85205, 35.43585], [-118.85218, 35.43553], [-118.85249, 35.43501], [-118.85257, 35.43462], [-118.85274, 35.43427], [-118.85284, 35.43411], [-118.85288, 35.4338], [-118.85293, 35.43364], [-118.85293, 35.4334], [-118.853, 35.43324], [-118.85845, 35.4332], [-118.85874, 35.43316], [-118.85964, 35.43288], [-118.86022, 35.43526], [-118.86031, 35.43629], [-118.86048, 35.43724]]]} | Restricted Access 2 | 44512 | Kern River Golf Course | 33105 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 196.033 | Kern River GC | 0 | Local Recreation Area 3 | 4 | |
16915 | 16915 | 16914 | {"type": "MultiPolygon", "coordinates": [[[[-118.55557, 35.73088], [-118.55556, 35.73119], [-118.55539, 35.73137], [-118.55496, 35.73155], [-118.55489, 35.7315], [-118.55458, 35.73136], [-118.55422, 35.73112], [-118.55404, 35.73098], [-118.55396, 35.73086], [-118.5538, 35.73054], [-118.55363, 35.73035], [-118.55335, 35.73013], [-118.55322, 35.73008], [-118.55318, 35.7297], [-118.55313, 35.72873], [-118.55429, 35.72874], [-118.55453, 35.72926], [-118.55471, 35.72961], [-118.55484, 35.72999], [-118.55508, 35.73041], [-118.55548, 35.73074], [-118.55557, 35.73088]]], [[[-118.55573, 35.7367], [-118.55568, 35.73677], [-118.55557, 35.73688], [-118.55555, 35.73668], [-118.55544, 35.73626], [-118.55522, 35.7358], [-118.55505, 35.73555], [-118.55484, 35.73541], [-118.55472, 35.73539], [-118.5544, 35.73526], [-118.5543, 35.73523], [-118.55412, 35.73513], [-118.5535, 35.73503], [-118.55338, 35.73507], [-118.55333, 35.73249], [-118.55329, 35.7318], [-118.55328, 35.73132], [-118.55325, 35.73116], [-118.55323, 35.7308], [-118.55321, 35.73036], [-118.55322, 35.73027], [-118.55338, 35.73036], [-118.55359, 35.73057], [-118.5539, 35.73111], [-118.55439, 35.73144], [-118.55479, 35.73164], [-118.55484, 35.73168], [-118.55502, 35.73189], [-118.5551, 35.73203], [-118.55509, 35.73215], [-118.55463, 35.73245], [-118.55451, 35.73255], [-118.55388, 35.73323], [-118.55381, 35.73332], [-118.55374, 35.73359], [-118.55371, 35.73407], [-118.55371, 35.73421], [-118.55375, 35.73436], [-118.55378, 35.73443], [-118.55386, 35.73455], [-118.55395, 35.73465], [-118.5543, 35.73482], [-118.55461, 35.73501], [-118.55476, 35.73513], [-118.55491, 35.73521], [-118.55571, 35.73652], [-118.55573, 35.7367]]], [[[-118.55674, 35.73728], [-118.55665, 35.73741], [-118.55655, 35.73759], [-118.55659, 35.73777], [-118.55658, 35.73791], [-118.55656, 35.738], [-118.55656, 35.73809], [-118.55646, 35.73848], [-118.5565, 35.73879], [-118.55662, 35.73902], [-118.55658, 35.73912], [-118.55655, 35.73942], [-118.55657, 35.73969], [-118.55656, 35.73985], [-118.55662, 35.74019], [-118.55661, 35.74026], [-118.55666, 35.74056], [-118.55667, 35.74083], [-118.55663, 35.74111], [-118.55656, 35.74142], [-118.55649, 35.74166], [-118.55604, 35.74248], [-118.55585, 35.74296], [-118.5536, 35.74299], [-118.55355, 35.73983], [-118.55341, 35.7353], [-118.55353, 35.73528], [-118.55405, 35.73535], [-118.55452, 35.73554], [-118.55463, 35.73561], [-118.55473, 35.73562], [-118.55487, 35.7357], [-118.55498, 35.73588], [-118.55511, 35.73614], [-118.55513, 35.73624], [-118.5552, 35.73633], [-118.55529, 35.73671], [-118.5553, 35.73682], [-118.55532, 35.73692], [-118.55532, 35.73708], [-118.55529, 35.73723], [-118.5553, 35.73746], [-118.55537, 35.73761], [-118.55544, 35.7377], [-118.55552, 35.73775], [-118.55569, 35.73781], [-118.55584, 35.73778], [-118.556, 35.73772], [-118.55639, 35.73742], [-118.55667, 35.73728], [-118.55674, 35.73728]]], [[[-118.55756, 35.72879], [-118.55768, 35.72908], [-118.55787, 35.72977], [-118.55806, 35.73018], [-118.55809, 35.73254], [-118.5582, 35.73546], [-118.55786, 35.73629], [-118.55759, 35.7371], [-118.55762, 35.73762], [-118.55754, 35.73781], [-118.5573, 35.73805], [-118.55716, 35.73822], [-118.55703, 35.7384], [-118.55694, 35.73856], [-118.55678, 35.73879], [-118.55674, 35.7387], [-118.55672, 35.73846], [-118.55683, 35.7381], [-118.55685, 35.7378], [-118.55683, 35.73764], [-118.55686, 35.73756], [-118.557, 35.7374], [-118.55702, 35.73723], [-118.55697, 35.73714], [-118.55689, 35.73707], [-118.55677, 35.73703], [-118.55666, 35.73704], [-118.55651, 35.73709], [-118.55623, 35.73724], [-118.55607, 35.73734], [-118.55586, 35.73752], [-118.55579, 35.73756], [-118.55571, 35.73757], [-118.55563, 35.73754], [-118.55557, 35.73745], [-118.55555, 35.73732], [-118.55555, 35.73724], [-118.55558, 35.73709], [-118.55567, 35.73705], [-118.55573, 35.737], [-118.5559, 35.73679], [-118.55592, 35.73672], [-118.55592, 35.73665], [-118.55592, 35.73656], [-118.5559, 35.73647], [-118.55505, 35.7351], [-118.55433, 35.73463], [-118.55413, 35.73456], [-118.55401, 35.73446], [-118.55397, 35.7344], [-118.55393, 35.73432], [-118.55391, 35.73408], [-118.55393, 35.73381], [-118.55393, 35.73368], [-118.55394, 35.7336], [-118.55401, 35.73338], [-118.55464, 35.73268], [-118.55485, 35.73251], [-118.55521, 35.73231], [-118.55529, 35.73221], [-118.55531, 35.73215], [-118.55529, 35.73198], [-118.55519, 35.7318], [-118.55509, 35.73169], [-118.55554, 35.73149], [-118.55576, 35.73124], [-118.55578, 35.73084], [-118.55564, 35.73064], [-118.55526, 35.73032], [-118.55503, 35.72993], [-118.5549, 35.72955], [-118.55471, 35.7292], [-118.55449, 35.72874], [-118.55756, 35.72879]]], [[[-118.55745, 35.74297], [-118.55612, 35.74297], [-118.55632, 35.74247], [-118.55639, 35.74238], [-118.55669, 35.74184], [-118.55683, 35.74146], [-118.55691, 35.74095], [-118.55694, 35.74065], [-118.55683, 35.73984], [-118.55683, 35.73926], [-118.55687, 35.73932], [-118.55716, 35.73994], [-118.55724, 35.74025], [-118.55735, 35.74056], [-118.55737, 35.7407], [-118.55736, 35.74076], [-118.55738, 35.74088], [-118.55746, 35.7411], [-118.55747, 35.7413], [-118.55741, 35.74163], [-118.55742, 35.74171], [-118.55745, 35.74181], [-118.55744, 35.74237], [-118.55749, 35.7426], [-118.55748, 35.74283], [-118.55745, 35.74297]]], [[[-118.5584, 35.74294], [-118.55766, 35.74294], [-118.55769, 35.7426], [-118.55763, 35.74228], [-118.55765, 35.74183], [-118.55761, 35.7416], [-118.55764, 35.74153], [-118.55764, 35.74145], [-118.55766, 35.74138], [-118.55766, 35.74108], [-118.55758, 35.74084], [-118.55756, 35.74061], [-118.55744, 35.7402], [-118.55741, 35.74013], [-118.55735, 35.73989], [-118.55714, 35.73942], [-118.55709, 35.73936], [-118.55701, 35.73918], [-118.55689, 35.73898], [-118.55698, 35.73887], [-118.55733, 35.73831], [-118.55746, 35.73815], [-118.55771, 35.73791], [-118.55777, 35.7378], [-118.55782, 35.73763], [-118.55779, 35.73712], [-118.55809, 35.73623], [-118.55816, 35.73611], [-118.55823, 35.73591], [-118.5584, 35.74294]]], [[[-118.55808, 35.7297], [-118.55802, 35.72959], [-118.55792, 35.7292], [-118.55777, 35.72878], [-118.55807, 35.72877], [-118.55808, 35.7297]]]]} | Open Access 1 | 16423 | Greenhorn Mountain Park | 19480 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 151.909 | Greenhorn Mtn. Park | 0 | Local Park 2 | 4 | |
16919 | 16919 | 16918 | {"type": "Polygon", "coordinates": [[[-118.40951, 35.6372], [-118.40949, 35.63724], [-118.40946, 35.63726], [-118.40939, 35.63726], [-118.40786, 35.63652], [-118.40879, 35.6353], [-118.40918, 35.6355], [-118.40922, 35.63555], [-118.40929, 35.63558], [-118.40933, 35.63565], [-118.40951, 35.6372]]]} | Open Access 1 | 45613 | Mountain Mesa Park | 28441 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 4.52 | Mtn. Mesa Park | 0 | Local Park 2 | 4 | |
16925 | 16925 | 16924 | {"type": "Polygon", "coordinates": [[[-119.02667, 35.39563], [-119.02663, 35.3959], [-119.02664, 35.39629], [-119.02662, 35.39646], [-119.02651, 35.39681], [-119.02638, 35.39701], [-119.02618, 35.39724], [-119.02598, 35.3974], [-119.02582, 35.39749], [-119.02557, 35.39761], [-119.02484, 35.39761], [-119.02316, 35.39817], [-119.02118, 35.39851], [-119.02117, 35.39894], [-119.01888, 35.39893], [-119.01891, 35.39267], [-119.01979, 35.39267], [-119.01979, 35.39195], [-119.02098, 35.39198], [-119.02096, 35.3976], [-119.02119, 35.39758], [-119.02118, 35.39217], [-119.02214, 35.39216], [-119.02667, 35.39563]]]} | Open Access 1 | 16493 | Metropolitan Recreation Center | 22188 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 93.734 | Metropolitan Rec. Ctr. | 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]);