Questions tagged [postgis-2.4]

version 2.4 of postgis

0
votes
1answer
49 views

Parse PostGIS raw data

I have this raw text value extracted from Postgres geometry(point) type 0101000020E6100000FAFFEFE0FB444B40672BE61C924E3840 I was wondering if there is any way to get the lat,long values from it ...
2
votes
1answer
70 views

ST_Transform not working locally

I am using PostgreSQL 9.6 and PostGIS extension 2.4.4. On my machine, I get an error while running ST_Transform query: SELECT ST_Transform(ST_SetSRID(ST_MakePoint('27.9252', '-26.0987'),4326),32619) ...
0
votes
1answer
54 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
82 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
217 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
129 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
423 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
53 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 ...
4
votes
1answer
546 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 ...