Questions tagged [postgresql]

PostgreSQL is an open source object-relational database system.

666 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
117 views

Using NetCDF file in PostgreSQL database?

I have a NetCDF file which is 25 by 20 grids by latitude and longitude and contains hourly rainfall data at each grid. In total I have 780 hours worth of data. I was trying to use ArcGIS to create a ...
0
votes
0answers
68 views

Connect QGIS to Remote PostgreSQL Server

I am trying to connect to my database on a remote server using QGIS. From what I've read I have to edit the pg_hba.conf and the postgresql.conf files. I think I have edited these files to allow any IP ...
0
votes
0answers
41 views

Extremely slow Nominatim install with Docker

I am trying to install Nominatim based off of a dockerized version of the tool found here: https://github.com/mediagis/nominatim-docker. I was successful with installing dockerised Nominatim with a ...
0
votes
0answers
52 views

RAISE NOTICE from trigger to QGIS

I work on vue postgresql made with table, so for save I have to use trigger. My trigger do a lot of thing and I have to send message to the user to make him understand what happend. But QGIS ...
0
votes
0answers
28 views

Problem with osm2pgsql

I'm having a problem importing a .pbf file in PostgreSQL using the osm2pgsql. I've downloaded the italy-latest.osm.pbf and as I do every year I'm going to upload it in PostgreSQL. I did it for other ...
0
votes
0answers
44 views

Using PHP on Webservers and PostgreSQL

I'm creating a general webapp that is displaying data from a Postgres database hosted on Digital Ocean. My problem is that I can't get the PHP script to run on my webserver(hosted by Hostgator) to ...
0
votes
0answers
22 views

CartoView Error

I've installed CartoView on Windows 7 by default instruction. I've changed Postgres to my own DB (It was problem with default DB from install package). CartoView doesn't start with this error: I ...
0
votes
0answers
45 views

QGIS + PostgreSQL - file that works on one PC will not work on another

I have QGIS on 2 different standalone PC and I share/sync files between them. I now need my second PC QGIS to work with a file that includes PostgreSQL queries. PC 1 is original PC and all is well ...
0
votes
0answers
78 views

How to load OSM data to RDS instance (PostgreSQL) on AWS

I am trying to load the OSM data to PostgreSQL (RDS on AWS). I could not find any information on loading the OSM data to cloud. I tried the steps outlined in many website and osm2pgsql but nothing ...
0
votes
0answers
87 views

geometry point and varchar multicolumn index in PostgreSQL

Is it possible to create a multicolumn index on a geometry point column and a varchar column? For example, say I have a geometry point column called "location_point" and a varchar column called "zip". ...
0
votes
0answers
120 views

renderd: “rendering failed with command 4, pausing.” when rendering tiles but no error in syslog

I just had to rebuild my server and I'm having an issue when trying to pre-render my tiles. I'm getting a lot of "rendering failed with command 4, pausing." I am getting tiles (so renderd is running) ...
0
votes
0answers
34 views

pgpointcloud repackaging point or x, y, z geometries to patch

I have a pointcloud in PostgreSQL/postgis imported via PDAL, everything is fine, I chipped it into groups of 600 points, no problems. I then manipulated the data, first exploding the patches and ...
0
votes
0answers
40 views

Not able to import LAS file into PostGIS from PDAL with filter

I'm not able to import LAS file into PostGIS from PDAL with filters. There is no error message from PDAL, and couldn't find any relevant errors in PostgreSQL log files, except these errors: 2019-09-...
0
votes
1answer
141 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 ...
0
votes
0answers
410 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
80 views

Error in installing PostGIS extension through PostgreSQL 11

I am getting following issues while installing PostGIS extension.
0
votes
0answers
89 views

PostGIS DLLs could not be loaded but they are there

I've got DLL loading error when trying to restore dump files. I'm on PostgreSQL 11.5 (64bit, of course) and last time I checked all DLLs it claimed are exactly there already. ERROR: could not load ...
0
votes
0answers
36 views

Getting node way relationship from Osm2pgsql data

I would like to ask what is the best way to extract which way a node belongs to given a Postgresql databased generated by Osm2pgsql. For example, in https://www.openstreetmap.org/node/4961890042, ...
0
votes
0answers
33 views

