Tag: postgis

All the articles with the tag "postgis".

• PostGIS Query Optimisation

  Updated:1 Mar, 2019

  I started to do some work on how efficient the spacial SQL queries I was using are. That meant looking at the indexing that is used on the geometry column

• PostGIS and geoJson

  Updated:25 Feb, 2019

  On with this current theme of spacial systems and mapping, one of the interesting challenges I faced was querying spacial data. My particular problem was t

• DBeaver - SQL GUI

  6 Nov, 2018

  I've used a few SQL GUI's over the years, SQuirreL, DBVisualizer, HeidiSQL, MySQL Workbench, but the one that stands out recently is DBeaver . It's got a c

• PostGIS Import from PHP Session Fails

  Updated:12 Mar, 2018

  Undefined function: 7 ERROR: function st_makepoint(numeric, numeric) does not exist