Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

EAS Field

XML Field

FGDC Field

AVS Field

Example

Comment

addresses.address_id int

key

na

 

 

 

address_base.base_numberaddress_prefix char(10)

base_number_prefix

address number prefix text

 

 

 

address_base.base_address_number num int

base_number

address number int

AVS_ADDRESSES.STREET_NUMBER NUMBER(6)

 

 

address_base.base_numberaddress_suffix char(10)

base_number_suffix

address number suffix text

 

 

 

?

?

? ?

AVS_ADDRESSES.STREET_NUMBER_SFX VARCHAR2(1)

V, A, C, P

todo - how do we map this?

address_base.zone_id int

jurisdiction

community place name text

  

SFMAIN, TI, PRESIDIO

FGDC field is approx

address_base.geoemtry.longitude float double

longitude

address longitude double

 

 

 

address_base.geoemtry.latitude float double

latitude

address latitude double

 

 

 

address_base.street_segment.st_name char(29)

street_name

street name text

AVS_STREETS.STREET_NAME VARCHAR2(28)

 

todo - problem with field width

address_base.street_segment.st_type char(6)

street_name_suffix

street name post type text

AVS_STREET_SUFFIXES.STREET_SFX VARCHAR2(2)

 

data type mismatch is accomodated in xml

addresses.unit_num_prefix char(5)

unit_number_prefix

na

 

 

 

addresses.unit_num char(20)

unit_number

unit identifier text

AVS_ADDRESSES.UNIT NUMBER(6)

 

todo - is data type mismatch

addresses.unit_num_suffix char(10)

unit_number_suffix

na

AVS_ADDRESSES.UNIT_SFX VARCHAR2(10)

 

 

addresses.unit_type_id int

na

unit type text

na

suite, apartment

 

na

na

na

AVS_ADDRESSES.ADDRESS_TYPE VARCHAR2(10)

PRIMARY, ALTERNATE, ALIAS

 

addresses.create_tms datetime

create_tms

na

 

 

 

addresses.retire_tms datetime

retire_tms

na

AVS_ADDRESSES.END_DATE DATE

 

 

addresses.disposition_code int

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

AVS_STRUCTURES.STRUCTURE_NUMBER VARCHAR2(2)

 

 

parcel.blk_lot char(9)

apn

na

 

 

 

addresses_history.last_change_tms datetime

timestamp

na

 

 

 

addresses_history.history_action char(10)

action

na

 

 

 

addresses.unq_adds_id int

na

na

AVS_ADDRESSES.ADDRESS_KIND VARCHAR2(10)

DBI, ASSESSOR