Latest Contributions by MarcoBoeringa

Megan White‌, I may not have to tell you this, because you may already be fully aware of it, but I am always highly wary of seeing people "automate" kriging interpolation... Kriging, by its very nature, is an interactive process that IMO should not be automated. It is actually the process of exploring your data using semivariograms, crossvalidation and other tools like the ones available in Geostatistical Analyst, that make kriging a superior interpolation method over most other ones, and allow you to achieve scientifically sound quality results. ...or discover that your data set is unsuitable for interpolation! - I still quite often see people trying to interpolate stuff even in the light of exploratory data analysis showing that they shouldn't interpolate the data. Some data sets inherently cannot be reasonably interpolated, e.g. when there is almost no spatial autocorrelation between points, and likely need other kinds of statistical analysis using tools like R or SPSS. People often seem to forget this, in a desperate attempt at all cost to create a surface covering data set from a set of point measurements. Doing away with all of that by "automation" may lead to erroneous results. I also think the kriging interpolation options of Spatial Analyst are unsuitable for truly scientific results (that is quite a thing to say for me, because I was the original author back in the days of ArcView 3.x of the "Kriging Interpolator" extension that build upon the Spatial Analyst tools to provide a more user friendly interface). I especially say this in the light of the Geostatistical Analyst, that provides far superior options for exploratory data analysis and validation of interpolation results. ... View more

If you are working with a File Geodatabase, like you do, then setting NULL means using None in Python, there is no NULL concept for setting values in a File Geodatabase to None / NULL, you should use None instead as in the code example. Remember: You are writing Python code here, which is not the same as defining SQL statements for use in ODBC. If you are working with an Enterprise Geodatabase and writing DML SQL statements and sending them through e.g. ODBC, then yes, you can set the values to NULL, in a DML SQL statement. ... View more

None is more or less the Python equivalent of NULL in a database. You are writing Python code, not SQL, here. Unless you are executing SQL through ODBC with something like pyodbc, and emmitting queries like <FIELD> IS NULL you generally would only use None in Python code. If you want to insert empty strings instead of None, you could simply use row[0]='' ... View more

To add to what Robert Scheitlin, GISP wrote, historically, it is actually a Google designed data format (Protocolbuffer Binary Format). It is now widely used by big name companies like Google, Mapbox and now ESRI to effectively distribute vector based geographic data, e.g. in Vector Tiles, and is the main data format for distributing OpenStreetMap data. One of the main benefits is that it is a very compact data format, and is fast to process with currently available tools. ... View more

Definitely don't expect any miracles from a VM. A VM is just another virtual computer, and as such limited by the same constraints that are valid for your own desktop. A virtual processor is still tied to a core somewhere on the globe, and those cores may even be worse in single thread processing than your local PC if you are unlucky. Only when your geoprocessing tool supports parallel processing, could you see benefits of some VM with many virtual cores or GPU based processing. But unless you're willing to pay a significant sum, a truly powerful VM may be out of reach, unless your university offers specialized computing services for students. Maybe cutting up your raster data set in smaller units, and compute those individually (in parallel), on multiple cores of your current machine, or multiple computers at the same time in your department, is the best bet to get results faster. ... View more

If these rail and bicycle path lines are in one and the same layer, you likely need to set the Symbol Levels to get the data to display and export right. I recognize the issues you describe, but setting Symbol Levels has always proven the reliable way out of these issues. Note though, that web services do not support this properly, so if your ultimate goal is to create web services, you may need to choose different types of symbology, or separate the classes in their own layer. Also, using symbol levels adds extra drawing cycles to ArcGIS, meaning display times will suffer. Usually not an issue if your main goal is to export to high quality cartographic PDF output, but it may be an issue in other cases. ... View more

Hi Adam, Note that you will not see the actual geoprocessing tool listed in pgAdmin. Instead, the ArcSDE application is what handles the SQL communication in the background with PostgreSQL. To access that information in pgAdmin: - Click on the database in the left pane - Click on the Dashboard TAB in the right pane if it isn't already visible - In the Server activity pane on the bottom, choose Sessions if it isn't active - In the displayed list of sessions, look for your user name and / or IP address in the User / Client columns and a session with "ArcSDE" in the Application column. - Check that the State is active. In the example below, only the postgres user has an active status, but this was just an example screenshot. Idle sessions should be ignored, they are no longer active. - Click on the little black arrow in the third column of the display of an active session to open a drop down that shows the Details of the active session. - You can now see the SQL being executed at this moment. Note that the Server activity details pane is not automatically refreshed, use the refresh button in the top right of the details pane to update it. It is easiest to do all of this on a database not used by hundreds of other users, as you will immediately see the proper user / IP address, instead of potentially hundreds of sessions in the Server activity pane. ... View more

