app.py

import gradio as gr
from langchain.prompts import PromptTemplate
from langchain.chains import LLMChain
from langchain.document_loaders import PyPDFLoader
import google.generativeai as genai
import os
from langchain_google_genai import ChatGoogleGenerativeAI

os.environ['GOOGLE_API_KEY'] = "AIzaSyArbqj5BvP8d7aeNsOf-6-5LI_12CO79BI"
genai.configure(api_key = os.environ['GOOGLE_API_KEY'])

### part by part prompts
result_1Point5 = """
"meta": [
    {
      "kind": "Unit",
      "name": "m",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"m\",\"baseMeasurement\":{\"ancestry\":\"L\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:m:",
      "propertyNames": [
        "BitRecord[].DiameterBit",
        "BitRecord[].DiameterPassThrough",
        "BitRecord[].DiameterPilot",
        "OperationsActivity[].ActivityMDTop",
        "OperationsActivity[].ActivityMDBase",
        "OperationsActivity[].ActivityTVDTop",
        "OperationsActivity[].ActivityTVDBase",
        "OperationsActivity[].BitMDTop",
        "OperationsActivity[].BitMDBase",
        "OperationsActivity[].PlannedHoleDepthIn",
        "OperationsActivity[].PlannedHoleDepthOut",
        "OperationsActivity[].TargetDepth",
        "OperationsActivity[].SectionDiameter",
        "StatusInfo[].ReportEndMD",
        "StatusInfo[].ReportEndTVD",
        "StatusInfo[].PlugTopMD",
        "StatusInfo[].DiameterHole",
        "StatusInfo[].DiameterHoleStartMD",
        "StatusInfo[].DiameterPilot",
        "StatusInfo[].DiameterPilotPlanMD",
        "StatusInfo[].DiameterPilotPlanTVD",
        "StatusInfo[].KickoffMD",
        "StatusInfo[].KickoffTVD",
        "StatusInfo[].FormationStrengthMD",
        "StatusInfo[].FormationStrengthTVD",
        "StatusInfo[].CasingDiameterLast",
        "StatusInfo[].CasingMDLast",
        "StatusInfo[].CasingTVDLast",
        "StatusInfo[].MdPlanned",
        "StatusInfo[].DrilledDistance",
        "StatusInfo[].DistDrillRot",
        "StatusInfo[].DistDrillSlid",
        "StatusInfo[].DistReam",
        "StatusInfo[].DistHold",
        "StatusInfo[].DistSteering",
        "StatusInfo[].TvdLot",
        "Weather[].PrecipitationAmount",
        "Weather[].CloudCeiling",
        "Weather[].WaveHeightAverage",
        "Weather[].WaveHeightMax",
        "Weather[].WaveSignificant",
        "Weather[].Visibility",
        "PumpOp[].LinerInnerDiameter",
        "PumpOp[].StrokeLength",
        "PumpOp[].MeasuredDepthBit",
        "MudVolume[].MudVolumeMeasureDepthTop",
        "MudVolume[].MudVolumeMeasureDepthBase",
        "MudVolume[].MudVolumeTvdTop",
        "MudVolume[].MudVolumeTvdBase",
        "MudLosses[].MudLostVolumeMeasureDepthTop",
        "MudLosses[].MudLostVolumeMeasureDepthBase",
        "MudLosses[].MudLostVolumeTvdTop",
        "MudLosses[].MudLostVolumeTvdBase",
        "GasReading[].GasReadingMeasureDepthTop",
        "GasReading[].GasReadingTvdBase"
      ]
    },
    {
      "kind": "Unit",
      "name": "s",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"s\",\"baseMeasurement\":{\"ancestry\":\"T\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:s:",
      "propertyNames": [
        "OperationsActivity[].ActualDuration",
        "OperationsActivity[].PlannedDuration",
        "StatusInfo[].ElapsedTimeStart",
        "StatusInfo[].ElapsedTimeSpud",
        "StatusInfo[].ElapsedTimeLoc",
        "StatusInfo[].ElapsedTimeDrill",
        "StatusInfo[].ElapsedTimeDrillRot",
        "StatusInfo[].ElapsedTimeDrillSlid",
        "StatusInfo[].ElapsedTimeCirc",
        "StatusInfo[].ElapsedTimeReam",
        "StatusInfo[].ElapsedTimeHold",
        "StatusInfo[].ElapsedTimeSteering",
        "TargetDays",
        "TotalDays",
        "TotalNPT"
      ]
    },
    {
      "kind": "Unit",
      "name": "kg/m3",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"kg/m3\",\"baseMeasurement\":{\"ancestry\":\"M/L3\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:kg%2Fm3:",
      "propertyNames": [
        "StatusInfo[].FormationStrength",
        "StatusInfo[].PresLotEmw"
      ]
    },
    {
      "kind": "Unit",
      "name": "m/s",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"m/s\",\"baseMeasurement\":{\"ancestry\":\"L/T\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:m%2Fs:",
      "propertyNames": [
        "StatusInfo[].RopCurrent",
        "StatusInfo[].RopAverage",
        "Weather[].CurrentSeaSpeed",
        "Weather[].WindSpeed"
      ]
    },
    {
      "kind": "Unit",
      "name": "Pa",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"Pa\",\"baseMeasurement\":{\"ancestry\":\"M/LT2\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:Pa:",
      "propertyNames": [
        "StatusInfo[].PresKickTol",
        "StatusInfo[].MAASP",
        "Weather[].BarometricPressure",
        "PumpOp[].PumpPressure",
        "HSE[].PressureAnnular",
        "HSE[].PressureChokeLine",
        "HSE[].PressureChokeMan",
        "HSE[].PressureDiverter",
        "HSE[].PressureKellyHose",
        "HSE[].PressureLastCasing",
        "HSE[].PressureBOPRam",
        "HSE[].PressureStandPipeManifold"
      ]
    },
    {
      "kind": "Unit",
      "name": "m3",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"m3\",\"baseMeasurement\":{\"ancestry\":\"L3\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:m3:",
      "propertyNames": [
        "StatusInfo[].VolKickTol",
        "MudVolume[].MudVolumeStart",
        "MudVolume[].MudVolumeEnd",
        "MudVolume[].MudVolumeBuild",
        "MudVolume[].MudVolumeCasing",
        "MudVolume[].MudVolumeDumped",
        "MudVolume[].MudVolumeHole",
        "MudVolume[].MudVolumeReceived",
        "MudVolume[].MudVolumeReturned",
        "MudVolume[].MudVolumeRiser",
        "MudVolume[].MudVolumeString",
        "MudVolume[].TotalMudVolume",
        "MudVolume[].ExpectedMudVolume",
        "Inventory[].VolumeItem",
        "HSE[].VolumeFluidDischarged",
        "HSE[].VolumeCuttingDischarged",
        "HSE[].VolumeOilCuttingDischarge",
        "HSE[].VolumeWasteDischarged",
        "MudLosses[].MudLostVolumeAbandonDownhole",
        "MudLosses[].MudLostVolumeBehindCasingDownhole",
        "MudLosses[].MudLostVolumeCirculatingDownhole",
        "MudLosses[].MudLostVolumeCementingDownhole",
        "MudLosses[].MudLostVolumeCasingHole",
        "MudLosses[].MudLostVolumeMudCleanerSurface",
        "MudLosses[].MudLostVolumeOtherLocationDownhole",
        "MudLosses[].MudLostVolumeOtherLocationSurface",
        "MudLosses[].MudLostVolumePitsSurface",
        "MudLosses[].MudLostVolumeShakerSurface",
        "MudLosses[].MudLostVolumeTrippingSurface",
        "MudLosses[].TotalMudLostVolumeDownhole",
        "MudLosses[].TotalMudLostVolumeSurface"
      ]
    },
    {
      "kind": "Unit",
      "name": "rad",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"rad\",\"baseMeasurement\":{\"ancestry\":\"A\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:rad:",
      "propertyNames": [
        "Weather[].SeaCurrentDirection",
        "Weather[].WaveDirection",
        "Weather[].WindDirection"
      ]
    },
    {
      "kind": "Unit",
      "name": "K",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"K\",\"baseMeasurement\":{\"ancestry\":\"K\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:K:",
      "propertyNames": [
        "Weather[].SeaTemp",
        "Weather[].SurfaceTempMin",
        "Weather[].SurfaceTempMax",
        "Weather[].WindChillTemp"
      ]
    },
    {
      "kind": "Unit",
      "name": "W/W",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"W/W\",\"baseMeasurement\":{\"ancestry\":\"1\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:W%2FW:",
      "propertyNames": [
        "PumpOp[].PumpEfficiency"
      ]
    },
    {
      "kind": "Unit",
      "name": "m3/s",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"m3/s\",\"baseMeasurement\":{\"ancestry\":\"L3/T\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:m3%2Fs:",
      "propertyNames": [
        "PumpOp[].PumpOutput"
      ]
    },
    {
      "kind": "Unit",
      "name": "rad/s",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"rad/s\",\"baseMeasurement\":{\"ancestry\":\"A/T\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:rad%2Fs:",
      "propertyNames": [
        "PumpOp[].StrokeRate"
      ]
    },
    {
      "kind": "Unit",
      "name": "m3/rad",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"m3/rad\",\"baseMeasurement\":{\"ancestry\":\"L3/A\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:m3%2Frad:",
      "propertyNames": [
        "PumpOp[].PumpDisplacement"
      ]
    },
    {
      "kind": "Unit",
      "name": "kg",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"kg\",\"baseMeasurement\":{\"ancestry\":\"M\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:kg:",
      "propertyNames": [
        "Inventory[].WeightItem"
      ]
    },
    {
      "kind": "Unit",
      "name": "m3/m3",
      "persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"m3/m3\",\"baseMeasurement\":{\"ancestry\":\"1\",\"type\":\"UM\"},\"type\":\"UAD\"}",
      "unitOfMeasureID": "namespace:reference-data--UnitOfMeasure:m3%2Fm3:",
      "propertyNames": [
        "GasReading[].TotalGasMax",
        "GasReading[].TotalGasMin",
        "GasReading[].TotalGasAverage",
        "GasReading[].Methane",
        "GasReading[].Ethane",
        "GasReading[].Propane",
        "GasReading[].Isobutane",
        "GasReading[].Norbutane",
        "GasReading[].Isopentane"
      ]
    }
  ],
"""

