superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, ACRES = "1007.155", MNG_AGENCY = 224 and MNG_AG_TYP = 10
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13077 | 13077 | 13076 | {"type": "Polygon", "coordinates": [[[-124.34451, 40.58758], [-124.34408, 40.58838], [-124.34285, 40.59105], [-124.34249, 40.59163], [-124.33783, 40.59166], [-124.33233, 40.60439], [-124.33168, 40.60462], [-124.33165, 40.60564], [-124.33134, 40.60602], [-124.33079, 40.60662], [-124.3308, 40.60664], [-124.33151, 40.60664], [-124.33022, 40.60913], [-124.32982, 40.60918], [-124.32896, 40.61198], [-124.32649, 40.61594], [-124.32158, 40.62355], [-124.32121, 40.62438], [-124.32122, 40.6244], [-124.32207, 40.6244], [-124.32174, 40.62487], [-124.32148, 40.6253], [-124.32067, 40.62633], [-124.31908, 40.62879], [-124.31804, 40.63005], [-124.31602, 40.63243], [-124.31447, 40.6324], [-124.31497, 40.63061], [-124.31377, 40.62907], [-124.3105, 40.62791], [-124.30993, 40.6277], [-124.31108, 40.62767], [-124.31343, 40.62597], [-124.315, 40.62485], [-124.31565, 40.62354], [-124.31907, 40.6175], [-124.31932, 40.61312], [-124.32126, 40.61097], [-124.32141, 40.61087], [-124.32152, 40.61047], [-124.32167, 40.61013], [-124.32186, 40.60878], [-124.3221, 40.60856], [-124.32253, 40.60849], [-124.32272, 40.60837], [-124.32272, 40.60806], [-124.32275, 40.60788], [-124.32323, 40.60759], [-124.32342, 40.60735], [-124.32409, 40.60712], [-124.32521, 40.60694], [-124.32597, 40.60696], [-124.32662, 40.6071], [-124.32697, 40.60712], [-124.32698, 40.60711], [-124.32696, 40.60664], [-124.32654, 40.60662], [-124.32431, 40.60244], [-124.32397, 40.60225], [-124.32359, 40.60228], [-124.31857, 40.59885], [-124.31826, 40.59874], [-124.31755, 40.5987], [-124.31498, 40.59885], [-124.31499, 40.59155], [-124.31463, 40.59152], [-124.31461, 40.5913], [-124.321, 40.59123], [-124.32104, 40.59159], [-124.33085, 40.5917], [-124.33084, 40.58965], [-124.34044, 40.58958], [-124.34041, 40.58769], [-124.34451, 40.58758]]]} | Open Access 1 | Eel River Estuary Preserve | 31669 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 1007.155 | Eel River Estuary Preserve |
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]);