Introduction

Schema

This is the schema of the EAS Flat File Export:

	FIELD NAME	PostgreSQL 11 DATA TYPE
1	id	text
2	eas_address_base_id	integer
3	base_address_num	integer
4	base_address_suffix	character varying(10)
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:

SELECT *
FROM   eas_flat_file_export
WHERE  (base_address_create_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (base_address_retire_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (unit_address_create_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (unit_address_retire_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (address_x_parcel_create_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (address_x_parcel_retire_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'));