Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
31 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
36 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
26 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
62 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
39 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
23 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
49 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
55 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
55 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
86 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
25 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
27 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
99 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
45 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
313 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
125 views

Does Redis geo have the capability for storing polygon?

I followed the example here and also here about geospatial support in Redis. I tried to add POINT features to my Redis dataset, and subsequently I can query POINT names within certain radius of a ...
0
votes
0answers
32 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
120 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
305 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
241 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
147 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
146 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
109 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
61 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
35 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
131 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
1answer
88 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
0answers
144 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
95 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
79 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
163 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 ...
0
votes
1answer
305 views

What to do about QSqlDatabase: QOCI driver not loaded [closed]

QGIS - 3.0.1 I am trying to connect to the Oracle database. I am not an expert in QGIS, pyqgis at all. I took help of following code to connect to Oracle database. Connecting directly to an Oracle ...
0
votes
0answers
43 views

Is there another way to connect to database other than cx_oracle library

Using QGIS 3.0.1, is there any other way to connect to an Oracle database from pyqgis apart from cx_oracle library?
0
votes
1answer
164 views

What is the max amount of connections a GeoPackage can handle in GeoServer?

I'm currently working on a GeoServer deployment and for simplicity, I want to to transition to using GeoPackages rather than Shapefiles (longer column names, less work integrating the data, etc.). As ...
1
vote
1answer
122 views

Can't insert a value into the table. PyQGIS 3.0. Postgresql [closed]

Can't insert a value into the table. PyQGIS 3.0 import psycopg2 conn = psycopg2.connect(dbname='postgres', user='postgres', password='1', host='localhost') cursor = conn.cursor() cursor.execute(""" ...
3
votes
0answers
56 views

Common information shared between Geopackages [closed]

I'm trying to build a map in which I have a few geographical units organized as such. Commune ---1:N---> Contrada Contrada ---1:N---> Vineyards One commune may contain many contradas, which ...
0
votes
1answer
195 views

Register with Geodatabase greyed out

I'm having trouble registering a table with a Geodatabase in an SDE, the option is greyed out. This is a weekly task for me and I have never had this happen before. I receive a new table weekly from ...
1
vote
1answer
358 views

Import data table from database into QGIS using PyQGIS

I need to import a data table from a database into QGIS using PyQGIS. This table is not QgsVectorLayer and there is not any geometry. That is probably why this is not working. How can I do it? uri ...
0
votes
1answer
22 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
94 views

Error restoring spatial database. ERROR : could not load library “/builds/postgresql-9.6.3/lib/rtpostgis-2.3.so”

I am trying to restore a backup of a database. I am running postgresql-9.6.3 with postgis-2.3.3 I run the following restore command .../myw_db new_db restore /path/to/database.backup I get the ...
1
vote
0answers
53 views

Best database for Geographical database for my case [closed]

I'd like help to make a decision on database change. For now my case is: MySQL on Cloud SQL (GCP): Storing GPS Tracking Data for now is 400Million Record (Around 400GB). And going bigger every day. ...
2
votes
1answer
121 views

Postgis convert long lat from 2 different locations into line and calculate the distance in meters

The name of my table is odk_duct.duct_monitoring1_core and the select statement below is what i want to see the distance. The table has 2 longitudes and 2 latitudes. select "_URI" as id, "...
1
vote
1answer
3k views

Download OpenTopoMap bulk data

Is it possible to download full regions of OpenTopoMap data ? I saw that it is possible for Garmin devices (http://garmin.opentopomap.org), however, I am looking for jpg/png tiles and I could not ...
0
votes
0answers
29 views

Fail show shape attribute [duplicate]

When I click on area, GeoNetwork show the next problem: "No matching records found". In geoserver, the information if it is shown. What is the problem?
0
votes
0answers
4k views

Store Database Connection String in App.config for an ArcGIS Pro SDK Add-In 2.x

I have added an app.config file to my visual studio pro SDK project and I’m trying to retrieve a connection string from it. The retrieval code always returns null. I don’t know if that’s because it is ...
2
votes
0answers
560 views

Connecting Microsoft Access database (.accdb) to QGIS

I am trying to connect a database to a QGIS map for a project. I've managed to set up the Access/ODBC connection using the ODBC Data Source Administrator, but when I try to add a new database ...
1
vote
3answers
173 views

Connection to SQL Server in ArcMap

I want to add database connection to SQL Server from ArcMap. But, I don't know what to write as 'instance'. I've tried 'NT Service\MSSQLSERVER' but it doesn't work.