attributes_1 = """
id: Previously called ResourceID or SRN which identifies this OSDU resource object without version.,\n
kind: The schema identification for the OSDU resource object following the pattern {Namespace}:{Source}:{Type}:{VersionMajor}.{VersionMinor}.{VersionPatch}. The versioning scheme follows the semantic versioning,\n
version: The version number of this OSDU resource; set by the framework.,\n
acl.owners[]: The list of owners of this data record formatted as an email,\n
acl.viewers[]: The list of viewers to which this data record is accessible/visible/discoverable formatted as an email,\n
legal.legaltags[]: The list of legal tags, which resolve to legal properties (like country of origin, export classification code, etc.) and rules with the help of the Compliance Service.,\n
legal.otherRelevantDataCountries[]: The list of other relevant data countries as an array of two-letter country codes,\n
legal.status: The legal status. Set by the system after evaluation against the compliance rules associated with the "legaltags" using the Compliance Service.,\n
tags: A generic dictionary of string keys mapping to string value. Only strings are permitted as keys and values., \n
createTime: Timestamp of the time at which initial version of this OSDU resource object was created. Set by the System. The value is a combined date-time string in ISO-8601 given in UTC.,\n
createUser: The user reference, which created the first version of this resource object. Set by the System.,\n
modifyTime: Timestamp of the time at which this version of the OSDU resource object was created. Set by the System. The value is a combined date-time string in ISO-8601 given in UTC.,\n
ancestry.parents[]: An array of none, one or many entity references of 'direct parents' in the data platform, which mark the current record as a derivative. In contrast to other relationships, the source record version is required. During record creation or update the ancestry.parents[] relationships are used to collect the legal tags from the sources and aggregate them in the legal.legaltags[] array. As a consequence, should e.g., one or more of the legal tags of the source data expire, the access to the derivatives is also terminated. For details, see ComplianceService tutorial, 'Creating derivative Records'.,\n
modifyUser: The user reference, which created this version of this resource object. Set by the System.,\n
data.GeoContexts[].GeoPoliticalEntityID: Reference to GeoPoliticalEntity.,\n
data.GeoContexts[].GeoTypeID: The GeoPoliticalEntityType reference of the GeoPoliticalEntity (via GeoPoliticalEntityID) for application convenience.,\n
data.GeoContexts[].BasinID: Reference to Basin.,\n
data.GeoContexts[].GeoTypeID: The BasinType reference of the Basin (via BasinID) for application convenience.,\n
data.GeoContexts[].FieldID: Reference to Field.,\n
data.GeoContexts[].GeoTypeID: The fixed type 'Field' for this AbstractGeoFieldContext.,\n
data.GeoContexts[].PlayID: Reference to the play.,\n
data.GeoContexts[].GeoTypeID: The PlayType reference of the Play (via PlayID) for application convenience.,\n
data.GeoContexts[].ProspectID: Reference to the prospect.,\n
data.GeoContexts[].GeoTypeID: The ProspectType reference of the Prospect (via ProspectID) for application convenience.,\n
data.SpatialLocation.SpatialLocationCoordinatesDate: Date when coordinates were measured or retrieved.,\n
data.SpatialLocation.QuantitativeAccuracyBandID: An approximate quantitative assessment of the quality of a location (accurate to > 500 m (i.e. not very accurate)), to < 1 m, etc.,\n
data.SpatialLocation.QualitativeSpatialAccuracyTypeID: A qualitative description of the quality of a spatial location, e.g. unverifiable, not verified, basic validation.,\n
data.SpatialLocation.CoordinateQualityCheckPerformedBy: The user who performed the Quality Check.,\n
data.SpatialLocation.CoordinateQualityCheckDateTime: The date of the Quality Check,\n
data.SpatialLocation.CoordinateQualityCheckRemarks[]: Freetext remarks on Quality Check.,\n
data.SpatialLocation.AsIngestedCoordinates: The original or 'as ingested' coordinates (Point, MultiPoint, LineString, MultiLineString, Polygon or MultiPolygon). The name 'AsIngestedCoordinates' was chosen to contrast it to 'OriginalCoordinates', which carries the uncertainty whether any coordinate operations took place before ingestion. In cases where the original CRS is different from the as-ingested CRS, the AppliedOperations can also contain the list of operations applied to the coordinate prior to ingestion. The data structure is similar to GeoJSON FeatureCollection, however in a CRS context explicitly defined within the AbstractAnyCrsFeatureCollection. The coordinate sequence follows GeoJSON standard, i.e. 'eastward/longitude', 'northward/latitude' {, 'upward/height' unless overridden by an explicit direction in the AsIngestedCoordinates.VerticalCoordinateReferenceSystemID}. Fragment Description: A schema like GeoJSON FeatureCollection with a non-WGS 84 CRS context; based on https://geojson.org/schema/FeatureCollection.json. Attention: the coordinate order is fixed: Longitude/Easting/Westing/X first, followed by Latitude/Northing/Southing/Y, optionally height as third coordinate,\n
data.SpatialLocation.Wgs84Coordinates: The normalized coordinates (Point, MultiPoint, LineString, MultiLineString, Polygon or MultiPolygon) based on WGS 84 (EPSG:4326 for 2-dimensional coordinates, EPSG:4326 + EPSG:5714 (MSL) for 3-dimensional coordinates). This derived coordinate representation is intended for global discoverability only. The schema of this substructure is identical to the GeoJSON FeatureCollection https://geojson.org/schema/FeatureCollection.json. The coordinate sequence follows GeoJSON standard, i.e. longitude, latitude {, height} Fragment Description: GeoJSON feature collection as originally published in https://geojson.org/schema/FeatureCollection.json. Attention: the coordinate order is fixed: Longitude first, followed by Latitude, optionally height above MSL (EPSG:5714) as third coordinate.,\n
data.SpatialLocation.AppliedOperations[]: The audit trail of operations applied to the coordinates from the original state to the current state. The list may contain operations applied prior to ingestion as well as the operations applied to produce the Wgs84Coordinates. The text elements refer to ESRI style CRS and Transformation names, which may have to be translated to EPSG standard names.,\n
data.SpatialLocation.SpatialParameterTypeID: A type of spatial representation of an object, often general (e.g. an Outline, which could be applied to Field, Reservoir, Facility, etc.) or sometimes specific (e.g. Onshore Outline, State Offshore Outline, Federal Offshore Outline, 3 spatial representations that may be used by Countries).,\n
data.SpatialLocation.SpatialGeometryTypeID: Indicates the expected look of the SpatialParameterType, e.g. Point, MultiPoint, LineString, MultiLineString, Polygon, MultiPolygon. The value constrains the type of geometries in the GeoJSON Wgs84Coordinates and AsIngestedCoordinates.,\n
data.VersionCreationReason: This describes the reason that caused the creation of a new version of this master data.,\n
data.TechnicalAssurances[].TechnicalAssuranceTypeID: Describes a record's overall suitability for general business consumption based on data quality. Clarifications: Since Certified is the highest classification of suitable quality, any further change or versioning of a Certified record should be carefully considered and justified. If a Technical Assurance value is not populated then one can assume the data has not been evaluated or its quality is unknown (=Unevaluated). Technical Assurance values are not intended to be used for the identification of a single "preferred" or "definitive" record by comparison with other records.,\n
data.TechnicalAssurances[].Reviewers[].EmailAddress: Contact email address. Property may be left empty where it is inappropriate to provide personally identifiable information.,\n
data.TechnicalAssurances[].Reviewers[].PhoneNumber: Contact phone number. Property may be left empty where it is inappropriate to provide personally identifiable information.,\n
data.TechnicalAssurances[].Reviewers[].RoleTypeID: The identifier of a reference value for the role of the contact within the associated organisation, such as Account owner, Sales Representative, Technical Support, Project Manager, Party Chief, Client Representative, Senior Observer.,\n
data.TechnicalAssurances[].Reviewers[].DataGovernanceRoleTypeID: The data governance role assigned to this contact if and only if the context has a data governance role (in context of TechnicalAssurance). The value is kept absent in all other cases.,\n
data.TechnicalAssurances[].Reviewers[].WorkflowPersonaTypeID: The persona in context of workflows associated with this contact, as used in TechnicalAssurance.,\n
data.TechnicalAssurances[].Reviewers[].Comment: Additional information about the contact,\n
data.TechnicalAssurances[].Reviewers[].OrganisationID: Reference to the company the contact is associated with.,\n
data.TechnicalAssurances[].Reviewers[].Name: Name of the individual contact. Property may be left empty where it is inappropriate to provide personally identifiable information.,\n
data.TechnicalAssurances[].AcceptableUsage[].WorkflowUsageTypeID: Name of the business activities, processes, and/or workflows that the record's technical assurance value is valid for.,\n
data.TechnicalAssurances[].AcceptableUsage[].WorkflowPersonaTypeID: Name of the role or personas that the record's technical assurance value is valid for.,\n
data.TechnicalAssurances[].AcceptableUsage[].DataQualityRuleSetID: The DataQualityRuleSet, which had to pass successfully to achieve this level of technical assurance.,\n
data.TechnicalAssurances[].AcceptableUsage[].DataQualityID: The relationship to a work-product-component--DataQuality assessment record, which was used as the basis for this decision.,\n
data.TechnicalAssurances[].AcceptableUsage[].ValueChainStatusTypeID: The stage of business where the record is acceptable for workflow usage.,\n
data.TechnicalAssurances[].UnacceptableUsage[].WorkflowUsageTypeID: Name of the business activities, processes, and/or workflows that the record's technical assurance value is not valid for.,\n
data.TechnicalAssurances[].UnacceptableUsage[].WorkflowPersonaTypeID: Name of the role or personas that the record is technical assurance value is not valid for.,\n
data.TechnicalAssurances[].UnacceptableUsage[].DataQualityRuleSetID: The DataQualityRuleSet, which did not pass successfully to achieve this level of technical assurance.,\n
data.TechnicalAssurances[].UnacceptableUsage[].DataQualityID: The relationship to a work-product-component--DataQuality assessment record, which was used as the basis for this decision.,\n
data.TechnicalAssurances[].UnacceptableUsage[].ValueChainStatusTypeID: The stage of business where the record is not acceptable for workflow usage.,\n
data.TechnicalAssurances[].EffectiveDate: Date when the technical assurance determination for this record has taken place,\n
data.TechnicalAssurances[].Comment: Any additional context to support the determination of technical assurance,\n
"""

