LOCATION BASED DECISION SUPPORT

GIS FOR MANAGERS AND ADMINISTRATORS

James E. Mitchell, Ph. D. Geospatial Services Manager Louisiana Office of Technology Services Kurt L. Johnson IT GIS Technical Specialist Louisiana Office of Technology Services Jennifer Harrison President Inner Corridor Technologies, Inc./TeachMeGIS

2016 LOUISIANA TRANSPORTATION

CONFERENCE

MARCH, 2016

PRESENTATION OVERVIEW

What is GIS?

What is an Enterprise GIS?

Other GIS Resources

DOTD GIS Resources

WHAT IS GIS?

It’s not just a map!

Tool for Integrating Disparate Data

Sources

A set of tools for Spatial Analysis

A set of tools for document and data

management

A digital light table, planimeter, ruler

and calculator

A tool for sharing data inside and

outside of DOTD, across departments

and to the public

Solutions to your daily business

problems

GIS is a

Solutions Tool!

WHAT COMPRISES GIS?

• It is not just a map!

• It is a system.

GIS Data

Internet Services

Software

Network locations

Models,

Work flows and

Procedures

WHAT IS DESKTOP GIS?

• At the core is the ArcGIS Software, which is a “toolset” (like Microsoft Office).

• The software displays maps, which are tied to database tables (GIS and non-GIS). But that is just the beginning.

Database

WHAT IS WEB GIS?

Mobile Tablet Browser

Anyone who can connect to the internet!

ESRI SOFTWARE INSTALLED AT DOTD No. Section Name No. Section Name

02 New Orleans District 42 Maintenance Systems Management

03 Lafayette District 45 Traffic Engineering and Services

04 Bossier City/Shreveport District 47 Legal

05 Monroe District 55 Assistant Secretary of Operations

08 Alexandria District 56 ITS

13 Information Technology 58 Chase District

19 Research (LTRC) 61 Baton Rouge District

21 Data Collection & Management Systems 62 Hammond District

22 Materials and Testing 64 Public Works

23 Real Estate 66 Intermodal Transportation

24 Road Design 67 Pavement and Geotechnical Services

25 Bridge and Structural Design 77 Traffic Engineering Management

27 Traffic Engineering Development 80 Contract Services

28 Environmental 82 Traffic Safety

30 Location & Survey 85 Transportation Planning

33 Training and Technology Transfer 88 Aviation

34 Project Management

CADD AND GIS

GIS

• Geospatial reference

• Data query and analysis using location

• Ability to create new information combining data from disparate sources

• Display with paper and web maps

CADD

• A rich collection of graphics

• Layers do not interact – no topology

• Geospatial reference not required (locally coordinate system)

GIS maps are not just graphics. They are data.

GIS compared to consumer mapping products such as - Bing, Google, Yahoo, Map Quest and others.

CONSUMER MAPPING AND GIS

GIS

• Designed for cartographic display

-Complete control over map symbology and composition

• Dynamic data over a dynamic base map

• Rich geoprocessing and analytical functions

• Extensive amount of data available as services on the internet

• Options for sharing include your map and your data

• Ability to create new information from disparate data sources

Consumer Mapping

• Optimized for visualization of spatial data

• Static data – canned base map

• Limited dynamic data

• No ability to change symbology

• Limited options for sharing your map

• Limited access to geospatial functions (geocoding and routing only)

VISUALIZATION AND GIS

GIS PROVIDES DATA – TOOLS - SHARING • The software accesses map layers and database tables

• The software gives the user tools to ask questions of the maps

• Which oil and gas wells are within 1000 ft of an interstate?

• How many miles of state roads are in Orleans Parish?

• How much has been spent on maintenance projects on interstates in my legislative district?

• Which schools are near highways on which hazardous materials are transported?

• Query results are combined to create new information that can be mapped and shared as data

• Any map and any query results can be shared to the web for the public or to an intranet site for internal use

