Integration of Tabular and Spatial Data Using Microsoft SQL Server

Site Archive
You are viewing a static copy of the 2013 Sunriver Conference website archived on December 11, 2013. To view current Northwest GIS User Group events and news visit

Small local governments face a unique set of challenges when it comes to collecting, managing and serving data in the digital age. In this session, we will discuss how the City of Hayden, a small town in Northern Idaho, took on the task of identifying and registering all of the businesses in their jurisdiction. We will explore the tools they chose for storing and updating data, collecting online payments and integrating their database into an ArcGIS environment. We will discuss the use of ArcGIS Desktop and .Net applications for managing local data and accessing remote systems via SOAP. We will also discuss the benefits of the native SQL Server geometry data types for storing and accessing spatial data.

Matthew Gerbrandt

Mr. Gerbrandt currently serves as a Geospatial Applications Developer for Innovate!, Inc. in support of projects which require expertise in cloud-based data management and .Net programming. Mr. Gerbrandt’s specialty is in building simple, intuitive applications which allow users to interact with and manage geospatial and tabular data. Prior to working for Innovate!, Mr. Gerbrandt spent 10 years with the Confederated Tribes of the Umatilla Indian Reservation where he served as the Senior Web Developer and Database Administrator. During this time, he focused on establishing and maintaining an enterprise GIS environment and building custom .Net tools for processing and analyzing tabular and spatial data using SQL Server and ArcGIS Server.

Homestead 1
October 17, 2013 - 4:30pm - 5:00pm
Your rating: None Average: 4 (7 votes)