Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [postgis-2.4]

version 2.4 of postgis

0
votes
1answer
21 views

ST_Contains always return false

I'm definitely a 'geonewbie' and I'm trying to test if a point is contained inside a region. I have taken some certified data here: https://www.istat.it/it/archivio/124086 getting WGS84 UTM32N for ...
1
vote
0answers
56 views

Query for finding intersection points between adjacent features within a buffer tolerance - PostGIS

I've developed the queries to find out intersection points (within 0.2 buffer) between line and polygon and also within adjacent polygons by using PostgreSQL 10 and PostGIS 2.4 database. Line data is ...
0
votes
1answer
75 views

Finding self-intersection in PostGIS

I've developed an query to find self-intersection points by using PostgreSQL 10 and PostGIS 2.4 database. The query took long time (aprx 90mins) to produce the result from 3,122 polygons. The query is:...
0
votes
1answer
45 views

What is the SQL in pgAdmin for PostgGIS Shapefile loader GUI Import and Export

I have been using PostGIS Shapefile loader to import and export shapefile, but now I want to ask is there any SQL alternative to this GUI import and export.
0
votes
0answers
173 views

Geocoding addreses using PostGIS?

I have a requirement where I am supposed to be able to take a reference address and provide the 3 closet addresses to the reference address from a list of addressses. So far I have Installed ...
0
votes
0answers
42 views

Using schema other than public with PostGIS? [duplicate]

I've read (too late) that it's best to use another schema to store data tables in than the public schema when using PostGIS. e.g. here: Using a schema other than public in PostGIS? Considering this ...
0
votes
0answers
17 views

ST_Intersection between two raster returning different results depending on input order

Depending on the input order of two rasters, I get different results even though I select the correct band. In my opinion, the following two queries should return the same results: 1st query: SELECT ...
4
votes
1answer
357 views

Speed up point sampling with ST_Value function in PostGIS, raster/vector overlay

I managed to extract raster values in PostGIS based on a table of point geometries by following Point sampling raster with PostGIS SELECT id, ST_Value(rastertable.rast, 1, pointtable.geom) as ...