Global Parametrics, Optimization of a multi-TB data repository

February 2019 - August 2019

Global Parametrics is maintaining a large repository of geophysical scientific data that is updated daily and consumed by scientists to develop risk models for hazards and disasters. allspatial is responsible for creating an optimized database structure, improving query performance and ensuring that spatial data is delivered efficiently, refining existing ETL (Extract-Transform-Load) workflows as well as developing new ones.

Technology Stack: PostgreSQL/PostGIS, Citus, CentOS, Python, gdal/ogr, Shell and SQL scripts (implementing ETL workflows), Docker

Seychelles, WB / GFDRR, Open Cities Africa Seychelles

April 2018 - August 2019

Open Cities Africa is a technology- and data-driven project funded by the WB/GFDRR and implemented by allspatial. The projects aims at improving disaster risk management by supporting better informed decisions during all phases of disaster risk management. Under the project risk relevant data is collected and utilised to better understand and visualise hazards (in particular urban and coastal flooding). OpenStreetMap and a community mapping approach are used to collect the required data on exposure (and hazards). A tool is developed that will extract risk relevant data from OpenStreetMap regularly and import it into the main geodatabase of the Centre for GIS. From there data can be accessed by risk management agencies and first responders through standard web services such as WFS, WMS and Vector Tile Service.

Technology Stack: OpenStreetMap, JOSM, PostgreSQL/PostGIS, gdal/ogr, Mapbox Vector Tiles, Tegola, Shell and SQL scripts (implementing ETL workflows)

Seychelles, UNDP / CEPF, Implementation of an information system for biodiversity conservation management

November 2017 - December 2019

To support ICS and other environmental organisations in biodiversity conservation management allspatial and Dr. Bruno Senterre are implementing a relating information system. The system will be cloud-based, has a strong spatial component and aims at facilitating the maintenance, management and analysis of monitoring data.

Technology Stack: PostgreSQL/PostGIS, QT/C++, Go, GraphQL, Mapbox Vector Tiles, SQLITE/GeoPackage, Tegola

Seychelles, SFRSA, Design and implementation of a customised GIS

July 2017 - October 2017

allspatial designed and implemented a customised GIS for the Seychelles Fire and Rescue Services Agency (SFRSA). The GIS provides the SFRSA with tools to capture incidents and fire safety inspections. So far incidents have been captured through a paper log book only. With the GIS-based capturing of incidents the SFRSA can perform crucial (spatial) analysis even before a crew is dispatched to the incident site. Thus, the crew can better prepare for handling the incident, e.g. by identifying premises that require evacuation, etc.

Capturing an incident

Technology Stack: PostgreSQL/PostGIS, QGIS, PyQt, Python

Seychelles, MHILT, Design and implementation of a mobile WebGIS

June 2017 - September 2017

allspatial designed and implemented a WebGIS (Mobile WebGIS) optimised for mobile devices for the Ministry of Habitat, Infrastructure and Land Transport (MHILT). The WebGIS provides various customised tools such as to search for parcels and beacons, map and register a business, etc.

Technology Stack: mapbox-gl-js, Vue, JavaScript, PHP, Mapbox Vector Tiles, Tegola, PostgreSQL/PostGIS

Cambodia, GIZ, Cambodian Cadastre Information System (CCIS) for the Ministry of Land Management, Urban Planning and Construction (MLMUPC)

November 2015 - August 2017

Supported and funded by GIZ -- allspatial, GCI/Germany and the Cadastral Information Technology (CIT) Department implemented a new Cambodian Cadastre Information System (CCIS) for the MLMUPC. CCIS reflects and supports the workflows to register different types of property and relating ownership in compliance with Cambodian land law and regulations. The new CCIS will replace the existing CCIS which has a number of limits and shortcomings and is technologically outdated. As a final step before switching from the old CCIS the new one the CIT Department has to migrate the data from the old database management system to the new one. allspatial has provided the CIT Department with the required tools and database scripts accordingly.

