Questions tagged [postgis-2.4]

version 2.4 of postgis

Filter by
Sorted by
Tagged with
0
votes
0answers
39 views

Error in installing PostGIS extension through PostgreSQL 11

I am getting following issues while installing PostGIS extension.
1
vote
0answers
34 views

Changing Map Coordinate System Changes in ArcGIS Pro Changes Azimuth

I am trying to create a label that will overlay a line in ArcGIS Pro, the layer is coming from a PostGIS database. The underlying materialized view for the label/symbol overlay is something like this: ...
0
votes
1answer
56 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
77 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) ...
1
vote
2answers
92 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
91 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
260 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
150 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
507 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
54 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
598 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 ...