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
Network GIS
Network data models, linear reference systems, and dynamic segmentation
Transportation & Linear Networks
Model and solve routing, logistics, and other transportation/network issues
Utility System Data Modeling
Integrate traditional GIS, network analysis, and distributed field editing
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
Related Case Studies
- Contra Costa Economic Development website integrates spatially-aware database and MS Virtual Earth
- Enterprise Addressing System for the City of San Francisco
- Colliers International Bank Site Data Management Application
- City of Fairfield Enterprise Geodatabase
- GIS Web Application to Identify and Manage Critical Geological Hazard 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"