superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LAYER = 13 and PARK_NAME = "Eastman Lake Recreation Area"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
ACCESS_TYP 1
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15395 | 15395 | 15394 | {"type": "MultiPolygon", "coordinates": [[[[-119.94779, 37.25909], [-119.94775, 37.26382], [-119.94675, 37.26382], [-119.94674, 37.26483], [-119.94503, 37.26985], [-119.94474, 37.27009], [-119.94424, 37.27246], [-119.94437, 37.27537], [-119.94326, 37.27538], [-119.94243, 37.27536], [-119.94148, 37.27657], [-119.94151, 37.27762], [-119.94062, 37.2785], [-119.94015, 37.27833], [-119.94084, 37.27763], [-119.94085, 37.27618], [-119.94138, 37.27541], [-119.94136, 37.2754], [-119.94115, 37.2754], [-119.94116, 37.273], [-119.94114, 37.27299], [-119.94097, 37.27313], [-119.94097, 37.27205], [-119.94087, 37.27203], [-119.94306, 37.26793], [-119.94208, 37.26436], [-119.94209, 37.26357], [-119.94315, 37.26357], [-119.94317, 37.2608], [-119.94466, 37.26018], [-119.94779, 37.25909]]], [[[-119.99489, 37.21396], [-119.99319, 37.21529], [-119.9937, 37.21564], [-119.99236, 37.21649], [-119.99222, 37.21684], [-119.99187, 37.21731], [-119.9913, 37.2177], [-119.99099, 37.21789], [-119.9909, 37.21838], [-119.99253, 37.22083], [-119.99181, 37.22085], [-119.99257, 37.22295], [-119.99243, 37.22356], [-119.99144, 37.22427], [-119.99121, 37.22454], [-119.99103, 37.2248], [-119.9907, 37.22633], [-119.9887, 37.22794], [-119.98861, 37.22798], [-119.9886, 37.23384], [-119.98853, 37.23386], [-119.98854, 37.23482], [-119.98821, 37.23507], [-119.98808, 37.23872], [-119.98571, 37.23875], [-119.98559, 37.24224], [-119.98871, 37.24225], [-119.98871, 37.24573], [-119.9876, 37.24574], [-119.98755, 37.24764], [-119.98419, 37.24763], [-119.98418, 37.24862], [-119.9796, 37.2486], [-119.97958, 37.24951], [-119.9762, 37.24953], [-119.9762, 37.24865], [-119.97504, 37.24863], [-119.97502, 37.24818], [-119.97196, 37.24819], [-119.97282, 37.2475], [-119.97278, 37.24745], [-119.97177, 37.24826], [-119.96593, 37.2482], [-119.96588, 37.24454], [-119.96378, 37.24454], [-119.96375, 37.2453], [-119.96138, 37.24534], [-119.96132, 37.24558], [-119.96135, 37.24559], [-119.96128, 37.24649], [-119.95539, 37.24648], [-119.95529, 37.24817], [-119.95207, 37.24814], [-119.95204, 37.24899], [-119.95001, 37.24902], [-119.94997, 37.25445], [-119.95105, 37.25449], [-119.95106, 37.25626], [-119.94782, 37.25634], [-119.94779, 37.25891], [-119.94457, 37.26003], [-119.94317, 37.26061], [-119.94318, 37.25894], [-119.94266, 37.25893], [-119.94269, 37.25704], [-119.9432, 37.25703], [-119.94328, 37.24635], [-119.94774, 37.24641], [-119.94769, 37.24539], [-119.95098, 37.24542], [-119.951, 37.24457], [-119.95211, 37.24453], [-119.95216, 37.24259], [-119.95324, 37.24259], [-119.96301, 37.23349], [-119.96293, 37.22462], [-119.96158, 37.22456], [-119.96156, 37.21384], [-119.96165, 37.21382], [-119.96164, 37.20629], [-119.97386, 37.20627], [-119.97391, 37.2043], [-119.97962, 37.20427], [-119.97963, 37.20464], [-119.9803, 37.20465], [-119.98033, 37.20694], [-119.97963, 37.20696], [-119.97963, 37.20901], [-119.97984, 37.20938], [-119.98042, 37.20981], [-119.98113, 37.21004], [-119.98154, 37.21039], [-119.98192, 37.21082], [-119.98235, 37.21166], [-119.98252, 37.21206], [-119.98306, 37.21247], [-119.98353, 37.21254], [-119.98392, 37.21254], [-119.98448, 37.21241], [-119.986, 37.21198], [-119.9863, 37.21232], [-119.98571, 37.21267], [-119.9857, 37.21269], [-119.98621, 37.21304], [-119.98642, 37.21306], [-119.98711, 37.2134], [-119.98813, 37.21293], [-119.98936, 37.21197], [-119.98967, 37.21182], [-119.98995, 37.21178], [-119.99029, 37.21194], [-119.99037, 37.21207], [-119.9904, 37.21208], [-119.99081, 37.21297], [-119.99085, 37.21324], [-119.99118, 37.2137], [-119.99102, 37.21462], [-119.99168, 37.21469], [-119.99219, 37.2148], [-119.99306, 37.21425], [-119.99361, 37.21388], [-119.99395, 37.21354], [-119.99404, 37.21342], [-119.9943, 37.21342], [-119.99484, 37.21368], [-119.99489, 37.21396]], [[-119.95361, 37.24704], [-119.95361, 37.24702], [-119.95304, 37.247], [-119.95302, 37.24704], [-119.95361, 37.24704]]]]} | Open Access 1 | Eastman Lake Recreation Area | http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/EastmanLake.aspx | 13556 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 3253.279 | Eastman Lake Rec. Area |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);