Introduction to gINT

1. Introduction to gINT Gary Logan and Ian Joyce gINT EMEA

2. Agenda – Morning Session (10.15 – 12.30) Introduction to gINT software What is gINT? Who uses gINT? What problems does gINT address? gINT integration with other Bentley products gINT support for enterprise subsurface data management The next release gINT V8i - What is included? Note – Coffee Break 11.15 – 11.30 Lunch – 12.30 – 13.15

3. Agenda – Afternoon Session (13:15 – 15.45) Open Discussion What’s the next step? Data exchange and transfer of existing datasets from/to gINT Localization of gINT. Standard Templates etc. for Denmark Training. What’s needed to get started? Knowledge sharing – work group under the Bentleyuser.dk Civil SIG? Note – Coffee Break 14.30 – 14.45 gINT in Denmark Examples of onshore and offshore gINT logs that have been developed by Jens Galsgaard and Stine Fogh from GEO

4. Brief overview of gINT Company started in 1986 by Salvatore Caronna Currently over 8000 licenses in 68 countries Acquired by Bentley in October 2009.

5. What is gINT • Used: • For data storage • For data validation • For data queries • For data reporting • Data sharing with other programs • gINT is a database manager and reporting engine for subsurface exploration

6. Target Audience (Who needs gINT) Anyone who investigates the subsurface or utilizes subsurface data could use gINT. • Because gINT is reporting engine and manages data it is used as a standalone program for subsurface reporting by primary users • Because gINT is database it is used as a subsurface data repository (geotechnical and geoenvironmental) by subsurface data consumers – secondary users

7. Target Audience (Who needs gINT) Primary gINT users (use gINT as standalone software) are: • Geotechnical Engineers and Engineering Geologists • Treat soil and rock as engineering materials to be analyzed for the design of civil structures (foundations, slope stability, retaining walls, tunnels, etc.). • Environmental Scientists • Investigate what hazardous/polluting materials are underground and how to implement site remediation. • Mining Specialists • Searching for ore bodies and designing civil structures for mine construction.

8. Target Audience (Who needs gINT) Secondary gINT users (subsurface data consumers) are: • GIS Analysts • Display subsurface data on the map in terms of point/location/borehole attributes, exposing gINT data within GIS environment, calling for borehole logs, subsurface profiles and other reports directly from GIS environment. • Civil Engineers • In road design and land development to determine and model subsurface strata such as bottom of fill and top of bedrock, create thematic maps, calculate volumes, create isopachs, etc. • Structural Engineers • In determining soil properties for analysis of soil-structure interaction and foundations • Water Resources, Hydraulic and Hydrologic Testing • Determine subsurface strata, Hydrologic soils designation on topography maps, hydraulic conductivity, etc.

9. gINT Clients Transportation and Government Agencies • 32 US State DOTs (96 offices) • US Army Corps of Engineers(36 offices) • US Bureau of Reclamation(13 offices) • USDA NRCS (11 offices) • US Geological Survey • EPA • Federal Highways Administration(3 offices) • 6 Canadian Provincial Ministries of Transportation • Agriculture Canada • UK Local Authoritiesincluding Cornwall, Lancashire, and Leeds • Queensland Main Roads Department, Australia • Roads & Traffic Authority, NSW, Australia • NSW Department of Water and Energy, Australia

10. gINT Clients Leading Consultants • AECOM (78 offices) • AMEC (73 offices) • ARUP (24 offices) • ATC Associates (25 offices) • CDM (20 offices) • CH2M HILL (16 offices) • Conestoga-Rovers (18 offices) • Fugro (28 offices) • Golder Associates (56 offices) • Kleinfelder (39 offices) • Ramboll • MACTEC (23 offices) • Montgomery Watson Harza (22 offices) • PSI (56 offices) • Stantec (Secor) (22 offices) • Shaw Group (34 offices) • Terracon (80 offices) • Tetra Tech (28 offices) • URS Corporation (101 offices) • WSP (27 offices)

11. gINT as Standalone Program

12. What is gINT • Used: • For data storage • For data validation • For data queries • For data reporting • Data sharing with other programs • gINT is a database manager and reporting engine for subsurface exploration

13. How subsurface data is managed • Paper • Excel • CAD • Database

14. How subsurface data is managed (paper)

15. Data Collection and Consolidation Electronic Field Data PDA Paper Data Other Software & Formats Lab Data

16. Types of subsurface data reports Borehole logs and well logs Data re-usability!

17. Types of subsurface data reports Fences, cross-sections/profiles Data re-usability!

18. Types of subsurface data reports Lab reports, tables, graphs and summaries Data re-usability!

19. Reports

20. Reports

21. Site Maps

22. Smart Reports

23. Data re-usability! Complex reporting

24. Surfaces

25. Surfaces

26. Alignments

27. Alignments

28. Associate site maps with projects drawings (DXF, LandXML, or hand drawn) Raster images

29. Zones

30. gINT as Subsurface Data Repository

31. What is gINT • Used: • For data storage • For data validation • For data queries • For data reporting • Data sharing with other programs • gINT is a database manager and reporting engine for subsurface exploration

32. Reusing data

33. gINT - central repository (Interoperability) • Powered by Bentley, but can be used as a central repository of subsurface data by a range of engineering software MicroStation InRoads MXROAD GEOPAK Geo Web Publisher

34. gINT – Bentley Interoperability • MicroStation/Navigator gINT can supply Logs and Fences (Profiles) to Microstation via DXF. Data re-usability!

