| point_id |
| Logical Only | NO |
| Definition | Unique ID assigned to each point by the NCRDS database software |
| Note |
| point_id Logical Attribute Properties |
| Logical Attribute Name | point_id |
| Datatype | INTEGER |
| Nullable | NO |
| point_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| point_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | point_id | point_id | point | INTEGER | point_id | Unique ID assigned to each point by the NCRDS database software |
| point_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| point_nm |
| Logical Only | NO |
| Definition | Point Name is assigned by each geologist. The number should be unique for at least all data submitted for the same quadrangle. The number must be coded exactly the same on 1) the submitted pointed location map or 2) the digitized point location file and 3) on any data submitted for that point into another data base (e.g., USALYT). For measured sections the same point number is required for all locations with A-Z added as a suffix. (See measured section guide for further information.) |
| Note |
| point_nm Logical Attribute Properties |
| Logical Attribute Name | point_nm |
| Datatype | VARCHAR(16) |
| Nullable | NO |
| point_nm Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| point_nm Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | point_nm | point_nm | point | VARCHAR | point_nm | Point Name is assigned by each geologist. The number should be unique for at least all data submitted for the same quadrangle. The number must be coded exactly the same on 1) the submitted pointed location map or 2) the digitized point location file and 3) on any data submitted for that point into another data base (e.g., USALYT). For measured sections the same point number is required for all locations with A-Z added as a suffix. (See measured section guide for further information.) |
| point_nm User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| prev_point_nm |
| Logical Only | NO |
| Definition | Previously assigned Point name |
| Note |
| prev_point_nm Logical Attribute Properties |
| Logical Attribute Name | prev_point_nm |
| Datatype | VARCHAR(16) |
| Nullable | NO |
| prev_point_nm Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| prev_point_nm Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | prev_point_nm | prev_point_nm | point | VARCHAR | prev_point_nm | Previously assigned Point name |
| prev_point_nm User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| ncra_id |
| Logical Only | NO |
| Definition | Unique ID for d_ncra code table |
| Note |
| ncra_id Logical Attribute Properties |
| Logical Attribute Name | ncra_id |
| Datatype | INTEGER |
| Nullable | NO |
| ncra_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ncra_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | ncra_id | ncra_id | point | INTEGER | ncra_id | Unique ID for d_ncra code table |
| ncra_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| other_data_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_other_data |
| Note |
| other_data_id Logical Attribute Properties |
| Logical Attribute Name | other_data_id |
| Datatype | INTEGER |
| Nullable | NO |
| other_data_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| other_data_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | other_data_id | other_data_id | point | INTEGER | other_data_id | Unique ID for code table, d_other_data |
| other_data_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| hydro_cd |
| Logical Only | NO |
| Definition | USGS unit number obtained from USGS State Hydrologic Unit maps. |
| Note |
| hydro_cd Logical Attribute Properties |
| Logical Attribute Name | hydro_cd |
| Datatype | NUMERIC(8, 0) |
| Nullable | NO |
| hydro_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| hydro_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | hydro_cd | hydro_cd | point | NUMERIC | hydro_cd | USGS unit number obtained from USGS State Hydrologic Unit maps. |
| hydro_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| owner_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_owner |
| Note |
| owner_id Logical Attribute Properties |
| Logical Attribute Name | owner_id |
| Datatype | INTEGER |
| Nullable | NO |
| owner_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| owner_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | owner_id | owner_id | point | INTEGER | owner_id | Unique ID for code table, d_owner |
| owner_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| country_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_country |
| Note |
| country_id Logical Attribute Properties |
| Logical Attribute Name | country_id |
| Datatype | INTEGER |
| Nullable | NO |
| country_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| country_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | country_id | country_id | point | INTEGER | country_id | Unique ID for code table, d_country |
| country_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| state_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_state |
| Note |
| state_id Logical Attribute Properties |
| Logical Attribute Name | state_id |
| Datatype | INTEGER |
| Nullable | NO |
| state_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| state_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | state_id | state_id | point | INTEGER | state_id | Unique ID for code table, d_state |
| state_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| county_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_county |
| Note |
| county_id Logical Attribute Properties |
| Logical Attribute Name | county_id |
| Datatype | INTEGER |
| Nullable | NO |
| county_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| county_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | county_id | county_id | point | INTEGER | county_id | Unique ID for code table, d_county |
| county_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| province_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_province |
| Note |
| province_id Logical Attribute Properties |
| Logical Attribute Name | province_id |
| Datatype | INTEGER |
| Nullable | NO |
| province_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| province_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | province_id | province_id | point | INTEGER | province_id | Unique ID for code table, d_province |
| province_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| region_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_region |
| Note |
| region_id Logical Attribute Properties |
| Logical Attribute Name | region_id |
| Datatype | INTEGER |
| Nullable | NO |
| region_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| region_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | region_id | region_id | point | INTEGER | region_id | Unique ID for code table, d_region |
| region_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| point_dt |
| Logical Only | NO |
| Definition | Data entry date in YYYYMMDD format. |
| Note |
| point_dt Logical Attribute Properties |
| Logical Attribute Name | point_dt |
| Datatype | NUMERIC(8, 0) |
| Nullable | YES |
| point_dt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| point_dt Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | point_dt | point_dt | point | NUMERIC | point_dt | Data entry date in YYYYMMDD format. |
| point_dt User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| proprietary_cd |
| Logical Only | NO |
| Definition | Code that identifies whether or not point is within a proprietary data set forwarded to the USGS. Enter 'PROP' for proprietary data, otherwise, any value is interpreted as public. |
| Note |
| proprietary_cd Logical Attribute Properties |
| Logical Attribute Name | proprietary_cd |
| Datatype | CHAR(4) |
| Nullable | NO |
| proprietary_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| proprietary_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | proprietary_cd | proprietary_cd | point | CHAR | proprietary_cd | Code that identifies whether or not point is within a proprietary data set forwarded to the USGS. Enter 'PROP' for proprietary data, otherwise, any value is interpreted as public. |
| proprietary_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| map_id |
| Logical Only | NO |
| Definition | Unique ID for d_map code table |
| Note |
| map_id Logical Attribute Properties |
| Logical Attribute Name | map_id |
| Datatype | INTEGER |
| Nullable | NO |
| map_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| map_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | map_id | map_id | point | INTEGER | map_id | Unique ID for d_map code table |
| map_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| field_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_field |
| Note |
| field_id Logical Attribute Properties |
| Logical Attribute Name | field_id |
| Datatype | INTEGER |
| Nullable | NO |
| field_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| field_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | field_id | field_id | point | INTEGER | field_id | Unique ID for code table, d_field |
| field_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| est_rank_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_est_rank |
| Note |
| est_rank_id Logical Attribute Properties |
| Logical Attribute Name | est_rank_id |
| Datatype | INTEGER |
| Nullable | NO |
| est_rank_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| est_rank_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | est_rank_id | est_rank_id | point | INTEGER | est_rank_id | Unique ID for code table, d_est_rank |
| est_rank_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| surf_elev_va |
| Logical Only | NO |
| Definition | Elevation of ground surface at point location in decimal meters |
| Note |
| surf_elev_va Logical Attribute Properties |
| Logical Attribute Name | surf_elev_va |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| surf_elev_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| surf_elev_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | surf_elev_va | surf_elev_va | point | NUMERIC | surf_elev_va | Elevation of ground surface at point location in decimal meters |
| surf_elev_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| elev_prec_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_elev_prec |
| Note |
| elev_prec_id Logical Attribute Properties |
| Logical Attribute Name | elev_prec_id |
| Datatype | INTEGER |
| Nullable | NO |
| elev_prec_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| elev_prec_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | elev_prec_id | elev_prec_id | point | INTEGER | elev_prec_id | Unique ID for code table, d_elev_prec |
| elev_prec_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| total_depth_va |
| Logical Only | NO |
| Definition | Total thickness of section, core, log, etc. being stored in meters. This figure must match the sum of the numbers in the THICKNESS column. |
| Note |
| total_depth_va Logical Attribute Properties |
| Logical Attribute Name | total_depth_va |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| total_depth_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| total_depth_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | total_depth_va | total_depth_va | point | NUMERIC | total_depth_va | Total thickness of section, core, log, etc. being stored in meters. This figure must match the sum of the numbers in the THICKNESS column. |
| total_depth_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| local_strike_va |
| Logical Only | NO |
| Definition | Direction of strike, as the number of degrees between 1 and 360, clockwise from north; E=90, S=180, W=270, N=360. |
| Note |
| local_strike_va Logical Attribute Properties |
| Logical Attribute Name | local_strike_va |
| Datatype | NUMERIC(4, 0) |
| Nullable | YES |
| local_strike_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| local_strike_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | local_strike_va | local_strike_va | point | NUMERIC | local_strike_va | Direction of strike, as the number of degrees between 1 and 360, clockwise from north; E=90, S=180, W=270, N=360. |
| local_strike_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| local_dip_va |
| Logical Only | NO |
| Definition | Dip direction in degrees clockwise from North 1 - 360 at right angles to strike |
| Note |
| local_dip_va Logical Attribute Properties |
| Logical Attribute Name | local_dip_va |
| Datatype | NUMERIC(4, 0) |
| Nullable | YES |
| local_dip_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| local_dip_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | local_dip_va | local_dip_va | point | NUMERIC | local_dip_va | Dip direction in degrees clockwise from North 1 - 360 at right angles to strike |
| local_dip_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| local_angle_va |
| Logical Only | NO |
| Definition | Dip angle in degrees clockwise from North |
| Note |
| local_angle_va Logical Attribute Properties |
| Logical Attribute Name | local_angle_va |
| Datatype | NUMERIC(4, 0) |
| Nullable | YES |
| local_angle_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| local_angle_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | local_angle_va | local_angle_va | point | NUMERIC | local_angle_va | Dip angle in degrees clockwise from North |
| local_angle_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| point_description_id |
| Logical Only | NO |
| Definition | Unique ID fo code table, d_point_description |
| Note |
| point_description_id Logical Attribute Properties |
| Logical Attribute Name | point_description_id |
| Datatype | INTEGER |
| Nullable | NO |
| point_description_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| point_description_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | point_description_id | point_description_id | point | INTEGER | point_description_id | Unique ID fo code table, d_point_description |
| point_description_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| weathering_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_weathering |
| Note |
| weathering_id Logical Attribute Properties |
| Logical Attribute Name | weathering_id |
| Datatype | INTEGER |
| Nullable | NO |
| weathering_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| weathering_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | weathering_id | weathering_id | point | INTEGER | weathering_id | Unique ID for code table, d_weathering |
| weathering_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| n_units_va |
| Logical Only | NO |
| Definition | Number of stratigraphic units described in the core, log of section |
| Note |
| n_units_va Logical Attribute Properties |
| Logical Attribute Name | n_units_va |
| Datatype | INTEGER |
| Nullable | NO |
| n_units_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| n_units_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | n_units_va | n_units_va | point | INTEGER | n_units_va | Number of stratigraphic units described in the core, log of section |
| n_units_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| point_comment_tx |
| Logical Only | NO |
| Definition | Additional information not included in other Point fields. |
| Note |
| point_comment_tx Logical Attribute Properties |
| Logical Attribute Name | point_comment_tx |
| Datatype | CHAR(40) |
| Nullable | NO |
| point_comment_tx Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| point_comment_tx Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | point_comment_tx | point_comment_tx | point | CHAR | point_comment_tx | Additional information not included in other Point fields. |
| point_comment_tx User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| lat_lon_prec_id |
| Logical Only | NO |
| Definition | Unique Latitude and longitude ID for code table, d_lat_lon_prec |
| Note |
| lat_lon_prec_id Logical Attribute Properties |
| Logical Attribute Name | lat_lon_prec_id |
| Datatype | INTEGER |
| Nullable | NO |
| lat_lon_prec_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| lat_lon_prec_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | lat_lon_prec_id | lat_lon_prec_id | point | INTEGER | lat_lon_prec_id | Unique Latitude and longitude ID for code table, d_lat_lon_prec |
| lat_lon_prec_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| latitude_tx |
| Logical Only | NO |
| Definition | Latitude in Degree(d), Minute('), Second(") format (e.g., 36d10'22.345") |
| Note |
| latitude_tx Logical Attribute Properties |
| Logical Attribute Name | latitude_tx |
| Datatype | CHAR(16) |
| Nullable | NO |
| latitude_tx Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| latitude_tx Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | latitude_tx | latitude_tx | point | CHAR | latitude_tx | Latitude in Degree(d), Minute('), Second(") format (e.g., 36d10'22.345") |
| latitude_tx User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| longitude_tx |
| Logical Only | NO |
| Definition | Longitude in Degree(d), Minuite('), Second(") format (81d34'12.345") |
| Note |
| longitude_tx Logical Attribute Properties |
| Logical Attribute Name | longitude_tx |
| Datatype | CHAR(16) |
| Nullable | NO |
| longitude_tx Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| longitude_tx Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | longitude_tx | longitude_tx | point | CHAR | longitude_tx | Longitude in Degree(d), Minuite('), Second(") format (81d34'12.345") |
| longitude_tx User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| lat_dec_va |
| Logical Only | NO |
| Definition | Latitude in decimal degrees |
| Note |
| lat_dec_va Logical Attribute Properties |
| Logical Attribute Name | lat_dec_va |
| Datatype | NUMERIC(10, 7) |
| Nullable | NO |
| lat_dec_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| lat_dec_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | lat_dec_va | lat_dec_va | point | NUMERIC | lat_dec_va | Latitude in decimal degrees |
| lat_dec_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| lon_dec_va |
| Logical Only | NO |
| Definition | Longitude in decimal degrees |
| Note |
| lon_dec_va Logical Attribute Properties |
| Logical Attribute Name | lon_dec_va |
| Datatype | NUMERIC(12, 7) |
| Nullable | NO |
| lon_dec_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| lon_dec_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | lon_dec_va | lon_dec_va | point | NUMERIC | lon_dec_va | Longitude in decimal degrees |
| lon_dec_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| range_ew_cd |
| Logical Only | NO |
| Definition | E or W for range east or west designator. |
| Note |
| range_ew_cd Logical Attribute Properties |
| Logical Attribute Name | range_ew_cd |
| Datatype | CHAR(1) |
| Nullable | NO |
| range_ew_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| range_ew_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | range_ew_cd | range_ew_cd | point | CHAR | range_ew_cd | E or W for range east or west designator. |
| range_ew_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| range_va |
| Logical Only | NO |
| Definition | Range decimal point value |
| Note |
| range_va Logical Attribute Properties |
| Logical Attribute Name | range_va |
| Datatype | NUMERIC(10, 2) |
| Nullable | NO |
| range_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| range_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | range_va | range_va | point | NUMERIC | range_va | Range decimal point value |
| range_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| township_ns_cd |
| Logical Only | NO |
| Definition | N or S for township north or south designator. |
| Note |
| township_ns_cd Logical Attribute Properties |
| Logical Attribute Name | township_ns_cd |
| Datatype | CHAR(1) |
| Nullable | NO |
| township_ns_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| township_ns_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | township_ns_cd | township_ns_cd | point | CHAR | township_ns_cd | N or S for township north or south designator. |
| township_ns_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| township_va |
| Logical Only | NO |
| Definition | Township decimal point value |
| Note |
| township_va Logical Attribute Properties |
| Logical Attribute Name | township_va |
| Datatype | NUMERIC(10, 2) |
| Nullable | NO |
| township_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| township_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | township_va | township_va | point | NUMERIC | township_va | Township decimal point value |
| township_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| section_va |
| Logical Only | NO |
| Definition | Section decimal point value |
| Note |
| section_va Logical Attribute Properties |
| Logical Attribute Name | section_va |
| Datatype | NUMERIC(10, 2) |
| Nullable | NO |
| section_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| section_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | section_va | section_va | point | NUMERIC | section_va | Section decimal point value |
| section_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| quarter4_cd |
| Logical Only | NO |
| Definition | Map quarter 4 code |
| Note |
| quarter4_cd Logical Attribute Properties |
| Logical Attribute Name | quarter4_cd |
| Datatype | CHAR(2) |
| Nullable | NO |
| quarter4_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| quarter4_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | quarter4_cd | quarter4_cd | point | CHAR | quarter4_cd | Map quarter 4 code |
| quarter4_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| quarter3_cd |
| Logical Only | NO |
| Definition | Map quarter 3 code |
| Note |
| quarter3_cd Logical Attribute Properties |
| Logical Attribute Name | quarter3_cd |
| Datatype | CHAR(2) |
| Nullable | NO |
| quarter3_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| quarter3_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | quarter3_cd | quarter3_cd | point | CHAR | quarter3_cd | Map quarter 3 code |
| quarter3_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| quarter2_cd |
| Logical Only | NO |
| Definition | Map quarter 2 code |
| Note |
| quarter2_cd Logical Attribute Properties |
| Logical Attribute Name | quarter2_cd |
| Datatype | CHAR(2) |
| Nullable | NO |
| quarter2_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| quarter2_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | quarter2_cd | quarter2_cd | point | CHAR | quarter2_cd | Map quarter 2 code |
| quarter2_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| quarter1_cd |
| Logical Only | NO |
| Definition | Map quarter 1 code |
| Note |
| quarter1_cd Logical Attribute Properties |
| Logical Attribute Name | quarter1_cd |
| Datatype | CHAR(2) |
| Nullable | NO |
| quarter1_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| quarter1_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | quarter1_cd | quarter1_cd | point | CHAR | quarter1_cd | Map quarter 1 code |
| quarter1_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| meridian_va |
| Logical Only | NO |
| Definition | Principal meridian code according to the Federal Information Processing Standards (FIPS) |
| Note |
| meridian_va Logical Attribute Properties |
| Logical Attribute Name | meridian_va |
| Datatype | NUMERIC(2, 0) |
| Nullable | NO |
| meridian_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| meridian_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | meridian_va | meridian_va | point | NUMERIC | meridian_va | Principal meridian code according to the Federal Information Processing Standards (FIPS) |
| meridian_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| collecting_org_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_collecting_org |
| Note |
| collecting_org_id Logical Attribute Properties |
| Logical Attribute Name | collecting_org_id |
| Datatype | INTEGER |
| Nullable | NO |
| collecting_org_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| collecting_org_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | collecting_org_id | collecting_org_id | point | INTEGER | collecting_org_id | Unique ID for code table, d_collecting_org |
| collecting_org_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| collector_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_collector |
| Note |
| collector_id Logical Attribute Properties |
| Logical Attribute Name | collector_id |
| Datatype | INTEGER |
| Nullable | NO |
| collector_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| collector_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | collector_id | collector_id | point | INTEGER | collector_id | Unique ID for code table, d_collector |
| collector_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| prev_collector_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_prev_collector |
| Note |
| prev_collector_id Logical Attribute Properties |
| Logical Attribute Name | prev_collector_id |
| Datatype | INTEGER |
| Nullable | NO |
| prev_collector_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| prev_collector_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | prev_collector_id | prev_collector_id | point | INTEGER | prev_collector_id | Unique ID for code table, d_prev_collector |
| prev_collector_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| source_nm |
| Logical Only | NO |
| Definition | Primary source of data, e.g., Anderson Coal Co., USGS Drilling, Raleigh Co. Rpt., Matson & Blumer. Drill hole numbers and reference page numbers should NOT be entered in source. They should be entered in "point_comment_txt" field. |
| Note |
| source_nm Logical Attribute Properties |
| Logical Attribute Name | source_nm |
| Datatype | VARCHAR(24) |
| Nullable | NO |
| source_nm Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| source_nm Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | source_nm | source_nm | point | VARCHAR | source_nm | Primary source of data, e.g., Anderson Coal Co., USGS Drilling, Raleigh Co. Rpt., Matson & Blumer. Drill hole numbers and reference page numbers should NOT be entered in source. They should be entered in "point_comment_txt" field. |
| source_nm User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| point_usage_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_point_usage |
| Note |
| point_usage_id Logical Attribute Properties |
| Logical Attribute Name | point_usage_id |
| Datatype | INTEGER |
| Nullable | NO |
| point_usage_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| point_usage_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | point_usage_id | point_usage_id | point | INTEGER | point_usage_id | Unique ID for code table, d_point_usage |
| point_usage_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| notes_id |
| Logical Only | NO |
| Definition | Numeric ID number for point notes. Enter 0 for none, otherwise the value of string_id column of point_notes table to reference it |
| Note |
| notes_id Logical Attribute Properties |
| Logical Attribute Name | notes_id |
| Datatype | INTEGER |
| Nullable | NO |
| notes_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| notes_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | notes_id | notes_id | point | INTEGER | notes_id | Numeric ID number for point notes. Enter 0 for none, otherwise the value of string_id column of point_notes table to reference it |
| notes_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |