#POSTGIS IRC Log - 2009-04-20

For logs after Feb 3, 2007, all times are GMT-8. Prior logs are GMT-9.
Back to Logs
01:21:13 CIA-34: mloskot * r2393 /trunk/source/ ( algorithm/distance/ headers/geos/algorithm/distance/ ): Updated svn:ignore patterns.
01:34:08 CIA-34: strk * r2394 /trunk/source/ ( geomgraph/Quadrant.cpp headers/geos/geomgraph/Quadrant.h ): Add named constants, sync to JTS-1.10
02:33:42 CIA-34: strk * r2395 /trunk/ ( 9 files in 5 dirs ): Port IteratedBufferStessTest
03:00:25 CIA-34: mloskot * r2396 /trunk/tests/perf/ ( . operation/ operation/buffer/ ): Updated svn:ignore patterns.
04:21:43 jgeerdes: \q
06:56:28 karpi: hello.. im trying to install postgresql+postgis on windows..
06:58:55 karpi: but "WARNING: The installer has detected that the PostGIS template 'template_postgis' already exists in yourPostgreSQL installation."
06:59:13 karpi: and it is no truth..
06:59:52 karpi: next error: "Removal of template_postgis database failed"
07:00:15 karpi: any expiriences with that, plz?
07:08:18 dassouki: i have a point table representing centroids, a line layer representing roads, and a polygon layer representing zones. I'd like to create X number of line( s ) connecting each centroid to the nearest roads such that these connections are within the zone. The new lines will be saved to a new table that also includes the existing lines. image: http://imgur.com/1tEaP.jpg
07:08:24 dassouki: any guidance would be appreciated
07:27:39 karpi: ...any hint where to do download compiled postgis for win, but without installer, plz ?
07:28:05 dassouki: karpi: I don't know but have u looked around the refractions tutorials
07:31:36 karpi: dassouki: thanks for attention .o )
07:33:26 karpi: dassouki: your problem is interessing task.. i thing only some pl/pgsql programing can solve this..
07:34:10 dassouki: i don't mind programming, i just don't know where to begin. I think i will submit this to the mailing list
07:37:16 karpi: i have used programing once time to solve advanced task, and it works. Im no hacker it is relativelly simple to advanced user..
07:37:52 karpi: PL/pgSQL procedure looks like this:
07:38:05 karpi: http://gismaster.liberix.cz/wikidata/data/clean_mesta_p.sql
07:39:40 dassouki: thank u :D
07:39:55 dassouki: i was hoping for a pythonic approach
07:40:36 karpi: dassouki: yes.. me to. At now.
07:54:47 coffee1: greets all
07:54:58 coffee1: how do you guys feel about postgis? i'm looking for a database that supports geographic objects
07:57:14 dassouki: coffee has no patience
09:08:59 reflex: Hi!, I'm trying to merge two linestring. The start of the first line is contiguous to the start of the second line. Function ST_LineMerge is not merging that two lines. Is there some easy way to do what I need?
10:23:30 sigq: geosfeed: Ticket #215 ( enhancement reopened ): Single-sided buffering implementation <http://trac.osgeo.org/geos/ticket/215#comment:5>
11:38:17 sigq: geosfeed: Ticket #215 ( enhancement updated ): Single-sided buffering implementation <http://trac.osgeo.org/geos/ticket/215#comment:6>
12:29:07 CIA-34: strk * r2397 /trunk/tests/xmltester/ ( BufferResultMatcher.cpp BufferResultMatcher.h ): Use JTS heuristic for distance-0 buffer checking
15:08:59 TheSteve0: jlivni
19:58:38 TheSteve0: jlivni: ping
19:58:50 TheSteve0: racicot: ping
20:11:33 jlivni: TheSteve0: whats up?
23:03:19 goodwin: how to add uuid in linux
23:08:44 wildintellect: you talking about mounting a drive?
23:09:02 wildintellect: or you talking about a unique id in a table?
23:19:04 goodwin: uniwue id in table
23:19:15 goodwin: sorry, unique id in table
23:19:36 goodwin: i have install postgres 8.3 in centOS
23:19:53 goodwin: but when tried to get a uuid , it throws error
23:20:13 goodwin: in windows i can add this while installation
23:20:20 goodwin: but not in linux
23:20:53 mlesli1: Looks like you need to install the contrib module to get uuid generators: http://www.postgresql.org/docs/current/static/datatype-uuid.html
23:20:55 sigq: Title: PostgreSQL: Documentation: Manuals: PostgreSQL 8.3: UUID Type ( at www.postgresql.org )
23:22:18 goodwin: yeah . this is good, but how ti configure