Technology Stack: PostgreSQL/PostGIS, Slony, QGIS, PyQt, Python, SQLAlchemy/GeoAlchemy, Pentaho Report Designer, libfprint (for fingerprint registration of land owners), FME

Mongolia, ALAGaC, Design and implementation of a Land Information System

March 2014 - August 2017

allspatial, Topmap/Mongolia and GCI/Germany implemented a customized Land Information System (LIS) for the Administration of Land Affairs, Geodesy and Cartography of Mongolia (ALAGaC). The LIS reflects the main business processes of ALAGaC with regard to land administration and management and is used by ALAGaC's land offices all over the country and at the headquarter in Ulaanbaatar.

Technology Stack: PostgreSQL/PostGIS, Bucardo, QGIS, PyQt, Python, SQLAlchemy/GeoAlchemy, Debian

Seychelles, Cable&Wireless, Design and implementation of a customised GIS

July 2016 - January 2017

allspatial designed and implemented a spatial database and customised GIS (QGIS + plugin) for Cable&Wireless. The GIS provides tools that allow Cable&Wireless to capture their network assets such as distribution points, joints, cabinets, etc.

Capturing a cabinet

Technology Stack: PostgreSQL/PostGIS, QGIS, PyQt, Python, Shell scripts

Seychelles and Mauritius, GFDRR / World Bank, Open Data for Resilience Initiative (OpenDRI)

May 2015 - August 2016

As part of the OpenDRI of GFDRR / World Bank allspatial performed an assessment of the status quo at governement organisations in the Seychelles and Mauritius with regard to geospatial data, agreements on data sharing, geospatial capacities, etc. As a result an assessment report was prepared for each country and presented to the organisations together with recommendations on those areas that have room for improvement. allspatial also set up and customised a data portal based on the Open Source Software GeoNode (Seychelles Data Portal). This portal facilitates data sharing among organisations that maintain and use geospatial information. The portal is hosted by the Division for Risk and Disaster Management of the Seychelles (DRDM). With numerous government organisations of the Seychelles a permanent working group (working group on Facebook) was established to facilitate data sharing on institutional level, push forward the geospatial sector in general and set and apply relating standards. The working group meets regularly (each two months), discusses current (geospatial) matters and does capacity building and presentations on new standards and technologies.

Technology Stack: OpenStreetMap, QGIS, InaSAFE, GeoNode, PostgreSQL/PostGIS

Seychelles, IFAD/CLISSA, Design and implementation of a spatial database at the Seychelles Agricultural Agency (SAA)

December 2015 - March 2016

allspatial designed and implemented a spatial database for the SAA and provided a three-day training course on GIS Basics to SAA and IFADC/CLISSA staff.

Technology Stack: PostgreSQL/PostGIS, QGIS

Seychelles, UNDP, Implementation of a geodatabase for the Climate Science and Data Management (CSDM) Section at the Ministry of Environment, Energy and Climate Change (MEECC)

December 2015 - March 2016

allspatial designed and implemented a geodatabase to store all vector data and some of the raster data CSDM was maintaining so far in file formats only. About 2600 ESRI Shapefiles and high resolution aerial photos (GeoTiff/ECW) for nine of the inner islands were imported. It is much easier now for CSDM to share and update data, avoid redundant data and enable fine-grained user access to data. For the CSDM Team to be able to perform basic database tasks themselves allspatial provided a training on database configuration and administration.

Technology Stack: PostgreSQL/PostGIS, QGIS, Debian, gdal/ogr, Shell and SQL scripts (implementing ETL workflows)

Seychelles, Ministry of Foreign Affairs and Transport, Implementation of a Project Information Management System

December 2014 - March 2015

