Re: Spatial join issues

Shaozhong SHI <[email protected]> Wed, 29 Oct 2025 17:00:03 +0000
Newsgroups gmane.comp.gis.postgis
Message-ID <CA+i5JwYiNtAcw2AE=gw_Fd-PrXO-3JbYSp3-gNEkg4eZp2BdUg@mail.gmail.com>
--000000000000f6324306424f1045
Content-Type: text/plain; charset="UTF-8"

This is very challenging.  Take my words for it.  Try on any polygons you
created and modified.

On Wed, 29 Oct 2025 at 14:36, Greg Troxel <[email protected]> wrote:

> Shaozhong SHI <[email protected]> writes:
>
> >   Visually, there appears some matching polygons.  Even if two geometries
> > represent the same shape visually, they might not be considered equal due
> > to tiny differences in precision or metadata.  Have you encountered
> > problems of failure of spatial join?  How did you overcome the problems?
> > Regards, David
>
> Could you post your example polygons, and the queries you are using?
> Your question is much too open ended.  It even sounds like it might be a
> request for help with GIS homework, but it's hard to tell :-)
>
>

--000000000000f6324306424f1045
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">This is very challenging.=C2=A0 Take my words for it.=C2=
=A0 Try on any polygons you created and modified.</div><br><div class=3D"gm=
ail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On W=
ed, 29 Oct 2025 at 14:36, Greg Troxel &lt;<a href=3D"mailto:[email protected]"=
>[email protected]</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" s=
tyle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pad=
ding-left:1ex">Shaozhong SHI &lt;<a href=3D"mailto:[email protected]" =
target=3D"_blank">[email protected]</a>&gt; writes:<br>
<br>
&gt;=C2=A0 =C2=A0Visually, there appears some matching polygons.=C2=A0 Even=
 if two geometries<br>
&gt; represent the same shape visually, they might not be considered equal =
due<br>
&gt; to tiny differences in precision or metadata.=C2=A0 Have you encounter=
ed<br>
&gt; problems of failure of spatial join?=C2=A0 How did you overcome the pr=
oblems?<br>
&gt; Regards, David<br>
<br>
Could you post your example polygons, and the queries you are using?<br>
Your question is much too open ended.=C2=A0 It even sounds like it might be=
 a<br>
request for help with GIS homework, but it&#39;s hard to tell :-)<br>
<br>
</blockquote></div>

--000000000000f6324306424f1045--