[OSM-dev] Daily diff fails to import
Sandro Santilli
strk at keybit.net
Thu May 26 18:46:58 BST 2011
On Thu, May 26, 2011 at 06:17:47PM +0100, Brian Quinion wrote:
> Adrian,
>
> I had this occur once with a schema that I had updated between
> versions of postgis. I never did entirely get to the bottom of it - I
> ended up adding ::text in a similar way to what Sandro suggested.
> i.e.:
>
> existing.geometry::text != NEW.geometry::text
>
> It was a crude hack (and probably hurt performance) and didn't seem to
> be needed the result of the time so I never committed it.
I'm sure binary tree operators used to do bounding box checks.
Your ::text cast instead would do a bitwise comparison.
There are few ways to compare geometries, and with recent versions
also Hausdorf distance for similarities.
--strk;
() Free GIS & Flash consultant/developer
/\ http://strk.keybit.net/services.html
More information about the dev
mailing list