superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 44 and YR_EST = 1959
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14671 | 14671 | 14670 | {"type": "MultiPolygon", "coordinates": [[[[-119.29929, 35.90624], [-119.29923, 35.91165], [-119.29481, 35.91165], [-119.29478, 35.90985], [-119.29034, 35.90984], [-119.29033, 35.90623], [-119.29929, 35.90624]]], [[[-119.33321, 35.9009], [-119.3332, 35.90268], [-119.33097, 35.90273], [-119.33098, 35.90092], [-119.33321, 35.9009]]], [[[-119.34447, 35.89873], [-119.33996, 35.89874], [-119.33988, 35.89595], [-119.34441, 35.89591], [-119.34447, 35.89873]]], [[[-119.37569, 35.93517], [-119.36695, 35.93521], [-119.36693, 35.93526], [-119.35817, 35.9353], [-119.35815, 35.93524], [-119.35364, 35.93525], [-119.35338, 35.92068], [-119.34007, 35.92066], [-119.34006, 35.9206], [-119.33998, 35.9206], [-119.33992, 35.90621], [-119.35775, 35.90616], [-119.37553, 35.90605], [-119.37552, 35.9206], [-119.37569, 35.93517]]], [[[-119.42609, 35.92014], [-119.4248, 35.92016], [-119.42477, 35.92379], [-119.42029, 35.92382], [-119.42029, 35.9202], [-119.40463, 35.92038], [-119.40462, 35.92221], [-119.40236, 35.92225], [-119.4023, 35.92778], [-119.39344, 35.92788], [-119.39349, 35.93508], [-119.37584, 35.93516], [-119.37569, 35.92059], [-119.3757, 35.90605], [-119.39353, 35.90593], [-119.41141, 35.90576], [-119.41143, 35.90584], [-119.4155, 35.90579], [-119.42029, 35.9123], [-119.42032, 35.91292], [-119.42076, 35.91292], [-119.42609, 35.92014]]], [[[-119.4155, 35.96387], [-119.39333, 35.96398], [-119.39331, 35.94974], [-119.41547, 35.9495], [-119.4155, 35.96387]]], [[[-119.48434, 36.03645], [-119.48248, 36.03648], [-119.48248, 36.05084], [-119.47347, 36.05086], [-119.47357, 36.03648], [-119.47365, 36.03646], [-119.47364, 36.02559], [-119.46468, 36.02561], [-119.46468, 36.0365], [-119.45575, 36.03654], [-119.4557, 36.04372], [-119.44681, 36.04375], [-119.44682, 36.04235], [-119.44695, 36.0366], [-119.4468, 36.02196], [-119.45868, 36.02197], [-119.45872, 36.01833], [-119.46173, 36.01834], [-119.46172, 36.02197], [-119.46466, 36.02197], [-119.47358, 36.02194], [-119.47758, 36.02556], [-119.4814, 36.02553], [-119.4826, 36.02723], [-119.48434, 36.03645]]]]} | No Public Access 3 | Pixley National Wildlife Refuge | 23755 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 6975.184 | Pixley NWR | 1959 |
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]);