Questions tagged [connection]
for questions related to the connection of some GIS software to a database
134
questions
1
vote
0
answers
24
views
Wrong field types when connecting to MSSQL DB with user-defined data types using PyQGIS
When I connect to an MSSQL table without geometry via QgsDataSourceUri, Browser or Data Source Manager, QGIS doesn't recognize the user-defined data types of the database and sets it to string.
from ...
- 11
1
vote
0
answers
57
views
Loading parallel PostgreSQL layers with PyQGIS
I want to load a large number of PostgreSQL layers using PyQGIS.
When I load the layers using threads, it creates as many connections as there are layers. For example, if I have 38 layers, I end up ...
0
votes
0
answers
38
views
Write from ArcGIS Pro into n:m tables in SQL Server database
I would like to use ArcGIS Pro to access an existing structure in SQL Server (see image) with editing options. In addition to the columns listed, the MainTable also has spatial information (X Y points)...
- 15
4
votes
0
answers
40
views
Closing connection to SpatiaLite DB in QGIS
I have a SpatiaLite DB that has been used to generate some layers in QGIS (via a PyQGIS script, using the native:extractbyextent processing tool).
Once these layers have been generated, they are saved ...
- 5,419
2
votes
0
answers
47
views
Managing amount of DB connections of QgsDataSourceUri with PyQGIS
So basically I have a simple code that adds vector layers to the QGIS project from PostgreSQL.
self.uri = QgsDataSourceUri()
self.uri.setConnection(
self.host,
self.port,
self.db,
self....
- 21
0
votes
1
answer
50
views
Delete Features of a layer from PostgreSQL on QGIS itself
I have layers that I need to edit using QGIS that I import from my company's PostgreSQL server. I currently have the ability to add features, for example the line that I have drawn below:
However, ...
- 783
3
votes
0
answers
82
views
How to close a GDAL PostGIS connection?
This issue has been bugging me for years, desperation got the better of me so now I'm here to seek the help of the public.
I'm storing raster data in a PostGIS database, and I'm using GDAL from Python ...
- 31
4
votes
1
answer
320
views
Drawing line arrow from origin/destination coordinates fields using Geometry Generator in QGIS
From the following table structure with the fields "ORIG_LATITUDE", "ORIG_LONGITUDE", "DEST_LATITUDE", "DEST_LONGITUDE":
I clarify that the field names ...
- 2,439
1
vote
0
answers
140
views
Why QGIS removes the XYZ Tile Connection Referer?
In QGIS when i make a XYZ Tile connection with a referer, QGIS removes the referer! Why?
See animated gif:
- 21
1
vote
0
answers
48
views
Read the URL in the QGIS Layer's Tooltip [duplicate]
From a YouTube video, I made a screenshot for the QGIS layer's tooltip that contains URL of the XYZ tiles connection (See attached pic).
How can I read this URL and re-use it to make the same ...
- 21
0
votes
0
answers
188
views
Could not list layers for this store, an error occurred retrieving them: Cannot find JNDI data source: java:comp/env/jdbc/postgres
While creating a PostGIS featuretypes using request method of python or add a layer using geoserver getting error like "Could not list layers for this store, an error occurred retrieving them: ...
0
votes
0
answers
376
views
Autodesk to ArcGIS Portal Connection limits loaded features in Civil 3D
I am using the Autodesk Connector for ArcGIS in a Civil 3D project to connect to data my organization has stored in its ArcGIS Enterprise Portal. I have found that any vector layer I connect to using ...
- 1
1
vote
1
answer
393
views
Accessing SpatiaLite tables in custom QGIS Plugin
I have a SpatiaLite database that has relational tables to link geo entities that can be reflected in QGIS as layers. To link the relations I need some custom forms where I can select these entities ...
- 23
0
votes
0
answers
203
views
Connection errors with PostGIS database
I am trying to import vector data into a managed PostGIS database with QGIS and I get this error:
server closed the connection unexpectedly This probably means the server terminated abnormally before ...
- 2,367
2
votes
2
answers
2k
views
ArcGIS Pro (Catalog Pane) will not make folder connection to external hard drive
I have an external hard drive that is storing spatial data and ESRI 10x projects. I would like to add this letter drive as a folder connect but ArcGIS Pro v2.9 seems unwilling or unable to do this. I ...
- 10.2k
1
vote
1
answer
3k
views
Authentication method 10 not supported (QGIS)
I have a problem when I am trying to connect the database that I have in pgadmin with my QGIS project. I am trying to create a New PostGIS connection like in the following picture:
But I am always ...
- 223
1
vote
2
answers
368
views
Create one PostGIS connection in QGIS with multiple databases from one host?
I have a number of spatial databases each containing multiple schemas on one server,
I want to use QGIS to examine layers,
Is it possible to create one PostGIS connection in QGIS and add all databases ...
- 11
1
vote
0
answers
55
views
PostGIS table visualization in QGIS without download permission
I'm used to work with PostGIS databases and accessing them from QGIS. I know how to create schemas or grant permissions, but I was wondering if it is feasible to set a user profile that could "...
- 3,240
1
vote
0
answers
368
views
Failure to connect QGIS to FIRMS WMS - Failed to download capabilities
I'm following this tutorial from (NASA) FIRMS that shows how to ingest FIRMS fire data into QGIS.
I've followed the first steps but I get the following error:
Failed to download capabilities
server ...
0
votes
0
answers
288
views
Unable to connect ArcPy with ArcMap to MS SQL Server accessed via ArcSDE
Why can I not connect my ArcPy to our enterprise database hosted on a Microsoft SQL Server?
I'm running Python 2.7, ArcMap 10.6.1, MSSQL Server 12.0 (2014)
I've created an SDE connection file in ...
- 71
0
votes
1
answer
129
views
Remove gpkg delated QGIS
I accidentally deleted a gpkg file from QGIS browser… I thought it was to delete the connection and the file was deleted… does anyone know any way to recover it? Does QGIS save deleted files somewhere?...
1
vote
0
answers
66
views
Unable to logon when connecting to Oracle database with QGIS 3.20
After I updated QGIS to 3.20 my old oracle connections doesn't work anymore.
I get the message "Unable to logon".
Under QGIS 3.16 everything works fine.
This is what I have read in the ...
- 11
0
votes
0
answers
142
views
PostGIS database connection
I am basic QGIS user and I have database created and data loaded in it. However, when I try to connect to the database, I am getting the following error.
Connection failed - consult message log for ...
1
vote
1
answer
611
views
Unable to logon when connecting to Oracle database with QGIS
I started using QGIS recently and wanted to connect it with our database set on a standalone server. the database installed is (screenshot below).
Windows ODBC and lister are well configured, the ...
- 83
1
vote
2
answers
414
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 ...
1
vote
2
answers
798
views
QGIS - How do I embed my layer's database connections into the project (rather than DB Manager)? [closed]
Situation:
I have projects, lots of projects. They call dozens of layers from the corporate PostGIS.
This is largely public data, and the data is referenced via a readonly user account.
As it happens, ...
- 27
1
vote
0
answers
239
views
How to define PG connection to a distant server for grass gis v.in.ogr?
OS: debian stretch ; GRASS version: 7.2.
I'm writing a standalone python script using grass_session.
with Session(gisdb="/tmp",
location="mylocation",
...
1
vote
2
answers
755
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 ...
- 11
0
votes
1
answer
349
views
MapServer FastCGI connection pool configuration
I posted this question in the MapServer User mailing list but hoping I can get more eyeballs on it here. I'll update both threads if I make any progress.
The MapServer LAYER documentation says the ...
- 3,688
0
votes
1
answer
141
views
Access MDB connection file result does not have an object ID in ArcGIS 10.8
I have made an MDB Access Connection by linking the Excel file with the Access one, but when I looked at the result in ArcMap the feature class table does not have an Object ID on it. I tried to ...
2
votes
0
answers
194
views
Connection pooling in OGR PostgreSQL driver
OGR (GDAL) provides a vector driver for "PostgreSQL" and data in the DB can be accessed with something like the following:
driver = ogr.GetDriverByName("PostgreSQL")
datasource = ...
- 3,688
1
vote
0
answers
1k
views
Connecting nodes to existing network lines using QGIS
I have road network (polyline layer) and point layer:
I am trying to connect nodes to the existing network lines. I able to connect nodes with lines using connect nodes to lines in Networks in QGIS ...
- 865
5
votes
2
answers
1k
views
Connecting points with line using virtual layer in QGIS
I have 10 points in QGIS layer as shown in Image 1.
I am trying to connect points with lines in required sequence as shown in Image 2. However, when I tried to connect all points with virtual layer, ...
- 865
4
votes
2
answers
806
views
Connecting points with line in a specific sequence
I have 6 points in one layer as shown in the first image. I am trying to:
connect points with lines in a required sequence.
Save data of line connections (From_point and To_point) in the seperate ...
- 865
8
votes
1
answer
373
views
Connecting points with lines and saving starting and ending points in new layer
I have 3 points in one layer as shown in the first image. I am trying to connect a building points with junction point by 2 lines. For demo, I have manually drawn a lines in image 2. Here, I am trying ...
- 865
1
vote
0
answers
37
views
Connect to single table within a MSSQL database or terminate connection to database once layer added to QGIS project?
I'm connecting to MSSQL server '123' that contains 100s of databases and I am connecting to just database 'ABC'. 'ABC' contains roughly ~700 tables. Once I add the 'xyzTable' as a layer to my QGIS ...
- 11
3
votes
1
answer
116
views
Saving Starting / Ending points of connecting line in attribute table
I have 3 layers ( 1 line and 2 points) as shown in image. The layer id,s are mixture of integers and text such as cable4389175, node1 , service_point5316. I connect the two point layers (node and ...
- 865
1
vote
0
answers
227
views
Create PostgreSQL ODBC Excel table
I want to allow a non-GIS user edit a CSV file which is hosted on QGIS Cloud on a PostGIS database. My method is to load the table from the QGIS Cloud database into Excel via ODBC.
Here are my steps ...
- 2,139
2
votes
1
answer
1k
views
Opening gdb in QGIS
I have been given an ESRI gdb file by a vendor. I can connect it in the usual fashion in QGIS but it only shows a couple of the layers that are contained and they show no entities in them.
Has anyone ...
- 575
4
votes
2
answers
2k
views
Connection to ArcGIS Server via QGIS fails
I am trying to load this map that comes from an ESRI Server in QGIS.
I tried two different ways:
DATA SOURCE MANAGER / PROTOCOL HTTPS or FILE and then adding the URL. When I do this it fails and ...
3
votes
0
answers
312
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 ...
- 31
0
votes
1
answer
1k
views
Extending lines using ArcGIS Pro
I am using ArcGIS Pro 2.6.1.
I have massive map of roads in multiple road files. I need to extend lines to their intersect point. Intersect tool does not seem to work to my satisfaction. Any other ...
- 65
0
votes
0
answers
26
views
Connecting ArcMap to secure folder
I am accessing data from a National Data Services secure server. Within the server, all my project data is in one folder, and applications like ArcMap are in a separate folder.
In ArcMap, "add ...
- 23
2
votes
1
answer
274
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(...
- 14.7k
1
vote
2
answers
372
views
Creating linear connections among points
I would like to create in an automatic way a linear feature representing the connections among all points using ArcMap or Python.
That is I would like that each point is connected to the others one ...
2
votes
1
answer
120
views
Use QgsAbstractProviderConnection in PyQGIS (3.14)
I created a PostGIS connection named 'test_conn' and try to access it via
from qgis.core import QgsAbstractProviderConnection
con = QgsAbstractProviderConnection('test_conn')
as described in ...
- 14.7k
3
votes
2
answers
125
views
Measuring distance between certain relations in QGIS
I need to measure the direct distance between busstops in meters, not taking roads/networks into account.
I have the WGS 84 Coordinates + globalIDs for 28.000 pairs.
I already imported the Busstops ...
- 31
0
votes
1
answer
1k
views
Connection failure to WMS/WMTS or WFS
Why can't I connect to any of the Web Map Services (WMS/WMTS/WFS) in QGIS?
I don't think its a problem with the servers I'm using, but more about QGIS not being connected to the internet maybe.
The ...
- 9
1
vote
1
answer
378
views
Loading layers into QGIS - Heavy work in the background - Too many clients already
I am 3rd year geoinformatics bachelor student currently developing a QGIS plugin that will allow me to import a larger number of layers from the data storage (Postgres) into the software. For the ...
- 19
0
votes
0
answers
85
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 ...
- 113