Transcript Corporate Business Services

Welcome to HNTB
Mapping and GIS Technology
Ramzi K. Bannura
National GIS Director
AGENDA
Introductions/Announcements
 HNTB/GIS Overview
 Customizing ArcGIS using ArcObjects with VBA
 ArcGIS Tips & Tricks
10 Minute Break
 DataTraX: Desktop Rail Management Software
 Field Data Collection Solutions
 Q&A
 Festivities: Tanner’s on Broadway

HNTB: Providing 88 Years of Service
In continuous operation since 1914
 Design offices nationwide
 More than 2,900 employees
 Our hallmark is outstanding design & quality work
 More than 2,100 current projects
 Nearly 1,000 active clients

HNTB: Providing 88 Years of Service
A pioneer in the transportation industry since 1914
 Expanded into aviation during WWII
 Maine Turnpike project launched expansion to toll
projects in 1945
 HNTB International Corporation formed in 1964
 Architectural, rail & environmental acquisitions during
the 1970s strengthened service line diversity
 1996: growth focus shifts to mega projects, national
infrastructure

Nine major discipline groups serve
an array of clients
Architecture
 Aviation
 Bridges & Tunnels
 Construction
 Environmental Engineering
 Rail Transportation
 Technology
 Transportation
 Urban Design & Planning

Our Typical Clients
Departments of Transportation (DOTs)
 Turnpike Authorities
 Metropolitan Planning Organizations
 Airports
 Rail Agencies
 Local Governments

Sampling of HNTB Projects
Invesco Field at MileHigh (Denver)
 Bartle Hall Expansion (Kansas City)
 Midway Airport (Chicago)
 Charles River Bridge (Big Dig-Boston)
 Golden Gate Bridge Retrofit (San Francisco)
 LionsGate Community Planning (Kansas City)
 I-70 Expansion Studies (Missouri)
 Grandview Triangle
 KCI Airport Terminal Improvements

One of the most successful multidisciplined firms in 2001
#1 US “pure” design firm
 #3 in aviation
 #4 in sports architecture
 #4 in transportation
– #4 in highways
– #10 in mass transit/light rail
 #4 in bridges

Source: ENR, April 16, 2001;
ENR Sourcebook, June, 2001
The GIS Connection

Support “Core Businesses” as a value-added service
especially in:
–
–
–
–
–
Aviation
Rail
Transportation
Urban Planning
Environmental
GIS Organization
National HQ in Kansas City
 60+ Offices nationwide
 23 Offices with GIS staff
 GIS Centers of Excellence

•
•
•
•
•
All - Kansas City
Aviation - Alexandria
Environmental - Chicago
Transportation - Dallas
Urban Planning - Indy
HNTB’ Main GIS Offices
GIS Projects Highlights
North Texas Tollway Authority - GIS-based Inventory
and Asset Management System
 Atlanta Hartsfield Intl. Airport - GIS Needs Assessment
and Implementation Plan
 Pierre Regional Airport - GIS-based Airport Land Plan
 Mitchell SD Airport - GIS-based Airport Land Plan
 I-70 Corridor Environmental Study/Impact Statement
 CalTrain - DataTraX Asset Management System
 Indianapolis Transportation Management System

The ESRI Connection

Strategic Partnership and Authorized Instructors
– ESRI - Corporate Business Partner
– ESRI - Authorized Instructors

GIS Training Classes available
– Intro to GIS
• coming soon!
– Intro to ArcGIS I
• Next Class - March 4-5: Sign up now!
• Classes offered quarterly or upon demand
– Migration to ArcGIS
Thank you!
ArcMap
Tips and Tricks
Shaun Martin
ArcMap Tips and Tricks: Printing/Plotting
 Printing/Plotting
Maps From ArcMap
– Submitted By: Shaun Martin / HNTB
 ArcPress:
Problematic Usage
– Rasterizing the image may take a long time.
– Ties up the computer until the rasterization process
is complete.
– May yield poor map quality. (Map may appear grainy
etc…)
ArcMap Tips and Tricks: Printing/Plotting
 Solution:
Export the Map as a .PDF Document
– Large (36x36) higher resolution maps export quickly.
– Yields a high level of cartographic quality.
ArcMap Tips and Tricks: Linking Excel
 Dynamically
Link an Excel Spreadsheet to an
ArcMap Layer.
– Submitted By: Scott Rice / HNTB

Point Location Data Stored and Updated in Excel.
– Constantly Performing Maintenance.
• Conversion From .xls to .txt or .dbf file format.
• Adding updated table to ArcMap and Updating
Links/Joins.
ArcMap Tips and Tricks: Linking Excel

Solution: Create a Dynamic Link Between the Excel
Table and ArcMap via Microsoft Access.
– Map will Reflect Changes to the Excel Spreadsheet
Automatically.
Access
Excel
ArcMap
ArcMap Tips and Tricks: Legend Edits
 Changing
Legend Font/Size by Grouping
Elements
– Submitted By: Justin Pummell / U.S. Army Corp. of Engineers

Modifying Legend Text Elements With Legend Wizard.
– Can be Very Time Consuming.
ArcMap Tips and Tricks: Legend Edits

