Tags » PostGIS

Upgrading Postgres & PostGIS on Windows

Major upgrades for both PostGIS and Postgresql were released in the last few weeks.  Postgres moved from 9.5 to 9.6 and PostGIS from 2.2 to 2.3.   301 more words


Visualizing SQL layers as web maps using Carto JS

Carto (formerly known as CartoDB) layers have SQL capabilities as they are stored in a cloud based PostGIS server. Users can initiate SQL expressions and visualize… 398 more words


Detecting duplicated geometries in a PostGIS table

Hi there!

Today I want to make a small post and talk about another annoying problem: Duplicated Geometries!

How can you identify which geometries are duplicated in your table? 133 more words


Detecting spikes in geometries using angle threshold

Hi there,

We all know that search for errors in geometries can be quite a journey. One of the errors we need to fix is the presence of spikes in our geometries. 288 more words


Sync your Swarm check-ins to a Carto map

So, you’re a swarm (former foursquare, before the split) user, and want to see all your check-ins in a map. Of course, you want to use… 637 more words


Movement data in GIS: issues & ideas

Since I’ve started working, transport and movement data have been at the core of many of my projects. The spatial nature of movement data makes it interesting for GIScience but typical GIS tools are not a particularly good match. 551 more words


Import Data PostGIS

Hallo, gue belajar lagi mengenai GIS, tapi kali ini menghubungkan data base yang ada di postgreSQL, PostGIS dengan Leaflet JS. Intro sedikit, Map ini akan menggunakan data spatial dari PostGIS dan data base dari PostgreSQL yang akan ditampilkan di Leaflet JS. 153 more words