units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where MNG_AGENCY = 525 sorted by rowid descending
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 26
- Local Recreation Area 2
- None 1
MNG_AG_TYP 1
- City Agency 29
MNG_AGENCY 1
- Laguna Niguel, City of · 29 ✖
ACCESS_TYP 1
- Open Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12812 | 12812 | 12811 | {"type": "Polygon", "coordinates": [[[-117.71964, 33.54565], [-117.71962, 33.54575], [-117.71966, 33.54592], [-117.71968, 33.54626], [-117.71963, 33.54635], [-117.71948, 33.54645], [-117.71938, 33.54643], [-117.71945, 33.5462], [-117.71944, 33.54597], [-117.71935, 33.54574], [-117.71904, 33.54583], [-117.71901, 33.54577], [-117.71901, 33.54572], [-117.71922, 33.54555], [-117.71964, 33.54565]]]} | Open Access 1 | 30256 | Lily Shapell Park | 21239 | 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.655 | Lily Shapell Park | 0 | Local Park 2 | 4 | |
12811 | 12811 | 12810 | {"type": "Polygon", "coordinates": [[[-117.71767, 33.55831], [-117.71774, 33.5585], [-117.71778, 33.55893], [-117.71777, 33.55911], [-117.71774, 33.55933], [-117.71768, 33.55954], [-117.71758, 33.55979], [-117.71747, 33.55997], [-117.71727, 33.56023], [-117.71711, 33.5604], [-117.71646, 33.56091], [-117.71683, 33.56008], [-117.71697, 33.55963], [-117.71704, 33.55916], [-117.71708, 33.55872], [-117.71711, 33.55778], [-117.71716, 33.55745], [-117.71727, 33.55751], [-117.71749, 33.55782], [-117.71767, 33.55831]]]} | Open Access 1 | 30255 | Laguna Niguel Skate & Soccer Park | 20863 | 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.534 | Laguna Niguel Skate & Soccer Park | 0 | Local Recreation Area 3 | 4 | |
10796 | 10796 | 10795 | {"type": "Polygon", "coordinates": [[[-117.70087, 33.51272], [-117.70066, 33.51278], [-117.70037, 33.51291], [-117.70039, 33.51303], [-117.70024, 33.51305], [-117.70005, 33.5126], [-117.70006, 33.51241], [-117.70036, 33.51238], [-117.7008, 33.51245], [-117.70087, 33.51272]]]} | Open Access 1 | 20187 | Parc Vista View Park | 23415 | 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.894 | Parc Vista View Park | 0 | Local Park 2 | 4 | |
10795 | 10795 | 10794 | {"type": "Polygon", "coordinates": [[[-117.69676, 33.51276], [-117.69672, 33.51276], [-117.69655, 33.51282], [-117.6963, 33.51294], [-117.69525, 33.51353], [-117.69519, 33.51348], [-117.69554, 33.51322], [-117.69554, 33.51316], [-117.69532, 33.51314], [-117.69535, 33.5131], [-117.69554, 33.51277], [-117.69562, 33.51269], [-117.69573, 33.51263], [-117.69638, 33.51263], [-117.69652, 33.51265], [-117.69676, 33.51276]]]} | Open Access 1 | 20186 | Parc Vista Overlook | 23413 | 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.363 | Parc Vista Overlook | None 942 | |||
10794 | 10794 | 10793 | {"type": "Polygon", "coordinates": [[[-117.7125, 33.55368], [-117.71184, 33.55434], [-117.71055, 33.55436], [-117.71005, 33.55417], [-117.70994, 33.55418], [-117.70983, 33.55394], [-117.70996, 33.55368], [-117.71009, 33.55349], [-117.71028, 33.5533], [-117.71046, 33.55317], [-117.71059, 33.5532], [-117.71118, 33.55316], [-117.71216, 33.55297], [-117.7125, 33.55368]]]} | Open Access 1 | 20184 | La Paz Sports Park | 20786 | 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 | 6.81 | La Paz Sports Park | 0 | Local Recreation Area 3 | 4 | |
10793 | 10793 | 10792 | {"type": "Polygon", "coordinates": [[[-117.70481, 33.55323], [-117.70475, 33.55348], [-117.70439, 33.55348], [-117.70438, 33.55343], [-117.70415, 33.55343], [-117.70414, 33.55337], [-117.70383, 33.55337], [-117.70383, 33.55327], [-117.70357, 33.55327], [-117.70356, 33.55332], [-117.70332, 33.55332], [-117.70331, 33.55327], [-117.70301, 33.55327], [-117.70281, 33.55297], [-117.70232, 33.5531], [-117.70234, 33.55317], [-117.70205, 33.55327], [-117.70188, 33.55317], [-117.70169, 33.553], [-117.70201, 33.55283], [-117.70234, 33.55257], [-117.70255, 33.55234], [-117.70275, 33.55201], [-117.70292, 33.55181], [-117.70307, 33.55199], [-117.70313, 33.55196], [-117.70327, 33.55212], [-117.70323, 33.55216], [-117.70338, 33.55234], [-117.70342, 33.55233], [-117.70359, 33.55253], [-117.70366, 33.5525], [-117.7038, 33.55265], [-117.70382, 33.55265], [-117.70398, 33.55283], [-117.70415, 33.55273], [-117.70435, 33.55296], [-117.70439, 33.55294], [-117.70453, 33.5531], [-117.70464, 33.55304], [-117.70481, 33.55323]]]} | Open Access 1 | 20183 | Yosemite Park | 27783 | 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 | 5.46 | Yosemite Park | 0 | Local Park 2 | 4 | |
10792 | 10792 | 10791 | {"type": "Polygon", "coordinates": [[[-117.6888, 33.50555], [-117.68875, 33.50585], [-117.68869, 33.50603], [-117.68854, 33.50618], [-117.68837, 33.50632], [-117.68833, 33.50648], [-117.68825, 33.50662], [-117.68814, 33.50668], [-117.68772, 33.50571], [-117.6886, 33.50531], [-117.6888, 33.50555]]]} | Open Access 1 | 20181 | Pooch Park | 23891 | 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.026 | Pooch Park | 0 | Local Park 2 | 4 | |
10791 | 10791 | 10790 | {"type": "Polygon", "coordinates": [[[-117.68979, 33.5116], [-117.68929, 33.51193], [-117.68899, 33.51208], [-117.68878, 33.51215], [-117.68851, 33.5122], [-117.68843, 33.51211], [-117.68822, 33.51214], [-117.68813, 33.51198], [-117.68823, 33.51189], [-117.6883, 33.51176], [-117.68835, 33.51163], [-117.68834, 33.51162], [-117.68819, 33.51158], [-117.68828, 33.51138], [-117.68868, 33.5114], [-117.68869, 33.51115], [-117.68965, 33.51106], [-117.68979, 33.5116]]]} | Open Access 1 | 20180 | Reef View Park | 24266 | 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.12 | Reef View Park | 0 | Local Park 2 | 4 | |
10789 | 10789 | 10788 | {"type": "Polygon", "coordinates": [[[-117.68446, 33.51432], [-117.68402, 33.51447], [-117.68379, 33.51438], [-117.68372, 33.51439], [-117.68363, 33.51437], [-117.68339, 33.51418], [-117.68337, 33.51408], [-117.68338, 33.51403], [-117.68343, 33.51401], [-117.68385, 33.51395], [-117.68383, 33.5139], [-117.68401, 33.51378], [-117.6841, 33.51381], [-117.68416, 33.51368], [-117.68427, 33.5136], [-117.6844, 33.51375], [-117.68448, 33.5141], [-117.68446, 33.51432]]]} | Open Access 1 | 20179 | Redondo View Node Park | 24243 | 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.438 | Redondo View Node 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);