...
| column name | data type | description | ||
|---|---|---|---|---|
eas_address_base_id | int | eas primary key for base address table | ||
base_address_num | int | |||
base_address_suffix | string | |||
base_address_create_tms | timestamp | |||
base_address_retire_tms | timestamp | |||
street_name | string | |||
street_type | string | |||
street_cnn | int | |||
eas_unit_address_id | int | eas primary key for unit address table | ||
| longitude | double | |||
| latitude | double | |||
unit_address_base_flg | boolean | This is an artifact of the relational data model. If false, this is a typical unit address. If true, the unit_number value goes along with the base address (not typical). In the vast majority of cases, a base address will not have a unit number itself, even though there may be units for that address. | ||
unit_address | string | The unit address number, letter, or fraction. For example: "A", "1/2", or "7". For legacy reasons, it is currently limited to 1 character. We are planning to expand it to 10 characters. | ||
| unit_address_create_tms | timestamp | |||
| unit_address_retire_tms | timestamp | |||
| parcel_block_lot | string | |||
| eas_address_x_parcel_id | int | eas primary key to lookup parcels for a unit address | ||
| address_x_parcel_create_tms | timestamp | |||
| address_x_parcel_retire_tms | timestamp | |||
| zipcode | int |