units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, COUNTY = 6, DES_TP = 14 and LAYER = 4
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4692 | 4692 | 4691 | {"type": "Polygon", "coordinates": [[[-118.35865, 34.26614], [-118.35827, 34.26807], [-118.35695, 34.26791], [-118.35657, 34.2683], [-118.35593, 34.26829], [-118.35637, 34.26785], [-118.35636, 34.26783], [-118.35538, 34.26771], [-118.35584, 34.26829], [-118.35539, 34.26829], [-118.35538, 34.2683], [-118.3577, 34.27107], [-118.35758, 34.2717], [-118.35674, 34.27179], [-118.3562, 34.272], [-118.35591, 34.27203], [-118.35491, 34.27184], [-118.35328, 34.27158], [-118.35331, 34.27145], [-118.35321, 34.27142], [-118.35327, 34.27106], [-118.35311, 34.27121], [-118.35307, 34.27142], [-118.35297, 34.27141], [-118.35294, 34.27154], [-118.35225, 34.27148], [-118.3521, 34.27136], [-118.35132, 34.27105], [-118.35025, 34.27136], [-118.35001, 34.27136], [-118.34913, 34.27125], [-118.34883, 34.27106], [-118.34638, 34.27079], [-118.3461, 34.27079], [-118.34579, 34.27083], [-118.34487, 34.27088], [-118.34383, 34.27067], [-118.34275, 34.27038], [-118.34297, 34.2702], [-118.34461, 34.26985], [-118.34448, 34.26941], [-118.34405, 34.26957], [-118.34268, 34.26987], [-118.34194, 34.26956], [-118.34228, 34.26782], [-118.33932, 34.26743], [-118.33933, 34.26732], [-118.33824, 34.26717], [-118.33809, 34.26706], [-118.33774, 34.26708], [-118.33774, 34.2671], [-118.33771, 34.26708], [-118.33752, 34.26709], [-118.33678, 34.26627], [-118.33684, 34.26622], [-118.33636, 34.26564], [-118.33801, 34.26554], [-118.33802, 34.26556], [-118.33921, 34.26572], [-118.3404, 34.26577], [-118.34054, 34.26507], [-118.34096, 34.26513], [-118.34096, 34.26515], [-118.34167, 34.26525], [-118.34171, 34.26509], [-118.34256, 34.26511], [-118.34257, 34.26507], [-118.34282, 34.26507], [-118.34299, 34.26424], [-118.34363, 34.26427], [-118.34414, 34.26432], [-118.34481, 34.26442], [-118.34531, 34.26452], [-118.34609, 34.26472], [-118.3483, 34.26542], [-118.34897, 34.26558], [-118.34944, 34.26565], [-118.35413, 34.26605], [-118.35603, 34.26619], [-118.35857, 34.26622], [-118.35865, 34.26614]]]} | Restricted Access 2 | 45521 | Unnamed - Los Angeles County Flood Control District | 30959 | 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 | http://dpw.lacounty.gov/wrd/Projects/BTWMA/index.cfm | Los Angeles 6 | 242.496 | 0 | Local Other or Unknown 14 | 4 | |
7380 | 7380 | 7379 | {"type": "MultiPolygon", "coordinates": [[[[-118.02362, 34.03786], [-118.02295, 34.03812], [-118.02142, 34.03872], [-118.02185, 34.03849], [-118.02227, 34.03822], [-118.02267, 34.03795], [-118.02315, 34.03758], [-118.02362, 34.03786]]], [[[-118.02425, 34.03824], [-118.01421, 34.04219], [-118.01399, 34.04191], [-118.02388, 34.03802], [-118.02425, 34.03824]]], [[[-118.01723, 34.04177], [-118.01626, 34.04227], [-118.01533, 34.04283], [-118.01464, 34.04327], [-118.0137, 34.04395], [-118.01315, 34.04438], [-118.01261, 34.04483], [-118.01196, 34.04542], [-118.01122, 34.04617], [-118.01112, 34.0462], [-118.01097, 34.0462], [-118.01088, 34.04618], [-118.01064, 34.04602], [-118.01062, 34.04603], [-118.01055, 34.04599], [-118.01434, 34.04296], [-118.01442, 34.04302], [-118.01471, 34.04276], [-118.01723, 34.04177]]], [[[-118.00813, 34.04674], [-118.00572, 34.05101], [-118.00492, 34.05209], [-118.0047, 34.05243], [-118.0044, 34.0526], [-118.00459, 34.05168], [-118.00483, 34.05171], [-118.00497, 34.05149], [-118.00512, 34.0508], [-118.00515, 34.05058], [-118.00476, 34.0505], [-118.0049, 34.04995], [-118.0053, 34.05002], [-118.00522, 34.05038], [-118.00569, 34.05046], [-118.00621, 34.04858], [-118.00572, 34.04847], [-118.00597, 34.04755], [-118.00643, 34.04763], [-118.00676, 34.04715], [-118.00676, 34.0471], [-118.00614, 34.04697], [-118.00621, 34.04672], [-118.00813, 34.04674]]], [[[-118.01108, 34.04633], [-118.01063, 34.04683], [-118.01023, 34.0473], [-118.00996, 34.04766], [-118.00948, 34.04832], [-118.00896, 34.04913], [-118.00849, 34.04996], [-118.00809, 34.05077], [-118.00783, 34.05135], [-118.00756, 34.05209], [-118.00753, 34.05213], [-118.00733, 34.05273], [-118.00733, 34.05251], [-118.00732, 34.0525], [-118.00646, 34.054], [-118.0063, 34.05548], [-118.00608, 34.05535], [-118.00619, 34.05523], [-118.00629, 34.055], [-118.00632, 34.05481], [-118.0063, 34.05459], [-118.00622, 34.05439], [-118.00584, 34.0537], [-118.00577, 34.05354], [-118.00572, 34.05337], [-118.00571, 34.05316], [-118.00576, 34.05288], [-118.00613, 34.05187], [-118.00634, 34.05139], [-118.00709, 34.04998], [-118.00954, 34.04563], [-118.00964, 34.04567], [-118.00967, 34.04563], [-118.01026, 34.04597], [-118.0095, 34.04674], [-118.00951, 34.04683], [-118.01046, 34.04607], [-118.01087, 34.0463], [-118.01098, 34.04633], [-118.01108, 34.04633]]], [[[-118.00544, 34.05569], [-118.00531, 34.05604], [-118.00476, 34.05566], [-118.00479, 34.05563], [-118.00491, 34.05568], [-118.00516, 34.05571], [-118.00544, 34.05569]]]]} | Restricted Access 2 | 6780 | Duck Farm Property | 18295 | 2177 | Watershed Conservation Authority 860 | Special District 4 | Conservation District 31 | https://www.wca.ca.gov/ | Special District 4 | 2177 | Watershed Conservation Authority 838 | Special District 4 | Conservation District 30 | Los Angeles 6 | 59.863 | Duck Farm Property | 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]);