> On Feb 26, 2021, at 10:40 AM, Frederic Leclercq wrote:
>
> Hi all,
>
> I've installed postgis via apt on ubuntu, and upgraded GEOS to 3.9 manually.
> How can I force PostGis to use this updated version of GEOS? Do I need to
> re-install postgis by compiling the source, or is there another
Hi all,
I've installed postgis via apt on ubuntu, and upgraded GEOS to 3.9
manually. How can I force PostGis to use this updated version of GEOS? Do I
need to re-install postgis by compiling the source, or is there another
(easy) way to achieve this?
Thanks in advance,
Fred.
_
Am 26.02.2021 09:01, schrieb karsten:
Hi Karsten
just to check first: is planet_osm_polygon.way a column holding a
PostGIS
polygon geometry type ?
way is geometry(Geometry,3857) in planet_osm_polygon and in my "cities"
table, too.
As is it rather appears to me that you are trying to inter
>>> Second question: which index should I create to speed these queries up?
Just an Index on the column "way"?
Yes that is the first and most important step.
If 'way' is the geometry column then create a gist (spatial) index and
also set a primary key
ALTER TABLE cities.way ADD CONSTRAINT cit
2. well way is really the geometry column so
CREATE INDEX cities_way_gist
ON cities
USING gist(way);
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
sorry it is
ALTER TABLE cities ADD CONSTRAINT cities_pkey PRIMARY KEY(id);
CREATE INDEX cities_way_gist
ON cities
USING gist
(geom);
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-us
Hi Luca
just to check first: is planet_osm_polygon.way a column holding a PostGIS
polygon geometry type ?
As is it rather appears to me that you are trying to intersect below a way
(line) with a ´single point - which rarely will give you any hit = result
back ;)
Overall you will need to feed the
