[postgis-users] ST_CoveredBy supporting geography?

[Paragon Corporation]

Nick,

Hmm, I guess we didn't provide a geography example and also didn't put in
the restrictions for geography.  We'll update the docs.

For geometry -- ST_CoveredBy covers Polygon/polygon and various other
permutations.

The geography version is much more limited and as Paul mentioned only covers
Polygon /POINT

Hope that helps,
Regina
http://www.postgis.us

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Nick
Bower
Sent: Tuesday, May 11, 2010 6:06 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] ST_CoveredBy supporting geography?

Thanks but not according to the doc I think?
1) Abstract superclass is mentioned in API, not point,
2) the SQL example uses circles
3) the blog link specifically uses polygons in it's discussion of OGC
coverage behaviour.

http://postgis.refractions.net/documentation/manual-1.5/ST_CoveredBy.html

I'm not disputing your explanation given the evidence, but suggest the docs
are entirely misleading for me figuring out if one polygon geography is
wholey inside another.


On 11/05/2010, at 11:48 PM, Paul Ramsey <pramsey at opengeo.org> wrote:

> Bad sentence construction in the error, perhaps? The restriction "only 
> polygon and point" means that one argument must be a polygon and one 
> must be a point. Both your arguments are polygons.
>
> P.
>
> On Tue, May 11, 2010 at 4:51 AM, Nicholas Bower <nick at petangent.net>
> wrote:
>> I've read the 1.5 reference docs but can't figure out what is wrong 
>> with below.  ST_CoveredBy(geography, geography) should work right?
>>   select count(*) from t_swath_metadata where ST_CoveredBy(
>>  ST_GeogFromText('SRID=4326;POLYGON((123.1773295292851
>> -16.07501950971949,
>>                           122.745660066063 -16.83965661151543,
>>                           124.1310486688905 -16.44978157737539,
>>                           123.1773295292851 -16.07501950971949))'), 
>> swath_bounding);
>> ERROR:  geography_covers: only POLYGON and POINT types are currently 
>> supported
>> CONTEXT:  SQL function "st_covers" statement 1
>> ********** Error **********
>> ERROR: geography_covers: only POLYGON and POINT types are currently 
>> supported SQL state: XX000
>> Context: SQL function "st_covers" statement 1
>>
>> db=> \d t_swath_metadata;
>> ...
>>  swath_bounding        | geography(Polygon,4326)     |
>> Indexes:
>>     ...
>>     "t_swath_metadata_swath_bounding_key" gist (swath_bounding)
>>
>> Thanks, Nick
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users