units_with_maps

Table actions

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

28 rows where COUNTY = 3, GAP_STS = 4 and MNG_AGENCY = 525

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Laguna Niguel, City of · 28 ✖

ACCESS_TYP 1

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
2522 2522 2521 {"type": "Polygon", "coordinates": [[[-117.69792, 33.53391], [-117.69747, 33.53431], [-117.69717, 33.53392], [-117.69739, 33.53378], [-117.69759, 33.53363], [-117.69792, 33.53391]]]} Open Access 1 20182 Vista Plaza Park 27187 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 0.636 Vista Plaza Park 0 Local Park 2 4
2523 2523 2522 {"type": "Polygon", "coordinates": [[[-117.6929, 33.51668], [-117.69252, 33.51811], [-117.69237, 33.51808], [-117.6922, 33.51809], [-117.69211, 33.51813], [-117.69193, 33.51829], [-117.6918, 33.51827], [-117.69181, 33.51798], [-117.69189, 33.51778], [-117.69217, 33.51732], [-117.69233, 33.51679], [-117.69255, 33.51678], [-117.69276, 33.51665], [-117.6929, 33.51668]]]} Open Access 1 20188 Parc Vista Park 23414 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 2.295 Parc Vista Park 0 Local Park 2 4
2524 2524 2523 {"type": "Polygon", "coordinates": [[[-117.68994, 33.54961], [-117.68986, 33.55006], [-117.68958, 33.5508], [-117.6898, 33.55126], [-117.68954, 33.55167], [-117.68856, 33.55148], [-117.68877, 33.55114], [-117.68876, 33.5511], [-117.68872, 33.55109], [-117.68882, 33.55087], [-117.68925, 33.54971], [-117.68994, 33.54961]]]} Open Access 1 20189 Rancho Niguel Park 24159 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 4.051 Rancho Niguel Park 0 Local Park 2 4
2703 2703 2702 {"type": "Polygon", "coordinates": [[[-117.71189, 33.52976], [-117.71141, 33.53052], [-117.71123, 33.53133], [-117.71118, 33.53213], [-117.71108, 33.53287], [-117.71045, 33.53324], [-117.71019, 33.53335], [-117.71002, 33.53355], [-117.70961, 33.53416], [-117.7094, 33.53408], [-117.70903, 33.53401], [-117.70864, 33.53413], [-117.70792, 33.53388], [-117.70804, 33.53366], [-117.70816, 33.53205], [-117.70601, 33.53084], [-117.7074, 33.53018], [-117.70779, 33.52996], [-117.70829, 33.52961], [-117.70843, 33.52962], [-117.70855, 33.52951], [-117.70855, 33.5294], [-117.70878, 33.52919], [-117.70902, 33.52894], [-117.70934, 33.52857], [-117.70962, 33.52817], [-117.70981, 33.52793], [-117.71023, 33.52749], [-117.71058, 33.52781], [-117.71056, 33.5279], [-117.71077, 33.52798], [-117.71076, 33.52832], [-117.71089, 33.52864], [-117.71147, 33.52941], [-117.71189, 33.52976]]]} Open Access 1 18295 Crown Valley Community Park 17837 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 47.993 Crown Valley Community Park 0 Local Park 2 4
2949 2949 2948 {"type": "Polygon", "coordinates": [[[-117.69952, 33.51972], [-117.69898, 33.51979], [-117.69751, 33.51992], [-117.69714, 33.51998], [-117.69657, 33.52011], [-117.6962, 33.52023], [-117.69559, 33.52049], [-117.69551, 33.52036], [-117.69556, 33.52029], [-117.69556, 33.52024], [-117.69544, 33.52006], [-117.69545, 33.52003], [-117.69549, 33.51999], [-117.69568, 33.51994], [-117.69617, 33.51967], [-117.69664, 33.5195], [-117.69675, 33.51943], [-117.69686, 33.51932], [-117.69694, 33.51919], [-117.69697, 33.5191], [-117.69697, 33.51895], [-117.69694, 33.51888], [-117.69661, 33.51848], [-117.69659, 33.51841], [-117.69679, 33.51852], [-117.69694, 33.51866], [-117.69719, 33.51883], [-117.69733, 33.51887], [-117.6976, 33.5189], [-117.69801, 33.5189], [-117.69851, 33.51885], [-117.6988, 33.51879], [-117.69903, 33.51953], [-117.69944, 33.51946], [-117.69952, 33.51972]]]} Open Access 1 20170 Marina Hills Park 21824 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 7.839 Marina Hills Park 0 Local Park 2 4
2950 2950 2949 {"type": "Polygon", "coordinates": [[[-117.72286, 33.52845], [-117.72271, 33.52961], [-117.72241, 33.52957], [-117.7223, 33.52993], [-117.72149, 33.52988], [-117.72153, 33.52977], [-117.72163, 33.52964], [-117.72167, 33.52952], [-117.7214, 33.52945], [-117.7214, 33.52938], [-117.72137, 33.52933], [-117.7213, 33.52929], [-117.7212, 33.52929], [-117.72115, 33.52931], [-117.72113, 33.52928], [-117.72078, 33.5292], [-117.72085, 33.52908], [-117.72084, 33.52906], [-117.7204, 33.52896], [-117.72046, 33.52884], [-117.72093, 33.52896], [-117.72097, 33.52882], [-117.7213, 33.52891], [-117.72139, 33.52887], [-117.72145, 33.5289], [-117.72155, 33.5289], [-117.72157, 33.52894], [-117.72207, 33.52906], [-117.72268, 33.52845], [-117.72286, 33.52845]]]} Open Access 1 20171 Niguel Woods Park 22759 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 3.945 Niguel Woods Park 0 Local Park 2 4
2952 2952 2951 {"type": "Polygon", "coordinates": [[[-117.69102, 33.49297], [-117.69085, 33.49333], [-117.69063, 33.49394], [-117.69056, 33.49433], [-117.69055, 33.4946], [-117.6901, 33.49425], [-117.68948, 33.49438], [-117.68901, 33.49422], [-117.689, 33.49419], [-117.68917, 33.49353], [-117.6893, 33.49333], [-117.68946, 33.49313], [-117.68993, 33.49261], [-117.69008, 33.49234], [-117.69025, 33.49176], [-117.69041, 33.49112], [-117.69069, 33.49198], [-117.69042, 33.49278], [-117.69102, 33.49297]]]} Open Access 1 20175 Long View Park 21452 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 7.549 Long View Park 0 Local Park 2 4
5747 5747 5746 {"type": "Polygon", "coordinates": [[[-117.70573, 33.5229], [-117.70504, 33.52389], [-117.70447, 33.52439], [-117.70436, 33.52453], [-117.70418, 33.52497], [-117.70372, 33.52499], [-117.70348, 33.52526], [-117.70347, 33.52559], [-117.70381, 33.52556], [-117.70382, 33.52563], [-117.70387, 33.52571], [-117.7036, 33.52585], [-117.70356, 33.52606], [-117.70309, 33.52671], [-117.70252, 33.52721], [-117.70227, 33.52726], [-117.70272, 33.52761], [-117.70238, 33.52788], [-117.70202, 33.52811], [-117.70178, 33.52824], [-117.70135, 33.52843], [-117.70118, 33.52815], [-117.70072, 33.52771], [-117.7012, 33.52779], [-117.70152, 33.52738], [-117.70126, 33.52707], [-117.70141, 33.52687], [-117.7016, 33.52674], [-117.70184, 33.52581], [-117.70219, 33.52526], [-117.70245, 33.52503], [-117.70301, 33.52483], [-117.70335, 33.52464], [-117.70343, 33.52442], [-117.70364, 33.52428], [-117.70383, 33.52413], [-117.70441, 33.52348], [-117.70478, 33.52316], [-117.70478, 33.52292], [-117.70484, 33.52274], [-117.70503, 33.52266], [-117.70559, 33.52279], [-117.70573, 33.5229]]]} Open Access 1 3109 La Hermosa Park 20758 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 17.479 La Hermosa Park 0 Local Park 2 4
7853 7853 7852 {"type": "Polygon", "coordinates": [[[-117.72286, 33.54177], [-117.72285, 33.5418], [-117.72226, 33.54275], [-117.7222, 33.54244], [-117.72198, 33.54222], [-117.72209, 33.54181], [-117.72228, 33.54141], [-117.72241, 33.54143], [-117.72252, 33.54143], [-117.72254, 33.54171], [-117.72286, 33.54177]]]} Open Access 1 9946 Ridge View Park 24350 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 1.452 Ridge View Park 0 Local Park 2 4
10775 10775 10774 {"type": "Polygon", "coordinates": [[[-117.70365, 33.50278], [-117.70341, 33.50296], [-117.70323, 33.50314], [-117.70312, 33.50331], [-117.70303, 33.50349], [-117.70297, 33.50365], [-117.70256, 33.50364], [-117.7023, 33.50368], [-117.70194, 33.50384], [-117.70151, 33.50284], [-117.70343, 33.50226], [-117.70365, 33.50278]]]} Open Access 1 20161 Beacon Hill Park 15913 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 4.849 Beacon Hill Park 0 Local Park 2 4
10776 10776 10775 {"type": "Polygon", "coordinates": [[[-117.70717, 33.49442], [-117.70707, 33.49487], [-117.70647, 33.49487], [-117.70646, 33.49427], [-117.70655, 33.49382], [-117.70657, 33.49379], [-117.70665, 33.49377], [-117.70699, 33.49381], [-117.70717, 33.49442]]]} Open Access 1 20162 Ocean Breeze Park 23053 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 1.692 Ocean Breeze Park 0 Local Park 2 4
10778 10778 10777 {"type": "Polygon", "coordinates": [[[-117.70508, 33.49228], [-117.70504, 33.49455], [-117.70459, 33.49584], [-117.70431, 33.49578], [-117.70421, 33.496], [-117.70406, 33.49603], [-117.70385, 33.49648], [-117.70224, 33.4962], [-117.70282, 33.4955], [-117.70293, 33.49551], [-117.70295, 33.4956], [-117.70289, 33.49567], [-117.70288, 33.49595], [-117.70293, 33.49602], [-117.70305, 33.49606], [-117.70316, 33.49603], [-117.70321, 33.49596], [-117.7032, 33.49564], [-117.70307, 33.49552], [-117.70307, 33.49543], [-117.70377, 33.49474], [-117.70373, 33.49462], [-117.70379, 33.49459], [-117.70369, 33.49426], [-117.70357, 33.49421], [-117.70374, 33.49397], [-117.70384, 33.49371], [-117.70393, 33.49343], [-117.70394, 33.49312], [-117.70384, 33.4926], [-117.70368, 33.49237], [-117.70366, 33.49231], [-117.70508, 33.49228]]]} Open Access 1 20163 Bear Brand Park 15920 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 14.083 Bear Brand Park 0 Local Park 2 4
10781 10781 10780 {"type": "Polygon", "coordinates": [[[-117.69444, 33.51134], [-117.69435, 33.51218], [-117.69411, 33.51232], [-117.69402, 33.5123], [-117.69371, 33.51243], [-117.69365, 33.51239], [-117.69305, 33.51245], [-117.69299, 33.51234], [-117.69289, 33.51231], [-117.69277, 33.51234], [-117.69245, 33.51252], [-117.6921, 33.51279], [-117.69196, 33.51288], [-117.69178, 33.51295], [-117.69167, 33.51296], [-117.69167, 33.51302], [-117.6916, 33.51305], [-117.6916, 33.5132], [-117.69122, 33.51319], [-117.69086, 33.51321], [-117.69069, 33.51326], [-117.69071, 33.51333], [-117.69101, 33.51327], [-117.69124, 33.51327], [-117.69124, 33.51341], [-117.69129, 33.51342], [-117.69131, 33.5135], [-117.69188, 33.5135], [-117.69189, 33.51348], [-117.69187, 33.5133], [-117.69192, 33.51327], [-117.692, 33.51326], [-117.69229, 33.51311], [-117.69228, 33.51316], [-117.69209, 33.5135], [-117.6918, 33.51384], [-117.69151, 33.5143], [-117.69125, 33.51423], [-117.69099, 33.5142], [-117.69043, 33.51394], [-117.69031, 33.51384], [-117.69026, 33.51376], [-117.69015, 33.51369], [-117.69015, 33.51362], [-117.69012, 33.51355], [-117.69006, 33.51351], [-117.69001, 33.51351], [-117.68994, 33.51352], [-117.68988, 33.51356], [-117.6897, 33.51332], [-117.68983, 33.51326], [-117.69005, 33.51324], [-117.69038, 33.51316], [-117.69043, 33.51324], [-117.6908, 33.51315], [-117.69103, 33.51284], [-117.69116, 33.5127], [-117.69149, 33.51249], [-117.69139, 33.51236], [-117.69259, 33.51149], [-117.69265, 33.51138], [-117.69275, 33.51128], [-117.69307, 33.51111], [-117.69285, 33.51077], [-117.69311, 33.51066], [-117.69333, 33.51061], [-117.69358, 33.51061], [-117.69381, 33.51065], [-117.69444, 33.51134]]]} Open Access 1 20165 Chapparosa Park 17136 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 13.982 Chapparosa Park 0 Local Park 2 4
10782 10782 10781 {"type": "Polygon", "coordinates": [[[-117.71921, 33.53755], [-117.71913, 33.53757], [-117.71898, 33.53748], [-117.71843, 33.53736], [-117.71805, 33.53742], [-117.71787, 33.53751], [-117.71782, 33.53751], [-117.71759, 33.53765], [-117.71707, 33.53762], [-117.7171, 33.53747], [-117.71708, 33.53721], [-117.71702, 33.53708], [-117.71684, 33.53681], [-117.71714, 33.53673], [-117.71745, 33.53673], [-117.71795, 33.53639], [-117.71798, 33.53615], [-117.71812, 33.53629], [-117.71854, 33.53612], [-117.71862, 33.53611], [-117.71872, 33.53621], [-117.71876, 33.53627], [-117.7188, 33.53639], [-117.71879, 33.53653], [-117.71869, 33.53678], [-117.71864, 33.53699], [-117.71865, 33.5371], [-117.7187, 33.53719], [-117.71918, 33.53749], [-117.71921, 33.53755]]]} Open Access 1 20166 Clipper Cove Park 17429 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 4.81 Clipper Cove Park 0 Local Park 2 4
10783 10783 10782 {"type": "Polygon", "coordinates": [[[-117.68619, 33.53075], [-117.68552, 33.53061], [-117.68525, 33.53062], [-117.68525, 33.52977], [-117.68527, 33.52974], [-117.68535, 33.52968], [-117.68575, 33.52965], [-117.68597, 33.52961], [-117.68619, 33.53075]]]} Open Access 1 20167 Hidden Hills Park 19908 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 2.113 Hidden Hills Park 0 Local Park 2 4
10784 10784 10783 {"type": "Polygon", "coordinates": [[[-117.69278, 33.52729], [-117.69204, 33.52765], [-117.69112, 33.5266], [-117.69197, 33.5261], [-117.69278, 33.52729]]]} Open Access 1 20168 Juaneno Park 20514 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 3.206 Juaneno Park 0 Local Park 2 4
10785 10785 10784 {"type": "Polygon", "coordinates": [[[-117.69405, 33.53263], [-117.69398, 33.53271], [-117.69366, 33.53254], [-117.69327, 33.53306], [-117.69313, 33.53326], [-117.6931, 33.53375], [-117.69345, 33.53376], [-117.69345, 33.53388], [-117.69181, 33.53381], [-117.69189, 33.53293], [-117.69211, 33.53299], [-117.69233, 33.53301], [-117.69262, 33.53276], [-117.69262, 33.53258], [-117.69233, 33.53258], [-117.69231, 33.53253], [-117.69271, 33.53232], [-117.69278, 33.53217], [-117.69373, 33.53244], [-117.69405, 33.53263]]]} Open Access 1 20169 La Plata Park 20789 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 4.865 La Plata Park 0 Local Park 2 4
10786 10786 10785 {"type": "Polygon", "coordinates": [[[-117.70562, 33.55782], [-117.70561, 33.55804], [-117.70547, 33.55864], [-117.70498, 33.55855], [-117.70458, 33.5585], [-117.70436, 33.55849], [-117.70404, 33.5585], [-117.70382, 33.55787], [-117.70562, 33.55782]]]} Open Access 1 20176 Niguel Heights Park 22757 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 2.884 Niguel Heights Park 0 Local Park 2 4
10787 10787 10786 {"type": "Polygon", "coordinates": [[[-117.70771, 33.51326], [-117.70742, 33.51316], [-117.70715, 33.51313], [-117.70713, 33.51305], [-117.70739, 33.51302], [-117.70749, 33.51294], [-117.70753, 33.51289], [-117.70756, 33.51283], [-117.70757, 33.51271], [-117.70754, 33.51262], [-117.70752, 33.51263], [-117.70752, 33.51276], [-117.70745, 33.51289], [-117.70742, 33.51291], [-117.70736, 33.51293], [-117.70721, 33.51293], [-117.70711, 33.51291], [-117.70703, 33.51287], [-117.70698, 33.51234], [-117.70711, 33.51181], [-117.70718, 33.51184], [-117.7072, 33.512], [-117.70728, 33.51214], [-117.70741, 33.51227], [-117.70759, 33.5124], [-117.70767, 33.51249], [-117.70773, 33.51257], [-117.70778, 33.51279], [-117.70776, 33.51304], [-117.70771, 33.51326]]]} Open Access 1 20177 Niguel Road Park 22758 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 1.623 Niguel Road Park 0 Local Park 2 4
10788 10788 10787 {"type": "Polygon", "coordinates": [[[-117.71099, 33.51618], [-117.71096, 33.51645], [-117.71082, 33.51641], [-117.71047, 33.51629], [-117.71026, 33.51628], [-117.71007, 33.5163], [-117.7103, 33.51613], [-117.71044, 33.51598], [-117.71054, 33.51582], [-117.71058, 33.51572], [-117.71059, 33.51562], [-117.71054, 33.51545], [-117.71043, 33.51531], [-117.71027, 33.51519], [-117.71002, 33.51512], [-117.71007, 33.51494], [-117.7104, 33.51506], [-117.71075, 33.51513], [-117.7109, 33.51515], [-117.71133, 33.51515], [-117.71138, 33.51517], [-117.71139, 33.51522], [-117.71139, 33.51535], [-117.71131, 33.51555], [-117.71111, 33.51584], [-117.7109, 33.51599], [-117.71089, 33.51612], [-117.71092, 33.51616], [-117.71099, 33.51618]]]} Open Access 1 20178 Seminole Park 25296 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 2.43 Seminole Park 0 Local Park 2 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]);