GIS Database Design
The design of the appropriate GIS database is a critical element of an overall successful GIS strategy and requires a a suitable data model to efficiently store, query and manage the geographical or spatial data. Lovell Johns can consult, advise, design and create the GIS database which best matches the size and nature of the client requirement. This element of GIS is often inextricably linked to the data capture and conversion elements and our GIS specialists can design and implement a GIS database architecture for use with:
- ArcGIS personal and file geodatabases
- Oracle and SQL Server via ArcSDE Technology
- Open Source databases such as MySQL and PostgreSQL via custom linking
Lovell Johns also offer metadata creation to specific European and International standards, such as INSPIRE (Infrastructure for Spatial Information in Europe).
Case Study - GIS Database Design - European Commission

Lovell Johns were part of a consortium of companies (with ESRI BeLux, Atos Origin and Leuven University) awarded a framework agreement to provide GIS database design services to the European Commission between 2004 and 2009. There were a number of projects in which work programmes and tasks were divided according to the strengths of each partner. LJ managed activities as part of the consortium carrying out the annual update of an EC internal GIS statistical database entitled GISCO.
The maintenance and development activities involved liaison with EC experts to implement specified tasks including database design using UML models, database implementation, geoprocessing, quality control procedure design, quality control processing & reporting and the import and versioning of datasets in ArcSDE.
View more case studies in: GIS Services