{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "i07_WellCompletionReports", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 100000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "

This feature class represents an index of records from the California Department of Water Resources' (DWR) Online System for Well Completion Reports (OSWCR). This feature class is for informational purposes only. All attribute values should be verified by reviewing the original Well Completion Report. Known issues include: - Missing and duplicate records - Missing values (either missing on original Well Completion Report, or not key entered into database) - Incorrect values (e.g. incorrect Latitude, Longitude, Record Type, Planned Use, Total Completed Depth) - Limited spatial resolution: The majority of well completion reports have been spatially registered to the center of the 1x1 mile Public Land Survey System section that the well is located in.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "copyrightText": "California Department of Water Resources", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "atlas_wmas.SDE.i07_WellReportPDFLinks", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "WCRNumber", "composite": false }, { "id": 1, "name": "atlas_wmas.SDE.i07_WellReportStatsBySection", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "MTRS", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "extent": { "xmin": -1.3873748137600001E7, "ymin": 3832432.4899000004, "xmax": 1.3418989093400002E7, "ymax": 5161619.090800002, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "MethodofDeterminationLL", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 222, 61, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 153, 153, 153, 255 ], "width": 0.75 } }, "defaultLabel": "Recorded Location", "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 237, 81, 81, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 153, 153, 153, 255 ], "width": 0.75 } }, "value": "Derived from TRS", "label": "Location from PLSS Section" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 115, 0, 77, 255 ], "toColor": [ 115, 0, 77, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 255, 0, 0, 255 ], "toColor": [ 255, 0, 0, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 255, 170, 0, 255 ], "toColor": [ 255, 170, 0, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 230, 230, 0, 255 ], "toColor": [ 230, 230, 0, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 76, 230, 0, 255 ], "toColor": [ 76, 230, 0, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 56, 168, 0, 255 ], "toColor": [ 56, 168, 0, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "WCRNumber", "typeIdField": "MethodofDeterminationLL", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "WCRNumber", "type": "esriFieldTypeString", "alias": "WCR Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "WCRNumber" }, { "name": "LegacyLogNumber", "type": "esriFieldTypeString", "alias": "Legacy Log Number", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LegacyLogNumber" }, { "name": "RegionOffice", "type": "esriFieldTypeString", "alias": "Region Office", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "RegionOffice" }, { "name": "CountyName", "type": "esriFieldTypeString", "alias": "County Name", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "CountyName" }, { "name": "LocalPermitAgency", "type": "esriFieldTypeString", "alias": "Local Permit Agency", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LocalPermitAgency" }, { "name": "PermitDate", "type": "esriFieldTypeDate", "alias": "Permit Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PermitDate" }, { "name": "PermitNumber", "type": "esriFieldTypeString", "alias": "Permit Number", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PermitNumber" }, { "name": "OwnerAssignedWellNumber", "type": "esriFieldTypeString", "alias": "Owner Assigned Well Number", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "OwnerAssignedWellNumber" }, { "name": "WellLocation", "type": "esriFieldTypeString", "alias": "Well Location", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WellLocation" }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "City" }, { "name": "PlannedUseFormerUse", "type": "esriFieldTypeString", "alias": "Planned Use/Former Use", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "PlannedUseFormerUse" }, { "name": "DrillerName", "type": "esriFieldTypeString", "alias": "Driller Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DrillerName" }, { "name": "DrillerLicenseNumber", "type": "esriFieldTypeString", "alias": "Driller License Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "DrillerLicenseNumber" }, { "name": "RecordType", "type": "esriFieldTypeString", "alias": "Record Type", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "RecordType" }, { "name": "DecimalLatitude", "type": "esriFieldTypeDouble", "alias": "Decimal Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DecimalLatitude" }, { "name": "DecimalLongitude", "type": "esriFieldTypeDouble", "alias": "Decimal Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DecimalLongitude" }, { "name": "MethodofDeterminationLL", "type": "esriFieldTypeString", "alias": "Method of Determination LL", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "MethodofDeterminationLL" }, { "name": "LLAccuracy", "type": "esriFieldTypeString", "alias": "LL Accuracy", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "LLAccuracy" }, { "name": "HorizontalDatum", "type": "esriFieldTypeString", "alias": "Horizontal Datum", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HorizontalDatum" }, { "name": "GroundSurfaceElevation", "type": "esriFieldTypeString", "alias": "Ground Surface Elevation", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "GroundSurfaceElevation" }, { "name": "ElevationAccuracy", "type": "esriFieldTypeString", "alias": "Elevation Accuracy", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "ElevationAccuracy" }, { "name": "ElevationDeterminationMethod", "type": "esriFieldTypeString", "alias": "Elevation Determination Method", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "ElevationDeterminationMethod" }, { "name": "VerticalDatum", "type": "esriFieldTypeString", "alias": "Vertical Datum", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "VerticalDatum" }, { "name": "Township", "type": "esriFieldTypeString", "alias": "Township", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Township" }, { "name": "Range", "type": "esriFieldTypeString", "alias": "Range", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Range" }, { "name": "Section", "type": "esriFieldTypeString", "alias": "Section", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Section" }, { "name": "BaselineMeridian", "type": "esriFieldTypeString", "alias": "Baseline Meridian", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "BaselineMeridian" }, { "name": "APN", "type": "esriFieldTypeString", "alias": "APN", "domain": null, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "APN" }, { "name": "DateWorkEnded", "type": "esriFieldTypeDate", "alias": "Date Work Ended", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateWorkEnded" }, { "name": "WorkflowStatus", "type": "esriFieldTypeString", "alias": "Workflow Status", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "WorkflowStatus" }, { "name": "TotalDrillDepth", "type": "esriFieldTypeString", "alias": "Total Drill Depth", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TotalDrillDepth" }, { "name": "TotalCompletedDepth", "type": "esriFieldTypeDouble", "alias": "Total Completed Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalCompletedDepth" }, { "name": "TopOfPerforatedInterval", "type": "esriFieldTypeString", "alias": "Top Of Perforated Interval", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TopOfPerforatedInterval" }, { "name": "BottomofPerforatedInterval", "type": "esriFieldTypeString", "alias": "Bottom of Perforated Interval", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BottomofPerforatedInterval" }, { "name": "CasingDiameter", "type": "esriFieldTypeString", "alias": "Casing Diameter", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CasingDiameter" }, { "name": "DrillingMethod", "type": "esriFieldTypeString", "alias": "Drilling Method", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "DrillingMethod" }, { "name": "Fluid", "type": "esriFieldTypeString", "alias": "Fluid", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Fluid" }, { "name": "StaticWaterLevel", "type": "esriFieldTypeString", "alias": "Static Water Level", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StaticWaterLevel" }, { "name": "TotalDrawDown", "type": "esriFieldTypeString", "alias": "Total Draw Down", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TotalDrawDown" }, { "name": "TestType", "type": "esriFieldTypeString", "alias": "Test Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TestType" }, { "name": "PumpTestLength", "type": "esriFieldTypeString", "alias": "Pump Test Length", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PumpTestLength" }, { "name": "WellYield", "type": "esriFieldTypeString", "alias": "Well Yield", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WellYield" }, { "name": "WellYieldUnitofMeasure", "type": "esriFieldTypeString", "alias": "Well Yield Unit of Measure", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WellYieldUnitofMeasure" }, { "name": "OtherObservations", "type": "esriFieldTypeString", "alias": "Other Observations", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "OtherObservations" }, { "name": "MTRS", "type": "esriFieldTypeString", "alias": "PLSS MTRS", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "MTRS" }, { "name": "Draw", "type": "esriFieldTypeSmallInteger", "alias": "Record drawn on map", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Draw" }, { "name": "WCRLinks", "type": "esriFieldTypeString", "alias": "WCR Links", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WCRLinks" }, { "name": "ReceivedDate", "type": "esriFieldTypeDate", "alias": "ReceivedDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ReceivedDate" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "B118WellUse", "type": "esriFieldTypeString", "alias": "B118WellUse", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "B118WellUse" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R2192_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2192", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1745_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [ { "id": "Derived from TRS", "name": "Location from PLSS Section", "domains": {}, "templates": [ { "name": "Location from PLSS Section", "description": "", "prototype": { "attributes": { "DecimalLongitude": null, "B118WellUse": null, "WCRNumber": null, "LegacyLogNumber": null, "RegionOffice": null, "CountyName": null, "LocalPermitAgency": null, "PermitDate": null, "PermitNumber": null, "OwnerAssignedWellNumber": null, "WellLocation": null, "City": null, "PlannedUseFormerUse": null, "DrillerName": null, "DrillerLicenseNumber": null, "RecordType": null, "DecimalLatitude": null, "MethodofDeterminationLL": "Derived from TRS", "LLAccuracy": null, "HorizontalDatum": null, "GroundSurfaceElevation": null, "ElevationAccuracy": null, "ElevationDeterminationMethod": null, "VerticalDatum": null, "Township": null, "Range": null, "Section": null, "BaselineMeridian": null, "APN": null, "DateWorkEnded": null, "WorkflowStatus": null, "TotalDrillDepth": null, "TotalCompletedDepth": null, "TopOfPerforatedInterval": null, "BottomofPerforatedInterval": null, "CasingDiameter": null, "DrillingMethod": null, "Fluid": null, "StaticWaterLevel": null, "TotalDrawDown": null, "TestType": null, "PumpTestLength": null, "WellYield": null, "WellYieldUnitofMeasure": null, "OtherObservations": null, "MTRS": null, "Draw": null, "WCRLinks": null, "ReceivedDate": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] } ], "templates": [], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }