...
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 | 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 |
|
|
|
|
|
|
|
Example 11
| Anchor | ||||
|---|---|---|---|---|
|
This version shall support the rework of the model RE MAD-156.
| Code Block |
|---|
<addressChangeNotification>
<address>
<key>419709</key>
<base_number_prefix></base_number_prefix>
<base_number>1</base_number>
<base_number_suffix></base_number_suffix>
<jurisdiction>PRESIDIO</jurisdiction>
<longitude>-122.418876252</longitude>
<latitude>37.774694542</latitude>
<street_name>SOUTH VAN NESS</street_name>
<street_name_suffix>
<abbreviated>AVE</abbreviated>
<unabbreviated>AVENUE</unabbreviated>
</street_name_suffix>
<unit_number_prefix>XXX</unit_number_prefix>
<unit_number>300</unit_number>
<unit_number_suffix>YYY</unit_number_suffix>
<create_tms>2010-08-13 12:15:43.828000</create_tms>
<retire_tms>2010-08-13 18:41:16.149255</retire_tms>
<disposition>provisional</disposition>
<mailing>True</mailing>
<action>insert</action>
<parcel_link_change>
<block>3506</block>
<lot>001</lot>
<apn>3506001</apn>
<action>insert</action>
</parcel_link_change>
</address>
<timestamp>2010-08-13 18:41:16.149255</timestamp>
</addressChangeNotification>
|