Questions tagged [postgis-2.4]

version 2.4 of postgis

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

Error in adding PostGIS extension :- rtpostgis-2.4.dll could not be loaded

I need to created web based application to showcase GIS data using .Net technology. After going through couple of blogs and links, I installed Postgress 10 and PostGIS 2.4. When i tried to add ...
0
votes
0answers
71 views

Error in installing PostGIS extension through PostgreSQL 11

I am getting following issues while installing PostGIS extension.
1
vote
0answers
56 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
71 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
107 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
178 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
101 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
499 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
266 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
756 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
59 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
847 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 ...