Services

GIS Database Design & Development

Geoascent will work with you to identify your goals, business workflow and build scalable spatial database solutions that meet your current and future requirements. With years of hands on database experience we have the resources to design projects utilising PostgreSQL or SQL Server depending on the specific needs. Along with database design we can:

Automation business workflow to reduce manual tasks

  • A data management interface with custom development of QGIS
  • Security and specifc user-based workflow
  • Web-based publishing of data and mapping
  • QGIS plugin development

GIS Strategy

Geoascent offers the production of an independent GIS Strategy, in order to provide an organisation with a high level view of key aspect of GIS, including spatial data, software and skills. We would provide recommendations over what software to use, what skills are present and required and also how the organisation can best source and use data.

The form and the scope of the GIS Strategy will vary from place to place, hence this would be tailored to the specific requirements of the organisation. A GIS Strategy should answer the questions:

  • What role should geospatial data and tools play in enabling our organisation to achieve it’s goals?
  • How should the governance and funding of geospatial data and tools work in conjunction with other aspects of the IT infrastructure?
  • How are we going to leverage geospatial data and tools to benefit our organisation?
  • What do we need to do to attain that state?
  • What would the costs, benefits and risks of pursuing that course be?
  • How are we going to do it?

Managed Migrations

Geoascent is experienced in managing migration projects, to enable organisation take up new and different GIS tools. In particular our expertise lies in setting up QGIS as a desktop GIS and PostGIS as spatial data holding and rolling them it out across organisations of different sizes. We provide the approach and strategy for a migration along with a managed step-by-step and supported process. We would work with your organisation to ensure business continuity taking into account specific user requirements, your data, system availability and training needs.

PostgreSQL / PostGIS Services

Postgres Support

Implementation

Professional installation of PostgreSQL database server on a customer or cloud hosted server. Our implementation will include:

  • Setup and configuration to ensure PostgreSQL is tuned to gain the best performance from the available resources.
  • Initial security configurations.
  • Training to cover the basics of PostgreSQL and setup
  • We can advise on any further steps that could be required, including upgrades, replication etc.

Health Check

Our 15 step health check will provide a comprehensive report on an existing database server. The detailed document will include cover the following areas along with any recommendations:

  • Current Environment
  • PostgreSQL server performance assessment
  • Database design performance checks
  • Security audit
  • Backup and recovery audit
  • Performance Tuning

Upgrades

Managed and supported upgrades of PostgreSQL to later versions, no matter which version of PostgreSQL you are currently using:

  • Upgrades of PostgreSQL and extensions.
  • Our procedure involves initial planning, pre-testing ,implementing and full testing
  • A period of dual running old and new is often possible.

Training Courses

  • Online courses available on request
  • Geoascent Academy offers predefined and custom training courses for open source geospatial software tools.
  • Knowledgeable and experienced trainers
  • Small class sizes Practical exercises with step-by-step guidance
  • A personal touch, we want to make sure everyone makes the most from our training
  • The trainer is available before, during and after to answer your questions
  • Courses can be customised towards a customer as well as standard offerings

Standard courses available: