...
| Anchor | ||||
|---|---|---|---|---|
|
Here is the mapping between AVS and EAS. To help clarify the purpose of each field, I use the FGDC Street Address Data Standard. Here is the latest and most complete reference or you can just take a look at draft 2 which is usually adequate. By the way, I used a real editor to edit this table.
| Code Block |
|---|
EAS |
...
XML Field
...
FGDC Field
...
AVS Field
...
Example
...
Comment
...
addresses.address_id int
...
key
...
na
...
...
...
...
Field: addresses.address_id int XML Field: key FGDC Field: na AVS Field: Example: Comment: EAS Field: address_base.base_address_prefix |
...
char(10) |
...
XML Field: base_number_prefix |
...
address number prefix text
...
...
...
FGDC Field: address number prefix text AVS Field: Example: Comment: EAS Field: address_base.base_address_num |
...
int XML Field: base_number |
...
address number int
FGDC Field: address number int AVS Field: AVS_ADDRESSES.STREET_NUMBER NUMBER(6) |
...
...
Example: Comment: EAS Field: address_base.base_address_suffix char(10) |
...
XML Field: base_number_suffix |
...
address number suffix text
...
...
...
MAD-122
...
?
...
?
...
?
FGDC Field: address number suffix text AVS Field: Example: Comment: MAD-122 EAS Field: ? XML Field: ? FGDC Field: ? AVS Field: AVS_ADDRESSES.STREET_NUMBER_SFX VARCHAR2(1) |
...
Example: V, A, C, P |
...
Comment: MAD-122 |
...
EAS Field: address_base.zone_id |
...
jurisdiction
...
community place name text
...
...
SFMAIN, TI, PRESIDIO
...
FGDC field is approx
int XML Field: jurisdiction FGDC Field: community place name text AVS Field: Example: SFMAIN, TI, PRESIDIO Comment: FGDC field is approx EAS Field: address_base.geoemtry.longitude |
...
longitude
...
address longitude double
...
...
...
double XML Field: longitude FGDC Field: address longitude double AVS Field: Example: Comment: EAS Field: address_base.geoemtry.latitude |
...
latitude
...
address latitude double
...
...
...
double XML Field: latitude FGDC Field: address latitude double AVS Field: Example: Comment: EAS Field: address_base.street_segment.st_name char(29) |
...
XML Field: street_name |
...
street name text
FGDC Field: street name text AVS Field: AVS_STREETS.STREET_NAME VARCHAR2(28) |
...
...
todo - problem with field width
Example: Comment: todo - problem with field width EAS Field: address_base.street_segment.st_type char(6) |
...
XML Field: street_name_suffix |
...
street name post type text
FGDC Field: street name post type text AVS Field: AVS_STREET_SUFFIXES.STREET_SFX VARCHAR2(2) |
...
...
data type mismatch is accomodated in xml
Example: Comment: data type mismatch is accomodated in xml EAS Field: addresses.unit_num_prefix |
...
char(5) XML Field: unit_number_prefix |
...
na
...
...
...
FGDC Field: na AVS Field: Example: Comment: EAS Field: addresses.unit_num char(20) |
...
XML Field: unit_number |
...
unit identifier text
FGDC Field: unit identifier text AVS Field: AVS_ADDRESSES.UNIT NUMBER(6) |
...
...
todo - is data type mismatch
Example: Comment: todo - is data type mismatch EAS Field: addresses.unit_num_suffix char(10) |
...
XML Field: unit_number_suffix |
...
na
FGDC Field: na AVS Field: AVS_ADDRESSES.UNIT_SFX VARCHAR2(10) |
...
...
Example: Comment: EAS Field: addresses.unit_type_id |
...
na
...
unit type text
...
na
...
suite, apartment
...
...
na
...
na
...
na
int XML Field: na FGDC Field: unit type text AVS Field: na Example: suite, apartment Comment: EAS Field: na XML Field: na FGDC Field: na AVS Field: AVS_ADDRESSES.ADDRESS_TYPE VARCHAR2(10) |
...
Example: PRIMARY, ALTERNATE, |
...
...
ALIAS Comment: EAS Field: addresses.create_tms |
...
datetime XML Field: create_tms |
...
na
...
...
...
FGDC Field: na AVS Field: Example: Comment: EAS Field: addresses.retire_tms |
...
datetime XML Field: retire_tms |
...
na
FGDC Field: na AVS Field: AVS_ADDRESSES.END_DATE |
...
...
DATE Example: Comment: EAS Field: addresses.disposition_code |
...
disposition
...
address lifecycle status text
...
...
provisional, offical
...
FGDC field is approx
...
na
...
na
...
address official status text
...
AVS_ADDRESSES.VALID VARCHAR2(1)
...
...
EAS combines this with address life cycle status
...
addresses.mailable_flg boolean
...
mailing
...
na
...
...
...
...
parcel.block_num char(5)
...
block
...
na
...
AVS_STRUCTURES.BLOCK VARCHAR2(5)
...
...
...
parcel.lot_num char(5)
...
lot
...
na
...
AVS_STRUCTURES.LOT VARCHAR2(4)
...
...
todo - field with mismatch
...
parcel.blk_lot char(9)
...
apn
...
na
...
...
...
...
na
...
na
...
building identifer text
int XML Field: disposition FGDC Field: address lifecycle status text AVS Field: Example: provisional, offical Comment: FGDC field is approx EAS Field: na XML Field: na FGDC Field: address official status text AVS Field: AVS_ADDRESSES.VALID VARCHAR2(1) Example: Comment: EAS combines this with address life cycle status EAS Field: addresses.mailable_flg boolean XML Field: mailing FGDC Field: na AVS Field: Example: Comment: EAS Field: parcel.block_num char(5) XML Field: block FGDC Field: na AVS Field: AVS_STRUCTURES.BLOCK VARCHAR2(5) Example: Comment: EAS Field: parcel.lot_num char(5) XML Field: lot FGDC Field: na AVS Field: AVS_STRUCTURES.LOT VARCHAR2(4) Example: Comment: todo - field with mismatch EAS Field: parcel.blk_lot char(9) XML Field: apn FGDC Field: na AVS Field: Example: Comment: EAS Field: na XML Field: na FGDC Field: building identifer text AVS Field: AVS_STRUCTURES.STRUCTURE_NUMBER VARCHAR2(2) |
...
...
Example: Comment: EAS Field: addresses_history.last_change_tms |
...
timestamp
...
na
...
...
...
datetime XML Field: timestamp FGDC Field: na AVS Field: Example: Comment: EAS Field: addresses_history.history_action char(10) |
...
action
...
na
...
...
...
XML Field: action FGDC Field: na AVS Field: Example: Comment: EAS Field: addresses.unq_adds_id |
...
na
...
na
int XML Field: na FGDC Field: na AVS Field: AVS_ADDRESSES.ADDRESS_KIND VARCHAR2(10) |
...
Example: DBI, |
...
...
...
...
...
...
...
ASSESSOR
Comment:
|
Example 11
| Anchor | ||||
|---|---|---|---|---|
|
...