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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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 <pram...@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 <n...@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@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users