Sharing GIS to AEC users online and on the road

(1)

Esri AEC 2014 .

Sharing GIS to AEC users

online and on the road

Renato Salvaleon

Land Department, Georgia Power Company

(2)

Esri AEC 2014 .

SCOPE OF PRESENTATION

• Intro

• Solution

• Documents and Geospatial Data

• Meaningful Information

• Web Maps

• Next Steps

(3)

Esri AEC 2014 . Es Es EsriAEC 2014 . .

INTRODUCTION

(4)

Esri AEC 2014 .

Introduction

Renato Salvaleon GISP, CSM – GIS Senior Info Analyst

• 15 years of GIS in the areas of military

intelligence and operations, transmission, IT,

and currently Land

• BS degree from the Philippine Military Academy

• MSIS and GIS Certificate from Kennesaw State

University

• Pursuing a Certificate in Land Surveying

(5)

Esri AEC 2014 .

Georgia Power

Largest operating company of Southern Company

• 2M residential, 300K commercial, 8K plus

industrial serving 2,375,304 as of 2013

• Total Georgia Power kW capacity of close

18M kW from 43 plants and seven jointly

owned plants with the following generation

sources: coal (39%), nuclear (27%), oil and

gas (33%), hydro (1%)

• Total of 73K miles of distribution and 12K

miles of transmission.

• More details on the Facts and Figure page

(6)

Esri AEC 2014 .

Land Department Organization

Document Management and GIS working together for Land Records

Land

Management

Land Sales

Land

Acquisition

Land

Engineering

MISSION: Manage property and projects in support of power delivery

Revenue generation varies from $19M to $100M dollars per year coming from

Land sales and donations; quit claims; fiber optic agreements; easements;

lake lots; forestry, water withdrawals, and park income.

(7)

Esri AEC 2014 .

Land Department

Acquire, protect and manage company

real property assets (Local government

industry - alike)

• 17 hydro generation sites

• 60,000 reservoir acres and

1,400 shoreline miles

• A total of 76,750 acres of land

-

21,750 leased to the Georgia DNR

for public recreation and hunting

-

18,000 plus total lake residents

with lease lots, access, and

easements

• )

(8)

Esri AEC 2014 .

Land Projects

Generation, Transmission, Distribution,

Corporate Services (AEC Industry alike)

• New construction (plants,

transmission line, substation)

• Rebuild and Reconductor

• Substation and Plant expansions

• DOT Relocations

• Customer relocations

• Distribution feeder additions

(9)

Esri AEC 2014 .

Land Rights in Georgia

Stored in GIS and Onbase

150,000 acres fee simple

Plants

Lakes

Substations

Operating HQ

Offices

Communications sites

Easements for

12,000 miles transmission

72,774 miles distribution

Fee is also stored as bulk property in

GIS

Georgia is headrights and Land lots

and Districts; not PLS

(10)

Esri AEC 2014 .

Land Records and GIS

In support of property and project management

• Records custodian for property

records (half a million) and

maps (200K)

• 6 million supporting

documents available offsite

• Conducts property research

for all projects

• Over 150 years of records

• Uses technology tools

c

y

t

y

(11)

Esri AEC 2014 .

My Inspiration to Present at this Summit

• Work

• Attending this summit last year

• Reading/hearing from the works of

individuals/groups like Curt Sumner (GIS), RJ

Zimmer (GIS for Surveyors), Erik Gakstatter

(GPS World), Land Records Meetup, GIS

Janet/PLS Randy (Intersect series of

PROFSURV), bloggers like Don Kuehne,

Gordon Luckett, and many more

• Passionate in the use of GIS in providing

geospatial solutions for the end users specially

the AEC users in my company

(12)

Esri AEC 2014 .

Who are my Users

Sharing GIS to AEC users on the web and on the road.

INTERNAL CUSTOMERS

To Land

Civil Engineers

Location Engineers

Surveyors - Field and Office

Mappers

Environmental Specialists

Foresters

Shoreline Specialists

Acquisition Coordinators

Engineering Coordinators

Researchers

Sales/Acquisition Agents

Outside Land

Transmission Planners

Transmission Project Managers

Forestry & ROW specialists

Generation engineers

Distribution engineers

Hydro engineers

Corporate Services - Mail &

Corporate office

Property & Tax accounting

EXTERNAL CUSTOMERS

General Public who uses our recreational facilities

