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
0answers
20 views

How to fix an error while registering PostgreSQL database to ArcGIS Enterprise Server

Software in use is: ArcMap 10.8.1 ArcGIS Server (Enterprise) 10.8 PostgreSQL 13 + PostGIS 3.1 Windows 10 64bit I followed a guide to register a PostgreSQL database (PostGIS) to ArcGIS Server. When I ...
4
votes
5answers
16k views

POI database of tourist attractions, or POI database with popularity index

I'd like to build a list of popular points of interest and tourist attractions for many/every city in the world. Is there any sort of dataset that I can use for this which either contains only popular ...
0
votes
0answers
30 views

Update a layer from QGIS DB manager

I have a layer that I want to upgrade using SQL sentences with QGIS DB manager. I want to do a simple join with another table, both are in a geopackage. My question is: Can I update the point layer ...
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 ...
1
vote
0answers
32 views

PostgreSQL cannot work when opens SSL on Windows 10 [closed]

I am not sure this topic will fit here but I don't know ask it where. I am trying to open the SSL of PostgreSQL 10.16 on Windows10. I read a lot of documents about creating an SSL certificate to ...
3
votes
3answers
96 views

QGIS 3 SQL dialect - is UNION ALL allowed?

I have a very large SQL query consisting of two similar but different blocks, connected by a UNION ALL: select OBJECTID, PROJECT_NAME, BIOGEOCLIMATIC_LBL, SITE_SERIES_MAP_CDE_LBL_CPNT_1, GEOMETRY as ...
10
votes
5answers
18k views

How to display special German characters “ÄÜÖß” in a map?

I have a shapefile with names for Regions. These don't seem to contain special characters "Ä", "Ü", "Ö", "ß" but ugly hieroglyphs. What can I do to display them correctly. If I import the shape as ...
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 ...
2
votes
1answer
55 views

Reasons to NOT make my database into a PostGIS database? [closed]

So our team currently has two databases in two "independent" parts of the process. It's organizationally independent but for the actual work we do they depend on one another's output. I ...
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 ...
-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 ...
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, ...
1
vote
1answer
27 views

PostgreSQL export geometry to .sql file [closed]

I don't know how to export the geometry of tables in a .sql format from PostgreSQL database. How can I do this?
4
votes
2answers
95 views

Select characters using regular expression in QGIS

I'm trying to seperate characters from database to seperate fields. Database is like: 999-10-1-1 999-10-11-111 999-10-111-1111 999-10-22-1 999-10-1111-2221 and I want something like in seperate ...
4
votes
2answers
504 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 ...
10
votes
6answers
1k views

Database versus Files for Solo Developer

I'm just getting started in GIS and am interested in using it to create maps of mountain biking trails in my area and nearby. I've been learning QGIS and have made enough progress to generate a decent ...
0
votes
0answers
38 views

QGIS: Using OSgeo4W shell to login to and create a new PostGIS database

I'm trying to create a new database through the OSgeo4W shell, as opposed to loading QGIS and hitting the 'Manage DB' menu to make one an pipe in SQL scripts. I haven't seen any documentation on this ...
3
votes
1answer
63 views

QGIS access Oracle non-spatial database tables

I stumbled accross this when I tried to connect to a "normal" Oracle 11g instance (no Oracle Spatial) in order to join Oracle tables to spatial data in other formats. Note that this is not ...
1
vote
0answers
12 views

Saving Metadata to DB (QGIS 3.4 or higher)

Is it possible to save metadata of a QGIS 3 layer in a database (PostGIS), similar to the function in QGIS 2.18 "save layer style to database". I don't want to save it in the project or as a ...
0
votes
1answer
54 views

ArcGIS Enterprise Registered Database Changed - Update Source Without Republishing All Layers?

