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.
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
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.
QGIS & PostGIS Training Courses
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.
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.