General public who leases our properties

General Public who have ROW/property issues

(13)

LIMSGIS Web & Mobile Apps

(14)

Esri AEC 2014 .

END STATE OF ENTERPRISE SOLUTION

DATA

MANAGEMENT

(15)

Esri AEC 2014 .

CURRENT STATE AND HOW LIMSGIS/ONBASE

LOOKS IN CONTEXT WITH ENTERPRISE SOLUTION

DATA

MANAGEMENT

GEOSPATIAL

DATA PORTALS

(16)

Esri AEC 2014 .

(17)

Esri AEC 2014 .

Web Maps

Similar concept as ArcGIS.COM

• Web Map use to share GIS

content and documents

among LIMSGIS users.

• Web created from the browser

is accessible from its mobile

version

• Can be shared

and emailed

(18)

Esri AEC 2014 .

What’s stored on web maps

Custom Web Map Viewer, Mobile component

• Map metadata

• Pertinent layers to web map

• Extent

• Document hit list – search result

(19)

Esri AEC 2014 .

My Workspace

Maps and Bookmarks

• Pop up window to store:

-

location bookmark

-

map bookmark

-

My favorite web maps

-

Shared maps

-

Group maps

• Important feature to use

for LIMSGIS Mobile

(20)

GIS Integrated with Portals and

Document Management System

Documents and

Geospatial Data

(21)

Esri AEC 2014 .

Delivery Solutions - Documents

LIMSGIS integrated with Onbase document management

• 200K maps & 500K document stored in

Onbase

• Locating documents (Property and maps) by

attributes

• Locating documents using GIS features

(Attribute link)

(22)

Esri AEC 2014 .

End Goal

Geolocate all documents - user clicks on a feature all documents

associated to the feature are highlighted and identified

(23)

Esri AEC 2014 .

Geospatial data

Data everywhere… the GIS analyst & the Records center are the

data keepers

• Digital data all the way back from early-mid 90s

-

CAD, GIS, Controls, PLS-CADD,

• Aerial imagery of almost 30TB

• Lidar data - NERC Alert data is 6TB

• Is there a solution that fits all?

(24)

Esri AEC 2014 .

Geospatial data portal solutions

We’ve tried Geoportal (Open), Erdas Apollo, Voyager Search and

Portal for ArcGIS/ArcGIS.COM

Links to Portals

(25)

Esri AEC 2014 .

Geospatial data portals

Use right clicks on LIMSGIS map view and clicks Voyager Search

passing its center and view extent…Voyager filters results based on

these parameters

Voyager parameters

parsed in LIMSGIS

using Voyager query

parameters

(26)

Esri AEC 2014 .

Geospatial data portals

Sample of Voyager Search filters

(27)

Esri AEC 2014 .

VOYAGER SEARCH FEATURES

• Search filters

• Arc Map Add-in

• Works with all the geospatial data that we use – even FME

workspaces

• Web integration API

• Discovery tool – scheduled, watch, easy to use

• Metadata extraction

• Single sign-on, AD security enabled

• Easy to install, easy to maintain… DB built-in

• We’ve indexed more than 1.1million records

(28)

Building workflows and defining

the purpose of the data and

solutions

Meaningful

Information

(29)

Esri AEC 2014 .

PROPERTIES, ENCUMBRANCES & RIGHTS

Challenge – Even our data has a separation

• The suggested data

format – how long ago?

• Difficult for the end users

• Difficult to maintain

• Compromise to get survey

data into GIS

• Data will be distorted

regardless

• We have to link these data

with other non-GIS access

databases

NON SURVEY

LAYERS

(30)

Esri AEC 2014 .

Needs and redefining the purpose of our data

• Do we need use GIS to drive spatial accuracy? at least not yet. (Erik B.).

• If we have to, then we will ask our surveyors, mappers, researchers to come

together to build and maintain parcel fabrics as part of our workflow.

• Workflows will help us define how we create and maintain these layers.

• Do not combine the purpose of data into one data set, e.g.

-

bulk property for both ownership and timber management

-

leased lots layers to view survey and non-survey (tax data) boundaries

• Our GIS data isused as a reference to retrieve project information & data. The

boundary is used as a reference and a link & not to be used for deciding any

property disputes.

• GIS will help answer property questions that are spatial in nature and to address

the department’s mission – i.e. to manage projects and properties for the

