Python tools automating day-to-day tasks with ArcGIS Enterprise
My intention is to collect the tools that I am writing here in this repository.
The apps.code-workspace file here helps me to edit our apps and our maps.
Visual Studio Code, which allows me to specify a Conda environment as a setting.
My approach is to tell Conda I want 'arcgis' and then let conda dependencies install everything else, s electing the version of python, pandas, etc that it wants. This way everything will work together.
I am relying on features in version 2.x of arcgis python api.
You need python-dotenv to run from command line, and autopep8 to keep VS Code happy.
I hate cloning the old ArcGIS Pro environment because then it's painful to upgrade. Currently, arcgis and arcpy will determine which (out of date) version of python will be selected. Today it's taking infinite time to 'conda install arcpy' so I am using 'clone'. Sigh.
You can create profiles with a couple lines of Python. Run this in a Jupyter notebook, for example.
from arcgis.gis import GIS
ago = GIS(url="https://clatsopcounty.maps.arcgis.com/", username="bwilsoncc", password="MYSECRET", profile="ago")
print(f"Connected {ago}")
Then in the code use profile="ago" to connect to that account. This beats embedding credentials in files.
Recreate the environment again after upgrades to ArcGIS Pro. (It will tell you it needs upgrades by failing!) I suppose there is an upgrade path? I simply nuke it and start over. Find the path with "conda env list" and delete the entire folder for arcgis_tools!
conda create -n arcgis_tools --clone arcgispro-py3
conda activate arcgis_tools
conda install black python-dotenv requests
This process gives the warnings about an inconsistent environment but when I am done, everything seems to work okay.
You can test it by just running Python in a terminal window, for example, it looks like this today.
python
Python 3.9.18 [MSC v.1931 64 bit (AMD64)] :: Anaconda, Inc. on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import arcpy
>>> arcpy.__version__
'3.2'
>>> import arcgis
>>> arcgis.__version__
'2.2.0.1'
>>> import osgeo.gdal as gd
>>> gd.__version__
'3.7.0e'
quit()
On a server there is a different package for arcgpy, see https://enterprise.arcgis.com/en/server/latest/develop/linux/scripting-service-publishing-with-arcpy.htm Refer to that page for the very limited list of things you can do with arcpy on a server. Probably not worth the bother but here is how to install:
conda install -n arcgis_tools arcpy-server=10.9 -c esri
Checks for missing taxmaps
Updates the "septic y/n" attribute in taxlots_accounts feature class.
Updates the (hosted) transit layer(s) on cc-gis.
Mostly tools for replacing parts of the map JSON files. Has its own README.
A series of tests to see what I should be doing to publish vector features and labels.
- test.aprx
- test.fgdb contains test data set, currently a small subset of taxmap data.
| Account | {ACCOUNT_ID} |
| Taxmap | {SIMapTax} |
| Owners | {expression/OWNERS_3LINE} |
| Mailing | {expression/MAILING_ADDRESS} |
| Google Map | {expression/GOOGLE_TXT} |
| Bing Street View | {expression/BING_TXT} |
//GOOGLE_QUERY var addr=Trim($feature.SITUS_ADDR); var city=Trim($feature.SITUS_CITY); if (addr!='' && city!='') { var situs=addr + ', ' + city + ', OR'; return Replace(situs,' ','+'); } return Round($feature.Y_COORD,4) + ',' + Round($feature.X_COORD,4)
//GOOGLE_TEXT var addr=Trim($feature.SITUS_ADDR); if (addr!='') { return addr; } return Round($feature.Y_COORD,4) + ',' + Round($feature.X_COORD,4)
//BING_STREET_QUERY //https://learn.microsoft.com/en-us/bingmaps/articles/create-a-custom-map-url var x=Round($feature.X_COORD,4); var y=Round($feature.Y_COORD,4); return y + '~' + x;
//BING_STREET_TXT //https://learn.microsoft.com/en-us/bingmaps/articles/create-a-custom-map-url var x=Round($feature.X_COORD,4); var y=Round($feature.Y_COORD,4); return y + ',' + x;
https://www.google.com/maps/place/125+W+Lexington+Ave%2C+Astoria%2C+OR
https://www.google.com/maps/place/46.1799%2C-123.8448
Connect to the database server in SQL Studio Manager and load and run geodatabase_version_report.sql.
I copied it from https://support.esri.com/en/technical-article/000017513