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

How to have a record id without geometry?

I have a buildings shapefile layer and every building has a building ID linked to its feature id ($id). Some new buildings have been built and old buildings were demolished. I'd like to not recycle ...
1
vote
1answer
368 views

Transfer data from SQL database to postgre database using GDAL

I am new to GDAL and have been uploading CSV crime data to a postgis database using ogr2ogr. ogr2ogr -f "PostgreSQL" -lco GEOMETRY_NAME=geometry -lco FID=gid PG:"host=server user=user dbname=dbname ...
4
votes
2answers
512 views

Healthy number of tables in PostgreSQL schema?

I manage a PostgreSQL + PostGIS database with two schemas of 200 and 120 tables. I wonder if this is correct or I should organize the tables in more and smaller schemas. So far, we hadn't had any ...
0
votes
1answer
546 views

PostGIS update column with selected

I am new to database sorry if this is basic. I have selected point geometry from a geometry column in pgAdmin, however, I would like to know how to now copy the selected points to a new column? This ...
0
votes
1answer
34 views

Editing DB contents

I have loaded polylines from the CSV below: name;type,status;wkt 01001-4;Integrated;virgin;LINESTRING(xx.x yy.y,xx.x yy.y) and it populates the table in the DB. What I would like to do is change ...
1
vote
2answers
330 views

PostgreSQL - only allow points to be added to the table (no polygons or lines)

I want to know if there is a way to only allow certain Geometry types to be added to a table in PostgreSQL. I have a tool that currently allows points, lines and polygons but would like to restrict ...
2
votes
2answers
211 views

Is there an easy way to implement INSPIRE model in PostGIS?

I need to implement INSPIRE (Infrastructure for Spatial Information in the European Community) model in PostGIS. I searched everywhere but couldn't find SQL file, or any other implementation that I ...
1
vote
1answer
66 views

Postgis pgAdmin ST_area returning different to other GIS's

I have a shapefile which is returning a different area value in pgAdmin than in FME, Cadcorp SIS and QGIS and I don't know why it is different in pgAdmin. The setting used in pgAdmin are: SELECT ...
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 ...
4
votes
1answer
267 views

What Datawarehouse can process geospatial informations?

I'm currently using a PostgreSQL database with the PostGIS extension. My querys are growing to big for my inhouse server, so I would like to port this into the cloud. The querys mainly compute the ...
0
votes
3answers
248 views

Finding the “square” bounding boxes of a country

I want to find the square bounding boxes that cover a country, of different sizes. First off, I know that they won't really be square, but just going by the numbers they can be said to be. The main ...
3
votes
2answers
328 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 ...
0
votes
0answers
139 views

Automatically backup from qgis to pgadmin

I have got postgres (pgadmin 3) + qgis link. And I think about next thing: how i can work with postgis layers, in a way that, backup file of my spatial database will created automatically for example ...
0
votes
1answer
124 views

How to convert QGIS 3.0 project to use auth_db ids

I am working on a Mac and running QGIS 3.0.3 and I am exploring the authentication db setup. I have a bunch of layers almost all of which are based on PostGIS queries and I want to move all my ...
2
votes
1answer
248 views

Create a point shapefile from table in .accdb database

I am a beginner in Python. I have a database in .accdb format of Access 2007. The database has a table called "T_point_RT" which has point data. I want to create a point shapefile from North and Est ...
1
vote
0answers
25 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
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
642 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
231 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
298 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
61 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
329 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
709 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
30 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
129 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
94 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
133 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
5k 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
34 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
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 ...
1
vote
3answers
451 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
39 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 ...
2
votes
0answers
349 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
736 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
204 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
45 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
50 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
116 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 ...
5
votes
1answer
529 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
925 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
187 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
348 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
141 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
149 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 ...
8
votes
1answer
1k 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
234 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
731 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
2
3 4 5
8