10

That error message is coming from PostGIS (well Postgresql) and is saying that it "sees" you but that there is no entry in the pg_hba.conf file for the IP address you are coming from. You need to log on to (or ask your sysadmin) to edit the pg_hba.conf file to add 172.20.10.2 to the list of acceptable hosts. Another option (if your server supports SSH) is ...


7

Will is correct. You need a geometry_columns table. Without the geometry_columns table QGIS scans each table in order to find the type and srid. The CREATE script looks like this: CREATE TABLE [dbo].[geometry_columns]( [f_table_catalog] [varchar](256) NOT NULL, [f_table_schema] [varchar](256) NOT NULL, [f_table_name] [varchar](256) NOT NULL, ...


7

The ArcGIS 10.1 Help indicates that you cannot edit the attributes of Excel or MS Access files, added through an Ole DB connection, because they have no ObjectID field. You can Copy the data to a fGDB table and then edit it. Or you can script Python to edit the native MS formats.


7

It definitely works when you are zoomed in to a coal mining area beyond 1:70K. If you check the getcapabilities you can see the MaxScaleDenominator is set. I suspect the server is calculating that in the internal projection of the data which is EPSG:27700 (again I'm guessing but it probably is) so if you are viewing in EPSG:4326 (as you are) then you seem ...


6

You could create temporary connection files through a combination of the tempfile module in the Python standard library and the Create Database Connection Geoprocessing tool. Your config file could be read in your script, used to make a temporary connection file, establish your Query Layers, and then delete the connection file.


6

The default behavior is to let connections remain active, so the real issue is likely the feature in your environment which closes open TCP/IP sessions: Firewall configuration Antivirus applications Network switch configuration Nightly database restarts Nightly application server restarts TCP-Keepalive timeout configuration "Sleep" mode on servers Your ...


6

I think it has to do with zoomscale. This map http://mapapps2.bgs.ac.uk/coalauthority/home.html seems to use the same services. Checkboxes are greyed out till zoomed in enough.


6

You are trying to load an ArcGIS FeatureServer into QGIS and don't need the export you added. Simply open the Data Source Manager (Ctrl + L): Go to the ArcGIS Feature Server tab and click on New: In the create new arcgise feature server window, give your layer a name and insert the URL (https://egis.fire.ca.gov/arcgis/rest/services/FRAP/ownership/...


5

There is a note in the doc: Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case. so you may want to rename your DB.


4

It doesn't look like it is included in the most recent GDAL-Complete framework. Please file a request with kyngchaos.com. In the meantime, if you don't mind trying it yourself, you can attempt to build a shared plugin for GDAL 1.10, install it, and see if it works with your data source: Ensure you have XCode and/or its command line tools installed. ...


4

Using Microstation v8i required: [Postgres ODBC Driver installed] only options are ODBC Oracle OLEDB BUDBC [ODBC} Open Microstation Settings>Database Connect to Database click search (magnifying glass) Select Data Source Machine Data Source New> PostgresSQL35W (unicode) [Postgres Driver required] environment/user/password settings Postgres Connection ...


4

After several days of interaction with ESRI tech support it turns out that the issue stemmed from having setup an organizational account with ArcGIS online after already logging in at one point with a personal account. Because the organization was not setup at the same time as the first initial install, I had only the default portal connection (www.arcgis....


4

This has been partially answered in other posts: Remove username and password from saved arcgis layer (.lyr) files?, Changing workspace path of query layer using ArcPy? and Is it possible to set data source of ArcMap MXD via replica MXD on remote server?, but I want to make it exceedingly clear here. Non-Solution: You might be thinking: Ahh..Just go ...


4

I would suggest two approaches: 1. You use Network Analyst to build a network dataset (ND) from your raw street feature class. Choosing the "Any Vertex" connectivity would create a junction point feature at each street intersection which you can export and use just like any other point feature class in ArcGIS. Start with this tutorial, the best ...


4

Digitizing a straight line between two points using snapping Create a new layer Skip this step if you already have a layer to which you want to add lines. Layer menu > create layer > New Shapefile Layer... (or geopackage or spatialite, whichever format you prefer) Click the ... button, choose a folder and type a name for your new shapefile. Choose "...


4

Works with this code: p = QgsProviderRegistry.instance().providerMetadata('postgres') con = p.connections()['test_con'] con.executeSql('SELECT * FROM mytable')


4

Based on your quesion and code I think you're after something like this: import arcpy, os, itertools arcpy.env.workspace = r"C:/test/Test.gdb" # could be trouble if arcpy.env.overwriteOutput is False and the feature class already exists arcpy.CreateFeatureclass_management("C:/test/Test.gdb", "linea", "POLYLINE") # I ...


4

You're right. It seems that, in the future, all data providers will be fully implemented in that way (known as Connections API). Nowadays, some providers are not there yet. Even more if you're not using the cutting edge of QGIS versions. FYI, running on QGIS master (built today), I can perfectly access SpatiaLite connections in the expected way: ...


4

Solution with algorithms and expressions For the fist part of your problem : You could use the geometry by expression algorithm and use this expression : collect_geometries( array_foreach( aggregate( 'LAYERNAME' , 'array_agg', "mrid", filter:="id" = attribute(@parent, 'id')+1)...


3

Since ArcGIS is 32-bit, you will also have to make sure to install the ORACLE 32-bit client. If you have installed the right version and it doesn't work, I'd contact someone who can give support on the ORACLE part.


3

If i got you,you have common field among tables so better to use Join command and export the result to get a combined feature(composite). This will not add geometry to the composite but only features' attributes only. N.B.If you are working with lot of data then take different approach, i mean you need to use RDBMS where you will link both table using ...


3

I had the same problem.Specify SRID as 4326 or something relevant.I am not sure QGIS cannot detect SRID automatically.


3

I think you're confused because the linked thread makes no mention of ArcGIS Server. When they mention "Server" they mean the server onto which the licence manager has been installed - this could be any server (but preferably it's a resilient one because if it goes down then it takes down all your GIS users with it). Without knowing your network ...


3

You will by-pass SDE control and will get all of the oracle spatial tables. Example: (DB/IP/Username has been changed) Database:Name of the Master database you are connecting to: Host:IP of database (must be unique) Port: Oracle is on 1521 (default) Username:username (must be a USER not DBA or superuser) Password:password (you MUST ...


3

The "Unable to establish a connection to www.arcgis.com." error message indicates a connectivity problem between ArcGIS Pro and arcgis.com. It is quite possible that something else happened on the first machine around the same time you installed Pro on the second. I can't think of a direct connection between the second install and the connectivity failure. ...


3

You either need to enable it as a windows service, or start it manually. Windows services can be slightly tricky, I would first do the manual step of starting it via the CMD line as documented in this stackoverflow answer https://stackoverflow.com/questions/5881845/how-to-manually-configure-and-start-postgresql-on-windows Also I believe that to install ...


3

QGIS does not support SSH tunneling currently, it is supported by the PGAdmin client. You can edit the servers pg_hba.conf file to accept external connections and make sure your servers port is listening on 5432, may be worth securing the connection on 5432 to your IP. The other option is making your own SSH tunnel, I don't have any experience on this ...


3

To calculate the road density per unit area you could overlay a grid and then sum length per cell. In QGIS there is an analysis tool called Sum Line Length which does exactly this. This would ignore the point layer though. The grid can then be styled using either the count or summed length fields as a measure of the density.


3

I would suggest using raster analysis for this problem. Converting the road network to a raster and performing proximity analysis (using Arc or QGIS) should result in a raster of continuous values representing distance from the nearest road: Next, we create a polygon shapefile of the area contained within the streets. And lastly, utilizing Zonal Statistics ...


3

There is no connection limitation if you're using version 2.13.x (warmly recommended, it's significantly faster than older versions when it comes to geopackages), but you'll eventually hit the max number of open files limit (which you can raise, in different ways according to the operating system in use).


Only top voted, non community-wiki answers of a minimum length are eligible