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 ...
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,
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.
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 ...
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.
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:
Network switch configuration
Nightly database restarts
Nightly application server restarts
TCP-Keepalive timeout configuration
"Sleep" mode on servers
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/...
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
so you may want to rename your DB.
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.
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....
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.
You might be thinking: Ahh..Just go ...
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 ...
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.
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 ...
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:
Solution with algorithms and expressions
For the fist part of your problem :
You could use the geometry by expression algorithm and use this expression :
filter:="id" = attribute(@parent, 'id')+1)...
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.
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 ...
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 ...
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 ...
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.
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 ...
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 ...
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.
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 ...
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).