JSON_file1 = """
{
  "id": <<id>>,
  "kind": <<kind>>,
  "version": <<version>>,
  "acl": {
    "owners": [
      <<acl.owners[]>>
    ],
    "viewers": [
      <<acl.viewers[]>>
    ]
  },
  "legal": {
    "legaltags": [
      <<legal.legaltags[]>>
    ],
    "otherRelevantDataCountries": [
      <<legal.otherRelevantDataCountries[]>>
    ],
    "status": <<legal.status>>
  },
  "tags": {<<tags>>},
  "createTime": <<createTime>>,
  "createUser": <<createUser>>,
  "modifyTime": <<modifyTime>>,
  "modifyUser": <<modifyUser>>,
  "ancestry": {
    "parents": [<<ancestry.parents[]>>]
  }
    "data": {
    "ResourceHomeRegionID": "namespace:reference-data--OSDURegion:AWSEastUSA:",
    "ResourceHostRegionIDs": [
      "namespace:reference-data--OSDURegion:AWSEastUSA:"
    ],
    "ResourceCurationStatus": "namespace:reference-data--ResourceCurationStatus:Created:",
    "ResourceLifecycleStatus": "namespace:reference-data--ResourceLifecycleStatus:Loading:",
    "ResourceSecurityClassification": "namespace:reference-data--ResourceSecurityClassification:Public:",
    "Source": "Example Data Source",
    "ExistenceKind": "namespace:reference-data--ExistenceKind:Prototype:",
    "NameAliases": [
      {
        "AliasName": "Example AliasName",
        "AliasNameTypeID": "namespace:reference-data--AliasNameType:RegulatoryIdentifier:",
        "DefinitionOrganisationID": "namespace:master-data--Organisation:SomeUniqueOrganisationID:",
        "EffectiveDateTime": "2020-02-13T09:13:15.55Z",
        "TerminationDateTime": "2020-02-13T09:13:15.55Z"
      }
    ],
    "GeoContexts": [
      {
        "GeoPoliticalEntityID": <<data.GeoContexts[].GeoPoliticalEntityID>>,
        "GeoTypeID": <<data.GeoContexts[].GeoTypeID>>
      },
      {
        "BasinID": <<data.GeoContexts[].BasinID>>,
        "GeoTypeID": <<data.GeoContexts[].GeoTypeID>>
      },
      {
        "FieldID": <<data.GeoContexts[].FieldID>>,
        "GeoTypeID": <<data.GeoContexts[].GeoTypeID>>
      },
      {
        "PlayID": <<data.GeoContexts[].PlayID>>,
        "GeoTypeID": <<data.GeoContexts[].GeoTypeID>>
      },
      {
        "ProspectID": <<data.GeoContexts[].ProspectID>>,
        "GeoTypeID": <<data.GeoContexts[].GeoTypeID>>
      }
    ],
    "SpatialLocation": {
      "SpatialLocationCoordinatesDate": <<data.SpatialLocation.SpatialLocationCoordinatesDate>>,
      "QuantitativeAccuracyBandID": <<data.SpatialLocation.QuantitativeAccuracyBandID>>,
      "QualitativeSpatialAccuracyTypeID": <<data.SpatialLocation.QualitativeSpatialAccuracyTypeID>>,
      "CoordinateQualityCheckPerformedBy": <<data.SpatialLocation.CoordinateQualityCheckPerformedBy>>,
      "CoordinateQualityCheckDateTime": <<data.SpatialLocation.CoordinateQualityCheckDateTime>>,
      "CoordinateQualityCheckRemarks": [
        <<data.SpatialLocation.CoordinateQualityCheckRemarks[]>>
      ],
      "AsIngestedCoordinates": {
      <<data.SpatialLocation.AsIngestedCoordinates>>
      },
      "Wgs84Coordinates": {
        <<data.SpatialLocation.Wgs84Coordinates>>
      },
      "AppliedOperations": [
        <<data.SpatialLocation.AppliedOperations[]>>
      ],
      "SpatialParameterTypeID": <<data.SpatialLocation.SpatialParameterTypeID>>,
      "SpatialGeometryTypeID": <<data.SpatialLocation.SpatialGeometryTypeID>>
    },
    "VersionCreationReason": <<data.VersionCreationReason>>,
    "TechnicalAssuranceTypeID": <<data.TechnicalAssurances[].TechnicalAssuranceTypeID>>,
    "TechnicalAssurances": [
      {
        "TechnicalAssuranceTypeID": <<data.TechnicalAssurances[].TechnicalAssuranceTypeID>>,
        "Reviewers": [
          {
            "RoleTypeID": <<data.TechnicalAssurances[].Reviewers[].RoleTypeID>>,
            "DataGovernanceRoleTypeID": <<data.TechnicalAssurances[].Reviewers[].DataGovernanceRoleTypeID>>,
            "WorkflowPersonaTypeID": <<data.TechnicalAssurances[].Reviewers[].WorkflowPersonaTypeID>>,
            "OrganisationID": <<data.TechnicalAssurances[].Reviewers[].OrganisationID>>,
            "Name": <<data.TechnicalAssurances[].Reviewers[].Name>>
          }
        ],
        "AcceptableUsage": [
          {
            "WorkflowUsageTypeID": <<data.TechnicalAssurances[].AcceptableUsage[].WorkflowUsageTypeID>>,
            "WorkflowPersonaTypeID": <<data.TechnicalAssurances[].AcceptableUsage[].WorkflowPersonaTypeID>>,
            "DataQualityRuleSetID": <<data.TechnicalAssurances[].AcceptableUsage[].DataQualityRuleSetID>>,
            "DataQualityID": <<data.TechnicalAssurances[].AcceptableUsage[].DataQualityID>>,
            "ValueChainStatusTypeID": <<data.TechnicalAssurances[].AcceptableUsage[].ValueChainStatusTypeID>>
          }
        ],
        "UnacceptableUsage": [
          {
            "WorkflowUsageTypeID": <<data.TechnicalAssurances[].UnacceptableUsage[].WorkflowUsageTypeID>>,
            "WorkflowPersonaTypeID": <<data.TechnicalAssurances[].UnacceptableUsage[].WorkflowPersonaTypeID>>,
            "DataQualityRuleSetID": <<data.TechnicalAssurances[].UnacceptableUsage[].DataQualityRuleSetID>>,
            "DataQualityID": <<data.TechnicalAssurances[].UnacceptableUsage[].DataQualityID>>,
            "ValueChainStatusTypeID": <<data.TechnicalAssurances[].UnacceptableUsage[].ValueChainStatusTypeID>>
          }
        ],
        "EffectiveDate": <<data.TechnicalAssurances[].EffectiveDate>>,
        "Comment": <<data.TechnicalAssurances[].Comment>>
      }
    ],
"""

attributes_2 = """
data.StartDateTime: Date and time that the reporting period started. A report period is commonly 24 hours.,\n
data.EndDateTime: Date and time that the reporting period ended. A report period is commonly 24 hours.,\n
data.BitRecord[].NumBit: Bit number and rerun number e.g. "4.1" for the first rerun of bit 4.,\n
data.BitRecord[].DiameterBit: Diameter of drilled hole.,\n
data.BitRecord[].DiameterPassThrough: Minimum hole or tubing which bit will pass through (for bi-center bits).,\n
data.BitRecord[].DiameterPilot: Diameter of pilot bit (for bi-center bits).,\n
data.BitRecord[].Manufacturer: Manufacturer / supplier of the item.,\n
data.BitRecord[].TypeBit: Type of bit.,\n
data.BitRecord[].Cost: Bit cost in local currency.,\n
data.BitRecord[].CostCurrency: The name of the local currency,\n
data.BitRecord[].MfgCode: The manufacturers code for the bit.,\n
data.BitRecord[].IADCCode: IADC bit code.,\n
data.BitRecord[].InitialConditionInner: Condition of inner tooth rows (inner 2/3 of bit) (0-8).,\n
data.BitRecord[].InitialConditionOuter: Condition of outer tooth rows (outer 1/3 of bit) (0-8).,\n
data.BitRecord[].InitialConditionDull: Overall dull condition from IADC bit wear 2 character codes.,\n
data.BitRecord[].InitialConditionLocation: Row and cone numbers for items which need location information (e.g. Cracked Cone, Lost Cone etc).,\n
data.BitRecord[].InitialConditionBearing: Condition of bit bearings (integer 0-8 or E, F, N or X)).,\n
data.BitRecord[].InitialConditionGauge: Condition of bit gauge in 1/16 of an inch. I = in gauge, else number of 16ths out of gauge.,\n
data.BitRecord[].InitialConditionOther: Other comments on bit condition from IADC list (BitDullCode in standard list).,\n
data.BitRecord[].InitialConditionReason: Reason bit was pulled from IADC codes.,\n
data.BitRecord[].FinalConditionInner: Condition of inner tooth rows (inner 2/3 of bit) (0-8).,\n
data.BitRecord[].FinalConditionOuter: Condition of outer tooth rows (outer 1/3 of bit) (0-8).,\n
data.BitRecord[].FinalConditionDull: Overall dull condition from IADC bit wear 2 character codes.,\n
data.BitRecord[].FinalConditionLocation: Row and cone numbers for items which need location information (e.g. Cracked Cone, Lost Cone etc).,\n
data.BitRecord[].FinalConditionBearing: Condition of bit bearings (integer 0-8 or E, F, N or X).,\n
data.BitRecord[].FinalConditionGauge: Condition of bit gauge in 1/16 of a inch. I = in gauge, else number of 16ths out of gauge.,\n
data.BitRecord[].FinalConditionOther: Other comments on bit condition from IADC list (BitDullCode in Standard LISTS).,\n
data.BitRecord[].FinalConditionReason: Reason bit was pulled from IADC codes.,\n
data.BitRecord[].DriveType: Bit drive type (Motor, rotary table etc),\n
data.BitRecord[].BitClass: N = new, U = used.,\n
data.OperationsActivity[].ActivityID: Identifier of the activity.,\n
data.OperationsActivity[].StartDateTime: Date and time that activities started.,\n
data.OperationsActivity[].EndDateTime: Date and time that activities ended.,\n
data.OperationsActivity[].ActualDuration: Actual duration of the activity.,\n
data.OperationsActivity[].Phase: Phase refers to a large activity classification, e.g., drill surface hole.,\n
data.OperationsActivity[].ActivityCodeID: The activity code of the activity,\n
data.OperationsActivity[].DetailActivity: Custom string to further define an activity.,\n
data.OperationsActivity[].TypeActivityClassID: Classifier (planned, unplanned, downtime).,\n
data.OperationsActivity[].ActivityMDTop: Measured depth at the top of interval over which the activity was conducted.,\n
data.OperationsActivity[].ActivityMDBase: Measured depth at the base of interval over which the activity was conducted.,\n
data.OperationsActivity[].ActivityTVDTop: TVD at the top of interval over which the activity was conducted.,\n
data.OperationsActivity[].ActivityTVDBase: TVD at the base of interval over which the activity was conducted.,\n
data.OperationsActivity[].BitMDTop: Measured depth of the bit at the top of interval over which the activity was conducted.,\n
data.OperationsActivity[].BitMDBase: Measured depth of the bit at the ase of interval over which the activity was conducted.,\n
data.OperationsActivity[].ActivityOutcomeID: OK, Finish, interrupted, failed, etc.,\n
data.OperationsActivity[].ActivityOutcomeDetailID: More detail on the outcome of the activity. For Example Injury, Operation Failed, Kick, Circulation Loss, Mud Loss,\n
data.OperationsActivity[].OperatorID: Reference to the Organisation that represents the Operator,\n
data.OperationsActivity[].ServiceProviderID: Reference to the Organisation that represents the Service Provider,\n
data.OperationsActivity[].TubularID: A pointer to the tubular object related to this activity. Not the Hole Section that you are operating within.,\n
data.OperationsActivity[].IsOptimum: Is the activity optimum? Values are "true" (or "1") and "false" (or "0").,\n
data.OperationsActivity[].IsProductive: Does activity bring closer to objective? Values are "true" (or "1") and "false" (or "0").,\n
data.OperationsActivity[].IsOffline: Is the activity an Offline activity, Values are "true" (or "1") and "false" (or "0"),\n
data.OperationsActivity[].ItemState: The item state for the data object. (Actual, Planned, Unknown and Modeled),\n
data.OperationsActivity[].Comments: Comments and remarks.,\n
data.OperationsActivity[].ProprietaryActivityCode[].Identifier: Identifier property,\n
data.OperationsActivity[].ProprietaryActivityCode[].Description: Description Property,\n
data.OperationsActivity[].ProprietaryActivityCode[].Authority: Authority property,\n
data.OperationsActivity[].ParentID: The UID of the parent activity,\n
data.OperationsActivity[].PredecessorID: The UID of the preceding activity,\n
data.OperationsActivity[].PlannedHoleDepthIn: The planned hole depth at the start of the activity,\n
data.OperationsActivity[].PlannedHoleDepthOut: The planned hole depth at the end of the activity,\n
data.OperationsActivity[].PlannedDuration: The planned duration for the activity.,\n
data.OperationsActivity[].TargetDepth: The target depth of the activity,\n
data.OperationsActivity[].OperationalNotes: Notes associated with the operation,\n
data.OperationsActivity[].AttachmentIDs[]: Attachments associated with the activity,\n
data.OperationsActivity[].SectionDiameter: The Diameter of the section in which the activity took place,\n
data.OperationsActivity[].ObjectReference: link to an external object or document. For example Regulatory submission, Tour sheet.,\n
data.OperationsActivity[].WellboreID: A Reference to the wellbore in which the activities take place.,\n
"""

