[postgis-users] ST_CoveredBy supporting geography?
Nick Bower
nick at petangent.net
Tue May 11 15:06:22 PDT 2010
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
More information about the postgis-users
mailing list