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

Error 6 when importing data from QGIS to PostGIS database ERROR: value too long for type character varying(10)

I collected data with Qfield to move into a PostGIS database but have been getting this error for some of the features. I have checked the attribute tables and the length of character looks fine to me....
user avatar
2 votes
2 answers
71 views

Where to see Feature Datasets in SQL Developer

Background: I am a non-GIS programmer, I do however directly work with numerous GIS products and data. Generally I primarily interact with the GIS data directly via the database (Oracle) through SQL ...
user avatar
  • 143
0 votes
1 answer
69 views

Extract data from a WMS with database [closed]

In my project, I have a connection to a WMS layer (https://geodienste.hamburg.de/HH_WMS_Cache_PLIS_Geodaten). The layer seems to be connected to a database. With the "get feature info (i)" ...
user avatar
0 votes
0 answers
39 views

Using Osmosis library to query data from a PBF file

I know that it's possible to read (crosby.binary.osmosis.OsmosisReader) and write (crosby.binary.osmosis.OsmosisSerializer) a PBF file using the Osmosis library. My question is if it's possible using ...
user avatar
0 votes
1 answer
293 views

AttributeError: 'NoneType' object has no attribute 'type' when importing file into Geopackage using DB Manager

Using QGIS 3.16 I have several Geopackages already, which I would like to import a file into and make a new layer. I'm using the DB Manager > Table > Import Layer/File menu item. QGIS throws a ...
user avatar
  • 2,617
0 votes
1 answer
129 views

SQLite/SpatiaLite error: no such function: ImportGeoJSON

I'm inside a bash script trying to import a GeoJSON file into a SQLite DB. I tried both ... SPATIALITE_SECURITY=relaxed sqlite3 'db.sqlite' "SELECT load_extension('mod_spatialite')" "...
user avatar
0 votes
0 answers
48 views

Transferring/inheriting GIS database structure in PostGIS from old project to new one

I have been given an existing GIS database design for a solar power project, with its structure, relationships, geometry etc designed from another project and existing in PostGIS database. I am ...
user avatar
3 votes
1 answer
53 views

Geometry data type Binary storage description

I'm looking for some low level information or reading or reference material which explains how most GIS databases store the geometry data type in binary form, because - I never really investigated it ...
user avatar
  • 2,617
1 vote
0 answers
47 views

Execute Function After Saving PostgreSQL Layer - QGIS

I have a QGIS project with many PostgreSQL layers. One of these layers is the result of processing some other layers. So each time any of the other layers are modified in any way that layer should be ...
user avatar
  • 131
0 votes
0 answers
7 views

Managing shared database where points are created based on column

We keep an Excel file with important attributes that has lat/longs attached to them. This Excel file is editable by a small team who adhere to the schema. I want to convert this Excel file to a simple ...
user avatar
1 vote
0 answers
54 views

Connect to Oracle SQL DB using JDBC connection

My IP address changes frequently and hence I use ssh tunnel via bastion host to connect to Oracle SQL DB. I used JDBC to connect to the Oracle SQL and it works successfully. However, I want to connect ...
user avatar
1 vote
1 answer
328 views

OpenLayers - Essential polygon data to save in a database

I have a project where I need to save polygons to a database. I found that you can get the coordinates array from a feature using: feature.getGeometry().getCoordinates(). This returns an array of all ...
user avatar
  • 245
0 votes
1 answer
192 views

QGIS: RiverGIS: Couldn't connect to river database

Trying to connect to the PostGIS DB for RiverGIS fails with Couldn't connect to river database: var@localhost Please, check you database connection settings! This happens despite the DB being ...
user avatar
1 vote
0 answers
48 views

Working with large datasets with no server [closed]

I am in a bit of a weird work environment. I'm a data-scientist type person who is now doing more and more GIS work on some very large datasets - spatial regression, some mapping, spatial correlation, ...
user avatar
1 vote
0 answers
225 views

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

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 ...
user avatar
  • 173
0 votes
0 answers
61 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 ...
user avatar
  • 281
1 vote
0 answers
90 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 ...
user avatar
  • 51
4 votes
3 answers
152 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 ...
user avatar
  • 869
2 votes
1 answer
87 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 ...
user avatar
-1 votes
1 answer
36 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 ...
user avatar
  • 147
1 vote
1 answer
95 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?
user avatar
  • 99
0 votes
0 answers
133 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 ...
user avatar
3 votes
1 answer
179 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 ...
user avatar
1 vote
0 answers
19 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 ...
user avatar
  • 11
0 votes
1 answer
158 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, ...
user avatar
  • 332
2 votes
1 answer
254 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 ...
user avatar
  • 657
3 votes
0 answers
138 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 ...
user avatar
1 vote
0 answers
49 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 ...
user avatar
  • 11
0 votes
2 answers
227 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 ...
user avatar
  • 448
0 votes
1 answer
390 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 ...
user avatar
  • 657
2 votes
1 answer
146 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(...
user avatar
2 votes
0 answers
212 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 ...
user avatar
  • 185
2 votes
0 answers
19 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 ...
user avatar
0 votes
1 answer
215 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 ...
user avatar
  • 1
1 vote
0 answers
133 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 ...
user avatar
  • 25
-1 votes
2 answers
174 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.
user avatar
  • 49
2 votes
1 answer
3k 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(# ...
user avatar
0 votes
0 answers
49 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 ...
user avatar
  • 103
0 votes
0 answers
518 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 ...
user avatar
  • 427
1 vote
0 answers
192 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 ...
user avatar
  • 11
1 vote
0 answers
47 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 ...
user avatar
0 votes
0 answers
25 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 ...
user avatar
2 votes
2 answers
127 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 ...
user avatar
1 vote
1 answer
1k 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 ...
user avatar
  • 418
4 votes
2 answers
205 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 ...
user avatar
  • 131
2 votes
1 answer
243 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 "...
user avatar
  • 293
-2 votes
1 answer
159 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 ...
user avatar
  • 626
1 vote
0 answers
196 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* ...
user avatar
3 votes
1 answer
103 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?
user avatar
  • 31
0 votes
0 answers
117 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 ...
user avatar

1
2 3 4 5
8