units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where DES_TP = 3 and MNG_AG_TYP = 16
This data as json, copyable, CSV (advanced)
MNG_AGENCY 3
ACCESS_TYP 2
MNG_AG_TYP 1
- Irrigation District · 3 ✖
DES_TP 1
- Local Recreation Area · 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16086 | 16086 | 16085 | {"type": "Polygon", "coordinates": [[[-118.08041, 34.18032], [-118.08026, 34.18034], [-118.08019, 34.18036], [-118.07973, 34.1804], [-118.07972, 34.18033], [-118.07957, 34.18014], [-118.07917, 34.18017], [-118.07918, 34.18035], [-118.07898, 34.18018], [-118.0788, 34.1802], [-118.07858, 34.1803], [-118.07861, 34.18249], [-118.07961, 34.18249], [-118.07961, 34.18269], [-118.0802, 34.18294], [-118.08025, 34.18311], [-118.08025, 34.18342], [-118.07962, 34.18343], [-118.07962, 34.18431], [-118.07949, 34.18439], [-118.07894, 34.18568], [-118.07885, 34.18607], [-118.07056, 34.1861], [-118.07142, 34.18298], [-118.07228, 34.18161], [-118.07299, 34.18017], [-118.07434, 34.17957], [-118.07436, 34.17906], [-118.07757, 34.17899], [-118.07797, 34.17919], [-118.07792, 34.17933], [-118.07788, 34.17966], [-118.07825, 34.17981], [-118.07858, 34.18005], [-118.07893, 34.18002], [-118.07894, 34.18], [-118.07891, 34.17982], [-118.07883, 34.17958], [-118.07892, 34.17933], [-118.07874, 34.17912], [-118.07879, 34.17897], [-118.07895, 34.17869], [-118.07911, 34.17836], [-118.07924, 34.17844], [-118.07914, 34.17871], [-118.07896, 34.17898], [-118.07893, 34.17912], [-118.079, 34.17919], [-118.07904, 34.1793], [-118.07895, 34.17959], [-118.07905, 34.17976], [-118.07907, 34.17992], [-118.07913, 34.18008], [-118.07953, 34.18006], [-118.07968, 34.18], [-118.07975, 34.17994], [-118.07984, 34.1799], [-118.07995, 34.17989], [-118.08004, 34.17991], [-118.08035, 34.17988], [-118.08036, 34.18003], [-118.0804, 34.18014], [-118.08039, 34.18025], [-118.08041, 34.18032]]]} | No Public Access 3 | 12340 | Kinneloa Irrigation District Open Space | 20674 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 126.684 | Kinneloa Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
16693 | 16693 | 16692 | {"type": "Polygon", "coordinates": [[[-120.00196, 37.03239], [-120.00171, 37.03243], [-120.00016, 37.03244], [-119.99943, 37.03242], [-119.99724, 37.03242], [-119.99579, 37.03241], [-119.99252, 37.03241], [-119.98734, 37.03239], [-119.98585, 37.0324], [-119.98511, 37.03239], [-119.98264, 37.03238], [-119.97899, 37.03232], [-119.979, 37.03958], [-119.97675, 37.03953], [-119.97457, 37.03941], [-119.97449, 37.03591], [-119.96991, 37.03582], [-119.9699, 37.03231], [-119.97086, 37.03233], [-119.97446, 37.03227], [-119.97437, 37.02492], [-119.9744, 37.02311], [-119.97465, 37.023], [-119.97595, 37.02177], [-119.97705, 37.02028], [-119.9795, 37.01914], [-119.98213, 37.0183], [-119.98262, 37.01829], [-119.98364, 37.01781], [-119.98429, 37.01744], [-119.9852, 37.01715], [-119.98573, 37.01685], [-119.98675, 37.01624], [-119.98722, 37.01571], [-119.98802, 37.0152], [-119.98904, 37.01478], [-119.98933, 37.01476], [-119.98986, 37.01509], [-119.99053, 37.0152], [-119.99118, 37.01519], [-119.99207, 37.01523], [-119.99284, 37.01517], [-119.99361, 37.01483], [-119.99386, 37.01459], [-119.99395, 37.0136], [-119.99422, 37.01325], [-119.99436, 37.01282], [-119.99459, 37.01265], [-119.99507, 37.01245], [-119.99623, 37.0122], [-119.99704, 37.01195], [-119.99831, 37.01198], [-119.99894, 37.01182], [-119.99942, 37.01152], [-120.00002, 37.01106], [-120.00027, 37.01077], [-120.00172, 37.01077], [-120.00185, 37.02526], [-120.00196, 37.03239]]]} | No Public Access 3 | 16739 | Madera Lake Park And Recreation Area | 21652 | 2275 | Madera Irrigation District 1173 | Special District 4 | Irrigation District 17 | http://www.madera-id.org/ | Special District 4 | 2275 | Madera Irrigation District 1113 | Special District 4 | Irrigation District 16 | Madera 48 | 1216.241 | Madera Lake Park And Rec. Area | 0 | Local Recreation Area 3 | 4 | |
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]);