units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where DES_TP = 14 and LABEL_NAME = "Flood Control"
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3050 | 3050 | 3049 | {"type": "MultiPolygon", "coordinates": [[[[-121.24452, 38.72086], [-121.24452, 38.72174], [-121.24392, 38.72198], [-121.24348, 38.72211], [-121.243, 38.72216], [-121.24087, 38.72215], [-121.24088, 38.72187], [-121.24142, 38.72131], [-121.24229, 38.72048], [-121.2424, 38.72035], [-121.24247, 38.72024], [-121.24255, 38.72001], [-121.24256, 38.71981], [-121.24243, 38.71901], [-121.24317, 38.71934], [-121.24452, 38.72086]]], [[[-121.24324, 38.72673], [-121.24287, 38.72694], [-121.24263, 38.72659], [-121.24242, 38.72641], [-121.24196, 38.72561], [-121.24212, 38.7254], [-121.24228, 38.7254], [-121.24235, 38.72544], [-121.24262, 38.72546], [-121.24261, 38.72582], [-121.24268, 38.72605], [-121.24282, 38.72626], [-121.24324, 38.72673]]], [[[-121.24705, 38.72776], [-121.24669, 38.72806], [-121.24614, 38.7276], [-121.24538, 38.7271], [-121.24461, 38.72713], [-121.24464, 38.72905], [-121.24408, 38.72926], [-121.24395, 38.72917], [-121.24386, 38.72913], [-121.24372, 38.7291], [-121.24358, 38.7291], [-121.24358, 38.72874], [-121.24324, 38.72824], [-121.24342, 38.72813], [-121.24353, 38.72797], [-121.24366, 38.72722], [-121.24366, 38.72705], [-121.24361, 38.7269], [-121.24353, 38.7268], [-121.2429, 38.72609], [-121.24281, 38.72588], [-121.2428, 38.7257], [-121.24283, 38.72526], [-121.24329, 38.72527], [-121.24334, 38.72506], [-121.2433, 38.72484], [-121.24337, 38.72448], [-121.24365, 38.72414], [-121.24385, 38.72389], [-121.24388, 38.72355], [-121.24381, 38.72292], [-121.24399, 38.72224], [-121.24462, 38.72224], [-121.24462, 38.72236], [-121.24444, 38.72249], [-121.24437, 38.72277], [-121.24432, 38.72287], [-121.2443, 38.72308], [-121.24453, 38.72352], [-121.24447, 38.72389], [-121.24432, 38.7242], [-121.24392, 38.72447], [-121.2439, 38.72451], [-121.24388, 38.72482], [-121.24387, 38.72589], [-121.24392, 38.72603], [-121.24398, 38.72612], [-121.2441, 38.72622], [-121.24423, 38.72622], [-121.24505, 38.72665], [-121.2456, 38.72668], [-121.2461, 38.72696], [-121.24705, 38.72776]]], [[[-121.24936, 38.72958], [-121.24879, 38.72974], [-121.24869, 38.72944], [-121.2471, 38.72837], [-121.24684, 38.72817], [-121.24721, 38.72788], [-121.24746, 38.72807], [-121.24913, 38.72919], [-121.24936, 38.72958]]]]} | Open Access 1 | 20932 | Flood Control | 18952 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 37.251 | Flood Control | 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 | |
10918 | 10918 | 10917 | {"type": "Polygon", "coordinates": [[[-121.28931, 38.73527], [-121.28926, 38.73535], [-121.28919, 38.73532], [-121.28927, 38.73501], [-121.28923, 38.73477], [-121.28889, 38.73486], [-121.28886, 38.73484], [-121.2892, 38.73473], [-121.28893, 38.73434], [-121.28848, 38.73416], [-121.28827, 38.73404], [-121.28811, 38.73391], [-121.28768, 38.73376], [-121.28769, 38.73373], [-121.28697, 38.73301], [-121.28696, 38.73287], [-121.28596, 38.73286], [-121.28595, 38.73305], [-121.28563, 38.73306], [-121.28482, 38.73357], [-121.2845, 38.73363], [-121.28378, 38.73346], [-121.28357, 38.73328], [-121.28339, 38.73323], [-121.28305, 38.73259], [-121.2832, 38.73219], [-121.2832, 38.73179], [-121.28349, 38.73159], [-121.28366, 38.73137], [-121.28382, 38.73123], [-121.28412, 38.73154], [-121.28378, 38.73159], [-121.28366, 38.73184], [-121.28366, 38.73285], [-121.28421, 38.7332], [-121.28441, 38.73322], [-121.28474, 38.73313], [-121.28474, 38.73306], [-121.28486, 38.73306], [-121.28508, 38.73292], [-121.28537, 38.73268], [-121.28574, 38.73246], [-121.28582, 38.73234], [-121.28596, 38.73234], [-121.28597, 38.73238], [-121.2864, 38.73239], [-121.28691, 38.73245], [-121.28733, 38.73266], [-121.28753, 38.73284], [-121.2878, 38.73301], [-121.28786, 38.73307], [-121.28825, 38.7333], [-121.28826, 38.73334], [-121.28844, 38.73337], [-121.28862, 38.73345], [-121.28884, 38.73347], [-121.28928, 38.73373], [-121.28931, 38.73527]]]} | Open Access 1 | 20924 | Flood Control | 18952 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 10.315 | Flood Control | 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]);