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
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
467 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
206 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
237 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(""" ...
2
votes
0answers
58 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
288 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
549 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
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
119 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
70 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
132 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
4k 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
32 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 ...
3
votes
0answers
836 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
344 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.
1
vote
1answer
37 views

How to get data from table and define the geometry on the same query?

My team is using DB2 database and I have to create and publish a map service in ArcGIS using one of the tables. The table has the XYZ column but no SRID defined in the table or database. The DB2 ...
1
vote
0answers
307 views

Using function in pgPointCloud extension to PostgreSQL with PostGIS

I am using the pgPointCloud extension to PostgreSQL and have created a table of blocks/patches of points in a point cloud. Now, I am just trying to run a few of the functions in the pgPointCloud/...
5
votes
1answer
574 views

Save style to DB (postgres) - QGIS

When trying to save a style to postgis database through QGIS I am getting the error: 'Unable to save layer style. It's not possible to insert a new record into the style table. Maybe this is due ...
1
vote
0answers
187 views

How to make path similar in the leaflet and in database for the tiles of a basemap

The Tiles in a database files has values for a tile like at zoom level 13 column 5869 and row 3370. However the leaflet and python generates the tile number as column 4782 and row 1162 at zoom level ...
1
vote
0answers
44 views

Does ArcGIS Server allow the output data to be stored in a database? [closed]

There is a chapter in my bachelor thesis on database output storage support within various WPS implementations. In other words, I want to find out if the output data (data derived from processes ...
2
votes
0answers
47 views

Creating multiple users for postgis db created with qgiscloud plugin?

I have created a PostGIS database using qgiscloud plugin. I would like to give access to 3 more users (usernames and associated passwords) in order for them to update 3 specific layers only, without ...
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 ...
2
votes
0answers
92 views

Joining an ArcGIS Enterprise Database to another SQL database [closed]

I'm curious if it is possible to join an ArcGIS enterprise database to a separate SQL Server. My intention is to have 1 unique attribute on the ArcGIS layer that can reference the row in the SQL table ...
4
votes
1answer
383 views

PyQGIS - Adding layer from PostGis database

I want to add new layer from PostGIS database but this code isn't working... Can someone help me? uri = QgsDataSourceURI() uri.setConnection("IP address", "5432", "ruian", "user", "pass", ...
1
vote
1answer
738 views

Shapefile and Database file too large for Google Earth/Accumap

I am completely new to GIS and I had hopefully a simple question regarding how to reduce the file size of my shapefile and associated database file. The files sizes are: Shapefile (.shp file format) ...
2
votes
0answers
1k views

How to connect existing postgis tables with Django models

I have some existing tables (shapefiles) and I want to connect each table with a django model. I imported the tables with shp2pgsql tool: shp2pgsql -I -s 2100 -W 'iso-8859-7' world.shp public.world | ...
3
votes
1answer
172 views

How Can I View All Databases on a PostGIS server in QGIS

When I add a new PostGIS database connection to QGIS the dialog asks for the database name. At times I want to add a database and can't remember the exact name or I want to add a database from a ...
1
vote
0answers
310 views

Connecting ArcMap to Oracle DB

I am trying to establish a connection from ArcMap 10.0 -- Service Pack 5 to an Oracle DB (I thought it was 10g if might be 11g) on windows 7.. It is windows have connected to the database via Catalog....
1
vote
1answer
131 views

What DBMS is used by ArcGIS Online? [closed]

I work in an Oracle shop. My I.T. department uses ArcGIS Online to host data for use in data collection activities. The data goes through a yearly cycle: Export from our Oracle enterprise ...
2
votes
0answers
140 views

How to make a database to be a model parameter in QGIS?

I built a model in QGIS that imports vector into PostGIS database. My only problem is that I can choose which database I would like to import my data into but only if I rightclick on the model and ...
7
votes
2answers
805 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 ...
3
votes
1answer
222 views

How to preserve geometry when saving vector files to a SpatiaLite db (QGIS)

I have been trying to add multiple vector layers to a SpatiaLite database, however using the integrated DB Manager in QGIS 2.14.10 and 2.18.7, whenever I add a shapefile using the "Import Layer/File" ...
2
votes
1answer
599 views

QGIS re-entering my database credentials

Whenever I have a disconnection from the internet I can't upload any of my edits to the database. I then have to restart my QGIS to get connected again and enter my credentials. Is there a way to do ...
1
vote
0answers
54 views

How can the users of my map add their favorite places [closed]

I want to create a map where the users of my website can add their favorite touristic places by clicking on the map and add some attributes. I don't mind if it's done by Leaflet openlayers or any ...
1
vote
0answers
35 views

Interactive map for linguistic purposes [closed]

I would like to learn how to do dynamic/interactive maps for users interested in linguistic issues. In short, the idea is that a user could choose for instance between two syntactic constructions (Put ...
2
votes
0answers
177 views

What exactly is the memory impact on the database when reducing cells size in a Raster GIS?

I understand that the size of the memory of a raster database increases when reducing the cell resolution. I read some about it in the ArcGIS Help. However, I am wondering about the exact relation on ...
0
votes
1answer
225 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, ...
2
votes
0answers
2k views

Access database file to QGIS [duplicate]

I'm trying to import an Access file (.mdb) to QuantumGIS. This database comes from a geodatabase from ArcGIS. Can someone explain me how to do it? I tried to import from Add Vector Layer > Database >...
3
votes
0answers
78 views

In MySQL are there unidirectional and directional graphs?

I'm new to MySQL and studying about geospatial data. I have read the documentation of MySQL and learned about the ST_Geometry type, its subtypes and its functions; but I didn't find anything about ...
2
votes
1answer
287 views

How to create “Unique class values” in QGIS for quicker entries?

I am starting to learn how to create QGIS database for assignments at work, I know how to create query's that you can "search" the database for, but this not exactly what I want in QGIS. I want to ...
1
vote
1answer
2k views

Error using Wildfly10 + Hibernate-Spatial + Postgis

Hey I have set up a Nominatim Server to geocode my adresses. Because this all ready has the data I need in a other place I want to connect my Server again this database. So I tried to set up a ...
0
votes
1answer
77 views

Error using Postgis 2.3.1

I installed PostgreSQL 9.6, PostGIS 2.3.1 and Pgadmin III on my computer, and I was reading the documentation, so I thought that would be a great idea see the function on practice and then modifie ...
1
vote
0answers
105 views

Different FIPS Codes Versions for Counties [closed]

I am a SQL guy writing queries for supply chain consultants. I know little about FIPS. I found in our database, at least three versions of FIPS code for counties. The number of FIPS are from 3100 to ...
1
vote
1answer
124 views

Extract data from the .dbf affilated with a set of shapes

I have a set of shapes that I produced from a spatial merge. It has 1.6 million postcode polygons, however when I save it in QGIS to .csv it only saves two thirds of the data. I'm not sure why this ...
5
votes
1answer
533 views

PostGis and datatypes WKT

I dont't have any experience with the geographics databases so I hope that you be patiente with me, the thing is: I know that the datatype geography is used if all you care about is measuring ...
1
vote
1answer
685 views

Linking Google sheet as a database for GIS [closed]

I’m working on a database update, at the moment this database is simply an excel spreadsheet not formatted to be used in a GIS project. The database has to be updated and modified over time. Some ...
2
votes
0answers
129 views

Importing a shapefile and keep getting error with PostGIS manager [duplicate]

I am new to PostGIS and using pgAdmin. I have tried to import a shapefile into PostGIS manager and it gives me this message: Importing with configuration: ex_hzfi99mczhvqbnkrya6ryz35mveyt_osm_point, ...
5
votes
1answer
524 views

Storing GPS and mobile sensor data

I am making an app to store GPS and mobile sensor data. My problem is how to store the data. The accelerometer data has a rapid frequency and the GPS data comes irregularly. Right now I've been ...
2
votes
2answers
309 views

Geoserver SLD: link to symbol in database instead of file

I have a PostgreSQL table with fields: 'id' with identificators of objects types (e.g. shops, cinemas etc), 'graphic' with SVG codes of correcponding map symbols. I want to create sld style with ...