units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_ID = 100, DES_TP = 82 and PARK_URL = "http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/EnglebrightLake.aspx"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10339 | 10339 | 10338 | {"type": "MultiPolygon", "coordinates": [[[[-121.24135, 39.28684], [-121.23651, 39.28669], [-121.23652, 39.28471], [-121.22354, 39.28431], [-121.22202, 39.29573], [-121.21133, 39.29659], [-121.21035, 39.30172], [-121.20619, 39.30182], [-121.20557, 39.30471], [-121.20725, 39.30472], [-121.20689, 39.30712], [-121.20508, 39.30696], [-121.20489, 39.30783], [-121.20483, 39.30774], [-121.20418, 39.30703], [-121.20377, 39.30672], [-121.20319, 39.30622], [-121.20249, 39.30582], [-121.20155, 39.30506], [-121.20105, 39.30451], [-121.20087, 39.30427], [-121.20022, 39.3035], [-121.19997, 39.3031], [-121.19991, 39.30282], [-121.19997, 39.30267], [-121.20025, 39.30234], [-121.20046, 39.30218], [-121.20207, 39.30133], [-121.20244, 39.30117], [-121.20281, 39.30095], [-121.2032, 39.30078], [-121.20354, 39.30061], [-121.20437, 39.30026], [-121.20475, 39.30006], [-121.20512, 39.2998], [-121.20546, 39.29962], [-121.20577, 39.2994], [-121.20612, 39.29924], [-121.20648, 39.29909], [-121.20679, 39.29895], [-121.2072, 39.2987], [-121.20782, 39.29819], [-121.20815, 39.29785], [-121.2085, 39.29753], [-121.20881, 39.29712], [-121.20912, 39.29676], [-121.2095, 39.29611], [-121.2096, 39.29592], [-121.20975, 39.29568], [-121.20998, 39.29541], [-121.21039, 39.295], [-121.21088, 39.2946], [-121.21114, 39.29435], [-121.21207, 39.29375], [-121.21274, 39.29342], [-121.21381, 39.29311], [-121.21406, 39.29307], [-121.21494, 39.29281], [-121.21523, 39.29262], [-121.21546, 39.2924], [-121.21574, 39.29205], [-121.21595, 39.29173], [-121.21609, 39.29148], [-121.2164, 39.2907], [-121.2165, 39.29017], [-121.21645, 39.28977], [-121.21631, 39.28929], [-121.21628, 39.28897], [-121.21616, 39.28835], [-121.21612, 39.28805], [-121.21616, 39.28774], [-121.21623, 39.28744], [-121.21645, 39.28671], [-121.21661, 39.2864], [-121.21681, 39.28607], [-121.21745, 39.28523], [-121.21768, 39.28496], [-121.21782, 39.28485], [-121.2182, 39.28442], [-121.21867, 39.28399], [-121.21899, 39.28372], [-121.21942, 39.28339], [-121.21973, 39.28319], [-121.2202, 39.283], [-121.22051, 39.28289], [-121.22077, 39.28277], [-121.22109, 39.28271], [-121.22141, 39.2826], [-121.22175, 39.28257], [-121.22206, 39.28248], [-121.22244, 39.28246], [-121.22292, 39.28237], [-121.22334, 39.28237], [-121.22369, 39.28234], [-121.22409, 39.28236], [-121.22453, 39.28234], [-121.22596, 39.28256], [-121.22671, 39.28277], [-121.22718, 39.28283], [-121.2277, 39.28297], [-121.22895, 39.28315], [-121.22977, 39.28312], [-121.23015, 39.28313], [-121.23052, 39.28307], [-121.23095, 39.28305], [-121.23135, 39.28298], [-121.23178, 39.28296], [-121.23216, 39.28289], [-121.23255, 39.28291], [-121.23338, 39.28288], [-121.23423, 39.283], [-121.2347, 39.28316], [-121.23522, 39.28327], [-121.23565, 39.2834], [-121.23654, 39.28369], [-121.2369, 39.28378], [-121.23728, 39.28394], [-121.23773, 39.28406], [-121.23812, 39.28418], [-121.2389, 39.28428], [-121.2393, 39.28437], [-121.2401, 39.28435], [-121.24134, 39.28417], [-121.24135, 39.28684]]], [[[-121.20869, 39.31124], [-121.20867, 39.31258], [-121.2083, 39.31239], [-121.208, 39.31226], [-121.20772, 39.31211], [-121.20752, 39.31196], [-121.20737, 39.31179], [-121.20734, 39.31159], [-121.20738, 39.31136], [-121.20717, 39.31138], [-121.20712, 39.31159], [-121.20717, 39.31185], [-121.20735, 39.31206], [-121.20758, 39.31223], [-121.20788, 39.31239], [-121.20819, 39.31253], [-121.20867, 39.31277], [-121.20861, 39.31834], [-121.2085, 39.32198], [-121.20371, 39.32243], [-121.20379, 39.32012], [-121.20377, 39.31996], [-121.20409, 39.31953], [-121.20418, 39.31929], [-121.20433, 39.31897], [-121.20437, 39.3188], [-121.20444, 39.31864], [-121.20459, 39.31843], [-121.20474, 39.3183], [-121.20489, 39.31824], [-121.20522, 39.31808], [-121.20543, 39.31792], [-121.20619, 39.31716], [-121.20631, 39.31694], [-121.20638, 39.31676], [-121.20634, 39.31644], [-121.20602, 39.31561], [-121.20579, 39.3144], [-121.20565, 39.31379], [-121.20567, 39.31323], [-121.20562, 39.3129], [-121.20554, 39.31254], [-121.20588, 39.31251], [-121.20615, 39.31247], [-121.20636, 39.31237], [-121.20639, 39.31233], [-121.20644, 39.31191], [-121.20637, 39.31145], [-121.20641, 39.31144], [-121.20661, 39.30901], [-121.2078, 39.30879], [-121.20778, 39.31132], [-121.20869, 39.31124]]], [[[-121.20618, 39.31226], [-121.20609, 39.31231], [-121.20585, 39.31235], [-121.20552, 39.31237], [-121.2055, 39.31153], [-121.20616, 39.31147], [-121.20623, 39.31191], [-121.20618, 39.31226]]], [[[-121.26953, 39.27667], [-121.26944, 39.28066], [-121.25986, 39.28062], [-121.25977, 39.27609], [-121.25976, 39.27595], [-121.26131, 39.27556], [-121.26204, 39.27528], [-121.2623, 39.27516], [-121.26299, 39.27488], [-121.26342, 39.27463], [-121.26341, 39.27655], [-121.26953, 39.27667]]], [[[-121.26953, 39.26553], [-121.2695, 39.27414], [-121.26479, 39.27387], [-121.26489, 39.27381], [-121.2651, 39.27362], [-121.26595, 39.27297], [-121.26647, 39.27238], [-121.26666, 39.27206], [-121.26675, 39.27166], [-121.26673, 39.27059], [-121.26669, 39.27027], [-121.26654, 39.26945], [-121.26638, 39.26906], [-121.26628, 39.26868], [-121.26612, 39.26829], [-121.2657, 39.26738], [-121.26548, 39.26695], [-121.26598, 39.26558], [-121.26953, 39.26553]]], [[[-121.27327, 39.23722], [-121.27325, 39.24134], [-121.2689, 39.24109], [-121.2689, 39.2409], [-121.26901, 39.24048], [-121.26914, 39.24012], [-121.26937, 39.23963], [-121.2698, 39.23901], [-121.26996, 39.23874], [-121.27044, 39.23823], [-121.27065, 39.23796], [-121.27086, 39.23774], [-121.27127, 39.23721], [-121.27327, 39.23722]]]]} | Open Access 1 | 18226 | Englebright Lake | 13557 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/EnglebrightLake.aspx | Yuba 25 | 735.901 | Englebright Lake | 0 | Resource Management Area 82 | 3 |
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]);