> Any words of warning about using a trigger and storing the data on a 10 cm > grid like i suggest? You may need to be aware of the differences between coordinates generated by ST_SnapToGrid, and coordinates generated by conversion from text. I wrote a bit about this at http://gis.stackexchange.com/a/204431/18189 Dan