| Table of Contents | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Introduction
Schema
This is the schema of the EAS Flat File Export:
FIELD NAME | PostgreSQL 11 DATA TYPE | DESCRIPTION | |
|---|---|---|---|
| 1 | id | ||
| 2 | eas_address_base_id | ||
| 3 | base_address_num | ||
| 4 | base_address_suffix | ||
| 5 | street_name | ||
| 6 | street_type | ||
| 7 | street_post_direction | ||
| 8 | street_cnn | ||
| 9 | street_full_street_name | ||
| 10 | base_address_create_tms | ||
| 11 | base_address_retire_tms | ||
| 12 | eas_unit_address_id | ||
| 13 | unit_address_base_flg | ||
| 14 | unit_address | ||
| 15 | unit_address_create_tms | ||
| 16 | unit_address_retire_tms | ||
| 17 | disposition_description | ||
| 18 | map_block_lot | ||
| 19 | block_lot | ||
| 20 | parcel_date_map_add | ||
| 21 | parcel_date_map_drop | ||
| 22 | eas_address_x_parcel_id | ||
| 23 | address_x_parcel_create_tms | ||
| 24 | address_x_parcel_retire_tms | ||
| 25 | zipcode | ||
| 26 | longitude | ||
| 27 | latitude | ||
| 28 | geometry |
Example
The following is an example of PostgreSQL 11 SQL to filter for any records that have changed within the last 7 days:
...