Monterrey, CA

[jczaplew]

Info

Name: GEOLOGIC MAP OF THE MONTEREY 30'X60' QUADRANGLE AND ADJACENT AREAS, CALIFORNIA

Source URL: GIS Data - ftp://ftp.consrv.ca.gov/pub/dmg/rgmp/Published_GIS_Data/RGM_001_Monterey_100k_v1/RGM_001_Monterey_100k_v1.zip PDF Descriptions - ftp://ftp.consrv.ca.gov/pub/dmg/pubs/rgm/RGM_001/monterey_pamphlet.pdf

Estimated scale: large

Number of bedrock polygons:

Lithology field: description Time field: age Stratigraphy name field: strat_name Description field:

Comments field:

Comments:

Todo:

• [x] Insert new source record
• [x] Add data to database
• [x] Process and add to homogenized tables
• [x] Process and import lines
• [ ] Process and import points
• [x] Match
• [x] Roll tiles

[vkhoo]

@cambro two point types i need clarification on, would this be okay?

update sources.ca_monterrey_point set point_type='plunge' where pttype ILIKE '%plunge direction%'; update sources.ca_monterrey_point set point_type='fault' where pttype ILIKE '%fault dip%';

[cambro]

looks ok for now. i'll double check.

[cambro]

There are strat_names that are missing and/or incomplete in this source too @vkhoo I am going to fix them, but please double check sources for accuracy and completeness before submitting.

[cambro]

@vkhoo the polygon table also has early_id and late_id defined as text. Please define these always as integers to avoid hassle and to insure data integrity.

[cambro]

@vkhoo the faults in this source are not identified properly in the new_type column. e.g., "thrust fault, concealed" is listed as "fault" This should have a new_type value of "thrust fault"

I will fix, but please double check sources for accuracy and completeness before submitting.

[cambro]

@vkhoo plunge measurements do not have a dip_direction. They have a strike (trend) and a plunge (dip). you will have to clarify what these dip_dir values mean in the sources table for plunges

[cambro]

@vkhoo and @jczaplew the lines table for this source, once again, lacks a gid, which is impossible if it is imported correctly. I need an answer for how this is happening please.

[cambro]

source_id 139 NOTE POINTS ARE NOT DONE.