Versions Compared

Key

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

Goal:

Definition:

Current State:

Ideal State:

Potential resolution:

Policy:

Standard Types:

Database Rules:

...

TABLE

...

LOCATION

...

Type

...

LOCATION

...

LOCATION_SK

...

Number

...

LOCATION

...

LOCATION_ID

...

Number

...

LOCATION

...

ORIENTATION

...

Number

...

0 to 359 only

...

LOCATION

...

PRIMARY_READ

...

Text

...

R, L, P, or C only

...

LOCATION

...

PRIMARY_ARTERY

...

Text

...

LOCATION

...

LEVEL

...

Number

...

LOCATION

...

LEVELS_VISIBLE

...

Text

...

LOCATION

...

LATITUDE

...

Number

...

6 more decimal places

...

LOCATION

...

LONGITUDE

...

Number

...

6 more decimal places

...

LOCATION

...

BLOCK_ID

...

Text

...

LOCATION

...

ELEVATION

...

Number

...

LOCATION

...

GEOM_X

...

Number

...

LOCATION

...

GEOM_Y

...

Number

...

LOCATION

...

GEOM

...

(I)

...

LOCATION

...

DMA_ID

...

Text

...

LOCATION

...

ZIP_CODE

...

Text

...

LOCATION

...

TIME_ZONE

...

Text

...

LOCATION

...

PLACE_TYPE_SK

...

Number

...

LOCATION

...

CREATED_BY

...

Text

...

LOCATION

...

CREATED_DTM

...

Date

...

LOCATION

...

UPDATED_BY

...

Text

...

LOCATION

...

UPDATED_DTM

...

Date

...

LOCATION

...

CURRENT_IND

...

True/False

...

LOCATION

...

DESCRIPTION

...

Text