Questions tagged [connection]

for questions related to the connection of some GIS software to a database

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
105 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
0answers
517 views

Connecting QGIS 2.x to Firebird Database via ODBC?

I tried to connect a Firebird Database in QGIS 2.2 and 2.4 via ODBC to a database and get following error message: Unable to initialize ODBC connection to DSN for SYSDBA/masterkey@Akdees [...
2
votes
1answer
78 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 ...
2
votes
0answers
98 views

MS SQL Layer - Losing LineStrings (Polyline) from SQL Server to QGIS

I have a table called [gfts].[Shapes] which contains a primary key shape_id and a geography data type GEOM. When I query the table in SQL Server I get the following Spatial Results: However, when I ...
2
votes
0answers
1k views

Creating new PostGIS connection in QGIS?

I am trying to create a new PostGIS connection and I am doing as it follows: The password I inserted is postgres, I don't know what should be inserted there. And when testing the connection, I get ...
1
vote
0answers
18 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
45 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
35 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
550 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 ...
1
vote
0answers
38 views

Auto-fill attribution of similar feature classes via connectivity rules (Geometric Network)

I am working with water utility data. I am trying to figure a way to make feature types connected to the Mains (primary distribution water pipes) automatically fill certain attributes when they are ...
1
vote
0answers
383 views

Error Opening WMS Maplayer: URLError: <urlopen error [Errno 10060]

I receive the error: URLError: <urlopen error [Errno 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection ...
1
vote
0answers
925 views

Why does QGIS not show my new geometry columns?

I am trying to connect a few PostGIS Tables to Quantum GIS. The problem is that the geometry columns QGIS is showing are not the ones from the PostGIS database. QGIS shows me some columns I used to ...
0
votes
0answers
13 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 ...
0
votes
0answers
148 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
621 views

Using an ArcSDE Connection through Python

I would like to run a script on a ArcSDE feature class. The script runs perfectly when I hard code a shapefile, but is unable to connect to an ArcSDE database. The purpose of the script is to assign ...
0
votes
0answers
227 views

Connect two points with fixed longitudinal slope over DEM - QGIS

Is it possible to connect two points with fixed longitudinal slope over DEM terrain or connect points with maximum longitudinal slope? Make road line between two point, for example 7% or make it with ...