If you can map it, you can make it a web map!

WHAT CAN WE DO WITH GIS?

• It is a tool for accessing information across the entire DOTD enterprise and information from external sources.

What current DOTD projects are in Senate District 25?

WHAT CAN WE DO WITH GIS?

• It can combine data from disparate sources to create new information.

Are there any oil leases the Haynesville Shale near this construction project (will truck traffic be a consideration?)

WHAT CAN WE DO WITH GIS?

• It is a set of tools for measuring and analyzing data.

Throw away the light table, the planimeter, ruler, and calculator. It’s all in GIS!

How many miles of State Highways are in East Baton Rouge Parish?

WHAT CAN WE DO WITH GIS?

• It is a tool for performing spatial analysis.

Extracting information and deriving solutions by analyzing the locations and the data related to those locations.

In which parishes are there roads with high average daily traffic? How many miles of roads have high ADT?

ADT

PLQ

SBR

TRB

CMR

LFU

VRM

RPDVRN

IBR

NCH

CLC

BRG

UNI

STM

SMY

WIN

SBN

SLN

AVY

CAD

DES

BOS

IBV

TNG

BNV

CLB

ALN

LSL

LVN

CTH

JFD

MRH

FRL

EVN

TNS

GRT

ACD

JCK

PTC

WSH

MDS

SMT

OCH

CLD

RCH

EFL

LNC

EBR

SHLWFL

RDR

ORL

DOTDDistrict 02

DOTDDistrict 08

DOTDDistrict 03

DOTDDistrict 07

DOTDDistrict 05

DOTDDistrict 04

DOTDDistrict 62

DOTDDistrict 58

PARISH PARISH_FIPS PARISH_NUMBER FEATURE_LABEL DESIGNATEDPARISHES DOTD_DISTRICT

Richland 083 42 RICHLAND 05

Bienville 013 07 BIENVILLE 04

Washington 117 59 WASHINGTON FLORIDA PARISHES 62

Jefferson 051 26 JEFFERSON 02

Vermilion 113 57 VERMILION ACADIANA PARISHES 03

Parishes with ADT > 100,000

Bossier

CaddoEast Baton Rouge

JeffersonOrleans

West Baton Rouge

Step1 - Select by Attribute, from the STL, the highway segments

with ADT > 100,000

Step 2 - Select by Location, the Parishes, using the previously selected

highway segments where ADT > 100,000

What are the Parishes with the Highest ADT?

PLQ

SBR

TRB

CMR

LFU

VRM

RPDVRN

IBR

NCH

CLC

BRG

UNI

STM

SMY

WIN

SBN

SLN

AVY

CAD

DES

BOS

IBV

TNG

BNV

CLB

ALN

LSL

LVN

CTH

JFD

MRH

FRL

EVN

TNS

GRT

ACD

JCK

PTC

WSH

MDS

SMT

OCH

CLD

RCH

EFL

LNC

EBR

SHLWFL

RDR

ORL

PARISH PARISH_FIPS PARISH_NUMBER FEATURE_LABEL DESIGNATEDPARISHES DOTD_DISTRICT

Richland 083 42 RICHLAND 05

Bienville 013 07 BIENVILLE 04

Washington 117 59 WASHINGTON FLORIDA PARISHES 62

Jefferson 051 26 JEFFERSON 02

Vermilion 113 57 VERMILION ACADIANA PARISHES 03

Perform a Spatial Join to summarize the ADT statistics on highway

segments falling in each Parish

The result is a Parish dataset with attributes containing rthe summary

statistics from the highway segments in that Parish

What are the Parishes with the Highest ADT?

Legend

Average ADT by Parish

Average ADT / Road Mileage

185.9 - 443.7

443.8 - 700.6

700.7 - 781.9

782.0 - 1035

1036 - 1188

1189 - 1740

1741 - 2305

2306 - 3531

