Finding Gateway IP's

Tools Used:

1. Python
2. Pandas
3. ArcGIS API for Python

View the Github Repository

This script was used to support a large data collection effort. In order for the system being deployed to function it was necessary to know the location and Gateway IP address of each computer it would be installed on. Once location data was collected through ESRI’s Survey 123 app, this script would run daily to pull features that had been uploaded to the server, identify the Gateway IP by querying multiple datasets and update the feature. The DNS dataset queried contains over 1 Million rows, leading to the need to use Pandas in the process.