Python Script for Generating Address Lists

eGIS Central > Documents > Python Script for Generating Address Lists

November 1, 2022

Documents

,

PYTHON SCRIPT FOR CREATING ADDRESS LISTS

Downloads:

Python Script

Description:

This script generates a mailing list for and area of interest to be used with ArcGIS Pro. The data source, DPW_MAILING_ADDRESS_POINTS is a combination of addresses from the Assessor, CAMS and USPS addressing database. From the Assessor’s parcels, both site and mail addresses are included. From the USPS, only the addresses with the unit(s) are included. All CAMS addresses are included with most duplicate addresses removed. Additional information can be obtained from the layer’s metadata

Data sources:

  • eGIS_Addressing.sde\eGIS_Addressing.EGIS.DPW_MAILING_ADDRESS_POINTS

Required inputs:

  • Area of Interest (must be a shapefile)
  • Output folder

Outputs:

  • Mailing address points for the area of interest
  • Excel file of the mailing addresses

Process:

  • Intersect DPW_MAILING_ADDRESS_POINTS with the area of interest.
  • Remove duplicate addresses and export the mailing list to an excel table.