units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where ACCESS_TYP = 3, AGNCY_TYP = 8 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_WEB, COUNTY, LABEL_NAME
DES_TP 6
- Local Other or Unknown 17
- Local Recreation Area 2
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 5
MNG_AG_TYP 1
ACCESS_TYP 1
- No Public Access · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | ||
12718 | 12718 | 12717 | {"type": "Polygon", "coordinates": [[[-121.59372, 38.74945], [-121.59374, 38.74956], [-121.5937, 38.74972], [-121.59337, 38.75048], [-121.59196, 38.75395], [-121.59179, 38.7545], [-121.59167, 38.75505], [-121.59145, 38.75654], [-121.57989, 38.75672], [-121.57986, 38.75654], [-121.57698, 38.75393], [-121.57695, 38.74977], [-121.58419, 38.7496], [-121.58418, 38.75113], [-121.58333, 38.75114], [-121.58331, 38.75313], [-121.58574, 38.75314], [-121.58577, 38.74956], [-121.59366, 38.74939], [-121.59372, 38.74945]]]} | No Public Access 3 | 29734 | Huffman West | 20139 | 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 | 232.676 | Huffman West | 0 | None 1114 | ||
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 | |
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 | |
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 |
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]);