On Tue, May 15, 2012 at 3:02 PM, Duarte Carreira <dncarreira at gmail.com> wrote: > - is there anyway i can get this to work in postgis 1.4 (main question)? Oh, you're getting text and PostgreSQL has some quite powerful regex functions. You can probably strip the Z from the text before passing it along to PostGIS. P.