...
EAS Field | XML Field | FGDC Field | AVS Field | Example | Comment |
|---|---|---|---|---|---|
addresses.address_id int | key | na |
|
|
|
address_base.base_address_prefix char(10) | base_number_prefix | address number prefix text |
|
|
|
address_base.base_address_num int | base_number | address number int | AVS_ADDRESSES.STREET_NUMBER NUMBER(6) |
|
|
address_base.base_address_suffix char(10) | base_number_suffix | address number suffix text |
|
| MAD-122 |
? | ? | ? | AVS_ADDRESSES.STREET_NUMBER_SFX VARCHAR2(1) | V, A, C, P | todo - how do we map this? MAD-122 |
address_base.zone_id int | jurisdiction | community place name text |
| SFMAIN, TI, PRESIDIO | FGDC field is approx |
address_base.geoemtry.longitude double | longitude | address longitude double |
|
|
|
address_base.geoemtry.latitude 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) |
|
|
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 |
|
|
|
|
|
|
|