units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
108 rows where MNG_AG_TYP = 9 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
DES_TP >30
MNG_AGENCY 8
- Fresno Metropolitan Flood Control District 29
- Los Angeles County Flood Control District 20
- Santa Barbara Flood Control and Water Conserv. District 17
- Natomas Basin Conservancy 14
- San Bernardino County Flood Control District 4
- Sacramento and San Joaquin Drainage District 2
- Sacramento Area Flood Control Agency 1
- Alameda County Flood Control and Water Conservation District 1
AGNCY_WEB 7 ✖
ACCESS_TYP 4
MNG_AG_TYP 1
- Flood District · 88 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16208 | 16208 | 16207 | {"type": "MultiPolygon", "coordinates": [[[[-117.18202, 34.09897], [-117.17363, 34.09895], [-117.17367, 34.10604], [-117.15671, 34.10581], [-117.1567, 34.10592], [-117.13909, 34.10642], [-117.13902, 34.10636], [-117.13901, 34.10642], [-117.12997, 34.1063], [-117.12728, 34.10623], [-117.12701, 34.10594], [-117.12678, 34.10571], [-117.12652, 34.1055], [-117.12624, 34.1053], [-117.1259, 34.10509], [-117.12558, 34.10494], [-117.12529, 34.10481], [-117.12496, 34.10469], [-117.12434, 34.10453], [-117.12369, 34.10445], [-117.12125, 34.10438], [-117.12127, 34.09896], [-117.12566, 34.09902], [-117.12565, 34.10075], [-117.13003, 34.10083], [-117.13004, 34.10082], [-117.13006, 34.09901], [-117.12566, 34.09894], [-117.12565, 34.09886], [-117.12127, 34.09879], [-117.12129, 34.09166], [-117.13014, 34.09176], [-117.13014, 34.09213], [-117.13217, 34.09216], [-117.13219, 34.09179], [-117.13252, 34.09179], [-117.13252, 34.0927], [-117.13455, 34.09272], [-117.13457, 34.09181], [-117.13861, 34.09186], [-117.13899, 34.09244], [-117.139, 34.09186], [-117.14332, 34.09182], [-117.14334, 34.09544], [-117.139, 34.09551], [-117.13901, 34.09914], [-117.15649, 34.0988], [-117.1563, 34.09169], [-117.16496, 34.09171], [-117.16503, 34.09529], [-117.16937, 34.09532], [-117.1694, 34.09712], [-117.17371, 34.09715], [-117.17371, 34.09536], [-117.18199, 34.09537], [-117.18202, 34.09897]], [[-117.12961, 34.10468], [-117.12962, 34.10454], [-117.12938, 34.10454], [-117.12938, 34.10467], [-117.12961, 34.10468]], [[-117.13014, 34.0923], [-117.13014, 34.09267], [-117.13218, 34.09268], [-117.13218, 34.09232], [-117.13014, 34.0923]]], [[[-117.15204, 34.09531], [-117.14768, 34.09537], [-117.14765, 34.09178], [-117.15197, 34.09173], [-117.15204, 34.09531]]]]} | Restricted Access 2 | 44334 | East Highlands Ranch Open Space | 18370 | 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 | 1593.347 | East Highlands Ranch OS | 0 | Local Recreation Area 3 | 4 | |
4872 | 4872 | 4871 | {"type": "Polygon", "coordinates": [[[-119.72189, 34.42619], [-119.72175, 34.42632], [-119.72033, 34.42628], [-119.72017, 34.42625], [-119.72001, 34.4262], [-119.71978, 34.42606], [-119.71997, 34.42593], [-119.72024, 34.42605], [-119.72189, 34.42619]]]} | Unknown Access 4 | 14721 | El Mission Creek | 18515 | 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.939 | El Mission Creek | 0 | Local Other or Unknown 14 | 4 | |
11572 | 11572 | 11571 | {"type": "Polygon", "coordinates": [[[-121.56715, 38.72188], [-121.55823, 38.72189], [-121.5582, 38.71449], [-121.56014, 38.7145], [-121.56708, 38.71449], [-121.56715, 38.72188]]]} | No Public Access 3 | 29738 | Elsie | 18605 | 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 | 156.937 | Elsie | None 1031 | |||
5799 | 5799 | 5798 | {"type": "MultiPolygon", "coordinates": [[[[-121.59691, 39.01108], [-121.59311, 39.01118], [-121.59358, 39.01301], [-121.59391, 39.01464], [-121.59433, 39.01645], [-121.59443, 39.01699], [-121.59445, 39.01733], [-121.59441, 39.01791], [-121.59437, 39.01814], [-121.59416, 39.01868], [-121.59396, 39.01902], [-121.59373, 39.01946], [-121.59354, 39.01995], [-121.5933, 39.02107], [-121.59319, 39.02146], [-121.59293, 39.02225], [-121.59287, 39.02225], [-121.59264, 39.02153], [-121.59211, 39.02089], [-121.59185, 39.0203], [-121.59032, 39.01854], [-121.58931, 39.01705], [-121.58836, 39.01612], [-121.58836, 39.01457], [-121.5864, 39.01457], [-121.58379, 39.01281], [-121.5838, 39.01078], [-121.58378, 39.00959], [-121.58501, 39.00963], [-121.58568, 39.00955], [-121.588, 39.00982], [-121.58942, 39.00995], [-121.59046, 39.00999], [-121.59107, 39.01008], [-121.59337, 39.01028], [-121.59439, 39.01045], [-121.59592, 39.01079], [-121.59691, 39.01108]]], [[[-121.60816, 39.04031], [-121.60835, 39.04131], [-121.60845, 39.04199], [-121.60859, 39.04275], [-121.60865, 39.04316], [-121.60866, 39.04405], [-121.60885, 39.04578], [-121.60901, 39.04677], [-121.60914, 39.04751], [-121.60925, 39.04829], [-121.60933, 39.04946], [-121.60963, 39.05223], [-121.60988, 39.05361], [-121.60993, 39.05437], [-121.60992, 39.05487], [-121.60995, 39.05554], [-121.61003, 39.05589], [-121.61012, 39.05638], [-121.61012, 39.05727], [-121.60998, 39.058], [-121.60972, 39.05842], [-121.60917, 39.05918], [-121.60876, 39.05993], [-121.60817, 39.06083], [-121.60767, 39.06145], [-121.60749, 39.0617], [-121.60473, 39.06131], [-121.60098, 39.05938], [-121.60167, 39.05491], [-121.60202, 39.0549], [-121.60225, 39.0404], [-121.60632, 39.04039], [-121.60751, 39.04033], [-121.60211, 39.04034], [-121.6018, 39.03873], [-121.60148, 39.03634], [-121.60101, 39.03366], [-121.6005, 39.03365], [-121.60049, 39.03311], [-121.60558, 39.03309], [-121.6062, 39.03424], [-121.60636, 39.03477], [-121.60696, 39.03595], [-121.6072, 39.03667], [-121.60733, 39.03687], [-121.60758, 39.03761], [-121.60774, 39.03819], [-121.60802, 39.03954], [-121.60805, 39.03986], [-121.60816, 39.04031]]], [[[-121.59954, 39.07212], [-121.59934, 39.07246], [-121.59882, 39.07361], [-121.59842, 39.07428], [-121.59809, 39.07473], [-121.59786, 39.07522], [-121.59766, 39.0756], [-121.59715, 39.07635], [-121.59689, 39.07662], [-121.5966, 39.07703], [-121.59637, 39.0774], [-121.59611, 39.07778], [-121.59552, 39.07846], [-121.59529, 39.07891], [-121.59495, 39.07928], [-121.59444, 39.07975], [-121.59428, 39.07997], [-121.59408, 39.08016], [-121.59349, 39.08092], [-121.5933, 39.08112], [-121.59314, 39.08132], [-121.59269, 39.08175], [-121.59219, 39.08216], [-121.59203, 39.08233], [-121.5916, 39.08271], [-121.59139, 39.08287], [-121.59116, 39.08301], [-121.59097, 39.08317], [-121.59055, 39.08341], [-121.59036, 39.08357], [-121.59016, 39.08371], [-121.58968, 39.08415], [-121.58929, 39.08466], [-121.58875, 39.08539], [-121.58839, 39.08605], [-121.58785, 39.08691], [-121.58771, 39.08707], [-121.58689, 39.08791], [-121.5864, 39.08858], [-121.58609, 39.08908], [-121.58595, 39.08926], [-121.58573, 39.08967], [-121.58569, 39.08985], [-121.58569, 39.09004], [-121.58575, 39.09061], [-121.58587, 39.09133], [-121.58594, 39.09157], [-121.58604, 39.0926], [-121.58601, 39.09322], [-121.58606, 39.09392], [-121.58606, 39.0943], [-121.58614, 39.0955], [-121.5863, 39.09631], [-121.58639, 39.09685], [-121.58643, 39.09723], [-121.58662, 39.09793], [-121.58678, 39.09846], [-121.58682, 39.09854], [-121.58597, 39.09854], [-121.58567, 39.09764], [-121.58468, 39.09428], [-121.58458, 39.09132], [-121.58467, 39.0909], [-121.58475, 39.09036], [-121.58497, 39.08994], [-121.58534, 39.08915], [-121.58577, 39.08839], [-121.58625, 39.08782], [-121.58672, 39.08714], [-121.58714, 39.08666], [-121.58848, 39.0847], [-121.5891, 39.08373], [-121.58956, 39.08287], [-121.5898, 39.08238], [-121.59006, 39.08189], [-121.5908, 39.08095], [-121.59121, 39.08047], [-121.59226, 39.07935], [-121.59277, 39.07875], [-121.59278, 39.07648], [-121.59362, 39.07648], [-121.59384, 39.07609], [-121.59416, 39.0758], [-121.59497, 39.07528], [-121.59533, 39.07501], [-121.59632, 39.07414], [-121.59669, 39.07384], [-121.59697, 39.07345], [-121.59736, 39.07281], [-121.59786, 39.07182], [-121.59954, 39.07212]]]]} | Unknown Access 4 | 59 | Feather River | 18860 | 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 | 733.868 | Feather River | 0 | None 465 | |||
11274 | 11274 | 11273 | {"type": "MultiPolygon", "coordinates": [[[[-121.56274, 38.64215], [-121.55175, 38.64219], [-121.55177, 38.63957], [-121.56212, 38.63953], [-121.56243, 38.64112], [-121.56256, 38.64159], [-121.56274, 38.64215]]], [[[-121.56974, 38.6564], [-121.5697, 38.66347], [-121.5552, 38.66347], [-121.55514, 38.66338], [-121.55569, 38.66199], [-121.55597, 38.6616], [-121.55662, 38.66106], [-121.55701, 38.66063], [-121.55734, 38.66024], [-121.55755, 38.65989], [-121.55802, 38.65871], [-121.55839, 38.65818], [-121.55884, 38.65793], [-121.55993, 38.65762], [-121.56053, 38.65731], [-121.56097, 38.65689], [-121.56108, 38.65639], [-121.56974, 38.6564]]], [[[-121.56061, 38.631], [-121.55811, 38.631], [-121.55878, 38.63463], [-121.55707, 38.63464], [-121.55706, 38.63442], [-121.55574, 38.62732], [-121.55758, 38.62732], [-121.55858, 38.62737], [-121.56002, 38.62737], [-121.56004, 38.62778], [-121.5601, 38.62831], [-121.56061, 38.631]]], [[[-121.56747, 38.64782], [-121.56742, 38.65624], [-121.56279, 38.65624], [-121.56281, 38.65341], [-121.55849, 38.65339], [-121.5583, 38.65285], [-121.55758, 38.65156], [-121.55699, 38.65089], [-121.55642, 38.64912], [-121.56515, 38.6491], [-121.56711, 38.64756], [-121.56747, 38.64782]]]]} | No Public Access 3 | 21780 | Fisherman's Lake | 18921 | 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 | 461.997 | Fisherman's Lake | None 986 | |||
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 | |
8831 | 8831 | 8830 | {"type": "Polygon", "coordinates": [[[-119.51853, 34.40523], [-119.51825, 34.40559], [-119.51773, 34.40641], [-119.51755, 34.40688], [-119.51721, 34.40679], [-119.51826, 34.40517], [-119.51853, 34.40523]]]} | Open Access 1 | 16039 | Franklin Park | 19067 | 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.208 | Franklin Park | 0 | Local Park 2 | 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 | |||
10348 | 10348 | 10347 | {"type": "Polygon", "coordinates": [[[-121.05008, 37.47695], [-121.04981, 37.47744], [-121.04901, 37.47822], [-121.04893, 37.48562], [-121.04748, 37.48584], [-121.04661, 37.48352], [-121.04645, 37.48354], [-121.04625, 37.48355], [-121.04608, 37.48354], [-121.04588, 37.48349], [-121.04563, 37.48339], [-121.04538, 37.48317], [-121.0453, 37.48304], [-121.04517, 37.48265], [-121.04504, 37.48171], [-121.04405, 37.48162], [-121.04261, 37.48197], [-121.04182, 37.4817], [-121.04167, 37.48135], [-121.0417, 37.48091], [-121.04211, 37.4806], [-121.04288, 37.48066], [-121.04371, 37.48094], [-121.04433, 37.48094], [-121.04465, 37.48038], [-121.04424, 37.4798], [-121.04404, 37.47886], [-121.0446, 37.47887], [-121.0447, 37.47961], [-121.04544, 37.48016], [-121.04697, 37.48112], [-121.04678, 37.48136], [-121.04678, 37.48138], [-121.04738, 37.4816], [-121.04842, 37.48149], [-121.04888, 37.48106], [-121.04885, 37.48074], [-121.04816, 37.4803], [-121.04815, 37.47982], [-121.04869, 37.47938], [-121.04871, 37.47807], [-121.04954, 37.47726], [-121.0498, 37.47675], [-121.04997, 37.47686], [-121.05008, 37.47695]], [[-121.04619, 37.48132], [-121.04606, 37.48124], [-121.04563, 37.48131], [-121.04513, 37.481], [-121.04492, 37.48099], [-121.04425, 37.48114], [-121.04401, 37.48116], [-121.04369, 37.4811], [-121.04297, 37.4808], [-121.04251, 37.48072], [-121.04228, 37.48073], [-121.04216, 37.48077], [-121.04206, 37.48082], [-121.04184, 37.48098], [-121.04186, 37.48134], [-121.04193, 37.48152], [-121.04206, 37.4816], [-121.04247, 37.48166], [-121.0427, 37.48174], [-121.0429, 37.48173], [-121.04383, 37.48147], [-121.0441, 37.48146], [-121.04487, 37.48158], [-121.04516, 37.48153], [-121.04569, 37.48173], [-121.0459, 37.48179], [-121.04622, 37.48158], [-121.04625, 37.48144], [-121.04619, 37.48132]]]} | Open Access 1 | 18274 | Gomes Lake | 19387 | 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 | Stanislaus 2 | 42.26 | Gomes Lake | 0 | None 906 | |||
13183 | 13183 | 13182 | {"type": "Polygon", "coordinates": [[[-121.58089, 38.76428], [-121.57704, 38.76432], [-121.57698, 38.75393], [-121.57986, 38.75654], [-121.57991, 38.75691], [-121.58081, 38.76113], [-121.58089, 38.76428]]]} | No Public Access 3 | 35166 | Huffman East | 20138 | 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 | 74.085 | Huffman East | None 1148 | |||
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 | ||
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 | |||
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 |
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]);