JSON_file2 = """
    "StartDateTime": <<data.StartDateTime>>,
    "EndDateTime": <<data.EndDateTime>>,
    "BitRecord": [
      {
        "NumBit": <<data.BitRecord[].NumBit>>,
        "DiameterBit": <<data.BitRecord[].DiameterBit>>,
        "DiameterPassThrough": <<data.BitRecord[].DiameterPassThrough>>,
        "DiameterPilot": <<data.BitRecord[].DiameterPilot>>,
        "Manufacturer": <<data.BitRecord[].Manufacturer>>,
        "TypeBit": <<data.BitRecord[].TypeBit>>,
        "Cost": <<data.BitRecord[].Cost>>,
        "CostCurrency": <<data.BitRecord[].CostCurrency>>,
        "MfgCode": <<data.BitRecord[].MfgCode>>,
        "IADCCode": <<data.BitRecord[].IADCCode>>,
        "InitialConditionInner": <<data.BitRecord[].InitialConditionInner>>,
        "InitialConditionOuter": <<data.BitRecord[].InitialConditionOuter>>,
        "InitialConditionDull": <<data.BitRecord[].InitialConditionDull>>,
        "InitialConditionLocation": <<data.BitRecord[].InitialConditionLocation>>,
        "InitialConditionBearing": <<data.BitRecord[].InitialConditionBearing>>,
        "InitialConditionGauge": <<data.BitRecord[].InitialConditionGauge>>,
        "InitialConditionOther": <<data.BitRecord[].InitialConditionOther>>,
        "InitialConditionReason": <<data.BitRecord[].InitialConditionReason>>,
        "FinalConditionInner": <<data.BitRecord[].FinalConditionInner>>,
        "FinalConditionOuter": <<data.BitRecord[].FinalConditionOuter>>,
        "FinalConditionDull": <<data.BitRecord[].FinalConditionDull>>,
        "FinalConditionLocation": <<data.BitRecord[].FinalConditionLocation>>,
        "FinalConditionBearing": <<data.BitRecord[].FinalConditionBearing>>,
        "FinalConditionGauge": <<data.BitRecord[].FinalConditionGauge>>,
        "FinalConditionOther": <<data.BitRecord[].FinalConditionOther>>,
        "FinalConditionReason": <<data.BitRecord[].FinalConditionReason>>,
        "DriveType": <<data.BitRecord[].DriveType>>,
        "BitClass": <<data.BitRecord[].BitClass>>
      }
    ],
"OperationsActivity": [
      {
        "ActivityID": <<data.OperationsActivity[].ActivityID>>,
        "StartDateTime": <<data.OperationsActivity[].StartDateTime>>,
        "EndDateTime": <<data.OperationsActivity[].EndDateTime>>,
        "ActualDuration": <<data.OperationsActivity[].ActualDuration>>,
        "Phase": <<data.OperationsActivity[].Phase>>,
        "ActivityCodeID": <<data.OperationsActivity[].ActivityCodeID>>,
        "DetailActivity": <<data.OperationsActivity[].DetailActivity>>,
        "TypeActivityClassID": <<data.OperationsActivity[].TypeActivityClassID>>,
        "ActivityMDTop": <<data.OperationsActivity[].ActivityMDTop>>,
        "ActivityMDBase": <<data.OperationsActivity[].ActivityMDBase>>,
        "ActivityTVDTop": <<data.OperationsActivity[].ActivityTVDTop>>,
        "ActivityTVDBase": <<data.OperationsActivity[].ActivityTVDBase>>,
        "BitMDTop": <<data.OperationsActivity[].BitMDTop>>,
        "BitMDBase": <<data.OperationsActivity[].BitMDBase>>,
        "ActivityOutcomeID": <<data.OperationsActivity[].ActivityOutcomeID>>,
        "ActivityOutcomeDetailID": <<data.OperationsActivity[].ActivityOutcomeDetailID>>,
        "OperatorID": <<data.OperationsActivity[].OperatorID>>,
        "ServiceProviderID": <<data.OperationsActivity[].ServiceProviderID>>,
        "TubularID": <<data.OperationsActivity[].TubularID>>,
        "IsOptimum": <<data.OperationsActivity[].IsOptimum>>,
        "IsProductive": <<data.OperationsActivity[].IsProductive>>,
        "IsOffline": <<data.OperationsActivity[].IsOffline>>,
        "ItemState": <<data.OperationsActivity[].ItemState>>,
        "Comments": <<data.OperationsActivity[].Comments>>,
        "ProprietaryActivityCode": [
          {
            "Identifier": <<data.OperationsActivity[].ProprietaryActivityCode[].Identifier>>,
            "Description": <data.OperationsActivity[].ProprietaryActivityCode[].Description>>,
            "Authority": <<data.OperationsActivity[].ProprietaryActivityCode[].Authority>>
          }
        ],
        "ParentID": <<data.OperationsActivity[].ParentID>>,
        "PredecessorID": <<data.OperationsActivity[].PredecessorID>>,
        "PlannedHoleDepthIn": <<data.OperationsActivity[].PlannedHoleDepthIn>>,
        "PlannedHoleDepthOut": <<data.OperationsActivity[].PlannedHoleDepthOut>>,
        "PlannedDuration": <<data.OperationsActivity[].PlannedDuration>>,
        "TargetDepth": <<data.OperationsActivity[].TargetDepth>>,
        "OperationalNotes": <<data.OperationsActivity[].OperationalNotes>>,
        "AttachmentIDs": [
          <<data.OperationsActivity[].AttachmentIDs[]>>
        ],
        "SectionDiameter": <<data.OperationsActivity[].SectionDiameter>>,
        "ObjectReference": <<data.OperationsActivity[].ObjectReference>>,
        "WellboreID": <<data.OperationsActivity[].WellboreID>>
      }
    ],
"""

attributes_3 = """
data.WellboreID: A link to the wellbore that was active at the end of this report period.,\n
data.WellAlias.Identifier: Identifier property,\n
data.WellAlias.Description: Description Property,\n
data.WellAlias.Authority: Authority property,\n
data.WellboreAlias[]: Local name defined for the wellbore Fragment Description: Definition of an alias,\n
data.WellboreAlias[].Identifier: Identifier property,\n
data.WellboreAlias[].Description: Description Property,\n
data.WellboreAlias[].Authority: Authority property,\n
data.StatusInfo[].StatusDateTime: The date and time for which the well status is reported.,\n
data.StatusInfo[].ReportEndMD: Wellbore measured depth at the end of the report period.,\n
data.StatusInfo[].ReportEndTVD: Wellbore true vertical depth at the end of the report.,\n
data.StatusInfo[].PlugTopMD: The measured plug back depth.,\n
data.StatusInfo[].DiameterHole: Hole nominal inside diameter.,\n
data.StatusInfo[].DiameterHoleStartMD: Measured depth to the start of the current hole diameter.,\n
data.StatusInfo[].DiameterPilot: Pilot hole nominal inside diameter.,\n
data.StatusInfo[].DiameterPilotPlanMD: The planned measured depth of the pilot hole.,\n
data.StatusInfo[].DiameterPilotPlanTVD: The planned true vertical depth of the pilot hole.,\n
data.StatusInfo[].TypeWellbore: Type of wellbore.,\n
data.StatusInfo[].KickoffMD: Measured depth to the kickoff point of the wellbore.,\n
data.StatusInfo[].KickoffTVD: True vertical depth to the kickoff point of the wellbore.,\n
data.StatusInfo[].FormationStrength: The measured formation strength. This should be the final measurement before the end of the report period.,\n
data.StatusInfo[].FormationStrengthMD: The measured depth of the formation strength measurement.,\n
data.StatusInfo[].FormationStrengthTVD: The true vertical depth of the formation strength measurement.,\n
data.StatusInfo[].CasingDiameterLast: Diameter of the last casing joint.,\n
data.StatusInfo[].CasingMDLast: Measured depth of the last casing joint.,\n
data.StatusInfo[].CasingTVDLast: True vertical depth of last casing joint.,\n
data.StatusInfo[].PresTestType: The type of pressure test that was run.,\n
data.StatusInfo[].MdPlanned: The measured depth planned to be reached.,\n
data.StatusInfo[].DrilledDistance: Distance drilled. This should be measured along the centerline of the wellbore.,\n
data.StatusInfo[].Summary24Hr: A summary of the activities performed and the status of the ongoing activities.,\n
data.StatusInfo[].Forecast24Hr: A summary of planned activities for the next reporting period.,\n
data.StatusInfo[].RopCurrent: Rate of penetration at the end of the reporting period.,\n
data.StatusInfo[].Rig: A pointer to the rig used.,\n
data.StatusInfo[].ElapsedTimeStart: Time from the start of operations (commonly in days).,\n
data.StatusInfo[].ElapsedTimeSpud: Time since the bit broke ground (commonly in days).,\n
data.StatusInfo[].ElapsedTimeLoc: Time the rig has been on location (commonly in days).,\n
data.StatusInfo[].ElapsedTimeDrill: Drilling time.,\n
data.StatusInfo[].RopAverage: Average rate of penetration.,\n
data.StatusInfo[].Supervisor: Name of the rig supervisor,\n
data.StatusInfo[].Engineer: Name of the operator's drilling engineer.,\n
data.StatusInfo[].Geologist: Name of operator's wellsite geologist.,\n
data.StatusInfo[].ElapsedTimeDrillRot: Time spent rotary drilling.,\n
data.StatusInfo[].ElapsedTimeDrillSlid: Time spent slide drilling from the start of the bit run.,\n
data.StatusInfo[].ElapsedTimeCirc: Time spent circulating from the start of the bit run.,\n
data.StatusInfo[].ElapsedTimeReam: Time spent reaming from the start of the bit run.,\n
data.StatusInfo[].ElapsedTimeHold: Time spent with no directional drilling work (commonly in hours).,\n
data.StatusInfo[].ElapsedTimeSteering: Time spent steering the bottomhole assembly (commonly in hours).,\n
data.StatusInfo[].DistDrillRot: Distance drilled: rotating.,\n
data.StatusInfo[].DistDrillSlid: Distance drilled: sliding.,\n
data.StatusInfo[].DistReam: Distance reamed.,\n
data.StatusInfo[].DistHold: Distance covered while holding angle with a steerable drilling assembly.,\n
data.StatusInfo[].DistSteering: Distance covered while actively steering with a steerable drilling assembly.,\n
data.StatusInfo[].NumPOB: Total number of personnel on board the rig.,\n
data.StatusInfo[].NumContract: Number of contractor personnel on the rig.,\n
data.StatusInfo[].NumOperator: Number of operator personnel on the rig.,\n
data.StatusInfo[].NumService: Number of service company personnel on the rig.,\n
data.StatusInfo[].NumAFE: Authorization for expenditure (AFE) number that this cost item applies to.,\n
data.StatusInfo[].ConditionHole: Description of the hole condition.,\n
data.StatusInfo[].TvdLot: True vertical depth of a leak off test point.,\n
data.StatusInfo[].PresLotEmw: Leak off test equivalent mud weight.,\n
data.StatusInfo[].PresKickTol: Kick tolerance pressure.,\n
data.StatusInfo[].VolKickTol: Kick tolerance volume.,\n
data.StatusInfo[].MAASP: Maximum allowable shut-in casing pressure.,\n
data.StatusInfo[].Tubular: A pointer to the tubular (assembly) used in this report period.,\n
data.StatusInfo[].CostDayMud: The cost per day of the mud used,\n
data.FluidsIDs[]: References to the Fluids Reports generated during this reporting period.,\n
data.PorePressure[]: A reference to the PPFG information for this reporting period,\n
data.TimedComments[].Comment: A comment that has been recorded at a particular time,\n
data.TimedComments[].CommentTime: The time that the comment was made,\n
data.Weather[].Agency: Name of company that supplied the weather data.,\n
data.Weather[].PrecipitationAmount: Amount of precipitation.,\n
data.Weather[].SeaCurrentDirection: Azimuth of current.,\n
data.Weather[].WaveDirection: The direction from which the waves are coming, measured from true north.,\n
data.Weather[].WindDirection: The direction from which the wind is blowing, measured from true north.,\n
data.Weather[].BarometricPressure: Atmospheric pressure.,\n
data.Weather[].BeaufortScaleNumber: The Beaufort wind force scale is a system used to estimate and report wind speeds when no measuring apparatus is available. It was invented in the early 19th century by Admiral Sir Francis Beaufort of the British Navy as a way to interpret winds from conditions. Values range from 0 (calm) to 12 (hurricane force).,\n
data.Weather[].CloudCeiling: Height of cloud cover.,\n
data.Weather[].Comments: Comments and remarks,\n
data.Weather[].CloudCover: Description of cloud cover.,\n
data.Weather[].CurrentSeaSpeed: The speed of the ocean current.,\n
data.Weather[].DateTime: Date and time that weather was observed,\n
data.Weather[].WaveHeightAverage: Average height of the sea waves.,\n
data.Weather[].WaveHeightMax: The maximum wave height.,\n
data.Weather[].WavePeriodDuration: The elapsed time between the passing of two wave tops.,\n
data.Weather[].WaveSignificant: An average of the higher 1/3 of the wave heights passing during a sample period (typically 20 to 30 minutes).,\n
data.Weather[].SeaTemp: Sea temperature.,\n
data.Weather[].SurfaceTempMin: Minimum temperature above ground. Temperature of the atmosphere.,\n
data.Weather[].SurfaceTempMax: Maximum temperature above ground.,\n
data.Weather[].WindChillTemp: A measure of the combined chilling effect of wind and low temperature on living things, also named chill factor, e.g., according to the US weather service table, an air temperature of 30 degF with a 10 mph corresponds to a windchill of 22 degF.,\n
data.Weather[].WeatherType: Type of weather.,\n
data.Weather[].WindSpeed: Wind speed.,\n
data.Weather[].Visibility: Horizontal visibility.,\n
data.Personnel[].OrganizationID: A Reference to the organization for which have their headcount measured during this report,\n
data.Personnel[].HeadCount: Number of persons on board or on location for the selected company/organization. HeadCount should be reported as a non-negative integer.,\n
data.Personnel[].TotalTime: Total time worked by the company (commonly in hours).,\n
data.Personnel[].OrganizationRole: Role the organization is playing for the service being provided,\n
data.Personnel[].ServiceType: Service provided by the company.,\n
data.Personnel[].Comments: Comments and remarks,\n
"""

