Using PostgreSQL/PostGIS, given a point position I need extract the nearest linestring from a db table and update the founded geometry adding the given point based on the point position. For these purposes the PostGIS function ST_AddPoint can be used,…
I'm trying to run a local Postgres database with the PostGIS extension, and then populate the database with a shapefile, without having to load the data in manually. I have a docker-compose.yml where I'm first using the postgis docker image…
When I build the Dockerfile below by running the command manually at a Windows notebook docker build -f Dockerfile --no-cache --tag my-postgis:16-3.4 --build-arg DOWNLOAD_URLS="https://download.geofabrik.de/europe/germany/berlin-latest.osm.pbf https://download.geofabrik.de/europe/germany/hamburg-latest.osm.pbf" --build-arg OSM_PASSWORD=osm_password --build-arg POSTGIS_TAG=16-3.4 . then it works as expected and the prefilled PostgreSQL database…
I have the following query to try and get a total of places within the range of a provided point, comparing against my table of places. All places have a geo column, defined as geo point default null. select count(*)…
CASE A SELECT ST_DistanceSphere( ST_GeomFromText('POINT(127.058923 37.242621)', 4326), "geometryType")as distance FROM "MyTable" WHERE ST_DistanceSphere( ST_GeomFromText('POINT(127.058923 37.242621)', 4326), "geometryType") < 500; CASE B SELECT ST_DistanceSphere( ST_GeomFromText('POINT(${longitude} ${latitude})', 4326), "geometryType")as distance FROM "MyTable" WHERE ST_DistanceSphere( ST_GeomFromText('POINT(${longitude} ${latitude})', 4326), "geometryType") < 500; When performing…
When I try to install postgis33_15 on Rocky Linux 8, I end up with the following error package postgis33_15-3.3.1-1.rhel8.x86_64 from pgdg15 requires gdal35-libs >= 3.5.2, but none of the providers can be installed package postgis33_15-3.3.1-1.rhel8.x86_64 from pgdg15 requires libgdal.so.31()(64bit), but…
If I use the statement SELECT * FROM dump WHERE (x_orig IS NOT NULL) OR (x_dest IS NOT NULL); It does not filter out the null values in the columns I indicate. But when I use the statement SELECT *…
Using Postgres and Postgis I was experiencing a very slow spatial join using st_equals. Out of curiosity, I tried using = instead, and the join was much faster. Using EXPLAIN, I noticed that the st_equals join uses a nested loop,…
I am implementing a Tile Server with the help of PostGIS. Running this query: SELECT ST_AsMVT(tile) FROM ( SELECT __FEATURES__, ST_AsMVTGeom( ST_Transform(__GEOM__, __SRID__), ST_Transform(ST_TileEnvelope(?, ?, ?), __SRID__), 4096, 256, false ) as geom FROM __SCHEMA__.__TABLE__ WHERE __GEOM__ && ST_Transform(ST_TileEnvelope(?, ?,…
I have a question that I'm sure you experts can easily answer :-) from a table in postgresql/postgis with the following content ID | car | timestamp | geom | startflag 903 | test1 | 03.11.23 08:38:52 | 0101000020E61000001D33F55 |…