[postgis-users] ST_Covers for Geography

DrYSG ygutfreund at draper.com
Tue Jul 24 11:53:09 PDT 2012


I am getting this error: 
*"geography_covers: only POLYGON and POINT types are currently supported"*
But I can't see what is wrong. Especially, since I have an ST_Intersects
that matches this request, but does not return the error. As far as I can
tell, I am passing in Polygons (cat.gpoly) is a geography polygon.

ST_Covers version:

*SELECT
cat.idx,cat.size_bytes,cat.date,cat.type,cat.elevation,cat.source,cat.egpl_date,cat.classification,cat.classification_int,cat.handling,cat.originator,cat.datum,cat.product,cat.description,cat.bbox,cat.path,cat.year
FROM portal.catalog AS cat 
 WHERE ST_Covers(st_geogfromtext('SRID=4326;POLYGON((-70.88758389282220
42.50890460863670,-71.24841610717770 42.50890460863670,-71.24841610717770
42.22276957602410,-70.88758389282220 42.22276957602410,-70.88758389282220
42.50890460863670))'), cat.gpoly) AND (cat.date >= '1/1/1900 5:00:00 AM' AND
cat.date <= '7/24/2012 2:45:06 PM') LIMIT 5000;*

ST_Intersects version: (which works fine) and has the same values:

*SELECT
cat.idx,cat.size_bytes,cat.date,cat.type,cat.elevation,cat.source,cat.egpl_date,cat.classification,cat.classification_int,cat.handling,cat.originator,cat.datum,cat.product,cat.description,cat.bbox,cat.path,cat.year
FROM portal.catalog AS cat 
 WHERE ST_Intersects(st_geogfromtext('SRID=4326;POLYGON((-70.88758389282220
42.50890460863670,-71.24841610717770 42.50890460863670,-71.24841610717770
42.22276957602410,-70.88758389282220 42.22276957602410,-70.88758389282220
42.50890460863670))'), cat.gpoly) AND (cat.date >= '1/1/1900 5:00:00 AM' AND
cat.date <= '7/24/2012 2:45:03 PM') LIMIT 5000;*

-- -1 row(s) affected.



--
View this message in context: http://postgis.17.n6.nabble.com/ST-Covers-for-Geography-tp4999120.html
Sent from the PostGIS - User mailing list archive at Nabble.com.



More information about the postgis-users mailing list