JSON_file3 = """
"WellboreID": <<data.WellboreID>>,
    "WellAlias": {
      "Identifier": <<data.WellAlias.Identifier>>,
      "Description": <<data.WellAlias.Description>>,
      "Authority": <<data.WellAlias.Authority>>
    },
    "WellboreAlias": [
      {
        "Identifier": <<data.WellboreAlias[].Identifier>>,
        "Description": <<data.WellboreAlias[].Description>>,
        "Authority": <<data.WellboreAlias[].Authority>>
      }
    ],
    "StatusInfo": [
      {
        "StatusDateTime": <<data.StatusInfo[].StatusDateTime>>,
        "ReportEndMD": <<data.StatusInfo[].ReportEndMD>>,
        "ReportEndTVD": <<data.StatusInfo[].ReportEndTVD>>,
        "PlugTopMD": <<data.StatusInfo[].PlugTopMD>>,
        "DiameterHole": <<data.StatusInfo[].DiameterHole>>,
        "DiameterHoleStartMD": <<data.StatusInfo[].DiameterHoleStartMD>>,
        "DiameterPilot": <<data.StatusInfo[].DiameterPilot>>,
        "DiameterPilotPlanMD": <<data.StatusInfo[].DiameterPilotPlanMD>>,
        "DiameterPilotPlanTVD": <<data.StatusInfo[].DiameterPilotPlanTVD>>,
        "TypeWellbore": <<data.StatusInfo[].TypeWellbore>>,
        "KickoffMD": <<data.StatusInfo[].KickoffMD>>,
        "KickoffTVD": <<data.StatusInfo[].KickoffTVD>>,
        "FormationStrength": <<data.StatusInfo[].FormationStrength>>,
        "FormationStrengthMD": <<data.StatusInfo[].FormationStrengthMD>>,
        "FormationStrengthTVD": <<data.StatusInfo[].FormationStrengthTVD>>,
        "CasingDiameterLast": <<data.StatusInfo[].CasingDiameterLast>>,
        "CasingMDLast": <<data.StatusInfo[].CasingMDLast>>,
        "CasingTVDLast": <<data.StatusInfo[].CasingTVDLast>>,
        "PresTestType": <<data.StatusInfo[].PresTestType>>,
        "MdPlanned": <<data.StatusInfo[].MdPlanned>>,
        "DrilledDistance": <<data.StatusInfo[].DrilledDistance>>,
        "Summary24Hr": <<data.StatusInfo[].Summary24Hr>>,
        "Forecast24Hr": <<data.StatusInfo[].Forecast24Hr>>,
        "RopCurrent": <<data.StatusInfo[].RopCurrent>>,
        "Rig": <<data.StatusInfo[].Rig>>,
        "ElapsedTimeStart": <<data.StatusInfo[].ElapsedTimeStart>>,
        "ElapsedTimeSpud": <<data.StatusInfo[].ElapsedTimeSpud>>,
        "ElapsedTimeLoc": <<data.StatusInfo[].ElapsedTimeLoc>>,
        "ElapsedTimeDrill": <<data.StatusInfo[].ElapsedTimeDrill>>,
        "RopAverage": <<data.StatusInfo[].RopAverage>>,
        "Supervisor": <<data.StatusInfo[].Supervisor>>,
        "Engineer": <<data.StatusInfo[].Engineer>>,
        "Geologist": <<data.StatusInfo[].Geologist>>,
        "ElapsedTimeDrillRot": <<data.StatusInfo[].ElapsedTimeDrillRot>>,
        "ElapsedTimeDrillSlid": <<data.StatusInfo[].ElapsedTimeDrillSlid>>,
        "ElapsedTimeCirc": <<data.StatusInfo[].ElapsedTimeCirc>>,
        "ElapsedTimeReam": <<data.StatusInfo[].ElapsedTimeReam>>,
        "ElapsedTimeHold": <<data.StatusInfo[].ElapsedTimeHold>>,
        "ElapsedTimeSteering": <<data.StatusInfo[].ElapsedTimeSteering>>,
        "DistDrillRot": <<data.StatusInfo[].DistDrillRot>>,
        "DistDrillSlid": <<data.StatusInfo[].DistDrillSlid>>,
        "DistReam": <<data.StatusInfo[].DistReam>>,
        "DistHold": <<data.StatusInfo[].DistHold>>,
        "DistSteering": <<data.StatusInfo[].DistSteering>>,
        "NumPOB": <<data.StatusInfo[].NumPOB>>,
        "NumContract": <<data.StatusInfo[].NumContract>>,
        "NumOperator": <<data.StatusInfo[].NumOperator>>,
        "NumService": <<data.StatusInfo[].NumService>>,
        "NumAFE": <<data.StatusInfo[].NumAFE>>,
        "ConditionHole": <<data.StatusInfo[].ConditionHole>>,
        "TvdLot": <<data.StatusInfo[].TvdLot>>,
        "PresLotEmw": <<data.StatusInfo[].PresLotEmw>>,
        "PresKickTol": <<data.StatusInfo[].PresKickTol>>,
        "VolKickTol": <<data.StatusInfo[].VolKickTol>>,
        "MAASP": <<data.StatusInfo[].MAASP>>,
        "Tubular": <<data.StatusInfo[].Tubular>>,
        "CostDayMud": <<data.StatusInfo[].CostDayMud>>
      }
    ],
    "FluidsIDs": [
      <<data.FluidsIDs[]>>
    ],
    "PorePressure": [
      <<data.PorePressure[]>>
    ],
    "TimedComments": [
      {
        "Comment": <<data.TimedComments[].Comment>>,
        "CommentTime": <<data.TimedComments[].CommentTime>>
      }
    ],
    "Weather": [
      {
        "Agency": <<data.Weather[].Agency>>,
        "PrecipitationAmount": <<data.Weather[].PrecipitationAmount>>,
        "SeaCurrentDirection": <<data.Weather[].SeaCurrentDirection>>,
        "WaveDirection": <<data.Weather[].WaveDirection>>,
        "WindDirection": <<data.Weather[].WindDirection>>,
        "BarometricPressure": <<data.Weather[].BarometricPressure>>,
        "BeaufortScaleNumber": <<data.Weather[].BeaufortScaleNumber>>,
        "CloudCeiling": <<data.Weather[].CloudCeiling>>,
        "Comments": <<data.Weather[].Comments>>,
        "CloudCover": <<data.Weather[].CloudCover>>,
        "CurrentSeaSpeed": <<data.Weather[].CurrentSeaSpeed>>,
        "DateTime": <<data.Weather[].DateTime>>,
        "WaveHeightAverage": <<data.Weather[].WaveHeightAverage>>,
        "WaveHeightMax": <<data.Weather[].WaveHeightMax>>,
        "WavePeriodDuration": <<data.Weather[].WavePeriodDuration>>,
        "WaveSignificant": <<data.Weather[].WaveSignificant>>,
        "SeaTemp": <<data.Weather[].SeaTemp>>,
        "SurfaceTempMin": <<data.Weather[].SurfaceTempMin>>,
        "SurfaceTempMax": <<data.Weather[].SurfaceTempMax>>,
        "WindChillTemp": <<data.Weather[].WindChillTemp>>,
        "WeatherType": <<data.Weather[].WeatherType>>,
        "WindSpeed": <<data.Weather[].WindSpeed>>,
        "Visibility": <<data.Weather[].Visibility>>
      }
    ],
    "Personnel": [
      {
        "OrganizationID": <<data.Personnel[].OrganizationID>>,
        "HeadCount": <<data.Personnel[].HeadCount>>,
        "TotalTime": <<data.Personnel[].TotalTime>>,
        "OrganizationRole": <<data.Personnel[].OrganizationRole>>,
        "ServiceType": <<data.Personnel[].ServiceType>>,
        "Comments": <<data.Personnel[].Comments>>
      }
    ],
"""

