Tag: Postgis

Manage spatial data Versions like a pro with GIS Open source version control tools

Manage spatial data Versions like a pro with GIS Open source version control tools

Agile, Data, Database, DevOps, General, Opensource, QGIS, Software
It's time to introduce DevOps to your GIS Data management workflow. If your organization manages big volumes of data, commonly referred to as Big Data, your workflows exhibit these common scenarios; Multiuser distributed data editing, frequent check-out and check-in of spatial data, data versions comparison over short time changes, edits conflict resolution, maintenance of the different versions against the production version during the lifecycle of data collection, cleansing, development and production. DevOps is a new term that has grown in the GEO-IT industry and GIS is not sidelined in its applicability. It presents a set of principles that in GIS would elaborate how to apply agility in administration and operation of your organizational data development lifecycle. It expands the va...
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
Which, Why and When. PostGIS vs SpatiaLite

Which, Why and When. PostGIS vs SpatiaLite

Applications, Database, General, Industry
Last time we talked on why PostGIS should be the database friend of a GISer , and we touched on most of the features that sets the GIS PostgreSQL extension far from any other spatial database. Of course, PostgreSQL is not the only spatial database that can get your work done, and as one of our readers had suggested, today we will be looking on why and when should choose between PostGIS and SpatiaLite. First things first. SpatiaLite is a variant of the SQLite database that also provides GIS features. It uses the GEOS, PROJ.4, etc... libraries that are also used in PostGIS, and hence the resulting feature set is similar. So what is the difference between the two ? Which one should you pick? Lets find out through a side by side comparison. 1.Scale of Project SpatiaLite is probably t...
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...
Laban Karanja: “GIS is already becoming a darling of the business world..”

Laban Karanja: “GIS is already becoming a darling of the business world..”

Interviews
Hi! My name is Laban Karanja - currently working as a Solutions Engineer with Esri Eastern Africa. Sounds like a grand title but it basically means that my job is to craft ArcGIS - based solutions for people/organizations who need them. I wasn't always into GIS (actually most of the people I work with would tell you I'm more into the 'IS' part of it than I am the 'G') - I stumbled onto it when I applied for a job at the company I currently work for. I studied Telecommunication Engineering at JKUAT many moons ago but never managed to join that sector. GIS was a bit more welcoming and I'm glad that I ended up here. Hobbies? I'm all about sleep, watching and listening to audio interviews and reading articles about the music business.   You can find Laban on Twitter @sowanch  also

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…)