{ "currentVersion": 10.81, "id": 5, "name": "SCUDGIS.DBO.LeakMonitor", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Leak", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelatedGuid", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "MonitorDate", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "LeakType", "type": "esriFieldTypeString", "alias": "Leak Type", "domain": { "type": "codedValue", "name": "LEAK TYPE", "description": "", "codedValues": [ { "name": "Above Ground", "code": "Above" }, { "name": "Below Ground", "code": "Below" }, { "name": "Broke Line", "code": "Broke" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LeakType" }, { "name": "ReportSource", "type": "esriFieldTypeString", "alias": "Report Source", "domain": { "type": "codedValue", "name": "LEAK SOURCE OF REPORT", "description": "LEAK SOURCE OF REPORT", "codedValues": [ { "name": "Leak Survey", "code": "Leak Survey" }, { "name": "Mobile FI", "code": "Mobile FI" }, { "name": "Public", "code": "Public" }, { "name": "Company Employee", "code": "Company Employee" }, { "name": "Fire Department", "code": "Fire Department" }, { "name": "E911 Dispatch", "code": "E911 Dispatch" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ReportSource" }, { "name": "LeakID", "type": "esriFieldTypeString", "alias": "Leak ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LeakID" }, { "name": "StreetAddress", "type": "esriFieldTypeString", "alias": "Street Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StreetAddress" }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "domain": { "type": "codedValue", "name": "GIS Area", "description": "Geographic Service Areas", "codedValues": [ { "name": "Sevierville", "code": "01" }, { "name": "Pigeon Forge", "code": "02" }, { "name": "Gatlinburg", "code": "03" }, { "name": "Seymour", "code": "04" }, { "name": "Kodak", "code": "05" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "City" }, { "name": "GasFound", "type": "esriFieldTypeString", "alias": "Gas Found?", "domain": { "type": "codedValue", "name": "Yes/No Only", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GasFound" }, { "name": "ArrivedDate", "type": "esriFieldTypeDate", "alias": "Arrived Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ArrivedDate" }, { "name": "Technician", "type": "esriFieldTypeString", "alias": "Technician", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Technician" }, { "name": "InvestigationFoundLeak", "type": "esriFieldTypeString", "alias": "Investigation Found Leak", "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "InvestigationFoundLeak" }, { "name": "IfLeakFoundGrade", "type": "esriFieldTypeString", "alias": "Grade", "domain": { "type": "codedValue", "name": "Leak Class_4", "description": "", "codedValues": [ { "name": "Class 1", "code": "1" }, { "name": "Class 2", "code": "2" }, { "name": "Class 3", "code": "3" }, { "name": "No Leak", "code": "NG" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfLeakFoundGrade" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": { "type": "codedValue", "name": "LEAK LOCATION", "description": "LEAK LOCATION", "codedValues": [ { "name": "In Building", "code": "In Building" }, { "name": "Near Building", "code": "Near Building" }, { "name": "In Manhole", "code": "In Manhole" }, { "name": "In Soil", "code": "In Soil" }, { "name": "Under Paving", "code": "Under Paving" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Location" }, { "name": "GasOdorDetected", "type": "esriFieldTypeString", "alias": "Gas Odor Detected", "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GasOdorDetected" }, { "name": "Soap", "type": "esriFieldTypeString", "alias": "Soap Test Performed", "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Soap" }, { "name": "GasPercent", "type": "esriFieldTypeDouble", "alias": "Gas Percent", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GasPercent" }, { "name": "LELPercent", "type": "esriFieldTypeDouble", "alias": "LEL Percent", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LELPercent" }, { "name": "PPMPercent", "type": "esriFieldTypeDouble", "alias": "PPM Percent", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PPMPercent" }, { "name": "PressureSystem", "type": "esriFieldTypeString", "alias": "PressureSystem", "domain": { "type": "codedValue", "name": "LEAK PRESSURE SYSTEM", "description": "LEAK PRESSURE SYSTEM", "codedValues": [ { "name": "LOW: 0-59", "code": "LOW" }, { "name": "MEDIUM: 60-100", "code": "MED" }, { "name": "HIGH: ABOVE 101", "code": "HIGH" }, { "name": "UNKNOWN", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PressureSystem" }, { "name": "AreaLocation", "type": "esriFieldTypeString", "alias": "Area Location", "domain": { "type": "codedValue", "name": "LEAK AREA LOCATION", "description": "Leak area location", "codedValues": [ { "name": "School", "code": "School" }, { "name": "Hospital", "code": "Hospital" }, { "name": "Commercial", "code": "Commercial" }, { "name": "Residential", "code": "Residential" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AreaLocation" }, { "name": "ProbableSource", "type": "esriFieldTypeString", "alias": "Probable Source", "domain": { "type": "codedValue", "name": "LEAK SOURCE", "description": "LEAK SOURCE", "codedValues": [ { "name": "Main", "code": "MAIN" }, { "name": "Service", "code": "SERV" }, { "name": "Service Tap", "code": "SERVTAP" }, { "name": "Valve", "code": "VALVE" }, { "name": "Meter", "code": "METER" }, { "name": "Regulator", "code": "REG" }, { "name": "Fitting", "code": "FITTING" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProbableSource" }, { "name": "IfMeterLocationonMeter", "type": "esriFieldTypeString", "alias": "Location on Meter", "domain": { "type": "codedValue", "name": "LEAK METER LOCATION", "description": "Leak Meter Location", "codedValues": [ { "name": "Above Grade", "code": "Above" }, { "name": "Below Grade", "code": "Below" }, { "name": "Grease Plug On Meter Stop", "code": "Grease Plug" }, { "name": "Header Regulator Venting", "code": "Header Regulator Venting" }, { "name": "Meter Housing", "code": "Housing" }, { "name": "Index Drive", "code": "Index Drive" }, { "name": "Inlet Swivel", "code": "Inlet Swivel" }, { "name": "Instrument Tubing", "code": "Instrument Tubing" }, { "name": "Meter", "code": "Meter" }, { "name": "Multiple Leaks On Meter Set", "code": "Multiple Leaks" }, { "name": "Nipple Above Meter Stop", "code": "Nipple Above Meter" }, { "name": "Nipple Above Regulator", "code": "Nipple Above Regulator" }, { "name": "Nipple Under Meter Stop", "code": "Nipple Under Meter" }, { "name": "Nipple Under Regulator", "code": "Nipple Under Regulator" }, { "name": "Outlet Swivel", "code": "Outlet Swivel" }, { "name": "Pilot Gasket", "code": "Pilot Gasket" }, { "name": "Regulator", "code": "Regulator" }, { "name": "Regulator Gasket", "code": "Regulator Gasket" }, { "name": "Regulator Venting", "code": "Regulator Venting" }, { "name": "Service Cock", "code": "Service Cock" }, { "name": "Strainer", "code": "Strainer" }, { "name": "Union", "code": "Union" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfMeterLocationonMeter" }, { "name": "IfMeterBodyManufacturer", "type": "esriFieldTypeString", "alias": "Meter Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfMeterBodyManufacturer" }, { "name": "IfMeterSize", "type": "esriFieldTypeString", "alias": "Meter Size", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfMeterSize" }, { "name": "IfMainorServiceMaterial", "type": "esriFieldTypeString", "alias": "Material", "domain": { "type": "codedValue", "name": "LEAK PIPE MATERIAL", "description": "LEAK PIPE MATERIAL", "codedValues": [ { "name": "PLASTIC", "code": "PLASTIC" }, { "name": "BARE STEEL", "code": "BARE STEEL" }, { "name": "COATED STEEL", "code": "COATED STEEL" }, { "name": "DUCTILE IRON", "code": "DUCTILE IRON" }, { "name": "PLASTIC INSERTED", "code": "PLASTIC INSERTED" }, { "name": "OTHER", "code": "OTH" }, { "name": "UNKNOWN", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfMainorServiceMaterial" }, { "name": "IfMainorServiceSize", "type": "esriFieldTypeString", "alias": "Size", "domain": { "type": "codedValue", "name": "LEAK PIPE DIAMETER", "description": "LEAK PIPE DIAMETER", "codedValues": [ { "name": "1/4\"", "code": ".25" }, { "name": "1/2\"", "code": ".5" }, { "name": "3/4\"", "code": ".75" }, { "name": "1\"", "code": "1" }, { "name": "1 1/2\"", "code": "1.5" }, { "name": "2\"", "code": "2" }, { "name": "2 1/2\"", "code": "2.5" }, { "name": "3\"", "code": "3" }, { "name": "4\"", "code": "4" }, { "name": "6\"", "code": "6" }, { "name": "8\"", "code": "8" }, { "name": "10\"", "code": "10" }, { "name": "12\"", "code": "12" }, { "name": "UNKNOWN", "code": "0" }, { "name": "1 1/4\"", "code": "1.25" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfMainorServiceSize" }, { "name": "ProbableCause", "type": "esriFieldTypeString", "alias": "Probable Cause", "domain": { "type": "codedValue", "name": "LEAK CAUSE", "description": "Leak Cause", "codedValues": [ { "name": "Corrosion", "code": "Corrosion" }, { "name": "Natural Forces", "code": "Natural Forces" }, { "name": "Excavation", "code": "Excavation" }, { "name": "Other Outside Forces Damage", "code": "Other Outside Forces Damage" }, { "name": "Material or Welds", "code": "Material or Welds" }, { "name": "Equipment", "code": "Equipment" }, { "name": "Operations", "code": "Operations" }, { "name": "Construction Defect", "code": "Construction Defect" }, { "name": "Mechanical Fittings (Nut Follower, Bolted, Stab, & Compression)", "code": "Mechanical Fittings" }, { "name": "Other", "code": "Other" }, { "name": "Pipe, Weld, or Joint Failure", "code": "Pipe Weld Joint Failure" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProbableCause" }, { "name": "IfExcavationDamageLocateCalled", "type": "esriFieldTypeString", "alias": "Located Called In", "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfExcavationDamageLocateCalled" }, { "name": "IfExcavationDamageLocateNumber", "type": "esriFieldTypeString", "alias": "Locate Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfExcavationDamageLocateNumber" }, { "name": "IfExcavationDamageExcavatorName", "type": "esriFieldTypeString", "alias": "Exavator Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfExcavationDamageExavatorName" }, { "name": "IfExcavationDamageExcavatorAddr", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfExcavationDamageExcavatorAddr" }, { "name": "IfExcavationDamageExcavatorCity", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfExcavationDamageExcavatorCity" }, { "name": "IfExcavationDamageExcavatorNumb", "type": "esriFieldTypeString", "alias": "Phone Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IfExcavationDamageExcavatorNumber" }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Remarks" }, { "name": "MadeSafeDate", "type": "esriFieldTypeDate", "alias": "Made Safe Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MadeSafeDate" }, { "name": "LeakGUID", "type": "esriFieldTypeGUID", "alias": "LeakGUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "LeakGUID" }, { "name": "LeakMaintenanceType", "type": "esriFieldTypeString", "alias": "Leak Maintenance Type", "domain": { "type": "codedValue", "name": "LEAK MAINTENANCE TYPE", "description": "", "codedValues": [ { "name": "Monitor", "code": "Monitor" }, { "name": "Repair", "code": "Repair" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LeakMaintenanceType" }, { "name": "FoundGrade", "type": "esriFieldTypeString", "alias": "Grade as Found", "domain": { "type": "codedValue", "name": "Leak Class_4", "description": "", "codedValues": [ { "name": "Class 1", "code": "1" }, { "name": "Class 2", "code": "2" }, { "name": "Class 3", "code": "3" }, { "name": "No Leak", "code": "NG" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FoundGrade" }, { "name": "FoundSource", "type": "esriFieldTypeString", "alias": "Source as Determined During Repair", "domain": { "type": "codedValue", "name": "LEAK SOURCE", "description": "LEAK SOURCE", "codedValues": [ { "name": "Main", "code": "MAIN" }, { "name": "Service", "code": "SERV" }, { "name": "Service Tap", "code": "SERVTAP" }, { "name": "Valve", "code": "VALVE" }, { "name": "Meter", "code": "METER" }, { "name": "Regulator", "code": "REG" }, { "name": "Fitting", "code": "FITTING" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FoundSource" }, { "name": "FoundCause", "type": "esriFieldTypeString", "alias": "Leak Cause as Determined During Repair", "domain": { "type": "codedValue", "name": "LEAK CAUSE", "description": "Leak Cause", "codedValues": [ { "name": "Corrosion", "code": "Corrosion" }, { "name": "Natural Forces", "code": "Natural Forces" }, { "name": "Excavation", "code": "Excavation" }, { "name": "Other Outside Forces Damage", "code": "Other Outside Forces Damage" }, { "name": "Material or Welds", "code": "Material or Welds" }, { "name": "Equipment", "code": "Equipment" }, { "name": "Operations", "code": "Operations" }, { "name": "Construction Defect", "code": "Construction Defect" }, { "name": "Mechanical Fittings (Nut Follower, Bolted, Stab, & Compression)", "code": "Mechanical Fittings" }, { "name": "Other", "code": "Other" }, { "name": "Pipe, Weld, or Joint Failure", "code": "Pipe Weld Joint Failure" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FoundCause" }, { "name": "ExcavationType", "type": "esriFieldTypeString", "alias": "Cause of Excavation Damage", "domain": { "type": "codedValue", "name": "LEAK CAUSE EXCAVATION TYPE", "description": "", "codedValues": [ { "name": "No Locates Requested", "code": "No Locates Requested" }, { "name": "Mis-Marked Facilities", "code": "Mis-Marked Facilities" }, { "name": "Facilities Not Marked", "code": "Facilities Not Marked" }, { "name": "Improper Excavation Practice", "code": "Improper Excavation Practice" }, { "name": "Incorrect Facility Records", "code": "Incorrect Facility Records" }, { "name": "811 Error", "code": "811 Error" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ExcavationType" }, { "name": "EquipmentFailureType", "type": "esriFieldTypeString", "alias": "Equipment Failure Type", "domain": { "type": "codedValue", "name": "LEAK CAUSE EQUIP FAILURE", "description": "", "codedValues": [ { "name": "Valve", "code": "Valve" }, { "name": "Service", "code": "Service" }, { "name": "Meter Regulator", "code": "Meter Regulator" }, { "name": "Gate Station", "code": "Gate Station" }, { "name": "Regulator Station", "code": "Regulator Station" }, { "name": "Mechanical Coupling", "code": "Mechanical Coupling" }, { "name": "Transition Fitting", "code": "Transition Fitting" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "EquipmentFailureType" }, { "name": "EquipementFailureCouplingType", "type": "esriFieldTypeString", "alias": "Mechanical Coupling Failure Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EquipementFailureCouplingType" }, { "name": "MWJType", "type": "esriFieldTypeString", "alias": "Material, Weld, or Joint Failure Type", "domain": { "type": "codedValue", "name": "LEAK CAUSE MWJ", "description": "", "codedValues": [ { "name": "Welds", "code": "Welds" }, { "name": "Split Seams", "code": "Split Seams" }, { "name": "Incomplete Fusion", "code": "Incomplete Fusion" }, { "name": "Service Tap", "code": "Service Tap" }, { "name": "Other Pipe Component", "code": "Other Pipe Component" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MWJType" }, { "name": "MWJPipeComponent", "type": "esriFieldTypeString", "alias": "What pipe component?", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MWJPipeComponent" }, { "name": "PipeCondition", "type": "esriFieldTypeString", "alias": "Pipe Condition", "domain": { "type": "codedValue", "name": "LEAK PIPE CONDITION", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Light Pitting", "code": "Light Pitting" }, { "name": "Heavy Pitting", "code": "Heavy Pitting" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PipeCondition" }, { "name": "CoatingCondition", "type": "esriFieldTypeString", "alias": "Coating Condition", "domain": { "type": "codedValue", "name": "LEAK COATING CONDITION", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CoatingCondition" }, { "name": "CoatingType", "type": "esriFieldTypeString", "alias": "Coating Type", "domain": { "type": "codedValue", "name": "LEAK COATING TYPE", "description": "", "codedValues": [ { "name": "Xtrub", "code": "Xtrub" }, { "name": "Coal Tar", "code": "Coal Tar" }, { "name": "Epoxy", "code": "Epoxy" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CoatingType" }, { "name": "CoatingRequiredRepair", "type": "esriFieldTypeString", "alias": "Did the coating require repair?", "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CoatingRequiredRepair" }, { "name": "DescribeCoatingRepair", "type": "esriFieldTypeString", "alias": "Describe Coating Repair", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "DescribeCoatingRepair" }, { "name": "Repaired", "type": "esriFieldTypeString", "alias": "Was the leak repair completed?", "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Repaired" }, { "name": "DescribeLeakRepair", "type": "esriFieldTypeString", "alias": "Describe Leak Repair", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "DescribeLeakRepair" }, { "name": "RepairedBy", "type": "esriFieldTypeString", "alias": "Repaired By", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "RepairedBy" }, { "name": "RepairedDate", "type": "esriFieldTypeDate", "alias": "Repaired Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RepairedDate" }, { "name": "MonitorGrade", "type": "esriFieldTypeString", "alias": "Monitor Grade", "domain": { "type": "codedValue", "name": "Leak Class_4", "description": "", "codedValues": [ { "name": "Class 1", "code": "1" }, { "name": "Class 2", "code": "2" }, { "name": "Class 3", "code": "3" }, { "name": "No Leak", "code": "NG" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MonitorGrade" }, { "name": "MonitorDescription", "type": "esriFieldTypeString", "alias": "Monitor Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MonitorDescription" }, { "name": "MonitorDate", "type": "esriFieldTypeDate", "alias": "Monitor Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MonitorDate" }, { "name": "MonitorBy", "type": "esriFieldTypeString", "alias": "Monitored Performed By", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "MonitorBy" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "ReportedDate", "type": "esriFieldTypeDate", "alias": "Reported Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ReportedDate" }, { "name": "SqlAddDate", "type": "esriFieldTypeDate", "alias": "AddDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "AddDate" }, { "name": "SqlStartDate", "type": "esriFieldTypeDate", "alias": "StartDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StartDate" }, { "name": "SqlEndDate", "type": "esriFieldTypeDate", "alias": "EndDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EndDate" }, { "name": "SqlStatus", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "SqlSystemLeakIsOn2", "type": "esriFieldTypeString", "alias": "SystemLeakIsOn2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SystemLeakIsOn2" }, { "name": "SqlDOTCauseOfLeak2", "type": "esriFieldTypeString", "alias": "DOTCauseOfLeak2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DOTCauseOfLeak2" }, { "name": "SqlRepairType2", "type": "esriFieldTypeString", "alias": "RepairType2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "RepairType2" }, { "name": "RelatedGuid", "type": "esriFieldTypeGUID", "alias": "RelatedGuid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RelatedGuid" }, { "name": "LeakStatus", "type": "esriFieldTypeString", "alias": "LeakStatus", "domain": { "type": "codedValue", "name": "LeakStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Cleared", "code": "Cleared" }, { "name": "Repaired", "code": "Repaired" }, { "name": "Retired", "code": "Retired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LeakStatus" }, { "name": "MonitorGasPercent", "type": "esriFieldTypeDouble", "alias": "MonitorGasPercent", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MonitorGasPercent" }, { "name": "GasDetectionEquipment", "type": "esriFieldTypeString", "alias": "Gas Detection Equipment", "domain": { "type": "codedValue", "name": "Leak Detection Equipment_4", "description": "Gas Leak Detection Equipment", "codedValues": [ { "name": "CGI", "code": "CGI" }, { "name": "Flame Pack", "code": "Flame Pack" }, { "name": "Hawk Laser Methane Detector", "code": "HLMD" }, { "name": "Mobile Flame Pack", "code": "Mobile Flame Pack" }, { "name": "Odor", "code": "Odor" }, { "name": "Other", "code": "Other" }, { "name": "Remote Methane Leak Detector", "code": "RMLD" }, { "name": "Sensit Gold", "code": "Sensit Gold" }, { "name": "Soap", "code": "Soap" }, { "name": "Visual/Vegetation", "code": "Visual/Vegetation" }, { "name": "IRwin Methane Gas Leak Detector", "code": "IR-GC-INFICON" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GasDetectionEquipment" }, { "name": "OtherGasDetectionEquipment", "type": "esriFieldTypeString", "alias": "Other Gas Detection Equipment", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OtherGasDetectionEquipment" } ], "indexes": [ { "name": "R422_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_422", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G6282RelatedGuid", "fields": "RelatedGuid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_422", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "SCUDGIS.DBO.LeakMonitor", "description": "", "prototype": { "attributes": { "MonitorGasPercent": null, "GasDetectionEquipment": null, "LeakType": null, "ReportSource": null, "LeakID": null, "StreetAddress": null, "City": null, "GasFound": null, "ArrivedDate": null, "Technician": null, "InvestigationFoundLeak": null, "IfLeakFoundGrade": null, "Location": null, "GasOdorDetected": null, "Soap": null, "GasPercent": null, "LELPercent": null, "PPMPercent": null, "PressureSystem": null, "AreaLocation": null, "ProbableSource": null, "IfMeterLocationonMeter": null, "IfMeterBodyManufacturer": null, "IfMeterSize": null, "IfMainorServiceMaterial": null, "IfMainorServiceSize": null, "ProbableCause": null, "IfExcavationDamageLocateCalled": null, "IfExcavationDamageLocateNumber": null, "IfExcavationDamageExcavatorName": null, "IfExcavationDamageExcavatorAddr": null, "IfExcavationDamageExcavatorCity": null, "IfExcavationDamageExcavatorNumb": null, "Remarks": null, "MadeSafeDate": null, "LeakGUID": null, "LeakMaintenanceType": null, "FoundGrade": null, "FoundSource": null, "FoundCause": null, "ExcavationType": null, "EquipmentFailureType": null, "EquipementFailureCouplingType": null, "MWJType": null, "MWJPipeComponent": null, "PipeCondition": null, "CoatingCondition": null, "CoatingType": null, "CoatingRequiredRepair": null, "DescribeCoatingRepair": null, "Repaired": null, "DescribeLeakRepair": null, "RepairedBy": null, "RepairedDate": null, "MonitorGrade": null, "MonitorDescription": null, "MonitorDate": null, "MonitorBy": null, "OtherGasDetectionEquipment": null, "LeakStatus": null, "RelatedGuid": null, "SqlRepairType2": null, "SqlDOTCauseOfLeak2": null, "ReportedDate": null, "SqlAddDate": null, "SqlStartDate": null, "SqlEndDate": null, "SqlStatus": null, "SqlSystemLeakIsOn2": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }