austintexas-gov/coa-utilities-customer-archive-azqs-8858
 
Readme
Updated 1 year ago
Indexed 27 minutes ago

COA Utilities Customer Archive

DISCLAIMER: Address information is collected from the City of Austin’s utility billing system in use prior to October 1, 2011 and may not conform to the same formatting as other commonly used addressing standards such as the United States Postal Service or City of Austin 911.

Records of electric, water, and sewer service from the City of Austin's Customer Information System have been uploaded here to provide DSD customers access to some of the archived data through the City of Austin’s data portal.

The dataset is static and not expected to change.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
SERVICE_ADDRESS_STREETservice_address_streetservice_address_streetTextStreet name of service address
SERVICE_ADDRESS_CITYservice_address_cityservice_address_cityTextCity of service address
WATER_SERVICE_PRE1995water_service_pre1995water_service_pre1995Calendar dateEarliest Water Services Before 1995
SERVICE_ADDRESS_FULLservice_address_fullservice_address_fullTextFull service address presented in single field
SERVICE_ADDRESS_SUFFIXservice_address_suffixservice_address_suffixTextStreet address suffix (if applicable) of service address
SERVICE_ADDRESS_APTservice_address_aptservice_address_aptTextApartment number (if applicable) of service address
SERVICE_ADDRESS_ZIPservice_address_zipservice_address_zipTextZip Code of service address
ELECTRIC_SERVICE_PRE1995electric_service_pre1995electric_service_pre1995Calendar dateEarliest Electric Services Before 1995
SEWER_SERVICE_PRE1995sewer_service_pre1995sewer_service_pre1995Calendar dateEarliest Sewer Services Before 1995
SERVICE_ADDRESS_STATEservice_address_stateservice_address_stateTextState of service address
SERVICE_ADDRESS_PREFIXservice_address_prefixservice_address_prefixTextStreet address prefix (if applicable) of service address
SERVICE_ADDRESS_FRACTIONservice_address_fractionservice_address_fractionTextService address additional number (if applicable)
SERVICE_ADDRESS_HOUSEservice_address_houseservice_address_houseTextService address number
SERVICE_ADDRESS_DIRECTIONservice_address_directionservice_address_directionTextStreet direction (if applicable) of service address
Upstream Metadata