Re: [postgis-users] pgrouting

2008-12-10 Thread searchelite
Jean David TECHER wrote: Hi Please see http://pgrouting.postlbs.org/ function like: - Shortest Path Dijkstra - Shortest Path Shooting Star We should try to find the nearest edge or vertex from your point(vehicle or emergency point) before finding the path --david; thank

[postgis-users] Arc article on postgis

2008-12-10 Thread John Abraham
Not sure why this was so hard to find: http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/using_th485132809.htm looks a bit out of date though. -- John ___ postgis-users mailing list postgis-users@postgis.refractions.net

Re: [postgis-users] how to identify the_geom that cause:RelateOperation called withLWGEOMCOLLECTION type

2008-12-10 Thread Ghislain Geniaux
Exact, that's the problem : scot3=# SELECT gid, the_geom scot3-# FROM bd_dispo_final scot3-# WHERE isempty(centroid(the_geom)); gid | the_geom ---

Re: [postgis-users] how to identify the_geom that cause:RelateOperation called withLWGEOMCOLLECTION type

2008-12-10 Thread Fred Lehodey
Hi, just a note: inserting the same geometry : INSERT INTO bug (gid, the_geom) VALUES ( 1 , '010320BE6B0100040081F178483F4F2841D730212506D33C418045F71F474F2841D706623902D33C417E45F71F474F2841D806623902D33C4181F178483F4F2841D730212506D33C41' ); and INSERT INTO bug (gid,

RE: [postgis-users] how to identify the_geom thatcause:RelateOperation called withLWGEOMCOLLECTION type

2008-12-10 Thread Obe, Regina
Fred and Ghislain, Thanks - yes that's because of the rounding that happens in ST_GeomFromText -- the ST_GeomFromText is rounding the last couple of digits so the text rep isn't actually what the geometry is so its probably something like 796579.5624334065668 or some such thing. Looking at

RE: [postgis-users] how to identify the_geom thatcause:RelateOperation called withLWGEOMCOLLECTION type

2008-12-10 Thread Obe, Regina
Fred, Not a stupid question and you are probably right. ST_GeomFromText would probably work just as well except that you can't control the number of digits as you can with ST_SnapToGrid. The main issue I see about that (including the snap to grid) approach is that as you said, you have

Re: [postgis-users] Points on a straight line

2008-12-10 Thread Fred Lehodey
Hi Abhi, ST_DWithin(); Example: SELECT p.* FROM yourPoints AS p, yourLine AS l WHERE ST_DWithin(p.the_geom,l.the_geom,yourTolerance) Fred On Wed, Dec 10, 2008 at 1:26 PM, Abhi [EMAIL PROTECTED] wrote: If I have a set of Point objects, is there a way I can filter out the Points from this

[postgis-users] Points on a straight line

2008-12-10 Thread Abhi
If I have a set of Point objects, is there a way I can filter out the Points from this set that lie on a straight line within a certain amount of tolerance? -- Cheers, Abhi ___ postgis-users mailing list postgis-users@postgis.refractions.net

[postgis-users] Buffering around 1/2 an object

2008-12-10 Thread David Potts
Hi I known this sound like a strange question, but is it possible to create a buffer around 1/2 of geomtry objectt. If I choose to buffer round a stright line, I get a geomtry that looks like a sausage, if I buffer round a point, I get a geomtry that looks like a circle. What I would like

RE: [postgis-users] Help with query

2008-12-10 Thread Burgholzer,Robert
Mark, This could be either a mapserver question, or a postgis question depending on the solution you chose. I would say the following (untested code): Mapserver: - define 3 layers, 1 for each concentric circle using your 1 dd circle as the template, with duplicates of 2 and 3

Re: [postgis-users] how to identify the_geom that cause:RelateOperation called withLWGEOMCOLLECTION type

2008-12-10 Thread Martin Davis
Congratulations, you've uncovered a long-standing bug in JTS. Taking the centroid of a polygon with zero area (or very close to it) results in an invalid point value for the centroid. This doesn't apply to linear features, so one workaround is to take the centroid of the *boundary* of the

[postgis-users] Help with query

2008-12-10 Thread mark balman
Hi All I have managed to resolve the query with the following suggestion - thanks to Rob Burgholzer's suggestion to use UNION Keeping this simple, I kept the following Layer for selecting the polygon features within the specified distances defined in the class expressions DATA the_geom FROM

[postgis-users] variant documentation paths, 1.3.4 works on NetBSD-current

2008-12-10 Thread Greg Troxel
I am updating postgis to 1.3.4 (from 1.3.3) in pkgsrc. It seems the names of installed docs have changed, and I made the inverse change on updating to 1.3.3. This seems to be a change in the tarball, given the date on the postgis.html. While I prefer the single file, it seems something in the

Re: [postgis-users] NAD conversion problem

2008-12-10 Thread Dylan Beaudette
On Tuesday 09 December 2008, Peter N. Schweitzer wrote: Richard Greenwood wrote: On Mon, Dec 8, 2008 at 12:19 PM, Peter N. Schweitzer [EMAIL PROTECTED] wrote: Richard Greenwood wrote: On Thu, Dec 4, 2008 at 1:19 PM, Peter N. Schweitzer [EMAIL PROTECTED] wrote: Hello, I have

Re: [postgis-users] variant documentation paths, 1.3.4 works on NetBSD-current

2008-12-10 Thread Paul Ramsey
Sorry Greg, it's manual, so variation is seeping in. Another reason to bring the scripted packaging system back up to snuff. P On Wed, Dec 10, 2008 at 3:34 PM, Greg Troxel [EMAIL PROTECTED] wrote: I am updating postgis to 1.3.4 (from 1.3.3) in pkgsrc. It seems the names of installed docs have