2009 Ohio GIS Conference
Presentation Abstract and Biography

Enterprise ETL & the Home Again Web Mapping Application: Columbus, Ohio

Erick Lobao, Stantec

Erick Lobao earned a B.A. in Geography and Environmental Studies from Ohio Wesleyan University and a Masterís in Geography from The Ohio State University in 2003. As a GIS Project Manager in the Columbus office, Mr. Lobao has a wide range of experience performing spatial analysis, developing GIS needs assessments, designing and maintaining enterprise databases, and providing GIS training to individuals with varying amounts of experience in GIS.

Nicholas Soltes, Stantec

Nick Soltes earned a B.S. in Geographic Information Systems from The Ohio State University. He has a strong background in utilizing GIS to create, manipulate, and analyze spatial data. As a GIS Analyst in Stantecís Columbus office, Mr. Soltes has worked with both environmental data, such as floodplains and mines, and infrastructure data, such as fiber-optic lines, providing him with a well-rounded understanding of the needs and challenges associated with a variety of spatial data.

Sonia Krammes, City of Columbus, D.O.T.

Sonia Krammes earned a B.S. in Geographic Information Systems from The Ohio State University in 2004. As a GIS Analyst with the City of Columbus, Department of Technology, her role is to provide technical support to Citywide GIS users. Mrs. Krammes is also responsible for creating data models to keep the GIS Repository data current and aids in the creation of GIS web applications that are utilized in departments throughout the City of Columbus.

Robert Parsons, City of Columbus, D.O.T.



Thursday, September 17, 2009 - 2:45 PM - Track 1

The City of Columbus's Home Again Initiative is designed to stabilize specific neighborhoods by addressing the issue of vacant houses. Public funds are distributed to private contractors who are tasked with repairing or demolishing vacant homes in targeted neighborhoods. A GIS based solution is ideal for analyzing the distribution of funds as well as the overall success of this initiative. This presentation highlights the use of ESRI model builder to support an enterprise GIS web mapping application developed to inform decision makers. ESRI's model builder provides basic tools to automate and schedule the extraction, transformation, and loading of data stored in different file formats and maintained by multiple organizations. Leveraging the City's GIS repository within a web mapping Application provides decision makers and political leaders the ability to visualize and analyze spatial patterns associated with the properties impacted by the Home Again Initiative as well as communicate spatial information to the public.

Presentation Powerpoint (1.0MB)