[postgis-users] error

[mathias cunault]

I would say you have at least one geometry error in your dataset. Did you
Check them?

Le mar. 24 mai 2022 à 17:58, Sydney Togarepi <stogarepi at gmail.com> a écrit :

> My sql query is liek this
>
> select cntry_name
> from public.country
> where st_dwithin(st_transform(country.geom,32736),(select
> (st_transform(cities1.geom,32736))from public.cities1 where city_name
> ='Harare'),600)
>
> and i am getting this error message.
> ERROR: ptarray_contains_point called on unclosed ring CONTEXT: SQL
> function "st_dwithin" statement 1 SQL state: XX000
>
> i am trying to get cities that are within a distance of 600unit from the
> given city
>
>
> Sydney Togarepi
> cell +263 773 883 627
> e-mail:stogarepi at gmail.com
> Skype: sydney998
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220524/e38878f9/attachment.htm>