UW-Macrostrat / map-ingestion

Managing ingestion of sources into burwell
1 stars 1 forks source link

Glacial and Surficial Geology in Allen County, Indiana #405

Open ericjohannes opened 5 years ago

ericjohannes commented 5 years ago

Name:

Rupp, R. F., digital compiler, 2007, SURFICIAL_GEOLOGY_IGS_ALLEN: Glacial and Surficial Geology in Allen County, Indiana (Indiana Geological Survey, scale 1:63,360, Polygon Personal GeoDatabase Feature Class)

Source URL:

https://iu.box.com/s/vn57z5v1k8dfbj17efj9oz3qj1wex735

Estimated scale:

large

Folder name:

Dataset names:

data/AllenCounty_SurficialGeology.shp

Number of bedrock polygons: 356 (surficial geology polygons)

Lithology field:

Time field:

Geologic_a (Geologic age of the map units)

Stratigraphy name field:

Description field:

Material (The sedimentological materials that make up the geologic units)

Comments field:

Origin (Origin and characteristics of the geologic map units) Landforms (The surface expression or geologic terrain of the geologic map unit) Geo_Sequen (Geologic sequence of the geologic map units)

Comments:

There is metadata on the shapfile in metadata/surficial_geology.txt

Abstract: This geodatabase feature class shows the surficial geology of Allen County, Indiana. This was originally digitized from Plate 5, Map of Allen County, Indiana showing near-surface glacial sequences in Fleming, A. H., 1994 The hydrogeology of Allen County, Indiana - a geologic and ground-water atlas: Indiana Geological Survey Special Report 57, 111p.

Todo:

aazaff commented 5 years ago

This one looks good to me, can you take a look @cvavrus

cvavrus commented 5 years ago

most of the geologic age column of the map units say 'Wisconsin', is this meant to be 'Wisconsinan'?

aazaff commented 5 years ago

I believe that is correct. @ericjohannes can you confirm?

ericjohannes commented 5 years ago

@cvavrus @aazaff Yes they are the same. I just checked with a geologist.

cvavrus commented 5 years ago

Great thanks!

Folder name: in_allen

Suggested inserts:

INSERT INTO maps.large (orig_id,source_id,name,age,descrip,strat_name,t_interval,b_interval,comments,geom) 
SELECT gid,1,geo_sequen,geologic_a,material,strat_name,late_id,early_id,concat_ws('; ',concat('origin: ',origin),concat('landforms: ',landforms)),ST_MakeValid(geom) FROM sources.in_allen where geom is not null;