...
| available in version | 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 | ||
| 1.1.8 | street_post_direction | string | EAST, WEST, NORTH, SOUTH e.g. MISSION BAY BLVD NORTH |
| 1.1.8 | street_full_street_name | string | concatenation of street_name, street_type, and street_post_direction |
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 | ||
| 1.1.7 | map_block_lot | string | the map_block_lot field for parcels |
| block_lot | string | the block_lot (or assessor parcel number) field for a parcel | |
| 1.1.7 | parcel_date_map_add | the create date for a parcel | |
| 1.1.7 | parcel_date_map_drop | the retire date for a parcel | |
| eas_address_x_parcel_id | int | eas primary key to lookup parcels for a unit address | |
| address_x_parcel_create_tms | timestamp | the create time stamp for when a parcel was linked to an address | |
| address_x_parcel_retire_tms | timestamp | the retire time stamp for when a parcel was linked to an address | |
| zipcode | int |