Customers

Key Projects and Delivery 2015 - 2018


Geospatial metadata catalogue

Development of auto-updating easy manageable internal metadata catalogue for the record and maintenance of data in large and wide ranging local authority spatial data holding. Opensource tools of QGIS and PostrgreSQL / PostGIS are the basis for the catalogue whereby the majority of data field are dynamically populated. Users are able to search the catalogue and load map layers into the QGIS project.

database diagram
astun training image

Traffic Regulation Order Spatial Database and Management Workflow with QGIS

Development of PostgreSQL / PostGIS and QGIS to provide an intelligent workflow to support the lifespan of a Traffic Regulation from conception and drafting through to revocation. The system sycronises with the legal process to ensure data is developed and published approriatley to the legal requirements. The project utilised both row level and column based database security to ensure precise access requirements are granted to managers, drafters and the public





Local Authority Asset and Land Terrier database using opensource tools

Astun Technology

With the use open source tools we have been able to build and replicate an archiac proprietary database system holding a Local Authority's land terrier, assets and lease data. Based on an existing structure we able enhance and build an improved relational database in PostgreSQL including user managed lookups and cases tools for valuations and rent reviews. An interface is designed through QGIS development to provide a completely open coded single database solution with a mapping elements, gaining all the benefits of GIS.

database diagram
astun training image

QGIS & PostGIS Training Courses

Astun Technology

We have built, created training material and delivered an opensource training programme on behalf of Astun Technology in PostGIS and QGIS training from it's launch in 2011 through to 2016.





GIS Strategy for Salisbury Area Greenspace Partnership

Salisbury Area Greenspace Partnership

Our green spaces are under increasing pressure from development and reduced funding resources while at the same time they are recognised as vital for the health and wellbeing of our communities and for the wildlife they support. Hence, the need for greenspace to be valued, well connected and managed for the benefit of all has never been more important. OGIS has been supporting SAGP in their work to record Greenspace in the Salisbury Area and deveoped a sustainable GIS strategy for this small but vital partnership organisation.

astun training image
astun training image

IDOX Acolaid Consultancy

Borough of Poole

We make a big thing about open source but when it comes down to it our skill stretch further into other worlds. By providing some assistance and technical experticse in IDOX Acolaid, Cadcorp and Mircosoft SQL Server we have ensured that the Borough of Poole's land charges are working efficiently and less officer time is take up system tecnicalities. Helping staff to what they are good at!

Local Authority Data Research Analysts

Borough of Poole

Borough of Poole are adopting QGIS as their mainstream desktop GIS. Having proving a range of introductory training early in 2015 we returned to provide some more speciatist training for research and data analysts at the Authority. A custom training course was provided focused around using census data and vector analysis tools within QGIS.

Training docs

GIS & Spatial Database Services

Academy
Training
Opensource GIS and database training courses from the GeoAscent Academy.
Consultancy
Consultancy
SQL, Databases, GIS, Ordnance Survey, Public Sector Mapping.
Support
Support
Support for your open source GIS solution.