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
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [postgresql-10]

The tag has no usage guidance.

0
votes
1answer
32 views

PosGIS KNN returns different results from QGIS hub spoke function

Following example here I have tried to get nearest neighbours where code is; CREATE TABLE model.hub_spoke_spokes3f AS SELECT hub.id AS hub_id, spoke.id, spoke.point_geom, ST_Distance(hub....
2
votes
0answers
28 views

How to create a valid QgsVectorLayer from a PostgreSQL view?

I am attempting to create a QgsVectorLayer with the same code as I am using for a PostgreSQL table, which works correctly and the isValid() method on the layer returns true. uri=QgsDataSourceUri() ...
0
votes
1answer
63 views

Osm2pgsql, permission denied when creating node cache file

This is probably a dumb issue but I'm kind of stuck while trying to import a big data set into an existing database with osm2pgsql. More specifically, I'm getting a permission denied error when using ...
3
votes
1answer
40 views

QGIS “ERROR” written in all fields in attribute table of a View coming from PostgreSQL/PostGIS

I have a table of around 800000 records with POINT geometry in PostgreSQL/PostGIS. When I directly open the table in QGIS, the attribute table opens fine and the fields are populated. But when I open ...
5
votes
2answers
1k views

How to resolve the “ERROR: could not open extension control file” when "create extension postgis;' for PostgreSQL 10?

I am receiving this error when I create extension postgis;: SQL Error [58P01]: ERROR: could not open extension control file "C:/POSTGR~1/10.5/pg10/../pg10/share/postgresql/extension/postgis....
2
votes
0answers
72 views

pgrouting extension slow in PostgreSQL 10?

I am trying to implement routing on my road dataset using pgrouting function pgr_createTopology. It works fine on postgresql 9.6 but gets extremely slow and get stuck as nodes increase in postgresql ...
0
votes
1answer
47 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.
1
vote
1answer
33 views

How to write dynamic SQL for a function that has dynamic SQL parameter?

I am trying to execute a string SQL query in function i.e. Create or Replace Function Route(edge_table text) Returns table(sequence integer) as $$ Begin Return Query Execute 'with r as( SELECT seq, ...
1
vote
2answers
726 views

Can't install PostGIS extension to PostgreSQL

I just installed a fresh new install of PostgreSQL-10.5-1-win64-bigsql Once installed I wanted to add the PostGIS extension ran: CREATE EXTENSION postgis; Got error message could not find C:\...
0
votes
2answers
43 views

Problem While Selecting from table using ST_Transform

This following query is not returning any values SELECT * FROM leads WHERE leads.latlong && ST_Transform( ST_MakeEnvelope(78.2137, 12.5186, 78.2460, 12.5419, 4326),3587); Results like: ...
0
votes
1answer
52 views

Running Query of pgRouting and PostGIS - dijkstra_sp_delta()?

Using PostgreSQL 10.4, compiled by Visual C++ build 1800, 64-bit PostGIS 2.4.4 pgRouting 2.6.0 and This Tutorial I am trying to run this Query $conn = pg_connect($conString); $sql = "...
1
vote
0answers
89 views

ERROR: function st_straightskeleton(geometry) does not exist

I'm trying to calculate center line from polygon, so i'm trying to do with postgis function st_straightskeleton but it is rising the error of function not found. postgis version: POSTGIS="2.4.3 ...
0
votes
0answers
29 views

Routing from user location to POI in pgRouting?

I have roads(edge) table and hospitals(point of interest) table in pgRouting database. Now I want to take user location or any point location that user inputs as a starting node and ending node must ...
5
votes
1answer
60 views

PostGIS same query and same geom produce different output when writing hex or text formatted geom

the same geom(etry) once in hex code and the other one in text formatted produce in text formatted a linestring (which is correct!) and once a multilinestring when using the raw hex geom (which is ...
0
votes
0answers
81 views

loading satellite image in qgis3

Hi I had loaded a satellite imagery in PostgreSql using command "raster2pgsql -s 4326 -I -C -M E:\20Mar\55M1_Geo.tif -F -t 100x100 public.55M1_Geo | psql -d rasterdata -p 5437 -U postgres" and ...
0
votes
0answers
43 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 ...
1
vote
1answer
54 views

Return Majority from PostGIS function ST_SummaryStatsAgg()

The mentioned function Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a raster or raster coverage. I have an image of land cover classes (a ...
0
votes
1answer
39 views

merge postgis schema with FME

I have a spatial postgis database named "testdata" having two schema named "afgdata" and "pakdata" with common table names viz. building_a, places, railways, roads, water_a, waterways of different ...
4
votes
1answer
366 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 ...
3
votes
1answer
1k views

Stack Builder not finding spatial extentions for Postgre 10 when installing PostGIS

I've never set up a development environment on Windows before. I followed this guide which is for PostgreSQL 9, but nevertheless. PostGIS is supposed to be installable through Stack Builder, but ...