units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
108 rows where MNG_AG_LEV = 4 and MNG_AG_TYP = 9
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY
DES_TP >30
MNG_AGENCY 9
- Fresno Metropolitan Flood Control District 29
- Los Angeles County Flood Control District 23
- Natomas Basin Conservancy 22
- Santa Barbara Flood Control and Water Conserv. District 21
- San Bernardino County Flood Control District 5
- Sacramento and San Joaquin Drainage District 4
- Sacramento Area Flood Control Agency 2
- Alameda County Flood Control and Water Conservation District 1
- Marin Public Works Dept/Flood Control 1
ACCESS_TYP 4
MNG_AG_TYP 1
- Flood District · 108 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108 | 108 | 107 | {"type": "Polygon", "coordinates": [[[-119.80165, 34.44381], [-119.80106, 34.44387], [-119.79957, 34.44402], [-119.79959, 34.44377], [-119.80161, 34.44357], [-119.80165, 34.44381]]]} | Unknown Access 4 | 295 | San Antonio Creek | 24829 | 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 | 1.291 | San Antonio Creek | 0 | Local Other or Unknown 14 | 4 | |
| 172 | 172 | 171 | {"type": "Polygon", "coordinates": [[[-119.7122, 34.45864], [-119.71219, 34.45865], [-119.71206, 34.45871], [-119.71176, 34.45871], [-119.71175, 34.45848], [-119.71185, 34.45854], [-119.7122, 34.45864]]]} | Open Access 1 | 462 | Santa Barbara Botanic Gardens | 25037 | 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 | 0.145 | Santa Barbara Botanic Gardens | 0 | Local Park 2 | 4 | |
| 241 | 241 | 240 | {"type": "Polygon", "coordinates": [[[-120.19548, 34.61923], [-120.19532, 34.62017], [-120.19414, 34.61966], [-120.19453, 34.61897], [-120.19477, 34.61907], [-120.19504, 34.61915], [-120.19548, 34.61923]]]} | Open Access 1 | 785 | Buellton Park | 16483 | 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 | 2.399 | Buellton Park | 0 | Local Park 2 | 4 | |
| 928 | 928 | 927 | {"type": "MultiPolygon", "coordinates": [[[[-118.59921, 34.0992], [-118.59903, 34.09939], [-118.59861, 34.09959], [-118.59848, 34.0997], [-118.59839, 34.10003], [-118.59832, 34.10038], [-118.59776, 34.10077], [-118.59771, 34.10077], [-118.5977, 34.10064], [-118.59805, 34.10038], [-118.59816, 34.10024], [-118.59822, 34.10008], [-118.59827, 34.09982], [-118.59832, 34.09971], [-118.59838, 34.09965], [-118.59873, 34.09941], [-118.59894, 34.09917], [-118.59904, 34.09909], [-118.59921, 34.0992]]], [[[-118.60098, 34.097], [-118.60043, 34.09746], [-118.60002, 34.09794], [-118.59991, 34.09786], [-118.60007, 34.09761], [-118.60025, 34.09742], [-118.60077, 34.0971], [-118.60089, 34.09699], [-118.60096, 34.09691], [-118.60098, 34.097]]], [[[-118.60123, 34.09661], [-118.60104, 34.09701], [-118.60099, 34.09686], [-118.60102, 34.09679], [-118.60106, 34.0966], [-118.60103, 34.09619], [-118.60109, 34.09619], [-118.6011, 34.09645], [-118.60123, 34.09661]]]]} | Open Access 1 | 6426 | Topanga Creek | 26407 | 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 | 1.477 | Topanga Creek | 0 | Local Other or Unknown 14 | 4 | |
| 986 | 986 | 985 | {"type": "MultiPolygon", "coordinates": [[[[-118.07211, 33.98316], [-118.0721, 33.98317], [-118.07151, 33.98276], [-118.07152, 33.98275], [-118.07211, 33.98316]]], [[[-118.07278, 33.98341], [-118.07277, 33.98343], [-118.07221, 33.98304], [-118.07222, 33.98303], [-118.07278, 33.98341]]], [[[-118.07399, 33.98445], [-118.07398, 33.98447], [-118.07355, 33.98418], [-118.07356, 33.98416], [-118.07399, 33.98445]]]]} | Open Access 1 | 6696 | San Gabriel River & Bike Trail | 24897 | 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.082 | San Gabriel River & Bike Trail | 0 | Local Recreation Area 3 | 4 | |
| 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 | |||
| 1274 | 1274 | 1273 | {"type": "Polygon", "coordinates": [[[-118.23627, 33.89605], [-118.23616, 33.89604], [-118.23608, 33.89598], [-118.2362, 33.89598], [-118.23627, 33.89605]]]} | Open Access 1 | 7201 | Compton Creek & Bike Path | 17572 | 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.02 | Compton Creek & Bike Path | 0 | Local Recreation Area 3 | 4 | |
| 1383 | 1383 | 1382 | {"type": "MultiPolygon", "coordinates": [[[[-118.11369, 33.74771], [-118.11255, 33.74876], [-118.11157, 33.74945], [-118.11111, 33.74973], [-118.11072, 33.75002], [-118.10969, 33.75059], [-118.10907, 33.75104], [-118.10859, 33.75128], [-118.10795, 33.75156], [-118.10746, 33.75184], [-118.10626, 33.75271], [-118.10615, 33.7526], [-118.10645, 33.75239], [-118.10679, 33.7521], [-118.10724, 33.75181], [-118.10794, 33.75137], [-118.10847, 33.7511], [-118.10942, 33.75052], [-118.11024, 33.75006], [-118.11049, 33.74986], [-118.11078, 33.74967], [-118.11147, 33.74927], [-118.11266, 33.74838], [-118.11291, 33.74808], [-118.11342, 33.74755], [-118.11353, 33.74764], [-118.11369, 33.74771]]], [[[-118.11145, 33.91335], [-118.11145, 33.91375], [-118.11156, 33.91471], [-118.1116, 33.91546], [-118.11167, 33.91642], [-118.11171, 33.91749], [-118.1118, 33.91832], [-118.11186, 33.91924], [-118.11187, 33.92019], [-118.11192, 33.92073], [-118.11189, 33.92139], [-118.11181, 33.92169], [-118.11149, 33.92319], [-118.11111, 33.92383], [-118.11077, 33.92461], [-118.11028, 33.92567], [-118.10967, 33.92685], [-118.10915, 33.928], [-118.10913, 33.928], [-118.1088, 33.92855], [-118.10837, 33.92938], [-118.10822, 33.92971], [-118.10783, 33.93064], [-118.10766, 33.93119], [-118.10745, 33.93166], [-118.10705, 33.93227], [-118.10669, 33.93288], [-118.10635, 33.9333], [-118.10614, 33.9336], [-118.10521, 33.93457], [-118.10477, 33.93515], [-118.10426, 33.93566], [-118.10372, 33.93624], [-118.10267, 33.9375], [-118.10222, 33.93811], [-118.1019, 33.93842], [-118.10146, 33.93901], [-118.10117, 33.93944], [-118.10115, 33.93944], [-118.10089, 33.93981], [-118.10051, 33.94047], [-118.10037, 33.94076], [-118.10031, 33.94104], [-118.10013, 33.94157], [-118.10007, 33.942], [-118.09992, 33.94246], [-118.09979, 33.94295], [-118.09969, 33.94343], [-118.0995, 33.94406], [-118.09941, 33.94443], [-118.09927, 33.9452], [-118.09912, 33.94539], [-118.09913, 33.94542], [-118.09891, 33.94581], [-118.09846, 33.94641], [-118.09783, 33.94708], [-118.09726, 33.94777], [-118.09665, 33.94841], [-118.09618, 33.94895], [-118.09485, 33.95055], [-118.09431, 33.95115], [-118.09373, 33.95176], [-118.09286, 33.95272], [-118.0923, 33.95331], [-118.09176, 33.95393], [-118.09132, 33.9545], [-118.09065, 33.95523], [-118.09021, 33.9559], [-118.08916, 33.95768], [-118.08874, 33.95854], [-118.08812, 33.9597], [-118.08791, 33.96041], [-118.08788, 33.96063], [-118.08793, 33.96163], [-118.08806, 33.96206], [-118.08832, 33.96268], [-118.08858, 33.96321], [-118.08887, 33.96363], [-118.08911, 33.96406], [-118.08941, 33.96464], [-118.08975, 33.9656], [-118.08987, 33.96622], [-118.08997, 33.96658], [-118.08997, 33.967], [-118.08988, 33.96752], [-118.08982, 33.96801], [-118.0896, 33.96863], [-118.08948, 33.9691], [-118.08918, 33.96955], [-118.08829, 33.97064], [-118.0876, 33.97136], [-118.08698, 33.97208], [-118.08584, 33.97349], [-118.08494, 33.9745], [-118.08391, 33.97578], [-118.08352, 33.97618], [-118.08311, 33.97664], [-118.08179, 33.97851], [-118.08046, 33.98048], [-118.0798, 33.98132], [-118.07925, 33.98212], [-118.07851, 33.98314], [-118.07771, 33.98444], [-118.07714, 33.98566], [-118.07692, 33.98619], [-118.07652, 33.98729], [-118.07632, 33.98773], [-118.07609, 33.98832], [-118.07552, 33.98955], [-118.07471, 33.99158], [-118.07426, 33.99266], [-118.07409, 33.99312], [-118.0733, 33.99488], [-118.07307, 33.99554], [-118.07271, 33.99623], [-118.07261, 33.9966], [-118.07235, 33.99713], [-118.07209, 33.99773], [-118.07154, 33.99906], [-118.07147, 33.99927], [-118.07122, 34.00026], [-118.07102, 34.00093], [-118.07088, 34.00162], [-118.07067, 34.00216], [-118.07066, 34.00243], [-118.07047, 34.003], [-118.07038, 34.00362], [-118.07038, 34.00391], [-118.07021, 34.00418], [-118.07016, 34.00445], [-118.06972, 34.00539], [-118.0696, 34.00584], [-118.06946, 34.00622], [-118.06931, 34.00676], [-118.06895, 34.00746], [-118.06867, 34.0079], [-118.06836, 34.00844], [-118.06781, 34.00925], [-118.06706, 34.01014], [-118.0663, 34.01092], [-118.06576, 34.01153], [-118.06514, 34.0121], [-118.06397, 34.01328], [-118.0635, 34.01365], [-118.06319, 34.01393], [-118.0627, 34.01428], [-118.06241, 34.01459], [-118.06179, 34.01516], [-118.06153, 34.01547], [-118.06135, 34.01595], [-118.0611, 34.01647], [-118.06093, 34.01676], [-118.0608, 34.01691], [-118.06067, 34.0168], [-118.0608, 34.01667], [-118.06099, 34.01641], [-118.06113, 34.01606], [-118.06131, 34.01568], [-118.06141, 34.01533], [-118.06165, 34.01503], [-118.06209, 34.01468], [-118.0627, 34.01406], [-118.06301, 34.01386], [-118.06323, 34.01367], [-118.0636, 34.01338], [-118.06526, 34.01165], [-118.06597, 34.01097], [-118.0662, 34.01081], [-118.06654, 34.01041], [-118.06704, 34.00992], [-118.06736, 34.0095], [-118.06769, 34.00911], [-118.06803, 34.00865], [-118.0683, 34.0082], [-118.06902, 34.00694], [-118.06969, 34.00525], [-118.07008, 34.0041], [-118.07019, 34.00376], [-118.07037, 34.00297], [-118.07049, 34.00258], [-118.07055, 34.00223], [-118.07075, 34.00144], [-118.07107, 34.00026], [-118.07125, 33.99976], [-118.07129, 33.99953], [-118.0716, 33.99861], [-118.07188, 33.99802], [-118.07222, 33.99716], [-118.07268, 33.99609], [-118.07298, 33.99531], [-118.07314, 33.99495], [-118.07352, 33.9942], [-118.07374, 33.99365], [-118.07389, 33.99318], [-118.07415, 33.9926], [-118.07467, 33.99119], [-118.07515, 33.99008], [-118.07543, 33.98937], [-118.07636, 33.98721], [-118.07665, 33.98652], [-118.07712, 33.98555], [-118.07738, 33.98482], [-118.07775, 33.98403], [-118.07837, 33.98307], [-118.07881, 33.98249], [-118.07901, 33.98211], [-118.08013, 33.98069], [-118.08051, 33.9801], [-118.08086, 33.97963], [-118.08178, 33.9783], [-118.08222, 33.9777], [-118.0835, 33.97588], [-118.08387, 33.97557], [-118.08439, 33.97496], [-118.08511, 33.97397], [-118.08584, 33.97323], [-118.08694, 33.97187], [-118.08721, 33.97156], [-118.08789, 33.9707], [-118.08833, 33.97033], [-118.08873, 33.96978], [-118.08924, 33.969], [-118.08947, 33.96838], [-118.08962, 33.96776], [-118.0897, 33.96718], [-118.08979, 33.96675], [-118.08963, 33.96575], [-118.08942, 33.96511], [-118.08885, 33.96387], [-118.08854, 33.96352], [-118.08806, 33.96243], [-118.08775, 33.96147], [-118.08775, 33.9605], [-118.08793, 33.95968], [-118.0881, 33.95931], [-118.08873, 33.95825], [-118.08958, 33.95666], [-118.08997, 33.95586], [-118.09069, 33.95491], [-118.09096, 33.95468], [-118.09148, 33.95393], [-118.09189, 33.95354], [-118.09264, 33.95264], [-118.09325, 33.95196], [-118.09431, 33.95085], [-118.09475, 33.95026], [-118.09504, 33.94997], [-118.09593, 33.94898], [-118.09652, 33.94827], [-118.0971, 33.94771], [-118.09741, 33.9473], [-118.0981, 33.94652], [-118.09851, 33.9459], [-118.09877, 33.94553], [-118.099, 33.94518], [-118.09901, 33.94517], [-118.09921, 33.94455], [-118.09952, 33.94326], [-118.09962, 33.94275], [-118.09982, 33.94198], [-118.10008, 33.94104], [-118.10025, 33.94062], [-118.10078, 33.93965], [-118.10101, 33.93934], [-118.10104, 33.93935], [-118.10107, 33.93912], [-118.1013, 33.93878], [-118.10179, 33.93824], [-118.10231, 33.93752], [-118.10291, 33.9369], [-118.10354, 33.93621], [-118.10462, 33.93496], [-118.10507, 33.93439], [-118.10564, 33.9338], [-118.10633, 33.93301], [-118.10685, 33.93224], [-118.10733, 33.93159], [-118.10753, 33.93111], [-118.10774, 33.9305], [-118.10865, 33.92863], [-118.10902, 33.92795], [-118.10902, 33.92793], [-118.10907, 33.92775], [-118.10922, 33.92736], [-118.10952, 33.92684], [-118.11015, 33.92552], [-118.11042, 33.92497], [-118.11058, 33.92448], [-118.11093, 33.92389], [-118.11116, 33.92327], [-118.11138, 33.92283], [-118.11158, 33.92211], [-118.11163, 33.92147], [-118.11174, 33.9208], [-118.11172, 33.92027], [-118.11165, 33.91966], [-118.11163, 33.91881], [-118.11154, 33.91766], [-118.11152, 33.91708], [-118.11151, 33.91632], [-118.11128, 33.91439], [-118.11111, 33.91334], [-118.11084, 33.91257], [-118.1106, 33.91174], [-118.11012, 33.91058], [-118.10995, 33.90989], [-118.10948, 33.90865], [-118.1091, 33.90752], [-118.10902, 33.90695], [-118.10887, 33.90639], [-118.10878, 33.90541], [-118.10875, 33.90384], [-118.10882, 33.9029], [-118.1088, 33.90236], [-118.10873, 33.90169], [-118.1087, 33.90098], [-118.10872, 33.89992], [-118.10871, 33.89818], [-118.10867, 33.89737], [-118.10866, 33.89624], [-118.10865, 33.89471], [-118.10868, 33.89372], [-118.1086, 33.89303], [-118.1086, 33.89125], [-118.10855, 33.8899], [-118.10855, 33.8891], [-118.10851, 33.88793], [-118.10853, 33.88792], [-118.10854, 33.88722], [-118.10852, 33.88668], [-118.10855, 33.88609], [-118.10852, 33.88552], [-118.10853, 33.8851], [-118.10851, 33.88463], [-118.10852, 33.88325], [-118.10849, 33.88214], [-118.10851, 33.88166], [-118.10846, 33.88005], [-118.10839, 33.87947], [-118.10823, 33.87873], [-118.10798, 33.87781], [-118.10794, 33.8775], [-118.10786, 33.87706], [-118.10778, 33.87685], [-118.10757, 33.87602], [-118.10746, 33.87551], [-118.10723, 33.87475], [-118.1069, 33.87356], [-118.10663, 33.87256], [-118.10639, 33.87174], [-118.10579, 33.8694], [-118.10474, 33.86573], [-118.10475, 33.86572], [-118.10456, 33.86493], [-118.104, 33.86272], [-118.10277, 33.8584], [-118.10251, 33.85716], [-118.10152, 33.85364], [-118.10041, 33.84941], [-118.10022, 33.84877], [-118.09958, 33.8471], [-118.09906, 33.84599], [-118.09835, 33.84487], [-118.09746, 33.8433], [-118.0968, 33.84209], [-118.09614, 33.84093], [-118.09572, 33.84012], [-118.09546, 33.83946], [-118.09512, 33.8387], [-118.09432, 33.83671], [-118.09408, 33.83598], [-118.09389, 33.83528], [-118.09373, 33.83441], [-118.09355, 33.83343], [-118.09332, 33.83196], [-118.09313, 33.83084], [-118.09279, 33.82844], [-118.09251, 33.82674], [-118.09207, 33.82368], [-118.09143, 33.81899], [-118.09134, 33.81863], [-118.0913, 33.81799], [-118.0912, 33.81723], [-118.09101, 33.81449], [-118.091, 33.81362], [-118.09097, 33.81305], [-118.0909, 33.8106], [-118.09079, 33.80959], [-118.09057, 33.80436], [-118.09054, 33.80303], [-118.09042, 33.80198], [-118.09024, 33.7987], [-118.09022, 33.79805], [-118.09015, 33.79648], [-118.09019, 33.7955], [-118.09024, 33.79518], [-118.0904, 33.79456], [-118.09065, 33.79381], [-118.09181, 33.79143], [-118.09208, 33.79098], [-118.09273, 33.78978], [-118.0941, 33.78691], [-118.09415, 33.78693], [-118.09426, 33.7866], [-118.09459, 33.78591], [-118.09488, 33.78539], [-118.09572, 33.7835], [-118.09606, 33.7828], [-118.09642, 33.78224], [-118.09699, 33.78087], [-118.09729, 33.78039], [-118.09746, 33.77997], [-118.09769, 33.77955], [-118.09797, 33.77848], [-118.09802, 33.7779], [-118.09801, 33.77769], [-118.09807, 33.77694], [-118.09805, 33.77661], [-118.09808, 33.7763], [-118.09809, 33.77611], [-118.09805, 33.77579], [-118.09807, 33.77496], [-118.09813, 33.77457], [-118.09807, 33.77406], [-118.09814, 33.77374], [-118.09815, 33.77353], [-118.09822, 33.77312], [-118.09825, 33.77207], [-118.09822, 33.77099], [-118.09826, 33.77015], [-118.09823, 33.76935], [-118.09826, 33.76888], [-118.09824, 33.76801], [-118.09828, 33.76735], [-118.09826, 33.76646], [-118.09829, 33.76368], [-118.09827, 33.76247], [-118.09829, 33.76165], [-118.09832, 33.76107], [-118.0984, 33.76069], [-118.09852, 33.76021], [-118.09862, 33.75986], [-118.09878, 33.75948], [-118.09893, 33.75948], [-118.09881, 33.7597], [-118.09863, 33.76009], [-118.09851, 33.76065], [-118.09844, 33.76129], [-118.0984, 33.76198], [-118.09833, 33.76418], [-118.09835, 33.76521], [-118.09832, 33.76597], [-118.09835, 33.76748], [-118.0983, 33.76963], [-118.09832, 33.77024], [-118.0983, 33.77106], [-118.09833, 33.77283], [-118.09831, 33.7732], [-118.09825, 33.77371], [-118.09825, 33.77395], [-118.09828, 33.77423], [-118.09827, 33.77469], [-118.09818, 33.77524], [-118.09817, 33.7769], [-118.09818, 33.7781], [-118.09814, 33.77848], [-118.09804, 33.77884], [-118.098, 33.77911], [-118.09772, 33.77984], [-118.09758, 33.7801], [-118.09731, 33.78075], [-118.09704, 33.78135], [-118.09675, 33.78186], [-118.09576, 33.78393], [-118.09508, 33.78547], [-118.09446, 33.78663], [-118.09438, 33.78714], [-118.09402, 33.78763], [-118.09356, 33.78864], [-118.09351, 33.78866], [-118.09333, 33.78902], [-118.09318, 33.78927], [-118.09281, 33.79009], [-118.09186, 33.79202], [-118.09151, 33.79271], [-118.09113, 33.79348], [-118.09092, 33.79387], [-118.09044, 33.79512], [-118.09042, 33.79527], [-118.09039, 33.79561], [-118.09035, 33.79592], [-118.09074, 33.80355], [-118.09091, 33.80678], [-118.09119, 33.81024], [-118.09109, 33.81079], [-118.09106, 33.8113], [-118.09107, 33.81199], [-118.09113, 33.81301], [-118.09116, 33.81418], [-118.09135, 33.81736], [-118.0914, 33.81782], [-118.09151, 33.81852], [-118.09159, 33.81899], [-118.09162, 33.819], [-118.09222, 33.82339], [-118.09307, 33.82926], [-118.09357, 33.83202], [-118.09366, 33.83283], [-118.09366, 33.8329], [-118.09382, 33.83404], [-118.09393, 33.83464], [-118.09412, 33.83543], [-118.09436, 33.83621], [-118.09466, 33.83699], [-118.09578, 33.83971], [-118.09626, 33.84073], [-118.09725, 33.84253], [-118.09776, 33.84349], [-118.09804, 33.84382], [-118.09946, 33.84633], [-118.09971, 33.84684], [-118.09994, 33.84738], [-118.10017, 33.84795], [-118.10034, 33.84843], [-118.10057, 33.84919], [-118.10266, 33.85689], [-118.10301, 33.85821], [-118.10312, 33.85892], [-118.10393, 33.8619], [-118.10454, 33.86404], [-118.10486, 33.86521], [-118.10494, 33.86568], [-118.10489, 33.86571], [-118.10496, 33.86571], [-118.10529, 33.8671], [-118.10555, 33.86805], [-118.10611, 33.86994], [-118.10646, 33.87134], [-118.10667, 33.87199], [-118.10707, 33.87348], [-118.10749, 33.87484], [-118.10776, 33.87584], [-118.10801, 33.87694], [-118.1082, 33.87764], [-118.1084, 33.87859], [-118.10854, 33.87918], [-118.10864, 33.87979], [-118.10866, 33.88017], [-118.10867, 33.88675], [-118.10871, 33.88799], [-118.10874, 33.89197], [-118.1088, 33.89366], [-118.10879, 33.89486], [-118.10874, 33.89587], [-118.1088, 33.8977], [-118.10885, 33.90208], [-118.1089, 33.90243], [-118.10885, 33.90308], [-118.10891, 33.90538], [-118.10896, 33.9062], [-118.10927, 33.90754], [-118.10954, 33.90844], [-118.10998, 33.9094], [-118.11019, 33.91003], [-118.11071, 33.91122], [-118.11096, 33.91216], [-118.11123, 33.91292], [-118.11145, 33.91335]]], [[[-118.06064, 34.01704], [-118.06034, 34.0173], [-118.05995, 34.01767], [-118.05967, 34.01775], [-118.06008, 34.01736], [-118.06039, 34.01702], [-118.06059, 34.01691], [-118.06064, 34.01704]]], [[[-118.05718, 34.0202], [-118.05659, 34.0208], [-118.05647, 34.02082], [-118.05624, 34.02078], [-118.05599, 34.02104], [-118.05596, 34.02124], [-118.05637, 34.02164], [-118.05628, 34.02168], [-118.05609, 34.02156], [-118.05585, 34.02136], [-118.05583, 34.0211], [-118.05607, 34.02078], [-118.05619, 34.02066], [-118.05645, 34.02071], [-118.05669, 34.02039], [-118.05703, 34.01998], [-118.05718, 34.0202]]], [[[-118.0539, 34.02414], [-118.05363, 34.02458], [-118.05288, 34.02562], [-118.05262, 34.02605], [-118.05234, 34.02643], [-118.0518, 34.02731], [-118.05126, 34.02796], [-118.05091, 34.02813], [-118.05152, 34.02738], [-118.05216, 34.02646], [-118.05316, 34.02491], [-118.05363, 34.02431], [-118.05385, 34.02384], [-118.0539, 34.02414]]], [[[-117.99167, 34.09319], [-117.99071, 34.09454], [-117.99031, 34.09439], [-117.99042, 34.09422], [-117.99113, 34.09362], [-117.99167, 34.09319]]], [[[-117.97634, 34.10744], [-117.97608, 34.10761], [-117.97604, 34.10758], [-117.97623, 34.1074], [-117.97634, 34.10744]]], [[[-118.03841, 34.03443], [-118.0324, 34.03706], [-118.03018, 34.03805], [-118.02831, 34.03884], [-118.02725, 34.03933], [-118.02466, 34.04038], [-118.02313, 34.04115], [-118.01905, 34.04296], [-118.01815, 34.04339], [-118.01733, 34.04382], [-118.01651, 34.04431], [-118.01579, 34.04478], [-118.01522, 34.0452], [-118.0144, 34.0459], [-118.01379, 34.04646], [-118.01334, 34.04692], [-118.0127, 34.04762], [-118.01229, 34.0481], [-118.01185, 34.04865], [-118.01143, 34.04923], [-118.01104, 34.0498], [-118.01067, 34.0504], [-118.01041, 34.05085], [-118.01011, 34.05143], [-118.00984, 34.05201], [-118.00961, 34.05255], [-118.00918, 34.05364], [-118.00877, 34.05498], [-118.00841, 34.05642], [-118.00853, 34.05676], [-118.00828, 34.05662], [-118.00826, 34.05674], [-118.00809, 34.05698], [-118.00816, 34.05703], [-118.008, 34.05721], [-118.00785, 34.05767], [-118.0078, 34.05766], [-118.00756, 34.05839], [-118.00726, 34.05917], [-118.00702, 34.05986], [-118.00691, 34.06003], [-118.00677, 34.06047], [-118.00656, 34.06097], [-118.00577, 34.06334], [-118.00573, 34.06372], [-118.00563, 34.0639], [-118.00555, 34.06409], [-118.00447, 34.0672], [-118.00342, 34.07028], [-118.00244, 34.07336], [-118.00212, 34.07414], [-118.00162, 34.07595], [-118.00138, 34.0775], [-118.0011, 34.07988], [-118.00077, 34.08225], [-118.00048, 34.08333], [-117.99952, 34.08611], [-117.99883, 34.08743], [-117.99849, 34.08795], [-117.9978, 34.08896], [-117.99715, 34.08987], [-117.99624, 34.09098], [-117.99515, 34.09219], [-117.99433, 34.09301], [-117.99251, 34.09463], [-117.98862, 34.09757], [-117.98778, 34.09826], [-117.98357, 34.10155], [-117.98094, 34.10352], [-117.97911, 34.10501], [-117.97674, 34.10689], [-117.97486, 34.10858], [-117.97242, 34.11067], [-117.96989, 34.11265], [-117.96979, 34.11257], [-117.9713, 34.11147], [-117.9751, 34.10817], [-117.98058, 34.10365], [-117.98343, 34.10148], [-117.99237, 34.09448], [-117.99415, 34.09298], [-117.9948, 34.09232], [-117.99554, 34.09137], [-117.99694, 34.08992], [-117.99791, 34.0884], [-117.99841, 34.08769], [-117.99965, 34.08523], [-118.00005, 34.0841], [-118.00045, 34.08271], [-118.00091, 34.08013], [-118.00095, 34.07947], [-118.00119, 34.07765], [-118.00121, 34.07686], [-118.00158, 34.07548], [-118.00219, 34.07355], [-118.00345, 34.06993], [-118.00448, 34.06686], [-118.00525, 34.06466], [-118.00541, 34.06411], [-118.00558, 34.06375], [-118.00575, 34.06306], [-118.00589, 34.06267], [-118.00634, 34.06144], [-118.00668, 34.06039], [-118.00733, 34.05852], [-118.00749, 34.05786], [-118.00764, 34.05739], [-118.00781, 34.05704], [-118.00785, 34.05682], [-118.00783, 34.0568], [-118.00796, 34.0567], [-118.0091, 34.05338], [-118.00931, 34.05269], [-118.00957, 34.05196], [-118.00978, 34.0514], [-118.00996, 34.051], [-118.01037, 34.05026], [-118.01047, 34.05005], [-118.01064, 34.0498], [-118.01078, 34.04953], [-118.01129, 34.04876], [-118.01166, 34.04831], [-118.01188, 34.048], [-118.01226, 34.0476], [-118.01275, 34.04704], [-118.01285, 34.04696], [-118.01339, 34.04634], [-118.01411, 34.04568], [-118.01481, 34.04516], [-118.01533, 34.04473], [-118.01622, 34.04415], [-118.0179, 34.0432], [-118.01874, 34.0428], [-118.01978, 34.04237], [-118.02122, 34.0417], [-118.02386, 34.04053], [-118.02709, 34.03914], [-118.02842, 34.03864], [-118.02972, 34.03804], [-118.03838, 34.03431], [-118.03841, 34.03443]]], [[[-117.94882, 34.13119], [-117.94815, 34.13196], [-117.94725, 34.13264], [-117.94681, 34.1329], [-117.94647, 34.1332], [-117.9457, 34.13373], [-117.94468, 34.13451], [-117.94405, 34.13496], [-117.94331, 34.13575], [-117.94298, 34.13616], [-117.94252, 34.13659], [-117.94216, 34.13687], [-117.94166, 34.13724], [-117.93952, 34.13805], [-117.93877, 34.13838], [-117.93806, 34.13866], [-117.9376, 34.13889], [-117.93713, 34.13919], [-117.93675, 34.13949], [-117.9365, 34.13973], [-117.93611, 34.14015], [-117.93558, 34.14081], [-117.93523, 34.1412], [-117.93496, 34.1416], [-117.93456, 34.142], [-117.93419, 34.14229], [-117.93352, 34.14267], [-117.93293, 34.14296], [-117.93156, 34.14375], [-117.93119, 34.14388], [-117.93077, 34.14418], [-117.92998, 34.14464], [-117.93036, 34.14423], [-117.93092, 34.14395], [-117.93147, 34.14365], [-117.93206, 34.14328], [-117.93258, 34.143], [-117.93314, 34.14262], [-117.93373, 34.14233], [-117.93422, 34.14202], [-117.93448, 34.14176], [-117.93508, 34.1411], [-117.93592, 34.14006], [-117.93682, 34.13925], [-117.93747, 34.13882], [-117.93794, 34.13857], [-117.9386, 34.1383], [-117.93932, 34.138], [-117.94031, 34.13764], [-117.94117, 34.1373], [-117.94137, 34.1372], [-117.9421, 34.13679], [-117.94235, 34.13659], [-117.94279, 34.13606], [-117.94341, 34.13538], [-117.94402, 34.13482], [-117.94567, 34.13364], [-117.94765, 34.13216], [-117.94805, 34.1319], [-117.94844, 34.13138], [-117.94872, 34.13114], [-117.94882, 34.13119]]], [[[-117.92065, 34.15278], [-117.92025, 34.15317], [-117.91981, 34.15357], [-117.91921, 34.15419], [-117.91761, 34.15578], [-117.91702, 34.15626], [-117.91596, 34.15701], [-117.91538, 34.15736], [-117.91429, 34.15813], [-117.91293, 34.15896], [-117.91355, 34.15845], [-117.91457, 34.1578], [-117.91504, 34.15742], [-117.91566, 34.15706], [-117.91611, 34.15677], [-117.91675, 34.15628], [-117.91731, 34.15589], [-117.91839, 34.15479], [-117.91917, 34.15404], [-117.91943, 34.15376], [-117.9197, 34.1535], [-117.92065, 34.15278]]], [[[-117.91021, 34.15971], [-117.91019, 34.15985], [-117.90895, 34.16001], [-117.90814, 34.15997], [-117.90749, 34.15987], [-117.9079, 34.15985], [-117.90861, 34.15989], [-117.90949, 34.15984], [-117.91021, 34.15971]]]]} | Open Access 1 | 12123 | San Gabriel River and Bike Trail | 24899 | 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 | 198.354 | San Gabriel River and Bike Trail | 0 | Local Recreation Area 3 | 4 | |
| 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 | |
| 2616 | 2616 | 2615 | {"type": "Polygon", "coordinates": [[[-119.80757, 34.42522], [-119.80482, 34.42554], [-119.80483, 34.42523], [-119.80248, 34.4255], [-119.80248, 34.42446], [-119.8037, 34.42461], [-119.80398, 34.42462], [-119.80426, 34.4246], [-119.80465, 34.42455], [-119.80523, 34.4244], [-119.80659, 34.42394], [-119.80746, 34.4237], [-119.80757, 34.42522]]]} | Open Access 1 | 17994 | More Mesa Open Space | 22474 | 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 | 13.532 | More Mesa OS | 0 | Local Recreation Area 3 | 4 | |
| 3152 | 3152 | 3151 | {"type": "MultiPolygon", "coordinates": [[[[-121.45548, 38.6727], [-121.45533, 38.67278], [-121.45527, 38.67304], [-121.45223, 38.67302], [-121.45222, 38.6748], [-121.44819, 38.67476], [-121.44761, 38.67528], [-121.44761, 38.67116], [-121.45222, 38.6712], [-121.45224, 38.67009], [-121.45374, 38.6701], [-121.45404, 38.67046], [-121.45426, 38.67077], [-121.45548, 38.6727]]], [[[-121.4527, 38.66887], [-121.45205, 38.66885], [-121.45167, 38.66839], [-121.4523, 38.6684], [-121.4527, 38.66887]]], [[[-121.45421, 38.68026], [-121.45328, 38.68025], [-121.45232, 38.68024], [-121.45258, 38.67949], [-121.4542, 38.6795], [-121.45421, 38.68026]]], [[[-121.45675, 38.66942], [-121.45676, 38.67323], [-121.45675, 38.67323], [-121.45617, 38.67309], [-121.45582, 38.67284], [-121.4544, 38.67061], [-121.45416, 38.6703], [-121.45341, 38.6694], [-121.45675, 38.66942]]], [[[-121.45675, 38.6734], [-121.45675, 38.6734], [-121.45675, 38.67432], [-121.45607, 38.67324], [-121.45675, 38.6734]]]]} | Open Access 1 | 21711 | Dry Creek Parkway | 18283 | 2128 | Sacramento Area Flood Control Agency 590 | Special District 4 | Flood District 8 | http://www.safca.org/ | Special District 4 | 2128 | Sacramento Area Flood Control Agency 580 | Special District 4 | Flood District 9 | Sacramento 41 | 79.517 | Dry Creek Parkway | 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 | ||
| 3770 | 3770 | 3769 | {"type": "Polygon", "coordinates": [[[-121.40978, 39.0321], [-121.40886, 39.03318], [-121.40825, 39.0338], [-121.40801, 39.03396], [-121.40738, 39.03562], [-121.40691, 39.03607], [-121.40665, 39.03623], [-121.40644, 39.03625], [-121.40543, 39.03614], [-121.40505, 39.03582], [-121.40453, 39.0351], [-121.40393, 39.0349], [-121.40344, 39.03488], [-121.40287, 39.03514], [-121.4026, 39.03562], [-121.40242, 39.03625], [-121.40184, 39.0353], [-121.40342, 39.03459], [-121.40368, 39.03458], [-121.40502, 39.03496], [-121.40768, 39.03386], [-121.40806, 39.03357], [-121.40923, 39.03229], [-121.40961, 39.0318], [-121.40978, 39.0321]]]} | Unknown Access 4 | 472 | Dry Creek | 18279 | 2127 | Sacramento and San Joaquin Drainage District 681 | Special District 4 | Flood District 8 | Special District 4 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Yuba 25 | 15.587 | Dry Creek | 0 | Local Other or Unknown 14 | 4 | ||
| 4015 | 4015 | 4014 | {"type": "Polygon", "coordinates": [[[-119.77525, 34.46378], [-119.77515, 34.46411], [-119.77508, 34.46424], [-119.77513, 34.46436], [-119.77498, 34.46477], [-119.77422, 34.46477], [-119.77427, 34.4643], [-119.77438, 34.46379], [-119.77525, 34.46378]]]} | Open Access 1 | 1439 | Tuckers Grove Park | 26559 | 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 | 2.064 | Tuckers Grove Park | 0 | Local Park 2 | 4 | |
| 4312 | 4312 | 4311 | {"type": "Polygon", "coordinates": [[[-119.82186, 36.82104], [-119.82186, 36.82267], [-119.82071, 36.82268], [-119.82071, 36.82239], [-119.81997, 36.82167], [-119.81992, 36.8217], [-119.81966, 36.8217], [-119.81966, 36.82097], [-119.82, 36.82096], [-119.82001, 36.82105], [-119.82186, 36.82104]]]} | Open Access 1 | 47276 | Basin I Park | 30984 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 6.944 | Basin I Park | 0 | Local Park 2 | 4 |
| 4548 | 4548 | 4547 | {"type": "Polygon", "coordinates": [[[-121.79158, 37.67939], [-121.79158, 37.67946], [-121.79149, 37.67979], [-121.79049, 37.6798], [-121.78952, 37.6799], [-121.78852, 37.67912], [-121.78813, 37.67868], [-121.78776, 37.6781], [-121.78856, 37.67806], [-121.78921, 37.67793], [-121.78982, 37.67789], [-121.79032, 37.67778], [-121.79055, 37.67842], [-121.79149, 37.67827], [-121.79153, 37.67865], [-121.79159, 37.67899], [-121.79158, 37.67939]]]} | Open Access 1 | 22291 | Unnamed site - Alameda County Flood Control and Water Conservation District | 28716 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2000 | Alameda County Flood Control and Water Conservation District 752 | Special District 4 | Flood District 9 | Alameda 17 | 13.147 | 0 | Local Other or Unknown 14 | 4 | ||
| 4557 | 4557 | 4556 | {"type": "Polygon", "coordinates": [[[-120.47548, 34.63445], [-120.47542, 34.63898], [-120.47512, 34.63897], [-120.47516, 34.63502], [-120.47511, 34.63485], [-120.475, 34.63471], [-120.47493, 34.63465], [-120.47476, 34.63455], [-120.47466, 34.63452], [-120.4744, 34.6345], [-120.4744, 34.63445], [-120.47548, 34.63445]]]} | Open Access 1 | 35173 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28688 | 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.795 | 0 | Local Other or Unknown 14 | 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]);