| 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 |