Re: [postgis-users] Postgis 1.5 core dumps on GEOSIntersects with side location conflict
Hi, On this 1.5 version, query is raising an error but does not crash the server: PostgreSQL 9.1.5 on x86_64-apple-darwin11.4.0, compiled by i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2336.9.00), 64-bit POSTGIS=1.5.3 GEOS=3.3.5-CAPI-1.7.5 PROJ=Rel. 4.8.0, 6 March 2012 LIBXML=2.7.3 USE_STATS Using the geography data type, which I think is preferred in your case, the query works: SELECT ST_intersects( st_geogfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))'), st_geogfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))') ); Nicolas On 20 September 2012 18:29, Adam work@gmail.com wrote: Thx I was wondering how we could fix existing geometries. ST_SimplifyPreserveTopology did a nice job on the one I mentioned in the email. Still would like Postgis1.5 not to core dump on this condition though... On Thu, Sep 20, 2012 at 11:04 AM, Dave Potts dave.po...@pinan.co.uk wrote: I have used the jts library and have the same type of issue In jts you would 1. Try to use a buffer of 0. 2. Try calling one of the simplify geom operations. Dave. Adam wrote: Running this query against Postgis 1.5 causes a core dump: SELECT ST_intersects( geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326), geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326) ); Running against Postgis 2.0 gives the following error (much preferred to get an error than a core dump!): ERROR: GEOSIntersects: TopologyException: side location conflict at 31.81640625 67.32421875 CONTEXT: SQL function st_intersects statement 1 Both are using geos version: '3.3.5-CAPI-1.7.5'. Unfortunately upgrading to Postgis 2 is not an option for us. Our platform is Solaris 10 x86 using 64 bit builds. From dbx the core file shows: [1] 0x1b408d(0x1, 0x1, 0x474e5543432b2b00, 0xbe0170, 0xfd7fffdf8880, 0x1b408d), at 0x1b408d [2] _Unwind_RaiseException_Body(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfd7ffec416bc [3] _SUNW_Unwind_RaiseException(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfd7ffec418a9 [4] __cxa_throw(obj = (nil), tinfo = (nil), dest = (nil)), line 75 in eh_throw.cc [5] geos::geomgraph::EdgeEndStar::propagateSideLabels(this = 0xfd7ffe6e2a00, geomIndex = 0), line 69 in new_allocator.h [6] _ZN4geos9geomgraph11EdgeEndStar16computeLabellingEPSt6vectorIPNS0_13GeometryGraphESaIS4_EE(this = 0x91bc10, geomGraph = 0xfd7fffdf8e18), line 88 in EdgeEndStar.cpp [7] geos::operation::relate::RelateComputer::labelNodeEdges(this = 0xfd7fffdf8e30), line 327 in RelateComputer.cpp [8] geos::operation::relate::RelateComputer::computeIM(this = 0xfd7fffdf8e30), line 131 in RelateComputer.cpp [9] geos::operation::relate::RelateOp::relate(a = (nil), b = (nil)), line 43 in RelateOp.cpp [10] geos::geom::Geometry::intersects(this = 0x91b598, g = 0x91b638), line 191 in memory [11] GEOSIntersects_r(extHandle = 0x91d100, g1 = (nil), g2 = (nil)), line 351 in geos_ts_c.cpp [12] GEOSIntersects(g1 = (nil), g2 = (nil)), line 139 in geos_c.cpp [13] intersects(fcinfo = 0xfd7fffdf9110), line 2322 in lwgeom_geos.c [14] ExecMakeFunctionResult(fcache = 0xfd7fffdf90d0, econtext = 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5a9d88 [15] ExecEvalAnd(andExpr = (nil), econtext = 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5aaf23 [16] ExecProject(projInfo = 0xbd6c40, isDone = 0xfd7fffdf95bc), at 0x5ae659 [17] ExecResult(node = 0xbd5630), at 0x5ba7d0 [18] ExecProcNode(node = 0xbd5630), at 0x5a77ec [19] standard_ExecutorRun(queryDesc = 0xbcd2e8, direction = ForwardScanDirection, count = 1), at 0x5a550c [20] fmgr_sql(fcinfo = 0xfd7fffdf9880), at 0x5b1529 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list
Re: [postgis-users] Postgis 1.5 core dumps on GEOSIntersects with side location conflict
This occurs because the geometries are invalid, and the current intersects algorithm used in JTS/GEOS has kittens when invalid geometries are used as input. The core dump thing is unfortunate (and obviously got fixed in later versions). You might say surely this shouldn't cause such a serious error, and I'd agree. Probably what should happen in the case of invalid geometries input to predicates is that they return a (possibly bogus) result. You might then say but obviously they do intersect, so why can't the result be correct?, and in this case I'd also agree. The intersects algorithm could be enhanced to detect intersection correctly in almost all cases, valid or not. (Some of the other predicates might not be so tolerant - but still a best effort strategy would be nicer than outright failure). But that's all work for the future (and get in touch if you have funding to offer!) For now, all you can do is to check validity before running the ST_intersects function in some way. The nicest way to do this would be to create a new function which does the validity check internally. And that function could also be enhanced to do some other kinds of intersection checks, to try and detect intersection for any inputs. For instance, in this case ST_intersects could be run safely on the geometry boundary linework, and will then report the correct answer. This could be supplemented with some point-in-polygon checks to catch the situation of disjoint boundaries. Alternatively, if invalid polygons are detected the buffer(0) trick could be used to try and clean them. On 9/20/2012 7:37 AM, Adam wrote: Running this query against Postgis 1.5 causes a core dump: SELECT ST_intersects( geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326), geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326) ); Running against Postgis 2.0 gives the following error (much preferred to get an error than a core dump!): ERROR: GEOSIntersects: TopologyException: side location conflict at 31.81640625 67.32421875 CONTEXT: SQL function st_intersects statement 1 Both are using geos version: '3.3.5-CAPI-1.7.5'. Unfortunately upgrading to Postgis 2 is not an option for us. Our platform is Solaris 10 x86 using 64 bit builds. From dbx the core file shows: [1] 0x1b408d(0x1, 0x1, 0x474e5543432b2b00, 0xbe0170, 0xfd7fffdf8880, 0x1b408d), at 0x1b408d [2] _Unwind_RaiseException_Body(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfd7ffec416bc [3] _SUNW_Unwind_RaiseException(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfd7ffec418a9 [4] __cxa_throw(obj = (nil), tinfo = (nil), dest = (nil)), line 75 in eh_throw.cc [5] geos::geomgraph::EdgeEndStar::propagateSideLabels(this = 0xfd7ffe6e2a00, geomIndex = 0), line 69 in new_allocator.h [6] _ZN4geos9geomgraph11EdgeEndStar16computeLabellingEPSt6vectorIPNS0_13GeometryGraphESaIS4_EE(this = 0x91bc10, geomGraph = 0xfd7fffdf8e18), line 88 in EdgeEndStar.cpp [7] geos::operation::relate::RelateComputer::labelNodeEdges(this = 0xfd7fffdf8e30), line 327 in RelateComputer.cpp [8] geos::operation::relate::RelateComputer::computeIM(this = 0xfd7fffdf8e30), line 131 in RelateComputer.cpp [9] geos::operation::relate::RelateOp::relate(a = (nil), b = (nil)), line 43 in RelateOp.cpp [10] geos::geom::Geometry::intersects(this = 0x91b598, g = 0x91b638), line 191 in memory [11] GEOSIntersects_r(extHandle = 0x91d100, g1 = (nil), g2 = (nil)), line 351 in geos_ts_c.cpp [12] GEOSIntersects(g1 = (nil), g2 = (nil)), line 139 in geos_c.cpp [13] intersects(fcinfo = 0xfd7fffdf9110), line 2322 in lwgeom_geos.c [14] ExecMakeFunctionResult(fcache = 0xfd7fffdf90d0, econtext = 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5a9d88 [15] ExecEvalAnd(andExpr = (nil), econtext = 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5aaf23 [16] ExecProject(projInfo = 0xbd6c40, isDone = 0xfd7fffdf95bc), at 0x5ae659 [17] ExecResult(node = 0xbd5630), at 0x5ba7d0 [18] ExecProcNode(node = 0xbd5630), at 0x5a77ec [19] standard_ExecutorRun(queryDesc = 0xbcd2e8, direction = ForwardScanDirection, count = 1), at 0x5a550c [20] fmgr_sql(fcinfo = 0xfd7fffdf9880), at 0x5b1529 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users No virus found in this message. Checked by AVG - www.avg.com http://www.avg.com Version: 2012.0.2221 / Virus Database: 2441/5281 - Release Date: 09/20/12 ___ postgis-users mailing list postgis-users@postgis.refractions.net
[postgis-users] Postgis 1.5 core dumps on GEOSIntersects with side location conflict
Running this query against Postgis 1.5 causes a core dump: SELECT ST_intersects( geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326), geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326) ); Running against Postgis 2.0 gives the following error (much preferred to get an error than a core dump!): ERROR: GEOSIntersects: TopologyException: side location conflict at 31.81640625 67.32421875 CONTEXT: SQL function st_intersects statement 1 Both are using geos version: '3.3.5-CAPI-1.7.5'. Unfortunately upgrading to Postgis 2 is not an option for us. Our platform is Solaris 10 x86 using 64 bit builds. From dbx the core file shows: [1] 0x1b408d(0x1, 0x1, 0x474e5543432b2b00, 0xbe0170, 0xfd7fffdf8880, 0x1b408d), at 0x1b408d [2] _Unwind_RaiseException_Body(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfd7ffec416bc [3] _SUNW_Unwind_RaiseException(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfd7ffec418a9 [4] __cxa_throw(obj = (nil), tinfo = (nil), dest = (nil)), line 75 in eh_throw.cc [5] geos::geomgraph::EdgeEndStar::propagateSideLabels(this = 0xfd7ffe6e2a00, geomIndex = 0), line 69 in new_allocator.h [6] _ZN4geos9geomgraph11EdgeEndStar16computeLabellingEPSt6vectorIPNS0_13GeometryGraphESaIS4_EE(this = 0x91bc10, geomGraph = 0xfd7fffdf8e18), line 88 in EdgeEndStar.cpp [7] geos::operation::relate::RelateComputer::labelNodeEdges(this = 0xfd7fffdf8e30), line 327 in RelateComputer.cpp [8] geos::operation::relate::RelateComputer::computeIM(this = 0xfd7fffdf8e30), line 131 in RelateComputer.cpp [9] geos::operation::relate::RelateOp::relate(a = (nil), b = (nil)), line 43 in RelateOp.cpp [10] geos::geom::Geometry::intersects(this = 0x91b598, g = 0x91b638), line 191 in memory [11] GEOSIntersects_r(extHandle = 0x91d100, g1 = (nil), g2 = (nil)), line 351 in geos_ts_c.cpp [12] GEOSIntersects(g1 = (nil), g2 = (nil)), line 139 in geos_c.cpp [13] intersects(fcinfo = 0xfd7fffdf9110), line 2322 in lwgeom_geos.c [14] ExecMakeFunctionResult(fcache = 0xfd7fffdf90d0, econtext = 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5a9d88 [15] ExecEvalAnd(andExpr = (nil), econtext = 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5aaf23 [16] ExecProject(projInfo = 0xbd6c40, isDone = 0xfd7fffdf95bc), at 0x5ae659 [17] ExecResult(node = 0xbd5630), at 0x5ba7d0 [18] ExecProcNode(node = 0xbd5630), at 0x5a77ec [19] standard_ExecutorRun(queryDesc = 0xbcd2e8, direction = ForwardScanDirection, count = 1), at 0x5a550c [20] fmgr_sql(fcinfo = 0xfd7fffdf9880), at 0x5b1529 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Postgis 1.5 core dumps on GEOSIntersects with side location conflict
I have used the jts library and have the same type of issue In jts you would 1. Try to use a buffer of 0. 2. Try calling one of the simplify geom operations. Dave. Adam wrote: Running this query against Postgis 1.5 causes a core dump: SELECT ST_intersects( geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326), geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326) ); Running against Postgis 2.0 gives the following error (much preferred to get an error than a core dump!): ERROR: GEOSIntersects: TopologyException: side location conflict at 31.81640625 67.32421875 CONTEXT: SQL function st_intersects statement 1 Both are using geos version: '3.3.5-CAPI-1.7.5'. Unfortunately upgrading to Postgis 2 is not an option for us. Our platform is Solaris 10 x86 using 64 bit builds. From dbx the core file shows: [1] 0x1b408d(0x1, 0x1, 0x474e5543432b2b00, 0xbe0170, 0xfd7fffdf8880, 0x1b408d), at 0x1b408d [2] _Unwind_RaiseException_Body(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfd7ffec416bc [3] _SUNW_Unwind_RaiseException(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfd7ffec418a9 [4] __cxa_throw(obj = (nil), tinfo = (nil), dest = (nil)), line 75 in eh_throw.cc [5] geos::geomgraph::EdgeEndStar::propagateSideLabels(this = 0xfd7ffe6e2a00, geomIndex = 0), line 69 in new_allocator.h [6] _ZN4geos9geomgraph11EdgeEndStar16computeLabellingEPSt6vectorIPNS0_13GeometryGraphESaIS4_EE(this = 0x91bc10, geomGraph = 0xfd7fffdf8e18), line 88 in EdgeEndStar.cpp [7] geos::operation::relate::RelateComputer::labelNodeEdges(this = 0xfd7fffdf8e30), line 327 in RelateComputer.cpp [8] geos::operation::relate::RelateComputer::computeIM(this = 0xfd7fffdf8e30), line 131 in RelateComputer.cpp [9] geos::operation::relate::RelateOp::relate(a = (nil), b = (nil)), line 43 in RelateOp.cpp [10] geos::geom::Geometry::intersects(this = 0x91b598, g = 0x91b638), line 191 in memory [11] GEOSIntersects_r(extHandle = 0x91d100, g1 = (nil), g2 = (nil)), line 351 in geos_ts_c.cpp [12] GEOSIntersects(g1 = (nil), g2 = (nil)), line 139 in geos_c.cpp [13] intersects(fcinfo = 0xfd7fffdf9110), line 2322 in lwgeom_geos.c [14] ExecMakeFunctionResult(fcache = 0xfd7fffdf90d0, econtext = 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5a9d88 [15] ExecEvalAnd(andExpr = (nil), econtext = 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5aaf23 [16] ExecProject(projInfo = 0xbd6c40, isDone = 0xfd7fffdf95bc), at 0x5ae659 [17] ExecResult(node = 0xbd5630), at 0x5ba7d0 [18] ExecProcNode(node = 0xbd5630), at 0x5a77ec [19] standard_ExecutorRun(queryDesc = 0xbcd2e8, direction = ForwardScanDirection, count = 1), at 0x5a550c [20] fmgr_sql(fcinfo = 0xfd7fffdf9880), at 0x5b1529 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Postgis 1.5 core dumps on GEOSIntersects with side location conflict
Thx I was wondering how we could fix existing geometries. ST_SimplifyPreserveTopology did a nice job on the one I mentioned in the email. Still would like Postgis1.5 not to core dump on this condition though... On Thu, Sep 20, 2012 at 11:04 AM, Dave Potts dave.po...@pinan.co.uk wrote: I have used the jts library and have the same type of issue In jts you would 1. Try to use a buffer of 0. 2. Try calling one of the simplify geom operations. Dave. Adam wrote: Running this query against Postgis 1.5 causes a core dump: SELECT ST_intersects( geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326), geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326) ); Running against Postgis 2.0 gives the following error (much preferred to get an error than a core dump!): ERROR: GEOSIntersects: TopologyException: side location conflict at 31.81640625 67.32421875 CONTEXT: SQL function st_intersects statement 1 Both are using geos version: '3.3.5-CAPI-1.7.5'. Unfortunately upgrading to Postgis 2 is not an option for us. Our platform is Solaris 10 x86 using 64 bit builds. From dbx the core file shows: [1] 0x1b408d(0x1, 0x1, 0x474e5543432b2b00, 0xbe0170, 0xfd7fffdf8880, 0x1b408d), at 0x1b408d [2] _Unwind_RaiseException_Body(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfd7ffec416bc [3] _SUNW_Unwind_RaiseException(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfd7ffec418a9 [4] __cxa_throw(obj = (nil), tinfo = (nil), dest = (nil)), line 75 in eh_throw.cc [5] geos::geomgraph::EdgeEndStar::propagateSideLabels(this = 0xfd7ffe6e2a00, geomIndex = 0), line 69 in new_allocator.h [6] _ZN4geos9geomgraph11EdgeEndStar16computeLabellingEPSt6vectorIPNS0_13GeometryGraphESaIS4_EE(this = 0x91bc10, geomGraph = 0xfd7fffdf8e18), line 88 in EdgeEndStar.cpp [7] geos::operation::relate::RelateComputer::labelNodeEdges(this = 0xfd7fffdf8e30), line 327 in RelateComputer.cpp [8] geos::operation::relate::RelateComputer::computeIM(this = 0xfd7fffdf8e30), line 131 in RelateComputer.cpp [9] geos::operation::relate::RelateOp::relate(a = (nil), b = (nil)), line 43 in RelateOp.cpp [10] geos::geom::Geometry::intersects(this = 0x91b598, g = 0x91b638), line 191 in memory [11] GEOSIntersects_r(extHandle = 0x91d100, g1 = (nil), g2 = (nil)), line 351 in geos_ts_c.cpp [12] GEOSIntersects(g1 = (nil), g2 = (nil)), line 139 in geos_c.cpp [13] intersects(fcinfo = 0xfd7fffdf9110), line 2322 in lwgeom_geos.c [14] ExecMakeFunctionResult(fcache = 0xfd7fffdf90d0, econtext = 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5a9d88 [15] ExecEvalAnd(andExpr = (nil), econtext = 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5aaf23 [16] ExecProject(projInfo = 0xbd6c40, isDone = 0xfd7fffdf95bc), at 0x5ae659 [17] ExecResult(node = 0xbd5630), at 0x5ba7d0 [18] ExecProcNode(node = 0xbd5630), at 0x5a77ec [19] standard_ExecutorRun(queryDesc = 0xbcd2e8, direction = ForwardScanDirection, count = 1), at 0x5a550c [20] fmgr_sql(fcinfo = 0xfd7fffdf9880), at 0x5b1529 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] PostGIS 1.5
Hello I try to restore a database was created and backed-up in PostGIS 1.3.5 to PostGIS 1.5 the geometry cant be restored any hint please how to deal with the problem. Where i can find PostGIS 1.3.5 windows binaries. Kind regards _ Hotmail: Powerful Free email with security by Microsoft. https://signup.live.com/signup.aspx?id=60969___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 1.5
Hello, Look depending of postgresql installation into http://postgis.refractions.net/download/windows/pg82/ http://postgis.refractions.net/download/windows/pg83/ http://postgis.refractions.net/download/windows/pg84/ For upgrading database, go to http://wiki.debian.org/DebianGis/UpdatingPostGIS for some advices Regards ThomasG GIS specialist ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users