SCCAddressStandardization

Address Standardization is the process of changing addresses to USPS standards. Standardizes the address information in a table . Addresses are often presented in different forms that may contain various abbreviations of words, such as "W" for "WEST" or "ST" for "STREET". Based on an address style you select, the address can be broken into multiple parts, such as House Number, Prefix Direction, Prefix Type, Street Name and Street Type. Each part will contain a piece of address information and the standardized value, such as "1ST" instead of "FIRST" as Street Name, "AVE" instead of "AVENUE" as Street Type. The address style specifies the components of an address and determines how the components are ordered and standardized. Depending on the applications, some address styles may expand the value of a word instead of abbreviating it. The input address you want to standardize can be stored in a single field. If the address information has already been split into multiple fields in the input feature class or table, this tool can concatenate the fields on the fly and standardize the information. Few steps : User Input --> Create CSV file from user input data (Custom script) --> address standardize Tool (ESRI Tool) --> Add few tools from toolbox to get all the City and Zipcode information --> Table to Excel (ESRI tool ) --> table to json format (not file text format output) Created by Sampa Patra and Jason Chen - TSS - GIS - Santa Clara County - Feb 2019