I have around 50 feature and map layers published in ArcGIS Enterprise (the same would apply for ArcGIS Online) that reference registered PostGIS database. The database will be migrated (same names, ...
2
votes
1answer
56 views

Add tables from access database to QGIS

There are some similar question here, but nothing worked for me. So I have a database that has the ending .mdb which to my knowledge is some kind of Microsoft access database. But I also tried it with ...
1
vote
1answer
407 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
76 views

Connecting to Azure PostgreSQL using domain user account through QGIS

We are using QGIS over the top of an Azure PostgreSQL database. We have it working using SQL user / password combination but security policy dictates this should be a domain user authenticated ...
0
votes
2answers
70 views

What is the proper convention for storing rasters in PostgreSQL database?

Just starting to implement PostgreSQL at work and want to make sure I'm building something that will be efficient down the road. Let's say I have a raster of surface temperature for every hour of ...
2
votes
1answer
381 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
0answers
42 views

Extending OSM database with new data

I want to add a new table inside my OSM database with extra data for every restaurant, and then when retrieving the places join the table by the "osm_id", is this possible and if yes, any ...
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() ...
3
votes
1answer
2k 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 ...
0
votes
1answer
160 views

Can I store raster data in a spatialite database (in QGIS)?

This might be a super simple question, but I'm a little confused. I don't know what the best way is to share qgis-projects that have raster-data, vector-data and some applied styling. I figured a ...
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 ...
2
votes
1answer
77 views

Access SpatiaLite connections with PyQGIS QgsProviderMetadata (QGIS 3.10.7 LTR)

I would like to list spatialite connections and access a specific connectionwith PyQGIS. For postgres provider it's pretty straightforward: >>> QgsProviderRegistry.instance().providerMetadata(...
2
votes
0answers
103 views

How to save each band in a new row with it's name, in PostGIS?

I have used PostGIS's raster2pgsql to import my multi-band raster data into my PostGIS database. Here is the code that can do this operation: raster2pgsql -I -C -e -Y -F /home/jj_user/input.tif ...
2
votes
3answers
643 views

ArcCatalog database connection showing blank tables

I received info to connect to a database (without a spatial component) that has tables I need for a project I'm working on. Problem is once I establish the connection in ArcCatalog I can see all of ...
2
votes
0answers
17 views

Existing standard country codes explicit in time and space

There are several comprehensive systems for coding countries such as ISO, TLD, M49. I am looking for a system that is explicit about the time period that the code refers to. My application is a ...
6
votes
1answer
832 views

PyQGIS - Adding layer from PostGis database [duplicate]

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", ...
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 ...
-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
1k views

psql changing comma to decimal for importing CSV file

I try to import a CSV file into a PostgreSQL database that runs on a remote server. I use psql via SSH. AIS_DB=# CREATE TABLE bet_srk_2008 ( AIS_DB(# Unique_VesselTraject numeric, AIS_DB(# ...
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
1answer
110 views

Transfer & maintain a relational database in QGIS - backend vs frontend [closed]

I'm going to set up a small db for my own use in QGIS. I can see only a few of the many tables will be spatial, but the ease of use and capacity of the widgets in QGIS are attractive. I won't writing (...
1
vote
0answers
124 views

Spatial similarity between polygons

I am using PostGIS and python3. I have a table with polygons objects, the polygons have year as an attribute. I need to identify the uniqueness of the polygons trough time. For instance I need to ...
1
vote
0answers
37 views

Tenant isolation in SaaS product based on PostGIS - do the same concepts as PostgreSQL apply?

We're working on two different GIS apps and we're a bit torn around how to provide a level of tenant data isolation on our GIS systems. System A would need to have strong tenant data isolation where ...
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 ...
1
vote
1answer
666 views

How to find closest point on a line from a point in Oracle Spatial?

I want to find the nearest point on a line from a point in Oracle Spatial. I know how to do in SQL Server and PostgreSQL but could not find anything about Oracle. I have used MDSYS.sdo_nn to find the ...
1
vote
2answers
80 views

QGIS style to DB

I want to import the style from a MapInfo.tab file into a postgis db. When I open the properties for the file and click on the botton style I only have the option save as QGIS QML style file or SLD ...
1
vote
1answer
99 views

QGIS - Execute SQL Failure

I've written an SQL query which works in the query section of the QGIS DB Manager. SELECT Max(S_order), SegmentID, S_Order, Length, Buff_Segme, Buff_Order, Buff_Lengt, Buff_Uniqu FROM "...
-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 ...
0
votes
1answer
1k 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
2 3 4 5
8