using gis to display well bore stratigraphy and analytical data in 3d
DESCRIPTION
Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D. April 9 th , 2009 Graham S. Hayes, Ph.D., GISP Wendel Duchscherer Architects & Engineers. Presentation Outline. GIS Overview Data Formats and Sources 3D Data Manipulation Hamden, CT Case Study Discussion. 123. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/1.jpg)
Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D
April 9th, 2009
Graham S. Hayes, Ph.D., GISP
Wendel DuchschererArchitects & Engineers
![Page 2: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/2.jpg)
Presentation Outline
GIS OverviewData Formats and Sources3D Data ManipulationHamden, CT Case StudyDiscussion
![Page 3: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/3.jpg)
What is a GIS?Geographic Information System
Management tool for maps & databasesTwo types of information: spatial data (location) and attribute data (descriptive)Capture, store, retrieve, analyze and display dataInformation stored in thematic layers
123
123Map Graphics(spatial data)
Tabular Tabular DatabasesDatabases(attributes)(attributes)
![Page 4: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/4.jpg)
GIS Models Real World Objects as Graphic Features
Points
Lines
Polygons
Text
![Page 5: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/5.jpg)
Presentation Outline
GIS OverviewData Formats and Sources3D Data ManipulationHamden, CT Case StudyDiscussion
![Page 6: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/6.jpg)
Data Formats and Sources
AttributesLocations, elevations, depth, sample results, etc.Excel, Access, GINT, text files, etc.
Map FeaturesVector
Points, Lines & PolygonsAttribute tables, CAD, GPS
RasterDigital Elevation Models (DEMs)Aerial Photos & Scanned USGS maps
Triangular Irregular Networks (TINs)
![Page 7: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/7.jpg)
Data Formats and Sources (continued)
Keys for Successful AttributesGather or compute X,Y and Z values if possible. Be consistent in recording elevations (e.g. ground, riser, casing, etc.)Store text in text fields, numbers in numeric fields. Don’t store depth ranges in mixed units in a single field.
depth
0-6”
2-4
12-18
start
0.0
2.0
12.0
end
0.5
4.0
14.0
thickness
0.5
2.0
6.0
![Page 8: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/8.jpg)
Data Formats and Sources (continued)
Keys for Successful Attributes (continued)
Use standard naming conventions for wells-IDs, sample-IDs, etc. (e.g. MW-105a; MW 105 a; MW105A)Be consistent in applying the standards. Relational databases live and die based on common IDs between tables.
Well-id
mw105mw106
mw107
start
0.0
2.0
12.0
end
0.5
4.0
14.0
thickness
0.5
2.0
6.0
Well-id
mw-105
mw-105
mw 105? ? ?
? ? ?elev
501.5539.2
495.7
![Page 9: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/9.jpg)
Data Formats and Sources (continued)
Keys for Successful Map FeaturesGather available basemap data from USGS and state GIS data clearing houses (e.g. DEMs, DOQQs, USGS quad sheets, basemap shapefiles, etc.)Use real world coordinates (state plane feet NAD83, UTM, etc.)
CAD data should be in model space (not paper space or mixed model and paper space)Elevation data in CAD should be stored as block attributes not just as textAvoid inset maps in CAD if porting data to GIS
![Page 10: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/10.jpg)
Presentation Outline
GIS OverviewData Formats and Sources3D Data ManipulationHamden, CT Case StudyDiscussion
![Page 11: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/11.jpg)
3D Data Manipulation
Data CreationCreate 3D surfaces from XYZ values
Raster GRIDs from point dataTINs from point, line and polygon data
Derive contours from 3D surfacesCompute areas and volumes from 3D surfacesConvert 2D vector data to 3D dataPerform visualization studies
![Page 12: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/12.jpg)
3D Data Manipulation (continued)
Data VisualizationDrape 2D or image data over raster or TIN surfaces Represent sample locations in 3DExtrude or offset 2D data by constant or attribute (e.g. building height, bore hole depth, thickness, etc.)
Symbolize attribute values by color and sizeSet transparency and illumination Create “fly through” animations
![Page 13: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/13.jpg)
Presentation Outline
GIS OverviewData Formats and Sources3D Data ManipulationHamden, CT Case StudyDiscussion
![Page 14: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/14.jpg)
Hamden, Connecticut
Since the early 1900’s, residents and factories in Hamden, CT dumped refuse into a low lying wetland.In 1932, Olin Corporation purchased Winchester Firearms and continued the practice of dumping slag and ash from their factory in the municipal dump.As recent as 1972, homes, parks, a school and sports fields have been constructed on top of the now filled wetland.
![Page 15: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/15.jpg)
Hamden, Connecticut (continued)
An environmental study determined that hazardous materials were present and remediation was necessary.Hired as a technical consultant by the law firm representing Olin Corporation to perform a forensic review of the landfill to:
determine the source and volume of the waste materialestablish the timing and aerial extent of the landfillvisualize the relationships between the waste material and the hazardous chemical components.
![Page 16: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/16.jpg)
1998 aerial photo showing the outline of the fill area.
![Page 17: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/17.jpg)
1949
19491943
1934 1965
1970 1975 1980
Summary of Filling at Hamden Middle School
![Page 18: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/18.jpg)
Historic photo (1980) draped over digital elevation model
![Page 19: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/19.jpg)
3D view of the original wetland elevation surface prior to filling
![Page 20: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/20.jpg)
3D view of the current elevation surface after filling
![Page 21: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/21.jpg)
3D view of the study area.
![Page 22: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/22.jpg)
3D view of the fill area and the contours of total fill thickness
![Page 23: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/23.jpg)
Concentration of Arsenic (mg/kg) above the RDEC of 10 mg/kgLarger symbols indicate higher concentrations.
![Page 24: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/24.jpg)
Concentration of Lead (mg/kg) above the RDEC of 400 mg/kg.Larger symbols indicate higher concentrations.
![Page 25: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/25.jpg)
Concentration of Benzo(a)pyrene (ug/kg) above the RDEC of 1,000 ug/kg. Larger symbols indicate higher concentrations.
![Page 26: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/26.jpg)
Aerial distribution and total thickness of all fill classes greater than 1.5 ft thick (4 foot contour interval).
![Page 27: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/27.jpg)
Aerial distribution and total thickness of refuse fill greater than 1.5 ft thick (4 foot contour interval).
![Page 28: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/28.jpg)
Aerial distribution and total thickness of waste fill greater than 1.5 ft thick (4 foot contour interval).
![Page 29: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/29.jpg)
Aerial distribution and total thickness of clean fill greater than 1.5 ft thick (4 foot contour interval).
![Page 30: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/30.jpg)
Tan = clean fillGrey = waste fillGreen = refuse fill
Landfill Stratigraphy & Geochemistry Landfill Stratigraphy & Geochemistry
Red = Arsenic
Green = LeadLight blue =
Benzo(a)pyrene
![Page 31: Using GIS to Display Well Bore Stratigraphy and Analytical Data in 3D](https://reader036.vdocuments.us/reader036/viewer/2022062802/56814499550346895db14187/html5/thumbnails/31.jpg)
Presentation Outline
GIS OverviewData Formats and Sources3D Data ManipulationHamden, CT Case StudyDiscussion