35. gINT – Bentley Interoperability • MicroStation • InRoads • MXROADS • GEOPAK gINT can supply data for sub-surfaces: Bedrock, FILL, Water table, etc. For creating contours, isopach thematic maps (depths, soil classification) Volume cals: Rock cut, soil replacement Data re-usability!

36. gINT – Bentley Interoperability • MicroStation • InRoads • MXROADS • GEOPAK gINT can supply data for boring locations (site map), profiles, sections and 3D visualisation in GEOPAK Data re-usability!

37. gINT – Fine Software Interoperability • GEO5 suite gINT can supply subsurface data to GEO5, geotech software package for foundation design, sheet piling design, retaining wall design, stability analysis, settlement analysis and FEM analysis. Data re-usability!

38. Publish boreholes to Google Earth • Click on borehole to display details • Customizable icons show hole types or data characteristics

39. gINT – Google Earth Interoperability gINT for Google Earth Create .kml files, harvest data, link to logs, reports and images Data re-usability!

40. gINT – ESRI Interoperability gINT for ArcGIS add-in View, report and query gINT data from ArcGIS Data re-usability!

41. Which product is right? gINT Logs (Logs Only) gINT Professional All reporting MS Access based gINT Professional Plus MS SQL Server based Includes gINT for ArcGIS

42. gINT Professional Plus Offers centralized data storage, multi-project reporting and dramatically extended querying power. Uses MS SQL Server back- end, not the MS AccessTM database used in the standard versions of gINT Enables users to enforce consistency across all data resources. gINT Professional Plus

43. Reference Materials • gINT Web site (www.bentley.com/gINT) • gINT OnDemand eSeminars:http://www.bentley.com/en-US/Corporate/Events/OnDemand/gINT+OnDemand+eSeminars.htm • Live Civil eSeminarshttp://www.bentley.com/en-US/Corporate/Events/Live+eSeminars/Civil/Civil+Live+eSeminars.htm • 3D Visualization of gINT Subsurface Data in MicroStation • gINT Integration with InRoads and GEOPAK

44. SummaryWhy gINT and a Good Database is Necessary • Centralizes control of your subsurface data (field and lab) • Standardizes storage and reporting • Improves data accuracy/quality (QA/QC) • Automates complex data management processes • Transforms raw data into information via reports • Eliminates redundant data entry • Data reusability: different reports, export, evaluation • Data reusability: interoperability with other software

45. The Next Release gINT V8i – What is included? • Expected release by the end of Q1 2011 • This release marks the end of the second phase of the integration with Bentley. The first phase was completed with an update released in June 2010. That release incorporated SELECTserver licensing and was the first build available from SELECTserver downloads. • Last major release was September 2008. • Over 100 new capabilities in the V8irelease.

46. gINT V8i ProjectWise Integration: • Except for a few places where it was not appropriate, everywhere in gINT where a file can be opened or saved the user can select to use ProjectWise. • This gives a central repository for all files related to gINT which would be stored with all other files related to the user’s projects. • The most common uses for this feature by our users: • Electronic data files that are imported into the gINT database. • Raster images (photos, aerial photos, etc.) that are also imported into the gINT database. • Exported final reports from gINT: PDF, DGN, Excel, KML (Google Earth), and data for import to analysis programs.

47. gINT V8i • DGN (Bentley Design File) Export • Allows export of all reports and gINT drawings to MicroStation and many other programs that support DGN. • This supersedes the use of the gINT DXF (v12) export format that our users have been using for many years. The DGN export eliminates the main complaints of that format: Inaccurate font translations and the inability to set entity properties by level. • The most common use for this feature by our users is to import gINT reports into final design drawings, usually for roads and bridges. • ECW Support • Enhanced Compression Wavelet files are highly compressed raster images that are very fast to render. They are also geocoded, that is, the location of the image is embedded within the file.

48. gINT V8i • Coordinate Conversions • gINT has incorporated the MicroStation coordinate conversion libraries. • Allows users to specify a project coordinate system. Entering North and East coordinates generates corresponding WGS84 Latitude and Longitude and visa versa.

49. gINT V8i • Coordinate Conversions (continued) • With output using an SQL Server database with multiple projects that have different coordinate systems, the program automatically resolves their coordinates to a common system. • The most common uses of this feature by our users: • For many organizations borehole locations are many times surveyed using GPS devices which give only latitude and longitude. gINT needs projected coordinates to accurately plot features in plan (site maps) and profile (fence diagrams). A utility feature provides a list of projected systems that cover any specified latitude and longitude. Selecting one of these project systems for the project coordinate system, the latitude and longitudes can be entered and the north and east automatically calculated by the program. • Organizations may have two or more adjacent projects with different coordinate systems and they would like to run reports on the combined projects. The new feature allows such reporting to occur with accurate relative locations of the boreholes.

50. gINT V8i • AGS4 Support • In 1992 the UK Association of Geotechnical and Geoenvironmental Specialists (a trade organization; www.ags.org.uk) published the first version of a data interchange format for geotechnical and geoenvironmental investigations. gINT was the first program that supported it. • gINT has always supported upgrades to the format. Version 4 is no exception. • The format has spread to Ireland, Hong Kong, New Zealand, Australia, Singapore, and the Middle East and is required by consultants from these countries doing work throughout the world. • With many consultants and government agencies all work requires the use of the format.