attributes_4 = """
data.PumpOp[].DateTime: Date and time when the pump operation occurred,\n
data.PumpOp[].LinerInnerDiameter: Liner inside diameter.,\n
data.PumpOp[].StrokeLength: Pump stroke length.,\n
data.PumpOp[].MeasuredDepthBit: Along-hole measured depth of the measurement from the drill datum.,\n
data.PumpOp[].PumpEfficiency: Pump efficiency.,\n
data.PumpOp[].PumpPressure: Pump pressure recorded.,\n
data.PumpOp[].PumpNumber: The sequence number of the pump (e.g., pump 1),\n
data.PumpOp[].PumpOutput: Pump output (included for efficiency).,\n
data.PumpOp[].StrokeRate: Pump rate (strokes per minute).,\n
data.PumpOp[].OperationType: Type of pump operation.,\n
data.PumpOp[].Comments: Comments and remarks,\n
data.PumpOp[].PumpDisplacement: how much fluid is moved by the pump in one cycle,\n
data.PumpOp[].PumpModelName: The model name for the pump,\n
data.MudVolume[].MudVolumeStart: Volume of mud at start of report interval (including pits and hole).,\n
data.MudVolume[].MudVolumeEnd: Volume of mud at the end of the report interval (including pits and hole).,\n
data.MudVolume[].DateTime: Date and time of the mud volume,\n
data.MudVolume[].MudVolumeMeasureDepthTop: Top measured depth for which the mud volume reading was conducted,\n
data.MudVolume[].MudVolumeMeasureDepthBase: Bottom measured depth for which the mud volume reading was conducted,\n
data.MudVolume[].MudVolumeTvdTop: Top true vertical depth interval over which the mud volume reading was conducted.,\n
data.MudVolume[].MudVolumeTvdBase: Bottom true vertical depth interval over which the mud volume reading was conducted.,\n
data.MudVolume[].MudVolumeBuild: Volume of mud built.,\n
data.MudVolume[].MudVolumeCasing: Volume of mud contained in casing annulus.,\n
data.MudVolume[].MudVolumeDumped: Volume of mud dumped.,\n
data.MudVolume[].MudVolumeHole: Volume of mud contained in the openhole annulus.,\n
data.MudVolume[].MudVolumeReceived: Volume of mud received from mud warehouse.,\n
data.MudVolume[].MudVolumeReturned: Volume of mud returned to mud warehouse.,\n
data.MudVolume[].MudVolumeRiser: Volume of mud contained in riser section annulus.,\n
data.MudVolume[].MudVolumeString: Volume of mud contained within active string.,\n
data.MudVolume[].TotalMudVolume: Actual total mud volume that was measured,\n
data.MudVolume[].ExpectedMudVolume: Total mud volume that was expected,\n
data.MudVolume[].Comments: Comments and remarks,\n
data.Inventory[].CostOfItem: Cost for the product for the report interval.,\n
data.Inventory[].VolumeItem: Item volume per unit.,\n
data.Inventory[].WeightItem: Item weight per unit.,\n
data.Inventory[].Name: Name or type of inventory item.,\n
data.Inventory[].PricePerUnit: Price per item unit, assume same currency for all items.,\n
data.Inventory[].TotalQuantityAdjustment: Daily quantity adjustment/correction.,\n
data.Inventory[].TotalQuantityOnLocation: Amount of the item remaining on location after all adjustments for the report interval.,\n
data.Inventory[].TotalQuantityReceived: Quantity received at the site.,\n
data.Inventory[].TotalQuantityReturned: Quantity returned to base from site.,\n
data.Inventory[].TotalQuantityStart: Start quantity for report interval.,\n
data.Inventory[].TotalQuantityUsed: Quantity used for the report interval.,\n
data.Inventory[].Comments: Comments and remarks,\n
data.Inventory[].ItemDescription: Description of the inventory item,\n
data.Cost[].Comments: Comments and remarks,\n
data.Cost[].TotalCostAmount: Total cost for the item for this period,\n
data.Cost[].CostCurrency: Currency used for Cost Amount,\n
data.Cost[].CostClass: Cost class code.,\n
data.Cost[].CostCode: Cost code.,\n
data.Cost[].CostGroup: Cost group code.,\n
data.Cost[].ItemDescription: Description of the cost item.,\n
data.Cost[].UnitCost: Cost per item, assume same currency.,\n
data.Cost[].CostSubCode: Cost subcode.,\n
data.Cost[].IsEstimated: Is this an estimated cost?,\n
data.Cost[].IsCarryOver: Is this item carried from day to day?,\n
data.Cost[].IsRental: Is this item a rental?,\n
data.Cost[].UnitKind: The kind of cost item specified (e.g., barrel, sack, gallon),\n
data.Cost[].UnitSize: Quantity of the unit kind (e.g., 50),\n
data.Cost[].TagName: An identification tag for the item. A serial number is a type of identification tag; however, some tags contain many pieces of information. This element only identifies the tag and does not describe the contents.,\n
data.Cost[].VendorName: Name of the vendor.,\n
data.Cost[].AFENumber: AFE number that this cost item applies to.,\n
data.Cost[].InvoiceNumber: Invoice number for cost item; the bill is sent to the operator.,\n
data.Cost[].PONumber: Purchase order number provided by the operator.,\n
data.Cost[].ItemSerialNumber: Serial number.,\n
data.Cost[].TicketNumber: The field ticket number issued by the service company on location.,\n
data.Cost[].VendorNumber: Vendor number.,\n
data.Cost[].CostPoolName: Name of pool/reservoir that this cost item can be accounted to.,\n
data.Cost[].TotalQuantityItemsUsed: Number of cost items used that day, e.g., 1 rig dayrate, 30 joints of casing.,\n
data.Cost[].ActivityPhaseID: Activity code classification describing higher level steps in the Well Activity,\n
data.Cost[].InUse: Used to indicate if Equipment or Service in scope for the Cost Item is being used. Can drive different Standby/In Use Rental Rates where applicable.,\n
data.Cost[].ProductType: High Level cost category qualifier,\n
"""

JSON_file4 = """
"PumpOp": [
      {
        "DateTime": <<data.PumpOp[].DateTime>>,
        "LinerInnerDiameter": <<data.PumpOp[].LinerInnerDiameter>>,
        "StrokeLength": <<data.PumpOp[].StrokeLength>>,
        "MeasuredDepthBit": <<data.PumpOp[].MeasuredDepthBit>>,
        "PumpEfficiency": <<data.PumpOp[].PumpEfficiency>>,
        "PumpPressure": <<data.PumpOp[].PumpPressure>>,
        "PumpNumber": <<data.PumpOp[].PumpNumber>>,
        "PumpOutput": <<data.PumpOp[].PumpOutput>>,
        "StrokeRate": <<data.PumpOp[].StrokeRate>>,
        "OperationType": <<data.PumpOp[].OperationType>>,
        "Comments": <<data.PumpOp[].Comments>>,
        "PumpDisplacement": <<data.PumpOp[].PumpDisplacement>>,
        "PumpModelName": <<data.PumpOp[].PumpModelName>>
      }
    ],
    "MudVolume": [
      {
        "MudVolumeStart": <<data.MudVolume[].MudVolumeStart>>,
        "MudVolumeEnd": <<data.MudVolume[].MudVolumeEnd>>,
        "DateTime": <<data.MudVolume[].DateTime>>,
        "MudVolumeMeasureDepthTop": <<data.MudVolume[].MudVolumeMeasureDepthTop>>,
        "MudVolumeMeasureDepthBase": <<data.MudVolume[].MudVolumeMeasureDepthBase>>,
        "MudVolumeTvdTop": <<data.MudVolume[].MudVolumeTvdTop>>,
        "MudVolumeTvdBase": <<data.MudVolume[].MudVolumeTvdBase>>,
        "MudVolumeBuild": <<data.MudVolume[].MudVolumeBuild>>,
        "MudVolumeCasing": <<data.MudVolume[].MudVolumeCasing>>,
        "MudVolumeDumped": <<data.MudVolume[].MudVolumeDumped>>,
        "MudVolumeHole": <<data.MudVolume[].MudVolumeHole>>,
        "MudVolumeReceived": <<data.MudVolume[].MudVolumeReceived>>,
        "MudVolumeReturned": <<data.MudVolume[].MudVolumeReturned>>,
        "MudVolumeRiser": <<data.MudVolume[].MudVolumeRiser>>,
        "MudVolumeString": <<data.MudVolume[].MudVolumeString>>,
        "TotalMudVolume": <<data.MudVolume[].TotalMudVolume>>,
        "ExpectedMudVolume": <<data.MudVolume[].ExpectedMudVolume>>,
        "Comments": <<data.MudVolume[].Comments>>
      }
    ],
    "Inventory": [
      {
        "CostOfItem": <<data.Inventory[].CostOfItem>>,
        "VolumeItem": <<data.Inventory[].VolumeItem>>,
        "WeightItem": <<data.Inventory[].WeightItem>>,
        "Name": <<data.Inventory[].Name>>,
        "PricePerUnit": <<data.Inventory[].PricePerUnit>>,
        "TotalQuantityAdjustment": <<data.Inventory[].TotalQuantityAdjustment>>,
        "TotalQuantityOnLocation": <<data.Inventory[].TotalQuantityOnLocation>>,
        "TotalQuantityReceived": <<data.Inventory[].TotalQuantityReceived>>,
        "TotalQuantityReturned": <<data.Inventory[].TotalQuantityReturned>>,
        "TotalQuantityStart": <<data.Inventory[].TotalQuantityStart>>,
        "TotalQuantityUsed": <<data.Inventory[].TotalQuantityUsed>>,
        "Comments": <<data.Inventory[].Comments>>,
        "ItemDescription": <<data.Inventory[].ItemDescription>>
      }
    ],
    "Cost": [
      {
        "Comments": <<data.Cost[].Comments>>,
        "TotalCostAmount": <<data.Cost[].TotalCostAmount>>,
        "CostCurrency": <<data.Cost[].CostCurrency>>,
        "CostClass": <<data.Cost[].CostClass>>,
        "CostCode": <<data.Cost[].CostCode>>,
        "CostGroup": <<data.Cost[].CostGroup>>,
        "ItemDescription": <<data.Cost[].ItemDescription>>,
        "UnitCost": <<data.Cost[].UnitCost>>,
        "CostSubCode": <<data.Cost[].CostSubCode>>,
        "IsEstimated": <<data.Cost[].IsEstimated>>,
        "IsCarryOver": <<data.Cost[].IsCarryOver>>,
        "IsRental": <<data.Cost[].IsRental>>,
        "UnitKind": <<data.Cost[].UnitKind>>,
        "UnitSize": <<data.Cost[].UnitSize>>,
        "TagName": <<data.Cost[].TagName>>,
        "VendorName": <<data.Cost[].VendorName>>,
        "AFENumber": <<data.Cost[].AFENumber>>,
        "InvoiceNumber": <<data.Cost[].InvoiceNumber>>,
        "PONumber": <<data.Cost[].PONumber>>,
        "ItemSerialNumber": <<data.Cost[].ItemSerialNumber>>,
        "TicketNumber": <<data.Cost[].TicketNumber>>,
        "VendorNumber": <<data.Cost[].VendorNumber>>,
        "CostPoolName": <<data.Cost[].CostPoolName>>,
        "TotalQuantityItemsUsed": <<data.Cost[].TotalQuantityItemsUsed>>,
        "ActivityPhaseID": <<data.Cost[].ActivityPhaseID>>,
        "InUse": <<data.Cost[].InUse>>,
        "ProductType": <<data.Cost[].ProductType>>
      }
    ],
"""

