Skip to main content

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

GeoDjango fails to load Spatialite, but not Jupyter?

I am trying to use Spatialite for a GeoDjango application on a Windows 10 machine using Anaconda, but, when I run python manage.py dbshell, I get an error "CommandError: You appear not to have ...
jwx's user avatar
  • 713
0 votes
0 answers
21 views

Is SRID not preserved in MySQL export/imports?

I have a database with spatial data stored as Polygons that I run queries such as ST_Intersects against. However if I export this database and import it the SRID appears to be lost, queries that ...
Mikael's user avatar
  • 1
0 votes
0 answers
23 views

Global Flood Database v1 unmask 'jrc_perm_water'

I am using Google Earth Engine to generate mean area flooded in electoral districts of India. What is a good way to remove the values of permanent water from the 'flooded' band and generate aggregate ...
Tarana Chauhan's user avatar
1 vote
1 answer
59 views

PostGIS user privileges when working with QGIS projects and layers saved in a PostGIS database

I have a PostGIS database that includes multiple schemas, tables and a QGIS project. I have 3 general user roles: admin, editor and reader. I know of the issue with database connection information ...
geo_theo's user avatar
0 votes
1 answer
27 views

Grass GIS vector seem to lost connection to database table, but in file dbln connection exists

After I imported a big vector file and table in sqlite.db was successfully created, there were some operations then I got an error: DBMI-SQLite driver error: Error in sqlite3_prepare(): select * from ...
Nikolay Yasinskiy's user avatar
0 votes
0 answers
80 views

AutoCAD Map3D New feature from geometry fails on PostGIS

I am designing a workflow for my company which would include connecting to a PostGIS database from AutoCAD Map3D. This is done via the FDO API, included in Map3D. A key functionality I want to use is ...
crafter6029's user avatar
0 votes
0 answers
27 views

Automatic link to database style in QGIS vanished

I have a couple of shapes in a PostgreSQL database link with QGIS. Once, I created specific styles for these layers and saved them in the PostgreSQL database as default style. Now, I loaded the ...
oppia04's user avatar
  • 735
1 vote
1 answer
50 views

What is the right way to dissolve vector features in GRASS GIS on attribute values of one column summarizing or averaging others?

The line product of v.overlay contains a column with zones number and a stack of other attributes. What I want: Dissolve features (lines) on attribute column that contains zones number. Other ...
Nikolay Yasinskiy's user avatar
0 votes
0 answers
31 views

Exporting .LAS file after using v.lidar.correction

Question I want to use the GRASS GIS LIDAR modules (v.lidar.edgedetection, v.lidar.growing, and v.lidar.correction) to classify points for LAS files. I'm very new to working with databases, and the ...
mozmoz3737's user avatar
0 votes
0 answers
26 views

QGIS 3.28.5 problems opening SQLite DB

I´m unable to open my Database and have no clue about the problem. I have the following Python error: Traceback (most recent call last): File "C:\PROGRA~1/QGIS32~1.5/apps/qgis-ltr/....
golo peters's user avatar
4 votes
0 answers
84 views

Spatial database design [closed]

I am designing a spatial database and I wanted to ask if it is a good idea to use inheritance to store objects that share certain attributes, but whose geometry differs since some are points, lines ...
Javier Aguilar's user avatar
1 vote
0 answers
86 views

Updating existing PostgreSQL database with OSM data

I currently work on the project which is directly working with the geo data of the country where I live. The database we have is quite huge, containing not only the geo data but also some other stuff. ...
qwerty's user avatar
  • 11
0 votes
1 answer
142 views

Create multiple rasters in PostGIS from a (xyz) table

I'm having a hard time understanding how PostGIS works in terms of raster creation. Let's say I have a table with 14 columns: the first two are x and y coordinates followed by the air temperature for ...
Andrei Niță's user avatar
0 votes
1 answer
47 views

Is my install really missing Spatial Functions in DB2 Spatial Extender?

I'm running a number of Spatial Functions in DB2 (11.5 LUW) and getting back errors such as: SQL Error [42884]: No authorized routine named "ST_ENDPOINT" of type "FUNCTION" having ...
Yndigo Dream's user avatar
0 votes
0 answers
46 views

QGIS - comma separated values or link table - m-n relations

Is there a way in QGIS to assign multiple values to another value without creating additional columns? Using the example of owners to parcels, I would like to set the reference to several parcels in ...
Marek's user avatar
  • 537
1 vote
0 answers
38 views

In GRASS GIS db.execute IN statement works, but NOT IN doesn't

Here is my command: db.execute sql="UPDATE table SET factor=number2 WHERE label IS NOT NULL AND number2 IN (SELECT label FROM table)" This command sets TRUE on those rows, where label in ...
Nikolay Yasinskiy's user avatar
0 votes
1 answer
17 views

v.db.update doesn't write values to a column

