[postgis-users] ST_CoveredBy supporting geography?

Nicholas Bower nick at petangent.net
Tue May 11 04:51:07 PDT 2010


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100511/27f0957d/attachment.html>


More information about the postgis-users mailing list