[postgis-users] Operation on mixed SRID geometries

[Milo van der Linden]

My guess is you should take a two step approach here, something like:

select count(*) FROM shey6 WHERE shey6_id in (SELECT shey6_id FROM shey6 
as a,sel10p4 as b WHERE contains(a.wkb_geometry,b.wkb_geometry) ='t')

hope this helps!

Kind regards,


temiz schreef:
> hello
>
> when I enter this command:
>
> select count(*) from shey6 as a,sel10p4 as b where 
> contains(a.wkb_geometry,b.wkb_geometry) ='t';
> ERROR:  Operation on mixed SRID geometries
>
> shey6 polygon
> sel10p4 point
>
>
> how can I solve the problem ?
>
>
> regards
>


-- 


	

Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
mlinden at zeelandnet.nl <mailto:mlinden at zeelandnet.nl>
milovanderlinden at gmail.com <mailto:milovanderlinden at gmail.com>
milo at 3dsite.nl <mailto:milo at 3dsite.nl>
http://www.3dsite.nl

	  	

De informatie in dit bericht reflecteert mijn persoonlijke mening en 
niet die van een bedrijf of instantie. Aan de informatie kunnen geen 
rechten worden ontleend. Indien dit bericht onderdeel is van een forum, 
mailing-list of community dan gelden automatisch de bij het betreffende 
medium behorende voorwaarden. The information in this message reflects 
my personal opinion and not that of a company or public body. All rights 
reserved.If this message is contained in a mailing-list or community, 
the rights on the medium are automatically adapted.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071001/1d080694/attachment.html>