3532 - 4880

4881 - 24540

WHAT IS AN ENTERPRISE GIS?

• One software, one database, one version of the truth, all shared across DOTD.

• An Enterprise GIS allows for and encourages:

• Interoperability

• Consistency

• Universal access to data across the entire organization

• Resources for training and support

• Data and mapping standards

ENTERPRISE GIS IT GIS Staff maintain GIS technology, databases, and web services

DOTD Staff produce GIS data that is stored on DOTD servers.

Data from other organizations may also be incorporated into the

enterprise environment.

DOTD staff, staff from local, state and federal agencies and the public access the

data, services, and tools via web browsers, data viewers

or the ArcGIS Desktop Software suite.

Data Exchange

Data can now be shared with mobile

apps

Data is published through maps via ArcGIS Server and

the Enterprise Geodatabase to DOTD and to the public, via ArcGIS

services and ArcGIS Online

DATA LIFE-CYCLE Data Collection Data Management

Data Analysis

Bu

sin

ess

Un

its

State Government Agency

Decisions

Business Units

State Mandated Data

Operational/Business Date

Federally Mandated Data

IT Infrastructure Enterprise Databases

Office of the Secretary

Management & Finance

Engineering

Data Distribution

Governor & Legislature

Other State Agencies

General Public

The World

WHY ENTERPRISE GIS IS IMPORTANT Enterprise GIS creates a common operational picture across the organization that facilitates:

1. Universal access to GIS technology

• Multiple levels of technology support different use requirements

• All levels of technology interact seamlessly

2. Universal access to the organization’s data

3. Universal access to users for support and training

Enterprise GIS promotes “one version of the truth” and provides for the flow and integration of data from disparate sources across and outside of the organization

Desktop

Web Mapping

Mobile

Statewide Enterprise Interoperability Streamlines Agency Functions Accurate, Authoritative, Actionable , Accessible , and Affordable Information

Streamlining – Shortening the Distance Between Data Collection and Decision Makers

DOTD Base Map

Land Cover / Land Use

Topography

Hydrography

Transportation

Boundaries

Manmade Structures

Public Land Survey

FRAMEWORK DATA

ESSENTIAL FUNCTIONS OF GOVERNMENT

Agriculture Natural Resources

Environmental Quality

Transportation and Infrastructure

Public Safety And

Homeland Security

Education Health

Human Services

THE GIS USER MODEL User Level Technology Stack

0

1

2

3

IT GIS

SaaS

Primary Technoloy to serve each level of GIS users: • Thick Client– ArcGIS Desktop • Thin Client – ArcGIS Server and Custom Web apps • SaaS – AGO, Software as a Service YELLOW – Less dominant technology ORANGE – More dominant technology IT Infrastructure

(Networking, Servers, Storage, etc.) (Updated from Mitchell and Kent, 2007 ESRI UC)

GIS USER LEVEL DESCRIPTIONS

Users will determine their own level, based on their job function and requirements

WHO IS USING GIS? Many local, state, and federal agencies share GIS data, including:

• DNR - SONRIS

• DEQ - TEMPO

• Wildlife and Fisheries – Oyster Leases

• State Lands – State water-bottoms.

• USGS - National Hydrography Dataset (NHD)

• USGS - National Elevation Dataset (NED)

• NRCS– (National Resources Conservation Service) - SSURGO

• FEMA Flood Maps site, MapMd site

• Bureau of Ocean Energy Management (BOEMR and BSE)

WHO IS USING GIS?

Private industry: • Engineering, surveying and

construction

• Oil companies

• Marketing companies

• Local water, electric and gas distribution companies

• Cell phone companies

Local Government: • Emergency Services/911

• School districts (bus routing, attendance zones)

• Long-range planning

• Assessor’s offices

• Police, fire, and emergency response

• Levee Districts

• Hospitals

Everybody!

84

167

90

165

171

71

