ADDRESSCOORDINATES (4.0SP17)

ID

uniqueidentifier

ADDRESSID

uniqueidentifier

false

FK to ADDRESS table

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

PENDINGGEOCODE

bit

false

True if an address is being geocoded.

INVALIDGEOCODE

bit

false

Indicates that a valid geocode could not be found for this address.

MATCHCODE

nvarchar(50)

false

Indicates the certainty of the geocoding match.

MATCHEDMETHOD

nvarchar(50)

false

Indicates the level on which the geocode match takes place.

GEOCODEEXCEPTION

nvarchar(255)

false

Indicates the reason for which an address cannot be geocoded.

LONGITUDE

decimal(16, 13)

false

Longitude value of the address's coordinates.

LATITUDE

decimal(16, 13)

false

Latitude value of the address's coordinates.

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

REGEOCODE

bit

false

IX_ADDRESSCOORDINATES_DATEADDED

False

False

True

IX_ADDRESSCOORDINATES_DATECHANGED

False

False

False

PK_ADDRESSCOORDINATES

True

True

False

UIX_ADDRESSCOORDINATES_ADDRESSID

True

False

False

TR_ADDRESSCOORDINATES_AUDIT_UPDATE

TR_ADDRESSCOORDINATES_AUDIT_DELETE