Latest Contributions by AndresCastillo

https://gdal.org/drivers/vector/filegdb.html#requirements provides a link to the FileGDB API SDK.   The link takes you to Esri's appsforms download page to download the proper zip file for your OS.   You can also find the drivers in the Esro github repo: https://github.com/Esri/file-geodatabase-api Notice the required OS and versions   This GIS thread gives an example by ThomasG77 on how to compile and configure the driver in your system: https://gis.stackexchange.com/questions/386112/exporting-many-tables-from-postgresql-to-gdb-using-ogr2ogr   For windows, I ran the express install of this: https://trac.osgeo.org/osgeo4w/ Once installed, I ran the installer again, but this time with the Advanced install option, and search then install the FileGDB plugins. ... View more

Here are other resources available on the topic: https://gis.stackexchange.com/questions/203809/publishing-map-services-in-arcmap-gives-error-001487-failed-to-update-published   https://pro.arcgis.com/en/pro-app/2.9/tool-reference/tool-errors-and-warnings/001001-010000/tool-errors-and-warnings-01476-01500-001487.htm   ... View more

The error I had came even though the data was not referenced. The data was being copied to the server, I suppose the Managed ArcGIS DataStore of the Hosting Server. This was the error: WARNING 086223: Jobs directory in service definition is not set or is invalid. Using default jobs directory. Creating the service. ERROR 001487: Failed to update the published service with the server-side data location. Please see the server's log for more details. ERROR 001369: Failed to create the service. Failed to execute (Publish Service Definition).   This was due to some parameters in my Modelbuilder model that were set as Constant values in the result of the geoprocessing history, and shared as a web tool. When you right-click the model>edit metadata, the item description page appears. In there, there is a section where you can specify the syntax of the model parameters by providing a dialog explanation for them. I was providing a dialog explanation for the 'output_gdb' (a workspace variable), the 'excel_csv_output' (a folder variable), and 'analysis data' (a folder variable). My theory is that by doing this, it was forcing the staged web tool to try to copy these workspace and folders to the datastore, but the directory structure was not available in the datastore. The web tool would maybe then no longer use the default workspaces and folders in the datastore. I was able to publish successfully once I removed the dialog description for these workspaces and folders.   ... View more

I'm thinking that one may want to make one spatial query layer for each geometry column in the table. As a result, one would have the same number of layers representing that table as the number of geometry columns. Just in case, here is how we can query for the spatial columns in a table that's not registered with the geodatabase: https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/geometry-columns.htm   Relevant forum in qgis: https://gis.stackexchange.com/questions/109599/how-to-display-a-table-with-more-than-one-geometry-column-in-qgis ... View more

The docs have this article: https://pro.arcgis.com/en/pro-app/latest/help/analysis/geoprocessing/share-analysis/00256-server-version-value-tool-value-does-not-have-new-parameter.htm Unfortunately, I am seeing on my end that it is not possible to not use the unsupported parameters, since they are used by default, and not anywhere I can specify them on the CalculateField tool. One alternative in case the ArcGIS Administrator does not have a plan to upgrade ArcGIS Enterprise is to downgrade ArcGIS Pro to the version compatible with the ArcGIS Server tool. Another alternative would be to convert the model to a a python script, and use UpdateCursor from arcpy's "Data Access" (da) module. https://gis.stackexchange.com/questions/138492/calculate-field-management-not-working-within-customized-python-tool-in-arcgis ... View more

Thank you @curtvprice , This makes a lot of sense. I notice a scenario in which there are additional things that would affect the ability to set the element to intermediate data. Even a data element is 'truly intermeditate' as you have described above, if that intermediate element is connected downstream to both a tool that 'consumes' the dataset, and a tool that 'creates a layer view that points to the dataset', the option to set intermediate disappears. In my case, the output to the 'Copy Features' output was not able to be set as intermediate, even though it served as input to both the 'Table to Excel' (consumes the data) and 'Select Layer By Attribute' (makes a view of the data) GP tools. See the attached pictures of how the 'set intermediate' option appears once the downstream links are removed to the 'Select Layer By Attribute' gp tools. @RobBlash  According to your clip 2 above, that seems to be what is going on. @DanPatterson_Retired   I am able to set variable as intermediate in ArcGIS Pro 2.8.8 still. ... View more

PostGIS has a similar tool: https://postgis.net/docs/ST_Difference.html ... View more

If you have two polygons, 'A' and B', run the tabulate intersection tool. Suppose 'A' has zone fields you want to summarize with. The result will give you an output table that has the percent of the zone field in A that is covered with B. you can then join this output table back to the A feature class, keeping all target features, and sort on the joined object id to see all of the records where the joined attributes are null (i.e. null objectid's). This will tell you with A polygons had 0 coverage from the B polygons. https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/tabulate-intersection.htm ... View more

Seems like ArcPy is too big to fit into lambda restrictions: https://community.esri.com/t5/python-ideas/allow-arcpy-to-be-loaded-and-executed-through-aws/idi-p/1063441 There should be other alternatives to explore, such as AWS Fargate, or AWS Batch ... View more

@JonNordling1 , I believe if you use the checkOutextension function in the uploaded lambda script, it becomes a matter of access. If the aws environment where the lambda is deployed has port access to the license manager, it should be able to grab the license for the script. I have not verified this, but this are my thoughts on this. ... View more

This is gold. ... View more

This Action worked for us in the bucket policy:             "Action": [                 "s3:ListBucket",                 "s3:List*",                 "s3:Get*",                 "s3:PutObjectAcl",                 "s3:ReplicateObject",                 "s3:ReplicateDelete",                 "s3:ReplicateTags",                 "s3:ObjectOwnerOverrideToBucketOwner"             ], ... View more

Found some doc on the above: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/dbms-support.htm Although PostgreSQL allows user accounts to write data to schemas of any name, ArcGIS requires that user accounts that create tables, views, or other objects in the database have identical user names and schema names. For example, you cannot connect from ArcGIS with the user name vlad and write to the public schema. ... View more

I tried a different s3 acs file with other contents, and tif files showed up. Maybe the limitation is that Drone2Map cannot read  for jpg files in acs files. ... View more