gazid

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

type

Base Table | gazetteerpt
Attribute Name | code
ColumnName | type
Logical Rolename |
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
Logical Rolename |
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
Logical Rolename |
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
Logical Rolename |
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
Logical Rolename |
RoleName |
Definition | Point place name
Note |
    Range: Any free-format string up to 48 characters

state

Base Table | gazetteerpt
Attribute Name | state
ColumnName | state
Logical Rolename |
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
Logical Rolename |
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
Logical Rolename |
RoleName |
Definition | A map reference
Note |
    Range: Any free-format string up to 48 characters

datumh

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

datumv

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

lddate

Base Table | gazetteerpt
Attribute Name | lddate
ColumnName | lddate
Logical Rolename |
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