Questions tagged [postgresql]

PostgreSQL is an open source object-relational database system.

Filter by
Sorted by
Tagged with
0
votes
1answer
31 views

Transfer & maintain a relational database in QGIS - backend vs frontend

I'm going to set up a small db for my own use in QGIS. I can see only a few of the many tables will be spatial, but the ease of use and capacity of the widgets in QGIS are attractive. I won't writing (...
0
votes
0answers
15 views

storing raster column externally in PostgreSQL

I read this article by Paul Ramsey: 5x Faster Spatial Join with this One Weird Trick I was thinking whether we can do it for the raster columns or not. Because working with rasters is usually very ...
0
votes
0answers
14 views

ERROR: lwcollection_construct: mixed dimension geometries: 0/2

I am running g a intersection between two data sets. Both have same Projection system 27700 but still I am getting this error: ERROR: lwcollection_construct: mixed dimension geometries: 0/2 Below ...
0
votes
1answer
36 views

PostgreSQL connection doesn't show up in Data Source Manager

I have data for a PostgreSQL connection. After writing the data in QgsSettings. The connection works but in the Data Source Manager under PostgreSQL connections is nothing documented. After I restart ...
3
votes
0answers
50 views

Difference between ST_Simplify function in PostGIS 3.0.0 and PostGIS 2.5.3

Faced such a problem (or maybe it's a bug). I get different results when using the ST_Simplify function in PostGIS 3.0.0 and PostGIS 2.5.3. There are source data that are simplified by using a query: ...
2
votes
1answer
2k views

postgis not valid win 32 application

I'm trying to setup Postgres 9.5 on my local machine x64 based win 8. I've downloaded postgresql-9.5.1-1-windows.exe and also downloaded postgis-bundle-pg95x64-setup-2.2.2-1.exe Postgres runs fine, ...
2
votes
1answer
38 views

Trying ST_Slope with SRTM rasters and a shapefile but the output raster has different SRID

I have two SRTM rasters https://dds.cr.usgs.gov/srtm/version2_1/SRTM1/Region_06/ (N40W074 and N40W075) with Datum "WGS_1984" I've united them to be able to work with one raster: CREATE TABLE rasters....
4
votes
2answers
65 views

osm2pgrouting creates erroneous roads

osm2pgrouting works without giving any errors but most of the roads have lost their geometry. Result is ; What I've done so far; OSM Data downloaded from http://download.geofabrik.de/ in pbf ...
2
votes
1answer
36 views

Trying to set SRID for a Geometry

I imported precinct data from the Harvard Dataverse into Postgres 9.3 using the PostGIS Shapefile Import/Export Manager. It creates a geom column with a SRID of 0. I think the data is projected as ...
2
votes
1answer
27 views

Create a new connection in QGIS 3.4.3 DB Manager

I am trying to establish a new database connection from QGIS 3.4.3 to Postgres/PostGIS. I have two connections established but I can't find any options to establish another connection. I cannot recall ...
2
votes
2answers
62 views

PostgreSQL/PostGIS 12. shp2pgsql.exe only blinks

I am running PostgreSQL/PostGIS version 12 (win10/64 bit) attempting to import shapefiles by means of shp2pgsql.exe. Really nothing happens. The GUI only blinks a fraction of a second. Then nothing. ...
1
vote
1answer
60 views

Bounding box in Dijkstra algorithm (many to many)

I apologize for the delicate duplication of my TOPIC but I am still standing. I have the table, which has information about pairs between source places and points (without geometry). I have used this ...
0
votes
1answer
261 views

How best to divide line features into equal parts and create continuous buffer zones for them using Postgres/PostGIS and QGIS [closed]

Having familiarized with an similar question specified on the link Dividing a buffer into segments based on path and distance, the author asked an analogous question whether it is possible to solve ...
1
vote
0answers
21 views

st_3dshortestline equivalent in Python 3

I have two geopandas Dataframes with 3D geometry. I could transform it in any other data type it could be more easy to use. I would like to know if there is something similar to the st_3dshortestline ...
0
votes
0answers
25 views

PostGIS with GeoJSON: `geometry` v. `geography`

Does the GeoJSON spec imply or strongly suggest that PostGIS geometry type should be used over geography? Looking at section 3.1.1 I am seeing that In other words, every point on a line that ...
5
votes
0answers
412 views

How to add geometries using EntityFramework 6, EF designer from database, npgsql and postgis?

I have a postgre database with postgis geometries that i would like to access using Entity framework and npgsql. I tried to go for the "EF designer from database" , but when doing so i only get the ...
2
votes
1answer
82 views

How to increase a PostGIS query efficiency when querying OSM information

I have this SQL query to get roads from my PostGIS server. WITH boxed_roads AS (SELECT * FROM "planet_osm_line" WHERE ST_Within(way, ST_MakeEnvelope(xmax ,xmin, ymax, ymin, 4326)) ) SELECT ...
1
vote
0answers
26 views

Tenant isolation in SaaS product based on PostGIS - do the same concepts as PostgreSQL apply?

We're working on two different GIS apps and we're a bit torn around how to provide a level of tenant data isolation on our GIS systems. System A would need to have strong tenant data isolation where ...
0
votes
1answer
416 views

Edit a view of a PostGIS table in QGIS

I have a simple layer in PostGIS created as follows: CREATE TABLE layer ( id serial PRIMARY KEY, geom geometry(LINESTRING, 31370), ... ) To avoid duplicate information, I created a view ...
-1
votes
0answers
26 views

Extracting closest point based on PostgreSQL field

How could I do the following PostgreSQL query: tables: stations (point), field: tp_min point of interest (point) buffer (polygon) I need to extract the meteorological station closest to the ...
1
vote
1answer
40 views

enabling scrolling hstore key/value field

The key/value widget applied on a Postgres hstore field conveniently shows, for a record, a sub-table containing the various keys and values. If there isn't enough space in the form, this sub-table is ...
2
votes
3answers
78 views

How to convert UK grid to coordinates in PostgreSQL?

I have a very large file with UK grid references that I need to get coordinates from I'm on a Mac so I cant seem to use the solution provided in this link https://digimap.edina.ac.uk/webhelp/os/...
2
votes
1answer
83 views

Invalid Geometry - Which column can I change to geometry?

I have a csv file with thes two columns (amongst others): localisation and geo_point_2d. Here is the content of one cell of localisation : {"type": "MultiPolygon", "coordinates": [[[[-53....
0
votes
0answers
20 views

pgr_dijkstra ERROR: invalid memory alloc request size 1080000000

I am using pgr_version 2.6.3 I tried googling, most of the posts suggest the data is corrupted. So I tried pg_dump and select row by row to try finding the corrupted row, but did not encounter any ...
-1
votes
0answers
29 views

I got this error : elementwise comparison failed; returning scalar instead, but in the future will perform elementwise comparison [closed]

rint(sf.columns) se=float(numb1.get()) cur.execute("select distinct nassereddine_carte_gouv.c_gouv from nassereddine_carte_gouv,disshp where nassereddine_carte_gouv.c_gouv=disshp.id and Shape_leng &...
2
votes
0answers
20 views

Problem with intersects operator in Postgres

I have this table below CREATE TABLE public.geometry_polyline_volume ( id serial not null primary key, distance float not null, height float not null, coordinates ...
4
votes
1answer
41 views

Does QGIS 3.4 locks the row while editing the postgis data?

I want to know if QGIS locks the row of a postgis table for editing or can this behavior be force implemented? Suppose there is another user who wants to edit the same row-- this must not be allowed.
2
votes
1answer
32 views

Find path containing point

In Postgres with PostGIS extension, I try to figure out to find the path containing a specific point: table A contains POINT table B contains PATH My code returns 0 rows when it should select * ...
2
votes
1answer
29 views

Iterate through path type inside 'WHERE' statement

I have a table defined as following CREATE TABLE public.geometry_polyline_volume ( id serial not null primary key, distance float not null, height float not null, ...
3
votes
1answer
29 views

Drawing line to closest point within single column

I have sets of points that define a roadway segment, and can connect them with St_MakeLine, but I have no field with which to order them, so they zig-zag. Ordering by lat/long/x/y only partially helps,...
0
votes
1answer
55 views

QGIS 3.10.2 - Install PostgreSQL and PostGIS

QGIS 3.10.2 in Ubuntu 18.04. I'm having problems installing PostgreSQL and PostGIS following the instructions here: Installing PostGIS under Ubuntu. This doesn't work, 'postgresql-9.1-postgis' isn't ...
0
votes
1answer
58 views

Fetching the geometry and attributes from PostgreSQL Using FME Workbench

I have 2 fetching administrative areas one inside the other. For that, I am having servers to get the data. When I am running anyone query in SQLCreator, it is working fine separately, but while ...
1
vote
1answer
39 views

Why does my source and target repeats itself when I use pgr_createtopology()?

I created my path in QGIS v2.18.18, making the lines and a combination of cleaning tool and explode lines tool to get my desired output. I tried using ROAD GRAPH plugin in order to check whether my ...
3
votes
1answer
362 views

Mapnik + PostgreSQL + Python = Segmentation fault

I would like to render subset of OpenStreetMap features over big area into one image, no sub-tiles. System: Devuan ascii 64bit (alike Debian 9), 64GB RAM, headless (SSH only) There is what I already ...
0
votes
0answers
27 views

How to work in the form of QGIS PostgreSQL fields which is of type array[]

I have a table in a PostgreSQL / PostGIS database where there are columns of type array [] and I would like to know how to work on the QGIS form. Example: I have a column called "WALLS" and that ...
3
votes
0answers
49 views

Function to make a trajectory more straight

I'm new at PostGIS and I have to do a project for my university course. I'm trying to analyze a trajectory of points that I downloaded from my runtastic app but it's a mess. There are some points ...
1
vote
0answers
22 views

Lizmap - QGIS server - PostgreSQL error layer not valide

l installed Lizmap in Windows 10 but a problem is that I haven't the edition button and can't display layers from PostgreSQL. I have a "service non disponible" with "layer not valide" error in QGIS ...
5
votes
2answers
854 views

ogr2ogr: encoding issues when importing from Oracle Spatial to PostGIS

I'm trying to import some spatial tables from Oracle Spatial to PostGIS using ogr2ogr, but I can't figure out why the special characters on the attribute tables get messed up while I'm doing it. My ...
3
votes
1answer
2k views

Retrieve geographic coordinates from OSM imported data

We have just finished importing OSM data into our PostGIS (Postgresql) database. And we are having difficulty understanding the geometry of various shapes imported. We run a query to retrieve the ...
1
vote
0answers
39 views

Store Login Data in QGIS Project

I have a QGIS project with data from a postgresql database. For this database you need a login. If I open the QGIS project I have to enter the login data. Is there any possibility to store the login ...
2
votes
1answer
38 views

Cannot convert shapefile data to PostgreSQL/PostGIS using ogr2ogr

I am a starter to use command-line interface. I was looking for a way to import a shapefile into PostgreSQL using "ogr2ogr". I was able to do this for point shapefile using code: ogr2ogr -f "...
2
votes
1answer
29 views

Insert value in postgres with type PATH

Hello I have created a table with a column type PATH as above (following the Postgres documentation) CREATE TABLE public.geometry_polyline_volume ( id serial not null primary key, ...
1
vote
1answer
37 views

Creating a shapefile with SQL Query Using Geotools Hibernate and Java

Here is my context : 1] I have geometries in an postgresql database 2] My application uses JAVA/Hibernate 3] I Currently use Geotools to create a shapefile How I do it ? First i retrieve my ...
2
votes
1answer
36 views

Insert data in a PostgreSQL database using shp2pgsql in peer mode (without password for user postgres)?

Context I wish to add some data that are for the moment in ESRI shapefiles into a PostgreSQL database. To do so, I am using the shp2pgsql (RELEASE: 2.4.3 (r16312)) tool from an Ubuntu server (18.04 ...
3
votes
1answer
107 views

How to track progress on a route?

I want to track and visualize the progress of a bus, as follows: I have the coordinates of each station as well as the coordinates of the bus, updated every 10 seconds The information is stored in ...
0
votes
1answer
92 views

Spatial queries with PostgreSQL on AWS

I have some data in PostgreSQL which I am exporting to Amazon RDS service. Will I be able to use PostGIS extension in AWS, Also will I need the mandatory column "geom" or I could run queries with ...
-1
votes
2answers
593 views

Building CartoDB from source using updated dependencies on Ubuntu 13.10

I am attempting to build CartoDB from source on an Amazon VM for the first time in my life. For purposes of sanity, I want to use the same instance/database of postgres for both CartoDB and all of my ...
1
vote
1answer
67 views

ST_MakePoint outside PostGIS

To import data into a PostgreSQL/PostGIS database I need this CSV format: "1,nameOfPoint,0101000020E6100000689DA690152F114090338CFF9B0B4A40,2019-07-22 19:56:03.603+00,2019-07-22 19:56:04.243+00" ...
2
votes
1answer
52 views

Create PostgreSQL user for QGIS project

I have some data in a PostgreSQL database, I use pgAdmin4 for the organisation of the data. I want to create a QGIS project for other users with the data from my database. The users of the project ...
3
votes
1answer
179 views

Upgrading PostGIS and PostgreSQL but running upgrade to PostgreSQL it errors?

I want to upgrade PostGIS(2.0.4 ---> 2.2.3) and PostgreSQL (9.2.4 ----> 9.6) so First I upgrade PostGIS 1、install PostGIS 2.2.3 on postgresql 9.2.4 2、alter EXTENSION postgis 2.0.4 ---&...

1 2 3 4 5 63