...
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.
...
EAS
...
Field:
...
address_base.base_address_id
...
(int)
XML Field: base_address_id
FGDC Field: na
AVS Field: na
Example:
Comment:
EAS Field: address_base.base_address_prefix
...
(char
...
10)
...
XML
...
Field:
...
base_number_prefix
...
FGDC
...
Field:
...
address
...
number
...
prefix (text)
AVS Field: na
Example:
Comment: EAS has no data in this field
TODO: add field to AVS?
EAS Field: address_base.base_address_num
...
(int)
XML Field: base_number
...
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
...
FGDC
...
Field:
...
address
...
number
...
suffix (text)
AVS Field: AVS_ADDRESSES.STREET_NUMBER_SFX ( VARCHAR2 1)
Example:
Comment: MAD-122
TODO: widen AVS field
EAS Field: zone.zipcode (int)
XML Field: zipcode
FGDC Field: zip code
AVS Field: ?
Example:
Comment:
TODO: add this to EAS change notification message (and remove "jurisdiction")
EAS Field: address_base.geoemtry.longitude
...
(double)
XML Field:
...
longitude
...
FGDC
...
Field:
...
address
...
longitude (double)
AVS Field:
Example:
Comment:
EAS Field: address_base.geoemtry.latitude
...
(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
FGDC Field: street name (text)
AVS Field: AVS_STREETS.STREET_NAME
...
VARCHAR2(28)
...
Example:
...
Comment:
...
problem
...
with
...
field width
TODO: AVS must truncate width
EAS Field: address_base.street_segment.st_type
...
(char
...
6)
...
XML
...
Field:
...
street_name_suffix
...
FGDC
...
Field:
...
street
...
name
...
post
...
type
...
text
AVS Field:
...
AVS_STREET_SUFFIXES.STREET_SFX
...
(VARCHAR2
...
2)
...
Example:
...
Comment:
...
data
...
type
...
mismatch
...
is
...
accomodated
...
in
...
xml
...
mapping
EAS
...
Field:
...
addresses.unit_num_prefix
...
(char 5)
...
XML
...
Field:
...
unit_number_prefix
...
FGDC
...
Field:
...
na
...
AVS
...
Field:
...
Example:
...
Comment
...
:
TODO: EAS will drop this field from database scehma
EAS Field: addresses.unit_num (char 20)
XML Field: unit_number
FGDC Field: unit identifier (text)
AVS Field: AVS_ADDRESSES.UNIT (NUMBER 6)
Example:
Comment:
TODO: AVS must widen field
EAS Field: addresses.unit_num_suffix
...
(char 10)
...
XML
...
Field:
...
unit_number_suffix
...
FGDC
...
Field:
...
na
...
AVS
...
Field:
...
AVS_ADDRESSES.UNIT_SFX
...
(VARCHAR2 10)
...
Example:
...
Comment
...
:
TODO: EAS will drop this field from database scehma
EAS Field: addresses.unit_type_id (int)
XML Field: na
FGDC Field: unit type (text)
AVS Field: na
Example: suite, apartment
Comment:
TODO: EAS will add this field to the XML
EAS Field: na
XML Field: na
FGDC Field: na
AVS Field: AVS_ADDRESSES.ADDRESS_TYPE
...
(VARCHAR2
...
10)
...
Example:
...
PRIMARY,
...
ALTERNATE,
...
ALIAS
...
Comment:
...
TODO: ?
XXXX
EAS Field:
...
addresses.create_tms
...
datetime
XML Field: create_tms
...
FGDC
...
Field:
...
na
...
AVS
...
Field:
...
Example:
...
Comment:
...
EAS
...
Field:
...
addresses.retire_tms
...
datetime
XML Field: retire_tms
...
FGDC
...
Field:
...
na
...
AVS
...
Field:
...
AVS_ADDRESSES.END_DATE
...
DATE
Example:
Comment:
EAS Field: addresses.disposition_code
...
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
...
datetime
...
XML
...
Field:
...
timestamp
...
FGDC
...
Field:
...
na
...
AVS
...
Field:
...
Example:
...
Comment:
...
EAS
...
Field:
...
addresses_history.history_action
...
char(10)
...
XML
...
Field:
...
action
...
FGDC
...
Field:
...
na
...
AVS
...
Field:
...
Example:
...
Comment:
...
EAS
...
Field:
...
addresses.unq_adds_id
...
int
XML Field: na
FGDC Field: na
AVS Field: AVS_ADDRESSES.ADDRESS_KIND
...
VARCHAR2(10)
...
Example:
...
DBI,
...
ASSESSOR
...
Comment:
...
Example 11
Anchor | ||||
---|---|---|---|---|
|
...