units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
58 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 9 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13182 | 13182 | 13181 | {"type": "Polygon", "coordinates": [[[-121.58503, 38.74523], [-121.58494, 38.74669], [-121.58484, 38.74681], [-121.58168, 38.74774], [-121.58154, 38.74783], [-121.58087, 38.74943], [-121.57695, 38.74952], [-121.57692, 38.74306], [-121.57717, 38.7431], [-121.57789, 38.74347], [-121.57806, 38.7435], [-121.58271, 38.74346], [-121.5831, 38.74338], [-121.58331, 38.74329], [-121.58335, 38.74324], [-121.58488, 38.74496], [-121.58503, 38.74523]]]} | No Public Access 3 | 35165 | Vestal | 27009 | 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 | 93.79 | Vestal | None 1147 | |||
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 | ||
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 | ||
15480 | 15480 | 15479 | {"type": "Polygon", "coordinates": [[[-120.41207, 34.8736], [-120.41185, 34.87358], [-120.41131, 34.87341], [-120.41098, 34.87337], [-120.41098, 34.87234], [-120.41206, 34.87233], [-120.41207, 34.8736]]]} | No Public Access 3 | 43077 | 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.135 | 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 | ||
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 | |
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 | |||
12720 | 12720 | 12719 | {"type": "Polygon", "coordinates": [[[-121.58519, 38.73806], [-121.5843, 38.74056], [-121.58366, 38.74229], [-121.58355, 38.74272], [-121.58352, 38.74306], [-121.58331, 38.74329], [-121.5831, 38.74338], [-121.58271, 38.74346], [-121.57806, 38.7435], [-121.57789, 38.74347], [-121.57717, 38.7431], [-121.57692, 38.74306], [-121.5769, 38.73805], [-121.58519, 38.73806]]]} | No Public Access 3 | 29736 | Ruby Ranch | 24724 | 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 | 93.99 | Ruby Ranch | 0 | Local Other or Unknown 14 | 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 | |
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 | |||
13122 | 13122 | 13121 | {"type": "MultiPolygon", "coordinates": [[[[-117.03119, 34.04474], [-117.02356, 34.04478], [-117.02356, 34.04447], [-117.02423, 34.04422], [-117.02454, 34.04413], [-117.02494, 34.04411], [-117.02527, 34.04421], [-117.02606, 34.04436], [-117.0261, 34.04433], [-117.0267, 34.04453], [-117.02707, 34.04453], [-117.0274, 34.04442], [-117.02786, 34.04413], [-117.02832, 34.04395], [-117.02955, 34.04374], [-117.03011, 34.04361], [-117.03012, 34.04364], [-117.03032, 34.04365], [-117.03064, 34.04371], [-117.03065, 34.04368], [-117.03119, 34.04367], [-117.03119, 34.04474]]], [[[-117.03337, 34.04484], [-117.03337, 34.04549], [-117.03215, 34.04542], [-117.03107, 34.04503], [-117.02836, 34.046], [-117.02836, 34.04623], [-117.02793, 34.04629], [-117.02793, 34.0466], [-117.0258, 34.04661], [-117.0258, 34.04488], [-117.03337, 34.04484]]], [[[-117.02567, 34.04661], [-117.02268, 34.04662], [-117.02267, 34.04664], [-117.02245, 34.04664], [-117.02245, 34.0449], [-117.02567, 34.04488], [-117.02567, 34.04661]]]]} | No Public Access 3 | 35037 | Oak Glen Creek Detention Basin | 22966 | 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 | 45.377 | Oak Glen Creek Detention Basin | 0 | None 1139 | ||
12714 | 12714 | 12713 | {"type": "MultiPolygon", "coordinates": [[[[-121.56761, 38.79009], [-121.55865, 38.79021], [-121.55838, 38.7897], [-121.55831, 38.78945], [-121.55828, 38.78913], [-121.5583, 38.78872], [-121.55898, 38.78631], [-121.55907, 38.78572], [-121.559, 38.78306], [-121.5628, 38.78305], [-121.56282, 38.78417], [-121.56754, 38.78412], [-121.56761, 38.79009]]], [[[-121.5769, 38.7889], [-121.5769, 38.79001], [-121.5678, 38.79009], [-121.56773, 38.78412], [-121.57225, 38.78407], [-121.57227, 38.7866], [-121.57639, 38.78658], [-121.57654, 38.78666], [-121.57683, 38.78666], [-121.57683, 38.78685], [-121.5765, 38.78685], [-121.57631, 38.78675], [-121.57514, 38.78676], [-121.57513, 38.7889], [-121.57514, 38.78891], [-121.5769, 38.7889]]]]} | No Public Access 3 | 29726 | Nestor | 22702 | 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 | 229.848 | Nestor | None 1110 | |||
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 | |||
13169 | 13169 | 13168 | {"type": "Polygon", "coordinates": [[[-121.52167, 38.73375], [-121.5121, 38.73375], [-121.51206, 38.72883], [-121.52163, 38.72882], [-121.52167, 38.73375]]]} | No Public Access 3 | 35140 | 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 | 112.326 | Natomas Basin Conservancy | None 1143 | |||
8353 | 8353 | 8352 | {"type": "Polygon", "coordinates": [[[-117.30775, 34.06867], [-117.30766, 34.06901], [-117.30769, 34.06982], [-117.30768, 34.07016], [-117.30758, 34.07063], [-117.30747, 34.07094], [-117.3073, 34.07133], [-117.30711, 34.07166], [-117.30698, 34.07184], [-117.30659, 34.07226], [-117.30613, 34.07269], [-117.30491, 34.07389], [-117.3049, 34.07457], [-117.30531, 34.07488], [-117.30526, 34.07493], [-117.3048, 34.07525], [-117.30449, 34.07581], [-117.3042, 34.07624], [-117.30421, 34.07678], [-117.3039, 34.07712], [-117.30332, 34.07721], [-117.30308, 34.07734], [-117.30273, 34.07744], [-117.30258, 34.07757], [-117.30151, 34.07756], [-117.30119, 34.07793], [-117.30111, 34.07804], [-117.30081, 34.07893], [-117.30044, 34.07934], [-117.30036, 34.07934], [-117.2989, 34.0811], [-117.29768, 34.07934], [-117.29728, 34.07871], [-117.29742, 34.07871], [-117.29748, 34.07809], [-117.29775, 34.07788], [-117.3005, 34.07406], [-117.30051, 34.07392], [-117.30064, 34.07392], [-117.30065, 34.07123], [-117.30052, 34.07122], [-117.30052, 34.0704], [-117.30255, 34.0704], [-117.30257, 34.06864], [-117.30775, 34.06867]]]} | No Public Access 3 | 12938 | Lytle-Cajon Channel/Warm Creek Confluence | 21616 | 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 | 143.889 | Lytle-Cajon Channel/Warm Creek Confluence | 0 | None 697 | ||
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 | |||
12719 | 12719 | 12718 | {"type": "Polygon", "coordinates": [[[-121.57188, 38.7717], [-121.56259, 38.77184], [-121.56254, 38.76466], [-121.56254, 38.76083], [-121.56867, 38.76072], [-121.5687, 38.76451], [-121.57185, 38.76444], [-121.57188, 38.7717]]]} | No Public Access 3 | 29735 | Lucich Ranch | 21580 | 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 | 215.926 | Lucich Ranch | 0 | Local Other or Unknown 14 | 4 | |
13175 | 13175 | 13174 | {"type": "Polygon", "coordinates": [[[-121.57686, 38.77162], [-121.57188, 38.7717], [-121.57185, 38.76445], [-121.5687, 38.76451], [-121.56867, 38.76072], [-121.57182, 38.76066], [-121.57184, 38.76246], [-121.57684, 38.76237], [-121.57686, 38.77162]]]} | No Public Access 3 | 35159 | Lucich Ranch | 21580 | 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 | 138.582 | Lucich Ranch | 0 | Local Other or Unknown 14 | 4 | |
12713 | 12713 | 12712 | {"type": "Polygon", "coordinates": [[[-121.5792, 38.79911], [-121.57248, 38.80318], [-121.56408, 38.80822], [-121.56355, 38.80823], [-121.55976, 38.81045], [-121.5595, 38.80998], [-121.55948, 38.80977], [-121.55947, 38.80965], [-121.55888, 38.80918], [-121.55872, 38.80892], [-121.55869, 38.80876], [-121.5588, 38.8086], [-121.55929, 38.80831], [-121.55957, 38.80806], [-121.56043, 38.80555], [-121.56042, 38.80542], [-121.56024, 38.80506], [-121.55948, 38.80369], [-121.55935, 38.80338], [-121.55935, 38.80321], [-121.55964, 38.80302], [-121.56279, 38.802], [-121.56309, 38.80189], [-121.56556, 38.80015], [-121.56849, 38.79901], [-121.56869, 38.79887], [-121.56881, 38.79871], [-121.56961, 38.79649], [-121.57279, 38.79732], [-121.5738, 38.79791], [-121.57594, 38.7985], [-121.57902, 38.79894], [-121.5792, 38.79911]]]} | No Public Access 3 | 29724 | Lucich North | 21579 | 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 | 259.302 | Lucich North | None 1109 | |||
16176 | 16176 | 16175 | {"type": "Polygon", "coordinates": [[[-118.02569, 34.09575], [-118.02561, 34.09631], [-118.0254, 34.0964], [-118.02208, 34.09808], [-118.02179, 34.09823], [-118.0218, 34.09825], [-118.02158, 34.09831], [-118.02096, 34.09882], [-118.02033, 34.0991], [-118.01846, 34.10006], [-118.01705, 34.10123], [-118.01607, 34.10226], [-118.01593, 34.10244], [-118.01581, 34.10265], [-118.01572, 34.10293], [-118.01569, 34.1031], [-118.01568, 34.1033], [-118.01569, 34.10344], [-118.01573, 34.10351], [-118.01587, 34.10418], [-118.01498, 34.10449], [-118.01309, 34.10512], [-118.01166, 34.10633], [-118.00712, 34.10626], [-118.00748, 34.10553], [-118.00754, 34.10551], [-118.00771, 34.10517], [-118.009, 34.10473], [-118.01107, 34.10048], [-118.01157, 34.10064], [-118.01175, 34.10074], [-118.01186, 34.10077], [-118.01189, 34.10083], [-118.01193, 34.10108], [-118.01201, 34.1012], [-118.01216, 34.10128], [-118.01232, 34.10131], [-118.01245, 34.1014], [-118.01249, 34.1015], [-118.01263, 34.10171], [-118.01281, 34.10171], [-118.01293, 34.10166], [-118.01317, 34.10165], [-118.01335, 34.10167], [-118.01359, 34.10176], [-118.01382, 34.10181], [-118.01404, 34.10192], [-118.01426, 34.10188], [-118.01451, 34.10145], [-118.0146, 34.10103], [-118.01469, 34.10074], [-118.01459, 34.10065], [-118.01441, 34.1004], [-118.0142, 34.10023], [-118.01418, 34.10009], [-118.01404, 34.09992], [-118.01387, 34.09979], [-118.01388, 34.09971], [-118.01385, 34.0997], [-118.01378, 34.09965], [-118.01376, 34.09954], [-118.01382, 34.09936], [-118.01377, 34.09909], [-118.0136, 34.09887], [-118.01357, 34.09879], [-118.01362, 34.0986], [-118.01381, 34.09841], [-118.01431, 34.09815], [-118.01466, 34.09789], [-118.01612, 34.09729], [-118.01658, 34.09718], [-118.01761, 34.0972], [-118.01891, 34.09694], [-118.01911, 34.09701], [-118.01959, 34.0969], [-118.0198, 34.09688], [-118.02015, 34.09689], [-118.02013, 34.09658], [-118.02021, 34.09675], [-118.02082, 34.09668], [-118.02534, 34.09589], [-118.02569, 34.09575]]]} | No Public Access 3 | 48171 | Los Angeles County Flood Control District Open Space | 32704 | 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 | 143.431 | Los Angeles County Flood Control District OS | 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]);