I use v.db.update map=myfile column=label query_column=cat (areas) to copy column values. This command works well. But when I try do do the same thing for another file which is a product of streams....
Nikolay Yasinskiy's user avatar
1 vote
0 answers
85 views

Online database of OpenStreetMap data

For now, I have been working on a local PostgreSQL database built on my own machine with OpenStreetMap data that I downloaded and osm2pgsql. I would like to outsource the computing of my code, namely ...
DianeS's user avatar
  • 103
1 vote
0 answers
58 views

Set value relation widget to change available options depending on input to another field

I'm building a Geopackage database, with several tables with no geometry that function primarily as field data collection forms to use through QField. As part of this database, there are two tables ...
HeyItsRobin's user avatar
0 votes
0 answers
353 views

Transfer GeoJSON data to a MySQL database

I want to transfer my GeoJSON data to a MySQL database. I know that MySQL somehow supports GeoJSON but I do not really understand how that works. That was my try: SET @point_o_from_geoJSON := ...
Melina M's user avatar
1 vote
0 answers
35 views

Why don't some attributes appear in feature class table when geocoded from a database connection? [closed]

Using ArcGIS 10.8.2, I have geocoded a large table by connecting to the database table through an enterprise geodatabase connection. Several of the attributes only have "1" or "null&...
minivanned's user avatar
-1 votes
1 answer
81 views

Mapping predecessors and successors, and visualizing it all

I have a current project that involves relocation of hundreds of utilities. Before a utility can be relocated, there are several utilities lines that that have to relocated prior (predecessors). We ...
user173714's user avatar
0 votes
1 answer
82 views

Configuring the database for a new GeoNetwork Installaion

I have some questions after reading the documentation for "Configuring the database" for version 4.0.x GeoNetwork. The documentation states: "The database dialect is configured in /WEB-...
Philip Whitten's user avatar
0 votes
1 answer
327 views

Connect to Supabase PostgreSQL database with ArcGIS Pro

I am trying to connect my PostgreSQL database on supabase.com with ArcGIS Pro and edit data. Only way how I was able to do it was when I've created a new database on the pgAdmin inside supabase ...
adamekcerv's user avatar
1 vote
0 answers
319 views

Registering raster layers in Amazon RDS PostgreSQL using enable_out_db parameter

I have an AWS RDS PostgreSQL instance (v.11) that I'm currently storing vector data in. I also have a lot of raster layers in AWS S3 that are COG geotiffs. I'd like to register them in the database to ...
isostaticrbnd's user avatar
1 vote
0 answers
253 views

Create db connection from ArcMap or ArcGIS Pro to a regular non-spatial PostgreSQL database

When I attempt to create a database connection via ArcMap or ArcGIS Pro to a pure tabular PostgreSQL database, I keep getting insufficient permissions error. I know it is not a permissions issue. Is ...
Daniel S's user avatar
2 votes
2 answers
437 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 ...
Neberu's user avatar
  • 143
0 votes
1 answer
2k 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)" ...
Corninski's user avatar
  • 107
1 vote
0 answers
307 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 ...
Programer Beginner's user avatar
0 votes
1 answer
2k 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 ...
nr_aus's user avatar
  • 3,576
2 votes
1 answer
753 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')" "...
Danysan's user avatar
  • 121
0 votes
0 answers
66 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 ...
Learning Geo The Hard Way's user avatar
3 votes
1 answer
550 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 ...
nr_aus's user avatar
  • 3,576
1 vote
0 answers
76 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 ...
Milad's user avatar
  • 141
1 vote
2 answers
390 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 ...
Swathi Venkatesh's user avatar
2 votes
1 answer
1k 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 ...
Stephen's user avatar
  • 285
1 vote
2 answers
709 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 ...
SBerendsen's user avatar
1 vote
0 answers
176 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, ...
Crimsoneer's user avatar
1 vote
0 answers
527 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 ...
M. Tomas's user avatar
  • 183
0 votes
0 answers
156 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 ...
J.Patordi's user avatar
  • 313
1 vote
0 answers
277 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 ...
Pham's user avatar
  • 51
4 votes
3 answers
296 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 ...
grego's user avatar
  • 1,063
2 votes
1 answer
190 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 ...
JustStack's user avatar
-1 votes
1 answer
77 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 ...
Vanludvig's user avatar
  • 147
1 vote
1 answer
445 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?
Equinox's user avatar
  • 99
0 votes
0 answers
410 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 ...
Matt Canada's user avatar
3 votes
1 answer
477 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 ...
Jochen Schwarze's user avatar
1 vote
1 answer
187 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 ...
a62's user avatar
  • 11
1 vote
1 answer
552 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, ...
Yanic's user avatar
  • 342
2 votes
1 answer
1k 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 ...
Lenn's user avatar
  • 1,297

1
2 3 4 5
9