Question : I have two points and I have to calculate difference between them. I using below query in SQL […]
Tag: postgis
Change owner of relation in PostgreSQL database
Question : I just started using PostgreSQL and have problems in changing the ownwer of a table. I have a […]
Why does this PostGIS query take so long to run?
Question : I am new to PostGIS and SQL in general. I am running a query on polygons which, I […]
Deciding the best way to partition (Postgresql)
Question : I have been trying to research this for quite a while now and I am having a hard […]
How to verify that at least one point fall into a polygon with Postgis?
Question : I have two tables where table A has a geometry (4326) column that contains surfaces (~20M). A second […]
Can’t get this PostgreSQL query to run faster
Question : I’m running PostgreSQL 9.6 with PostGIS 2.3.3 I’m trying to make this rather critical query go faster (looking […]
SQL query: insert values into polygon where features of the polygon intersects another polygon [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Using SELECT to call a function in a jdbc migration
Question : I’m looking to set up some Postgres/PostGIS migrations with clojure/jdbc. running side-effect functions with SELECT is proving to […]
Finding road segements which are not split at intersection.(Query Optimization )
Question : I have a query in which I am trying to find the road segments which intersect but are […]
Set field values to newly imported rows in PostgreSQL table with existing data
Question : I have a PostgreSQL table with existing data, and needs to import all the rows in a CSV […]