For the management of information on donor-funded projects in the Seychelles MS Excel was used so far by the Ministry of Foreign Affairs and Transport (MFA). This made any updates cumbersome and error-prone. Access restrictions were difficult to implement and various copies of the same document existed in different versions. To overcome these shortcomings a Project Information Management System (PIMS) was implemented by allspatial. The system reflects a client-server architecture with a database running on the server and a desktop application on client-side. PIMS captures programmes and projects and the relating details on funding, activities, targeted sectors, implementing agencies, etc.

Project Information Management System
Project Information Management System (Full size image)

Technology Stack: PostgreSQL, QT/C++

Seychelles, Ministry of Land Use and Housing, Migration to high performance database server

November 2014

The geodatabase of the Ministry of Land Use And Housing (MLUH) capturing planning information and numerous other spatial datasets was running on pretty outdated server hardware until mid-2014. Besides that the server was never equipped and configured to be run as database server specifically. Accordingly there were frequent issues with regard to performance and availability. Eventually the Planning Authority made the decision to acquire a new server. allspatial provided the specifications for that server and set it up with the sole aim to be run as high performance database server. The operating system is a Debian Linux with the geodatabase running on PostgreSQL and PostGIS. The geodatabase is heavily used by the Planning Authority and other departments within the MLUH and in addition hosts the spatial data required by the WebGIS. Since the migration to the new server in July 2014 the geodatabase is running without any issues and interruptions.

Technology Stack: PostgreSQL/PostGIS, Debian

Benin, KfW, Cadastre software for rural areas

June 2014

Within the scope of a pilot project funded by the KfW allspatial implemented a GIS application to capture cadastre and ownership information in the rural areas of Benin. The aim was an efficient but affordable system. It was decided to record cadastre data with a hand-held GNSS device and the relating ownership information with a tablet. Data from both devices were then imported into a spatial database (PostgreSQL+PostGIS) and related accordingly.

Benin cadastre tools
Cadastre tools for Benin

Technology Stack: PostgreSQL/PostGIS, QGIS, PyQt, Python

Seychelles, UNDP, Vegetation study for 5 islands

July 2013 - July 2014

Funded by UNDP Dr. Bruno Senterre and allspatial created vegetation maps for the islands of Mahe, Praslin, La Digue, Silhouette and Curieuse. The maps reflect the current and potential vegetation of the named islands and will be used for environmental conservation and restoration purposes. The maps of current vegetation were created using supervised classification and were verified and improved through ground truthing and based on high resolution aerial photos. The potential habitat types were derived from numerous spatial datasets based on a set of well defined rules.

Potential habitat types of Mahe
Potential habitat types of Mahe (Full size image)

GIS software used: QGIS, GRASS GIS

Seychelles, Ministry of Land Use and Housing, WebGIS launched

November 2013

The new WebGIS (MLUH WebGIS) of the Ministry of Land Using and Housing was launched on the 2013 GIS Day. The WebGIS provides information on spatial planning and cadastre, tourists information, historical information and maps on the maritime boundaries that the Seychelles share with their neighbouring countries.

Seychelles, Ministry of Land Use and Housing, "Spatializing" planning information

September / October 2013

Planning information of the Planning Authority / Ministry of Land Use and Housing (MLUH) is kept in an MS SQL Server database. However, no spatial relation is maintained in the database for that planning information and thus, the full potential of the information was kept locked. To overcome that situation a synchronization tool was implemented by allspatial. The tool synchronizes new and updated planning information to a spatial database (set up with PostgreSQL + PostGIS). During that process planning information is being "spatialized" by relating it to one or more particular parcels. As a result planning information can easily be mapped and located and spatial analysis be performed. The capabilities arising from that are utilized extensively in the new WebGIS of the MLUH.

Seychelles, Ministry of Land Use and Housing, Implementation of a WebGIS

July / August 2013

allspatial implemented a WebGIS for the Ministry of Land Use and Housing to make land information available to the public through the Internet. Applicants can check the status of their development application online or they can look up the size and number of a plot / parcel. The approved land use plans were made available, too. In addition a routing tool was implemented enabling the user to find the shortest way (or alternatively fastest way) between two locations. The WebGIS will be launched on the GIS Day, November 20, 2013.