attributes_5 = """
data.HSE[].Comments: Comments and remarks,\n
data.HSE[].DaysIncidentFree: Incident free duration (commonly in days).,\n
data.HSE[].VolumeFluidDischarged: Daily whole mud discarded.,\n
data.HSE[].LastAbandonDrillDate: Last abandonment drill.,\n
data.HSE[].LastBopDrillDate: Last blow out preventer drill.,\n
data.HSE[].LastBopPressureTestDate: Last blow out preventer pressure test.,\n
data.HSE[].LastCasingPressureTestDate: Last casing pressure test date and time.,\n
data.HSE[].LastDiverterDrillDate: Last diverter drill.,\n
data.HSE[].LastFireBoatDrillDate: Last fire or life boat drill.,\n
data.HSE[].LastRigInspectionDate: Last rig inspection/check.,\n
data.HSE[].LastSafetyInspectionDate: Last safety inspection.,\n
data.HSE[].LastSafetyMeetingDate: Last safety meeting.,\n
data.HSE[].LastTripDrillDate: Last trip drill.,\n
data.HSE[].NextBopPresTestDate: Next blow out preventer pressure test.,\n
data.HSE[].NonComplianceIssued: Inspection non-compliance notice served?,\n
data.HSE[].TotalStopCards: Number of health, safety and environment incidents reported.,\n
data.HSE[].PressureAnnular: Blow out preventer annular preventer pressure tested to.,\n
data.HSE[].PressureChokeLine: Choke line pressure tested to.,\n
data.HSE[].PressureChokeMan: Choke line manifold pressure tested to.,\n
data.HSE[].PressureDiverter: Blow out preventer diverter pressure tested to.,\n
data.HSE[].PressureKellyHose: Kelly hose pressure tested to.,\n
data.HSE[].PressureLastCasing: Last casing pressure test pressure.,\n
data.HSE[].PressureBOPRam: Blow out preventer ram pressure tested to.,\n
data.HSE[].PressureStandPipeManifold: Standpipe manifold pressure tested to.,\n
data.HSE[].RegulatoryAgencyInspection: Governmental regulatory inspection agency inspection?,\n
data.HSE[].VolumeCuttingDischarged: Volume of cuttings discharged.,\n
data.HSE[].VolumeOilCuttingDischarge: Oil on cuttings daily discharge.,\n
data.HSE[].VolumeWasteDischarged: Volume of sanitary waste discharged.,\n
data.Incident[].Comments: Comments and remarks,\n
data.Incident[].DateTime: Date and time that incident occurred,\n
data.Incident[].CauseDescription: Cause description.,\n
data.Incident[].CostLossEstimate: Gross estimate of the cost incurred due to the incident.,\n
data.Incident[].AccidentDescription: Accident description.,\n
data.Incident[].LocationDescription: Location description.,\n
data.Incident[].EstimateHoursLost: Number of hours lost due to the incident.,\n
data.Incident[].IsNearMiss: Near miss incident occurrence?,\n
data.Incident[].TotalFatality: Number of personnel killed due to the incident.,\n
data.Incident[].TotalMajorInjury: Number of personnel with major injuries.,\n
data.Incident[].TotalMinorInjury: Number of personnel with minor injuries.,\n
data.Incident[].RemedialActionDescription: Remedial action description.,\n
data.Incident[].IncidentReporterName: Name of the person who prepared the incident report.,\n
data.Incident[].OrganisationID: A reference to the organisation for which is the company primarily involved in managing the incident.,\n
data.MudLosses[].Comments: Comments and remarks,\n
data.MudLosses[].DateTime: Date and time that the mud loss occurred,\n
data.MudLosses[].MudLostVolumeMeasureDepthTop: Top measured depth for which the mud loss reading was occurred,\n
data.MudLosses[].MudLostVolumeMeasureDepthBase: Bottom measured depth for which the mud loss reading was occurred,\n
data.MudLosses[].MudLostVolumeTvdTop: Top true vertical depth interval over which the mud loss reading was occurred,\n
data.MudLosses[].MudLostVolumeTvdBase: Bottom true vertical depth interval over which the mud loss reading was occurred,\n
data.MudLosses[].MudLostVolumeAbandonDownhole: Mud volume lost downhole during abandonment.,\n
data.MudLosses[].MudLostVolumeBehindCasingDownhole: Mud volume lost downhole behind casing.,\n
data.MudLosses[].MudLostVolumeCirculatingDownhole: Mud volume lost downhole while circulating.,\n
data.MudLosses[].MudLostVolumeCementingDownhole: Mud volume lost downhole while cementing.,\n
data.MudLosses[].MudLostVolumeCasingHole: Mud volume lost downhole running casing,\n
data.MudLosses[].MudLostVolumeMudCleanerSurface: Volume of mud lost in mud cleaning equipment (at surface).,\n
data.MudLosses[].MudLostVolumeOtherLocationDownhole: Mud volume lost downhole from other location.,\n
data.MudLosses[].MudLostVolumeOtherLocationSurface: Surface volume lost other location.,\n
data.MudLosses[].MudLostVolumePitsSurface: Volume of mud lost in pit room (at surface).,\n
data.MudLosses[].MudLostVolumeShakerSurface: Volume of mud lost at shakers (at surface).,\n
data.MudLosses[].MudLostVolumeTrippingSurface: Volume of mud lost while tripping (at surface).,\n
data.MudLosses[].TotalMudLostVolumeDownhole: Total volume of mud lost downhole.,\n
data.MudLosses[].TotalMudLostVolumeSurface: Total volume of mud lost at surface.,\n
data.JobContact[].EmailAddress: Contact email address. Property may be left empty where it is inappropriate to provide personally identifiable information.,\n
data.JobContact[].PhoneNumber: Contact phone number. Property may be left empty where it is inappropriate to provide personally identifiable information.,\n
data.JobContact[].RoleTypeID: The identifier of a reference value for the role of the contact within the associated organisation, such as Account owner, Sales Representative, Technical Support, Project Manager, Party Chief, Client Representative, Senior Observer.,\n
data.JobContact[].DataGovernanceRoleTypeID: The data governance role assigned to this contact if and only if the context has a data governance role (in context of TechnicalAssurance). The value is kept absent in all other cases.,\n
data.JobContact[].WorkflowPersonaTypeID: The persona in context of workflows associated with this contact, as used in TechnicalAssurance.,\n
data.JobContact[].Comment: Additional information about the contact,\n
data.JobContact[].OrganisationID: Reference to the company the contact is associated with.,\n
data.JobContact[].Name: Name of the individual contact. Property may be left empty where it is inappropriate to provide personally identifiable information.,\n
data.GasReading[].DateTime: Date and time of the gas reading.,\n
data.GasReading[].TotalGasMax: The highest gas reading.,\n
data.GasReading[].TotalGasMin: The lowest gas reading.,\n
data.GasReading[].TotalGasAverage: The average gas reading,\n
data.GasReading[].GasReadingMeasureDepthTop: Top measured depth for which the gas reading was conducted,\n
data.GasReading[].GasReadingTvdBase: Bottom true vertical depth interval over which the gas reading was conducted.,\n
data.GasReading[].Methane: Methane (C1) concentration,\n
data.GasReading[].Ethane: Ethane (C2) concentration.,\n
data.GasReading[].Propane: Propane (C3) concentration.,\n
data.GasReading[].Isobutane: Iso-butane (iC4) concentration.,\n
data.GasReading[].Norbutane: Nor-butane (nC4) concentration.,\n
data.GasReading[].Isopentane: Iso-pentane (iC5) concentration,\n
data.GasReading[].ReadingType: Type of gas reading, e.g.circulating, background gas, connection gas, drilling background, gas, drilling gas peak, flow check gas, no readings, other, shut down gas, trip gas, unknown.,\n
data.ConditionHole: Hole condition description.,\n
data.CostDay: Daily cost.,\n
data.CostDayMud: Daily mud cost.,\n
data.Lithology: Description of the lithology for the interval.,\n
data.TotalCost: Cumulative cost for the job through the end of current report,\n
data.TargetCost: Authorized cost for the total job,\n
data.TargetDays: Planned days for the total job,\n
data.TotalDays: Cumulative days for the job through the end of the current report,\n
data.TotalNPT: Total days of non-productive time through the end of the current report,\n
data.Name: Name of Operations Report,\n
data.WellActivityID: A link to the well activity to which this report is associated.,\n
data.ReportNumber: Sequential number assigned to report header,\n
data.ReportDescription: Report description,\n
data.ReportRemarks: Report remarks,\n
"""

JSON_file5 = """
"HSE": [
      {
        "Comments": <<data.HSE[].Comments>>,
        "DaysIncidentFree": <<data.HSE[].DaysIncidentFree>>,
        "VolumeFluidDischarged": <<data.HSE[].VolumeFluidDischarged>>,
        "LastAbandonDrillDate": <<data.HSE[].LastAbandonDrillDate>>,
        "LastBopDrillDate": <<data.HSE[].LastBopDrillDate>>,
        "LastBopPressureTestDate": <<data.HSE[].LastBopPressureTestDate>>,
        "LastCasingPressureTestDate": <<data.HSE[].LastCasingPressureTestDate>>,
        "LastDiverterDrillDate": <<data.HSE[].LastDiverterDrillDate>>,
        "LastFireBoatDrillDate": <<data.HSE[].LastFireBoatDrillDate>>,
        "LastRigInspectionDate": <<data.HSE[].LastRigInspectionDate>>,
        "LastSafetyInspectionDate": <<data.HSE[].LastSafetyInspectionDate>>,
        "LastSafetyMeetingDate": <<data.HSE[].LastSafetyMeetingDate>>,
        "LastTripDrillDate": <<data.HSE[].LastTripDrillDate>>,
        "NextBopPresTestDate": <<data.HSE[].NextBopPresTestDate>>,
        "NonComplianceIssued": <<data.HSE[].NonComplianceIssued>>,
        "TotalStopCards": <<data.HSE[].TotalStopCards>>,
        "PressureAnnular": <<data.HSE[].PressureAnnular>>,
        "PressureChokeLine": <<data.HSE[].PressureChokeLine>>,
        "PressureChokeMan": <<data.HSE[].PressureChokeMan>>,
        "PressureDiverter": <<data.HSE[].PressureDiverter>>,
        "PressureKellyHose": <<data.HSE[].PressureKellyHose>>,
        "PressureLastCasing": <<data.HSE[].PressureLastCasing>>,
        "PressureBOPRam": <<data.HSE[].PressureBOPRam>>,
        "PressureStandPipeManifold": <<data.HSE[].PressureStandPipeManifold>>,
        "RegulatoryAgencyInspection": <<data.HSE[].RegulatoryAgencyInspection>>,
        "VolumeCuttingDischarged": <<data.HSE[].VolumeCuttingDischarged>>,
        "VolumeOilCuttingDischarge": <<data.HSE[].VolumeOilCuttingDischarge>>,
        "VolumeWasteDischarged": <<data.HSE[].VolumeWasteDischarged>>
      }
    ],
    "Incident": [
      {
        "Comments": <<data.Incident[].Comments>>,
        "DateTime": <<data.Incident[].DateTime>>,
        "CauseDescription": <<data.Incident[].CauseDescription>>,
        "CostLossEstimate": <<data.Incident[].CostLossEstimate>>,
        "AccidentDescription": <<data.Incident[].AccidentDescription>>,
        "LocationDescription": <<data.Incident[].LocationDescription>>,
        "EstimateHoursLost": <<data.Incident[].EstimateHoursLost>>,
        "IsNearMiss": <<data.Incident[].IsNearMiss>>,
        "TotalFatality": <<data.Incident[].TotalFatality>>,
        "TotalMajorInjury": <<data.Incident[].TotalMajorInjury>>,
        "TotalMinorInjury": <<data.Incident[].TotalMinorInjury>>,
        "RemedialActionDescription": <<data.Incident[].RemedialActionDescription>>,
        "IncidentReporterName": <<data.Incident[].IncidentReporterName>>,
        "OrganisationID": <<data.Incident[].OrganisationID>>
      }
    ],
    "MudLosses": [
      {
        "Comments": <<data.MudLosses[].Comments>>,
        "DateTime": <<data.MudLosses[].DateTime>>,
        "MudLostVolumeMeasureDepthTop": <<data.MudLosses[].MudLostVolumeMeasureDepthTop>>,
        "MudLostVolumeMeasureDepthBase": <<data.MudLosses[].MudLostVolumeMeasureDepthBase>>,
        "MudLostVolumeTvdTop": <<data.MudLosses[].MudLostVolumeTvdTop>>,
        "MudLostVolumeTvdBase": <<data.MudLosses[].MudLostVolumeTvdBase>>,
        "MudLostVolumeAbandonDownhole": <<data.MudLosses[].MudLostVolumeAbandonDownhole>>,
        "MudLostVolumeBehindCasingDownhole": <<data.MudLosses[].MudLostVolumeBehindCasingDownhole>>,
        "MudLostVolumeCirculatingDownhole": <<data.MudLosses[].MudLostVolumeCirculatingDownhole>>,
        "MudLostVolumeCementingDownhole": <<data.MudLosses[].MudLostVolumeCementingDownhole>>,
        "MudLostVolumeCasingHole": <<data.MudLosses[].MudLostVolumeCasingHole>>,
        "MudLostVolumeMudCleanerSurface": <<data.MudLosses[].MudLostVolumeMudCleanerSurface>>,
        "MudLostVolumeOtherLocationDownhole": <<data.MudLosses[].MudLostVolumeOtherLocationDownhole>>,
        "MudLostVolumeOtherLocationSurface": <<data.MudLosses[].MudLostVolumeOtherLocationSurface>>,
        "MudLostVolumePitsSurface": <<data.MudLosses[].MudLostVolumePitsSurface>>,
        "MudLostVolumeShakerSurface": <<data.MudLosses[].MudLostVolumeShakerSurface>>,
        "MudLostVolumeTrippingSurface": <<data.MudLosses[].MudLostVolumeTrippingSurface>>,
        "TotalMudLostVolumeDownhole": <<data.MudLosses[].TotalMudLostVolumeDownhole>>,
        "TotalMudLostVolumeSurface": <<data.MudLosses[].TotalMudLostVolumeSurface>>
      }
    ],
    "JobContact": [
      {
        "EmailAddress": <<data.JobContact[].EmailAddress>>,
        "PhoneNumber": <<data.JobContact[].PhoneNumber>>,
        "RoleTypeID": <<data.JobContact[].RoleTypeID>>,
        "DataGovernanceRoleTypeID": <<data.JobContact[].DataGovernanceRoleTypeID>>,
        "WorkflowPersonaTypeID": <<data.JobContact[].WorkflowPersonaTypeID>>,
        "Comment": <<data.JobContact[].Comment>>,
        "OrganisationID": <<data.JobContact[].OrganisationID>>,
        "Name": <<data.JobContact[].Name>>
      }
    ],
    "GasReading": [
      {
        "DateTime": <<data.GasReading[].DateTime>>,
        "TotalGasMax": <<data.GasReading[].TotalGasMax>>,
        "TotalGasMin": <<data.GasReading[].TotalGasMin>>,
        "TotalGasAverage": <<data.GasReading[].TotalGasAverage>>,
        "GasReadingMeasureDepthTop": <<data.GasReading[].GasReadingMeasureDepthTop>>,
        "GasReadingTvdBase": <<data.GasReading[].GasReadingTvdBase>>,
        "Methane": <<data.GasReading[].Methane>>,
        "Ethane": <<data.GasReading[].Ethane>>,
        "Propane": <<data.GasReading[].Propane>>,
        "Isobutane": <<data.GasReading[].Isobutane>>,
        "Norbutane": <<data.GasReading[].Norbutane>>,
        "Isopentane": <<data.GasReading[].Isopentane>>,
        "ReadingType": <<data.GasReading[].ReadingType>>
      }
    ],
    "ConditionHole": <<data.ConditionHole>>,
    "CostDay": <<data.CostDay>>,
    "CostDayMud": <<data.CostDayMud>>,
    "Lithology": <<data.Lithology>>,
    "TotalCost": <<data.TotalCost>>,
    "TargetCost": <<data.TargetCost>>,
    "TargetDays": <<data.TargetDays>>,
    "TotalDays": <<data.TotalDays>>,
    "TotalNPT": <<data.TotalNPT>>,
    "Name": <<data.Name>>,
    "WellActivityID": <<data.WellActivityID>>,
    "ReportNumber": <<data.ReportNumber>>,
    "ReportDescription": <<data.ReportDescription>>,
    "ReportRemarks": <<data.ReportRemarks>>,
    "ExtensionProperties": {}
  }
}
"""

