{ "currentVersion": 10.81, "id": 5, "name": "SCUDGIS.DBO.LeakMonitor", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MonitorDate", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LeakType", "type": "esriFieldTypeString", "alias": "Leak Type", "length": 255, "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" } }, { "name": "ReportSource", "type": "esriFieldTypeString", "alias": "Report Source", "length": 255, "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" } }, { "name": "LeakID", "type": "esriFieldTypeString", "alias": "Leak ID", "length": 255, "domain": null }, { "name": "StreetAddress", "type": "esriFieldTypeString", "alias": "Street Address", "length": 255, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 255, "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" } }, { "name": "GasFound", "type": "esriFieldTypeString", "alias": "Gas Found?", "length": 50, "domain": { "type": "codedValue", "name": "Yes/No Only", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ArrivedDate", "type": "esriFieldTypeDate", "alias": "Arrived Date", "length": 8, "domain": null }, { "name": "Technician", "type": "esriFieldTypeString", "alias": "Technician", "length": 255, "domain": null }, { "name": "InvestigationFoundLeak", "type": "esriFieldTypeString", "alias": "Investigation Found Leak", "length": 255, "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IfLeakFoundGrade", "type": "esriFieldTypeString", "alias": "Grade", "length": 255, "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" } }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "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" } }, { "name": "GasOdorDetected", "type": "esriFieldTypeString", "alias": "Gas Odor Detected", "length": 255, "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Soap", "type": "esriFieldTypeString", "alias": "Soap Test Performed", "length": 255, "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GasPercent", "type": "esriFieldTypeDouble", "alias": "Gas Percent", "domain": null }, { "name": "LELPercent", "type": "esriFieldTypeDouble", "alias": "LEL Percent", "domain": null }, { "name": "PPMPercent", "type": "esriFieldTypeDouble", "alias": "PPM Percent", "domain": null }, { "name": "PressureSystem", "type": "esriFieldTypeString", "alias": "PressureSystem", "length": 255, "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" } }, { "name": "AreaLocation", "type": "esriFieldTypeString", "alias": "Area Location", "length": 255, "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" } }, { "name": "ProbableSource", "type": "esriFieldTypeString", "alias": "Probable Source", "length": 255, "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" } }, { "name": "IfMeterLocationonMeter", "type": "esriFieldTypeString", "alias": "Location on Meter", "length": 255, "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" } }, { "name": "IfMeterBodyManufacturer", "type": "esriFieldTypeString", "alias": "Meter Manufacturer", "length": 255, "domain": null }, { "name": "IfMeterSize", "type": "esriFieldTypeString", "alias": "Meter Size", "length": 255, "domain": null }, { "name": "IfMainorServiceMaterial", "type": "esriFieldTypeString", "alias": "Material", "length": 255, "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" } }, { "name": "IfMainorServiceSize", "type": "esriFieldTypeString", "alias": "Size", "length": 255, "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" } }, { "name": "ProbableCause", "type": "esriFieldTypeString", "alias": "Probable Cause", "length": 255, "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" } }, { "name": "IfExcavationDamageLocateCalled", "type": "esriFieldTypeString", "alias": "Located Called In", "length": 255, "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IfExcavationDamageLocateNumber", "type": "esriFieldTypeString", "alias": "Locate Number", "length": 255, "domain": null }, { "name": "IfExcavationDamageExcavatorName", "type": "esriFieldTypeString", "alias": "Exavator Name", "length": 255, "domain": null }, { "name": "IfExcavationDamageExcavatorAddr", "type": "esriFieldTypeString", "alias": "Address", "length": 255, "domain": null }, { "name": "IfExcavationDamageExcavatorCity", "type": "esriFieldTypeString", "alias": "City", "length": 255, "domain": null }, { "name": "IfExcavationDamageExcavatorNumb", "type": "esriFieldTypeString", "alias": "Phone Number", "length": 255, "domain": null }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "length": 255, "domain": null }, { "name": "MadeSafeDate", "type": "esriFieldTypeDate", "alias": "Made Safe Date", "length": 8, "domain": null }, { "name": "LeakGUID", "type": "esriFieldTypeGUID", "alias": "LeakGUID", "length": 38, "domain": null }, { "name": "LeakMaintenanceType", "type": "esriFieldTypeString", "alias": "Leak Maintenance Type", "length": 50, "domain": { "type": "codedValue", "name": "LEAK MAINTENANCE TYPE", "description": "", "codedValues": [ { "name": "Monitor", "code": "Monitor" }, { "name": "Repair", "code": "Repair" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FoundGrade", "type": "esriFieldTypeString", "alias": "Grade as Found", "length": 50, "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" } }, { "name": "FoundSource", "type": "esriFieldTypeString", "alias": "Source as Determined During Repair", "length": 50, "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" } }, { "name": "FoundCause", "type": "esriFieldTypeString", "alias": "Leak Cause as Determined During Repair", "length": 50, "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" } }, { "name": "ExcavationType", "type": "esriFieldTypeString", "alias": "Cause of Excavation Damage", "length": 100, "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" } }, { "name": "EquipmentFailureType", "type": "esriFieldTypeString", "alias": "Equipment Failure Type", "length": 100, "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" } }, { "name": "EquipementFailureCouplingType", "type": "esriFieldTypeString", "alias": "Mechanical Coupling Failure Type", "length": 50, "domain": null }, { "name": "MWJType", "type": "esriFieldTypeString", "alias": "Material, Weld, or Joint Failure Type", "length": 50, "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" } }, { "name": "MWJPipeComponent", "type": "esriFieldTypeString", "alias": "What pipe component?", "length": 50, "domain": null }, { "name": "PipeCondition", "type": "esriFieldTypeString", "alias": "Pipe Condition", "length": 50, "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" } }, { "name": "CoatingCondition", "type": "esriFieldTypeString", "alias": "Coating Condition", "length": 50, "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" } }, { "name": "CoatingType", "type": "esriFieldTypeString", "alias": "Coating Type", "length": 50, "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" } }, { "name": "CoatingRequiredRepair", "type": "esriFieldTypeString", "alias": "Did the coating require repair?", "length": 50, "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DescribeCoatingRepair", "type": "esriFieldTypeString", "alias": "Describe Coating Repair", "length": 250, "domain": null }, { "name": "Repaired", "type": "esriFieldTypeString", "alias": "Was the leak repair completed?", "length": 50, "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DescribeLeakRepair", "type": "esriFieldTypeString", "alias": "Describe Leak Repair", "length": 250, "domain": null }, { "name": "RepairedBy", "type": "esriFieldTypeString", "alias": "Repaired By", "length": 250, "domain": null }, { "name": "RepairedDate", "type": "esriFieldTypeDate", "alias": "Repaired Date", "length": 8, "domain": null }, { "name": "MonitorGrade", "type": "esriFieldTypeString", "alias": "Monitor Grade", "length": 50, "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" } }, { "name": "MonitorDescription", "type": "esriFieldTypeString", "alias": "Monitor Description", "length": 50, "domain": null }, { "name": "MonitorDate", "type": "esriFieldTypeDate", "alias": "Monitor Date", "length": 8, "domain": null }, { "name": "MonitorBy", "type": "esriFieldTypeString", "alias": "Monitored Performed By", "length": 250, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "ReportedDate", "type": "esriFieldTypeDate", "alias": "Reported Date", "length": 8, "domain": null }, { "name": "SqlAddDate", "type": "esriFieldTypeDate", "alias": "AddDate", "length": 8, "domain": null }, { "name": "SqlStartDate", "type": "esriFieldTypeDate", "alias": "StartDate", "length": 8, "domain": null }, { "name": "SqlEndDate", "type": "esriFieldTypeDate", "alias": "EndDate", "length": 8, "domain": null }, { "name": "SqlStatus", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "SqlSystemLeakIsOn2", "type": "esriFieldTypeString", "alias": "SystemLeakIsOn2", "length": 50, "domain": null }, { "name": "SqlDOTCauseOfLeak2", "type": "esriFieldTypeString", "alias": "DOTCauseOfLeak2", "length": 50, "domain": null }, { "name": "SqlRepairType2", "type": "esriFieldTypeString", "alias": "RepairType2", "length": 50, "domain": null }, { "name": "RelatedGuid", "type": "esriFieldTypeGUID", "alias": "RelatedGuid", "length": 38, "domain": null }, { "name": "LeakStatus", "type": "esriFieldTypeString", "alias": "LeakStatus", "length": 50, "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" } }, { "name": "MonitorGasPercent", "type": "esriFieldTypeDouble", "alias": "MonitorGasPercent", "domain": null }, { "name": "GasDetectionEquipment", "type": "esriFieldTypeString", "alias": "Gas Detection Equipment", "length": 50, "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" } }, { "name": "OtherGasDetectionEquipment", "type": "esriFieldTypeString", "alias": "Other Gas Detection Equipment", "length": 50, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Leak", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "RelatedGuid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }