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.
379
questions
-1
votes
0answers
24 views
What are my best options for storing land parcel's and building polygons? [closed]
I'm developing a REST API that is required to store and and return some GIS data, namely small land parcels and building polygons.
I'm needing some recommendations on where and how to best store the ...
0
votes
0answers
31 views
Do I need a database for generating WFS-T with QGIS-Server?
I have hard difficulties in understanding: I have a QGIS-Project (in QGIS) and I want to create a WFS-T by using QGIS-Server (and the QGIS-Server I have is connected with e.g. Windows-Server).
Is the ...
0
votes
0answers
28 views
Request Error QGIS Server 3.12.3
When I request
http://10.48.242.187/cgi-bin/qgis_mapserv.fcgi?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetCapabilities&MAP=/var/www/html/S5/qgis/Erhaltungsprogramm.qgz
I get always an error ...
0
votes
2answers
29 views
PostgreSQL database designer that supports PostGIS geometry data types
Does anyone know if there are PostgreSQL database modeling software or apps that support PostGIS geometry data types? I know pgModeler is supposed to but I have been unable to get this installed.
0
votes
0answers
18 views
Spatial SQLite created with ArcMap
I created a spatial SQLite database using ArcMap and I'm trying include a new point in my table (tbl_furos_coordenadas), by SQL, but I'm not having success with this... My table created below:
CREATE ...
0
votes
0answers
14 views
OBDC Error While Exectuing the Query #7 - Importing PostgreSQL table into MS Access
Trying to import a table from PostgreSQL to MS Access (2007) however, I keep getting the error
OBDC Call Failed - Error While Executing the Query #7
STEPS TAKEN
In OBDC Data Source Admin (32-bit)...
2
votes
1answer
48 views
psql changing comma to decimal for importing CSV file
I try to import a CSV file into a PostgreSQL database that runs on a remote server.
I use psql via SSH.
AIS_DB=# CREATE TABLE bet_srk_2008 (
AIS_DB(# Unique_VesselTraject numeric,
AIS_DB(# ...
0
votes
0answers
34 views
Connect a Python script to a database
I need to run a script tool from ArcCatalog. It needs to access a feature class in an ArcSDE database so I can link the script to the layer as a source layer. I have connected the folder the script's ...
0
votes
0answers
90 views
Many to many relationship in a QGIS Geopackage - fail
The current user manual has been unsuccessful in directing me to establish a many to many db relationship in a geopackage in QGIS (3.10.2 on Ubuntu w gdal 2x).
After the airlines in the manual ...
0
votes
1answer
75 views
Transfer & maintain a relational database in QGIS - backend vs frontend [closed]
I'm going to set up a small db for my own use in QGIS. I can see only a few of the many tables will be spatial, but the ease of use and capacity of the widgets in QGIS are attractive. I won't writing (...
1
vote
0answers
55 views
Spatial similarity between polygons
I am using PostGIS and python3. I have a table with polygons objects, the polygons have year as an attribute. I need to identify the uniqueness of the polygons trough time. For instance I need to ...
1
vote
0answers
29 views
Tenant isolation in SaaS product based on PostGIS - do the same concepts as PostgreSQL apply?
We're working on two different GIS apps and we're a bit torn around how to provide a level of tenant data isolation on our GIS systems.
System A would need to have strong tenant data isolation where ...
0
votes
0answers
13 views
Database Population in wrong Authentication Type
I've populated a database while connected to it as an editor with an Operating System Authentication Type. I should have populated it while connected to the Database as the GIS administrator with a ...
1
vote
2answers
46 views
QGIS style to DB
I want to import the style from a MapInfo.tab file into a postgis db.
When I open the properties for the file and click on the botton style I only have the option save as QGIS QML style file or SLD ...
1
vote
1answer
167 views
How to find closest point on a line from a point in Oracle Spatial?
I want to find the nearest point on a line from a point in Oracle Spatial. I know how to do in SQL Server and PostgreSQL but could not find anything about Oracle.
I have used MDSYS.sdo_nn to find the ...
1
vote
0answers
51 views
Select characters using regular expression in QGIS
I'm trying to seperate characters from database to seperate fields. Database is like:
999-10-1-1
999-10-11-111
999-10-111-1111
999-10-22-1
999-10-1111-2221
and I want something like in seperate ...
1
vote
1answer
44 views
QGIS - Execute SQL Failure
I've written an SQL query which works in the query section of the QGIS DB Manager.
SELECT Max(S_order), SegmentID, S_Order, Length, Buff_Segme, Buff_Order, Buff_Lengt, Buff_Uniqu
FROM "...
-2
votes
1answer
92 views
Practices with database in QGIS [closed]
I would like to store some specifics data (customer information, etc.) into my QGIS project. The aim is to be able to automaticly use these data later when I make some exports. Some of these data are ...
1
vote
0answers
72 views
postgisQueryBuilder in QGIS can't connect to PostgreSQL DB - QPSQL driver not loaded
PostgreSQL is installed properly and I can work with my DB very well. My databases show up as connected inside the QGIS browser window. I think the appropriate packages are installed:
# rpm -qa post* ...
3
votes
1answer
36 views
Windows QGIS PostGIS connection to Ubuntu PostgreSQL database
I have QGIS software in my Windows system and I want to make PostGIS connection to a database present in Ubuntu system, both are in same network(LAN). How can I do that?
0
votes
0answers
47 views
osm2pgsql: does table planet_osm_roads contain any non-duplicate data?
Although there is a osm wiki page that attempts to shed light on the different tables which are created within a postgres/postgis database there is something that is not quite made clear:
Is the data ...
1
vote
0answers
21 views
n:m relations of lines including directions
For trail planning and route signalization projects, I am looking for a solutions which allows me to connect "physical" trail segments (available as .gdb from authorities) with overlaying routes, ...
1
vote
1answer
39 views
Making one to many to many Attribute Relationships
I am making relationship between three tables in QGIS 3.8 version ("ACTIVE SITE","FUEL_TANK","REFUEL").
The primary key and the foreign key for the Tables are as follow
the primary keys are "ACTIVE ...
1
vote
1answer
214 views
Understanding NOAA/GFS0P25 dataset of Google Earth Engine
I'm trying to get time-series data from NOAA/GFS0P25 data set on GEE.
My code:
var m2 = "NOAA/GFS0P25"
var band1 = 'total_precipitation_surface'
var data_collection = ee.ImageCollection(m2);
var ...
0
votes
1answer
180 views
Create different Server Database Connection file for ArcGIS Server
I would like to register database with ArcGIS Server. I know it is done through ArcGIS Server Manager under Site / Data Stores / Register: Database.
I am also aware there can be different connection ...
0
votes
0answers
109 views
Connecting QGIS 3.4 to a MS Access database
I try to connect to MS Access and i have already created an ODBC connection.
Now, I have the the problem that I cannot open the database in QGIS (but the connection was succesful).
0
votes
0answers
58 views
Import multiple PostGIS layers in QGIS map canvas via QTask QGIS 3
The vertex tool in red and the geometry displayed by the layer in yellow are not in sync
from time import sleep
from qgis.PyQt.QtSql import QSqlQuery, QSqlDatabase
serverName = 'hostname'
database = '...
0
votes
0answers
16 views
Load .osm changefile to my local database
I've successfully created a local tileserver on Ubuntu 18.04, now I need to edit the map I've uploaded on database.
I created my own .osc change file from openstreetmap editor's iD and I need to put ...
1
vote
0answers
91 views
PostGIS: proper way to model object that follows sections of another object's path?
First, apologies if this has been asked before. I don't really know how/what to search for, and am struggling to just put this question into words.
I'm trying to model aerial utilities in a PostGIS ...
1
vote
0answers
35 views
Storing earth observation derived attributes for polygons [closed]
I want to generate a number of vegetation related indices (NDVI, NDTI, etc., min/max/avg/std (pixel values)) from earth observation data for a large number of polygons during the entire growing season,...
1
vote
0answers
51 views
QGIS 3.6 - Updating layers from changing excel spreadsheet
I am building/editing a table and utilising Excel as the vehicle.
When I change the spreadsheet I need to produce a new csv file and then re-import to generate new layers.
Handling Excel spreadsheet ...
2
votes
2answers
92 views
Delete several tables in QGIS DB manager
I have a lot of tables in a PostGIS-Database and I want to delete most of them. In the QGIS DB manager, I am able to delete one by one (right-click - delete). However, that's quite annoying. How to ...
1
vote
1answer
189 views
How to make query of MySQL connection in QGIS?
i have added a connection with a MySQL database in QGIS
(Add vector layer - Database - MySQL).
Is there an option to make a query over the database in QGIS?
0
votes
1answer
38 views
ArcGIS attribute tables exploitation
I have kind of the same question as "greyline" : How to implement 3NF (third normal form) in ArcGIS attribute tables?
I need, among other things, to place foreign key in my tables to combine them and ...
1
vote
0answers
53 views
Creating QGIS Symbology Database?
I'm looking to swap from MapInfo to QGIS at my work and im trying to see if its possbile to have a centralised symbology database. eg to be able to pull our symbology from a database rather than from ...
-1
votes
1answer
53 views
Why the replace function in PostgreSQL is not returning the value?
I am trying to convert state names to abbreviations and I am using the replace function. I am able to run the snippet successfully but names remain the same without being converted to abbreviation:
...
1
vote
1answer
196 views
Exporting data to a text file using a template
I've build a toolbox in my project environment to plan "Aids to Navigation".
The vessel (ship) that does the actual work in the field has a navigation computer that can only import waypoint.
These ...
2
votes
2answers
85 views
write z-value from polygon layer to point layer in QGIS
I have two layers:
1 polygon layer where the depth of an area is written in the database (as DRVAL1) and and where the depth is exported as a Z-value to the geometry.
1 point layer that I use to plan ...
1
vote
0answers
62 views
Synchronisation problems using QFieldSync
When resynchronizing data from QField GPKG project to QGis SHP project, using QFieldSync, attribute data are shifted to the right column. There is a lag, I have never seen something like that before.
...
1
vote
1answer
110 views
Which provider should I use with `qgis.core.QgsVectorLayer` method at `PostgreSQL database with PostGIS extension` storage?
I use PyQGIS 3.6.1 Noosa to load layer from my database storage PostgreSQL database with PostGIS extension using qgis.core.QgsVectorLayer method. But layer is invalid somehow. Performing same ...
1
vote
1answer
125 views
Default expression won't write to database
Made this expression and put it in the defaults value box.:
CASE
---cardinal
WHEN ("CATCAM" = '1')THEN'2,6'
WHEN ("CATCAM" = '2')THEN'2,6,2'
WHEN ("CATCAM" = '3')THEN'6,2'
WHEN ("CATCAM" = '4')THEN'...
0
votes
1answer
313 views
ogr2ogr conversion failed when converting the varchar value to data type int
I keep getting this Error 1 when I run the following on some tables
ogr2ogr -skipfailures -f "MapInfo File" -lco overwrite=yes -lco launder=no -lco relaxedFieldNameMatch "D:\QG\CREFNO.tab" "MSSQL:...
0
votes
1answer
654 views
Connect ArcGIS 10.6 to Oracle 12c Enterprise Edition
I want to connect ArcGIS 10.6 to an Oracle 12c Enterprise Edition. However, I found different informations on the Esri websites on how to do so.
I followed this website (http://desktop.arcgis.com/...
0
votes
0answers
265 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 ...
1
vote
1answer
308 views
PostGIS view on multiple geometry columns
I have two PostGIS tables, ‘filelinks’ and ‘maricopa_plss_qtrqtrs’. The filelinks table has a geometry type column named ‘geom_p’ and the maricopa_plss_qtrqtrs has a geometry type column named ‘geom’. ...
2
votes
0answers
446 views
GDAL PostgreSQL shapefile import “Unable to find driver 'PostgreSQL”
I have seen a number of posts similar to this but with no resolution.
I am experimenting with GDAL commands and am fairly new to it however when using a PostgreSQL database connection I am getting ...
1
vote
0answers
37 views
QGIS how to make options in valuemap invisible when outside constraint
I am making a geopackage to plan aids to navigation in a maritime environment.
I have made the design of my attributes form with the drag/drop designer.
The constraints I put in work i.e. If i choose ...
0
votes
0answers
41 views
Complex edge conditions on geo-edges
Spatial graph databases are capable to find a shortest path from the node A to the node B. Are there any DB which allows complex conditions on nodes and edges between them?
For example:
The node is ...
1
vote
0answers
106 views
How to attach one spatialite database to another in db manager
I'm trying to attach one database to another so that data from it can be used in queries.
I'm using
ATTACH DATABASE '{full url}' AS {database_name};
No errors actually occur, but when I run
PRAGMA ...
1
vote
2answers
1k views
PostgreSQL select value where '100%' using bigint
I am trying to select data from a bigint column in PgAdmin using SQL:
SELECT FROM public.addressbaseplus WHERE uprn LIKE '100%'
However, I am getting the following error:
ERROR: operator does not ...
