9

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

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

The ArcGIS 10.1 Help indicates 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.


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.


4

Yes, you can do something like: try: if arcpy.Exists(PropertyTax_Parcels): arcpy.AddMessage("Checking core Layer found? Yes and online") except: raise Exception("Layer not found") You just define it as a static layer in your SDE and if so it can continue; other wise you else out of the script. I do this in many places and will ...


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 getting ...


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 "...


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

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

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

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

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).


2

Yes. Yes. a. See ESRI help configuring one machine arcgis for server (Linux). b. See also database connections in arcgis desktop for specific Postgres instructions Yes see ESRI help setting up a connection in PostgreSQL. You would need to connect from desktop and copy the connection file to the server. a. You also need to register the database ...


2

You need more than just an internet connection. if there are published ArcGIS Server (AGS) layers you would have access to whatever is website. if you have network access you would need the connection string. With AGS you have wms, wfs, and geodata services that can be consumed over the web. As far as sde you would need vpn, or some other direct ...


2

Any answer is going to be semantic in nature - your definitions of upstream, tributary, network, etc. are going to dictate the answer. From a network (continuously connected features) point of view, I'm going to go with there is no difference and you cannot have a water body upstream of another without it being tributary. If you do have one that isn't ...


2

The issue may be that your trying to access an older version that isn't compatible, administrative connections can only be made with ArcGIS Server and ArcGIS Desktop products that are on the same version. ESRI has a a technical article on an error message that may be relevant to your issue here


2

You can create a new dialog as a class, even in your main .py file. class NewDialog(QtGui.QWidget): def __init__(self, parent): super(NewDialog, self).__init__(parent) Than in your main class you can put function like that: ... def open_new_dialog(self): self.nd = NewDialog(self) self.nd.show() ... This function creates a new dialog and ...


2

Well, just as a conceptual framework, what I picture helping you solve this challenge is roughly as follows. First, in the MS Access Database you would need to use Macros, calculated fields, or some other method to ensure there is an automatically populated "last updated" type field for relevant tables, so any time a new record is inserted or an existing ...


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