Data Schema
...
Well
Wellbore
Wellbore Casing
a well casing is a lining that is installed into the wellbore once it is drilled it surrounds the well entirely casing is typically hollow steel pipe that lines the inside of the wellbore the well casing is constructed in multiple sections the interior of the casing is composed of steel and is smaller than the diameter of the well the exterior of the casing is made of concrete poured into the gap between the well and steel casing once it has been inserted the thickness of the casing varies depending on depth, with the casing being thicker near the top of the well variable data type unit of measure is nullable? default value description sourceid string no from wellview table wvcas use idrec column from openwells table cd assembly use assembly id column sourcewellid string no from wellview table wvcas use idwell column from openwells table cd assembly use well id column sourcewellboreid string no from wellview table wvcas use idrecwellbore column from openwells table cd assembly use wellbore id column topmd double ft no 0 0 top measured depth of casing bottommd double ft no bottom measured depth of casing id double in no inner diameter of casing from wellview table wvcas use szidnommincalc column od double in no outer diameter of casing from wellview table wvcas use szodnommincalc column roughness double in yes 0 0006 absolute roughness coefficient of casing material rundate datetime offset yes datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 wellbore casing notes every well requires casing data wells with no casing data will fail a data integrity check if a well fails the data integrity check the system will not compute values for that well top measured depth notes if the topmd is null, the system will assume 0ft as the default topmd value roughness notes if the roughness is null, the system will assume 0 0003 as the default roughness value data integrity checks condition response sourceid, sourcewellid, or sourcewellboreid is null or empty record rejected uwisourceid, sourcewellid, or sourcewellboreid does not exist record rejected