units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 4 and MNG_AG_TYP = 9 sorted by id
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, MNG_AG_ID, COUNTY
DES_TP 3
- Local Other or Unknown 5
- None 1
- None 1
MNG_AGENCY 2
MNG_AG_TYP 1
- Flood District · 7 ✖
AGNCY_TYP 1 ✖
ACCESS_TYP 1
- Unknown Access · 7 ✖
Link | rowid | id ▼ | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108 | 108 | 107 | {"type": "Polygon", "coordinates": [[[-119.80165, 34.44381], [-119.80106, 34.44387], [-119.79957, 34.44402], [-119.79959, 34.44377], [-119.80161, 34.44357], [-119.80165, 34.44381]]]} | Unknown Access 4 | 295 | San Antonio Creek | 24829 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 1.291 | San Antonio Creek | 0 | Local Other or Unknown 14 | 4 | |
3770 | 3770 | 3769 | {"type": "Polygon", "coordinates": [[[-121.40978, 39.0321], [-121.40886, 39.03318], [-121.40825, 39.0338], [-121.40801, 39.03396], [-121.40738, 39.03562], [-121.40691, 39.03607], [-121.40665, 39.03623], [-121.40644, 39.03625], [-121.40543, 39.03614], [-121.40505, 39.03582], [-121.40453, 39.0351], [-121.40393, 39.0349], [-121.40344, 39.03488], [-121.40287, 39.03514], [-121.4026, 39.03562], [-121.40242, 39.03625], [-121.40184, 39.0353], [-121.40342, 39.03459], [-121.40368, 39.03458], [-121.40502, 39.03496], [-121.40768, 39.03386], [-121.40806, 39.03357], [-121.40923, 39.03229], [-121.40961, 39.0318], [-121.40978, 39.0321]]]} | Unknown Access 4 | 472 | Dry Creek | 18279 | 2127 | Sacramento and San Joaquin Drainage District 681 | Special District 4 | Flood District 8 | Special District 4 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Yuba 25 | 15.587 | Dry Creek | 0 | Local Other or Unknown 14 | 4 | ||
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 | |
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 | |||
5920 | 5920 | 5919 | {"type": "MultiPolygon", "coordinates": [[[[-121.53785, 38.99012], [-121.53571, 38.99016], [-121.53505, 38.98682], [-121.53318, 38.97686], [-121.53261, 38.97452], [-121.53228, 38.97439], [-121.52906, 38.974], [-121.52845, 38.97401], [-121.52772, 38.97407], [-121.52694, 38.97429], [-121.52603, 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.54233, 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.55608, 38.95694], [-121.55575, 38.95752], [-121.55566, 38.95751], [-121.55566, 38.95777], [-121.55556, 38.95767], [-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 | 418 | Bear River | 15929 | 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 | 185.752 | Bear River | None 473 | ||||
6625 | 6625 | 6624 | {"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 | 4393 | Carpinteria Creek | 16898 | 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.458 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
10130 | 10130 | 10129 | {"type": "MultiPolygon", "coordinates": [[[[-119.79298, 34.45997], [-119.79252, 34.45991], [-119.7921, 34.46012], [-119.79188, 34.4602], [-119.7916, 34.46027], [-119.79158, 34.46041], [-119.79162, 34.46056], [-119.79145, 34.46063], [-119.79126, 34.46065], [-119.79126, 34.4609], [-119.79072, 34.4611], [-119.7886, 34.46125], [-119.78792, 34.46073], [-119.78791, 34.46056], [-119.79093, 34.45917], [-119.79247, 34.45875], [-119.79289, 34.45965], [-119.79298, 34.45997]]], [[[-119.80355, 34.44549], [-119.80304, 34.44557], [-119.80256, 34.44575], [-119.80212, 34.44575], [-119.80227, 34.44563], [-119.80246, 34.44553], [-119.80285, 34.4454], [-119.80309, 34.44528], [-119.80312, 34.44528], [-119.80355, 34.44549]]], [[[-119.8054, 34.44317], [-119.80527, 34.44343], [-119.80481, 34.44368], [-119.80461, 34.44386], [-119.80474, 34.44426], [-119.80438, 34.44456], [-119.8039, 34.44475], [-119.80365, 34.44499], [-119.80358, 34.44532], [-119.80331, 34.44519], [-119.80329, 34.44516], [-119.8033, 34.44512], [-119.80453, 34.44362], [-119.80464, 34.44344], [-119.80471, 34.44324], [-119.8054, 34.44317]]]]} | Unknown Access 4 | 17605 | Maria Ygnacia Creek | 21811 | 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 | 19.072 | Maria Ygnacia Creek | 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]);