units_with_maps

Table actions

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

57 rows where ACCESS_TYP = 3, AGNCY_TYP = 8 and MNG_AG_TYP = 9

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_WEB, MNG_AG_ID

MNG_AG_TYP 1

  • Flood District · 57 ✖

ACCESS_TYP 1

  • No Public Access · 57 ✖
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
1033 1033 1032 {"type": "Polygon", "coordinates": [[[-118.51157, 34.07731], [-118.51143, 34.07746], [-118.5104, 34.07684], [-118.5101, 34.07613], [-118.50988, 34.07539], [-118.50872, 34.07481], [-118.50845, 34.0745], [-118.50826, 34.07401], [-118.50761, 34.07364], [-118.50763, 34.07328], [-118.50737, 34.07296], [-118.50731, 34.07284], [-118.50737, 34.07275], [-118.50746, 34.07269], [-118.50778, 34.07276], [-118.50866, 34.0734], [-118.50892, 34.0734], [-118.50898, 34.07385], [-118.50974, 34.07406], [-118.50989, 34.07443], [-118.50989, 34.07475], [-118.51067, 34.07526], [-118.51068, 34.07637], [-118.51099, 34.07669], [-118.51107, 34.07682], [-118.5113, 34.07702], [-118.51157, 34.07731]]]} No Public Access 3 6378 Sullivan Canyon Creek & Dam 25948 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 10.67 Sullivan Canyon Creek & Dam   None 93  
1702 1702 1701 {"type": "MultiPolygon", "coordinates": [[[[-118.10957, 33.99118], [-118.10841, 33.99393], [-118.10812, 33.99414], [-118.10776, 33.99428], [-118.10723, 33.99468], [-118.1056, 33.99616], [-118.1049, 33.99713], [-118.10463, 33.99726], [-118.10446, 33.99744], [-118.10439, 33.99781], [-118.104, 33.99834], [-118.10373, 33.99899], [-118.1034, 33.99955], [-118.09727, 34.00134], [-118.09715, 34.00171], [-118.09154, 33.99932], [-118.09273, 33.99735], [-118.09448, 33.99594], [-118.09703, 33.99726], [-118.09734, 33.99688], [-118.09773, 33.99673], [-118.09793, 33.99653], [-118.10047, 33.99561], [-118.10232, 33.9928], [-118.10204, 33.99241], [-118.10691, 33.99146], [-118.10957, 33.99118]]], [[[-118.10991, 33.9911], [-118.1069, 33.99141], [-118.102, 33.99238], [-118.10139, 33.99156], [-118.10665, 33.98858], [-118.10706, 33.9888], [-118.10745, 33.98908], [-118.10935, 33.99074], [-118.10962, 33.99093], [-118.10991, 33.9911]]]]} No Public Access 3 6693 Rio Hondo & Bike Trail 24380 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 234.812 Rio Hondo & Bike Trail 0 Local Recreation Area 3 4
3385 3385 3384 {"type": "Polygon", "coordinates": [[[-121.55826, 38.7289], [-121.54862, 38.72895], [-121.5486, 38.7219], [-121.55823, 38.72189], [-121.55826, 38.7289]]]} No Public Access 3 35038 Natomas Basin Conservancy 22668 2092 Natomas Basin Conservancy 634 Special District 4 Flood District 8 http://www.natomasbasin.org/ Special District 4 2092 Natomas Basin Conservancy 623 Special District 4 Flood District 9   Sacramento 41 161.591 Natomas Basin Conservancy   None 279  
3477 3477 3476 {"type": "Polygon", "coordinates": [[[-121.48575, 38.69996], [-121.48446, 38.69997], [-121.48434, 38.68531], [-121.48562, 38.68532], [-121.48575, 38.69996]]]} No Public Access 3 25814 UEDA Parkway 26644 2092 Natomas Basin Conservancy 634 Special District 4 Flood District 8 http://www.natomasbasin.org/ Special District 4 2092 Natomas Basin Conservancy 623 Special District 4 Flood District 9   Sacramento 41 45.052 UEDA Parkway 0 Local Recreation Area 3 4
3642 3642 3641 {"type": "Polygon", "coordinates": [[[-121.55976, 38.81045], [-121.55308, 38.81447], [-121.5516, 38.81536], [-121.55163, 38.80843], [-121.55929, 38.80831], [-121.5588, 38.8086], [-121.55869, 38.80876], [-121.55872, 38.80892], [-121.55888, 38.80918], [-121.55948, 38.80966], [-121.55948, 38.80977], [-121.5595, 38.80998], [-121.55976, 38.81045]]]} No Public Access 3 29722 Frazer 19069 2092 Natomas Basin Conservancy 634 Special District 4 Flood District 8 http://www.natomasbasin.org/ Special District 4 2092 Natomas Basin Conservancy 623 Special District 4 Flood District 9   Sutter 47 85.165 Frazer   None 303  
3674 3674 3673 {"type": "Polygon", "coordinates": [[[-121.5396, 38.7289], [-121.53955, 38.73052], [-121.53953, 38.73375], [-121.53067, 38.73375], [-121.53068, 38.72896], [-121.5396, 38.7289]]]} No Public Access 3 29739 Bianchi West 16062 2092 Natomas Basin Conservancy 634 Special District 4 Flood District 8 http://www.natomasbasin.org/ Special District 4 2092 Natomas Basin Conservancy 623 Special District 4 Flood District 9   Sacramento 41 102.179 Bianchi West 0 None 307  
4563 4563 4562 {"type": "Polygon", "coordinates": [[[-120.41098, 34.87234], [-120.41098, 34.87337], [-120.41065, 34.87339], [-120.4103, 34.87346], [-120.41027, 34.87345], [-120.41017, 34.87328], [-120.41001, 34.87306], [-120.40976, 34.87284], [-120.40967, 34.87273], [-120.40957, 34.87255], [-120.40952, 34.87236], [-120.41098, 34.87234]]]} No Public Access 3 35192 Unnamed site - Santa Barbara Flood Control and Water Conserv. District 28664 2141 Santa Barbara Flood Control and Water Conserv. District 46 Special District 4 Flood District 8 http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 Special District 4 2141 Santa Barbara Flood Control and Water Conserv. District 45 Special District 4 Flood District 9   Santa Barbara 7 3.02   0 Local Other or Unknown 14 4
4779 4779 4778 {"type": "Polygon", "coordinates": [[[-119.7721, 36.81927], [-119.7721, 36.82034], [-119.77065, 36.82074], [-119.76932, 36.82178], [-119.76873, 36.82129], [-119.76874, 36.82111], [-119.76941, 36.82058], [-119.76952, 36.82039], [-119.76935, 36.82023], [-119.76862, 36.8208], [-119.76973, 36.81993], [-119.7721, 36.81927]]]} No Public Access 3 47094 Unnamed site - Fresno Metropolitan Flood Control District 30753 2036 Fresno Metropolitan Flood Control District 29 Special District 4 Flood District 8 http://www.fresnofloodcontrol.org/ Special District 4 2036 Fresno Metropolitan Flood Control District 729 Special District 4 Flood District 9   Fresno 9 9.081   0 Local Other or Unknown 14 4
5654 5654 5653 {"type": "Polygon", "coordinates": [[[-120.41368, 34.87359], [-120.41207, 34.8736], [-120.41207, 34.87233], [-120.4133, 34.87231], [-120.41331, 34.87227], [-120.41366, 34.87227], [-120.41368, 34.87359]]]} No Public Access 3 35181 Unnamed site - Santa Barbara Flood Control and Water Conserv. District 28664 2141 Santa Barbara Flood Control and Water Conserv. District 46 Special District 4 Flood District 8 http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 Special District 4 2141 Santa Barbara Flood Control and Water Conserv. District 45 Special District 4 Flood District 9   Santa Barbara 7 5.145   0 Local Other or Unknown 14 4
7111 7111 7110 {"type": "MultiPolygon", "coordinates": [[[[-118.28809, 33.79111], [-118.28789, 33.79151], [-118.28789, 33.79271], [-118.28758, 33.79273], [-118.28759, 33.79285], [-118.28789, 33.79286], [-118.28788, 33.79407], [-118.28758, 33.79355], [-118.28712, 33.79355], [-118.28703, 33.79257], [-118.28728, 33.79176], [-118.2873, 33.79163], [-118.2873, 33.79112], [-118.28809, 33.79111]]], [[[-118.28884, 33.79414], [-118.28884, 33.79461], [-118.2882, 33.79461], [-118.28805, 33.79435], [-118.28806, 33.79285], [-118.28837, 33.79285], [-118.28836, 33.79318], [-118.28845, 33.79318], [-118.28844, 33.794], [-118.28884, 33.79401], [-118.28884, 33.79414]]], [[[-118.28884, 33.79478], [-118.28884, 33.79511], [-118.28883, 33.7957], [-118.2883, 33.79478], [-118.28884, 33.79478]]], [[[-118.28979, 33.79607], [-118.28978, 33.79731], [-118.28946, 33.79732], [-118.28947, 33.79761], [-118.28899, 33.79761], [-118.289, 33.79539], [-118.28939, 33.79538], [-118.2894, 33.79552], [-118.28978, 33.79552], [-118.28979, 33.79607]]], [[[-118.28994, 33.79789], [-118.28993, 33.79899], [-118.28916, 33.80024], [-118.28897, 33.80024], [-118.28891, 33.80001], [-118.28877, 33.79965], [-118.28852, 33.79913], [-118.28826, 33.79876], [-118.28819, 33.79867], [-118.28837, 33.79789], [-118.28994, 33.79789]]]]} No Public Access 3 6187 Canada de Palos Verdes Creek 16791 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 18.831 Canada de Palos Verdes Creek 0 Local Other or Unknown 14 4
8226 8226 8225 {"type": "MultiPolygon", "coordinates": [[[[-118.39803, 34.33154], [-118.3977, 34.33187], [-118.39753, 34.33221], [-118.39757, 34.33239], [-118.39737, 34.33259], [-118.39713, 34.33296], [-118.39723, 34.33309], [-118.39705, 34.33349], [-118.39717, 34.33365], [-118.39712, 34.3337], [-118.39693, 34.33361], [-118.39669, 34.32974], [-118.39678, 34.32974], [-118.39673, 34.32982], [-118.39691, 34.33018], [-118.39675, 34.33035], [-118.39698, 34.33065], [-118.39722, 34.33079], [-118.39714, 34.33099], [-118.39747, 34.3312], [-118.39755, 34.3313], [-118.39803, 34.33154]]], [[[-118.40538, 34.33402], [-118.40103, 34.33386], [-118.40101, 34.33713], [-118.39708, 34.33708], [-118.39693, 34.33374], [-118.39715, 34.33384], [-118.39734, 34.33366], [-118.3972, 34.33348], [-118.39737, 34.33307], [-118.39728, 34.33295], [-118.39748, 34.33265], [-118.39771, 34.33242], [-118.39766, 34.33222], [-118.39781, 34.33192], [-118.39822, 34.33152], [-118.39805, 34.33141], [-118.39764, 34.33122], [-118.39757, 34.33112], [-118.39729, 34.33095], [-118.39738, 34.33074], [-118.39707, 34.33057], [-118.39691, 34.33035], [-118.39707, 34.3302], [-118.39687, 34.32982], [-118.39693, 34.32974], [-118.39846, 34.32976], [-118.39852, 34.32957], [-118.39898, 34.32907], [-118.39906, 34.32891], [-118.40003, 34.32864], [-118.40055, 34.32838], [-118.40086, 34.32802], [-118.40088, 34.32853], [-118.4008, 34.32863], [-118.40014, 34.32961], [-118.40005, 34.32969], [-118.39991, 34.32975], [-118.39991, 34.32977], [-118.40014, 34.32977], [-118.40022, 34.3297], [-118.40089, 34.32872], [-118.40095, 34.32978], [-118.40521, 34.32981], [-118.40538, 34.33402]]]]} No Public Access 3 12544 Pacoima Wash 23311 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 125.037 Pacoima Wash   None 686  
8295 8295 8294 {"type": "Polygon", "coordinates": [[[-118.44066, 34.32991], [-118.44064, 34.33152], [-118.43961, 34.33184], [-118.43917, 34.33239], [-118.43727, 34.33306], [-118.43591, 34.33306], [-118.43464, 34.33355], [-118.4344, 34.33311], [-118.43366, 34.33287], [-118.43328, 34.33317], [-118.43276, 34.33272], [-118.43306, 34.33152], [-118.43441, 34.33071], [-118.43503, 34.33053], [-118.43502, 34.3299], [-118.43183, 34.32988], [-118.43185, 34.3275], [-118.43215, 34.32748], [-118.43219, 34.32749], [-118.43222, 34.32753], [-118.43237, 34.32753], [-118.43239, 34.32749], [-118.43242, 34.32747], [-118.43272, 34.32745], [-118.43274, 34.32766], [-118.43307, 34.32764], [-118.43308, 34.32772], [-118.43659, 34.32755], [-118.43659, 34.32747], [-118.43694, 34.32744], [-118.43744, 34.32745], [-118.43745, 34.32741], [-118.43782, 34.32741], [-118.43782, 34.3299], [-118.44066, 34.32991]]]} No Public Access 3 12714 Flood Control 18953 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 85.213 Flood Control 0 Local Other or Unknown 14 4
8296 8296 8295 {"type": "Polygon", "coordinates": [[[-118.46627, 34.32993], [-118.46601, 34.32993], [-118.466, 34.32966], [-118.46531, 34.32965], [-118.46531, 34.32993], [-118.46492, 34.32992], [-118.4651, 34.32938], [-118.46586, 34.32944], [-118.46627, 34.32993]]]} No Public Access 3 12715 Flood Control 18953 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 0.889 Flood Control 0 Local Other or Unknown 14 4
8298 8298 8297 {"type": "Polygon", "coordinates": [[[-118.42996, 34.33076], [-118.42998, 34.3313], [-118.42978, 34.33175], [-118.42986, 34.33266], [-118.42959, 34.33271], [-118.42929, 34.33205], [-118.42879, 34.33196], [-118.4284, 34.33155], [-118.42781, 34.33143], [-118.42735, 34.33145], [-118.42681, 34.33168], [-118.42663, 34.3315], [-118.42709, 34.33123], [-118.42776, 34.33103], [-118.42849, 34.33092], [-118.42842, 34.33034], [-118.42684, 34.33026], [-118.42679, 34.33], [-118.42852, 34.32962], [-118.42869, 34.32985], [-118.42874, 34.32985], [-118.42897, 34.32974], [-118.42912, 34.3296], [-118.42922, 34.32943], [-118.42925, 34.32922], [-118.4294, 34.32923], [-118.4294, 34.32942], [-118.42954, 34.33013], [-118.42957, 34.33017], [-118.42962, 34.3302], [-118.42968, 34.3302], [-118.42974, 34.33019], [-118.4298, 34.33026], [-118.42957, 34.33035], [-118.42956, 34.33037], [-118.42969, 34.33054], [-118.42996, 34.33076]]]} No Public Access 3 12716 Flood Control 18953 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 12.167 Flood Control 0 Local Other or Unknown 14 4
8300 8300 8299 {"type": "Polygon", "coordinates": [[[-118.46565, 34.33048], [-118.46562, 34.33062], [-118.46563, 34.33073], [-118.46517, 34.33077], [-118.46516, 34.33138], [-118.46458, 34.332], [-118.46458, 34.33243], [-118.46432, 34.33311], [-118.4639, 34.3328], [-118.46417, 34.33245], [-118.46393, 34.33219], [-118.46382, 34.33173], [-118.46412, 34.33168], [-118.46385, 34.33059], [-118.46422, 34.33041], [-118.46428, 34.3302], [-118.4648, 34.33011], [-118.46482, 34.33008], [-118.46531, 34.33009], [-118.46526, 34.33043], [-118.46565, 34.33048]]]} No Public Access 3 12719 Flood Control 18953 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 6.732 Flood Control 0 Local Other or Unknown 14 4
8301 8301 8300 {"type": "Polygon", "coordinates": [[[-118.45954, 34.32608], [-118.45903, 34.32693], [-118.45897, 34.32748], [-118.45866, 34.32801], [-118.45855, 34.32801], [-118.45828, 34.32695], [-118.45824, 34.32695], [-118.45826, 34.32561], [-118.45823, 34.3255], [-118.458, 34.32543], [-118.4579, 34.32485], [-118.45808, 34.32479], [-118.45807, 34.32476], [-118.45823, 34.32469], [-118.45797, 34.32414], [-118.45813, 34.32418], [-118.45857, 34.32507], [-118.45921, 34.32507], [-118.45954, 34.32608]]]} No Public Access 3 12720 Flood Control 18953 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 7.386 Flood Control 0 Local Other or Unknown 14 4
8302 8302 8301 {"type": "MultiPolygon", "coordinates": [[[[-118.47595, 34.32868], [-118.47522, 34.32881], [-118.47516, 34.32877], [-118.475, 34.3286], [-118.47468, 34.32886], [-118.47418, 34.32872], [-118.47382, 34.32824], [-118.47375, 34.32796], [-118.47388, 34.32773], [-118.47425, 34.32782], [-118.47464, 34.3274], [-118.47489, 34.32723], [-118.475, 34.32723], [-118.47498, 34.32741], [-118.47504, 34.32747], [-118.47515, 34.32748], [-118.47595, 34.32868]]], [[[-118.47687, 34.33028], [-118.47677, 34.33041], [-118.47584, 34.32924], [-118.4757, 34.32915], [-118.4762, 34.32905], [-118.47683, 34.33027], [-118.47687, 34.33028]]]]} No Public Access 3 12721 Flood Control 18953 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 6.178 Flood Control 0 Local Other or Unknown 14 4
8303 8303 8302 {"type": "Polygon", "coordinates": [[[-118.47061, 34.3327], [-118.47016, 34.33284], [-118.46964, 34.33229], [-118.46861, 34.33235], [-118.46846, 34.33475], [-118.46779, 34.33473], [-118.46763, 34.33148], [-118.46832, 34.33146], [-118.46882, 34.3306], [-118.46881, 34.33058], [-118.46838, 34.33055], [-118.46839, 34.33011], [-118.46915, 34.33012], [-118.46944, 34.33023], [-118.46958, 34.33035], [-118.47003, 34.33102], [-118.47061, 34.3327]]]} No Public Access 3 12722 Flood Control 18953 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 15.975 Flood Control 0 Local Other or Unknown 14 4
8304 8304 8303 {"type": "Polygon", "coordinates": [[[-118.44775, 34.33271], [-118.44653, 34.33307], [-118.44644, 34.33288], [-118.44629, 34.33208], [-118.44632, 34.3321], [-118.44633, 34.33209], [-118.44593, 34.33133], [-118.4458, 34.33101], [-118.44556, 34.33066], [-118.44548, 34.3306], [-118.44537, 34.33055], [-118.44527, 34.33054], [-118.44516, 34.33055], [-118.44502, 34.3306], [-118.44486, 34.33072], [-118.44462, 34.33082], [-118.44455, 34.33083], [-118.44446, 34.3308], [-118.4444, 34.33074], [-118.44438, 34.33068], [-118.4444, 34.33061], [-118.44498, 34.32992], [-118.44717, 34.32993], [-118.44716, 34.33007], [-118.44756, 34.33103], [-118.44775, 34.33271]]]} No Public Access 3 12723 Flood Control 18953 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 13.401 Flood Control 0 Local Other or Unknown 14 4
8352 8352 8351 {"type": "Polygon", "coordinates": [[[-117.30654, 34.07949], [-117.3063, 34.07973], [-117.30578, 34.07938], [-117.30538, 34.07893], [-117.30545, 34.07884], [-117.30409, 34.07756], [-117.30366, 34.07727], [-117.30308, 34.07734], [-117.30332, 34.07721], [-117.3039, 34.07712], [-117.30416, 34.07684], [-117.30422, 34.07705], [-117.30575, 34.07856], [-117.30654, 34.07949]]]} No Public Access 3 12937 Lytle-Cajon Channel 21615 2131 San Bernardino County Flood Control District 891 Special District 4 Flood District 8 http://www.sbcounty.gov/dpw/floodcontrol/ Special District 4 2131 San Bernardino County Flood Control District 865 Special District 4 Flood District 9   San Bernardino 22 4.286 Lytle-Cajon Channel   None 696  

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