Tag: PostgreSQL

STDM Code Sprint: Call for Participation

STDM Code Sprint: Call for Participation

Events, General, News, Opensource, QGIS
Code Sprints (also known as Hackathons) are a proven method to develop contributors community around an open source project. To ensure longevity for an open source project, as a sponsor or project owner you have to build capacity to potential contributors who can then invest the same know-how to improving the system for long term sustainability. It would be for this reason that  the Global Land Tool Network (GLTN) is organizing a code sprint that will bring together geospatial experts to further support the enhancement of the Social Tenure Domain Model (STDM) ecosystem. The Event Scheduled take place from April 24 to 27 at the Regional Centre for Mapping of Resources for Development (RCMRD) in Nairobi, Kenya is organized by Metaspatial (Germany) in close cooperation with UN-Habitat and
Why PostGIS is the love of GISers

Why PostGIS is the love of GISers

Applications, Database, Industry, Opensource, Software
We are living in a changing world. A world that is becoming more modern by day. Every individual is now a sensor, generating a continuous flow of location-encoded data, thanks to this new era of location-aware mobile phones , geocoded Computer IP addresses, GPS devices in our cars and so much to list. It is convincing to say that the location aspect of things is now part of our lives. Seemingly, questions never end. How close is the nearest hotel from my office? Where were the crimes in my city for the last two months? What is the shortest route from my home to the hospital? Where should the next emergency station be built so as to minimize the response time? People ask these questions and others like them, every day all over. Answers to these questions and the likes requires a mechanis...

Tracking history in PostGIS databases with Triggers

Database, Learning GIS, Opensource, QGIS, Tutorial
Well, you must have come across some projects that needed tracking of changes in the database or you might be working on one right now.Tracking changes (history recording) is vital in most projects more so where spatial data is involved.Whether you are using MySQL, PostGIS or Oracle Spatial tracking of history in data should be a capability that the database platform should support. (more…)