Database

Farragut Systems has extensive experience with ESRI's Geodatabase and their Spatial Database Engine, as well as Oracle Spatial. We have designed and implemented Geodatabases, for example, for a wide range of data types, including utility data, parcel information, water and sewer, and facilities. In addition, we have developed a number of applications that utilize GIS and database connectivity. These integrated applications have been developed for a wide range of customers including municipal, environmental and emergency management implementations

We have designed and implemented Databases and Geodatabases for a large number of entities, incluing Boulder County, CO, Wake County, NC, tarrant Regional Water District, TX and the Colorado Department of Transportation.

Key Benefits

	Consistency and accuracy of the database are key to successful operations
	The latest technologies, such as ESRI's Spatial Data Engine (SDE), ensure speed and precision
	The security of the data can be defined and assured

Capabilities

The development of a database dictionary is a necessary first step in designing and implementing a GIS database. Farragut typically builds and tests a database dictionary during a Pilot Project, revises it based on comments received, and produces a final version prior to implementing a GIS database. The database dictionary is developed with extensive input by the customer to ensure that it addresses critical database issues, such as required linkages.

A database dictionary includes, but is not limited to the following:

	GIS datasets, feature classes (point, line, polygon) and naming conventions
	Data sources
	Feature attribute tables
	External DBMS database tables (e.g., CAMA)
	Foreign and primary keys used to link tables
	Item definitions for all feature attributes and DBMS tables
	Attribute descriptions and ranges of valid values

Farragut also has long-term experience in data translation and has translated data from various CAD formats (for example, AutoCAD and MicroStation) into GIS-formatted files for use in ArcInfo^TM, ArcCAD, and ArcView® GIS.

Our process for data translation includes the following:

	Data translation from CAD to GIS, including building of topology
	Editing and correction
	Edge-matching
	Database linkage setup
	Production of final check plots, and final QA/QC
	Tiling of the GIS database

In the integration of GIS and databases, Farragut has developed a number of applications that utilize GIS and database connectivity. Some of our integrated GIS and database applications include municipal, environmental, and emergency management implementations.

Farragut's database experience covers:

	Relational databases including ORACLE, SQL Server, MS Access, SYBASE, and INFORMIX
	GIS and Database Integration
	GIS and CAMA Integration
	GIS and Document Management Systems Integration
	ODBC Connectivity
	OLE DB
	SQL

To request more information on this service, go to our information request page.

Key Benefits

Capabilities

Send mail to webmstr@farragut.com with questions or comments about this web site. Copyright © 2001-2006 Farragut Systems, Inc. Last modified: April 9, 2007

Send mail to webmstr@farragut.com with questions or comments about this web site.
Copyright © 2001-2006 Farragut Systems, Inc.
Last modified: April 9, 2007