building the sams-ii · •sams-ii ms sql server 2012 •arcgis server 10.5 platform ......
TRANSCRIPT
Building the SAMS-II
Statewide Addressing in the Mountain State
Kevin Kuhn – GISP WV GIS Technical CenterGIS Analyst / Instructor
A Collaboration between the WV Dept. Homeland Security and Emergency Management (WVDHSEM), WV GIS Technical Center at WVU and County Addressing Coordinators.
Original SAMS History
• SAMS Oracle / Web Platform implemented in 2003.• SAMS funded through Verizon WV Incentive Regulation Plan (IRP) with the West Virginia
Public Service Commission.• 2001 the Statewide Addressing and Mapping Board (WVSAMB) was established with the
passage of legislation introduced by the West Virginia E-911 Council, WV Senate Bill 460. Then, in 2007, House Bill 2525 was passed and the board received an additional three years to complete their work pursuant to the provisions of article ten, chapter four of the WV code.
• Since 2008 the West Virginia Division of Homeland Security and Emergency Management (DHSEM) has been the home of the statewide addressing and mapping project. The division plays a key role in the E-911 addressing and database development by providing vital resources and support to counties and municipalities through the production of cartographic output that supports additional field work and field edits.
SAMS – 1st Generation
• Why replace SAMS? • No Local Oracle dba Support• Costly Contract Support
• Could not import newly acquired aerial imagery!
• Ageing Hardware• Slow Performance• Incompatible Data Structures • Inefficient Workflow for ‘Offline’
Participant Counties
SAMS-II Project Scope
• Primary Goal: replace the SAMS Oracle system with a modern web application responsive to the evolving GIS landscape and provide a unified platform to suit the needs of the e911, addressing community and its partners in West Virginia.
• SAMS-II Capable of web-based addressing data maintenance, import and integration, and data export.
• SAMS-II MS SQL Server 2012 • ArcGIS Server 10.5 Platform• ArcGIS API for JavaScript 3.x
SAMS-II Development Timeline
• Jan 2015 - Coordinator Survey (Compiled April 2015) • April 2015 - Needs Assessment / Design
Documentation• May 2015 - Oracle to SQL Server Migration Study• Sept 2015 - Application Development Begins • Nov 2015 - SAMS-II Demo & Training site GO LIVE! • Nov 2015 - 1st SAMS-II Demonstration Webinars /
Online User Training Begins• Feb 2016 - SAMS-II GO LIVE! • Sept 2017 – SAMS-II Development Wraps
SAMS-II
SAMS-II
Symbology & Basemaps
SQL Server
JavaScript, Python, SQL Tran
ArcGIS Server – SAMS II Data Model
Edit Utilities
Import Utility
Validation Tools
Reporting Tools
• WV Division of Homeland Security and Emergency Management• Nuvia Villamizar – [email protected] 304.558.5380• David Phillips – [email protected] 304.558.5380
• WV GIS Technical Center• Kevin Kuhn – [email protected] 304.293.9462
Thanks for Listening!