DDR_document = """
Summary report

Wellbore: 15/9-19 A

Period: 1997-08-14 00:00 - 1997-08-15 00:00

Status:	normal
Report creation time:	2018-05-03 13:53
Report number:	22
Days Ahead/Behind (+/-):
Operator:	Statoil
Rig Name:	BYFORD DOLPHIN
Drilling contractor:
Spud Date:	1997-07-25 00:00
Wellbore type:
Elevation RKB-MSL (m):	25
Water depth MSL (m):	84
Tight well:	Y
HPHT:	Y
Temperature ():
Pressure ():
Date Well Complete:	1997-08-30
Dist Drilled (m):	50.5
Penetration rate (m/h):	-999.99
Hole Dia (in):	8.5
Pressure Test Type:	leak off test
Formation strength (g/cm3):	1.73
Dia Last Casing ():
Depth at Kick Off mMD:	2178
Depth at Kick Off mTVD:
Depth mMd:	3908.5
Depth mTVD:	3112.7
Plug Back Depth mMD:
Depth at formation strength mMD:	2178
Depth At Formation Strength mTVD:	1627
Depth At Last Casing mMD:	4643
Depth At Last Casing mTVD:
Summary of activities (24 Hours)

RETRIVED CORE NO 2, 100 % RECOVERY. RIH AND CUT CORE NO 3. CIRC DOWN
GAS LEVEL AND POH TO CURRENT DEPTH 1412M.

Summary of planned activities (24 Hours)

RETRIEVE CORE NO 3. RIH AND CUT CORE NO 4. CIRC OUT GAS AND POOH WITH
COREBARREL.

Operations

Start time	End time	End Depth mMD	Main - Sub Activity	State	Remark
00:00	01:30	3881	formation evaluation -- core	ok	CONTINUED CORING FROM 3858 - 3881M. TOTAL CUT 27M.
01:30	02:00	3852	formation evaluation -- trip	ok	FLOW CHECKED, OK. LAID DOWN SPACER PUP JT. PUMP SLUG.
02:00	06:00	780	formation evaluation -- trip	ok	POOH. FLOW CHECKED INSIDE CSG WINDOW, OK. CURRENT DEPTH AT REPORT TIME, 780M.
06:00	09:00	0	formation evaluation -- trip	ok	CONTINUED POOH WITH CORE NO 2. REDUCED SPEED LAST 400M. HELD SAFETY BRIEF BEFORE PULL CORE BARREL TO DRILL FLOOR. HAD 20 PPM H2S IN COREBARREL. PERSONNEL PUT ON PROTECTION EQUIPMENT BEFORE START LAYING DOWN CORE.
09:00	10:30	0	formation evaluation -- trip	ok	RETRIVED CORE NO 2, 100 % RECOVERY. MAX 5 PPM H2S WHEN RETRIVING CORE.
10:30	12:30	0	formation evaluation -- trip	ok	M/UP COREBARREL AND COREHEAD. SERVICED COREBARREL.
12:30	15:30	2160	formation evaluation -- trip	ok	RIH TO CSG WINDOW AT 2161M. BREAK CIRC EACH 1000 M.
15:30	16:00	2160	formation evaluation -- wait	ok	HELD SAFETY MEETING WITH ALL PERSONNEL WITH H2S GAS, GAS PROCEDYRES AND CONTINGENCIES.
16:00	18:30	3876	formation evaluation -- trip	ok	CONTINUED RIH TO 3876M.
18:30	20:30	3876	formation evaluation -- circulating conditioning	ok	CIRC BTM'S UP IN ORDER TO CLEAN WELL FOR GAS. MAX PEAK FROM PREVIOUS CORING; 15,2 %. CIRC GAS LEVEL DOWN TO 0,9 %.
20:30	21:00	3881	formation evaluation -- trip	ok	ROTATE AND WASH TO BTM AT 3881,5M. SPACED OUT STRING.
21:00	21:30	3881	formation evaluation -- circulating conditioning	ok	DROP BALL AND SEATED SAME IN COREBARREL WITH 17 BAR PRESS INCREASE. TAKE SCR'S.
21:30	23:00	3908	formation evaluation -- core	ok	CUT CORE NO 3 FROM 3881,5 TO 3908,5M.
23:00	23:30	3820	formation evaluation -- trip	ok	PUMP OUT OF HOLE TO 3820M. HAD 45 T OVER PULL AT CONNECTION AT 3880M. ROTATE STRING AND HAD NO EXCESSIVE TORQUE TO BREAK ROTATION, NORMAL PUMP PRESSURES INDICATING GEOMETRICAL OBSTRUCTION.
23:30	00:00	3820	formation evaluation -- circulating conditioning	ok	CIRC TO CLEAN OUT CORING GAS.
Drilling Fluid

Sample Time	22:30
Sample Point	Flowline
Sample Depth mMD	3893
Fluid Type	ULTIDRILL
Fluid Density (g/cm3)	1.55
Funnel Visc (s)	59
Mf ()
Pm ()
Pm filtrate ()
Chloride ()
Calcium ()
Magnesium ()
Ph
Excess Lime ()
Solids
Sand ()
Water ()
Oil ()
Solids ()
Corrected solids ()
High gravity solids ()
Low gravity solids ()
Viscometer tests
Plastic visc. (mPa.s)	39
Yield point (Pa)	10
Filtration tests
Pm filtrate ()
Filtrate Lthp ()
Filtrate Hthp ()
Cake thickn API ()
Cake thickn HPHT ()
Test Temp HPHT ()
Comment
Pore Pressure

Time	Depth mMD	Depth TVD	Equ Mud Weight (g/cm3)	Reading
00:00	3600		1.22	estimated
00:00	3908.5		1.09	estimated
Core Information

Core No	Depth Top mMD	Depth Bottom mMD	Core Length (m)	Recover core (%)	Core barrel length (m)	Inner barrel type	Description
2	3854	3881.5	27.7	100	28	aluminum	none
Lithology Information

Start Depth mMD	End Depth mMD	Start Depth TVD	End Depth TVD	Shows Description	Lithology Description
3854	-999.99				SANDSTONE
Gas Reading Information

Time	Class	Depth to Top mMD	Depth to Bottom MD	Depth to Top mTVD	Depth to Bottom TVD	Highest Gas (%)	Lowest Gas ()	C1 (ppm)	C2 (ppm)	C3 (ppm)	IC4 (ppm)	IC5 (ppm)
00:00	trip gas	3881.5		3089.3		2.45		22386	2259	464	36	6
00:00	drilling gas peak	3894				12.75		87345	5653	2923	155	68
"""

### Function to extract the attributes using the text format
def getCompletion_DDR(attribute, JSON_file, DDR_document):

    template_string = """
    Extract the following attribute whose meanings are mentioned as follows\
    {attribute} \
    from the text that is delimited by triple backticks \
    output the values of the attribute extracted in the following JSON file format\
    {output_format} \
    if the value of the attribute is missing or cannot be extracted output the null string \
    text: ```{text}```
    """
    prompt = PromptTemplate(template=template_string, input_variables=["attribute, output_format, text"])
    llm = ChatGoogleGenerativeAI(model="gemini-pro")
    llm.temperature=0
    #llm.max_output_tokens = 100000
    llm_chain = LLMChain(prompt=prompt, llm=llm)
    return llm_chain.run(attribute = attribute, output_format = JSON_file, text = DDR_document)

def edit_string(string):

    string = string.replace('`', '')
    string = string.replace('json', '')

    return string

# function to oputput the required DDR in JSON format with the text input
def readPDF_DDR_JSON_document(ddr_path):

    loader = PyPDFLoader(ddr_path)
    pages = loader.load_and_split()
    ddr_document = str(pages[0].page_content)

    attribute_list = [attributes_1, attributes_2, attributes_3, attributes_4, attributes_5]
    JSON_files_list = [JSON_file1, JSON_file2, JSON_file3, JSON_file4, JSON_file5]

    results_list = []
    for i in tqdm.tqdm(range((len(attribute_list)))):
        result = getCompletion_DDR(ddr_document, attribute_list[i], JSON_files_list[i])
        results_list.append(result)

    for i in range(len(results_list)):
        results_list[i] = edit_string(results_list[i])

    results_string = results_list[0] + result_1Point5 + results_list[1] + results_list[2] + results_list[3] + results_list[4]

    return results_string

import tqdm

gr.close_all()
demo = gr.Interface(fn=readPDF_DDR_JSON_document,
                    inputs=[gr.File(label="Kindly upload the Daily drilling report in PDF format", file_count="single", file_types=["text", ".pdf"])],
                    outputs=[gr.Textbox(label="DDR in the JSON format", lines=6)],
                    title="Converting the DDR in the JSON Format using Generative AI",
                    description="File type conversion from pdf to OSDU Complaint JSON Format"
                   )
demo.launch(share=True, debug = True, auth=("HCLTech", "Password2024"))