Questions tagged [database]
One or more structured sets of persistent data, managed and stored as a unit and generally associated with software to update and query the data.
414
questions
0
votes
0
answers
6
views
Where to find the pg_service.cnfg file for an existing QGIS project with postgresql connection? And how to make the file if the service name is blank?
I have an existing QGIS project to work on and the layers are from a postgresql connection. I want to open this project on QField on Android but it couldn't load the layers because it requires ...
0
votes
1
answer
19
views
GeoDjango fails to load SpatiaLite, but not Jupyter?
I am trying to use SpatiaLite for a GeoDjango application on a Windows 10 machine using Anaconda, but, when I run python manage.py dbshell, I get an error "CommandError: You appear not to have ...
0
votes
0
answers
21
views
Is SRID not preserved in MySQL export/imports?
I have a database with spatial data stored as Polygons that I run queries such as ST_Intersects against. However if I export this database and import it the SRID appears to be lost, queries that ...
0
votes
0
answers
23
views
Global Flood Database v1 unmask 'jrc_perm_water'
I am using Google Earth Engine to generate mean area flooded in electoral districts of India.
What is a good way to remove the values of permanent water from the 'flooded' band and generate aggregate ...
1
vote
1
answer
59
views
PostGIS user privileges when working with QGIS projects and layers saved in a PostGIS database
I have a PostGIS database that includes multiple schemas, tables and a QGIS project. I have 3 general user roles: admin, editor and reader. I know of the issue with database connection information ...
0
votes
1
answer
28
views
Grass GIS vector seem to lost connection to database table, but in file dbln connection exists
After I imported a big vector file and table in sqlite.db was successfully created, there were some operations then I got an error:
DBMI-SQLite driver error:
Error in sqlite3_prepare():
select * from ...
0
votes
0
answers
80
views
AutoCAD Map3D New feature from geometry fails on PostGIS
I am designing a workflow for my company which would include connecting to a PostGIS database from AutoCAD Map3D. This is done via the FDO API, included in Map3D.
A key functionality I want to use is ...
0
votes
0
answers
27
views
Automatic link to database style in QGIS vanished
I have a couple of shapes in a PostgreSQL database link with QGIS. Once, I created specific styles for these layers and saved them in the PostgreSQL database as default style. Now, I loaded the ...
1
vote
1
answer
51
views
What is the right way to dissolve vector features in GRASS GIS on attribute values of one column summarizing or averaging others?
The line product of v.overlay contains a column with zones number and a stack of other attributes.
What I want:
Dissolve features (lines) on attribute column that contains zones number. Other ...
0
votes
0
answers
31
views
Exporting .LAS file after using v.lidar.correction
Question
I want to use the GRASS GIS LIDAR modules (v.lidar.edgedetection, v.lidar.growing, and v.lidar.correction) to classify points for LAS files. I'm very new to working with databases, and the ...
0
votes
0
answers
27
views
QGIS 3.28.5 problems opening SQLite DB
I´m unable to open my Database and have no clue about the problem. I have the following Python error:
Traceback (most recent call last):
File "C:\PROGRA~1/QGIS32~1.5/apps/qgis-ltr/....
4
votes
0
answers
86
views
Spatial database design [closed]
I am designing a spatial database and I wanted to ask if it is a good idea to use inheritance to store objects that share certain attributes, but whose geometry differs since some are points, lines ...
1
vote
0
answers
88
views
Updating existing PostgreSQL database with OSM data
I currently work on the project which is directly working with the geo data of the country where I live. The database we have is quite huge, containing not only the geo data but also some other stuff. ...
0
votes
1
answer
144
views
Create multiple rasters in PostGIS from a (xyz) table
I'm having a hard time understanding how PostGIS works in terms of raster creation. Let's say I have a table with 14 columns: the first two are x and y coordinates followed by the air temperature for ...
0
votes
1
answer
47
views
Is my install really missing Spatial Functions in DB2 Spatial Extender?
I'm running a number of Spatial Functions in DB2 (11.5 LUW) and getting back errors such as:
SQL Error [42884]: No authorized routine named "ST_ENDPOINT" of type "FUNCTION" having ...