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.
365
questions
-1
votes
0answers
44 views
Difference between a geodatabase and a normal database? [on hold]
I am new to GIS and don't really understand the difference between a normal database and a geodatabase.
0
votes
0answers
14 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
19 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
27 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
45 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
32 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
29 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
50 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
12 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
85 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
23 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
38 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
54 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
62 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
27 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
46 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
29 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:
...
0
votes
1answer
85 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 ...
1
vote
2answers
52 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
53 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
70 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
73 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
189 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
324 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
143 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
174 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
231 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
27 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
39 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 ...
0
votes
0answers
214 views
Can I use SpatiaLite database using Room for Android?
I want to use the SpatiaLite database using Room library for my project. Is it possible to do? I have heard there is a custom open helper for the Room which might help to use the SpatiaLite db. But ...
1
vote
0answers
82 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
742 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 ...
0
votes
0answers
40 views
How to have a record id without geometry?
I have a buildings shapefile layer and every building has a building ID linked to its feature id ($id). Some new buildings have been built and old buildings were demolished. I'd like to not recycle ...
1
vote
1answer
236 views
Transfer data from SQL database to postgre database using GDAL
I am new to GDAL and have been uploading CSV crime data to a postgis database using ogr2ogr.
ogr2ogr -f "PostgreSQL" -lco GEOMETRY_NAME=geometry -lco FID=gid PG:"host=server user=user dbname=dbname ...
4
votes
2answers
386 views
Healthy number of tables in PostgreSQL schema?
I manage a PostgreSQL + PostGIS database with two schemas of 200 and 120 tables.
I wonder if this is correct or I should organize the tables in more and smaller schemas.
So far, we hadn't had any ...
0
votes
1answer
363 views
PostGIS update column with selected
I am new to database sorry if this is basic.
I have selected point geometry from a geometry column in pgAdmin, however, I would like to know how to now copy the selected points to a new column?
This ...
1
vote
2answers
287 views
QGis 3.0 Multiuser Access
How does multiuser access work in QGis 3.0?
Can multiple people open and edit the same object in a layer and save it at the same time? (Edit: Yes, but it may cause loss of data)
Does it warn you ...
0
votes
1answer
33 views
Editing DB contents
I have loaded polylines from the CSV below:
name;type,status;wkt
01001-4;Integrated;virgin;LINESTRING(xx.x yy.y,xx.x yy.y)
and it populates the table in the DB.
What I would like to do is change ...
1
vote
2answers
209 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 ...
2
votes
2answers
159 views
Is there an easy way to implement INSPIRE model in PostGIS?
I need to implement INSPIRE (Infrastructure for Spatial Information in the European Community) model in PostGIS.
I searched everywhere but couldn't find SQL file, or any other implementation that I ...
1
vote
1answer
62 views
Postgis pgAdmin ST_area returning different to other GIS's
I have a shapefile which is returning a different area value in pgAdmin than in FME, Cadcorp SIS and QGIS and I don't know why it is different in pgAdmin.
The setting used in pgAdmin are:
SELECT ...
1
vote
0answers
48 views
Trigger history_ How can I define the last updated column?
I am trying to implement a trigger function in PostgreSQL. I've written this trigger history function:
CREATE OR REPLACE FUNCTION history_update()
RETURNS trigger AS
$$
BEGIN
INSERT INTO ...
4
votes
1answer
212 views
What Datawarehouse can process geospatial informations?
I'm currently using a PostgreSQL database with the PostGIS extension. My querys are growing to big for my inhouse server, so I would like to port this into the cloud.
The querys mainly compute the ...
0
votes
3answers
152 views
Finding the “square” bounding boxes of a country
I want to find the square bounding boxes that cover a country, of different sizes.
First off, I know that they won't really be square, but just going by the numbers they can be said to be.
The main ...
3
votes
2answers
221 views
Geoserver+postgis: how to complete creating database via REST API?
I'm using geoserver 2.13.1 with postgres 9.5 and postgis 2.4.2.
I am trying to use REST api to create workspace (works) and in it a datastore of postgis type. I have already prepared a template ...
0
votes
0answers
114 views
Automatically backup from qgis to pgadmin
I have got postgres (pgadmin 3) + qgis link. And I think about next thing: how i can work with postgis layers, in a way that, backup file of my spatial database will created automatically for example ...
0
votes
1answer
105 views
How to convert QGIS 3.0 project to use auth_db ids
I am working on a Mac and running QGIS 3.0.3 and I am exploring the authentication db setup.
I have a bunch of layers almost all of which are based on PostGIS queries and I want to move all my ...
2
votes
1answer
211 views
Create a point shapefile from table in .accdb database
I am a beginner in Python.
I have a database in .accdb format of Access 2007. The database has a table called "T_point_RT" which has point data.
I want to create a point shapefile from North and Est ...
1
vote
0answers
25 views
How to reproduce this type of server-side authentication?
A Server Connection that I have is username and password protected, and so this prompt pops up when you open the mxd. I am trying to understand the system we have here better, and would like to be ...
1
vote
1answer
29 views
Is it possible from inside QGIS to analyze a number of occurrances (non-points) of a given variable repeating in a database to map it?
I have a database with each and every death in a country, each row in the database has a GEO_REFERENCE tag constructed by the concatenation of a code given to every division and subdivision instead of ...
