#POSTGIS IRC Log - 2008-07-10

For logs after Feb 3, 2007, all times are GMT-8. Prior logs are GMT-9.
Back to Logs
05:16:52 CIA-6: robe * r2837 /trunk/doc/reference.xml: Examples of using ST_ExteriorRing and ST_NumInteriorRings
08:05:52 zanberdo: How can I protect against a topologyException with an st_within query when I include two overlapping geometries?
08:09:28 zanberdo: I think what I'm looking for is a why to accept overlapping geometries and combine them into a single geometry that can then be used with the st_within function
08:37:26 zanberdo: the gist of the problem is that the gui that's used to generate several polygons can permit overlapping and non-overlapping polygons to exists. It's bound to a single layer in mapserver for rendering purposes. I'm building a single multipoly object to pass to the query. I've tested nested st_unions with postgres, but that's not going to work well with mapserver, as the query is static ( well, generally so )...
08:38:29 zanberdo: I'm reading the docs for postgis and there is reference to an st_union function that states it takes a geometry set, but either I haven't got this function ( using postgis 8.2 ) or I"m not setting the geometry set correctly
14:51:58 landonf: Are ESRI .prj files to be trusted? Wondering why shp2pgsql ignores them.
16:40:43 landonf: What possible datums could 'local astronomical datum' refer to?