All Questions
Tagged with postgresql spatial-database
57
questions
0
votes
0
answers
66
views
Transferring/inheriting GIS database structure in PostGIS from old project to new one
I have been given an existing GIS database design for a solar power project, with its structure, relationships, geometry etc designed from another project and existing in PostGIS database. I am ...
4
votes
1
answer
1k
views
How to open QGIS project without being asked for PostGIS credentials every time
Problem:
We have several layers stored in a PostgreSQL database with PostGIS extension (Stored on AWS RDS Instance). The connection has been working perfectly to date.
I get asked for login ...
0
votes
1
answer
78
views
I just imported some shapefiles to a PostGIS database, where can I find the files in my drive?
When I installed PostGIS, the default directory for all data is C:\Program Files\PostgreSQL\13\data but I can't find any folder that seems to be related to the database (named 'discover') that I made.
-1
votes
1
answer
858
views
How can I insert a satellite image with multiple bands into PostGIS?
I am trying to insert a satellite image (e.g. a Sentinel Image) into PostGIS. What is the best structure to save the different bands?
I know that you can use somehow use 'ST_AddBand' or 'ST_Band', but ...
0
votes
1
answer
483
views
Problem with CLOB data type when running ogr2ogr command
Using ogr2ogr, I transferred data from the oracle database to the postgres database. However, the table "table" contains attributes that have a "clob" as a data type, which were ...
0
votes
1
answer
646
views
Import OS Mastermap to PostgreSQL database
I have ordnance survey master map a coverage for the whole of the UK. These are currently received on a disk every 3 months and arrive in .gz format.
Does anyone have any recommendations on how to ...
2
votes
1
answer
536
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 ...
1
vote
1
answer
116
views
Find every possible user to user travel time duration using pgr_dijkstra or pgr_kDijkstra
I have this below GetNearest function that will get every user's nearest node from ways (imported using osm2pgrouting).
CREATE or REPLACE FUNCTION GetNearest(NUMERIC, NUMERIC)
RETURNS BIGINT AS
...
0
votes
1
answer
633
views
password authentication failed for user "ASUS"
I'm creating table in PostgreSQL using these commands:
shp2pgsql -s 32632 watershed.shp watershed > watershed.sql
psql -f watershed.sql cambridge
psql -f watershed.sql cambridge
But I had ...
4
votes
1
answer
525
views
Accessing PostGIS data in QGIS?
I've created a two new PostgreSQL users; one that is supposed to have read-only privileges and another one that should have most privileges (admin-user). When I connect/log in to the new users in QGIS ...
2
votes
2
answers
899
views
PostgreSQL - only allow points to be added to the table (no polygons or lines)
I want to know if there is a way to only allow certain Geometry types to be added to a table in PostgreSQL.
I have a tool that currently allows points, lines and polygons but would like to restrict ...
1
vote
1
answer
1k
views
Nearest point on line from a point in PostGIS and its attribute value
Consider the following image;
I have points (shown in blue circles) stored in my database with their geometry and an attribute value. Additionally, I have another table with User Points (yellow ...
3
votes
1
answer
607
views
Optimize intersection of polygons
I need to get the intersection of two polygons and both sides use the same dataset (titlenumberpolygon - UK National polygons). PostGIS is used in the analysis.
First a spatial index was created ...
1
vote
1
answer
818
views
Skipping projection errors in PostGIS
I have a PostGIS query that throws an error somewhere down the line:
SELECT ST_Disjoint(ST_Transform(location, 26910),ST_Buffer(ST_Transform(ST_SetSRID(ST_MakePoint(-121.3991535, 37.7458),4326), ...
-1
votes
1
answer
663
views
ST_Covers returning false with PostgreSQL/PostGIS
I have two lon/lats that I've turned into geometry. I've tried having the column type being both text and geometry. I have a fence_geom and a user_geom. I am looking to test to see if the user is ...