Can't add layers to new PostgreSQL database

I made a new PostgreSQL database and am trying to add layers/tables to it in QGIS using the DBManager. And I am failing. Here is the error message I'm getting: However, I can add layers to other ...
0
votes
0answers
54 views

Find a point in a polygon shape

I have a table that contains a column polygon shape. I need a query that I Want to pass a point(coordinates) if point contains in a polygon_shape of an instance the match will be returns . select * ...
0
votes
0answers
67 views

Connect to Enterprise GDB in PostgreSQL using QGIS : “No Geometry” Error

I have an esri Enterprise Geodatabase (9.3) stored in MSSql 2008 with storage type as sde binary. I upgraded it to EGDB 10.4.1 (using multiple up-gradation steps) in MSSql 2012. Then I copy/paste my ...
0
votes
1answer
26 views

Using features of CARTO Builder to dynamically calculate the average of selected columns

I am trying to find a simple way to calculate the average of selected columns (avg per row) dynamically in CARTO, using only the pre implemented features of CARTO Builder so that it is as user-...
0
votes
0answers
95 views

PostGIS Out-DB Rasters - Segmentation Fault

I am loading data from a NETCDF file with raster2pgsql, which I would like to keep as an out-DB raster. The command I use is (note the -R option): raster2pgsql -s 96482 -I -d -F -R NETCDF:"/home/...
0
votes
0answers
54 views

Transfer indexed Oracle geoloc table to PostgreSQL using ogr2ogr

I am copying tables using ogr2ogr from Oracle to PostGIS using ogr2ogr -f "PostgreSQL" PG:"host=<host> port=5432 user=<user> dbname=<dbname> password=<pwd>" OCI:<USERNAME&...
0
votes
0answers
118 views

Optimal way to find points within polygon in PostGIS

I've developed an query to find points which are completely falls inside polygon by using PostgreSQL 10 and PostGIS 2.4 database. The query took long time (aprx 90mins) to produce the result. The ...
0
votes
0answers
28 views

Split line layer by another line layer

I have two line layers . One is the stream network (dissolved) and other is the point layer converted to line layer by converting each point into short line segments. I am using "Split by lines" tool ...
0
votes
0answers
68 views

Merging Degree Two nodes in Stream Network using QGIS 3.4

I have a stream network and I want to convert it in graph like data structure, for which I need to have precise set of FROM and TO vertices.The geometry of stream network is not correct i.e. the ...
0
votes
0answers
82 views

GeoServer could not show the layer by SLD style

I am trying to show simple classification of semi real-time data by using PostgreSQL v.1.20, QGIS 3.4, and GeoServer 2.15.1 The idea is symbolized the field of 'Statusparkir' in table parkir_conn. ...
0
votes
0answers
34 views

Does ST_GeomFromText find exact matches for provided string or it finds similar, but not 100% same string?

SELECT * FROM centroids WHERE centroid = ST_GeomFromText('POINT (21.6198205 41.9418615)', 4326); Record have centroid geometry equal to POINT (21.619820510769063 41.94186153740355) Running on ...
0
votes
0answers
81 views

Perform Multiple Point in Polygon Queries PostGIS

I was wondering if there was a way to send one request to a PostgreSQL server with the PostGIS extension that contained multiple points, and then find the polygons that they are located in. For ...
0
votes
1answer
585 views

Django demands to set default. ValueError: String input unrecognized as WKT EWKT, and HEXEWKB

when I try to makemigrate models with Geometry fields to postgres DB I face with next message: You are trying to change the nullable field 'geom' on allotment to non-nullable without a default; we ...
0
votes
0answers
264 views

ArcGIS Pro connection to PostgreSQL Database

I am connecting a PostgreSQL database to ArcGIS Pro and it connects but when I attempt to open the attribute table I receive a "Shape Integrity Error" and cannot view it. I am able to view the ...
0
votes
0answers
71 views

How do I create a view across a server using postgres_fdw?

My understanding is that you can query across servers if you use postgres_fdw. I have set this connection up successfully following the official documentation. However, I am struggling to construct ...
0
votes
1answer
23 views

