...
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: addressesaddress_base.unitcreate_num_prefix (char 5tms (datetime)
XML Field: unitbase_numberaddress/create_prefixtms
FGDC Field: na
AVS Field:
Example:
Comment: TODO:
EAS will drop this field from database scehmaEAS Field: addresses.unit_num (char 20address_base.last_change_tms (datetime)
XML Field: unit_numberbase_address/last_change_tms
FGDC Field: unit identifier (text)
AVS Field: AVS_ADDRESSES.UNIT (NUMBER 6)
Example:
Comment: TODO: AVS must widen field
EAS Field: addressesaddress_base.unit_num_suffix (char 10retire_tms (datetime)
XML Field: base_address/retire_tms
FGDC Field:
AVS Field:
Example:
Comment:
EAS Field: addresses.unit_num_prefix (char 5)
XML Field: unit_number_suffixprefix
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 (intnum (char 20)
XML Field: naunit_number
FGDC Field: unit type identifier (text)
AVS Field: naAVS_ADDRESSES.UNIT (NUMBER 6)
Example: suite, apartment
Comment:
TODO: EAS will add this field to the XMLEAS Field: naAVS must widen field
EAS Field: addresses.unit_num_suffix (char 10)
XML Field: naunit_number_suffix
FGDC Field: na
AVS Field: AVS_ADDRESSES.ADDRESSUNIT_TYPE SFX (VARCHAR2 10)
Example: PRIMARY, ALTERNATE, ALIAS
Comment:
TODO: ?XXXXEAS will drop this field from database scehma
EAS Field: addresses.create_tms datetimeunit_type_id (int)
XML Field: create_tmsna
FGDC Field: naunit type (text)
AVS Field: na
Example: suite, apartment
Comment:
EAS Field: addresses.retire_tms datetime TODO: EAS will add this field to the XML - do we need to map it to an AVS field?
EAS Field: na
XML Field: retire_tmsna
FGDC Field: na
AVS Field: AVS_ADDRESSES.END_DATE DATEADDRESS_TYPE (VARCHAR2 10)
Example: PRIMARY, ALTERNATE, ALIAS
Comment:
TODO: ???
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
TODO: do we need to map this to an AVS field?
EAS Field: naaddresses.mailable_flg (boolean_)
XML Field: naunit_address/mailing
FGDC Field: address official status textna
AVS Field: AVS_ADDRESSES.VALID VARCHAR2(1)
na
Example:
Comment: EAS combines this with address life cycle status
EAS Field: addresses.mailable_flg booleancreate_tms (datetime)
XML Field: mailingunit_address.create_tms
FGDC Field: na
AVS Field:
Example:
Comment:
EAS Field: parceladdresses.block_num char(5last_change_tms (datetime)
XML Field: blockunit_address.last_change_tms
FGDC Field: na
AVS Field: AVS_STRUCTURES.BLOCK VARCHAR2(5)
Example:
Comment:
EAS Field: parceladdresses.lotretire_num chartms (5datetime)
XML Field: lotunit_address.retire_tms
FGDC Field: na
AVS Field: AVS_STRUCTURES.LOT VARCHAR2(4)
Example: : na
Example:
Comment: todo - field with mismatch
EAS Field: address_x_parcel.parcel.blkblock_lot num (char (95)
XML Field: apnaddress_parcel_link/parcel/block
FGDC Field: na
AVS Field: AVS_STRUCTURES.BLOCK (VARCHAR2 5)
Example:
Comment:
EAS Field: naaddress_x_parcel.parcel.lot_num (char 5)
XML Field: naaddress_parcel_link/parcel/lot
FGDC Field: building identifer textna
AVS Field: AVS_STRUCTURES.STRUCTURE_NUMBER VARCHAR2(2LOT (VARCHAR2 4)
Example:
Comment:
TODO: field width mismatch - widen AVS field?
EAS Field: addresses_history.last_change_tms datetime
XML Field: timestamp
address_x_parcel.parcel.blk_lot (char 9)
XML Field: address_parcel_link/parcel/apn
FGDC Field: na
AVS Field: na
Example:
Comment:
EAS Field: addressesaddress_x_historyparcel.historycreate_action chartms (10datetime)
XML Field: actionaddress_parcel_link/create_tms
FGDC Field: na
AVS Field:
Example:
Comment:
TODO: determine mapping
EAS Field: addresses.unq_adds_id intaddress_x_parcel.retire_tms (datetime)
XML Field: naaddress_parcel_link/retire_tms
FGDC Field: na
AVS Field: AVS_ADDRESSES.ADDRESS_KIND VARCHAR2(10)???
Example: DBI, ASSESSOR
Comment:
TODO: determine mapping
Example 11
| Anchor | ||||
|---|---|---|---|---|
|
...