Geospatial Data Modeling and Geodatabase Design

The geodatabase melds the benefits of standard IT tools with the power of spatial analysis and mapping

Centrally located enterprise geodatabases can deliver immediate benefits to both the users and stewards of GIS data: significantly reduced data development and management costs, controlled access to valid and current geo-spatial information, simplified data maintenance workflows, and more productive use of GIS throughout the enterprise.

Enterprise Addressing System. Turnkey solution for an authoritative centralized address system

Enterprise Addressing System
Turnkey solution for an authoritative centralized address system
Network GIS. Network data models, linear reference systems, and dynamic segmentation
Network & Utilities GIS
Network data models, Utility Systems Data Modeling, linear reference systems, and dynamic segmentation
Transportation & Linear Networks Model and solve routing, logistics, and other transportation/network issues
LRS for Transportation & Infrastructure
Model and solve routing, logistics, and other transportation/network issues
Spatial data processing for insurance and risk analysis
Spatial Data Processing
Analysis of large volumes of geodata to answer business questions and understand risk

Farallon Geodatabase Capabilities

Because an enterprise GIS geodatabase requires an interdependent suite of technical, strategic and implementation services, we have developed Farallon into a nimble State of California certified small business that offers the following Geodatabase specializations:

GeoSpatial Data Modeling, Geodatabase Design

  • Spatial data modeling, spatial and topology business rules
  • Network data models
  • Linear Reference System (LRS) and Dynamic Segmentation
  • Information flow and data auditing rules
  • Spatial and Temporal Entity relationships

GeoSpatial Data Development, Validation and Maintenance

  • Terabyte-scale geo-spatial dataset development
  • Geo-spatial data migration, validation, auditing
  • Metadata development
  • GIS data maintenance workflow design

Oracle Spatial Geodatabase Development

  • Spatial data modeling for Oracle 9i/10g Locator and Spatial
  • Development of spatial business rules, persistent topology
  • Spatial data validation, PL/SQL automation
  • GIS vendor Interoperability
  • Long Transactions
  • Spatial-Temporal geodatabase development

ESRI ArcSDE Geodatabase Development

  • Spatial data modeling
  • Development of spatial business rules, persistent topology
  • Oracle 9i/10g and Microsoft SQL Sever Experts
  • Geodatabase Versioning Plans
  • Spatial and Temporal Entity relationships

Farallon Geospatial Modeling and the Importance of Valid Data

Rigorous data management procedures insure data integrity and useful. Every database Farallon builds follows strict modeling rules, such as referential integrity rules, formal definition of primary and foreign keys, and accurately documented entity relationship diagrams that visually depict valid database object interactions. In addition, we define the required spatial and business rules that all core geodata must meet to be considered valid.

Enterprise Geodatabase design means:

  • Multi-departmental
  • Multi-facility
  • Multiple data providers/consumers
  • Multiple uses for the same information
  • Links to non-spatial databases
  • Customizable “look and feel”