Questions tagged [spatial-database]
Spatial database is a database that is optimized to store and query data that is related to objects in space, including points, lines and polygons.
464
questions
1
vote
1
answer
86
views
Save Layer Styles to a Database
I would like to save my layer styles to a database and the "only" option given is "As Default in Local Database". After some searching, I see the local database is named qgis....
- 191
0
votes
1
answer
603
views
Extract nearest values from NetCDF file in Python
I have a NetCDF database (link to file) obtained from Copernicus Climate Data of ~43k unevenly spaced values around the world. Instead of being indexed using (lat, lon) it uses a sequence of 'stations'...
- 65
1
vote
0
answers
99
views
Connecting QGIS to SQL server -- not showing sde
I have problem with seeing/making connection to spatial data on SQL Server with QGIS while I can normally see it (on the same SQL Server) with ArcMap.
I should use the same user and password for both ...
- 11
1
vote
0
answers
436
views
Best way to work with large vector data files [closed]
I am about to start making 50+ maps for my next book project. The last 2 books were a struggle with the huge amount of Ontario, Canada vector data to make my basemaps.
These were large files from the ...
- 143
0
votes
1
answer
65
views
tmap + labels colors don't match the data
I created the following map. However, the labels in the legend don't match the data. I don't understand what goes wrong. I expected the pal colors to be ordered with the labels. So would do the data.
...
- 41
0
votes
2
answers
394
views
Plot polygon's attribute on R
I have created a settlement plan on ArcGIS Pro, on which every polygon corresponds to a specific room in the settlement. All the polygons/rooms have some features (E.g. Fire Place, Bench etc.). I have ...
- 39
0
votes
0
answers
617
views
Spatial indexes with RTree for polygons
I am trying to understand about how R-tree works for polygon data. In other words, polygon is a list of vertices (points), however, I am wondering how spatial index can recognize the order of points ...
- 1
3
votes
2
answers
1k
views
How to use a list with spatial dataframes in a for loop? - R
I have three spatial dataframes (polygons), created via this tutorial. The three spatial dataframes must be exported as shapefiles via a for loop. I created a list polygons containing the three ...
- 175
5
votes
1
answer
694
views
Adding Timestamp to attribute table in QGIS
I have the project where, in one part of it, I need to add the timestamp to uniform generated points along the line (road, in my project). There is a road and uniform distributed points on it, which ...
- 349
1
vote
2
answers
336
views
Create one PostGIS connection in QGIS with multiple databases from one host?
I have a number of spatial databases each containing multiple schemas on one server,
I want to use QGIS to examine layers,
Is it possible to create one PostGIS connection in QGIS and add all databases ...
- 11
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 ...
1
vote
0
answers
576
views
QGIS is not displaying geometry features for MySQL table
I'm currently working in a MySQL database version 5.7. I've a polygon table that was created using the following way:
CREATE TABLE coords(
ref_geo CHAR(80) NOT NULL,
geom GEOMETRY NOT NULL
);
I ...
4
votes
1
answer
69
views
Appending characters before the filename of all layers in a GeoPackage in QGIS?
I have a geopackage which contains around 30 files. I want to put a "mmbl_" before the actual file name for all the layers in the said geopackage. Is there a an SQL expression to automate ...
- 1,217
0
votes
0
answers
50
views
What geospatial table and indexing functions are suitable for a borehole database design for large volume of serialised constant increment data?
Pretty common use case I suspect, but want to make sure I optimise from the get go. PostGIS I'm suspecting is the weapon of choice, and one way I'll be interrogating data is QGIS. Large part of data ...
- 81
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 ...
- 41