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.

Filter by
Sorted by
Tagged with
0
votes
0answers
34 views

Azure Database for PostgreSQL / PostGIS [closed]

Is there any document on earth to explain the methodology for uploading Spatial data set on Azure database for PostgreSQL using PostGIS extension? I am connected to the Azure database for Postgres ...
0
votes
1answer
424 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/...
1
vote
0answers
24 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* ...
0
votes
1answer
32 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 ...
3
votes
1answer
33 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
1answer
25 views

QGIS 2.18.13 Points at intersections have More Information with the ID than what is in the database fields?

Created Point Feature Class at all street intersections. When looking at the database fields I only get two fields yet when i use the Info tool I get several paragraphs of information including the ...
0
votes
0answers
31 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, ...
0
votes
1answer
579 views

Using an ArcSDE Connection through Python

I would like to run a script on a ArcSDE feature class. The script runs perfectly when I hard code a shapefile, but is unable to connect to an ArcSDE database. The purpose of the script is to assign ...
0
votes
1answer
100 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 ...
0
votes
1answer
227 views

Appending columns from a table to my active table?

I am trying to append three columns from srs2016 to srs2013_1 using this sql. INSERT INTO srs2013_1 (the_geom, agency_responsible, description) SELECT the_geom, agency_responsible, ...
3
votes
2answers
242 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 ...
7
votes
2answers
806 views

Using QField with Multi-User Access also Offline?

I got 10-20 QGIS-Users which edit all one Project online and offline. Sometimes they do it at the same time. Until now we only used QGisDesktop with a PostGis Database stored in QGIS Cloud(50MB ...
1
vote
1answer
30 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 ...
2
votes
1answer
1k views

Filemaker interface with QGIS

I have created a map of features on an archaeological site. The artifact inventory is in FileMaker Pro 12. Rather than creating a CSV file and using that as the attribute table, I would rather, if ...
1
vote
1answer
61 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
3answers
169 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 ...
0
votes
1answer
68 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
44 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).
9
votes
8answers
11k views

Comprehensive database of all cities/towns in South Africa?

The title says it all really - I'm looking for a comprehensive list/database of all cities/towns in South Africa. I know about these guys: http://www.afrigis.co.za/, but they're just not getting back ...
0
votes
0answers
52 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
13 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
86 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
25 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
1answer
80 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?
1
vote
0answers
40 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
61 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
0answers
48 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
35 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
2answers
53 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
56 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
80 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
87 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
59 views

Database access pattern using PostgreSQL and ArcGIS

I am planning to connect to a PostgreSQL DBs on a server from ArcGIS on my laptop. My server admin is interested to know "The access pattern: How, when, how often, (would ArcGIS access the DBs) during ...
0
votes
1answer
205 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
0answers
171 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
199 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
284 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
33 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
40 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
1answer
221 views

Unable to change default geodatabase with arcpy.env.workspace

Even after I set the path for the default database with arcpy environment variable, ArcMap does not change the default database directory? At first my arcpy.env.workspace looks like below: >>&...
6
votes
3answers
39k views

How to embed a map into Access Database?

I am developing a database for my organisation that could be spatially enabled. I have to use MS Access 2007 on Windows and am therefore looking for any possibilities to incorporate my Access ...
3
votes
1answer
1k views

Put LeafletJS geoJSON's into a MySQL database through PHP

I'm doing a project that will let users manipulate a map through LeafletJS, creating circles and polygons on top of the map. I need to gather these inputs for later analysis, using a MySQL database ...
5
votes
1answer
1k views

How to fix: update of view in private qgis.db failed error

After a change in permissions, I started to get this error message: Update of view in private qgis.db failed. table vw_srs already exists I know that changing the ownership of the db or deleting ...
1
vote
0answers
87 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
882 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 ...
2
votes
2answers
174 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 ...
2
votes
0answers
31 views

Camera reports database online to look it up?

I received tons of aerial photos that go back to 1930's and I have the information about the camera number and lens number and focal length. They were taken in a picture of the roll that tells us what ...
0
votes
0answers
46 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
268 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 ...