[postgis-users] Spatial linking or selection

Shaozhong SHI shishaozhong at gmail.com
Fri May 15 05:35:25 PDT 2020


Hi, Friends,

I am a little bit confused.

If I use geometry as data type, do I put something like 5 metres and
use_spheroid=false?

Is that correct?

Regards,

Shao

On Fri, 15 May 2020 at 13:00, Giuseppe Broccolo <g.broccolo.7 at gmail.com>
wrote:

> Hi Shao,
>
> Il giorno ven 15 mag 2020 alle ore 11:56 Shaozhong SHI <
> shishaozhong at gmail.com> ha scritto:
>
>> Hi, Nicolas,
>>
>> Thanks.
>>
>> That is very interesting.  I will test it.
>>
>> I could not find information on how distance is defined.  0.01 stands on
>> what unit?
>>
>> https://postgis.net/docs/ST_DWithin.html
>>
>
> Have a look to this statement in the doc you linked:
>
> """
> For geometry: The distance is specified in units defined by the spatial
> reference system of the geometries. For this function to make sense, the
> source geometries must both be of the same coordinate projection, having
> the same SRID.
>
> For geography units are in meters and measurement is defaulted to
> use_spheroid=true, for faster check, use_spheroid=false to measure along
> sphere.
> """
>
> Giuseppe.
>
> _______________________________________________
> 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/20200515/e8ee90e1/attachment.html>


More information about the postgis-users mailing list