Geometry from Record use in Function

I have a function I am creating for some iterative task I need to do but I cannot get the geometry coming out of a record data type into the execute properly: DO $$ DECLARE records record; images ...
0
votes
0answers
50 views

Feature templates do not change when using LYR file and PostgreSQL?

We just started migrating from SQL Server to a PostgreSQL Server for production. Traditionally, we load a LYR file containing all of our symbology, then point it to our new GDB on the SQL Server. If ...
0
votes
0answers
64 views

Mark Dangle Error for linestring

I will create buffer for 5 meter in start point of line string, If any other line string is within the buffer but not snapped then to mark as the startpoint as dangle error.I have attached the sample ...
0
votes
0answers
34 views

How to handle Update error: Transaction does not have authorization for mytable3:mytable3.5?

I am building collaborative mapping app using openlayers 5.3.0, geoserver 2.14.0 and postgresql 10.4. I want the user to be able to update features using wfs-t but before updating, the user needs to ...
0
votes
0answers
295 views

GeoAlchemy2: Cannot insert row because Function st_geomfromewkt(unknown) “does not exist”

i've been stuck on this problem for quite a while now and I can't figure out what could be the issue here. I have a Postgres DB with postgis extension installed CREATE EXTENSION IF NOT EXISTS ...
0
votes
0answers
193 views

Filter Nominatim data by Class or Type

Is it possible to prevent certain results based on "class" and/or "types"? For example, I do not want any results that have the following class or types: class: natural, highway type: peak, footway, ...
0
votes
1answer
65 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 ...
0
votes
1answer
173 views

PostGIS geocoding with local street centerline data

I have the PostGIS TIGER geocoder setup and working to geocode addresses in a single city. I am trying to use local street centerline data for geocoding instead of the TIGER data because it is more ...
0
votes
1answer
968 views

Getting OGR to work on a Mac

I downloaded GDAL on my Mac (running Mojave 10.14.1) through Homebrew and I'm having trouble getting OGR to work with Postgresql. When I try the following to create a geojson from gpx files I have, I ...
0
votes
0answers
232 views

How do you change the value of a Boolean column in a QGIS 3 Attribute Table?

I am editing feature in a PostgreSQL table in QGIS 3 and while I can edit the values in most columns, I cannot edit the Boolean value. I can enter the cell in edit mode, but keystrokes don't work. I'...
0
votes
0answers
295 views

ArcGIS vs QGIS vs PostGIS projection issue

Windows 10, ArcGIS Pro, QGIS 2.18, pgAdmin 4-postgreSQL I have two (sample area) PostGIS tables in a PostgreSQL database: building_polys (SRID: 27700) -OS MastermapTopo address_points (SRID: 4258) -...
0
votes
1answer
526 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 ...
0
votes
1answer
327 views

Uploading shapefile to PostGIS database using PHP

I want to insert a shapefile into a PostGIS database using PHP. I go through the examples and I tried the following: $command = 'shp2pgsql -s 2100 -d /D:\CHECK DATA-group\2016\Ayomi\JULY\...
0
votes
0answers
363 views

Can't upgrade PostGIS on Ubuntu with Postgres 10?

I am running Postgres 10.5 (I think) on Ubuntu 14.04. I want to upgrade to PostGIS 2.2+ so I can use ST_Subdivide. I've done: apt install postgresql-10-postgis-2.4 But when I try to upgrade PostGIS ...
0
votes
0answers
135 views

ogr2ogr merge fgdb (while importing to PostGIS)

I have millions of records and hundreds of tables in several file geodatabases.. The tables name in these FGDBs are all same but just in different areas. For instance, the Admin table, you see below,...
0
votes
1answer
487 views

PostgreSQL Query which returns geom column as WKT set in function

Given: We are accessing a PostgreSQL DB from a VB NET application. When the query completes the DB rows are delivered in a VB NET DataTable. The Postgre DB geom column is in the format of System.Bytes[...
0
votes
2answers
315 views

PostGIS: Change raster values depending on values from other raster

I have two rasters and I want to change all the values from "raster1" to 4, where they are larger than the values from "raster2" and to 0, where they are smaller. So raster2 has only one value, which ...