In order to allow for all of the data to be included in OpenGround Cloud Professional, is there a list of all the extra 'non-standard' mapping that has been added to the system?
In some contracts such as the recent HS2 work in the UK, it has been necessary for a client to request for an AGS file with no added fields contained within from the AGS standard. OpenGround Cloud Professional includes a number of extra fields and mapping for other records that have been added to allow for more functionality in a number of ways. Any of the fields effected are listed below;
| OpenGround Cloud Professional Table | OpenGround Cloud Professional Field | AGS 4 Mapped Field |
|---|---|---|
| TestingScheduleDetails | TestCount | LBST_TCNT |
| EnvironmentalContainerDetails | ContainerID | ECTN_ID |
| EnvironmentalContainerDetails | Remarks | ECTN_REM |
| TestingSchedule | ScheduleType | LBSG_TYPE |
| Project | Office | PROJ_OFFC |
| InitialConsumptionOfLimeGeneral | SizePassing | LSTG_SIZE |
| CompactionGeneral | SieveSize1 | CMPG_SIZ1 |
| CompactionGeneral | SieveSize2 | CMPG_SIZ2 |
| CBRGeneral | SieveSize | CBRG_SIZE |
| LocationDetails | ApprovedBy | LOCA_APPG |
| LocationDetails | CheckedBy | LOCA_CHKG |
| RelativeDensity | SieveSize1 | RELD_SIZ1 |
| RelativeDensity | SieveSize2 | RELD_SIZ2 |
| RelativeDensity | SieveSize3 | RELD_SIZ3 |
| MCVGeneral | SieveSize | MCVG_SIZE |
| FlatDilatometerGeneral | DepthTest | DMDG_DPTH |
| FlatDilatometerGeneral | Remarks | DMDG_REM |
| FlatDilatometerGeneral | tflexTime | DMDG_TFLX |
| FlatDilatometerGeneral | ChHorizontal | DMDG_CH |
| FlatDilatometerGeneral | DateTest | DMDG_DATE |
| FlatDilatometerGeneral | kHorizontal | DMDG_DK |
| FlatDilatometerGeneral | TestNumber | DMTG_TESN |
| FlatDilatometerData | TestNumber | DMTG_TESN |
| FlatDilatometerData | DepthTest | DMDG_DPTH |
| FlatDilatometerData | MinutesElapsed | DMDT_MINS |
| FlatDilatometerData | Reading | DMDT_PTA |
| FlatDilatometerData | Remarks | DMDT_REM |
| ShrinkSwell | AirVoids | SHSW_AV |
| ShrinkSwell | BulkDensityInitial | SHSW_BDEN |
| ShrinkSwell | AccreditionReference | SHSW_CRED |
| ShrinkSwell | DryDensityInitial | SHSW_DDEN |
| ShrinkSwell | ShrinkSwellIndex | SHSW_ISS |
| ShrinkSwell | LaboratoryName | SHSW_LAB |
| ShrinkSwell | MoistureContentShrink | SHSW_MCSH |
| ShrinkSwell | MoistureContentSwell | SHSW_MCSW |
| ShrinkSwell | Method | SHSW_METH |
| ShrinkSwell | ParticleDensity | SHSW_PDEN |
| ShrinkSwell | Remarks | SHSW_REM |
| ShrinkSwell | CrackingRemarks | SHSW_REMC |
| FlatDilatometerSeismicDerived | Dilatometermodulus | DMTP_DED |
| FlatDilatometerSeismicDerived | G0 | DMTP_DGO |
| FlatDilatometerSeismicDerived | Horizontalsressindex | DMTP_DKD |
| FlatDilatometerSeismicDerived | K0 | DMTP_DKO |
| FlatDilatometerSeismicDerived | Materialindex | DMTP_DMID |
| FlatDilatometerSeismicDerived | OCR | DMTP_DOCR |
| FlatDilatometerSeismicDerived | InternalFriction | DMTP_DPHI |
| FlatDilatometerSeismicDerived | qD | DMTP_DQD |
| FlatDilatometerSeismicDerived | Interpretedsoildescription | DMTP_DSD |
| FlatDilatometerSeismicDerived | Cu | DMTP_DSU |
| FlatDilatometerSeismicDerived | M | DMTP_DVDM |
| FlatDilatometerSeismicDerived | InterpretationReference | DMTP_REF |
| FlatDilatometerSeismicDerived | Remarks | DMTP_REM |
| FlatDilatometerSeismicDerived | DepthTest | DMTT_DPTH |
| FlatDilatometerSeismicDerived | TestNumber | DMTG_TESN |
| RingShearData | AngularDisplacement | RSHD_ADIS |
| RingShearData | BulkDensityInitial | RSHD_BDEN |
| RingShearData | ResidualStrengthCriterion | RSHD_CRIT |
| RingShearData | DryDensityInitial | RSHD_DDEN |
| RingShearData | DiameterInner | RSHD_DIA1 |
| RingShearData | DiameterOuter | RSHD_DIA2 |
| RingShearData | AngularRate | RSHD_DISA |
| RingShearData | ResidualStressDisplacementRate | RSHD_DISR |
| RingShearData | SpecimenHeight | RSHD_HGT |
| RingShearData | VoidsRatioInitial | RSHD_IVR |
| RingShearData | MoistureContentFinal | RSHD_MCF |
| RingShearData | MoistureContentInitial | RSHD_MCI |
| RingShearData | NormalStress | RSHD_NORM |
| RingShearData | ParticleDensity | RSHD_PDEN |
| RingShearData | LinearDisplacement | RSHD_RDIS |
| RingShearData | Remarks | RSHD_REM |
| RingShearData | ResidualShearStress | RSHD_RES |
| RingShearData | StageNumber | RSHD_TESN |
| FlatDilatometerSeismicData | CorrectedA | DMTT_APTA |
| FlatDilatometerSeismicData | CorrectedB | DMTT_APTB |
| FlatDilatometerSeismicData | CorrectedC | DMTT_APTC |
| FlatDilatometerSeismicData | DepthTest | DMTT_DPTH |
| FlatDilatometerSeismicData | EffectiveVerticalStressEstimated | DMTT_EEFS |
| FlatDilatometerSeismicData | BulkWeightEstimate | DMTT_EGAM |
| FlatDilatometerSeismicData | TotalVerticalStressEstimated | DMTT_ETVS |
| FlatDilatometerSeismicData | PorewaterPressureEstimated | DMTT_ISPP |
| FlatDilatometerSeismicData | Thrust | DMTT_MTH |
| FlatDilatometerSeismicData | APressure | DMTT_PTA |
| FlatDilatometerSeismicData | BPressure | DMTT_PTB |
| FlatDilatometerSeismicData | CPressure | DMTT_PTC |
| FlatDilatometerSeismicData | Remarks | DMTT_REM |
| FlatDilatometerSeismicData | ShearWaveVelocity | DMTT_SWV |
| FlatDilatometerSeismicData | EstimationMethod | DMTT_TECH |
| FlatDilatometerSeismicData | TestNumber | DMTG_TESN |
| FlatDilatometerSeismicGeneral | TestNumber | DMTG_TESN |
| FlatDilatometerSeismicGeneral | BladeCalibrationA | DMTG_BCVA |
| FlatDilatometerSeismicGeneral | BladeCalibrationB | DMTG_BCVB |
| FlatDilatometerSeismicGeneral | CorrectionFactor | DMTG_CFZM |
| FlatDilatometerSeismicGeneral | Subcontractor | DMTG_CONT |
| FlatDilatometerSeismicGeneral | ThrustMeasurementMethod | DMTG_COT |
| FlatDilatometerSeismicGeneral | Operators | DMTG_CREW |
| FlatDilatometerSeismicGeneral | DateTest | DMTG_DATE |
| FlatDilatometerSeismicGeneral | GroundwaterMethod | DMTG_GWD |
| FlatDilatometerSeismicGeneral | Standard | DMTG_METH |
| FlatDilatometerSeismicGeneral | ReactionMethod | DMTG_MRF |
| FlatDilatometerSeismicGeneral | Remarks | DMTG_REM |
| FlatDilatometerSeismicGeneral | BladeNumber | DMTG_REMB |
| FlatDilatometerSeismicGeneral | SeismicNumber | DMTG_REMS |
| FlatDilatometerSeismicGeneral | RodType | DMTG_TDR |
| FlatDilatometerSeismicGeneral | RigType | DMTG_TYPE |
| FlatDilatometerSeismicGeneral | DepthGroundwater | DMTG_WAT |
| RingShearGeneral | Condition | RSHG_COND |
| RingShearGeneral | AccreditionReference | RSHG_CRED |
| RingShearGeneral | LaboratoryName | RSHG_LAB |
| RingShearGeneral | Method | RSHG_METH |
| RingShearGeneral | Residualcohesionintercept | RSHG_RCOH |
| RingShearGeneral | Remarks | RSHG_REM |
| RingShearGeneral | ResidualFrictionAngle | RSHG_RPHI |
| OrganicContent | AccreditionReference | ORGC_CRED |
| OrganicContent | LaboratoryName | ORGC_LAB |
| OrganicContent | Method | ORGC_METH |
| OrganicContent | OrganicContent | ORGC_OC |
| OrganicContent | Remarks | ORGC_REM |
| AllophaneContent | AllophaneContent | ALLO_AC |
| AllophaneContent | AccreditionReference | ALLO_CRED |
| AllophaneContent | LaboratoryName | ALLO_LAB |
| AllophaneContent | Method | ALLO_METH |
| AllophaneContent | Remarks | ALLO_REM |
| PinholeDispersion | AccreditionReference | PHDC_CRED |
| PinholeDispersion | PinholeClass | PHDC_DC1 |
| PinholeDispersion | LaboratoryName | PHDC_LAB |
| PinholeDispersion | Method | PHDC_METH |
| PinholeDispersion | Remarks | PHDC_REM |