Making the Move to #PostGIS - how I started to get back into databases again.
Originally posted in xyHt 21st Feb 2018: http://www.xyht.com/spatial-itgis/using-shipping-data-gis/ We've all been dazzled by these awesome maps which animate ships or aircraft as they move in near real time, but how do they work? What magic sits beneath the hood? As luck would have it, whilst working with the offshore wind farm industry I had to do … Continue reading Using Live Shipping Data in GIS
Why is a spatial index important?
Indexes are what make using a spatial database for large data sets possible. Without indexing, any search for a feature would require a "sequential scan" of every record in the database