Land Use Management System Implementation using Esri ArcGIS and LGIM for Town of Danville

Land Use Management System Implementation using Esri ArcGIS and LGIM for Town of Danville

Challenge

The Town of Danville used a GeoMedia and Oracle-based GIS. They needed to implement a multi-departmental Land Use Management System which was not compatible with their GIS.  The Town needed to install Esri’s ArcGIS Server within its network. To ensure the safe migration of the Town’s GIS data and an easy and effective transition to a new ESRI-based GIS server system, the Town requested Farallon to develop a project plan and workflow to assist in the conversion process.

Solution

Farallon installed Esri’s ArcGIS for Server onto a Danville server and configured it to interact with the Town of Danville’s SQL Server database. Farallon then implemented Esri’s Local Government Information Model (LGIM) on the Town’s new ArcGIS Server to establish a commonly-used and comprehensive data model in which most municipal governments store their GIS data. The LGIM is advantageously comprised of a wide variety of pre-developed services and applications allowing municipalities to easily integrate with external business systems and other third party vendors.

After completing the ArcGIS Server set up, Farallon populated the new geodatabase with data originally stored in the Oracle/GeoMedia database. Farallon focused initially on populating the geodatabase with feature class data crucial to the launch of the Land System. The Land System and other property data processing applications needed parcel updates on a regular and recurring basis within ArcGIS. Farallon developed a semi-automated script using FME software to facilitate the import of county parcel shapefiles into the ArcGIS database. Farallon also provided in depth ESRI ArcGIS training and support.

Screenshots & Videos

The ArcCatalog interface for ESRI geodatabase management and design.

The FME visual interface showing the configuration of the tool that re-projects and populates the Danville spatial data into the ESRI LGIM

The FME visual interface showing the configuration of the tool that re-projects and populates the Danville spatial data into the ESRI LGIM

Example of the easy-to-use address search toolbar.

SQL Server: An example of the former Oracle database management system using SQL Developer.

SQL Server: An example of the former Oracle database management system using SQL Developer.