WebGIS of the MLUH
WebGIS of the MLUH, identifying the shortest way between two locations (Full size image)

Technology Stack: PostgreSQL/PostGIS, Debian, p.mapper, PHP, JavaScript, jQuery

Seychelles, Ministry of Land Use and Housing, Geodatabase replication setup

June 2013

allspatial set up a master / slave replication for the geodatabase of the Ministry of Land Use and Housing (MLUH). This way the daily work load of the geodatabase is shared among two database servers (master and slave). If data is updated on the master server the update will be available on the slave server a few seconds later only. The MLUH geodatabase captures all kind of land related information and is used heavily by the Planning Authority, the Cadastre Division and the Lands Division. A major part of the land information maintained in the geodatabase will soon be made available to the public through a web-based GIS (Geographic Information System).

Master / Slave setup
Master / Slave setup for the geodatabase (Full size image)

Technology Stack: PostgreSQL/PostGIS

Postgres Plus Professional Certification

May 2013

Michael Wagner, the owner of allspatial successfully took the exam to become a certified Postgres Plus Professional. The certification assesses database professionals' ability to work in demanding, large-scale production environments, and certifies their proficiency. Amongst others the certification requires competence in the areas as follows:

  • PostgreSQL system architecture
  • Transactions and Concurrency
  • Performance Tuning
  • Table Partitioning
  • High Availability & Replication
  • Connection Pooling
  • Monitoring

Seychelles, Ministry of Health, Setting up a high performance database server

March 2013

allspatial set up a PostgreSQL database server at the Ministry of Health. The server hardware was selected with the goal of setting up a high performance database server, and hard- and software were configured and tuned accordingly. The server will host health relating geodata and support the Ministry of Health in disaster and risk management scenarios but also in standard analysis and reporting tasks. In addition a tool is being developed to allow for import of data from the web based Health Surveillance System of the Ministry of Health. This way data from the Health Surveillance System can be joined with geodata to create thematic maps as required. An example would be a map showing the number of Dengue Fever cases per district registered in a particular month.

Technology Stack: PostgreSQL/PostGIS

Seychelles, National Bureau of Statistics, Customised GIS tools for capturing census information

December 2012 / January 2013

allspatial implemented as set of customised GIS tools for the National Bureau of Statistics (NBS). The tools enable the NBS to capture household information and to relate that information spatially by linking it with the buildings / residential structures. This way the number of households (and persons) in a certain district or an arbitrary spatial area can easily be determined.

Households for a selected building
Households for a selected building

While this information is important for the census it is also crucial for disaster and risk management. Thus, with little effort the number of persons (potentially) affected by a flooding or disease outbreak can be determined to take measures for evacuation, first aid, etc.

Technology Stack: PostgreSQL/PostGIS, QGIS, PyQt, Python

Seychelles, Ministry of Health, GIS Training on disaster and disease outbreak management

October 2012

allspatial and the GIS Centre / MLUH provided a one-week training on GIS for Natural Disaster and Disease Outbreak Management at the Ministry of Health. The training covered, among other topics:

  • Creation of zones in which culling or vaccination is required (animal disease outbreak)
  • Identification of the location for road barricades (control points for access to the quarantine zones)
  • Simulation of a Chikungunya outbreak
  • Creation of a Digital Terrain Model (DTM)
  • Identification of the areas that would be flooded if the sea level rises (e.g. in case of a Tsunami)
  • Identification of the households that would need to be evacuated
  • Geospatial statistics

allspatial launched on Mahe

September 2012

allspatial, a consultancy business for geospatial information technology and the relating software, services, customisation and training, was launched on Mahe / Republic of Seychelles. allspatial provides its services in particular to clients in the Seychelles and other countries in the Indian Ocean region.