#POSTGIS IRC Log - 2009-05-27

For logs after Feb 3, 2007, all times are GMT-8. Prior logs are GMT-9.
Back to Logs
07:46:27 strk: pramsey: ding dong dang
07:46:55 pramsey: strk: pong ping pang
08:11:01 sigq: geosfeed: Ticket #215 ( enhancement updated ): Single-sided buffering implementation <http://trac.osgeo.org/geos/ticket/215#comment:10>
08:14:53 sigq: geosfeed: Ticket #254 ( enhancement created ): Geometry cleaning routine for Invalid Geometries <http://trac.osgeo.org/geos/ticket/254>
08:16:51 sigq: geosfeed: Ticket #253 ( defect closed ): Unexpected "Self-intersection at or near point" <http://trac.osgeo.org/geos/ticket/253#comment:2>
08:23:04 sigq: geosfeed: Ticket #215 ( enhancement updated ): Single-sided buffering implementation <http://trac.osgeo.org/geos/ticket/215#comment:11>
08:24:22 sigq: geosfeed: Ticket #240 ( task updated ): Move non-unit test programs out of tests/unit <http://trac.osgeo.org/geos/ticket/240#comment:2>
08:26:21 sigq: geosfeed: Ticket #176 ( defect updated ): Buffer returns empty geometry though it should not be empty <http://trac.osgeo.org/geos/ticket/176#comment:6>
08:29:05 sigq: geosfeed: Ticket #86 ( defect updated ): Possible memory leaks caused by LineString constructor <http://trac.osgeo.org/geos/ticket/86#comment:42>
08:31:06 sigq: geosfeed: Ticket #180 ( defect updated ): getting bad Intersect, contains with polygon vs. linearring <http://trac.osgeo.org/geos/ticket/180#comment:2>
08:33:07 sigq: geosfeed: Ticket #246 ( task closed ): Update TUT framework in unit tests package <http://trac.osgeo.org/geos/ticket/246#comment:3>
08:52:56 CIA-34: pramsey * r2515 /trunk/NEWS: Add single-sided item
08:53:26 CIA-34: pramsey * r2516 /trunk/NEWS: remove error
09:09:53 CIA-34: kneufeld * r4111 /trunk/doc/ ( . html/style.css installation.xml xmlformat.conf ): performed an overhaul of the installation guide ... hopefully it's easier to follow.
09:16:54 CIA-34: pramsey * r2517 /branches/3.1/capi/geos_c.h.in: Match to trunk r2500
09:52:19 CIA-34: pramsey * r2518 /branches/3.1/source/geomgraph/GeometryGraph.cpp: Back-port fix from trunk r2489 for #234
10:04:38 ha1331: if I have a table that contains among other things column for postgis points. How do should I define the index if I usually need to have the result set filtered by multiple columns, including the point column?
10:05:48 ha1331: for example asset_id, date, the_geom( the postgis column point )
10:06:59 CIA-34: pramsey * r2519 /branches/3.1/source/geomgraph/GeometryGraph.cpp: add const modifier
10:07:32 CIA-34: pramsey * r2520 /branches/3.1/tests/xmltester/markup/MarkupSTL.cpp: Backport r2483 from trunk
10:15:54 CIA-34: pramsey * r2521 /branches/3.1/source/geom/util/GeometryTransformer.cpp: Back port r2467 from trunk
10:24:08 CIA-34: pramsey * r2522 /branches/3.1/source/index/quadtree/NodeBase.cpp: Port r2414 from trunk
10:35:44 CIA-34: pramsey * r2523 /branches/3.0/configure.in: AC_SUBST fix as requested in bug #251
10:37:36 sigq: geosfeed: Ticket #251 ( defect closed ): Invalid use of AC_SUBST in configure.in from GEOS 3.0.3 <http://trac.osgeo.org/geos/ticket/251#comment:1>
10:40:59 sigq: geosfeed: Ticket #255 ( enhancement created ): Export C++ API DLL entries for MSVC <http://trac.osgeo.org/geos/ticket/255>
10:43:03 CIA-34: pramsey * r2524 /branches/3.0/source/ ( headers/geos/Makefile.am index/quadtree/NodeBase.cpp ): Backport r2414 from trunk.
10:45:02 CIA-34: pramsey * r2525 /branches/3.0/source/geom/util/GeometryTransformer.cpp: Backport r2467 from trunk.
10:46:47 CIA-34: pramsey * r2526 /branches/3.0/source/geomgraph/GeometryGraph.cpp: Backport r2489 from trunk.
10:52:32 CIA-34: pramsey * r2527 /branches/3.1/source/index/quadtree/Quadtree.cpp: Backport r2406 from trunk.
10:52:50 CIA-34: pramsey * r2528 /branches/3.0/source/index/quadtree/Quadtree.cpp: Backport r2406 from trunk.
10:56:36 CIA-34: pramsey * r2529 /branches/3.0/source/precision/SimpleGeometryPrecisionReducer.cpp: Backport r2368 from trunk.
10:56:54 CIA-34: pramsey * r2530 /branches/3.1/source/precision/SimpleGeometryPrecisionReducer.cpp: Backport r2368 from trunk.
11:06:44 CIA-34: pramsey * r2531 /branches/3.0/source/operation/overlay/PolygonBuilder.cpp: Backport r2366 from trunk.
11:06:50 CIA-34: pramsey * r2532 /branches/3.1/source/operation/overlay/PolygonBuilder.cpp: Backport r2366 from trunk.
11:19:14 sigq: geosfeed: Ticket #239 ( defect closed ): Bug in GEOSEquals predicate <http://trac.osgeo.org/geos/ticket/239#comment:5>
11:20:35 sigq: geosfeed: Ticket #232 ( defect updated ): Static string in WKBReader causes glibc errors when Geos is statically linked <http://trac.osgeo.org/geos/ticket/232#comment:5>
11:51:59 sigq: geosfeed: Ticket #233 ( task updated ): Test Looser Snap Tolerance <http://trac.osgeo.org/geos/ticket/233#comment:2>
12:04:02 sigq: geosfeed: Ticket #233 ( task updated ): Test Looser Snap Tolerance <http://trac.osgeo.org/geos/ticket/233#comment:3>
12:26:23 karstenv: I have a postgis layer setup for mapserver with a replacement variable "WEBSQL". I'm fighting to get the postgis data statement correct in my mapfile
12:26:33 karstenv: it is DATA "the_geom from ( select * from event_table where id_num IN %WEBSQL% ) as temp using unique gid using SRID=4326"
12:26:54 karstenv: WEBSQL could be a select disticnt clause e.g. SELECT DISTINCT id_num FROM my_table LEFT JOIN m_ticket ON code = 'XY' AND unit = my_unit
12:28:13 karstenv: tried various versions of this I get an syntax error for all of them so far
12:29:31 karstenv: how would I have the data clause query all geometry features that are in my "select distinct ..." sub query ?
13:52:41 jlivni: karstenv: be sure you put parens around your subselect
13:53:32 jlivni: and turn on mapserver debugging to view the actual sql being queried if you need
13:59:02 rudenstam: I'm curious, do PostGIS have internal functions for clustering of points ( many points closeby become one "larger" point ) and for network analysis ( path of least resistance between A and B )... I did some searching but found only maillist entries from 2006 ( when this did not exist )
14:01:26 pramsey: no, rudenstam it does not
14:02:12 rudenstam: okey.. I'll move my search to application layer then.. iirc, GRASS does
14:02:20 pramsey: if you know of someone interested in funding clustering code, let me know, it would be an interesting project
14:03:19 rudenstam: afraid not
14:03:22 pramsey: alas
14:03:34 pramsey: ciao for now!
15:32:01 karstenv: jlivni: thanks Josh. I got some steps further now this part is working - one problem was that I did not explicitly include some columns in the subselect statement