units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where AGNCY_NAME = 104, AGNCY_WEB = "http://www.sandiegocounty.gov/parks/" and DES_TP = 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4991 | 4991 | 4990 | {"type": "Polygon", "coordinates": [[[-116.11014, 32.64478], [-116.108, 32.64477], [-116.10711, 32.64478], [-116.10763, 32.64374], [-116.10765, 32.64374], [-116.11013, 32.64378], [-116.11014, 32.64478]]]} | Open Access 1 | 793 | In-Ko-Pah County Open Space | 20184 | 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 | 7.223 | In-Ko-Pah County OS | 0 | Local Recreation Area 3 | 4 | |
| 6543 | 6543 | 6542 | {"type": "MultiPolygon", "coordinates": [[[[-116.91618, 32.84986], [-116.9158, 32.84995], [-116.91515, 32.85059], [-116.91472, 32.8507], [-116.91484, 32.85107], [-116.91525, 32.85324], [-116.914, 32.85341], [-116.91334, 32.84972], [-116.91177, 32.85009], [-116.91176, 32.8484], [-116.91061, 32.84865], [-116.91064, 32.84184], [-116.91071, 32.84181], [-116.91116, 32.84154], [-116.91129, 32.84149], [-116.91356, 32.84095], [-116.91405, 32.84103], [-116.91448, 32.84114], [-116.91479, 32.84146], [-116.915, 32.84173], [-116.91513, 32.84194], [-116.91535, 32.84238], [-116.91387, 32.84275], [-116.91387, 32.8431], [-116.91389, 32.84327], [-116.91385, 32.84344], [-116.91387, 32.84357], [-116.91404, 32.84404], [-116.91344, 32.84419], [-116.91364, 32.84485], [-116.91326, 32.84494], [-116.91351, 32.84573], [-116.9139, 32.84565], [-116.91406, 32.84614], [-116.91209, 32.84661], [-116.91189, 32.84834], [-116.9119, 32.84835], [-116.91259, 32.8482], [-116.91322, 32.84866], [-116.91397, 32.84868], [-116.91489, 32.84935], [-116.91522, 32.84928], [-116.91542, 32.84981], [-116.91562, 32.84978], [-116.91611, 32.84965], [-116.91618, 32.84986]]], [[[-116.91703, 32.84504], [-116.91654, 32.84516], [-116.91648, 32.845], [-116.91697, 32.84488], [-116.91703, 32.84504]]], [[[-116.92242, 32.84101], [-116.92235, 32.84257], [-116.92092, 32.84275], [-116.92092, 32.84281], [-116.9208, 32.84282], [-116.92081, 32.84283], [-116.92096, 32.84286], [-116.91974, 32.84281], [-116.9197, 32.84288], [-116.91955, 32.84329], [-116.91951, 32.84385], [-116.91966, 32.84457], [-116.92002, 32.84461], [-116.92028, 32.84451], [-116.92094, 32.84452], [-116.92115, 32.84448], [-116.92125, 32.84507], [-116.92138, 32.84613], [-116.91821, 32.84687], [-116.91757, 32.84492], [-116.91719, 32.845], [-116.91704, 32.84458], [-116.91742, 32.84449], [-116.91717, 32.8437], [-116.91815, 32.84346], [-116.918, 32.84236], [-116.92076, 32.84171], [-116.92055, 32.84013], [-116.9205, 32.83964], [-116.92053, 32.83965], [-116.92219, 32.83949], [-116.92242, 32.84101]]]]} | Open Access 1 | 5015 | Lakeside Archipelago Open Space | 20975 | 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 | 122.828 | Lakeside Archipelago OS | 0 | Local Recreation Area 3 | 4 | |
| 6739 | 6739 | 6738 | {"type": "Polygon", "coordinates": [[[-116.1145, 32.65367], [-116.10581, 32.65366], [-116.10581, 32.64737], [-116.10624, 32.6465], [-116.11446, 32.64653], [-116.1145, 32.65367]]]} | Open Access 1 | 5151 | County Open Space | 29240 | 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 | 158.984 | County OS | 0 | Local Recreation Area 3 | 4 | |
| 6795 | 6795 | 6794 | {"type": "MultiPolygon", "coordinates": [[[[-117.23538, 33.37666], [-117.23537, 33.37797], [-117.23496, 33.37797], [-117.23496, 33.37696], [-117.23431, 33.37695], [-117.23431, 33.37662], [-117.2353, 33.37661], [-117.23535, 33.37663], [-117.23538, 33.37666]]], [[[-117.23748, 33.37662], [-117.23725, 33.37715], [-117.23745, 33.37724], [-117.23724, 33.37765], [-117.23639, 33.37765], [-117.23639, 33.37853], [-117.23556, 33.37853], [-117.23557, 33.37665], [-117.23562, 33.37661], [-117.23748, 33.37662]]]]} | Open Access 1 | 5294 | Fallbrook Park and Community Center | 18835 | 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/FallbrookCommunityCenter.html | San Diego 4 | 8.565 | Fallbrook Park and Community Ctr. | 0 | Local Recreation Area 3 | 4 |
| 15149 | 15149 | 15148 | {"type": "Polygon", "coordinates": [[[-117.22985, 33.12069], [-117.22559, 33.1207], [-117.22559, 33.12034], [-117.22632, 33.12033], [-117.2275, 33.11994], [-117.22846, 33.11978], [-117.22826, 33.11881], [-117.22822, 33.11871], [-117.2277, 33.11842], [-117.22665, 33.11804], [-117.22645, 33.11788], [-117.2261, 33.1179], [-117.22608, 33.1176], [-117.22604, 33.11748], [-117.22594, 33.11732], [-117.22574, 33.11714], [-117.22573, 33.11712], [-117.22574, 33.11708], [-117.22579, 33.11704], [-117.22666, 33.11703], [-117.22668, 33.11773], [-117.22982, 33.11772], [-117.22985, 33.12069]]]} | No Public Access 3 | 45992 | Diamond Trail | 29166 | 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.sandiegocounty.gov/content/dam/sdc/dpw/WATERSHED_PROTECTION_PROGRAM/Pacific%20Watersheds.pdf | San Diego 4 | 19.749 | Diamond Trail | 0 | Local Recreation Area 3 | 4 |
| 15159 | 15159 | 15158 | {"type": "Polygon", "coordinates": [[[-117.12105, 33.004], [-117.12098, 33.00409], [-117.12083, 33.00424], [-117.12067, 33.00451], [-117.12062, 33.00467], [-117.12064, 33.00492], [-117.12061, 33.00507], [-117.12023, 33.00568], [-117.11995, 33.00557], [-117.1199, 33.00545], [-117.11984, 33.00535], [-117.11975, 33.00525], [-117.11963, 33.00516], [-117.11942, 33.00505], [-117.1192, 33.00497], [-117.11907, 33.00495], [-117.11894, 33.00495], [-117.11842, 33.00502], [-117.11826, 33.00516], [-117.11817, 33.00485], [-117.11819, 33.00445], [-117.1182, 33.00431], [-117.11831, 33.00418], [-117.11838, 33.00401], [-117.11835, 33.00386], [-117.11829, 33.00382], [-117.11836, 33.00338], [-117.11849, 33.00338], [-117.11855, 33.00336], [-117.11859, 33.00332], [-117.11865, 33.00322], [-117.11868, 33.00319], [-117.11929, 33.00323], [-117.11993, 33.00317], [-117.1201, 33.0032], [-117.12038, 33.00331], [-117.12105, 33.00331], [-117.12111, 33.00375], [-117.1211, 33.00387], [-117.12105, 33.004]]]} | Open Access 1 | 46007 | 4S Ranch Sports Park | 29269 | 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 | 12.833 | 4S Ranch Sports Park | 0 | Local Recreation Area 3 | 4 |
| 16091 | 16091 | 16090 | {"type": "MultiPolygon", "coordinates": [[[[-117.16992, 33.02186], [-117.1699, 33.02425], [-117.16846, 33.02523], [-117.16669, 33.02662], [-117.16683, 33.0272], [-117.16703, 33.02781], [-117.16437, 33.02813], [-117.16459, 33.02897], [-117.16401, 33.0291], [-117.16387, 33.02928], [-117.16379, 33.02966], [-117.16368, 33.02995], [-117.1637, 33.03035], [-117.16377, 33.03067], [-117.16434, 33.03106], [-117.16391, 33.03115], [-117.16418, 33.03134], [-117.16414, 33.03172], [-117.16397, 33.03211], [-117.16365, 33.03248], [-117.16347, 33.03338], [-117.16162, 33.0328], [-117.16189, 33.03238], [-117.1619, 33.03235], [-117.16209, 33.03205], [-117.16212, 33.03204], [-117.16238, 33.03165], [-117.16273, 33.03006], [-117.16271, 33.02971], [-117.16244, 33.02964], [-117.16281, 33.02851], [-117.16332, 33.02842], [-117.16436, 33.02765], [-117.16556, 33.02698], [-117.16566, 33.02637], [-117.16704, 33.0256], [-117.16718, 33.02502], [-117.16649, 33.02392], [-117.16688, 33.02405], [-117.16731, 33.02392], [-117.16759, 33.02373], [-117.16774, 33.0237], [-117.16787, 33.02314], [-117.1676, 33.02184], [-117.16992, 33.02186]]], [[[-117.16141, 33.03309], [-117.16115, 33.03348], [-117.16117, 33.03593], [-117.1608, 33.03594], [-117.1608, 33.03669], [-117.16103, 33.03671], [-117.15999, 33.03744], [-117.15944, 33.038], [-117.15911, 33.03846], [-117.15948, 33.0391], [-117.15904, 33.03933], [-117.15875, 33.03954], [-117.15852, 33.03977], [-117.15842, 33.0397], [-117.15832, 33.0398], [-117.15814, 33.04005], [-117.15818, 33.0401], [-117.15764, 33.04108], [-117.15767, 33.0411], [-117.15766, 33.04112], [-117.15744, 33.0414], [-117.1573, 33.04131], [-117.15734, 33.04127], [-117.15744, 33.04112], [-117.15752, 33.04093], [-117.15752, 33.04057], [-117.15751, 33.04053], [-117.15744, 33.04043], [-117.15735, 33.04038], [-117.15729, 33.04036], [-117.15709, 33.04036], [-117.15618, 33.04146], [-117.15704, 33.04177], [-117.15692, 33.04185], [-117.1567, 33.04199], [-117.1562, 33.04221], [-117.15616, 33.04214], [-117.15591, 33.04223], [-117.15497, 33.04248], [-117.15498, 33.04254], [-117.15495, 33.04256], [-117.15469, 33.04261], [-117.15457, 33.04265], [-117.15351, 33.04294], [-117.15293, 33.04302], [-117.15229, 33.04302], [-117.15187, 33.04297], [-117.15159, 33.04292], [-117.14999, 33.04246], [-117.14972, 33.0424], [-117.14943, 33.04235], [-117.14758, 33.04217], [-117.14706, 33.04217], [-117.14644, 33.04221], [-117.146, 33.04221], [-117.14559, 33.04219], [-117.14518, 33.04213], [-117.1451, 33.04211], [-117.1451, 33.0421], [-117.14507, 33.04209], [-117.14479, 33.04202], [-117.14476, 33.04202], [-117.14475, 33.04204], [-117.1419, 33.0412], [-117.14166, 33.04114], [-117.14169, 33.0411], [-117.14167, 33.04108], [-117.14132, 33.04101], [-117.14107, 33.04097], [-117.14069, 33.04095], [-117.13986, 33.04096], [-117.13985, 33.04091], [-117.13939, 33.04092], [-117.13938, 33.04097], [-117.13837, 33.04098], [-117.13836, 33.04105], [-117.13786, 33.04106], [-117.13785, 33.04075], [-117.13706, 33.04077], [-117.13645, 33.04083], [-117.13601, 33.04091], [-117.13604, 33.04105], [-117.13541, 33.04117], [-117.13544, 33.04133], [-117.13513, 33.04129], [-117.13512, 33.04016], [-117.13947, 33.04016], [-117.13946, 33.03649], [-117.14194, 33.03648], [-117.14768, 33.0385], [-117.1475, 33.03728], [-117.14804, 33.03772], [-117.14873, 33.03794], [-117.14888, 33.03795], [-117.14903, 33.03802], [-117.1491, 33.0384], [-117.14877, 33.03886], [-117.14878, 33.03888], [-117.15488, 33.04101], [-117.15675, 33.0382], [-117.15679, 33.03791], [-117.15694, 33.03781], [-117.15707, 33.03774], [-117.15722, 33.0377], [-117.15743, 33.03767], [-117.15774, 33.0377], [-117.15827, 33.03786], [-117.15862, 33.03744], [-117.15853, 33.03689], [-117.15944, 33.03576], [-117.15953, 33.03545], [-117.15944, 33.03489], [-117.15993, 33.03387], [-117.16114, 33.03301], [-117.16119, 33.03298], [-117.16141, 33.03309]]], [[[-117.15266, 33.04386], [-117.15256, 33.04386], [-117.15239, 33.04379], [-117.15219, 33.04374], [-117.15167, 33.0437], [-117.1516, 33.04368], [-117.15145, 33.04355], [-117.15132, 33.04349], [-117.15062, 33.04356], [-117.1504, 33.04353], [-117.15035, 33.04338], [-117.15006, 33.04316], [-117.14999, 33.04314], [-117.14982, 33.04312], [-117.14953, 33.04321], [-117.14945, 33.04322], [-117.1489, 33.04315], [-117.14884, 33.04312], [-117.14868, 33.04299], [-117.14833, 33.04286], [-117.14775, 33.04272], [-117.14762, 33.04272], [-117.14755, 33.04274], [-117.14726, 33.0429], [-117.14712, 33.0429], [-117.14706, 33.04287], [-117.14682, 33.04282], [-117.14657, 33.04282], [-117.14643, 33.04285], [-117.14635, 33.0429], [-117.14629, 33.04291], [-117.14612, 33.04292], [-117.14546, 33.04279], [-117.14516, 33.04268], [-117.14474, 33.04266], [-117.14444, 33.0426], [-117.14431, 33.04256], [-117.14424, 33.04251], [-117.14413, 33.04248], [-117.14401, 33.04249], [-117.14397, 33.04251], [-117.14388, 33.04251], [-117.14381, 33.04248], [-117.14372, 33.04241], [-117.1436, 33.04236], [-117.14327, 33.04232], [-117.14298, 33.04227], [-117.14234, 33.04208], [-117.14213, 33.04196], [-117.14201, 33.04185], [-117.14193, 33.04181], [-117.14179, 33.04181], [-117.14173, 33.04184], [-117.14159, 33.04187], [-117.14143, 33.04182], [-117.14036, 33.04176], [-117.14, 33.04172], [-117.13988, 33.04177], [-117.13981, 33.04184], [-117.13969, 33.04186], [-117.13931, 33.04173], [-117.13918, 33.04171], [-117.1391, 33.04171], [-117.13901, 33.04175], [-117.13885, 33.04191], [-117.1385, 33.04184], [-117.13843, 33.0418], [-117.13836, 33.04172], [-117.13823, 33.04165], [-117.13808, 33.04166], [-117.13785, 33.04178], [-117.13768, 33.04181], [-117.13737, 33.04163], [-117.1373, 33.04161], [-117.13724, 33.04161], [-117.13713, 33.04164], [-117.13703, 33.04164], [-117.13691, 33.04161], [-117.13685, 33.04161], [-117.13679, 33.04161], [-117.13669, 33.04164], [-117.13655, 33.04173], [-117.13652, 33.0418], [-117.13647, 33.04184], [-117.1364, 33.04187], [-117.13635, 33.04187], [-117.13631, 33.04186], [-117.13623, 33.04181], [-117.13621, 33.04177], [-117.1362, 33.04166], [-117.13615, 33.04159], [-117.1361, 33.04155], [-117.13598, 33.04151], [-117.13663, 33.04139], [-117.13726, 33.04134], [-117.14065, 33.04129], [-117.14067, 33.04133], [-117.14111, 33.04137], [-117.14112, 33.04146], [-117.14154, 33.04153], [-117.14158, 33.04145], [-117.14262, 33.04174], [-117.14265, 33.04171], [-117.14456, 33.04228], [-117.1452, 33.04241], [-117.14562, 33.04246], [-117.14608, 33.04249], [-117.14638, 33.04249], [-117.14713, 33.04245], [-117.14716, 33.04258], [-117.14754, 33.04259], [-117.14756, 33.04254], [-117.14934, 33.04271], [-117.14936, 33.04262], [-117.14979, 33.04269], [-117.15141, 33.04315], [-117.15171, 33.04322], [-117.15169, 33.04334], [-117.1517, 33.04336], [-117.15215, 33.04342], [-117.15265, 33.04344], [-117.15266, 33.04386]]], [[[-117.15222, 33.04386], [-117.13513, 33.04381], [-117.13513, 33.04166], [-117.13569, 33.04157], [-117.13595, 33.04158], [-117.136, 33.0416], [-117.13606, 33.04165], [-117.13608, 33.04181], [-117.13613, 33.04188], [-117.1362, 33.04192], [-117.13627, 33.04195], [-117.1364, 33.04195], [-117.13647, 33.04193], [-117.13657, 33.04185], [-117.13662, 33.04178], [-117.13667, 33.04174], [-117.13678, 33.04169], [-117.13689, 33.04169], [-117.13704, 33.04174], [-117.13713, 33.04174], [-117.13723, 33.04171], [-117.13731, 33.04172], [-117.13765, 33.0419], [-117.13785, 33.04188], [-117.13801, 33.04182], [-117.13813, 33.04174], [-117.13819, 33.04173], [-117.13829, 33.04176], [-117.13838, 33.04187], [-117.13849, 33.04193], [-117.13889, 33.04202], [-117.13907, 33.04185], [-117.13921, 33.04181], [-117.13927, 33.04182], [-117.13969, 33.04197], [-117.13981, 33.04196], [-117.13985, 33.04194], [-117.13993, 33.04187], [-117.14002, 33.04183], [-117.14139, 33.04191], [-117.14157, 33.04197], [-117.14164, 33.04197], [-117.14179, 33.04191], [-117.14188, 33.04191], [-117.14194, 33.04193], [-117.14221, 33.04213], [-117.14237, 33.0422], [-117.14244, 33.04221], [-117.14257, 33.04226], [-117.14295, 33.04236], [-117.14332, 33.04242], [-117.14359, 33.04244], [-117.14371, 33.04249], [-117.14377, 33.04257], [-117.14386, 33.04261], [-117.14399, 33.04261], [-117.14408, 33.04258], [-117.14417, 33.04259], [-117.14432, 33.04266], [-117.14452, 33.04272], [-117.14476, 33.04275], [-117.14511, 33.04276], [-117.14524, 33.04282], [-117.14552, 33.0429], [-117.14613, 33.04302], [-117.14629, 33.04301], [-117.14643, 33.04296], [-117.14656, 33.04293], [-117.14682, 33.04293], [-117.14698, 33.04296], [-117.14715, 33.04301], [-117.14725, 33.04301], [-117.14762, 33.04284], [-117.14774, 33.04283], [-117.14831, 33.04295], [-117.14861, 33.04307], [-117.14873, 33.04317], [-117.14886, 33.04324], [-117.14945, 33.04331], [-117.14956, 33.04331], [-117.14983, 33.04322], [-117.14996, 33.04323], [-117.15001, 33.04324], [-117.15026, 33.04344], [-117.15033, 33.04363], [-117.15062, 33.04366], [-117.15128, 33.04359], [-117.15138, 33.04361], [-117.15148, 33.04374], [-117.1516, 33.0438], [-117.15204, 33.04381], [-117.15217, 33.04384], [-117.15222, 33.04386]]]]} | Open Access 1 | 10527 | Santa Fe Valley Open Space | 29298 | 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.sdrp.org/trails.htm | San Diego 4 | 329.336 | Santa Fe Valley 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]);