gazid

Base Table | gazetteerpt
Attribute Name | gazid
ColumnName | gazid
RoleName |
Definition |
    Derived from sequence gazseq
Note |
    Range: gazid > 0

type

Base Table | gazetteerpt
Attribute Name | code
ColumnName | type
RoleName | type
Definition |
    References gazetteertype.code
Note |
    Range: type = {10 | 12 | 30 | 40 | 601} 10 = town, 12 = bigTown, 30 = quarry, 40 = quake, 601 = fault

lat

Base Table | gazetteerpt
Attribute Name | lat
ColumnName | lat
RoleName |
Definition |
    Latitude must be within +/- 90
Note |
    Range: -90.0 <= lat <= 90.0 Units: Degrees

lon

Base Table | gazetteerpt
Attribute Name | lon
ColumnName | lon
RoleName |
Definition |
    Longitude must be within +/-180
Note |
    Range: -180.0 <= lon <= 180.0 Units: Degrees

z

Base Table | gazetteerpt
Attribute Name | z
ColumnName | z
RoleName |
Definition |
    Elevation (+ is above sea level)
Note |
    Range: -10.0 <= z <= 1000.0 Units: Kilometers

name

Base Table | gazetteerpt
Attribute Name | name
ColumnName | name
RoleName |
Definition |
    Point place name
Note |
    Range: Any free-format string up to 48 characters

state

Base Table | gazetteerpt
Attribute Name | state
ColumnName | state
RoleName |
Definition |
    State where point is located
Note |
    Range: Any free-format string up to 2 characters

county

Base Table | gazetteerpt
Attribute Name | county
ColumnName | county
RoleName |
Definition |
    County where point is located
Note |
    Range: Any free-format string up to 32 characters

map

Base Table | gazetteerpt
Attribute Name | map
ColumnName | map
RoleName |
Definition |
    A map reference
Note |
    Range: Any free-format string up to 48 characters

datumh

Base Table | gazetteerpt
Attribute Name | datumh
ColumnName | datumh
RoleName |
Definition |
    Map horizontal datum (eg. WGS84)
Note |
    Range: datumh = { NAD27 | WGS84}

datumv

Base Table | gazetteerpt
Attribute Name | datumv
ColumnName | datumv
RoleName |
Definition |
    Map vertical datum
Note |
    Range: datumv = { NAD27 | WGS84 | AVERAGE} AVERAGE = average of stations

lddate

Base Table | gazetteerpt
Attribute Name | lddate
ColumnName | lddate
RoleName |
Definition |
    Load date. Date and time that the record was created or last modified, in Oracle date datatype
Note |
    Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS