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
46 views

Load vector layer directly from mongodb with PyQGIS

I want to load my vector layer directly from a MongoDB database using Python in QGIS. I found code here but it dumps the layer before loading it. Here is the code I found: client = MongoClient() ...
0
votes
0answers
148 views

Mongo geoWithin problems reading from collection

I have a data set with geo points. { _id ...other fields... location: { type: "Point", coordinates: [0,0]}} What I have been attempting to do is filter out and delete any documents that ...
0
votes
1answer
76 views

QGIS MySQL points import

I have a column in my MySQL database table that contains location information (GeoJSON). I want to import this data and see the points on my QGIS project map but it doesn't seem to work. What I was ...
0
votes
0answers
61 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
41 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
0answers
38 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
283 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
0answers
22 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 ...
0
votes
0answers
90 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 ...
0
votes
1answer
449 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
314 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
62 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
1answer
54 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 ...
0
votes
1answer
333 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
479 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 ...
0
votes
0answers
44 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
68 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 ...
0
votes
0answers
179 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
136 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 ...
0
votes
1answer
878 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
1answer
33 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
138 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 ...
0
votes
0answers
38 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
5k 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 ...
0
votes
1answer
298 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, ...
0
votes
1answer
63 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
0answers
301 views

Database modeling for big data (big set of points X big sets of possible values for each points)?

I'm building a PostgreSQL database with the intent to host modelisation results for different projects. Each project has a set of receptors points (~5000-10000 receptors) and have many results sets (...
0
votes
0answers
443 views

Saving styles to database

In QGIS, the option to save the style to a database (postgres) does not appear in the drop down list if the postgis table has been opened using add vector layer and then entering the postgres database ...
0
votes
0answers
324 views

Word cloud labels in QGIS from database

I would like to do some word clouding as labels in QGIS from a series of tables in a database. Examples of word clouds can be found here: Word Cloud - Google Search I have two tables in a database: ...
0
votes
0answers
168 views

HTML Popup Database Actions

I'm working on a collection of points on the map, each comes with a bunch of properties. I succeeded using a customized XSL template to show the information when I click on any point. And now what I ...
0
votes
1answer
1k views

Character encoding for Oracle DB and Geoserver

I have a setup that uses Oracle database->GeoServer->OpenLayers->my JavaScript. I use the UTF-8 character set in GeoServer and the JavaScript layers. The Oracle instance is configured to use WIN1252 (...
-1
votes
1answer
30 views

Handling a database with more coordinate points than I need to be returned

I have a database with millions of coordinate points and I need to select a subset of them to create a heat map based on a bounding box. There are so many points that it's hurting performance on my ...
-1
votes
1answer
91 views

What is a database in ArcGIS? [closed]

I was wondering in general, what exactly is a database and is there a difference between that and a geodatabase? I was also wondering when you would use a database as part of ArcGIS. Do you make one ...
-1
votes
1answer
168 views

How to Append data before saving polygon in Openlayers 2

I creat a new polygon but before saving i want to append some data such as polygon name , color etc. How can i do this ? I am using this function var SaveStrategy: new OpenLayers.Strategy.Save(); ...
-1
votes
1answer
70 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
votes
1answer
41 views

Adding data column by column in postgreSQL database

I organize my data in different txt files and dat. files, mostly in each file there is one specific column of data. Now I want to import and combine 4 of them to create a table. Say I have one file ...
-1
votes
2answers
1k views

WMS layer connected to SQL database

It is possible to connect a WMS layer to a SQL database or other type of database? Example: I have created an application with GeoServer and OpenLayers. Now I can see the data from attribute table. ...
-1
votes
1answer
55 views

Migrating Data to Another Database whit FDOToolbox [closed]

I want to migrate my data (Shapefile) to a PostgresSQL using a FDOtoolbox , i searched a tutorial for that but i dont found it . can any one explain the steps to do for migarte the data from a ...
-1
votes
2answers
112 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.
-2
votes
1answer
3k views

What are shapefiles, layer files, and databases and what are their relationships? [duplicate]

What exactly is a shapefile in ArcGIS, and how is it related to a database or a layer file. What are the differences between these 3 things?
-2
votes
1answer
123 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
4 5 6 7
8