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.

83 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
81 views

Saving ArcMap/ArcGIS Pro symbology to a PostGIS DB for each layer

I want to have a default style/symbology assigned to each layer in a PostGIS database so that whenever it is loaded in ArcMap/ArcGIS Pro, it will come up with the default style. There is a way in QGIS ...
3
votes
0answers
67 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 ...
3
votes
0answers
1k 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 ...
3
votes
0answers
416 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/...
3
votes
0answers
82 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 ...
3
votes
0answers
345 views

QGIS not loading default layer style from PostgreSQL database on startup

I have saved a vector layer style to my PostgreSQL database source. I then amended the layer_styles table record for the relevant layer by editing the styleqml field (just changed the outline_width ...
3
votes
0answers
51 views

DataB and DataB-copy worked on simultaniously - how merge DataB-copy into DataB

ArcGis 10 - EDITED (sorry for not being more specific, quite new to the arcgis world) We need to enter A LOT of Map data (Sewage system) into a Database in a relatively short time. It involves an ...
3
votes
0answers
116 views

Search in Bounding Boxes and Locations

Description of the problem (what I need): I have a set of bounding boxes (maybe the actual data is a location[longitude, latitude] in which case the bounding box will have identical corners). I have ...
2
votes
0answers
88 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
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 ...
2
votes
0answers
60 views

Creating QGIS Symbology Database?

I'm looking to swap from MapInfo to QGIS at my work and im trying to see if its possbile to have a centralised symbology database. eg to be able to pull our symbology from a database rather than from ...
2
votes
0answers
673 views

GDAL PostgreSQL shapefile import “Unable to find driver 'PostgreSQL”

I have seen a number of posts similar to this but with no resolution. I am experimenting with GDAL commands and am fairly new to it however when using a PostgreSQL database connection I am getting ...
2
votes
0answers
51 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
2k 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 | ...
2
votes
0answers
160 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 ...
2
votes
0answers
294 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 ...
2
votes
0answers
142 views

Is there any map API that allows you to pull an address range from a polygon?

I've seen a lot of answers saying you can't draw polygons and get the exact addresses of all of the places contained; thankfully, I don't need so much info. I'm looking for a way to get a vague ...
2
votes
0answers
1k views

How do I set up a PostgreSQL database for use with PostGIS and GeoDjango?

The Django docs say to use createdb -T template_postgis geodjango but I already have a database set up. While trying to find out what this actually does and a way to apply it to an existing database, ...
2
votes
0answers
116 views

QGIS: Edits in attribute table are not updated in Postgis database. Why?

As the title say. I edit values in the attribute tables of my QGIS project but there is no update to the database. I refreshed in QGIS as well as the database. What else do I need to do?
2
votes
0answers
3k views

Coverting annotation into a shapefile

I have created an annotation feature class in Arc10 and when viewed within the database, looks great. However, whenever I go into catalog and export the annotation feature class to a shapefile, it ...
2
votes
0answers
90 views

Bounding Box approximation when calculating in euclidic space?

Although I will illustrate my problem using a database, I think this is a quite general GIS question. I hope I came to the right place to ask. I am working with a system that runs on a normal ...
2
votes
0answers
77 views

Raster layer with unique vector for each raster cell?

I have been looking around several hours, even days, but couldn't find a clear answer to my question. I am working on a WebGIS tool that interprets local geology. From more than 70 asc-files, I would ...
2
votes
0answers
919 views

Connect QGIS to MSSQL view (i.e. not a table)

I've got a MSSQL view containing data I want to show in QGIS. The view transforms a BLOB field containing WKB that is in one of my tables into a SQL geometry, which QGIS will be able to display. ...
2
votes
0answers
211 views

How exactly is an SLD_body object (when extracted from its XML href) structured when using a cElementTree to parse it?

I'm trying to export data from a PostGIS database into a geoserver and I've gotten it to where I can get the PostGIS database to point to the geoserver (I'm doing this as a python script for a GIS ...
1
vote
0answers
8 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 ...
1
vote
0answers
40 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 ...
1
vote
0answers
109 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
34 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 ...
1
vote
0answers
128 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* ...
1
vote
0answers
24 views

n:m relations of lines including directions

For trail planning and route signalization projects, I am looking for a solutions which allows me to connect "physical" trail segments (available as .gdb from authorities) with overlaying routes, ...
1
vote
0answers
99 views

PostGIS: proper way to model object that follows sections of another object's path?

First, apologies if this has been asked before. I don't really know how/what to search for, and am struggling to just put this question into words. I'm trying to model aerial utilities in a PostGIS ...
1
vote
0answers
72 views

QGIS 3.6 - Updating layers from changing excel spreadsheet

I am building/editing a table and utilising Excel as the vehicle. When I change the spreadsheet I need to produce a new csv file and then re-import to generate new layers. Handling Excel spreadsheet ...
1
vote
0answers
65 views

Synchronisation problems using QFieldSync

When resynchronizing data from QField GPKG project to QGis SHP project, using QFieldSync, attribute data are shifted to the right column. There is a lag, I have never seen something like that before. ...
1
vote
0answers
46 views

QGIS how to make options in valuemap invisible when outside constraint

I am making a geopackage to plan aids to navigation in a maritime environment. I have made the design of my attributes form with the drag/drop designer. The constraints I put in work i.e. If i choose ...
1
vote
0answers
134 views

How to attach one spatialite database to another in db manager

I'm trying to attach one database to another so that data from it can be used in queries. I'm using ATTACH DATABASE '{full url}' AS {database_name}; No errors actually occur, but when I run PRAGMA ...
1
vote
0answers
54 views

Trigger history_ How can I define the last updated column?

I am trying to implement a trigger function in PostgreSQL. I've written this trigger history function: CREATE OR REPLACE FUNCTION history_update() RETURNS trigger AS $$ BEGIN INSERT INTO ...
1
vote
0answers
26 views

How to reproduce this type of server-side authentication?

A Server Connection that I have is username and password protected, and so this prompt pops up when you open the mxd. I am trying to understand the system we have here better, and would like to be ...
1
vote
0answers
224 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
375 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
0answers
445 views

How to store tile maps into databases and use them for web mapping?

I am making a web map using leaflet and a lot of tile maps from raster files. When using gdal2tile.py to convert these rasters into tile maps, it will automatically create a bunch of directories and ...
1
vote
0answers
54 views

Missing vector features when import from .sqlite to postgis?

I imported vector data from a .sqlite file to PostGIS but not all of my vector features imported. I haven't been able to determine a reason for most of the loss of features between the databases (...
1
vote
0answers
472 views

Is there any way to connect features (entities) of dxf to database in python?

I'm using gdal, ezdxf, sqlite python packages and sqlite ODBC driver. They work fine, and in AutoCAD I can easily manually connect to my dbase.sqlite (read only) using _DBCONFIGURE and _DBCONNECT ...
1
vote
0answers
364 views

Null output from Transform function of Spatialite

I am using Spatialite, an extension of SQlite and I have some problems running the transform function. According to the Spatialite functions page (http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2....
1
vote
0answers
142 views

Export SQL table with images to Qgis

In MySQL Workbench 6.3 CE I created a table with some columns. One of this columns is of data type 'BLOB' to insert an image. Now i am looking for a way to export this table and import this table ...
1
vote
0answers
581 views

Registering database to ArcGIS for Server gives null error?

I'm trying to register a database to ArcGIS for Server 10.2.0 from the web server manager using sde file from ArcMap. The connection works fine in ArcMap. But when registering I'm only getting a "...
1
vote
0answers
51 views

Export only one value from a one-band raster

I have a PostGIS database with a georeferenced raster, with one band which contains values from 0 to 255. I should export it to a transparent GeoTiff picture in which the only visible pixels are those ...
1
vote
0answers
411 views

Road traffic database sample?

I would like to do some experiments on a traffic forecasting neural network and I need some real traffic data to run the network. My question is where can I download some real traffic statistics data ...
1
vote
0answers
382 views

world city database (with lon,lat) & population per year

I'm building a visualisation with cities population around the globe for a website, found the MaxMind free database that includes most cities around the globe with coordinates and population, which is ...
1
vote
0answers
66 views

Is it possible to retrieve lost versioned data in SQL Server Management Studio?

One of my staff accidentally deleted a feature class she was creating in her version before I reconciled it. I have grabbed a back up of the database from yesterday in SQL Management Studio. Is ...