Re: [postgis-users] ST_Overlaps broken ?

2013-09-10 Thread Jean Marchal
Thanks a lot!! looks like it was my mind more than something else that was broken! Jean 2013/9/10 Brent Wood > > As I understand it, ST_Overlaps() will return true for features of the > same type which partially overlap. Where one contains another entirely (ie: > ST_Contains() = true) ST_Overl

Re: [postgis-users] ST_Overlaps broken ?

2013-09-10 Thread Brent Wood
As I understand it, ST_Overlaps() will return true for features of the same type which partially overlap. Where one contains another entirely (ie: ST_Contains() = true) ST_Overlaps() will return false. Should you be using ST_Intersects() instead of ST_Overlaps()? See the descriptions of the d

Re: [postgis-users] ST_Overlaps broken ?

2013-09-10 Thread Mike Toews
On 11 September 2013 10:56, Jean Marchal wrote: > Dear PostGIS users, > > > > Returns FALSE instead of TRUE, same thing for hundreds of polygons. Is it > just me or everyone get same result ? > > I tried with postgis 2.1 and 2.1.1dev > > My guess is it's not only ST_Overlaps() but some underlying

[postgis-users] ST_Overlaps broken ?

2013-09-10 Thread Jean Marchal
Dear PostGIS users, SELECT ST_Overlaps(ST_GeomFromText('POLYGON (( -308992.78000114113 515108.0599712543, -308991.140001066 515102.94997100905, -308984.8076443 515093.52997056395, -308976.323579 515071.97996953875, -308965.4284324 515056.24996879

[postgis-users] Errors populating tiger data on windows

2013-09-10 Thread Jonathan Haglund
Hello all, I am using the stock tiger scripts from PostgreSQL 9.2/PostGIS 2.0.3 64 bit on Windows Server 2008 R2. I edited them to use my password and file paths. Running the "create_geocode.bat" script creates the tables fine, though it throws errors saying some things already exist. I the

Re: [postgis-users] update to 2.0.4

2013-09-10 Thread Sandro Santilli
On Tue, Sep 10, 2013 at 07:28:50PM +0200, Mario Jurcevic wrote: > Hi, > what is the correct way to upgrade from 2.0.3 to 2.0.4? > > By running postgis_upgrade_minor_2.0... > gives error: > > cannot drop function addgeometrycolumn(character varying,character > varying,character varying,character

Re: [postgis-users] 'Spatial Extensions' missing from Stack Builder?

2013-09-10 Thread Bborie Park
http://www.postgresonline.com/journal/archives/319-PostGIS-2.1-windows-bundle.html See Regina's blog post... On Tue, Sep 10, 2013 at 1:02 PM, Stephen V. Mather < s...@clevelandmetroparks.com> wrote: > I can't confirm, but given 9.3 dropped yesterday, I'd say it's quite > likely it hasn't been b

Re: [postgis-users] When is PostGIS 2.1.0 Windows binary coming out?

2013-09-10 Thread Bborie Park
http://www.postgresonline.com/journal/archives/319-PostGIS-2.1-windows-bundle.html On Tue, Sep 10, 2013 at 1:07 PM, John Smith wrote: > (sorry for the double-posting) > > guys, > > I got PostgreSQL 9.3 and looking for a compatible PostGIS Windows binary. > > From this announcement for PostGIS 2

Re: [postgis-users] Problem with ST_MapAlgebraExpr

2013-09-10 Thread Bborie Park
Your expression is not using the correct placeholders. It should look something like: ... ST_MapAlgebraExpr(a.maxrast,b.minrast,'[rast1.val] * [rast2.val]', 'INTERSECTION', 'NULL', 'NULL', 'NULL') as rast from max_rast a, min_rast b On Tue, Sep 10, 2013 at 12:36 PM, wrote: > > Dear Postgis Com

[postgis-users] (no subject)

2013-09-10 Thread John Smith
guys, I got PostgreSQL 9.3 and looking for a compatible PostGIS Windows binary. >From this announcement for PostGIS 2.0.4 ( http://postgis.17.x6.nabble.com/PostGIS-2-0-4-Released-td5004152.html), I got PostGIS 2.0.3 (http://download.osgeo.org/postgis/windows/pg92/), but it's incompatible. So the

Re: [postgis-users] 'Spatial Extensions' missing from Stack Builder?

2013-09-10 Thread Stephen V. Mather
I can't confirm, but given 9.3 dropped yesterday, I'd say it's quite likely it hasn't been bundled yet in stackbuilder. Stephen V. Mather GIS Manager (216) 635-3243 (Work) clevelandmetroparks.com From: postgis-users-boun...@lists.osgeo.org [postgis-

[postgis-users] Problem with ST_MapAlgebraExpr

2013-09-10 Thread g.singh
Dear Postgis Community, I have two rasters and I want to create new raster using intersection through ST_MapALgepraExpre() function. The new raster should have pixel values as max pixel values from either of the two rasters. I guess that I want to use product of these two rasters for what I wan

[postgis-users] When is PostGIS 2.1.0 Windows binary coming out?

2013-09-10 Thread John Smith
(sorry for the double-posting) guys, I got PostgreSQL 9.3 and looking for a compatible PostGIS Windows binary. >From this announcement for PostGIS 2.0.4 (http://postgis.17.x6.nabble. com/PostGIS-2-0-4-Released-td5004152.html), I got PostGIS 2.0.3 ( http://download.osgeo.org/postgis/windows/pg92/

[postgis-users] 'Spatial Extensions' missing from Stack Builder?

2013-09-10 Thread Matthew Baker
All, I'm trying to install PostGIS via the enterpriseDB / Stack Builder method, but it seems that the latest version of PostgreSQL and Stack Builder is missing that 'spatial extensions' option. Can anyone confirm? Thanks, -m ___ postgis-users mai

[postgis-users] update to 2.0.4

2013-09-10 Thread Mario Jurcevic
Hi, what is the correct way to upgrade from 2.0.3 to 2.0.4? By running postgis_upgrade_minor_2.0... gives error: cannot drop function addgeometrycolumn(character varying,character varying,character varying,character varying,integer,character varying,integer,boolean) because extension postgis