[postgis-users] Problem with ST_MapAlgebraExpr
g.singh at utwente.nl
g.singh at utwente.nl
Fri Sep 13 04:27:19 PDT 2013
Thanks Bborie Park,
Can you please tell me what should I use for rast1.val and rast2.val. I am asking this because when I used '[maxrast.val] * [minrast.val]' I get erroras under:
ERROR: RASTER_mapAlgebra2: Invalid pixel type: INTERSECTION
********** Error **********
ERROR: RASTER_mapAlgebra2: Invalid pixel type: INTERSECTION
SQL state: XX000
The function in the query looks like as below:
st_MapAlgebraExpr(a.maxrast,b.minrast, '[maxrast.val] * [minrast.val]' , 'INTERSECTION', 'NULL', 'NULL', 'NULL') as rast
thanks
gaurav
-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of postgis-users-request at lists.osgeo.org
Sent: Wednesday, September 11, 2013 9:00 PM
To: postgis-users at lists.osgeo.org
Subject: postgis-users Digest, Vol 139, Issue 8
Send postgis-users mailing list submissions to
postgis-users at lists.osgeo.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help' to
postgis-users-request at lists.osgeo.org
You can reach the person managing the list at
postgis-users-owner at lists.osgeo.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of postgis-users digest..."
Today's Topics:
1. Problem with ST_MapAlgebraExpr (g.singh at utwente.nl)
2. 'Spatial Extensions' missing from Stack Builder? (Matthew Baker)
3. (no subject) (John Smith)
4. When is PostGIS 2.1.0 Windows binary coming out? (John Smith)
5. Re: 'Spatial Extensions' missing from Stack Builder?
(Stephen V. Mather)
6. Re: Problem with ST_MapAlgebraExpr (Bborie Park)
7. Re: When is PostGIS 2.1.0 Windows binary coming out? (Bborie Park)
8. Re: When is PostGIS 2.1.0 Windows binary coming out? (Bborie Park)
9. Re: 'Spatial Extensions' missing from Stack Builder? (Bborie Park)
10. Re: update to 2.0.4 (Sandro Santilli)
11. Re: update to 2.0.4 (Sandro Santilli)
12. Errors populating tiger data on windows (Jonathan Haglund)
13. ST_Overlaps broken ? (Jean Marchal)
14. Re: ST_Overlaps broken ? (Mike Toews)
15. Re: ST_Overlaps broken ? (Brent Wood)
16. Re: ST_Overlaps broken ? (Jean Marchal)
17. Re: upgrading from postgresql 8.4 - postgis 1.3.6 to
postgresql 9.2/postgis2.0 (Athanasios Kostopoulos)
----------------------------------------------------------------------
Message: 1
Date: Tue, 10 Sep 2013 19:36:47 +0000
From: <g.singh at utwente.nl>
To: <postgis-users at lists.osgeo.org>
Subject: [postgis-users] Problem with ST_MapAlgebraExpr
Message-ID:
<21D074A959B3D34FA326A6E2CC1DA638030D6A at EXMBX21.ad.utwente.nl>
Content-Type: text/plain; charset="us-ascii"
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 want in new raster. I use following query and encounter the problem. I am sure there is something wrong in my query with expression. Can someone please guide me how to correct it. My Postgis version is of data "2012-03-29 09:07:33" and raster lib build data "2012-03-29 09:07:33"
With env as(
select rid, gaztext_id, st_area(ST_Envelope(rast)) as area, rast from text_rast_intersection ),
max_rast as(select e.rid, e.gaztext_id, e.rast as maxrast from env e, env b where e.area > b.area )
,min_rast as (select e.rid, e.gaztext_id, e.rast as minrast from env e, env b where e.area < b.area )
select '222' as rid, 964 as gaztext_id,
st_MapAlgebraExpr(a.maxrast,b.minrast,'minrast'*'mnaxrast', 'INTERSECTION', 'NULL', 'NULL', 'NULL') as rast from max_rast a, min_rast b
ERROR:
ERROR: operator is not unique: unknown * unknown
LINE 14: st_MapAlgebraExpr(a.maxrast,b.minrast,'minrast'*'mnaxrast', ...
^
HINT: Could not choose a best candidate operator. You might need to add explicit type casts.
********** Error **********
ERROR: operator is not unique: unknown * unknown
SQL state: 42725
Hint: Could not choose a best candidate operator. You might need to add explicit type casts.
Character: 468
Thanks,
Gaurav
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/b05379a9/attachment-0001.html>
------------------------------
Message: 2
Date: Tue, 10 Sep 2013 14:00:25 -0600
From: Matthew Baker <mattbaker at gmail.com>
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] 'Spatial Extensions' missing from Stack
Builder?
Message-ID: <522F7A59.50808 at gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
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
------------------------------
Message: 3
Date: Tue, 10 Sep 2013 16:04:50 -0400
From: John Smith <jayzee.smith at gmail.com>
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Subject: [postgis-users] (no subject)
Message-ID:
<CAMZ8qd-f2Jyic6EoW7Z070aiwFs+edbsr857WyXMSLhP45UZgg at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
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 best bet looks
like postgis-pg93-binaries-2.1.0w64gcc48.zip from Winnie (
http://winnie.postgis.net/download/windows/pg93/buildbot/ for
PostgreSQL 9.3 rc1). Does anyone have any problems using that?
When is PostGIS 2.1.0 Windows binary coming out (
http://postgis.net/2013/08/17/postgis-2-1-0)?
thanks, jzs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/ddc0ea96/attachment-0001.html>
------------------------------
Message: 4
Date: Tue, 10 Sep 2013 16:07:59 -0400
From: John Smith <jayzee.smith at gmail.com>
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Subject: [postgis-users] When is PostGIS 2.1.0 Windows binary coming
out?
Message-ID:
<CAMZ8qd-yLexB1FZg0mCapEqYizqKtuayz__3nSbbdJHofY3=uQ at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
(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/), but it's incompatible. So
the best bet looks like postgis-pg93-binaries-2.1.0w64gcc48.zip from Winnie
(http://winnie.postgis.net/download/windows/pg93/buildbot/ for
PostgreSQL 9.3 rc1). Does anyone have any problems using that?
When is PostGIS 2.1.0 Windows binary coming out (http://postgis.net/2013/08/
17/postgis-2-1-0)?
thanks, jzs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/65198ad6/attachment-0001.html>
------------------------------
Message: 5
Date: Tue, 10 Sep 2013 20:02:09 +0000
From: "Stephen V. Mather" <svm at clevelandmetroparks.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] 'Spatial Extensions' missing from Stack
Builder?
Message-ID:
<C340540F516C5B488D36C1359E1A272C333D6B31 at SN2PRD0510MB382.namprd05.prod.outlook.com>
Content-Type: text/plain; charset="us-ascii"
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-bounces at lists.osgeo.org [postgis-users-bounces at lists.osgeo.org] on behalf of Matthew Baker [mattbaker at gmail.com]
Sent: Tuesday, September 10, 2013 4:00 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] 'Spatial Extensions' missing from Stack Builder?
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 mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
------------------------------
Message: 6
Date: Tue, 10 Sep 2013 13:27:08 -0700
From: Bborie Park <dustymugs at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] Problem with ST_MapAlgebraExpr
Message-ID:
<CAKVfRvFruhi4rz==GaEAKTZ0mH8j5uvHR8uHaq24VAHSdQHd=Q at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
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, <g.singh at utwente.nl> wrote:
>
> 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 want in new raster. I
use following query and encounter the problem. I am sure there is something
wrong in my query with expression. Can someone please guide me how to
correct it. My Postgis version is of data "2012-03-29 09:07:33" and raster
lib build data "2012-03-29 09:07:33"
>
>
>
> With env as(
>
> select rid, gaztext_id, st_area(ST_Envelope(rast)) as area, rast from
text_rast_intersection ),
>
> max_rast as(select e.rid, e.gaztext_id, e.rast as maxrast from env e, env
b where e.area > b.area )
>
> ,min_rast as (select e.rid, e.gaztext_id, e.rast as minrast from env e,
env b where e.area < b.area )
>
> select '222' as rid, 964 as gaztext_id,
>
> st_MapAlgebraExpr(a.maxrast,b.minrast,'minrast'*'mnaxrast',
'INTERSECTION', 'NULL', 'NULL', 'NULL') as rast from max_rast a, min_rast b
>
>
>
> ERROR:
>
> ERROR: operator is not unique: unknown * unknown
>
> LINE 14: st_MapAlgebraExpr(a.maxrast,b.minrast,'minrast'*'mnaxrast', ...
>
> ^
>
> HINT: Could not choose a best candidate operator. You might need to add
explicit type casts.
>
>
>
> ********** Error **********
>
>
>
> ERROR: operator is not unique: unknown * unknown
>
> SQL state: 42725
>
> Hint: Could not choose a best candidate operator. You might need to add
explicit type casts.
>
> Character: 468
>
>
>
>
>
> Thanks,
>
> Gaurav
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/1fc5a5b5/attachment-0001.html>
------------------------------
Message: 7
Date: Tue, 10 Sep 2013 13:29:24 -0700
From: Bborie Park <dustymugs at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Cc: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Subject: Re: [postgis-users] When is PostGIS 2.1.0 Windows binary
coming out?
Message-ID:
<CAKVfRvFmhYTyZW4Ty3TTP-Z3WA-REYb-dRMicp_C-QPHOF67AA at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
http://www.postgresonline.com/journal/archives/319-PostGIS-2.1-windows-bundle.html
On Tue, Sep 10, 2013 at 1:07 PM, John Smith <jayzee.smith at gmail.com> 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.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 best bet looks like postgis-pg93-binaries-2.1.0w64gcc48.zip from
> Winnie (http://winnie.postgis.net/download/windows/pg93/buildbot/ for
> PostgreSQL 9.3 rc1). Does anyone have any problems using that?
>
> When is PostGIS 2.1.0 Windows binary coming out (
> http://postgis.net/2013/08/17/postgis-2-1-0)?
>
> thanks, jzs
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/633b030e/attachment-0002.html>
------------------------------
Message: 8
Date: Tue, 10 Sep 2013 13:29:24 -0700
From: Bborie Park <dustymugs at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Cc: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Subject: Re: [postgis-users] When is PostGIS 2.1.0 Windows binary
coming out?
Message-ID:
<CAKVfRvFmhYTyZW4Ty3TTP-Z3WA-REYb-dRMicp_C-QPHOF67AA at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
http://www.postgresonline.com/journal/archives/319-PostGIS-2.1-windows-bundle.html
On Tue, Sep 10, 2013 at 1:07 PM, John Smith <jayzee.smith at gmail.com> 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.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 best bet looks like postgis-pg93-binaries-2.1.0w64gcc48.zip from
> Winnie (http://winnie.postgis.net/download/windows/pg93/buildbot/ for
> PostgreSQL 9.3 rc1). Does anyone have any problems using that?
>
> When is PostGIS 2.1.0 Windows binary coming out (
> http://postgis.net/2013/08/17/postgis-2-1-0)?
>
> thanks, jzs
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/633b030e/attachment-0003.html>
------------------------------
Message: 9
Date: Tue, 10 Sep 2013 13:30:08 -0700
From: Bborie Park <dustymugs at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] 'Spatial Extensions' missing from Stack
Builder?
Message-ID:
<CAKVfRvHhvmxPwMvNa3q_aLb5eP_Ewpys-G1wAk5VDhT7cK0Jbg at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
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 <
svm at clevelandmetroparks.com> wrote:
> 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-bounces at lists.osgeo.org [
> postgis-users-bounces at lists.osgeo.org] on behalf of Matthew Baker [
> mattbaker at gmail.com]
> Sent: Tuesday, September 10, 2013 4:00 PM
> To: postgis-users at lists.osgeo.org
> Subject: [postgis-users] 'Spatial Extensions' missing from Stack Builder?
>
> 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 mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/37cda51a/attachment-0001.html>
------------------------------
Message: 10
Date: Tue, 10 Sep 2013 22:41:56 +0200
From: Sandro Santilli <strk at keybit.net>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Cc: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] update to 2.0.4
Message-ID: <20130910204156.GC3556 at gnash>
Content-Type: text/plain; charset=us-ascii
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 varying,integer,character
> varying,integer,boolean) because extension postgis requires it
> HINT: You can drop extension postgis instead.
That's because you evidently had PostGIS installed as an extension
> With "alter extension" gives no error but is everything updated?
It should. Check with
SELECT postgis_full_version();
--strk;
http://www.cartodb.com - Map, analyze and build applications with your data
~~ http://strk.keybit.net
------------------------------
Message: 11
Date: Tue, 10 Sep 2013 22:41:56 +0200
From: Sandro Santilli <strk at keybit.net>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Cc: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] update to 2.0.4
Message-ID: <20130910204156.GC3556 at gnash>
Content-Type: text/plain; charset=us-ascii
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 varying,integer,character
> varying,integer,boolean) because extension postgis requires it
> HINT: You can drop extension postgis instead.
That's because you evidently had PostGIS installed as an extension
> With "alter extension" gives no error but is everything updated?
It should. Check with
SELECT postgis_full_version();
--strk;
http://www.cartodb.com - Map, analyze and build applications with your data
~~ http://strk.keybit.net
------------------------------
Message: 12
Date: Tue, 10 Sep 2013 14:54:31 -0600
From: Jonathan Haglund <jonathan.haglund at gotravelsites.com>
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] Errors populating tiger data on windows
Message-ID: <522F8707.6040605 at gotravelsites.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
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 then
ran "SELECT loader_generate_script(ARRAY['HI'], 'windows');" and
executed that. Its fine for awhile, but eventually I get the following:
ERROR: current transaction is aborted, commands ignored until end of
transaction block
If I break execution I get more info (line breaks edited after pasting
from the cmd prompt):
NOTICE: INSERT INTO
tiger_data.hi_featnames(tlid,paflag,mtfcc,linearid,sufqual,suftyp,sufdir,prequal,pretyp,predir,sufqualabr,suftypabrv,sufdirabrv,prequalabr,
pretypabrv,predirabrv,name,fullname)
SELECT
paflag,mtfcc,linearid,sufqual,suftyp,sufdir,prequal,pretyp,predir,sufqualabr,suftypabrv,sufdirabrv,prequalabr,pretypabrv,predirabrv,name,fullname,tlid
FROM tiger_staging.hi_featnames;
CONTEXT: SQL function "loader_load_staged_data" statement 1
ERROR: column "tlid" is of type bigint but expression is of type
character varying
LINE 1: ...alabr,pretypabrv,predirabrv,name,fullname) SELECT paflag,mtf...
^
HINT: You will need to rewrite or cast the expression.
QUERY: INSERT INTO
tiger_data.hi_featnames(tlid,paflag,mtfcc,linearid,sufqual,suftyp,sufdir,prequal,pretyp,predir,sufqualabr,suftypabrv,sufdirabrv,prequalabr,pretypabrv,predirabrv,name,fullname)
SELECT
paflag,mtfcc,linearid,sufqual,suftyp,sufdir,prequal,pretyp,predir,sufqualabr,suftypabrv,sufdirabrv,prequalabr,pretypabrv,predirabrv,name,fullname,tlid
FROM tiger_staging.hi_featnames;
CONTEXT: PL/pgSQL function loader_load_staged_data(text,text,text[])
line 24 at
EXECUTE statement
SQL function "loader_load_staged_data" statement 1
I have followed the instructions, started over many times in case I
messed up somewhere, but some things I noticed: The docs refer to
tiger2010, but only 2011 and 2012 scripts are present, within the 2011
folder. The "create_geocode.bat" script by default refers to
"tiger_loader_2012.sql" which is what I left it as. Not every state
throws this error, but most of them do. If I ignore it and let it
finish geocoding technically seems to work, but I have no way of knowing
if my data is incomplete.
I can find no other reference to this issue and since I am using the
scripts as they came to me through the application stack builder I have
no idea what to do. Please let me know if you need more information.
-Jonathan
------------------------------
Message: 13
Date: Tue, 10 Sep 2013 18:56:32 -0400
From: Jean Marchal <jean.d.marchal at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: [postgis-users] ST_Overlaps broken ?
Message-ID:
<CACF6B3XXeY8OASAng8bOQDYAYsfhFFUESc0=cVkZk5B-akG1QQ at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Dear PostGIS users,
SELECT ST_Overlaps(ST_GeomFromText('POLYGON ((
-308992.78000114113 515108.0599712543,
-308991.140001066 515102.94997100905,
-308984.80000076443 515093.52997056395,
-308976.3200003579 515071.97996953875,
-308965.42999984324 515056.24996879324,
-308955.59999937564 515039.59996800125,
-308945.3999988958 515013.9399667829,
-308940.1299986392 515003.59996629134,
-308938.5599985644 514997.499966003,
-308924.9999979213 514962.6199643463,
-308921.439997755 514956.3899640478,
-308910.2799972221 514944.63996349275,
-308901.2699967995 514945.0099635087,
-308891.5399963334 514941.33996333554,
-308873.2199954614 514932.08996289596,
-308858.2199947536 514918.0699622296,
-308844.9299941212 514908.16996175796,
-308839.5499938652 514913.7899620272,
-308834.6499936357 514912.4499619603,
-308829.0399933681 514907.06996170804,
-308827.3899932876 514901.95996146277,
-308828.86999335885 514895.079961136,
-308828.7699933499 514882.09996052086,
-308820.27999295294 514860.54995949566,
-308817.84999283403 514852.3899591081,
-308806.34999229014 514816.65995741263,
-308803.40999215096 514801.48995669186,
-308797.2499918565 514775.1099554375,
-308797.5999918729 514770.139955204,
-308795.6499917805 514755.0299544856,
-308796.6799918264 514740.12995377555,
-308796.6499918252 514726.15995311365,
-308791.9299916029 514707.8599522449,
-308790.5599915385 514698.7899518125,
-308791.0399915576 514691.82995148376,
-308789.53999149054 514684.7399511449,
-308790.7099915445 514667.84995034337,
-308788.3499914333 514658.7100499086,
-308791.01999156177 514648.9100494459,
-308791.43999157846 514642.9500491619,
-308795.169991754 514632.23004865274,
-308807.05999232084 514619.0800480284,
-308814.4999926761 514612.6100477204,
-308818.9499928877 514605.930047404,
-308827.3799932897 514599.53004710004,
-308836.2899937108 514586.1700464636,
-308845.5799941495 514581.8200462572,
-308857.39999471605 514569.6700456813,
-308877.12999565154 514573.0300458409,
-308896.719996579 514578.3800460957,
-308913.9799974039 514588.5600465797,
-308918.66999762505 514592.8800467849,
-308930.2199981734 514584.6900463961,
-308937.2399985045 514584.1800463684,
-308943.12999878824 514585.5900464356,
-308947.759999007 514590.9000466876,
-308950.3199991286 514597.060046982,
-308986.2200008333 514597.5600470044,
-308995.6100012809 514606.19004741684,
-309028.27000282705 514653.37004965544,
-309042.7600035146 514660.3600499891,
-309043.7500035614 514660.4300499931,
-309048.1700037718 514668.7199503854,
-309049.60000383854 514705.7499521449,
-309059.2800043002 514724.3899530284,
-309071.1000048667 514741.17995382845,
-309086.95000561327 514757.2499545887,
-309096.71000608057 514774.8899554275,
-309113.04000685364 514812.94995723665,
-309121.7300072685 514831.51995811984,
-309121.28000724316 514852.44995911047,
-309122.88000731915 514872.5299600661,
-309128.4600075856 514892.8799610324,
-309127.0200075209 514913.73996202275,
-309121.6700072661 514933.3299629539,
-309109.4300066829 514951.4499638155,
-309095.42000602186 514966.4399645254,
-309083.1800054386 514984.559965387,
-309081.1200053394 515014.35996680334,
-309068.7200047523 515020.4899670929,
-309068.30000472814 515026.4499673769,
-309067.0300046727 515030.3599675633,
-309054.87000409514 515047.47996837646,
-309043.9700035751 515060.69996900484,
-309041.57000345737 515066.5199692808,
-309032.730003044 515078.8799698688,
-309016.76000228524 515107.71997123584,
-309009.46000193805 515112.20997145027,
-309004.43000169843 515112.8599714823,
-309000.450001508 515112.5799714662,
-308992.78000114113 515108.0599712543
))'), ST_Geomfromtext('POLYGON ((
-308992.78000114113 515108.0599712543,
-308991.140001066 515102.94997100905,
-308984.80000076443 515093.52997056395,
-308976.3200003579 515071.97996953875,
-308965.42999984324 515056.24996879324,
-308955.59999937564 515039.59996800125,
-308945.3999988958 515013.9399667829,
-308940.1299986392 515003.59996629134,
-308938.5599985644 514997.499966003,
-308924.9999979213 514962.6199643463,
-308921.439997755 514956.3899640478,
-308910.2799972221 514944.63996349275,
-308901.2699967995 514945.0099635087,
-308891.5399963334 514941.33996333554,
-308873.2199954614 514932.08996289596,
-308858.2199947536 514918.0699622296,
-308844.9299941212 514908.16996175796,
-308839.5499938652 514913.7899620272,
-308834.6499936357 514912.4499619603,
-308829.0399933681 514907.06996170804,
-308827.3899932876 514901.95996146277,
-308828.86999335885 514895.079961136,
-308828.7699933499 514882.09996052086,
-308820.27999295294 514860.54995949566,
-308817.84999283403 514852.3899591081,
-308806.34999229014 514816.65995741263,
-308803.40999215096 514801.48995669186,
-308797.2499918565 514775.1099554375,
-308797.5999918729 514770.139955204,
-308795.6499917805 514755.0299544856,
-308796.6799918264 514740.12995377555,
-308796.6499918252 514726.15995311365,
-308791.9299916029 514707.8599522449,
-308790.5599915385 514698.7899518125,
-308791.0399915576 514691.82995148376,
-308789.53999149054 514684.7399511449,
-308790.7099915445 514667.84995034337,
-308788.3499914333 514658.7100499086,
-308791.01999156177 514648.9100494459,
-308791.43999157846 514642.9500491619,
-308795.169991754 514632.23004865274,
-308807.05999232084 514619.0800480284,
-308814.4999926761 514612.6100477204,
-308818.9499928877 514605.930047404,
-308827.3799932897 514599.53004710004,
-308836.2899937108 514586.1700464636,
-308845.5799941495 514581.8200462572,
-308857.39999471605 514569.6700456813,
-308877.12999565154 514573.0300458409,
-308896.719996579 514578.3800460957,
-308913.9799974039 514588.5600465797,
-308918.66999762505 514592.8800467849,
-308930.2199981734 514584.6900463961,
-308937.2399985045 514584.1800463684,
-308943.12999878824 514585.5900464356,
-308947.759999007 514590.9000466876,
-308950.3199991286 514597.060046982,
-308986.2200008333 514597.5600470044,
-308995.6100012809 514606.19004741684,
-309028.27000282705 514653.37004965544,
-309042.7600035146 514660.3600499891,
-309043.7500035614 514660.4300499931,
-309048.1700037718 514668.7199503854,
-309049.60000383854 514705.7499521449,
-309059.2800043002 514724.3899530284,
-309071.1000048667 514741.17995382845,
-309086.95000561327 514757.2499545887,
-309096.71000608057 514774.8899554275,
-309113.04000685364 514812.94995723665,
-309121.7200072706 514831.51995811984,
-309121.28000724316 514852.44995911047,
-309122.88000731915 514872.5299600661,
-309128.4600075856 514892.8799610324,
-309127.0200075209 514913.73996202275,
-309121.6700072661 514933.3299629539,
-309109.4300066829 514951.4499638155,
-309095.42000602186 514966.4399645254,
-309083.1800054386 514984.559965387,
-309081.1200053394 515014.35996680334,
-309068.7200047523 515020.4899670929,
-309068.30000472814 515026.4499673769,
-309067.0300046727 515030.3599675633,
-309054.87000409514 515047.47996837646,
-309043.9700035751 515060.69996900484,
-309041.57000345737 515066.5199692808,
-309032.730003044 515078.8799698688,
-309016.76000228524 515107.71997123584,
-309009.46000193805 515112.20997145027,
-309004.43000169843 515112.8599714823,
-309000.450001508 515112.5799714662,
-308992.78000114113 515108.0599712543
))'))
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 function called
by ST_Overlaps()
Thanks,
Jean
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/54f7d845/attachment-0001.html>
------------------------------
Message: 14
Date: Wed, 11 Sep 2013 11:18:47 +1200
From: Mike Toews <mwtoews at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] ST_Overlaps broken ?
Message-ID:
<CAM2FmMr-Z9nhypSMMm6yqMiMrZ8Ab1q9u+x4quedC4PB0oP7RA at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
On 11 September 2013 10:56, Jean Marchal <jean.d.marchal at gmail.com> wrote:
> Dear PostGIS users,
>
> <snip>
>
> 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 function called
> by ST_Overlaps()
This is the expected result. It returns true for ST_Covers, which
means one of the geometries is completely contained in the other, so
by definition it is false for ST_Overlaps. Maybe you are looking for a
different spatial predicate? I'd recommend putting these geometries in
JTS test builder to get a visual reference for how the spatial
predicates actually work. Also see
https://en.wikipedia.org/wiki/DE-9IM
-Mike
------------------------------
Message: 15
Date: Tue, 10 Sep 2013 16:37:21 -0700 (PDT)
From: Brent Wood <pcreso at pcreso.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] ST_Overlaps broken ?
Message-ID:
<1378856241.46590.YahooMailNeo at web122005.mail.ne1.yahoo.com>
Content-Type: text/plain; charset="iso-8859-1"
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 different spatial relationships here:
http://workshops.opengeo.org/postgis-intro/spatial_relationships.html
Brent Wood
________________________________
From: Jean Marchal <jean.d.marchal at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Sent: Wednesday, September 11, 2013 10:56 AM
Subject: [postgis-users] ST_Overlaps broken ?
Dear PostGIS users,
SELECT ST_Overlaps(ST_GeomFromText('POLYGON ((
??????? -308992.78000114113 515108.0599712543,
??????? -308991.140001066 515102.94997100905,
??????? -308984.80000076443 515093.52997056395,
??????? -308976.3200003579 515071.97996953875,
??????? -308965.42999984324 515056.24996879324,
??????? -308955.59999937564 515039.59996800125,
??????? -308945.3999988958 515013.9399667829,
??????? -308940.1299986392 515003.59996629134,
??????? -308938.5599985644 514997.499966003,
??????? -308924.9999979213 514962.6199643463,
??????? -308921.439997755 514956.3899640478,
??????? -308910.2799972221 514944.63996349275,
??????? -308901.2699967995 514945.0099635087,
??????? -308891.5399963334 514941.33996333554,
??????? -308873.2199954614 514932.08996289596,
??????? -308858.2199947536 514918.0699622296,
??????? -308844.9299941212 514908.16996175796,
??????? -308839.5499938652 514913.7899620272,
??????? -308834.6499936357 514912.4499619603,
??????? -308829.0399933681 514907.06996170804,
??????? -308827.3899932876 514901.95996146277,
??????? -308828.86999335885 514895.079961136,
??????? -308828.7699933499 514882.09996052086,
??????? -308820.27999295294 514860.54995949566,
??????? -308817.84999283403 514852.3899591081,
??????? -308806.34999229014 514816.65995741263,
??????? -308803.40999215096 514801.48995669186,
??????? -308797.2499918565 514775.1099554375,
??????? -308797.5999918729 514770.139955204,
??????? -308795.6499917805 514755.0299544856,
??????? -308796.6799918264 514740.12995377555,
??????? -308796.6499918252 514726.15995311365,
??????? -308791.9299916029 514707.8599522449,
??????? -308790.5599915385 514698.7899518125,
??????? -308791.0399915576 514691.82995148376,
??????? -308789.53999149054 514684.7399511449,
??????? -308790.7099915445 514667.84995034337,
??????? -308788.3499914333 514658.7100499086,
??????? -308791.01999156177 514648.9100494459,
??????? -308791.43999157846 514642.9500491619,
??????? -308795.169991754 514632.23004865274,
??????? -308807.05999232084 514619.0800480284,
??????? -308814.4999926761 514612.6100477204,
??????? -308818.9499928877 514605.930047404,
??????? -308827.3799932897 514599.53004710004,
??????? -308836.2899937108 514586.1700464636,
??????? -308845.5799941495 514581.8200462572,
??????? -308857.39999471605 514569.6700456813,
??????? -308877.12999565154 514573.0300458409,
??????? -308896.719996579 514578.3800460957,
??????? -308913.9799974039 514588.5600465797,
??????? -308918.66999762505 514592.8800467849,
??????? -308930.2199981734 514584.6900463961,
??????? -308937.2399985045 514584.1800463684,
??????? -308943.12999878824 514585.5900464356,
??????? -308947.759999007 514590.9000466876,
??????? -308950.3199991286 514597.060046982,
??????? -308986.2200008333 514597.5600470044,
??????? -308995.6100012809 514606.19004741684,
??????? -309028.27000282705 514653.37004965544,
??????? -309042.7600035146 514660.3600499891,
??????? -309043.7500035614 514660.4300499931,
??????? -309048.1700037718 514668.7199503854,
??????? -309049.60000383854 514705.7499521449,
??????? -309059.2800043002 514724.3899530284,
??????? -309071.1000048667 514741.17995382845,
??????? -309086.95000561327 514757.2499545887,
??????? -309096.71000608057 514774.8899554275,
??????? -309113.04000685364 514812.94995723665,
??????? -309121.7300072685 514831.51995811984,
??????? -309121.28000724316 514852.44995911047,
??????? -309122.88000731915 514872.5299600661,
??????? -309128.4600075856 514892.8799610324,
??????? -309127.0200075209 514913.73996202275,
??????? -309121.6700072661 514933.3299629539,
??????? -309109.4300066829 514951.4499638155,
??????? -309095.42000602186 514966.4399645254,
??????? -309083.1800054386 514984.559965387,
??????? -309081.1200053394 515014.35996680334,
??????? -309068.7200047523 515020.4899670929,
??????? -309068.30000472814 515026.4499673769,
??????? -309067.0300046727 515030.3599675633,
??????? -309054.87000409514 515047.47996837646,
??????? -309043.9700035751 515060.69996900484,
??????? -309041.57000345737 515066.5199692808,
??????? -309032.730003044 515078.8799698688,
??????? -309016.76000228524 515107.71997123584,
??????? -309009.46000193805 515112.20997145027,
??????? -309004.43000169843 515112.8599714823,
??????? -309000.450001508 515112.5799714662,
??????? -308992.78000114113 515108.0599712543
??? ))'), ST_Geomfromtext('POLYGON ((
??????? -308992.78000114113 515108.0599712543,
??????? -308991.140001066 515102.94997100905,
??????? -308984.80000076443 515093.52997056395,
??????? -308976.3200003579 515071.97996953875,
??????? -308965.42999984324 515056.24996879324,
??????? -308955.59999937564 515039.59996800125,
??????? -308945.3999988958 515013.9399667829,
??????? -308940.1299986392 515003.59996629134,
??????? -308938.5599985644 514997.499966003,
??????? -308924.9999979213 514962.6199643463,
??????? -308921.439997755 514956.3899640478,
??????? -308910.2799972221 514944.63996349275,
??????? -308901.2699967995 514945.0099635087,
??????? -308891.5399963334 514941.33996333554,
??????? -308873.2199954614 514932.08996289596,
??????? -308858.2199947536 514918.0699622296,
??????? -308844.9299941212 514908.16996175796,
??????? -308839.5499938652 514913.7899620272,
??????? -308834.6499936357 514912.4499619603,
??????? -308829.0399933681 514907.06996170804,
??????? -308827.3899932876 514901.95996146277,
??????? -308828.86999335885 514895.079961136,
??????? -308828.7699933499 514882.09996052086,
??????? -308820.27999295294 514860.54995949566,
??????? -308817.84999283403 514852.3899591081,
??????? -308806.34999229014 514816.65995741263,
??????? -308803.40999215096 514801.48995669186,
??????? -308797.2499918565 514775.1099554375,
??????? -308797.5999918729 514770.139955204,
??????? -308795.6499917805 514755.0299544856,
??????? -308796.6799918264 514740.12995377555,
??????? -308796.6499918252 514726.15995311365,
??????? -308791.9299916029 514707.8599522449,
??????? -308790.5599915385 514698.7899518125,
??????? -308791.0399915576 514691.82995148376,
??????? -308789.53999149054 514684.7399511449,
??????? -308790.7099915445 514667.84995034337,
??????? -308788.3499914333 514658.7100499086,
??????? -308791.01999156177 514648.9100494459,
??????? -308791.43999157846 514642.9500491619,
??????? -308795.169991754 514632.23004865274,
??????? -308807.05999232084 514619.0800480284,
??????? -308814.4999926761 514612.6100477204,
??????? -308818.9499928877 514605.930047404,
??????? -308827.3799932897 514599.53004710004,
??????? -308836.2899937108 514586.1700464636,
??????? -308845.5799941495 514581.8200462572,
??????? -308857.39999471605 514569.6700456813,
??????? -308877.12999565154 514573.0300458409,
??????? -308896.719996579 514578.3800460957,
??????? -308913.9799974039 514588.5600465797,
??????? -308918.66999762505 514592.8800467849,
??????? -308930.2199981734 514584.6900463961,
??????? -308937.2399985045 514584.1800463684,
??????? -308943.12999878824 514585.5900464356,
??????? -308947.759999007 514590.9000466876,
??????? -308950.3199991286 514597.060046982,
??????? -308986.2200008333 514597.5600470044,
??????? -308995.6100012809 514606.19004741684,
??????? -309028.27000282705 514653.37004965544,
??????? -309042.7600035146 514660.3600499891,
??????? -309043.7500035614 514660.4300499931,
??????? -309048.1700037718 514668.7199503854,
??????? -309049.60000383854 514705.7499521449,
??????? -309059.2800043002 514724.3899530284,
??????? -309071.1000048667 514741.17995382845,
??????? -309086.95000561327 514757.2499545887,
??????? -309096.71000608057 514774.8899554275,
??????? -309113.04000685364 514812.94995723665,
??????? -309121.7200072706 514831.51995811984,
??????? -309121.28000724316 514852.44995911047,
??????? -309122.88000731915 514872.5299600661,
??????? -309128.4600075856 514892.8799610324,
??????? -309127.0200075209 514913.73996202275,
??????? -309121.6700072661 514933.3299629539,
??????? -309109.4300066829 514951.4499638155,
??????? -309095.42000602186 514966.4399645254,
??????? -309083.1800054386 514984.559965387,
??????? -309081.1200053394 515014.35996680334,
??????? -309068.7200047523 515020.4899670929,
??????? -309068.30000472814 515026.4499673769,
??????? -309067.0300046727 515030.3599675633,
??????? -309054.87000409514 515047.47996837646,
??????? -309043.9700035751 515060.69996900484,
??????? -309041.57000345737 515066.5199692808,
??????? -309032.730003044 515078.8799698688,
??????? -309016.76000228524 515107.71997123584,
??????? -309009.46000193805 515112.20997145027,
??????? -309004.43000169843 515112.8599714823,
??????? -309000.450001508 515112.5799714662,
??????? -308992.78000114113 515108.0599712543
??? ))'))
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 function called by ST_Overlaps()
Thanks,
Jean
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/85e510ea/attachment-0001.html>
------------------------------
Message: 16
Date: Tue, 10 Sep 2013 19:51:07 -0400
From: Jean Marchal <jean.d.marchal at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] ST_Overlaps broken ?
Message-ID:
<CACF6B3XT3O3nDpqrm3wLGpmSU45hz8hsWAMpuU4frigKQ-eekQ at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Thanks a lot!! looks like it was my mind more than something else that was
broken!
Jean
2013/9/10 Brent Wood <pcreso at pcreso.com>
>
> 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 different spatial relationships here:
> http://workshops.opengeo.org/postgis-intro/spatial_relationships.html
>
> Brent Wood
>
> ------------------------------
> *From:* Jean Marchal <jean.d.marchal at gmail.com>
> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> *Sent:* Wednesday, September 11, 2013 10:56 AM
> *Subject:* [postgis-users] ST_Overlaps broken ?
>
> Dear PostGIS users,
>
> SELECT ST_Overlaps(ST_GeomFromText('POLYGON ((
> -308992.78000114113 515108.0599712543,
> -308991.140001066 515102.94997100905,
> -308984.80000076443 515093.52997056395,
> -308976.3200003579 515071.97996953875,
> -308965.42999984324 515056.24996879324,
> -308955.59999937564 515039.59996800125,
> -308945.3999988958 515013.9399667829,
> -308940.1299986392 515003.59996629134,
> -308938.5599985644 514997.499966003,
> -308924.9999979213 514962.6199643463,
> -308921.439997755 514956.3899640478,
> -308910.2799972221 514944.63996349275,
> -308901.2699967995 514945.0099635087,
> -308891.5399963334 514941.33996333554,
> -308873.2199954614 514932.08996289596,
> -308858.2199947536 514918.0699622296,
> -308844.9299941212 514908.16996175796,
> -308839.5499938652 514913.7899620272,
> -308834.6499936357 514912.4499619603,
> -308829.0399933681 514907.06996170804,
> -308827.3899932876 514901.95996146277,
> -308828.86999335885 514895.079961136,
> -308828.7699933499 514882.09996052086,
> -308820.27999295294 514860.54995949566,
> -308817.84999283403 514852.3899591081,
> -308806.34999229014 514816.65995741263,
> -308803.40999215096 514801.48995669186,
> -308797.2499918565 514775.1099554375,
> -308797.5999918729 514770.139955204,
> -308795.6499917805 514755.0299544856,
> -308796.6799918264 514740.12995377555,
> -308796.6499918252 514726.15995311365,
> -308791.9299916029 514707.8599522449,
> -308790.5599915385 514698.7899518125,
> -308791.0399915576 514691.82995148376,
> -308789.53999149054 514684.7399511449,
> -308790.7099915445 514667.84995034337,
> -308788.3499914333 514658.7100499086,
> -308791.01999156177 514648.9100494459,
> -308791.43999157846 514642.9500491619,
> -308795.169991754 514632.23004865274,
> -308807.05999232084 514619.0800480284,
> -308814.4999926761 514612.6100477204,
> -308818.9499928877 514605.930047404,
> -308827.3799932897 514599.53004710004,
> -308836.2899937108 514586.1700464636,
> -308845.5799941495 514581.8200462572,
> -308857.39999471605 514569.6700456813,
> -308877.12999565154 514573.0300458409,
> -308896.719996579 514578.3800460957,
> -308913.9799974039 514588.5600465797,
> -308918.66999762505 514592.8800467849,
> -308930.2199981734 514584.6900463961,
> -308937.2399985045 514584.1800463684,
> -308943.12999878824 514585.5900464356,
> -308947.759999007 514590.9000466876,
> -308950.3199991286 514597.060046982,
> -308986.2200008333 514597.5600470044,
> -308995.6100012809 514606.19004741684,
> -309028.27000282705 514653.37004965544,
> -309042.7600035146 514660.3600499891,
> -309043.7500035614 514660.4300499931,
> -309048.1700037718 514668.7199503854,
> -309049.60000383854 514705.7499521449,
> -309059.2800043002 514724.3899530284,
> -309071.1000048667 514741.17995382845,
> -309086.95000561327 514757.2499545887,
> -309096.71000608057 514774.8899554275,
> -309113.04000685364 514812.94995723665,
> -309121.7300072685 514831.51995811984,
> -309121.28000724316 514852.44995911047,
> -309122.88000731915 514872.5299600661,
> -309128.4600075856 514892.8799610324,
> -309127.0200075209 514913.73996202275,
> -309121.6700072661 514933.3299629539,
> -309109.4300066829 514951.4499638155,
> -309095.42000602186 514966.4399645254,
> -309083.1800054386 514984.559965387,
> -309081.1200053394 515014.35996680334,
> -309068.7200047523 515020.4899670929,
> -309068.30000472814 515026.4499673769,
> -309067.0300046727 515030.3599675633,
> -309054.87000409514 515047.47996837646,
> -309043.9700035751 515060.69996900484,
> -309041.57000345737 515066.5199692808,
> -309032.730003044 515078.8799698688,
> -309016.76000228524 515107.71997123584,
> -309009.46000193805 515112.20997145027,
> -309004.43000169843 515112.8599714823,
> -309000.450001508 515112.5799714662,
> -308992.78000114113 515108.0599712543
> ))'), ST_Geomfromtext('POLYGON ((
> -308992.78000114113 515108.0599712543,
> -308991.140001066 515102.94997100905,
> -308984.80000076443 515093.52997056395,
> -308976.3200003579 515071.97996953875,
> -308965.42999984324 515056.24996879324,
> -308955.59999937564 515039.59996800125,
> -308945.3999988958 515013.9399667829,
> -308940.1299986392 515003.59996629134,
> -308938.5599985644 514997.499966003,
> -308924.9999979213 514962.6199643463,
> -308921.439997755 514956.3899640478,
> -308910.2799972221 514944.63996349275,
> -308901.2699967995 514945.0099635087,
> -308891.5399963334 514941.33996333554,
> -308873.2199954614 514932.08996289596,
> -308858.2199947536 514918.0699622296,
> -308844.9299941212 514908.16996175796,
> -308839.5499938652 514913.7899620272,
> -308834.6499936357 514912.4499619603,
> -308829.0399933681 514907.06996170804,
> -308827.3899932876 514901.95996146277,
> -308828.86999335885 514895.079961136,
> -308828.7699933499 514882.09996052086,
> -308820.27999295294 514860.54995949566,
> -308817.84999283403 514852.3899591081,
> -308806.34999229014 514816.65995741263,
> -308803.40999215096 514801.48995669186,
> -308797.2499918565 514775.1099554375,
> -308797.5999918729 514770.139955204,
> -308795.6499917805 514755.0299544856,
> -308796.6799918264 514740.12995377555,
> -308796.6499918252 514726.15995311365,
> -308791.9299916029 514707.8599522449,
> -308790.5599915385 514698.7899518125,
> -308791.0399915576 514691.82995148376,
> -308789.53999149054 514684.7399511449,
> -308790.7099915445 514667.84995034337,
> -308788.3499914333 514658.7100499086,
> -308791.01999156177 514648.9100494459,
> -308791.43999157846 514642.9500491619,
> -308795.169991754 514632.23004865274,
> -308807.05999232084 514619.0800480284,
> -308814.4999926761 514612.6100477204,
> -308818.9499928877 514605.930047404,
> -308827.3799932897 514599.53004710004,
> -308836.2899937108 514586.1700464636,
> -308845.5799941495 514581.8200462572,
> -308857.39999471605 514569.6700456813,
> -308877.12999565154 514573.0300458409,
> -308896.719996579 514578.3800460957,
> -308913.9799974039 514588.5600465797,
> -308918.66999762505 514592.8800467849,
> -308930.2199981734 514584.6900463961,
> -308937.2399985045 514584.1800463684,
> -308943.12999878824 514585.5900464356,
> -308947.759999007 514590.9000466876,
> -308950.3199991286 514597.060046982,
> -308986.2200008333 514597.5600470044,
> -308995.6100012809 514606.19004741684,
> -309028.27000282705 514653.37004965544,
> -309042.7600035146 514660.3600499891,
> -309043.7500035614 514660.4300499931,
> -309048.1700037718 514668.7199503854,
> -309049.60000383854 514705.7499521449,
> -309059.2800043002 514724.3899530284,
> -309071.1000048667 514741.17995382845,
> -309086.95000561327 514757.2499545887,
> -309096.71000608057 514774.8899554275,
> -309113.04000685364 514812.94995723665,
> -309121.7200072706 514831.51995811984,
> -309121.28000724316 514852.44995911047,
> -309122.88000731915 514872.5299600661,
> -309128.4600075856 514892.8799610324,
> -309127.0200075209 514913.73996202275,
> -309121.6700072661 514933.3299629539,
> -309109.4300066829 514951.4499638155,
> -309095.42000602186 514966.4399645254,
> -309083.1800054386 514984.559965387,
> -309081.1200053394 515014.35996680334,
> -309068.7200047523 515020.4899670929,
> -309068.30000472814 515026.4499673769,
> -309067.0300046727 515030.3599675633,
> -309054.87000409514 515047.47996837646,
> -309043.9700035751 515060.69996900484,
> -309041.57000345737 515066.5199692808,
> -309032.730003044 515078.8799698688,
> -309016.76000228524 515107.71997123584,
> -309009.46000193805 515112.20997145027,
> -309004.43000169843 515112.8599714823,
> -309000.450001508 515112.5799714662,
> -308992.78000114113 515108.0599712543
> ))'))
>
> 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 function
> called by ST_Overlaps()
>
> Thanks,
>
> Jean
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
--
Jean Marchal
Etudiant au doctorat / PHD student
Universit? Laval - Pavillon Abitibi-Price
Facult? de foresterie, de g?ographie et de g?omatique
2405, rue de la Terrasse
Qu?bec (Qu?bec) G1V 0A6
T?l: 418-656-2131 poste 2620
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/6c00287f/attachment-0001.html>
------------------------------
Message: 17
Date: Wed, 11 Sep 2013 17:44:59 +0200
From: Athanasios Kostopoulos <athanasios.kostopoulos at classmarkets.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] upgrading from postgresql 8.4 - postgis
1.3.6 to postgresql 9.2/postgis2.0
Message-ID:
<CAFnWstN=w94WmL_ONZQKCpX-_-UYwUmLQqHF8FS2naAvb8oXoA at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Thanks for your input. I tried that approach and it did not work. It gave
the same results when I go the "short" way around by create extensions.
Afterwards I tried with Postgres 8.4, going "the long way". The same
results.
Specifically:
[snipped lots of messages like ERROR: syntax error at or near "'
UPDATE '"
LINE 1: EXECUTE '
]
then eventually:
CREATE FUNCTION pygeocode(text) RETURNS character varying
LANGUAGE plpythonu
AS $_$"
LINE 1: $_$;
^
ERROR: syntax error at or near "#"
LINE 1: # This retrieves the URL from Google,
^
invalid command \n
out of memory
(out of memory happens after a while)
Any tips or ideas are more than welcome. The perl script has not been
tested with postGIS version 1.3.6 - anyone had any success with that
particular version?
On Fri, Sep 6, 2013 at 5:59 PM, Marcos Cano <mcano at stsa.info> wrote:
> I did that a few months ago... Basically what I did was..
>
>
> Install pg9.2.4 (latest stable version) with disable-integer-datetimes
>
> And postgis 2.0.3 pointing against this Postgres version with :
> --with-pgconfig= thepath/to/pg9.2.4/bin/pg_config
>
> I run the both servers the newest in a different tcp port because there
> were something's I still need from
> That server.
>
> Do a pg_dump of the postgis enabled database.. I did the pg_dump with the
> /bin/ folder of
> The older version.
>
>
> In the new server I created a spatially enabled database make sure you
> make it the long way (without EXTENSIONS)
>
> Then I did a restore with the perl script
>
> Greetings
>
> On Friday, September 6, 2013, Athanasios Kostopoulos wrote:
>
>> Dear list,
>> I have a problem that proves to be quite the brain-teaser (at least for
>> me).
>>
>> I have an ancient database (8.4.X) integrated with postGIS 1.3.6.
>> Clearly, this while currently working will reach end of life soon and needs
>> to be upgraded.
>>
>> On a Debian wheezy system, I installed postgres 9.2/postgis2.0 - all from
>> the apt repositories provided by postgres. When I try to do things the
>> recommended way from postGIS (processing the backup with the perl script)
>> during restore I get a few errors and constantly increasing memory usage,
>> until the restore process will die with an "out of memory error". When I
>> try to restore the "pure" dump, I get a number of errors.
>>
>> Now, I understand that I am talking a big increase in major versions,
>> including some non backwards compatible changes in postgis but such an
>> upgrade should be feasible. Can someone give me a small push, so I can move
>> forward with this? I would prefer to upgrade to the latest versions of
>> postgresql and postGIS, if such a thing is possible.
>>
>> Thanks in advance for any replies.
>>
>> classmarkets GmbH | Schumannstra?e 6 | 10117 Berlin | Deutschland
>> Tel: +49 (0)30 56 59 001-0 | Fax: +49 (0)30 56 59 001-99 |
>> www.classmarkets.com
>>
>> Amtsgericht Charlottenburg HRB 111815 B | USt.Id.Nr: DE 260731582
>> Gesch?ftsf?hrer: Veit M?rz, Fabian Str?hle
>>
>> Diese Nachricht (inklusive aller Anh?nge) ist vertraulich. Sie darf
>> ausschlie?lich durch den vorgesehenen Empf?nger und Adressaten gelesen,
>> kopiert oder genutzt werden. Sollten Sie diese Nachricht versehentlich
>> erhalten haben, bitten wir, den Absender (durch Antwort-E-Mail) hiervon
>> unverz?glich zu informieren und die Nachricht zu l?schen. Jede unerlaubte
>> Nutzung oder Weitergabe des Inhalts dieser Nachricht, sei es vollst?ndig
>> oder teilweise, ist unzul?ssig. Bitte beachten Sie, dass E-Mail-Nachrichten
>> an den Absender nicht f?r fristgebundene Mitteilungen geeignet sind.
>> Fristgebundene Mitteilungen sind daher ausschlie?lich per Post oder per
>> Telefax zu ?bersenden.
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
--
classmarkets GmbH | Schumannstra?e 6 | 10117 Berlin | Deutschland
Tel: +49 (0)30 56 59 001-0 | Fax: +49 (0)30 56 59 001-99 |
www.classmarkets.com
Amtsgericht Charlottenburg HRB 111815 B | USt.Id.Nr: DE 260731582
Gesch?ftsf?hrer: Veit M?rz, Fabian Str?hle
Diese Nachricht (inklusive aller Anh?nge) ist vertraulich. Sie darf
ausschlie?lich durch den vorgesehenen Empf?nger und Adressaten gelesen,
kopiert oder genutzt werden. Sollten Sie diese Nachricht versehentlich
erhalten haben, bitten wir, den Absender (durch Antwort-E-Mail) hiervon
unverz?glich zu informieren und die Nachricht zu l?schen. Jede unerlaubte
Nutzung oder Weitergabe des Inhalts dieser Nachricht, sei es vollst?ndig
oder teilweise, ist unzul?ssig. Bitte beachten Sie, dass E-Mail-Nachrichten
an den Absender nicht f?r fristgebundene Mitteilungen geeignet sind.
Fristgebundene Mitteilungen sind daher ausschlie?lich per Post oder per
Telefax zu ?bersenden.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130911/8b1d975b/attachment-0001.html>
------------------------------
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
End of postgis-users Digest, Vol 139, Issue 8
*********************************************
More information about the postgis-users
mailing list