superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AG_TYP = 9
This data as json, copyable, CSV (advanced)
MNG_AGENCY 8
- Fresno Metropolitan Flood Control District 29
- Natomas Basin Conservancy 19
- Los Angeles County Flood Control District 16
- Santa Barbara Flood Control and Water Conserv. District 15
- 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
ACCESS_TYP 4
MNG_AG_TYP 1
- Flood District · 91 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1647 | 1647 | 1646 | {"type": "MultiPolygon", "coordinates": [[[[-121.6007, 38.7384], [-121.59981, 38.74049], [-121.59115, 38.74058], [-121.59023, 38.74346], [-121.58935, 38.74635], [-121.58496, 38.74644], [-121.58503, 38.74523], [-121.58488, 38.74496], [-121.58336, 38.74324], [-121.58352, 38.74306], [-121.58355, 38.74272], [-121.58366, 38.74229], [-121.5843, 38.74056], [-121.58581, 38.73629], [-121.59247, 38.73626], [-121.59185, 38.7384], [-121.59186, 38.73842], [-121.6007, 38.7384]]], [[[-121.58903, 38.7474], [-121.58849, 38.74926], [-121.58654, 38.7493], [-121.5865, 38.74746], [-121.58903, 38.7474]]]]} | No Public Access 3 | Atkinson | 15671 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 207.44 | Atkinson | ||
1868 | 1868 | 1867 | {"type": "MultiPolygon", "coordinates": [[[[-121.53785, 38.99012], [-121.53571, 38.99016], [-121.53505, 38.98682], [-121.53318, 38.97686], [-121.53261, 38.97453], [-121.53228, 38.97439], [-121.52906, 38.974], [-121.52845, 38.97401], [-121.52772, 38.97407], [-121.52694, 38.97429], [-121.52604, 38.97461], [-121.52466, 38.97549], [-121.52472, 38.97146], [-121.53415, 38.97196], [-121.53419, 38.9722], [-121.53437, 38.97219], [-121.53521, 38.97686], [-121.53623, 38.98263], [-121.53785, 38.99012]]], [[[-121.54307, 38.97419], [-121.53827, 38.97526], [-121.53632, 38.97537], [-121.5361, 38.97451], [-121.53695, 38.97474], [-121.53768, 38.97467], [-121.53863, 38.97446], [-121.5393, 38.97412], [-121.54232, 38.97348], [-121.54302, 38.97266], [-121.54307, 38.97419]]], [[[-121.5693, 38.94626], [-121.56559, 38.95156], [-121.56466, 38.95274], [-121.56398, 38.95341], [-121.5629, 38.95417], [-121.56164, 38.95474], [-121.56038, 38.95508], [-121.55862, 38.95546], [-121.55738, 38.95588], [-121.55666, 38.95633], [-121.55609, 38.95694], [-121.55575, 38.95752], [-121.55567, 38.95751], [-121.55566, 38.95777], [-121.55557, 38.95768], [-121.55556, 38.95768], [-121.55525, 38.9583], [-121.55289, 38.96098], [-121.55118, 38.96232], [-121.55065, 38.96278], [-121.55031, 38.96313], [-121.54971, 38.96387], [-121.54949, 38.9638], [-121.54995, 38.96284], [-121.55104, 38.96187], [-121.55287, 38.96042], [-121.55366, 38.95939], [-121.555, 38.95758], [-121.55531, 38.95677], [-121.55611, 38.95602], [-121.5573, 38.95535], [-121.55905, 38.95497], [-121.56076, 38.95466], [-121.5618, 38.95423], [-121.56279, 38.95374], [-121.56346, 38.95316], [-121.56433, 38.95229], [-121.56908, 38.94541], [-121.5693, 38.94626]]]]} | Unknown Access 4 | Bear River | 15929 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Special District 4 | 185.757 | Bear River | |||
1954 | 1954 | 1953 | {"type": "MultiPolygon", "coordinates": [[[[-121.56754, 38.78412], [-121.56281, 38.78417], [-121.56278, 38.78305], [-121.559, 38.78306], [-121.55896, 38.78247], [-121.55883, 38.78192], [-121.55796, 38.77936], [-121.56749, 38.77925], [-121.56754, 38.78412]]], [[[-121.57688, 38.7791], [-121.57685, 38.78379], [-121.57658, 38.7838], [-121.57635, 38.78385], [-121.57612, 38.78398], [-121.57591, 38.78415], [-121.57575, 38.78438], [-121.57562, 38.78466], [-121.5756, 38.78501], [-121.57605, 38.78658], [-121.57227, 38.7866], [-121.57224, 38.78407], [-121.56773, 38.78412], [-121.56767, 38.77925], [-121.57688, 38.7791]]]]} | No Public Access 3 | Bennett North | 16014 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 220.336 | Bennett North | ||
1955 | 1955 | 1954 | {"type": "Polygon", "coordinates": [[[-121.58089, 38.76428], [-121.58083, 38.77153], [-121.58085, 38.77515], [-121.58084, 38.7788], [-121.57707, 38.77889], [-121.57707, 38.77795], [-121.57912, 38.77792], [-121.57912, 38.77662], [-121.57911, 38.77661], [-121.57706, 38.77662], [-121.57704, 38.76432], [-121.58089, 38.76428]]]} | No Public Access 3 | Bennett South | 16015 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 125.171 | Bennett South | ||
2122 | 2122 | 2121 | {"type": "Polygon", "coordinates": [[[-121.58368, 38.77894], [-121.58367, 38.78624], [-121.57862, 38.78635], [-121.57859, 38.78626], [-121.57859, 38.78505], [-121.57857, 38.78483], [-121.57847, 38.78457], [-121.57822, 38.78433], [-121.57798, 38.78417], [-121.57743, 38.78397], [-121.57704, 38.78389], [-121.57707, 38.7791], [-121.58368, 38.77894]]]} | No Public Access 3 | Bolen North | 16237 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 107.053 | Bolen North | ||
2123 | 2123 | 2122 | {"type": "Polygon", "coordinates": [[[-121.5898, 38.77492], [-121.58979, 38.77858], [-121.58084, 38.7788], [-121.58085, 38.77515], [-121.5898, 38.77492]]]} | No Public Access 3 | Bolen South | 16238 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 77.853 | Bolen South | ||
2124 | 2124 | 2123 | {"type": "MultiPolygon", "coordinates": [[[[-121.59008, 38.78617], [-121.59003, 38.79179], [-121.58388, 38.78653], [-121.58388, 38.78637], [-121.59008, 38.78617]]], [[[-121.59012, 38.77873], [-121.59011, 38.78228], [-121.59002, 38.78232], [-121.58999, 38.78603], [-121.58388, 38.78623], [-121.58389, 38.77893], [-121.59012, 38.77873]]]]} | No Public Access 3 | Bolen West | 16239 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 150.02 | Bolen West | ||
2314 | 2314 | 2313 | {"type": "Polygon", "coordinates": [[[-117.03429, 34.05023], [-117.03428, 34.05205], [-117.02584, 34.05208], [-117.02582, 34.0496], [-117.0264, 34.04972], [-117.02709, 34.04997], [-117.0277, 34.04982], [-117.02836, 34.04976], [-117.02879, 34.04956], [-117.02917, 34.04944], [-117.02963, 34.04933], [-117.03007, 34.04927], [-117.03008, 34.04906], [-117.03226, 34.04903], [-117.03227, 34.05024], [-117.03429, 34.05023]]]} | No Public Access 3 | Bryant St Detention Basin | 16460 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | http://www.sbcounty.gov/dpw/floodcontrol/ | Special District 4 | 51.958 | Bryant St Detention Basin | ||
2340 | 2340 | 2339 | {"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 | Buellton Park | 16483 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2.399 | Buellton Park | ||
2457 | 2457 | 2456 | {"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 | Compton Creek & Bike Path | 17572 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 0.02 | Compton Creek & Bike Path | ||
2576 | 2576 | 2575 | {"type": "MultiPolygon", "coordinates": [[[[-118.28809, 33.79111], [-118.2879, 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.79317], [-118.28845, 33.79318], [-118.28844, 33.79399], [-118.28884, 33.79401], [-118.28884, 33.79414]]], [[[-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]]], [[[-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.28947, 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]]]]} | No Public Access 3 | Canada de Palos Verdes Creek | 16791 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 18.844 | Canada de Palos Verdes Creek | ||
2650 | 2650 | 2649 | {"type": "Polygon", "coordinates": [[[-119.50841, 34.395], [-119.5075, 34.3955], [-119.50689, 34.39577], [-119.50682, 34.39566], [-119.50722, 34.39559], [-119.50754, 34.39538], [-119.50776, 34.39528], [-119.50804, 34.39502], [-119.50825, 34.39477], [-119.50841, 34.395]]]} | Unknown Access 4 | Carpinteria Creek | 16898 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 0.458 | Carpinteria Creek | ||
2652 | 2652 | 2651 | {"type": "MultiPolygon", "coordinates": [[[[-119.52905, 34.3961], [-119.52846, 34.39735], [-119.52762, 34.39922], [-119.52766, 34.39927], [-119.52741, 34.39995], [-119.5269, 34.39971], [-119.52637, 34.39941], [-119.52671, 34.39929], [-119.52671, 34.39926], [-119.52674, 34.39925], [-119.52684, 34.39932], [-119.52708, 34.39925], [-119.52717, 34.39921], [-119.52737, 34.39902], [-119.5274, 34.39902], [-119.5288, 34.39601], [-119.52905, 34.3961]]], [[[-119.53027, 34.40061], [-119.5299, 34.40115], [-119.52919, 34.40081], [-119.52943, 34.40021], [-119.53027, 34.40061]]]]} | Restricted Access 2 | Carpinteria Salt Marsh Reserve | 16900 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 5.154 | Carpinteria Salt Marsh Reserve | ||
2763 | 2763 | 2762 | {"type": "MultiPolygon", "coordinates": [[[[-121.51211, 38.73594], [-121.5053, 38.73594], [-121.4936, 38.73517], [-121.49357, 38.73262], [-121.492, 38.73261], [-121.492, 38.73089], [-121.49354, 38.73089], [-121.49355, 38.73073], [-121.49199, 38.73072], [-121.49192, 38.73045], [-121.49182, 38.73023], [-121.49167, 38.73], [-121.49147, 38.72979], [-121.49128, 38.72963], [-121.49109, 38.72951], [-121.49064, 38.72931], [-121.49032, 38.72913], [-121.49007, 38.72895], [-121.49007, 38.72887], [-121.49617, 38.72886], [-121.49617, 38.7293], [-121.49615, 38.72941], [-121.49619, 38.72953], [-121.49628, 38.72963], [-121.49641, 38.72969], [-121.49656, 38.72971], [-121.49671, 38.72969], [-121.49683, 38.72962], [-121.49685, 38.72975], [-121.49752, 38.72982], [-121.49755, 38.72954], [-121.49765, 38.72954], [-121.4977, 38.72935], [-121.49817, 38.72938], [-121.49818, 38.72885], [-121.51206, 38.72883], [-121.51211, 38.73594]], [[-121.50409, 38.72946], [-121.50409, 38.72907], [-121.50368, 38.72907], [-121.50368, 38.72947], [-121.50409, 38.72946]], [[-121.50715, 38.72915], [-121.50714, 38.72913], [-121.50677, 38.7291], [-121.50648, 38.72911], [-121.50584, 38.7291], [-121.50595, 38.72985], [-121.5059, 38.72993], [-121.5059, 38.73022], [-121.50588, 38.73035], [-121.50575, 38.73041], [-121.50568, 38.73055], [-121.50563, 38.7312], [-121.50566, 38.73125], [-121.50695, 38.73036], [-121.50694, 38.73024], [-121.50705, 38.72956], [-121.50715, 38.72915]]], [[[-121.56722, 38.72886], [-121.55827, 38.72891], [-121.55829, 38.73595], [-121.54081, 38.73595], [-121.54077, 38.72191], [-121.5486, 38.7219], [-121.54862, 38.72893], [-121.54863, 38.72895], [-121.55825, 38.7289], [-121.55823, 38.72189], [-121.56715, 38.72188], [-121.56722, 38.72886]]]]} | No Public Access 3 | Central Basin | 17046 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 883.597 | Central Basin | ||
3122 | 3122 | 3121 | {"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 | Elsie | 18605 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 156.93 | Elsie | ||
3271 | 3271 | 3270 | {"type": "MultiPolygon", "coordinates": [[[[-118.05583, 33.85032], [-118.0555, 33.85058], [-118.05501, 33.85093], [-118.05491, 33.85112], [-118.05476, 33.85123], [-118.05468, 33.85127], [-118.05459, 33.8512], [-118.04664, 33.85659], [-118.04643, 33.85693], [-118.04634, 33.85714], [-118.04633, 33.85671], [-118.04639, 33.85671], [-118.04639, 33.85665], [-118.04633, 33.85663], [-118.04632, 33.85595], [-118.04638, 33.85594], [-118.04638, 33.85587], [-118.04631, 33.85585], [-118.0463, 33.8556], [-118.04654, 33.85566], [-118.04783, 33.85479], [-118.04783, 33.85477], [-118.04764, 33.85477], [-118.04801, 33.85452], [-118.04824, 33.85453], [-118.04963, 33.85362], [-118.0504, 33.85362], [-118.0504, 33.85303], [-118.05091, 33.8527], [-118.05367, 33.85081], [-118.05441, 33.85033], [-118.05583, 33.85032]]], [[[-118.05906, 33.84647], [-118.05887, 33.84646], [-118.05885, 33.84651], [-118.05848, 33.84671], [-118.05662, 33.84943], [-118.05631, 33.84983], [-118.05507, 33.84984], [-118.05525, 33.84969], [-118.05551, 33.84942], [-118.05575, 33.84913], [-118.05748, 33.84657], [-118.0575, 33.84635], [-118.05754, 33.84628], [-118.05892, 33.84628], [-118.05906, 33.84636], [-118.05906, 33.84647]]], [[[-118.06126, 33.83895], [-118.06125, 33.83898], [-118.06107, 33.83907], [-118.06104, 33.83915], [-118.06065, 33.84192], [-118.06053, 33.8425], [-118.06071, 33.84255], [-118.06063, 33.84287], [-118.06045, 33.84285], [-118.06031, 33.84332], [-118.06015, 33.84376], [-118.06033, 33.84383], [-118.06029, 33.84391], [-118.06012, 33.84387], [-118.0601, 33.84388], [-118.06006, 33.84403], [-118.06022, 33.84408], [-118.06016, 33.84424], [-118.05997, 33.8442], [-118.05961, 33.84495], [-118.05926, 33.84555], [-118.05916, 33.84569], [-118.05931, 33.84579], [-118.05914, 33.84603], [-118.05915, 33.84608], [-118.05904, 33.84601], [-118.05903, 33.84404], [-118.05933, 33.84332], [-118.05956, 33.84256], [-118.05972, 33.84173], [-118.05975, 33.84146], [-118.05936, 33.84143], [-118.05939, 33.84138], [-118.05938, 33.84131], [-118.05978, 33.84132], [-118.06007, 33.8393], [-118.0601, 33.83928], [-118.06013, 33.83912], [-118.05992, 33.83901], [-118.05993, 33.83898], [-118.06126, 33.83895]]], [[[-118.0628, 33.83198], [-118.0623, 33.83332], [-118.0618, 33.83474], [-118.0617, 33.83513], [-118.06187, 33.83514], [-118.06185, 33.83522], [-118.06169, 33.83519], [-118.06164, 33.83536], [-118.0615, 33.83603], [-118.06132, 33.83726], [-118.0613, 33.83755], [-118.06124, 33.83796], [-118.06119, 33.8381], [-118.06114, 33.83842], [-118.06119, 33.83852], [-118.06131, 33.83859], [-118.06131, 33.83862], [-118.05997, 33.83865], [-118.05998, 33.83862], [-118.06021, 33.8385], [-118.06055, 33.8359], [-118.06077, 33.83495], [-118.06068, 33.83492], [-118.06058, 33.83495], [-118.0607, 33.83451], [-118.06094, 33.83379], [-118.06107, 33.83344], [-118.0628, 33.83198]]]]} | Open Access 1 | Coyote Creek & Bike Trail | 17737 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 63.574 | Coyote Creek & Bike Trail | ||
3339 | 3339 | 3338 | {"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.55992, 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 | Fisherman's Lake | 18921 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 462.047 | Fisherman's Lake | ||
3497 | 3497 | 3496 | {"type": "Polygon", "coordinates": [[[-119.51853, 34.40523], [-119.51825, 34.40559], [-119.51773, 34.4064], [-119.51755, 34.40688], [-119.51721, 34.40679], [-119.51826, 34.40517], [-119.51853, 34.40523]]]} | Open Access 1 | Franklin Park | 19067 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 1.208 | Franklin Park | ||
3683 | 3683 | 3682 | {"type": "Polygon", "coordinates": [[[-119.73541, 34.4041], [-119.73541, 34.40426], [-119.73437, 34.40428], [-119.73407, 34.4042], [-119.73417, 34.40413], [-119.73405, 34.40365], [-119.73466, 34.40398], [-119.73541, 34.4041]]]} | Open Access 1 | Douglas Family Reserve | 18244 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 1.024 | Douglas Family Reserve | ||
3713 | 3713 | 3712 | {"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.40643, 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 | Dry Creek | 18279 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Special District 4 | 15.594 | Dry Creek |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);