Geotechnical Format: Fixed Misspelling "Environment" [d6902]
Fixed misspelling of "Environment" in the Geotechnical Format.
Geotechnical Format: Remove Unnecessary Lookup [d7476]
Removed lookup for SAMPLING_COMPANY_CODE from the Field_Sample section of the Geotechnical format.
AGS Data Source: Fixed Encoding and Double Quotes Within Field Values [d7889]
Source data values within AGS files are separated by double quotes (""). Fixed an issue when loading AGS Data Source files that contain a double quote within a field value. For example, a coordinate value of 40° 51' 59"" N uses double quotes to represent seconds.
Geotechnical Format: Update Numerous Sections and Fields [d9339]
Modified and added various fields to the Geotechnical format.
Facility_Project:
- office _designation
- project_reviewer
- client_location
- client_contact
- project_status
- logo
- alternative_logo
- depth_log_page
- depth_cpt_page
- depth_dmt_page
- output_units
- cpt_input_units
- recovery_units
- compressive_strength_units
- consol_stress_units
- display_latlong
- display_northing_easting
- display_elevation
- display_recovery
- display_HP
- display_single_unconf_compres_strength
- display_uc_uu_columns
- display_moisture
- display_dry_unit_weight
- display_atterberg_limits
- consolidation_time_plots
- only_graph_cv_for_load
- suppress_lines_btwn_cv
- display_sample_id
Location_Data
- logger
- status
- cave_in_depth
- cave_in_note
- depth_log_page
- alignment
- text_at_base_of_log_yn
- refusal_yn
- refusal_type
Location_Parameters
- measurement_date is required
Drill_Activity
- start_depth is part of the primary key for this section
- cpt_dmt_reactionforce
- hammer_efficiency
Drill_Parameter
- run_length is not required
Test_Pit
- weather
- stability
- custom_field_1
- custom_field_2
- custom_field_3
- custom_field_4
- custom_field_5
Coring
- length_unit
- duration
- duration_unit
Field_Sample
- sample_date is not required
- matrix_code is not required
- sample_desc
- sample_duration
- duration_unit
- reportable_yn
- parent_sample_code
Hole_Diameter
- end_depth is not required
Water_Table
- strike_date is not required
- hours_after is not required
- days_after
Backfill
- completion_date is not required
- end_depth is not required
Well_Construction
- custom_field_1
- custom_field_2
- custom_field_3
- custom_field_4
- custom_field_5
Standard_Penetration
- elevation_accuracy
- datum
- horizontal_accuracy
- custom_field_1
- custom_field_2
- custom_field_3
- custom_field_4
- custom_field_5
Lithology_Data
- uscs_symbol
- uscs_material
- fill_yn
- splitfill_yn
- modifier
- modifying_material
- particle_size_rnge_sand
- particle_size_rnge_grvl
- angularity
- particle_shape
- max_particle_size
- hardness
- plastictiy
- dry_strength
- dilatancy
- toughness
- color
- joining_word
- additional_color
- munsell_color
- odor
- moisture
- consistency
- relative_density
- soil_structure
- cementation
- observation
Water_Content
- date is not required
- test_method allows for 50 characters
- testing_lab
- wc_wet_weight_tare
- wc_dry_weight_tare
- wc_tare_weight
- sample_diameter_1
- sample_diameter_2
- sample_diameter_3
- sample_diameter_average
- sample_height_1
- sample_height_2
- sample_height_3
- sample_height_average
- density_specimen_weight_tare
- density_weight_tare
- temperature
- amount_stabilizer
- type_stabilizer
- wet_unitweight
- dry_unitweight
Atterberg
- date is not required
- testing_lab
- organic
Atterberg_Readings - new section
- sys_sample_code
- date
- reading_number
- wc_wet_weight_tare
- wc_dry_weight_tare
- wc_weight_tare
- att_water_content
- number_of_blows
- cone_penet_initial
- cone_penet_final
- param_number
Other_Lab_Results (new format section). This section will be used for generic lab results that do not belong in the other Lab Testing sections.
- sys_sample_code
- date
- test_type
- accreditation
- test_method
- testing_lab
- geo_result_code
- result
- result_unit
- remark
- reading_number
Added reading_number to all sections, which targets DT_GEO_TEST.
Geotechnical Schema Updates [d9437]
Added various fields to the standard and Geotechnical Schemas:
Standard Schema Changes:
- Create AT_LOCATION which will behave similarly to AT_FACILITY
- DT_SAMPLE.REPORTABLE_YN, VARCHAR(1) – Is sample reportable for analysis? 'Y' for yes or 'N' for no. (i.e., if this is no, then the sample will be removed from analysis and will not report on any output reports.)
- DT_DRILL_ACTIVITY.CPT_DMT_REACTION_FORCE, VARCHAR(50) – The reaction force of the rig used during CPT/DMT.
- DT_DRILL_ACTIVITY.HAMMER_EFFICIENCY, VARCHAR(50) – The efficiency of the hammer. This value can be used to correct N60 values.
- DT_EXCAVATION.STABILITY, VARCHAR(50) – The stability of the trial pit or the trial trench (e.g., stable, not stable)
- DT_EXCAVATION.CUSTOM_FIELD_1
- DT_EXCAVATION.CUSTOM_FIELD_2
- DT_EXCAVATION.CUSTOM_FIELD_3
- DT_EXCAVATION.CUSTOM_FIELD_4
- DT_EXCAVATION.CUSTOM_FIELD_5
Geotechnical Schema Changes:
- DT_GEO_CORING.RECOVERY_LENGTH – Decimal. Recovery length.
- DT_GEO_CORING.RQD_LENGTH – Decimal. RQD length.
- DT_GEO_CORING.LENGTH_UNIT – VARCHAR(15). Units for the recovery length and RQD length.
- DT_GEO_CORING.DURATION – Real, Null. Duration of coring.
- DT_GEO_CORING.DURATION_UNIT – VARCHAR(15), Null. Unit for duration of coring.
- DT_GEO_STANDARD_PENETRATION.SELF_WEIGHT_TYPE – Text(20). Specify whether it is a hammer or rod.
- DT_GEO_TEST_PARAMETER.PARAM_NUMBER – Integer. There are often several DT_GEO_TEST_PARAMETER rows with the same GEO_TEST_ID and PARAM_CODE. This field would be used to distinguish different readings and allow for multiple test parameters per GEO_TEST_ID for the same PARAM_CODE. This field is part of the key for this table.
- Add EQUIS.ADD_WORKFLOW stored procedure to DT_FACILITY in Geotechnical Schema.
- Add EQUIS.ADD_WORKFLOW stored procedure to DT_LOCATION in Geotechnical Schema.
- DT_GEO_TEST.TEST_METHOD – Increase to 50 characters from 20 characters
- DT_GEO_TEST.READING_NUMBER – Integer, Null. This field is used to distinguish different readings and allow for multiple tests when TEST_DATE does not apply.
- DT_GEO_TEST.TEST_DATE – Alter column to be nullable.
- Updated DT_GEO_TEST UQ to include FACILITY_ID, OBJECT_EUID,
TEST_TYPE, TEST_DATE, and READING_NUMBER.
Geotechnical Module: AGS 4 Link Mapping Documentation [d9754]
An AGS 4 Project Mapping file to use in EQuIS Link has been added to the EQuIS Geotechnical Examples folder.