{"title":"Wellficent well registry row","version":"2.1","snapshot":{"snapshotSha256":"7d6e677299352a7b989393edc6a851c0822df0e5f2355d2bd0f6d0b3c86192df","schemaVersion":4,"classificationVersion":"wellficent-source-purpose-v2","classificationSha256":"83e4157601b4d73cb883d6e8578f9fe1ea467bb929d96a74071d77068ee8ca48","shardCount":4},"formats":{"paginatedJson":"https://wellficent.com/api/v1/wells","ndjson":"https://wellficent.com/api/v1/wells.ndjson","csv":"https://wellficent.com/api/v1/wells.csv","geojson":"https://wellficent.com/api/v1/wells.geojson"},"catalogues":"https://wellficent.com/api/v1/wells/catalogues","classification":{"version":"wellficent-source-purpose-v2","kind":"derived-from-source-purpose","unmapped":"unclassified","meaning":"Conservative grouping of explicit source purpose, operation and well-type codes; never verified present-day operation, outcome or prediction.","rules":{"netherlands-nlog":{"Development hydrocarbon":"development","Exploration hydrocarbon":"exploration","Appraisal hydrocarbon":"appraisal","Development hydrocarbon for injection":"injection","Development geothermic energy production":"development","Geothermic energy exploration":"exploration"},"new-zealand-nzpam":{"exploration":"exploration","development":"development","appraisal":"appraisal","production":"production"},"norway-sodir":{"PRODUCTION":"production","INJECTION":"injection","APPRAISAL":"appraisal","WILDCAT":"exploration","OBSERVATION":"observation","APPRAISAL-CCS":"carbon-storage","WILDCAT-CCS":"carbon-storage","INJECTION-CCS":"carbon-storage"},"uk-nsta-offshore":{"Development":"development","Exploration":"exploration","Appraisal":"appraisal","Carbon capture & storage":"carbon-storage"},"uk-nsta-onshore":{"Development":"development","Exploration":"exploration","Appraisal":"appraisal"},"canada-bcer":{"PROD":"production","INJ":"injection","OBS":"observation","DISP":"disposal","STOR":"storage"},"california-calgem-geothermal":{"DST":"development","DWT":"development","EST":"exploration","EWT":"exploration","ELT":"exploration","INJ":"injection","OBS":"observation","TG":"temperature-gradient"}},"evidence":{"canada-bcer":{"sourceField":"OPERATION_TYPE","name":"BC Energy Regulator — Metadata for Well Codes","url":"https://www.bc-er.ca/files/gis/WELLCODE_METADATA.pdf","checkedAt":"2026-10-03","notes":"OPS_TYPE definitions used for the source export OPERATION_TYPE codes. SRC means Source, but the dictionary does not establish water use; SRC and UND remain unclassified. Operation type is separate from MODE_CODE status."},"california-calgem-geothermal":{"sourceField":"WellType","name":"CalGEM — Geothermal Production and Injection Data Guide","url":"https://www.conservation.ca.gov/calgem/geothermal/geosteam/Pages/geothermal_opi_help.aspx","checkedAt":"2026-10-03","notes":"Get Wells Screen Well Type definitions, not the separate monthly report type/status codes. TG remains a distinct temperature-gradient class; CLT/NLT describe temperature/commercial class without proving production. WW and CON are not defined in this reviewed list and remain unclassified."}}},"jsonSchema":"https://wellficent.com/api/v1/wells/json-schema","quality":"https://wellficent.com/api/v1/wells/quality","analyticalLayersSchema":"https://wellficent.com/api/v1/wells/ml-schema","contractVersion":"1.0.0","schemaScope":"Formal JSON Schema validates flat NDJSON machine rows; nested paginated/detail records use the documented source envelope.","fields":{"snapshotSha256":{"type":"string","meaning":"SHA-256 digest of all normalized source snapshots for this dataset edition."},"sourceSha256":{"type":["string","null"],"meaning":"SHA-256 digest of the original source response when captured; null if unavailable."},"id":{"type":"string","meaning":"Stable source-scoped borehole record ID; use for joins, not cross-source physical deduplication."},"wellId":{"type":"string","meaning":"Source well or well-origin identifier; sidetracks may share it."},"sourceRecordId":{"type":"string","meaning":"Original record identifier as text; leading zeroes are preserved."},"name":{"type":"string","meaning":"Reported borehole name used for display."},"wellName":{"type":["string","null"],"meaning":"Reported well or well-family name."},"catalogue":{"type":"string","meaning":"Source snapshot ID and licence boundary."},"sector":{"type":"string","enum":["oil-gas","geothermal","water"],"meaning":"Source collection group, not a verified commodity or current production label."},"purposeGroup":{"type":"string","enum":["exploration","appraisal","development","production","injection","observation","carbon-storage","disposal","storage","temperature-gradient","unclassified"],"meaning":"Wellficent deterministic category from explicit source purpose or operation/type code where mapped; unclassified otherwise. Not a present-day operational status."},"classificationBasis":{"type":"string","meaning":"Version of the deterministic mapping; inspect original sourcePurpose."},"classificationSha256":{"type":"string","meaning":"SHA-256 of the exact reviewed source-purpose/type rule table for this row edition."},"qualityFlags":{"type":"array","items":{"enum":["completion-before-spud","measured-depth-reference-unreported"]},"uniqueItems":true,"meaning":"Derived source consistency flags; original dates and measurements are retained. An empty list means these two checks found no issue, not complete validation."},"qualityRuleVersion":{"type":"string","const":"wellficent-row-quality-v1","meaning":"Version of the explicit source-date and depth-reference consistency checks."},"sourcePurpose":{"type":["string","null"],"meaning":"Verbatim source purpose, operation or well-type code when supplied; meanings differ by source."},"sourceStatus":{"type":["string","null"],"meaning":"Verbatim source status in a historical snapshot; meaning varies by catalogue."},"operator":{"type":["string","null"],"meaning":"Source-reported primary operator or responsible company; inspect operatorRole and companies."},"operatorRole":{"type":["string","null"],"meaning":"Role assigned by the source to the primary company, not an assertion of current ownership."},"companies":{"type":"array","meaning":"All source-reported company roles with original source IDs and available official links."},"basin":{"type":["string","null"]},"area":{"type":["string","null"]},"depth":{"type":["string","null"],"meaning":"Display text; use measurements for numeric values, units and reference levels."},"spudDate":{"type":["string","null"],"format":"date","meaning":"Reported spud date; null means unavailable, not never drilled."},"completionDate":{"type":["string","null"],"format":"date"},"sourceUpdatedAt":{"type":["string","null"],"meaning":"Source record update date when reported, not the retrieval date."},"statusEffectiveDate":{"type":["string","null"],"meaning":"Source status reference date when reported."},"authorizationDate":{"type":["string","null"],"meaning":"Source authorization date; authorization is not proof of drilling."},"operatorCode":{"type":["string","null"],"meaning":"Original company code when supplied; preserve leading zeroes."},"measuredDepthM":{"type":["number","null"],"unit":"m","meaning":"First reported measured-depth measurement in metres; datum/reference remains in measurements."},"measurements":{"type":"array","meaning":"Each value retains sourceField, kind, unit and reference. Never mix unlike depths or datums."},"latitude":{"type":"number","minimum":-90,"maximum":90,"crs":"EPSG:4326"},"longitude":{"type":"number","minimum":-180,"maximum":180,"crs":"EPSG:4326"},"coordinateCrs":{"type":"string","const":"EPSG:4326","meaning":"Coordinate reference system for latitude/longitude; original source CRS is catalogue metadata."},"coordinateMethod":{"type":"string","meaning":"Documented source or local transformation used to produce WGS84 coordinates."},"positionAccuracy":{"type":["string","null"],"meaning":"Source-stated position accuracy, when known; decimal places do not establish accuracy."},"sourceAsOf":{"type":["string","null"],"meaning":"Source edition/observation as stated, not an inferred live date."},"sourceCheckedAt":{"type":"string","format":"date","meaning":"Day Wellficent accessed the source."},"sourceUrl":{"type":"string","format":"uri","meaning":"Official source record or dataset URL."},"sourceAttribution":{"type":["string","null"],"meaning":"Exact source-required acknowledgement when stated; null does not grant reuse rights."},"sourceTermsUrl":{"type":["string","null"],"meaning":"Reviewed source terms when item-level terms are supplied."},"sourceRightsReviewUrl":{"type":["string","null"],"meaning":"Source item used to review rights when explicit item-level terms are unavailable."},"commercialUseAllowed":{"type":["boolean","null"],"meaning":"Null means not established; false means the reviewed source terms restrict commercial use."},"reuseLicense":{"type":"string","meaning":"Catalogue-specific source rights label; inspect terms and attribution before redistribution."},"spudYear":{"type":["integer","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"facility":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"totalDepthReachedDate":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"completionStatus":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"wellboreStatus":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"originStatus":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"targetField":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"prospect":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"flowClass":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"fluidTypes":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"parentWell":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"parentRole":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"sidetrackType":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"licenceNumber":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."},"totalDepthLicenceNumber":{"type":["string","null"],"meaning":"Source-specific reported field; meanings and coverage vary by catalogue. Null means not supplied."}},"csvFieldAliases":{"status":"sourceStatus","checkedAt":"sourceCheckedAt","companiesJson":"companies","measurementsJson":"measurements","qualityFlagsJson":"qualityFlags"},"csvEncoding":"UTF-8 with BOM; arrays are JSON; commercialUseAllowed is true, false or unknown; missing scalar values are empty. Formula-like text is escaped for spreadsheets.","missingValues":"Null is unknown or not supplied, never zero. No synthetic values or predictions are included.","evaluation":"Split by catalogue and source-scoped wellId; use time-aware splits only where dated labels and feature availability support them. Report missingness and source leakage."}