units_with_maps

Table actions

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

275 rows where LAYER = 4, MNG_AGENCY = 27 and MNG_AG_TYP = 6

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, PARK_URL, YR_EST

MNG_AG_TYP 1

  • Open Space District · 275 ✖

MNG_AGENCY 1

  • Mountains Recreation and Conservation Authority · 275 ✖
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
51 51 50 {"type": "Polygon", "coordinates": [[[-118.674, 34.29348], [-118.67397, 34.29777], [-118.67398, 34.29799], [-118.67395, 34.30795], [-118.67392, 34.32596], [-118.65355, 34.32593], [-118.6368, 34.29182], [-118.63356, 34.27021], [-118.63407, 34.26984], [-118.63486, 34.26943], [-118.63545, 34.26914], [-118.63594, 34.26887], [-118.63651, 34.26874], [-118.63636, 34.2682], [-118.63686, 34.26821], [-118.63699, 34.26795], [-118.63775, 34.2679], [-118.63862, 34.26735], [-118.63882, 34.26705], [-118.64002, 34.26694], [-118.64055, 34.26718], [-118.64124, 34.26707], [-118.64161, 34.26757], [-118.64205, 34.268], [-118.64292, 34.26794], [-118.64321, 34.26815], [-118.64384, 34.26796], [-118.64476, 34.26861], [-118.64486, 34.26885], [-118.64554, 34.26919], [-118.64591, 34.26945], [-118.64587, 34.26972], [-118.64605, 34.26992], [-118.64617, 34.27043], [-118.64649, 34.27042], [-118.64736, 34.27032], [-118.64857, 34.2705], [-118.64975, 34.27054], [-118.65053, 34.27066], [-118.65167, 34.27079], [-118.65135, 34.27117], [-118.65102, 34.27141], [-118.6505, 34.27233], [-118.65068, 34.27264], [-118.651, 34.27288], [-118.65206, 34.27291], [-118.65241, 34.2726], [-118.65269, 34.27253], [-118.65287, 34.27283], [-118.6536, 34.27319], [-118.65554, 34.27312], [-118.65564, 34.27322], [-118.6557, 34.27352], [-118.65552, 34.27365], [-118.65526, 34.27388], [-118.65532, 34.27401], [-118.6557, 34.27417], [-118.65686, 34.2756], [-118.65684, 34.27585], [-118.65692, 34.276], [-118.65743, 34.27643], [-118.65769, 34.27678], [-118.65796, 34.27742], [-118.65835, 34.27777], [-118.65861, 34.2779], [-118.657, 34.2786], [-118.65697, 34.2852], [-118.65552, 34.2852], [-118.65553, 34.28163], [-118.65284, 34.28162], [-118.65281, 34.2889], [-118.65656, 34.28891], [-118.65656, 34.28992], [-118.65968, 34.28993], [-118.65966, 34.29346], [-118.674, 34.29348]], [[-118.65173, 34.28695], [-118.65174, 34.28673], [-118.65148, 34.28674], [-118.65148, 34.28695], [-118.65173, 34.28695]]]} Open Access 1 147 Rocky Peak Park 7206 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://lamountains.com/parks.asp?parkid=51 Ventura 8 3570.979 Rocky Peak Park 0 Local Park 2 4
413 413 412 {"type": "Polygon", "coordinates": [[[-118.60477, 34.27717], [-118.60418, 34.27703], [-118.60318, 34.2767], [-118.60222, 34.27647], [-118.60128, 34.2759], [-118.59886, 34.27528], [-118.59773, 34.27477], [-118.5968, 34.27437], [-118.59644, 34.27429], [-118.59687, 34.27384], [-118.59763, 34.27384], [-118.59817, 34.27352], [-118.59822, 34.27339], [-118.59913, 34.27345], [-118.59979, 34.27347], [-118.60035, 34.2736], [-118.60064, 34.27325], [-118.60057, 34.27261], [-118.60272, 34.2726], [-118.60273, 34.27228], [-118.60457, 34.27224], [-118.60449, 34.27236], [-118.60431, 34.27294], [-118.60432, 34.27441], [-118.60439, 34.27467], [-118.60448, 34.27485], [-118.60448, 34.27491], [-118.60457, 34.27492], [-118.60477, 34.27613], [-118.60481, 34.27645], [-118.60482, 34.27667], [-118.6048, 34.27695], [-118.60477, 34.27717]]]} Open Access 1 831 Stoney Point Park 30273 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 55.047 Stoney Point Park 0 Local Park 2 4
415 415 414 {"type": "Polygon", "coordinates": [[[-118.21396, 34.10912], [-118.21373, 34.10945], [-118.21319, 34.10986], [-118.21289, 34.11018], [-118.21235, 34.11095], [-118.21288, 34.11156], [-118.21273, 34.11194], [-118.21216, 34.11203], [-118.21173, 34.11207], [-118.21061, 34.11072], [-118.21136, 34.11055], [-118.21098, 34.11009], [-118.21022, 34.11025], [-118.21011, 34.11013], [-118.21088, 34.10996], [-118.21117, 34.10978], [-118.2106, 34.10917], [-118.21198, 34.10827], [-118.21371, 34.10856], [-118.2137, 34.10865], [-118.21396, 34.10912]]]} Open Access 1 1647 Heidelberg Park 19791 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 18.734 Heidelberg Park 0 Local Park 2 4
938 938 937 {"type": "MultiPolygon", "coordinates": [[[[-118.69792, 34.10714], [-118.69353, 34.10711], [-118.68501, 34.10711], [-118.68487, 34.09988], [-118.69337, 34.09987], [-118.69287, 34.10126], [-118.69282, 34.10153], [-118.69283, 34.10168], [-118.69285, 34.10183], [-118.69297, 34.10211], [-118.69307, 34.10225], [-118.69318, 34.10237], [-118.69338, 34.10253], [-118.69352, 34.10262], [-118.69383, 34.10273], [-118.69404, 34.10277], [-118.69426, 34.10279], [-118.69447, 34.10278], [-118.69662, 34.10254], [-118.69692, 34.10254], [-118.69721, 34.10256], [-118.69791, 34.10269], [-118.69792, 34.10714]]], [[[-118.71106, 34.10003], [-118.711, 34.10008], [-118.711, 34.1006], [-118.71099, 34.10061], [-118.71099, 34.10066], [-118.711, 34.10067], [-118.71101, 34.10229], [-118.70867, 34.10291], [-118.70755, 34.10261], [-118.70751, 34.10269], [-118.70732, 34.10264], [-118.70735, 34.10256], [-118.70735, 34.10227], [-118.70701, 34.10227], [-118.70646, 34.10285], [-118.70647, 34.10286], [-118.70927, 34.1046], [-118.70848, 34.10476], [-118.70774, 34.10486], [-118.70724, 34.10489], [-118.70674, 34.10489], [-118.706, 34.10485], [-118.70526, 34.10476], [-118.70453, 34.1046], [-118.70406, 34.10447], [-118.70337, 34.10423], [-118.70141, 34.10334], [-118.70104, 34.10319], [-118.70066, 34.10306], [-118.70008, 34.10291], [-118.69741, 34.10236], [-118.69709, 34.10233], [-118.69661, 34.10232], [-118.69444, 34.10256], [-118.69422, 34.10257], [-118.69401, 34.10254], [-118.69371, 34.10245], [-118.69353, 34.10235], [-118.69339, 34.10223], [-118.69327, 34.1021], [-118.69318, 34.10195], [-118.69312, 34.10179], [-118.6931, 34.10163], [-118.6931, 34.10146], [-118.69314, 34.1013], [-118.69364, 34.09988], [-118.70399, 34.09987], [-118.7067, 34.09985], [-118.71106, 34.0999], [-118.71106, 34.10003]]], [[[-118.70669, 34.09625], [-118.7023, 34.09625], [-118.70229, 34.09806], [-118.70011, 34.09807], [-118.7001, 34.09625], [-118.70228, 34.09625], [-118.70228, 34.09551], [-118.70342, 34.09546], [-118.70406, 34.09465], [-118.70491, 34.09451], [-118.70605, 34.09381], [-118.70636, 34.09308], [-118.70669, 34.09361], [-118.70669, 34.09625]]], [[[-118.70669, 34.09336], [-118.70649, 34.09304], [-118.70669, 34.09297], [-118.70669, 34.09329], [-118.70669, 34.09336]]]]} Open Access 1 6489 King Gillette Ranch 7140 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.lamountains.com/parks.asp?parkid=670 Los Angeles 6 383.837 King Gillette Ranch 0 Local Park 2 4
1046 1046 1045 {"type": "Polygon", "coordinates": [[[-118.34139, 34.12342], [-118.34119, 34.12342], [-118.34101, 34.12338], [-118.34082, 34.12338], [-118.34041, 34.12313], [-118.34051, 34.12301], [-118.34068, 34.12311], [-118.34077, 34.12313], [-118.34087, 34.12313], [-118.341, 34.12307], [-118.34139, 34.12342]]]} Open Access 1 6900 Unnamed site - Mountains Recreation and Conservation Authority 29458 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 0.464   0 Local Other or Unknown 14 4
1047 1047 1046 {"type": "MultiPolygon", "coordinates": [[[[-118.52781, 34.12892], [-118.52765, 34.12897], [-118.52752, 34.12899], [-118.52699, 34.12889], [-118.5269, 34.12887], [-118.52682, 34.12882], [-118.52674, 34.12872], [-118.52724, 34.12879], [-118.52781, 34.12892]]], [[[-118.52963, 34.12976], [-118.52948, 34.12986], [-118.5294, 34.12995], [-118.52935, 34.12974], [-118.52925, 34.12956], [-118.52963, 34.12976]]]]} Open Access 1 6364 Dirt Mulholland 18160 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 0.435 Dirt Mulholland   None 95  
1066 1066 1065 {"type": "Polygon", "coordinates": [[[-118.16257, 34.20755], [-118.16261, 34.2077], [-118.16261, 34.20779], [-118.16252, 34.20798], [-118.16232, 34.20798], [-118.16232, 34.20756], [-118.16257, 34.20755]]]} Open Access 1 6963 Unnamed site - Mountains Recreation and Conservation Authority 29458 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 0.283   0 Local Other or Unknown 14 4
1069 1069 1068 {"type": "Polygon", "coordinates": [[[-118.64067, 34.06497], [-118.64065, 34.06495], [-118.64055, 34.065], [-118.6405, 34.06505], [-118.64048, 34.06512], [-118.6405, 34.06525], [-118.64059, 34.06544], [-118.63925, 34.0655], [-118.6403, 34.06406], [-118.64038, 34.06412], [-118.64057, 34.0642], [-118.64081, 34.06442], [-118.64085, 34.06449], [-118.64086, 34.06455], [-118.64083, 34.06472], [-118.64088, 34.06484], [-118.64087, 34.06487], [-118.64083, 34.06492], [-118.64067, 34.06497]]]} Open Access 1 6433 Las Flores Canyon Open Space 21048 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 3.131 Las Flores Canyon OS 0 Local Recreation Area 3 4
1082 1082 1081 {"type": "Polygon", "coordinates": [[[-118.63078, 34.13573], [-118.63037, 34.13633], [-118.6238, 34.13634], [-118.6238, 34.13271], [-118.62865, 34.13271], [-118.62873, 34.1328], [-118.6287, 34.13306], [-118.62899, 34.1332], [-118.62924, 34.13362], [-118.62944, 34.13379], [-118.62951, 34.13395], [-118.6297, 34.13402], [-118.62991, 34.13418], [-118.63012, 34.13424], [-118.63017, 34.13442], [-118.63028, 34.13455], [-118.63032, 34.13484], [-118.63051, 34.13517], [-118.63078, 34.13573]]]} Open Access 1 6457 Dry Creek Canyon Park 29796 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 56.278 Dry Creek Canyon Park 0 Local Park 2 4
1188 1188 1187 {"type": "Polygon", "coordinates": [[[-118.33232, 34.11518], [-118.33231, 34.11561], [-118.33188, 34.11561], [-118.33189, 34.11558], [-118.33202, 34.11557], [-118.33203, 34.11518], [-118.33232, 34.11518]]]} Open Access 1 6882 Lake Hollywood MRCA Open Space 20946 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 0.322 Lake Hollywood MRCA OS 0 Local Recreation Area 3 4
1189 1189 1188 {"type": "Polygon", "coordinates": [[[-118.34398, 34.10983], [-118.34396, 34.10986], [-118.34393, 34.10999], [-118.34395, 34.1101], [-118.34376, 34.11029], [-118.34363, 34.10997], [-118.34368, 34.10981], [-118.34398, 34.10983]]]} Open Access 1 6893 Castilian MRCA Open Space 16949 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 0.278 Castilian MRCA OS 0 Local Recreation Area 3 4
1190 1190 1189 {"type": "Polygon", "coordinates": [[[-118.3611, 34.12682], [-118.36096, 34.12699], [-118.36109, 34.12708], [-118.36098, 34.12719], [-118.36091, 34.12732], [-118.36077, 34.12724], [-118.36072, 34.12735], [-118.36057, 34.12747], [-118.36053, 34.1274], [-118.36065, 34.1273], [-118.36073, 34.12714], [-118.36079, 34.12706], [-118.36096, 34.12689], [-118.36102, 34.12679], [-118.3611, 34.12682]]]} Open Access 1 6901 Mulholland Adjacent Open Space 22590 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 0.278 Mulholland Adjacent OS 0 Local Recreation Area 3 4
1208 1208 1207 {"type": "Polygon", "coordinates": [[[-118.6372, 34.36427], [-118.62414, 34.36475], [-118.62394, 34.35736], [-118.63275, 34.35717], [-118.63292, 34.36076], [-118.63708, 34.36067], [-118.6372, 34.36427]]]} Unknown Access 4 8425 Unnamed site - Mountains Recreation and Conservation Authority 28644 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 201.929   0 Local Other or Unknown 14 4
1273 1273 1272 {"type": "Polygon", "coordinates": [[[-118.21161, 34.50894], [-118.21051, 34.50893], [-118.21051, 34.50802], [-118.2116, 34.50803], [-118.21161, 34.50894]]]} Unknown Access 4 9563 Red Rover Mine TaxDef 24228 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 2.509 Red Rover Mine TaxDef   None 110  
1440 1440 1439 {"type": "Polygon", "coordinates": [[[-118.64876, 34.13111], [-118.64858, 34.13138], [-118.64815, 34.13161], [-118.64807, 34.13167], [-118.64806, 34.13091], [-118.6487, 34.13091], [-118.64871, 34.13102], [-118.64876, 34.13111]]]} Open Access 1 12480 MRCA Calabasas Open Space 22568 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 0.921 MRCA Calabasas OS 0 Local Recreation Area 3 4
2390 2390 2389 {"type": "Polygon", "coordinates": [[[-118.71787, 34.45684], [-118.71569, 34.45684], [-118.71568, 34.46041], [-118.71122, 34.4604], [-118.70698, 34.46033], [-118.70695, 34.45676], [-118.70268, 34.45668], [-118.70267, 34.45669], [-118.70272, 34.46026], [-118.69843, 34.46019], [-118.6982, 34.45301], [-118.70692, 34.45318], [-118.70696, 34.44953], [-118.71123, 34.44959], [-118.71339, 34.44958], [-118.71341, 34.45326], [-118.71611, 34.45327], [-118.71787, 34.45684]]]} Unknown Access 4 11474 Holser Canyon Open Space 29737 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 345.8 Holser Canyon OS 0 Local Recreation Area 3 4
2440 2440 2439 {"type": "Polygon", "coordinates": [[[-118.75343, 34.05089], [-118.75323, 34.05643], [-118.74908, 34.05636], [-118.74917, 34.05088], [-118.75343, 34.05089]]]} Open Access 1 48525 Dal Molin-Runcie Nature Preserve 33239 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 58.568 Dal Molin-Runcie Nature Preserve 2017 Local Conservation Area 4 2
2511 2511 2510 {"type": "Polygon", "coordinates": [[[-118.51605, 34.05992], [-118.51605, 34.05992], [-118.51557, 34.05983], [-118.51602, 34.0595], [-118.51598, 34.0597], [-118.516, 34.05981], [-118.51605, 34.05992]]]} Open Access 1 6356 Topanga State Park 26410 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.parks.ca.gov/?page_id=629 Los Angeles 6 0.22 Topanga SP 1967 None 206  
2757 2757 2756 {"type": "MultiPolygon", "coordinates": [[[[-118.59473, 34.28578], [-118.59293, 34.28578], [-118.59293, 34.285], [-118.59312, 34.285], [-118.59312, 34.28575], [-118.59473, 34.28575], [-118.59473, 34.28578]]], [[[-118.59361, 34.28526], [-118.59361, 34.28556], [-118.59351, 34.28556], [-118.59352, 34.28526], [-118.59361, 34.28526]]], [[[-118.59668, 34.28578], [-118.59486, 34.28578], [-118.59486, 34.28575], [-118.59668, 34.28575], [-118.59668, 34.28578]]], [[[-118.60597, 34.28577], [-118.60597, 34.28579], [-118.59688, 34.28578], [-118.59688, 34.28575], [-118.60597, 34.28577]]], [[[-118.60374, 34.28244], [-118.60374, 34.28248], [-118.60327, 34.28222], [-118.59971, 34.28221], [-118.59971, 34.28218], [-118.60328, 34.28219], [-118.60374, 34.28244]]], [[[-118.60598, 34.2846], [-118.6054, 34.2846], [-118.60471, 34.2841], [-118.60429, 34.28329], [-118.6043, 34.28325], [-118.60474, 34.28409], [-118.60541, 34.28457], [-118.60598, 34.28457], [-118.60598, 34.2846]]]]} Open Access 1 18451 Deer Lake Highlands 17998 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 1.806 Deer Lake Highlands   None 231  
2813 2813 2812 {"type": "Polygon", "coordinates": [[[-118.60192, 34.30954], [-118.5977, 34.30949], [-118.59761, 34.30585], [-118.60185, 34.30584], [-118.60192, 34.30954]]]} Open Access 1 12864 MRCA Parkland 22570 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 39.114 MRCA Parkland 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]);