[postgis-users] postgis topology strange behavior

Hello, I'm using the postgis topology with the following example below. It inserts three contiguous polygons, but the third has a strange behavior. It seems that the polygon doesn't snap totally to the other polygon (with model tolerance of 0.1), where he should split the edges and create a node

[postgis-users] Fwd: postgis topology strange behavior

forgot to attach the files. -- Forwarded message -- From: Gonçalo Revez Date: Mon, Feb 24, 2014 at 12:01 PM Subject: postgis topology strange behavior To: postgis-users@lists.osgeo.org Hello, I'm using the postgis topology with the following example below. It inserts three con

[postgis-users] Fwd: postgis topology strange behavior

another image explaining the error attach -- Forwarded message -- From: Gonçalo Revez Date: Mon, Feb 24, 2014 at 12:05 PM Subject: Fwd: postgis topology strange behavior To: postgis-users@lists.osgeo.org forgot to attach the files. -- Forwarded message -- From:

Re: [postgis-users] Fwd: postgis topology strange behavior

I cannot test your data, but maybe you should trim your digit number : -99095.34929557323630434 , could be 99095.35 Cheers, Rémi-C 2014-02-24 13:08 GMT+01:00 Gonçalo Revez : > another image explaining the error attach > > -- Forwarded message -- > From: Gonçalo Revez > Date: Mo

[postgis-users] Academic research

Hi, my name is Jairo de Almeida, I'm from Brazil, I would like to do a postgis research. About postgis basics and advanced concepts. Could they help me to do a menu for this academic work, First listing important topics about postgis (Basics). And last Advanced concepts. Could they suggest a import

Re: [postgis-users] postgis topology strange behavior

On Mon, Feb 24, 2014 at 12:01:28PM +, Gonçalo Revez wrote: > Hello, > > I'm using the postgis topology with the following example below. > > It inserts three contiguous polygons, but the third has a strange behavior. > > It seems that the polygon doesn't snap totally to the other polygon (wi

Re: [postgis-users] postgis topology strange behavior

Hi, answers below: On Mon, Feb 24, 2014 at 1:53 PM, Sandro Santilli wrote: > On Mon, Feb 24, 2014 at 12:01:28PM +, Gonçalo Revez wrote: > > Hello, > > > > I'm using the postgis topology with the following example below. > > > > It inserts three contiguous polygons, but the third has a strang

Re: [postgis-users] Fwd: postgis topology strange behavior

Hey, ST_SnapToGrid Cheers, Rémi-C 2014-02-24 16:20 GMT+01:00 Gonçalo Revez : > In fact, those geometry were already derived from a previous postgis > topological model. Only the the third polygon was edited. > > I could try that, but shouldn't the tolerance meaning consider some kind > of the

Re: [postgis-users] Fwd: postgis topology strange behavior

In fact, those geometry were already derived from a previous postgis topological model. Only the the third polygon was edited. I could try that, but shouldn't the tolerance meaning consider some kind of the trim of the values? Is there any function in postgis to do that automatically? If i'm awa

Re: [postgis-users] postgis topology strange behavior

On Mon, Feb 24, 2014 at 03:06:04PM +, Gonçalo Revez wrote: > On Mon, Feb 24, 2014 at 1:53 PM, Sandro Santilli wrote: > > Does ValidateTopology catches that error ? > > *G: No the validation doesn't catch any error.* My bet is that there isn't any. > > In the topology primitives tables ther

[postgis-users] segmentize lines with order

Hi guys, I'm trying to use lines from postgis to google maps android. To do that, I'm converting the lines to points with St_DumpPoints and, in gmaps, I make the lines. My problem is that I cannot create a correct sequence to order the points in android and so i get wrong lines (see ss atached

Re: [postgis-users] segmentize lines with order

On 2/24/2014 11:33 AM, Pedro Costa wrote: Hi guys, I'm trying to use lines from postgis to google maps android. To do that, I'm converting the lines to points with St_DumpPoints and, in gmaps, I make the lines. My problem is that I cannot create a correct sequence to order the points in android

[postgis-users] PostGIS on a Raspberry Pi

I enjoy hearing about folks heating up multiple cores on their big iron. Reporting from the other end of the spectrum, I have PostgreSQL 9.1 / PostGIS 2.0 running on a Raspberry Pi . My Raspberry Pi's day job is as a chickencam (that's a w

Re: [postgis-users] PostGIS on a Raspberry Pi

You're running PostGIS on a RaspberryPi? That, sir, is about the coolest thing I've heard in some time. I applaud you. Sorry to hear about chickens messing up your query times, though. :) -g On 2/24/2014 12:06 PM, Richard Greenwood wrote: I enjoy hearing about folks heating up multiple cores

Re: [postgis-users] PostGIS on a Raspberry Pi

I'll pipe up and say that I have also had success running PostGIS on RPi as well. Nice to see it work there and be so flexible. Hats off to all the PostGIS core devs! Jeff On Mon, Feb 24, 2014 at 12:10 PM, Greg Allensworth wrote: > You're running PostGIS on a RaspberryPi? That, sir, is about the

[postgis-users] ST_MapAlgebraExpr 2 rasters problem with resultant raster

Hi, I am using ST_MapAlgepraExpr for the intersection of two rasters. The first raster has minimum and maximum values as 5.112e-020 and 0.000125 respectively. The second raster has minimum and maximum value as 0.000 and 0.000400 respectively. I carry the raster intersection using expression ST_

Re: [postgis-users] PostGIS on a Raspberry Pi

Dude, next time my users say the website is slow, I'm gonna blame the chickens. -Andy On 02/24/2014 02:10 PM, Greg Allensworth wrote: You're running PostGIS on a RaspberryPi? That, sir, is about the coolest thing I've heard in some time. I applaud you. Sorry to hear about chickens messing up

Re: [postgis-users] PostGIS on a Raspberry Pi

Greg...This is a great post and an excellent bench mark.  Thanks for sharing this information. M From: Andy Colson To: postgis-users@lists.osgeo.org Sent: Monday, February 24, 2014 4:33 PM Subject: Re: [postgis-users] PostGIS on a Raspberry Pi Dude, next t

Re: [postgis-users] PostGIS on a Raspberry Pi

Richard, Did you use the DebianGIS repo or compile everything yourself? I have been thinking of using GEOS via Shapely in combination with a GPS chip on my Pi in a geo-fence type application. David. On Mon, Feb 24, 2014 at 7:16 PM, MICHAEL FENE wrote: > Greg...This is a great post and an exce

Re: [postgis-users] PostGIS on a Raspberry Pi

I used the repo for everything but PostGIS, which I built. But the repo has PostGIS 1.5 is that meets your needs. Rich On Mon, Feb 24, 2014 at 7:25 PM, David Fawcett wrote: > Richard, > > Did you use the DebianGIS repo or compile everything yourself? > > I have been thinking of using GEOS via S

Re: [postgis-users] PostGIS on a Raspberry Pi

Richard, * Richard Greenwood (richard.greenw...@gmail.com) wrote: > I enjoy hearing about folks heating up multiple cores on their big iron. > Reporting from the other end of the spectrum, I have PostgreSQL 9.1 / > PostGIS 2.0 running on a Raspberry Pi . My > Raspberry