company that are pertinent to Land. – (Erik B.)

(31)

Esri AEC 2014 .

Solution - a new workflow for property transactions, rearranged the layers

• WORKFLOW

• Data capture for property triggered when closing

documents are received/Recorded in Onbase

• Parcel map/plats are used to generate

boundaries using COGO or data conversion.

• PROPERTY DATA MODEL

• Properties group will be reduced to

-

Property Transaction – sold, donated, purchased

-

Fee Property - maintained from transaction layer

-

Bulk Property – maintained from transaction layer

-

Project Boundaries - linear

• Survey or non survey becomes an attribute,

data/document source, method used (COGO,

conversion from CAD or survey)

PROPERTIES LAYER

(32)

Esri AEC 2014 .

Easements

Developed a workflow, conversion tool using ArcSDE, AutoCAD C3D & FME

• Needs/Requirements

-

Calling project parcels as easements is misleading

-

Get used to the term “project parcels”

-

Create GIS while project parcels are being surveyed and acquired and

not at the end of the construction

-

Mappers want to use their tool (CAD) – the words GIS, SDE, reconcile

and post gives them the shivers

-

Mappers want an Easy button

• Workflow analysis

-

Data capture for easement happens when a construction release form

is emailed.

(33)

Esri AEC 2014 .

Easements

Developed a workflow, conversion tool using AutoCAD C3D, FME Desktop

• Workflow Solution

-

Tax parcel list with geometry is received from researchers

-

During the pre-construction survey, mappers use survey data to create new

project parcels based on scope

-

Mappers create the SDF in CAD. Run the conversion tool in FME

-

GIS Analysts QAs, reconcile and post in SDE

-

The process is iterated until a construction release form is created and some

project parcels are either converted to fee or acquired easements

• Toolset - a combination of data conversion within Civil 3d from civil objects

to Autodesk’s SDF format – Mapguide format – and FME Desktop

(34)

Esri AEC 2014 .

Easements

Solution - Using FME Desktop...deployed in Citrix…to be moved to FME Server

(35)

Reference & Project

(36)

Esri AEC 2014 .

Property Boundaries for Shoreline properties

Survey, GIS and boundaries…

NON SURVEY

LAYERS

SURVEY LAYERS

GPC Monument

LEASED

LOT 874

(37)

Esri AEC 2014 .

Data mining from NGS Control FTP to SDE

Control points from the context of our own data….

NOAA

NGS

Survey

data

explorer

Our Own GIS Viewer

(38)

Esri AEC 2014 .

Data mining from NGS Control FTP to SDE

Using FME desktop ….

DO NOT DROP THE SDE Feature Class

in the TRANSLATION!

(39)

Esri AEC 2014 .

… from SDE to web service

…with a Python shutdown script that republishes the web service

(40)

Esri AEC 2014 .

Acquisition Status of a Site Project

GIS, Maps, Documents

(41)

Esri AEC 2014 .

Acquisition Status

GIS, Property,

and Maps

GIS FEATURE ATTRIBUTES

PROPERTY DOCUMENTS

(42)

Esri AEC 2014 .

LIMSGIS Mobile versions

Same web and information…different platform

(43)

Web integration projects

New

(44)

Esri AEC 2014 .

In-house Mobi mobile app builder

(45)

Esri AEC 2014 .

Mobile content delivery tool

+ ArcGIS.COM web maps

(46)

Esri AEC 2014 .

Future Integration with FME Server

User driven automation..better cartographic product

EA

project

data in

GIS

database

EA

project

data in

Excel

EA

project

data in

CAD for

mapper

s

EA project data

submitted by

(47)

Esri AEC 2014 .

Better Cartographic products with GIS data

Saves times, easy user automation, web api integration using FME

Server

(48)

Esri AEC 2014 .

And More…

• Automating capital project parcel list

• Automating route survey scope for planning

• Project handoffs – workflow manager

More of FME Server/Workflow Manager and integration with

LIMSGIS

(49)

Esri AEC 2014 .

- Feature Services on the web and mobile versions

- Geolocate feature

- Improved mobile tools

- FME Server integration for self-download using FME

- Forms and Reporting

Integrate ArcGIS Workflow Manager

Offline editing capability

Integration with Portal

for ArcGIS

& ArcGIS.COM

Project Management and Property

Management Integration

(50)

Esri AEC 2014 .

QUESTIONS