Program Overview

Developing GIS databases is typically the most time intensive and costly portion of building and maintaining a GIS. And a poorly designed database can lead to inefficiency and higher costs in the long run. For this reason, GIS Associates believes in properly planning and designing the database at the front-end, with plenty of client input to ensure the database will meet their needs, both immediate and future.

Our staff has provided database design, development and conversion services for a wide range of clients, including the Suwannee River Water Management District, the St. Johns River Water Management District, the Southwest Florida Water Management District, JEA (formerly Jacksonville Electric Authority), Marion County (Florida), St. Johns County (Florida), St. Lucie County (Florida), the City of Alachua (Florida), and the Town of Lady Lake (Florida).

For more information regarding database design, development and conversion, please contact us.

Featured Project

Division of Water Supply Management GIS Support, St. Johns River Water Management District (SJRWMD), Florida

Projected Public Supply Population Increase, 2000-2025GISA coordinated and supported GIS services for the District’s Division of Water Supply Management from 2001-2010, including:

  • Provided direction for GIS activities within the division;
  • Management of GIS and related projects;
  • Public meetings and presentations;
  • Evaluation of GIS needs and current resources, and development of program to meet future goals;
  • Design and development of Oracle RDBMS modules;
  • Design and organization of GIS and related databases and conversion from GIS and various tabular (Excel, dBase) and text formats to ArcSDE enterprise geodatabase;
  • Extensive spatial modeling and analyses (raster and vector);
  • GIS instruction for District personnel;
  • GIS programming to automate complex tasks;
  • Development of custom ArcMap Documents and ArcView Projects for personnel to automate and/or facilitate common tasks;
  • Establishment of GIS and GPS standards for staff and consultants, and assistance with determining how data should be collected and/or digitized;
  • Developed Standard Operating Procedures (SOP) manuals for users to view, query, edit, and analyze Geodatabases;
  • Providing direction, expertise, and oversight to district staff and contractors regarding:
    • Converting databases from a wide range of formats (GIS, Access, Excel, dBase, etc.) into Oracle and Geodatabases;

    • Establishing relationships between databases to allow them to be linked (either directly or using a link table);

    • Quality assuring tabular and spatial databases; and

    • Spatially referencing databases (linking tabular data to spatial features) using related tabular fields and/or GIS data layers.

↑ Back to top