65

425

371

61

190

79

63

167

84

167

425

71

49

20

10

5559

310510

220

110

Forecast Wind Speed Blue = Tropical Storm, > 39 mph Yellow = Gale, 58 – 74 mph Red = Hurricane, > 74 mph

Hurricane Gustav Advisory #28

Forecast Winds

Legend

! Critical Transportation Needs

!. DOTD Staging Area

!C Medical Special Needs

kj Parish Pickup Point

!O Sex Offenders Shelter

Government-wide Federated Enterprise GIS in Action – Hurricane Response Example

What Chemical Plants are in the Path of the

Storm?

DOTD Enterprise GIS ArcGIS Server Web Services

Using The Base Map for Emergency Response A Federation of Agency-level Enterprise GIS

Local Data Updates

Cached Base Map

Real-time Dynamic Data Services

Geoprocessing Services

Enterprise Base Map

Database State House and Senate

Members

DHH Hospital Status (EMSTAT) Database LSU Medical Special Needs

Operations DEQ Chemical Plants (Tempo)

Database

DNR Oil and Gas Well (SONRIS) Database

Database Query

Authoritative Response

What Hospitals are in the path of the storm and

which are open?,?

Where Can We Send Evacuating Medical

Special Needs?

Which Rigs and Wells are in the Path of the

Storm?

Real-time

Status Reports

DOTD Secretary

DOTD EOC

Operations Staff

Agency-wide Situational Awareness

Using Business Intelligence and Dashboard Applications

Service Oriented Architecture

DOTD

NOAA Real-time Weather Data

GIS AT DOTD

• How is DOTD using GIS today?

• Topographic Mapping-La.R.S. 48:36

• Louisiana Road Base Map-ARNOLD

• Enterprise LRS - Roads and Highways Implementation

• GIS on the Web – ArcGIS Online (AGO)

• State-wide Levee Inspection

• National Flood Insurance Program

EXAMPLE – MUNICIPAL SEPARATE STORM SEWER SYSTEM (MS4) PERMITS

EXAMPLES

• Demo…show web maps - LADOTD.maps.arcgis.com

• Motorist Assistance Patrol

• Proposed NHS map – click on the roads to see the details

• LADOTD Functional Class Map

• Signal Foundation Design Zones

• Search for 1201 capital access road

• Mardi Gras Pass Map

GPS TECHNOLOGY MANAGEMENT PLAN

Objectives

• Establish a GPS Technology Oversight Committee (GTOC)

• Standardize policies and procedures for the accurate, efficient, and safe operation of GPS

• Document data accuracy to improve interoperability with GIS and other target databases

• Improve GPS hardware/software use. Streamline operation, data collection, and maintenance

• Standardized training for DOTD staff and consultants

• Improve cost effectiveness of DOTD’s GPS Investment

GPS TECHNOLOGY TODAY

• Equipment available for check-out; Trimble handheld GPS data collectors, laser rangefinder, and staff pole

• Training including a Standards Operation and Collection Procedure manual

• Technical support for data processing and importing into GIS

WHERE CAN YOU GET HELP?

• Submit an IT Service Request from the DOTD INTRAnet

• Contact your IT GIS Staff!

• These are GIS professionals in OTS that manage and maintain GIS technology, systems, and applications, and provide technical support and training.

•For more information go to:

http://gis.dotd.la.gov

GIS TRAINING

•ESRI Virtual Campus provides excellent, self-paced on-line training courses.

•LTRC/TTEC schedules instructor-led hands-on courses.

•Find out about both options at:

•http://gis.dotd.la.gov

THANKS FOR ATTENDING!

James Mitchell, Ph. D. Geospatial Services Manager Louisiana Office of Technology Services Kurt L. Johnson IT GIS Technical Specialist Louisiana Office of Technology Services

Jennifer Harrison President Inner Corridor Technologies, Inc. TeachMeGIS