units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

694 rows where ACCESS_TYP = 2 and GAP_STS = 4

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, LAYER

ACCESS_TYP 1

  • Restricted Access · 694 ✖
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
3 3 2 {"type": "Polygon", "coordinates": [[[-120.81796, 37.78801], [-120.81602, 37.78793], [-120.81565, 37.78787], [-120.81358, 37.7878], [-120.81268, 37.78774], [-120.8117, 37.78776], [-120.8111, 37.78789], [-120.81064, 37.78764], [-120.80991, 37.78733], [-120.80928, 37.78757], [-120.80895, 37.78704], [-120.80743, 37.78568], [-120.80702, 37.78537], [-120.80701, 37.78515], [-120.80703, 37.78338], [-120.80993, 37.78254], [-120.81293, 37.78022], [-120.81292, 37.77802], [-120.81434, 37.77723], [-120.81693, 37.77715], [-120.81697, 37.78113], [-120.81726, 37.78253], [-120.81756, 37.78477], [-120.81686, 37.78479], [-120.81635, 37.78482], [-120.8157, 37.78465], [-120.81513, 37.78463], [-120.81405, 37.78454], [-120.81371, 37.7843], [-120.81343, 37.78428], [-120.81288, 37.78427], [-120.81092, 37.78458], [-120.81058, 37.78429], [-120.81017, 37.78433], [-120.80902, 37.785], [-120.80861, 37.78529], [-120.80875, 37.78561], [-120.80897, 37.78583], [-120.80941, 37.78606], [-120.80994, 37.78614], [-120.81072, 37.78613], [-120.81093, 37.78596], [-120.8114, 37.78609], [-120.81224, 37.78639], [-120.81288, 37.78655], [-120.8129, 37.78674], [-120.81368, 37.78684], [-120.8148, 37.78683], [-120.81525, 37.78688], [-120.81579, 37.78697], [-120.81674, 37.78697], [-120.81725, 37.78683], [-120.81777, 37.7866], [-120.81796, 37.78801]], [[-120.81641, 37.7829], [-120.81637, 37.78261], [-120.81576, 37.78291], [-120.81539, 37.78302], [-120.81522, 37.78337], [-120.81521, 37.78348], [-120.8154, 37.78386], [-120.81556, 37.78389], [-120.81566, 37.78395], [-120.81602, 37.78396], [-120.81609, 37.784], [-120.81655, 37.78409], [-120.81655, 37.78401], [-120.81644, 37.78328], [-120.81641, 37.7829]]]} Restricted Access 2 9 Oakdale Golf & Country Club 32983 1227 Oakdale, City of 2 City 2 City Agency 2 http://www.oakdalegov.com/#!recreation/c222d City 2 1227 Oakdale, City of 2 City 2 City Agency 2   Stanislaus 2 137.317 Oakdale Golf & Country Club 0 Local Recreation Area 3 4
177 177 176 {"type": "Polygon", "coordinates": [[[-119.74164, 34.43295], [-119.74153, 34.43576], [-119.73893, 34.43575], [-119.73887, 34.43693], [-119.73869, 34.43693], [-119.73853, 34.43695], [-119.73837, 34.437], [-119.73822, 34.43708], [-119.73804, 34.43724], [-119.73783, 34.43753], [-119.73766, 34.43766], [-119.73751, 34.43772], [-119.73402, 34.43838], [-119.73394, 34.43798], [-119.73391, 34.43769], [-119.73392, 34.43573], [-119.73369, 34.43572], [-119.73366, 34.43384], [-119.73517, 34.43387], [-119.73518, 34.43141], [-119.73888, 34.43138], [-119.73888, 34.42908], [-119.73969, 34.42935], [-119.74016, 34.42954], [-119.74079, 34.42982], [-119.7407, 34.4325], [-119.74164, 34.43295]]]} Restricted Access 2 492 Santa Barbara Golf Club 32988 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 110.039 Santa Barbara Golf Club 0 Local Recreation Area 3 4
347 347 346 {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} Restricted Access 2 953 George Manooshian Park 29754 2312 Glendora Unified School District 141 Special District 4 School District 14 http://www.glendora.k12.ca.us/ Special District 4 1120 Glendora, City of 74 City 2 City Agency 2   Los Angeles 6 18.865 George Manooshian Park 0 Local Park 2 4
672 672 671 {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} Restricted Access 2 5104 711 St. Mary's Road Park 15210 1163 Lafayette, City of 236 City 2 City Agency 2 http://www.ci.lafayette.ca.us/index.aspx?page=87 City 2 1163 Lafayette, City of 232 City 2 City Agency 2   Contra Costa 12 11.502 711 St. Mary's Road Park 1983 Local Park 2 4
705 705 704 {"type": "Polygon", "coordinates": [[[-117.79528, 33.68552], [-117.79478, 33.68601], [-117.79345, 33.68511], [-117.79387, 33.68468], [-117.79439, 33.68492], [-117.79528, 33.68552]]]} Restricted Access 2 3955 Lemongrass Park 21155 6034 Woodbridge Village Association 244 Private 7 Home Owners Association 16 http://www.wva.org/ Private 14 6034 Woodbridge Village Association 240 Private 7 Home Owners Association 15   Orange 3 2.759 Lemongrass Park 0 Private Recreation or Education 65 4
779 779 778 {"type": "Polygon", "coordinates": [[[-117.80378, 33.68325], [-117.80318, 33.68385], [-117.8024, 33.68332], [-117.80299, 33.68272], [-117.80378, 33.68325]]]} Restricted Access 2 5060 Birdsong Park 16124 6034 Woodbridge Village Association 244 Private 7 Home Owners Association 16 http://www.wva.org/ Private 14 6034 Woodbridge Village Association 240 Private 7 Home Owners Association 15   Orange 3 1.997 Birdsong Park 0 Private Recreation or Education 65 4
781 781 780 {"type": "Polygon", "coordinates": [[[-121.83892, 37.69284], [-121.83892, 37.69497], [-121.83838, 37.69541], [-121.83777, 37.69567], [-121.83724, 37.69614], [-121.83653, 37.69638], [-121.83615, 37.6966], [-121.8359, 37.6971], [-121.83545, 37.69735], [-121.83435, 37.69759], [-121.83308, 37.69793], [-121.83316, 37.69844], [-121.83289, 37.69879], [-121.83205, 37.69921], [-121.83202, 37.6983], [-121.82998, 37.69835], [-121.82998, 37.70055], [-121.82094, 37.70062], [-121.81888, 37.69912], [-121.81883, 37.69713], [-121.82405, 37.69676], [-121.8243, 37.69635], [-121.82403, 37.6952], [-121.82983, 37.6953], [-121.83021, 37.69279], [-121.83892, 37.69284]]]} Restricted Access 2 5062 Las Positas Golf Course 33002 1178 Livermore, City of 256 City 2 City Agency 2 http://www.larpd.org/parks/parks.html City 2 1178 Livermore, City of 252 City 2 City Agency 2   Alameda 17 216.12 Las Positas GC 0 Local Recreation Area 3 4
801 801 800 {"type": "Polygon", "coordinates": [[[-117.96358, 33.88243], [-117.96358, 33.8825], [-117.96344, 33.88286], [-117.96216, 33.88253], [-117.96201, 33.8825], [-117.96195, 33.88252], [-117.96179, 33.88286], [-117.96169, 33.88291], [-117.96154, 33.8829], [-117.96146, 33.88298], [-117.9612, 33.8838], [-117.96112, 33.88384], [-117.9608, 33.88378], [-117.96076, 33.88375], [-117.96074, 33.8837], [-117.96106, 33.88283], [-117.96104, 33.8828], [-117.96086, 33.88272], [-117.96083, 33.88261], [-117.96097, 33.88214], [-117.96093, 33.88209], [-117.96088, 33.88205], [-117.95971, 33.88173], [-117.95964, 33.88171], [-117.95962, 33.88168], [-117.95968, 33.88149], [-117.95974, 33.88142], [-117.95979, 33.8814], [-117.96346, 33.88234], [-117.96354, 33.88238], [-117.96358, 33.88243]]]} Restricted Access 2 5203 McDermont Park 22019 6062 Amerige Heights Community Association 263 Private 7 Home Owners Association 16 http://www.amerigeheights.org/ Private 14 6062 Amerige Heights Community Association 259 Private 7 Home Owners Association 15   Orange 3 7.049 McDermont Park 0 Private Recreation or Education 65 4
824 824 823 {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.18411], [-118.29645, 34.18412], [-118.29561, 34.18351], [-118.2956, 34.18348], [-118.296, 34.18308], [-118.29685, 34.1837], [-118.29688, 34.18375]]]} Restricted Access 2 5370 Miller Park 29568 1038 Burbank, City of 138 City 2 City Agency 2 http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities City 2 1038 Burbank, City of 135 City 2 City Agency 2 http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/miller-park Los Angeles 6 1.599 Miller Park 0 Local Park 2 4
840 840 839 {"type": "Polygon", "coordinates": [[[-117.95755, 33.88747], [-117.95754, 33.88755], [-117.95748, 33.88761], [-117.95743, 33.88762], [-117.9565, 33.88761], [-117.95641, 33.88756], [-117.95633, 33.88746], [-117.95631, 33.88741], [-117.95629, 33.88728], [-117.9563, 33.88721], [-117.95632, 33.88719], [-117.9564, 33.88717], [-117.95751, 33.88743], [-117.95755, 33.88747]]]} Restricted Access 2 4941 Mackey Neighborhood Park 21637 6062 Amerige Heights Community Association 263 Private 7 Home Owners Association 16 http://www.amerigeheights.org/ Private 14 6062 Amerige Heights Community Association 259 Private 7 Home Owners Association 15   Orange 3 0.97 Mackey Neighborhood Park 0 Private Recreation or Education 65 4
947 947 946 {"type": "MultiPolygon", "coordinates": [[[[-118.30927, 33.77858], [-118.30758, 33.77901], [-118.3066, 33.7792], [-118.30555, 33.77935], [-118.30359, 33.77951], [-118.30379, 33.77922], [-118.30356, 33.7791], [-118.30373, 33.77882], [-118.30371, 33.77863], [-118.30258, 33.77836], [-118.30228, 33.77858], [-118.30213, 33.77866], [-118.30196, 33.77871], [-118.30179, 33.77874], [-118.30145, 33.77873], [-118.30114, 33.77863], [-118.30124, 33.77834], [-118.3011, 33.7783], [-118.30143, 33.77756], [-118.3013, 33.77738], [-118.30092, 33.7772], [-118.30093, 33.77658], [-118.30075, 33.77653], [-118.30073, 33.77656], [-118.3002, 33.77642], [-118.30015, 33.77669], [-118.30004, 33.7768], [-118.29989, 33.77685], [-118.29945, 33.77691], [-118.29942, 33.77696], [-118.29941, 33.77494], [-118.296, 33.77494], [-118.2959, 33.77466], [-118.29444, 33.77083], [-118.29424, 33.77018], [-118.29413, 33.76975], [-118.29404, 33.76934], [-118.29402, 33.76908], [-118.29401, 33.76865], [-118.29405, 33.76753], [-118.29404, 33.76724], [-118.294, 33.76667], [-118.29394, 33.76629], [-118.29718, 33.76629], [-118.29719, 33.76641], [-118.29801, 33.76687], [-118.29825, 33.76705], [-118.29891, 33.76743], [-118.29912, 33.76759], [-118.29932, 33.7677], [-118.30005, 33.76787], [-118.30059, 33.76797], [-118.30179, 33.76827], [-118.30185, 33.76825], [-118.30188, 33.76819], [-118.30407, 33.76881], [-118.30522, 33.76959], [-118.30699, 33.77065], [-118.30701, 33.77105], [-118.30741, 33.77167], [-118.30772, 33.77175], [-118.30895, 33.77159], [-118.30875, 33.77225], [-118.30863, 33.77282], [-118.30859, 33.77321], [-118.3086, 33.77377], [-118.30863, 33.77407], [-118.30927, 33.77858]]], [[[-118.30012, 33.77981], [-118.29971, 33.77989], [-118.29931, 33.78001], [-118.29894, 33.78016], [-118.29858, 33.78034], [-118.29825, 33.78056], [-118.29796, 33.78081], [-118.29759, 33.78122], [-118.2974, 33.78122], [-118.29726, 33.78129], [-118.29689, 33.78086], [-118.29719, 33.7805], [-118.29739, 33.7803], [-118.2976, 33.78013], [-118.2979, 33.77991], [-118.29838, 33.77962], [-118.29904, 33.77935], [-118.29933, 33.77926], [-118.29938, 33.77939], [-118.29967, 33.77967], [-118.29978, 33.77974], [-118.3001, 33.77979], [-118.30012, 33.77981]]]]} Restricted Access 2 5975 Defense Fuel Supply Point (DFSP) - Hab. Restoration 18013 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Los Angeles 6 326.646 Defense Fuel Supply Point (DFSP) - Hab. Restoration 0 Federal Other or Unknown 87 4
968 968 967 {"type": "Polygon", "coordinates": [[[-118.10763, 33.83029], [-118.10763, 33.83204], [-118.10759, 33.8321], [-118.09924, 33.83206], [-118.09919, 33.83205], [-118.09916, 33.83201], [-118.09956, 33.8307], [-118.09974, 33.83027], [-118.10362, 33.83028], [-118.10363, 33.83055], [-118.10507, 33.83056], [-118.10508, 33.83028], [-118.10763, 33.83029]]]} Restricted Access 2 6607 Heartwell Golf Course 33019 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 36.514 Heartwell GC 0 Local Recreation Area 3 4
1030 1030 1029 {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} Restricted Access 2 5646 Friendship Park 19120 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 3.848 Friendship Park 0 Local Park 2 4
1070 1070 1069 {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.12109, 34.18492], [-118.12098, 34.18506], [-118.12057, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18574], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18334], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11782, 34.18092], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18009], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.18319], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12162, 34.18407], [-118.12169, 34.18412]]]} Restricted Access 2 6971 Altadena Golf Course 33022 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 57.739 Altadena GC 0 Local Recreation Area 3 4
1118 1118 1117 {"type": "Polygon", "coordinates": [[[-117.15742, 32.70928], [-117.15639, 32.70929], [-117.15639, 32.70847], [-117.15742, 32.70847], [-117.15742, 32.70928]]]} Restricted Access 2 47585 The Park at Petco Park 31312 6117 Petco Park Owner 322 Private 7 Commercial 20 http://www.petcoparkinsider.com/park-at-the-park Private 14 6117 Petco Park Owner 319 Private 7 Commercial 18 http://www.petcoparkinsider.com/park-at-the-park San Diego 4 2.17 The Park at Petco Park 0 Private Recreation or Education 65 4
1140 1140 1139 {"type": "Polygon", "coordinates": [[[-118.1547, 33.95388], [-118.15452, 33.95422], [-118.15424, 33.9546], [-118.15397, 33.95488], [-118.15371, 33.95511], [-118.15347, 33.95528], [-118.14778, 33.95833], [-118.14294, 33.95579], [-118.14293, 33.95577], [-118.14293, 33.95574], [-118.14549, 33.95228], [-118.14787, 33.95356], [-118.14876, 33.95237], [-118.15149, 33.95385], [-118.15239, 33.95264], [-118.1547, 33.95388]]]} Restricted Access 2 6710 Rio Hondo Golf Club 33020 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 101.146 Rio Hondo Golf Club 0 Local Recreation Area 3 4
1149 1149 1148 {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} Restricted Access 2 6734 Hillcrest And Ocean View Lots 19962 321 San Francisco - Public Utilities Commission, City and County of 31 County 3 County Agency - Other 9 http://sfwater.org/ County 3 321 San Francisco - Public Utilities Commission, City and County of 30 County 3 County Agency - Other 8   San Mateo 15 0.08 Hillcrest And Ocean View Lots 0 Local Other or Unknown 14 4
1392 1392 1391 {"type": "MultiPolygon", "coordinates": [[[[-117.69075, 33.62392], [-117.68979, 33.62464], [-117.6881, 33.62602], [-117.68796, 33.62602], [-117.68764, 33.62571], [-117.68732, 33.6253], [-117.68703, 33.62485], [-117.68795, 33.62401], [-117.68946, 33.62275], [-117.69075, 33.62392]]], [[[-117.69308, 33.61785], [-117.69279, 33.61798], [-117.69244, 33.61822], [-117.69209, 33.61852], [-117.69108, 33.62006], [-117.69044, 33.6209], [-117.69044, 33.62091], [-117.69115, 33.62121], [-117.69006, 33.62215], [-117.68996, 33.62243], [-117.68983, 33.62274], [-117.68763, 33.62065], [-117.68806, 33.62016], [-117.68832, 33.61992], [-117.68852, 33.6197], [-117.68907, 33.61929], [-117.68969, 33.61891], [-117.69138, 33.61803], [-117.69201, 33.61773], [-117.69254, 33.61741], [-117.69268, 33.61741], [-117.69308, 33.61785]]]]} Restricted Access 2 30526 Lake Forest Golf Course 33099 1167 Lake Forest, City of 235 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 1167 Lake Forest, City of 231 City 2 City Agency 2   Orange 3 40.437 Lake Forest GC 0 Local Recreation Area 3 4
1455 1455 1454 {"type": "Polygon", "coordinates": [[[-117.96503, 33.88478], [-117.96434, 33.88483], [-117.96427, 33.88423], [-117.96499, 33.88417], [-117.96503, 33.88478]]]} Restricted Access 2 9773 Reiswig Park 24286 6062 Amerige Heights Community Association 263 Private 7 Home Owners Association 16 http://www.amerigeheights.org/ Private 14 6062 Amerige Heights Community Association 259 Private 7 Home Owners Association 15   Orange 3 1.084 Reiswig Park 0 Private Recreation or Education 65 4
1490 1490 1489 {"type": "Polygon", "coordinates": [[[-117.68588, 34.45141], [-117.68154, 34.45142], [-117.68152, 34.44779], [-117.68587, 34.4478], [-117.68588, 34.45141]]]} Restricted Access 2 12700 Antelope Valley Open Space 29491 3000 Arroyos and Foothills Conservancy 375 Non Profit 6 Non Profit - Land Trust 10 http://www.arroyosfoothills.org/ Non Governmental Organization 10 3000 Arroyos and Foothills Conservancy 370 Non Profit 6 Non Profit - Land Trust 10   Los Angeles 6 39.642 Antelope Valley OS 0 Private Recreation or Education 65 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);