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.
465 questions
0
votes
0
answers
34
views
Collect the spatial data used in an MXD file and haven't been saved in the same folder
So, I created several MXD files a long time ago, with spatial data and other reports/photos etc. inside but didn't save it all in the same folder in my computer. Now, a few days have gone by and I ...
- 1
3
votes
1
answer
480
views
Saving layer styles to database using QGIS
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.qmldb ...
- 375
0
votes
1
answer
1k
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
252
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
802
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 ...
- 153
0
votes
1
answer
96
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.
...
- 141
0
votes
2
answers
496
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
813
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
2k
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 ...
- 305
5
votes
1
answer
930
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
468
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
75
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
664
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
81
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,257
0
votes
0
answers
67
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 ...
- 91
4
votes
1
answer
2k
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
0
votes
1
answer
96
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,257
2
votes
0
answers
1k
views
QGIS Set Master Password
I installed a fresh version of the QGIS LTR 3.10. I am working on creating a postgres server from a raspberry pi4 and connecting the database to my qgis. Through a tutorial I am walking through, they ...
- 1,456
0
votes
0
answers
307
views
Spatial indexing of GeoTIFF images (Java Library)
I have a requirement to spatially index each pixel of GeoTIFF images and store them in a scalable database. I intend to perform this in the following manner.
Divide each GeoTIFF into smaller tile ...
- 151
1
vote
1
answer
234
views
GIS Database format functional differences [closed]
We are a small team (10 p) working on spatial planning. We are using QGIS as a main tool.
We have a lot of open source data, we daily use on multiple projects, and therefore some files are duplicated ...
- 863
-1
votes
1
answer
1k
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 ...
- 340
0
votes
0
answers
148
views
Maintaining Form Designs with one Geopackage to Multiple Different Projects
I work for an Archaeological consulting company in Australia and one of the major parts of our job is to go out and survey for aboriginal heritage sites before constructions can be approved. The ...
0
votes
0
answers
266
views
Sharing QGIS Project that connects to local postGIS database
I am looking to share a QGIS project with a few others outside my network. The QGIS project is using layers from a postGIS database I created locally. I am wondering what the best way is to go about ...
- 51
1
vote
1
answer
52
views
Converting points with an associated circumference to a raster overlay
I have a data frame in r with x and y coordinates and each point has a circumference (tree_crown) around it. I'm wanting to build a raster file that each cell would have a value equal to the percent ...
- 21
3
votes
1
answer
1k
views
Creating one-to-one relationships in QGIS
Can I create one-to-one relationship using project relations in QGIS?
I am trying to create a spatial database in QGIS. I want to link my attribute data to my spatial data (shapefile). I have already ...
- 115
0
votes
0
answers
416
views
Linking or joining data in MS Acess to shapefiles in QGIS
I am creating a spatial database for five buildings for a project that I am working on. I have spatial data in the form of a shapefile and attribute data in Microsoft Access(with a table and queries). ...
- 115
0
votes
1
answer
564
views
Problem with CLOB data type when running ogr2ogr command
Using ogr2ogr, I transferred data from the Oracle database to the PostgreSQL database. However, the table "table" contains attributes that have a "clob" as a data type, which were ...
0
votes
1
answer
735
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 ...
- 374
2
votes
1
answer
414
views
Two persons working on same layer in QGIS [closed]
We are two people who need to edit on the same layer in QGIS. For example one of us will edit locally, the other one via a server connection.
- 39
2
votes
1
answer
1k
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 ...
- 339
1
vote
1
answer
93
views
Exracting data fromSpatialPolygonDataFrame conditionally in R?
For some research I am working on, I have a dataframe called charters of charter schools in New Jersey. Simplified it looks like this:
school.name school.id district.id lat ...
- 13
1
vote
1
answer
151
views
Store and observe changes of polygons through time?
What approach should be used to have the ability to store and observe changes of polygons?
For example if you have an area where many parcels of land have changed owners and dimensions (larger/...
- 13
-2
votes
1
answer
153
views
Local coordinates in NoSql database
Is there any nosql database which supports the below
1) Should support local coordinates (spatial data which holds the coordinatesof door, Infra, etc.)
2)Integration with Geoserver.
- 143
1
vote
1
answer
136
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
...
2
votes
1
answer
66
views
Find gaps in spatial database based on attributes and fill those caps with new features with existing attributes
I have a big line shapefile data (over 2 millions features) showing animal movements.
Simplified example:
ID Year st_time end_time&...
- 154
4
votes
2
answers
4k
views
Visualize geographic spatial data from SQL Server directly in PowerBI
Is it possible to directly query geographic spatial data form SQL Server in PowerBI like its possible with Tableau?
https://cloudblogs.microsoft.com/sqlserver/2018/05/14/visualize-geographic-spatial-...
- 43
0
votes
1
answer
726
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 this ...
2
votes
0
answers
2k
views
DBeaver spatial output window: Is it possible to sync/filter spatial query to map bounds?
While upgrading PostGRES/PostGIS from 9.x to 11.x, I have discovered DBeaver and so far I am pleased.
Apparently it has some spatial integration, including the ability to visualize spatial data ...
- 6,524
2
votes
0
answers
638
views
Can relation reference in QGIS and QField be used to fill stochastic matrices?
I am a novice GIS user and am just seeing the potential for relations in my work. A problem I've come across and would like a solution to it.
I have two stochastic matrices (risk matrices) that ...
- 126
0
votes
1
answer
85
views
SQL layer wont ORDER BY in CARTO VL
I have a dataset that shows the borehole yield for fractured aquifers in South Africa. Using the "yield_ls" column, my CARTO VL legend looks like this (notice how the 4th item should be the first).
...
- 515
0
votes
2
answers
761
views
Clarification on Oracle sdo_gtype
I need some clarification on oracle sdo_gtype 4402. I understand that sdo_gtype is coded as DLTT:
D: Dimension
L: linear reference
TT: TT identifies the geometry type
It's clear to me that first 4 ...
- 1
4
votes
1
answer
557
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 ...
- 427
3
votes
2
answers
3k
views
GeoDjango application using SpatiaLite database
I want to create a simple GeoDjango app with SpatiaLite database but I have this error at migrate:
django.core.exceptions.ImproperlyConfigured: Unable to load the
SpatiaLite library extensio`.
...
- 1,061
0
votes
1
answer
125
views
Extracting and transposing a single record in db manager
This seems like a simple operation so apologies if I've missed an existing answer.
What I need to do is extract single record (a client) from a database of clients (in Spatialite) and present the ...
user39790
1
vote
0
answers
371
views
What's the most size-efficient spatial database [closed]
I'm configuring a tile server on Apache Mesos. From all the tutorials I've read, I gathered that PostgreSQL and PostGIS is widely used for this purpose.
I learned that MongoDb and MySQL Server also ...
2
votes
2
answers
997
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 ...
- 359
3
votes
2
answers
6k
views
Using SqlGeometry.MakeValid to get a counter-clockwise polygon in SQL Server
The data I've loaded from a shapefile into a geometry column in SQL Server (using NetTopologySuite) is not producing valid GeoJSON when I export it because it doesn't follow the right-hand rule.
I ...
- 161
6
votes
0
answers
4k
views
When does WKT orientation matter for polygon and multipolygon in geography spatial (left/right hand rule, counter-clockwise, clockwise)
I've decide to use sql server on Azure for my gis database.
I'll be dealing with spatial Geography not Geometry.
While inserting some country boundaries using the spatial data in SQL Server, some ...
- 221
2
votes
1
answer
936
views
How to extract values from multiple rasters and polygons for given coordinates
I have roughly 30 predictor variables in raster and two polygon shapefiles format that I am trying to extract values from for a given response variable coordinates.
I have already done the following:...
- 425
0
votes
2
answers
936
views
Copying raster to SQLite using GDAL?
I want to copy a raster file into SQLite database. Previously, I did the same with vector data like this:
def store_vector_output(self, file_name, identifier):
from osgeo import ogr
drv = ogr....
- 768