units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and MNG_AGENCY = 802
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6035 | 6035 | 6034 | {"type": "Polygon", "coordinates": [[[-121.32629, 39.06195], [-121.3262, 39.06219], [-121.32455, 39.06449], [-121.32446, 39.06432], [-121.32444, 39.06432], [-121.32419, 39.06471], [-121.32392, 39.06495], [-121.32362, 39.06511], [-121.32323, 39.0652], [-121.3161, 39.06519], [-121.31608, 39.06617], [-121.31433, 39.06532], [-121.3141, 39.06518], [-121.30308, 39.06511], [-121.30316, 39.05903], [-121.30234, 39.05904], [-121.30219, 39.06131], [-121.30048, 39.06088], [-121.29973, 39.063], [-121.2979, 39.06267], [-121.29789, 39.06268], [-121.30002, 39.06449], [-121.30005, 39.06509], [-121.30003, 39.06523], [-121.30003, 39.06702], [-121.29874, 39.07054], [-121.29861, 39.07061], [-121.29861, 39.07063], [-121.29912, 39.07649], [-121.29815, 39.0768], [-121.29621, 39.07433], [-121.29611, 39.07433], [-121.29376, 39.07127], [-121.29003, 39.06663], [-121.28899, 39.06697], [-121.29008, 39.07248], [-121.29071, 39.07538], [-121.28975, 39.07786], [-121.28859, 39.07771], [-121.28628, 39.07357], [-121.28378, 39.07411], [-121.2829, 39.0729], [-121.28181, 39.07132], [-121.27987, 39.06846], [-121.27983, 39.06845], [-121.2798, 39.05769], [-121.28011, 39.05769], [-121.28021, 39.05905], [-121.28266, 39.0583], [-121.28575, 39.06172], [-121.2873, 39.05932], [-121.28634, 39.05701], [-121.28865, 39.05585], [-121.2912, 39.05689], [-121.29121, 39.05687], [-121.2911, 39.05667], [-121.29189, 39.05631], [-121.28812, 39.05453], [-121.28805, 39.05341], [-121.29046, 39.05328], [-121.29085, 39.05108], [-121.28921, 39.0502], [-121.28655, 39.0509], [-121.28622, 39.04977], [-121.28722, 39.04823], [-121.28597, 39.0479], [-121.28576, 39.04397], [-121.28468, 39.04312], [-121.28452, 39.03597], [-121.28511, 39.03603], [-121.28584, 39.03619], [-121.28631, 39.03622], [-121.28664, 39.03628], [-121.28705, 39.0364], [-121.28782, 39.0365], [-121.28815, 39.03653], [-121.28886, 39.03665], [-121.28918, 39.03668], [-121.28976, 39.03684], [-121.29029, 39.03701], [-121.29044, 39.03713], [-121.29096, 39.03743], [-121.29124, 39.03767], [-121.29153, 39.03808], [-121.29165, 39.03833], [-121.29172, 39.03857], [-121.29183, 39.03922], [-121.29194, 39.03973], [-121.29194, 39.04016], [-121.292, 39.04057], [-121.29218, 39.04119], [-121.2924, 39.04171], [-121.29256, 39.04195], [-121.29294, 39.04271], [-121.29322, 39.04352], [-121.29374, 39.0442], [-121.29393, 39.04442], [-121.29423, 39.04465], [-121.29499, 39.04498], [-121.29522, 39.04504], [-121.29582, 39.04531], [-121.29638, 39.04563], [-121.29686, 39.04582], [-121.29723, 39.04607], [-121.29798, 39.0465], [-121.29831, 39.04665], [-121.29883, 39.04696], [-121.29931, 39.04716], [-121.29954, 39.0473], [-121.29976, 39.04739], [-121.29996, 39.0475], [-121.30013, 39.04753], [-121.30028, 39.04753], [-121.30058, 39.04749], [-121.3011, 39.04748], [-121.30138, 39.0475], [-121.30164, 39.04757], [-121.30189, 39.04762], [-121.30211, 39.04773], [-121.30231, 39.04788], [-121.30246, 39.04793], [-121.30265, 39.04815], [-121.30291, 39.04861], [-121.30299, 39.04872], [-121.30318, 39.04943], [-121.30332, 39.04984], [-121.30343, 39.05046], [-121.30356, 39.05083], [-121.30379, 39.05124], [-121.3044, 39.05211], [-121.30468, 39.05236], [-121.30483, 39.05246], [-121.30537, 39.05274], [-121.3056, 39.05281], [-121.30587, 39.05292], [-121.3061, 39.05296], [-121.30634, 39.05304], [-121.30662, 39.05304], [-121.30688, 39.05308], [-121.30707, 39.05306], [-121.30728, 39.05296], [-121.30749, 39.05294], [-121.30845, 39.05275], [-121.30909, 39.05266], [-121.30945, 39.05256], [-121.30984, 39.05248], [-121.31023, 39.05235], [-121.31061, 39.05227], [-121.31098, 39.05221], [-121.31185, 39.05189], [-121.31233, 39.05163], [-121.3131, 39.05124], [-121.31358, 39.05106], [-121.31402, 39.05085], [-121.31473, 39.05047], [-121.31508, 39.05034], [-121.31558, 39.05011], [-121.31596, 39.04998], [-121.31624, 39.04985], [-121.31739, 39.04955], [-121.31768, 39.0495], [-121.31799, 39.04939], [-121.31864, 39.04921], [-121.31867, 39.04924], [-121.32036, 39.04907], [-121.32101, 39.05002], [-121.32242, 39.05154], [-121.3224, 39.05322], [-121.32191, 39.05332], [-121.32212, 39.05379], [-121.32241, 39.05528], [-121.32242, 39.05557], [-121.3223, 39.0563], [-121.3223, 39.0565], [-121.32236, 39.05663], [-121.32256, 39.05692], [-121.32274, 39.05712], [-121.3238, 39.05846], [-121.3239, 39.05846], [-121.32525, 39.06021], [-121.32623, 39.0616], [-121.32629, 39.06195]]]} | Open Access 1 | 736 | Camp Far West Reservoir | 12744 | 2159 | South Sutter Water District 824 | Special District 4 | Water District 13 | http://www.foothillswaternetwork.org/about%20us/interactive-journey/ssw.php | Special District 4 | 2159 | South Sutter Water District 802 | Special District 4 | Water District 13 | http://www.campfarwestlake.net/aboutus.htm | Yuba 25 | 1968.35 | Camp Far West Reservoir | 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]);