...
Each FFE record represents a specific combination of “base address (table record identifier)” and “unit address (table record identifier)” and “parcel link (table record identifier)”. This is not an “EAS (record”, nor an “EAS address ) record”.
Schedule
The EAS FFE nightly job is initiated on Monday through Friday at 6:00 PM, and takes less than three minutes to post these data to the DT Secure FTP Server.
...
This is the schema of the EAS FFE:
FIELD NAME | PostgreSQL 11 DATA TYPE | PostGIS 2.5 DATA TYPE | DESCRIPTION | |
|---|---|---|---|---|
| 1 | id | “eas_address_base_id” (field #2) + “-” + “eas_unit_address_id“ (field #12) + “-” + “eas_address_x_parcel_id“ (field #22) Conceptually: “base address table record identifier” + “-” + “unit address table record identifier” + “-” + “parcel link table record identifier” | ||
| 2 | eas_address_base_id | |||
| 3 | base_address_num | See Address Number in the EAS Glossary. page 37 | ||
| 4 | base_address_suffix | See Address Number Suffix in the EAS Glossary. page 39 | ||
| 5 | street_name | See Street Name in the EAS Glossary. page 54 | ||
| 6 | street_type | See Street Name Post Type in the EAS Glossary. page 56 | ||
| 7 | street_post_direction | See Street Name Post Directional in the EAS Glossary. page 59 | ||
| 8 | street_cnn | |||
| 9 | street_full_street_name | See Complete Street Name in the EAS Glossary. page 63 | ||
| 10 | base_address_create_tms | |||
| 11 | base_address_retire_tms | |||
| 12 | eas_unit_address_id | See EAS Address Identifier ( | ||
| 13 | unit_address_base_flg | |||
| 14 | unit_address | See Subaddress Identifier in the EAS Glossary. page 78 | ||
| 15 | unit_address_create_tms | |||
| 16 | unit_address_retire_tms | |||
| 17 | disposition_description | official, placeholder Generally, you will not be interested in placeholder addresses, for example “0 UNKNOWN”. | ||
| 18 | map_block_lot | |||
| 19 | block_lot | See Assessor Parcel Number in the EAS Glossary. | ||
| 20 | parcel_date_map_add | See the description for the column | ||
| 21 | parcel_date_map_drop | See the description for the column | ||
| 22 | eas_address_x_parcel_id | |||
| 23 | address_x_parcel_create_tms | |||
| 24 | address_x_parcel_retire_tms | |||
| 25 | zipcode | See Zip Code in the EAS Glossary. page 96 | ||
| 26 | longitude | In the WGS 84 spatial reference system. See EPSG:4326. | ||
| 27 | latitude | In the WGS 84 spatial reference system. See EPSG:4326. | ||
| 28 | geometry | In the NAD83 / California zone 3 (ftUS) spatial reference system. See EPSG:2227. | ||
| 29 | complete_landmark_name | |||
| 30 | address_type | “Landmark Address“, “Numbered Thoroughfare Address“ One of the values that are above, and is used to filter records of the respective address types. By definition, a numbered thoroughfare address may have a complete landmark name, while a landmark address will never have a value in the | ||
| 31 | landmark_aliases | An array of complete landmark name aliases. |
Change Detection
The FFE only contains certain timestamps for a subset of the changes that can occur in the EAS database. Specifically, there are dedicated timestamps for when a:
base address was created (see the field
base_address_create_tmsin the table that is above)base address was retired (see the field
base_address_retire_tmsin the table that is above))unit (apartment or condominium) (sub)address was created (see the field
unit_address_create_tmsin the table that is above))unit (apartment or condominium) (sub)address was retired (see the field
unit_address_retire_tmsin the table that is above))(base or unit) address is linked to a parcel (see the field
address_x_parcel_create_tmsin the table that is above))parcel in unlinked from a (base or unit) address (see the field
address_x_parcel_retire_tmsin the table that is above))
The FFE does not contain timestamps for every possible change that can occur in the EAS database. Specifically, there are no dedicated timestamps for a changed:
...