You really should open up pgAdmin, the database manager tool of PostgreSQL, to truly see what is going on. E.g., if you deleted only a selection of the rows of a (very) large table, and the Delete Row tool triggers a VACUUM FULL on your table, then PostgreSQL may have spend the excess 34 minutes re-writing the entire table in the background to remove dead tuples / rows and optimize the table by re-claiming disk space. Some database operations are inherently costly, and may not show progress (although it would be a good thing if geoprocessing tools in applicable cases and where possible showed at least a warning message if such situations are occurring). Note that in case you intend to delete all rows of a table, the Help justly recommends using the Truncate Table tool instead, which will be must faster / instantaneous. ... View more

Do you actually need an ESRI "Geo-"database, or just a "spatial" database? Setting triggers and stored procedures on an ESRI Geodatabase is generally not recommended, as you may be trashing the geodatabase by your stored procedures and triggers interfering with the ESRI designed ones and data model. If you just need a spatial database to store stuff, and want to manage it yourself, you can use the pyodbc Python package that is part of the package list in ArcGIS Pro in the Python Package Manager, to insert data in the database through cursors, and use database DDL and DML statements via ODBC to manage your database. You can subsequently access the created data by running the Add Incrementing ID Field tool to add an objectid field (or manage a similar unique ID field yourself), and then use ArcGIS Query Layers to add the data to ArcGIS as read-only layers (that can however be input to other tools). I have done all of this based on a PostGIS database installed on Ubuntu running in Oracle's Virtualbox virtualization environment on a Windows 10 host. It takes time to get familiar with all of this, but is do-able. Of course, since you are not going to create an ESRI Geodatabase through this method, editing data, and using any of the advanced Geodatabase behaviors and functionality, is out of the question. Be aware of that (Actually, editing data may be possible through a web Feature Service, but I have never tried that and it requires ArcGIS Enterprise / Server to publish the service, also see this link for information regarding accessing a non-geodatabase spatial database: Databases and ArcGIS—Help | Documentation ). ... View more

I noticed the "Extract Data Task" screenshots also show a "Raster Format" parameter, and set to "ESRI GRID". ESRI GRID is an old format, and could be finicky with file paths, especially things like spaces or special characters, that you should avoid. Is the "Raster Format" parameter actually used in your case? If so, maybe trying to switch to another raster data format might help. Secondly, I see in one of the screenshots, just before the other "Failed" messages, a "Consolidation Failed" message. I see some other messages about e.g. lack of disk space on the drive where consolidation of data takes place, or the consolidation process not being able to find the data involved, in this older thread: https://community.esri.com/thread/56303  The link above also in one of the posts there, points to a setting that is also in ArcGIS Pro (Go to Options/Share and Download in Pro), where you can set where to "consolidate" the data before publishing. Maybe trying to set this folder to another drive (it defaults to your user profile which may be resource limited in your organization), and using a shorter path, may help. ... View more

Jamal NUMAN‌, I wonder if this is a regression bug in Pro 2.5? I am still at 2.4, and in a similar case, I can pan through the model, and the Pan tool isn't disabled as it is in your screenshot. Can you also confirm that you were able to do this in 2.4? Screenshot from my Pro 2.4: ... View more

To be honest, I have a hard time understanding the problem from your explanation. For now, I would like to point out some of ESRI's Heather Smith's recent blog post about coordinate systems, that may be of some help in understanding differences between GCS and PCS etc.: Geographic vs Projected Coordinate Systems  Coordinate Systems: What's the Difference?  Projection on the fly and geographic transformations  ... View more

I do also recommend to regularly clear out the geoprocessing history in Pro. Just like in ArcMap, Pro accumulates a lot of junk in the geoprocessing history, which can significantly bloat the project file (this was also a problem in ArcMap, I once had an mxd of > 50MB due to this), and slow down save and open times of projects. ... View more