UW-Macrostrat / map-ingestion

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

Columbus, Indiana #511

Open rleverett opened 4 years ago

rleverett commented 4 years ago

Name: Loope, H. M., Rupp, R. F., and Hasenmueller, W. A., 2014, Preliminary Quaternary geologic map of the Columbus 7.5-minute quadrangle, Indiana: Indiana Geological Survey Open-File Study 14-03, scale 1:24,000.

Source URL: Data: https://iu.box.com/s/gtx0dj03lldbs4459lkx3mq3yp33gb31 Publication: https://igws.indiana.edu/bookstore/details.cfm?Pub_Num=OFS14-03

Estimated scale: large

Folder name: Columbus

Dataset names: in_columbus

Number of bedrock polygons: 181

Lithology field:

Time field: age_1

Stratigraphy name field: strat_name

Description field: unitdescri

Comments field:

Comments:

Todo:

rleverett commented 4 years ago

Labeled the early_id and late_id of the units for which the age was listed as 'Illinoian' as the id for Pleistocene.

Suggested Inserts:

INSERT INTO maps.large (orig_id,source_id,name,age,descrip,strat_name,t_interval,b_interval,geom) 
SELECT gid,1,unitname_1,age_1,unitdescri,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.in_columbus where geom is not null;