1
Solution: Converting the Legend to Graphics and
Grouping Text Elements Allows for Single-Step Font
Style/Size Modifications.
Convert to
Graphics
2
Ungroup
Elements
Group Text
3 Elements
Modify All
4 Elements
ArcMap Tips and Tricks: Path Names

Map Document Data References - Full Vs. Relative
Path Names
– Submitted By: David Bayer / HNTB

If Full Path Names are Used, Data Links
May Break When Maps are Distributed
to Other Users.
– If the Map Contains Many Layers, Repairing Links can be a
Long, Slow Process
ArcMap Tips and Tricks

Solution: Using Relative Path Names Allows for Easy
Map / Data Distribution.
– ArcMap will look for data starting from the location on disk in
which the map is stored.
– Relative Path Example:
• G:\GIS_Stuff\ArcGIS\Projects\MapDocs\Data\etc...
ArcMap Tips and Tricks: ArcObjects Online
 Joe
Says: “A Site Every ArcGIS User Should
Have Book-marked”
– Submitted By: Joe Eckmann / ESRI

http://arconline.esri.com/ArcObjectsOnline/Samples/QuerySamples.asp
Customizing ArcGIS using
ArcObjects with VBA
Scott Rice
Custom Toolbar and Buttons
 11
buttons
 Download, download and modify, or code from
scratch
DataTraX v1.03
Rail Corridor Management System
Jim Vanderweide
Introduction to Project

Peninsula Corridor Joint Powers Board (PCJPB)

Part of $1 Billion, 6 year Capital Improvement Plan

77 Mile Caltrain
Commuter Rail

20% increase in
Ridership annually
System Architecture
Data Overview
Data Acquisition

HJW Geospatial, Inc. provided
Orthos and Planimetric Data

Hard copy maps
(utilities & Right of Way)

Union Pacific Railroad PMV data
(precision measurement vehicle)
Project Overview
DataTraX Application
Data Management Tool for Planning
DataTraX Development
User Requirements

User friendly Viewing and Query Tool

30 - 50 end users (engineers, planners, railroad
specialist)

Data management system capable of updates

Customized for individual departments within JPB

Capable of expanding functionality to meet future needs
Software Overview
DataTraX

ESRI MapObjects 2.0a

Legend Tools for MapObjects by MPN Components

C++ (Microsoft Visual C++ 6.0)

Oracle 8i (8.1.7)
Additional Software Provided

ArcGIS 8.1
DataTraX Development Technical Discussion

Standard map functions
(Zoom In/Out, Pan,
Full Extent, ID Layer)

Redlining ability
(Line, Polygon, Text)

Printing/Plotting

Customized reports for
each department

Standard Windows
interface
Future Development for Rail Management
Handheld Technology

Compaq iPAQ

Tablet PC
ArcIMS

Intranet/Internet Mapping Solutions
Additional Functionality

Additional Modules to DataTraX

Emergency Response

Automated Trackchart
DataTraX
Demo
Field Data Collection Solutions
David Bayer
What options do we have?
 Pocket
PC vs. Handheld PC/Palm/Tablet PC
– Windows CE Operating System
• Pocket PC, Handheld PC
– Palm Operating System
• Palm
– Windows OS - 2000/NT/XP
• Tablet PC ( it’s a laptop )
Why we chose Pocket PC
 Supported
by ESRI
– ArcPad bundled with iPAQ for $995
 Development
Environment
– Microsoft eMbedded Visual Tools
•
•
•
•
eMbedded Visual Basic
eMbedded Visual C++
develop for the Pocket PC and Handheld PC
free download at http://www.microsoft.com/mobile/developer/downloads/emvt30/
Data input methods in the Pocket PC
 Keyboard
 Handwriting
recognition
ArcPad & eMbedded VB
 ArcPad
– collect data in pre-existing shapefile (no database connectivity)
– integrates seamlessly with a GPS unit
– only customizable using extension for ArcView 3.x
(v6.0 will be customizable with Visual Basic Script)
 eMbedded
VB
– create a fully customized project
– no mapping
eMbedded VB & Pocket Access
 eMbedded
–
–
–
–
Visual Basic
subset of desktop Visual Basic
run application in emulator or on device
copies all the necessary .dll files to the device
connects to Pocket Access using ADOCE
 Pocket Access
database
– converts Access .mdb files
using ActiveSync
Projects
 Mobile
DataTraX
– supports desktop version
– utilizes GPS
 SIMON
– Station Information Manager ONline
 EAT
– in-house restaurant guide
Field Data Collection
Demo
Ramzi Bannura  National GIS Director
(816) 527-2497  [email protected]
ArcGIS Tips & Tricks
Shaun Martin  GIS Analyst
(816) 527-2709  [email protected]
Customizing ArcGIS using ArcObjects with VBA
Scott Rice  GIS Analyst
(816) 527-2240  [email protected]
DataTraX: Desktop Rail Management Software
Jim Vanderweide  Senior GIS Analyst
(816) 527-2676  [email protected]
Field Data Collection Solutions
David Bayer  GIS Analyst
(816) 527-2496  [email protected]