[OSM-dev] invalid geometry in planet_polygon

nimix melchiormoos at gmail.com
Tue Aug 24 16:25:48 BST 2010



Stefan de Konink-3 wrote:
> 
> 
> It is really a bitch that PostgreSQL cannot use the ST_IsValid as index
> in queries. Yes, you could manually do the boolean operation yourself,
> but still it would be quite handy if the validness wouldn't be checked
> at all if it was valid in the first place.
> 
> 
> 

Why not? I think an index like [1] should work and speed up your queries as
the validity is only checked once on insert or on the build operation.
regards,
Melchior

[1]
CREATE INDEX idx_planet_osm_polygon_valid ON planet_osm_polygon USING btree
(ST_IsValid(way));

-- 
View this message in context: http://gis.638310.n2.nabble.com/invalid-geometry-in-planet-polygon-tp5454655p5457332.html
Sent from the Developer Discussion mailing list archive at Nabble.com.



More information about the dev mailing list