Name: John Spence
Type: User
Bio: A dedicated professional with 24 years of GIS program and application development, data acquisition/maintenance, solutions engineering, GIS infrastructure.
Location: Washington
Blog: https://www.gis.dev
John Spence's Projects
This script will capture details about assets stored within ArcGIS Online along with usage data.
ArcGIS Online and ArcGIS Enterprise (Portal) federated user (IDP) manager. If a user account is not present or disabled, it will disable the account. If the account is present and enabled, it will ensure the system has the account enabled. It will also send emails alerting of actions taken. This script could be easily modified to allow for First and Last name updates, etc.
Scrape open data from City of Bellevue Open Data site (data.bellevuewa.gov) using the REST APIs.
Chatbot with multilingual support for COVID-19 related questions.
Extract Comcast hotspots for use within GIS applications.
Extract AGOL Service to database. Works with ArcGIS Pro.
This script leverages ArcPy that is part of the ArcGIS Pro to lift and extract a service from a map within a Pro project.
Send warning e-mail to users 15 minutes prior to killing connections and stopping incoming connections.
Enterprise Geodatabase Sync
Metadata extraction for Geodatabases and databases.
Locates on a share drive Esri MXD documents and interrogates the layers within, collecting data into a CSV.
Made at the request of a professional colleague in the affected area, this script is designed to scrape the PG&E data feed for outage information and store it within a database.
ArcGIS Online or ArcGIS Portal Web Map Inventory
Rebuild locators attached to service automatically.
Check and force SDE databases back online after they were taken offline for automated maintenance, etc.
GeoDatabase General Maintenance & Housekeeping
Backup Android SMS, MMS and call log to Gmail / Gcal / IMAP
Backup Copy
ArcGIS REST Service Metadata Extraction
This series of scripts were developed to support the COVID-19 response. One lifts and extracts all of the Comcast Xfinity WiFi hot spots. A second lifts and loads Starbucks store locations. All data is being pushed to ArcGIS Online.