450 likes | 786 Views
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
E N D
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 & Tricks10 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 multi-disciplined 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
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
ArcMapTips 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 Access ArcMap Excel • Solution: Create a Dynamic Link Between the Excel Table and ArcMap via Microsoft Access. • Map will Reflect Changes to the Excel Spreadsheet Automatically.
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 Modify All Elements Ungroup Elements 2 4 Convert to Graphics Group Text Elements 1 3 • Solution:Converting the Legend to Graphics and Grouping Text Elements Allows for Single-Step Font Style/Size Modifications.
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.03Rail 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 CaltrainCommuter Rail • 20% increase inRidership annually
Data Overview Data Acquisition • HJW Geospatial, Inc. providedOrthos and Planimetric Data • Hard copy maps(utilities & Right of Way) • Union Pacific Railroad PMV data(precision measurement vehicle)
Project Overview DataTraX ApplicationData 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 DevelopmentTechnical Discussion • Standard map functions(Zoom In/Out, Pan,Full Extent, ID Layer) • Redlining ability(Line, Polygon, Text) • Printing/Plotting • Customized reports foreach department • Standard Windowsinterface
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
Ramzi Bannura Ÿ National GIS Director(816) 527-2497 Ÿ rbannura@hntb.comArcGIS Tips & TricksShaun Martin Ÿ GIS Analyst(816) 527-2709 Ÿ sdmartin@hntb.comCustomizing ArcGIS using ArcObjects with VBAScott Rice Ÿ GIS Analyst(816) 527-2240 Ÿ srrice@hntb.comDataTraX: Desktop Rail Management SoftwareJim Vanderweide Ÿ Senior GIS Analyst(816) 527-2676 Ÿ jvanderweide@hntb.comField Data Collection SolutionsDavid Bayer Ÿ GIS Analyst(816) 527-2496 Ÿ dbayer@hntb.com