Questions tagged [connection]
for questions related to the connection of some GIS software to a database
101
questions
0
votes
0answers
16 views
Can't connect to PostGIS from Mapnik Python script
I Want to create WMS Server using Python with Mapnik and PostGIS.
I have successfully posted a shapefile into PostGIS database using shp2pgsql. I want to fetch the data of my table into Mapnik using ...
4
votes
1answer
85 views
Connect points with line using virtual layer
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, ...
4
votes
2answers
98 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 ...
8
votes
1answer
112 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 ...
1
vote
0answers
24 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 ...
3
votes
1answer
35 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 ...
1
vote
0answers
41 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 ...
1
vote
1answer
46 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 ...
4
votes
2answers
115 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
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 ...
0
votes
1answer
69 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 ...
0
votes
0answers
23 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 ...
2
votes
1answer
71 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(...
1
vote
2answers
106 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
1answer
30 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 ...
2
votes
2answers
57 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 ...
0
votes
1answer
143 views
Connection failure to WMS/WMTS or WFS
I can't 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 pop-...
1
vote
1answer
141 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 ...
0
votes
0answers
38 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 ...
1
vote
1answer
93 views
Error Loading .xml file to WFS in QGIS
In this link xml-link, there is a .xml file from a website (WFS) which contains vector data regarding water bodies for a specific area. I saved it as .xml by just right-clicking -> "Save as" and I ...
3
votes
0answers
42 views
Reduce QGIS project needed PostgreSQL connections
I have a QGIS project, based on data from a PostgreSQL database. The project should be used by a lot people from my company. In a performance test I noticed, that every person, who opens the project ...
0
votes
0answers
19 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 ...
1
vote
1answer
340 views
GeoServer Connection Pool uses most available connections and not releasing them
We are using GeoServer with a geoserver cache for some layers. Most of our layer updates frequently and therefore we do not want to setup a cache for them (they do have in memory cache though).
...
1
vote
0answers
20 views
Distance from points to points in the same polygon
I have 2 point layers and 1 polygon layer. I want to find distance nearest between this 2 point layer, but they must be in the same polygons.
I used distance nearest hub, NNJoin, MMQgis but they just ...
1
vote
0answers
52 views
Carto trying to set syncing with a PostGIS database connection
I'm trying to set up a syncing connection between Carto and a PostGIS Table. However, I'm not seeing updates in Carto, and the table does not show up in my list of syncs when I make a Get request.
...
1
vote
0answers
73 views
Data upload error in QGIS cloud
I want to publish my .shp file but I am facing one uxpected error.
could not connect to server: Connection refused (0x0000274D/10061) Is
the server running on host "db.qgiscloud.com" (136.243....
1
vote
0answers
100 views
Connecting to PostgreSQL database from another machine using QGIS?
I have a database with name "Test" in PostgreSQL 11 in my machine, I can connect to this database from my machine using QGIS with host localhost, but when I tried to connect it from a different ...
0
votes
1answer
375 views
Create different Server Database Connection file for ArcGIS Server
I would like to register database with ArcGIS Server. I know it is done through ArcGIS Server Manager under Site / Data Stores / Register: Database.
I am also aware there can be different connection ...
0
votes
1answer
51 views
Connection QGIS 3.4.5 / PostgreSQL 9.3 with role group [closed]
I created 2 connection roles with PostgreSQL. Then, to manage more easily the privileges, I created a group role includind these roles (inherit).
I created a trigger which track data changes. I used ...
0
votes
1answer
48 views
Arcpy SDE Connection Getting Invalid Path? [closed]
I literally copied and pasted the file path (r'C:\Users\myName\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\mydatabase.sde'), but after I run my script, I always get the error saying error 267, the ...
3
votes
1answer
674 views
From QGIS 3.4.5 and 3.6 asks password repeadly to connect to PostgreSQL 10 [closed]
Action: At first time when opening project on QGIS 3.4.5 and 3.6 versions needs credentials to connect to PostgreSQL DB.
Problem: But after that when connection is success with correct credentials ...
1
vote
0answers
53 views
ArcPy not seeing ArcSDE datasets from IDLE or PyScripter? [duplicate]
I tested the code below from ArcCatalog 10.5's python console and IDLE+PyScripter. While in ArcCatalog everything works correctly(code is supposed to list available datasets and feature layers), in ...
2
votes
1answer
1k views
Connect points in two layers using lines in QGIS 3.x
I'm using QGIS 3.2.1 and I have two Layers containing point objects, Is there any plugin for this version of qgis that I can use to select two points and then connect them using a line and save the ...
0
votes
1answer
241 views
Connecting to several WFS using python/OWSLIB/OGR2OGR
I'm trying to download a lot of datasets from different WFS URLs using ogr2ogr (and to an extent, owslib) in Python. My problem arises when I try to connect to a second WFS.
In my test code, I have ...
0
votes
1answer
456 views
Accessing ArcSDE feature class with ArcPy?
I have a script that runs perfectly with shapefiles and GDB feature classes but I need to change it to run on feature classes stored on an SDE. However I cannot figure out how to reference them ...
1
vote
0answers
730 views
Can't connect with my PostgreSQL database with ArcGIS
I have created a database in PostgreSQL, spatially enabled it, and now I need to connect it with ArcGIS (we use only ArcGIS products here on my university), everything on localhost, I've tried ...
0
votes
1answer
840 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 ...
1
vote
1answer
269 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 ...
2
votes
1answer
1k views
General Function Failure: failed to connect to database
I am trying to access the file geodatabase and I get a message of General Function Failure: failed to connect to database. I can access other file geodatasabses, the problem is only with this one. I ...
0
votes
1answer
861 views
Getting user password from ArcSDE using Workspace Properties - python
Looking at this page for getting Workspace Properties I am wondering if there is a simple way to get a Users password from an existing SDE connection on the users machine?
Using the code sample from ...
3
votes
0answers
205 views
Loading Postgres layer with Session parameter (SET) using Pyqgis
With postgreSQL 9.5 and +, there is a policy feature that handle row-level access which is great.
My special case is to use this feature to control access to a multi-user postgres DB.
Here is what i'...
3
votes
1answer
2k views
Database Connection error: Invalid database name
I just created a new database in my Postres called GlenMary and I can't get ArcMap to connect through my already established database connection in ArcMap. I am trying to add some new data to the ...
1
vote
1answer
533 views
Connecting ArcGIS Desktop to remote PostgreSQL database?
I have setup PostgreSQL 9.5 on my local machine. I am trying to create a database connection from a coworkers laptop on the office network (let's say the network IP is 192.168.1.X). My database server ...
0
votes
1answer
48 views
Geoserver H2 datastore trying to connect to old private IP and failing/timing-out
Restarted my ubuntu EC2 instance, which changed its' private IP
Tried to preview a geo-server image-mosaic layer which was using the H2 datastore
Kept on getting this exception -
org.h2.jdbc....
6
votes
1answer
769 views
PyQGIS - Adding layer from PostGis database [duplicate]
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", ...
3
votes
1answer
197 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 ...
2
votes
2answers
558 views
The average distance between the roads
I have two vector layers.
Roads Line layer
Roads Point layer
I want somehow to get the average value of the distance between each roads and get average value for my region. Each road has its own ...
1
vote
0answers
156 views
Get username info from active connection in Mapbasic [closed]
I'm trying to retrieve information on username from active connection (SQL Server Express) in MapInfo 11.5 32bit. First I tried using Server_ConnectInfo( ConnectionNo, SRV_CONNECT_INFO_SQL_USER_ID ) ...
1
vote
1answer
91 views
Digimap OpenStream timeout
I am having trouble with an WMS layer that calls the Ordnance Survey/Digimap OpenStream data, but however I call the layer it times out without ever displaying a map.
I have registered with Digimap ...
11
votes
2answers
3k views
Connecting QGIS to a Remote PostgreSQL database using an SSH key?
I have created a username,password & ssh key with root privileges on a remote server (Vagrant) and I am attempting to connect via the usual methods but my password authentication fails. I can ...
