units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_LEV = 4 and MNG_AGENCY = 1114
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16777 | 16777 | 16776 | {"type": "MultiPolygon", "coordinates": [[[[-121.32835, 39.32083], [-121.32741, 39.32099], [-121.32743, 39.32082], [-121.32742, 39.32081], [-121.32611, 39.32104], [-121.32606, 39.32077], [-121.32632, 39.32044], [-121.32753, 39.32028], [-121.32834, 39.32058], [-121.32835, 39.32083]]], [[[-121.33188, 39.34191], [-121.33189, 39.34216], [-121.33188, 39.34277], [-121.33121, 39.34476], [-121.32791, 39.34345], [-121.32665, 39.344], [-121.32726, 39.34514], [-121.32708, 39.34564], [-121.32807, 39.34709], [-121.32842, 39.34764], [-121.32772, 39.34845], [-121.3264, 39.34849], [-121.32679, 39.35054], [-121.32645, 39.35135], [-121.32611, 39.35143], [-121.32406, 39.35094], [-121.32355, 39.35201], [-121.32411, 39.3543], [-121.32393, 39.35623], [-121.32202, 39.35605], [-121.32233, 39.35703], [-121.32218, 39.35806], [-121.3208, 39.35861], [-121.32109, 39.3604], [-121.32114, 39.36108], [-121.32034, 39.36122], [-121.32035, 39.362], [-121.31996, 39.36193], [-121.31991, 39.36118], [-121.31898, 39.36126], [-121.31866, 39.36182], [-121.31683, 39.36169], [-121.31191, 39.36163], [-121.31381, 39.36072], [-121.31438, 39.35769], [-121.3151, 39.35558], [-121.3156, 39.35493], [-121.31674, 39.35424], [-121.31864, 39.35203], [-121.31711, 39.35045], [-121.31381, 39.35083], [-121.3124, 39.35023], [-121.31157, 39.34868], [-121.30954, 39.34808], [-121.30783, 39.347], [-121.3062, 39.34438], [-121.30459, 39.34319], [-121.3042, 39.34249], [-121.30412, 39.34039], [-121.30516, 39.33994], [-121.30606, 39.33992], [-121.30807, 39.33935], [-121.30808, 39.33857], [-121.3048, 39.33534], [-121.30563, 39.33302], [-121.30741, 39.33138], [-121.30729, 39.33068], [-121.3033, 39.32901], [-121.30466, 39.32782], [-121.30453, 39.32059], [-121.3106, 39.32065], [-121.31527, 39.32072], [-121.31837, 39.32456], [-121.31915, 39.32509], [-121.3195, 39.32553], [-121.32, 39.32597], [-121.32241, 39.32959], [-121.32248, 39.32994], [-121.32225, 39.3305], [-121.32237, 39.33074], [-121.32276, 39.3312], [-121.32426, 39.33264], [-121.32426, 39.33439], [-121.32584, 39.33452], [-121.32707, 39.33532], [-121.32707, 39.33704], [-121.32858, 39.33861], [-121.32912, 39.34105], [-121.33188, 39.34191]]], [[[-121.31524, 39.36175], [-121.31682, 39.36179], [-121.3186, 39.36191], [-121.31775, 39.36316], [-121.32079, 39.36518], [-121.32123, 39.36596], [-121.32097, 39.36688], [-121.31987, 39.36715], [-121.31905, 39.36651], [-121.31795, 39.36582], [-121.31713, 39.36478], [-121.31529, 39.36402], [-121.31306, 39.36412], [-121.31005, 39.36485], [-121.3087, 39.36396], [-121.30512, 39.36372], [-121.30466, 39.36234], [-121.30758, 39.36172], [-121.31033, 39.36236], [-121.31075, 39.36219], [-121.31169, 39.36174], [-121.31524, 39.36175]]]]} | Open Access 1 | 662 | Collins Lake Recreation Area | 720 | 2010 | Browns Valley Irrigation District 1174 | Special District 4 | Irrigation District 17 | http://www.bvid.org/ | Special District 4 | 2010 | Browns Valley Irrigation District 1114 | Special District 4 | Irrigation District 16 | http://www.collinslake.com/map | Yuba 25 | 1598.822 | Collins Lake Rec. Area | 0 | Local Recreation Area 3 | 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]);