FME at the centre

Jon HawkinsGIS Coordinator, Waterford City Council

Monday 10th September 2012

Overview

Translate Transform Disseminate Upload Download Integrate non spatial data Integrate Spatial Data Create a CRM

Translate

Import latest: OSI ESB Network

Source

GeoMedia

TAB

SHP

Transform

Changes to style Removal of unwanted Layers Merged, Tiled, Cut

Source

GeoMedia

TAB

DWG

MapInfo Styler Geometry Filter

Disseminate

Water Network (CiS GeoMedia SQL) Sewage Network (MapDrain TAB + Access) Road Network (MapRoad SQL 2008)

Source

GeoMedia

TAB

SHP

DWG

Upload

Planning Applications iPlan SQL PlanReg TAB

iPlanSQL

GeoMedia[Internal]

TAB

CSV

KML

PlanRegTAB

GeoMedia[External]

Date Formatter

Download

MapAlerter

KML

Tweeter

Integrate Non Spatial Databases

Eg. Housing Data and FMSGeoMedia

SQLSIA

MapInfoTAB

General

SQLHome

HousingTAB MapInfo

TABRestricted

AgressoSQL

Excel

Refuse Collections

In 2008, data integration enabled a 33% reduction in operation costs for the collection of domestic waste

Missing revenue

Are all commercial properties paying for water? Are all properties paying for water paying rates?

Point Connector Aggregator

Integrating spatial data

GeoDirectory Update

GeoDirectorySQL

BringBanksTAB

SchoolsTAB

Bin RoutesTAB

TownlandsTAB

LibrariesTAB

ED’sTAB

SQLGeoDirectory

Enabled Open Source GIS

NeighborFinder StringConcatenator

Create a CRM

Mobile Incident Capture

IncidentsGeoMedia

NeighbourhoodsTAB

TaskListSQL

ContactsSQL

Email

PythonCaller

Duties

Map Production

Analyst

Trainer

Systems Implementation

Data Capture / Maintenance

OSi Liason

Project Manager

Data Matching and Cleansing

Promotion

Database Administrator

GIS Work ProgrammeBudget Management

Systems Implementation

Report Generator

Data Sharing

Programmer Developer

Consultancy

Responsible forGeoDirectory / CAD

Technical Support

Need to be organised

Central GIS Server

Desktop GIS

AutoCAD

GIS Applications

iPhone, iPad, Android

Mobile GIS

TwitterInternet

Intranet

Thank You!

Questions?

For more information: Jon Hawkins jhawkins@waterfordcity.ie Waterford City Council

Benefits

Set up once use many Supports one definitive source of information Disseminates information automatically Manipulates data into the exact format and style

you wish to present Enables integration of corporate data Enables you to support multiple data formats Allows users to continue using the application

most suited to their needs Geographic relationships can be exposed and

queried as part of a transformation Workspaces can be shared