TransWikia.com

Using use_spheroid=false in ST_DWithin of PostGIS

Geographic Information Systems Asked by Shana on August 14, 2021

I have created 2 geography columns and indexed them using GIST. I am looking to use ST_DWithin for a larger dataset and to make it faster trying to use the use_spheroid=false.

SELECT pois.objectid, ST_Multi(ST_Union(polygon.coordinates)) as coords   
              into table3
              FROM table1 as polygon 
              INNER JOIN table12 as pois 
              ON ST_DWithin(polygon.geog,pois.geog, 10* 1609.34, use_spheroid=false)
              group by pois.objectid
            limit 1;

but I get the following error,

ERROR:  column "use_spheroid" does not exist

Am I using the use_spheroid=false argument correctly

One Answer

Just set it to false without naming it.

ST_DWithin(polygon.geog,pois.geog, 10* 1609.34, false)

Correct answer by JGH on August 14, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP