integrating regional spatial information with fme
DESCRIPTION
The North Central All-Hazards Emergency Management Region (NCR) for the State of Colorado contracted Critigen to develop a web-based GIS data portal where the ten NCR member counties could upload their spatial data to populate one common GIS database. Using a customized FME Server interface, users can upload spatial data and have it automatically translated into a common data model. Counties and other jurisdictions also reap the benefits when they download user-defined subsets of data for their own use into their own data schema. Additionally, the composite database supports an emergency preparedness planning tool, providing first response planners access to a continuous, region-wide dataset. In this session, you will learn how Critigen overcame the challenges faced in completing this project and will be given a view into the proposed next steps and potential applications beyond this effort.TRANSCRIPT
Integrating Regional Spatial Information with FME
Frank Orr Spatial Solutions Consultant
2010:An FME
Odyssey
Agenda
Introductions Background and drivers for the project Collecting information Application design System architecture Challenges Benefits Next steps Future applications
Introductions
Boulder
Adams
Elbert Douglas
Clear Creek
Broomfield
Arapahoe
Jefferson
Gilpin
Denver
Critigen– Denver, CO Safe Software The Colorado North Central All-Hazards
Region Member Counties
Project Background
Emergency management planning focus Need for continuous region-wide dataset Coordination with member counties hard to
achieve Homeland Security grant for 2007/2008 Additional grant for 2009/2010
Collecting Information
10 counties, all with different needs, desires, agendas
Collecting Information
Shapefiles
Coverages
PGDB
10 very different data schemas, from the very simple to the very complex
Collecting Information
Everything decided by committee, consensus difficult to reach
Prototype application with 9 data layers Roads Parcels Parcel Owners Census Blocks Municipalities Lakes Streams Fire stations Schools
Phase 2 adds 15 additional layers including: Parks/Open Space Trails Address Points FEMA Flood Zones Medical Facilities Etc.
Collecting Information
NCR data schema developed to house translated data sets
Feature classes, attributes, and domains need to be mapped and translated
Application Design
ESRI ArcGIS Server web-based mapping application
Application Design
SQL Server SDE database Password-protected web application
Data Upload
Custom web pages assemble required FME Server request strings
Data Upload
FME Server translation Based on 10 FME upload workspaces
Data Upload
Data Upload
Upload Schema Mapping
Data Upload
Custom web pages assemble required FME Server request strings Typical Upload Request
https://www.gis.ncrcolorado.org/SpatialDirect/translationServlet?SSFunction=getUploadStatus&reqID=12015361025840.7794552208857219
Data Download
Custom web pages assemble required FME Server request strings
Data Download
FME Server data translation Based on 11 FME download workspaces
Data Download
Parameters Point & Buffer Extents County Municipality
Data Download
Download Area Options By Area – Drag a rectangle, define on map By Point and Buffer, define on map By Municipality – clip polygon By County – by County field in attribute table
Schema Options 10 different counties plus NCR master schema
Coordinate System Options UTM NAD83, 4 state plane, LL NAD83
Layer Options Select any and all available data layers
Data Download
Custom web pages assemble required FME Server request strings Typical Download Request
https://www.gis.ncrcolorado.org/SpatialDirect/translationServlet?SSFunction=remoteFetch&format=Download_Arapahoe.fmw&fmeParams= --selectedThemes "" --boxMinX --boxMaxX --boxMinY --boxMaxY --queryType POINTBUFFER --pointXcoordinate 493412.821 --pointYcoordinate 4406154.604 --countyName --cityName --radius 53019 --destinationCoordSys UTM83-13
Workflow Overview
Upload
Download
System Architecture
Two servers, one primary, one redundant Hosted at separate county locations
Douglas County – Primary Denver County - Redundant
Automated replication between servers FileReplication Pro replication software
Automated failover between the servers DNS Made Easy
Challenges
Decision by committee Lack of previous coordination between
counties Disparities in GIS sophistication Proprietary data concerns Expanding beyond initial user community
Benefits
Unique planning tool with seamless region-wide dataset
Dialog between counties promotes better coordination Edge matching Data schema consolidation
Serve as a model for inter-region and state wide coordination
Next Steps
Add more data layers Medical facilities Critical infrastructure Etc.
Enhance existing data layers Assist counties to identify and fill
gaps Fire stations, schools
Add more viewer functionality Geocoding service Advanced spatial queries
Help counties work together to edge match street centerlines
Future Application
Other Colorado all-hazards regions DRCOG and other MPOs State of Colorado