Name: SCUDGIS.DBO.LeakMonitor

Display Field: MonitorDate

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LeakType ( type: esriFieldTypeString, alias: Leak Type, length: 255 , Coded Values: [Above: Above Ground] , [Below: Below Ground] , [Broke: Broke Line] )
• ReportSource ( type: esriFieldTypeString, alias: Report Source, length: 255 , Coded Values: [Leak Survey: Leak Survey] , [Mobile FI: Mobile FI] , [Public: Public] , ...4 more... )
• LeakID ( type: esriFieldTypeString, alias: Leak ID, length: 255 )
• StreetAddress ( type: esriFieldTypeString, alias: Street Address, length: 255 )
• City ( type: esriFieldTypeString, alias: City, length: 255 , Coded Values: [01: Sevierville] , [02: Pigeon Forge] , [03: Gatlinburg] , ...2 more... )
• GasFound ( type: esriFieldTypeString, alias: Gas Found?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• ArrivedDate ( type: esriFieldTypeDate, alias: Arrived Date, length: 8 )
• Technician ( type: esriFieldTypeString, alias: Technician, length: 255 )
• InvestigationFoundLeak ( type: esriFieldTypeString, alias: Investigation Found Leak, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• IfLeakFoundGrade ( type: esriFieldTypeString, alias: Grade, length: 255 , Coded Values: [1: Class 1] , [2: Class 2] , [3: Class 3] , ...1 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 , Coded Values: [In Building: In Building] , [Near Building: Near Building] , [In Manhole: In Manhole] , ...3 more... )
• GasOdorDetected ( type: esriFieldTypeString, alias: Gas Odor Detected, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• Soap ( type: esriFieldTypeString, alias: Soap Test Performed, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• GasPercent ( type: esriFieldTypeDouble, alias: Gas Percent )
• LELPercent ( type: esriFieldTypeDouble, alias: LEL Percent )
• PPMPercent ( type: esriFieldTypeDouble, alias: PPM Percent )
• PressureSystem ( type: esriFieldTypeString, alias: PressureSystem, length: 255 , Coded Values: [LOW: LOW: 0-59] , [MED: MEDIUM: 60-100] , [HIGH: HIGH: ABOVE 101] , ...1 more... )
• AreaLocation ( type: esriFieldTypeString, alias: Area Location, length: 255 , Coded Values: [School: School] , [Hospital: Hospital] , [Commercial: Commercial] , ...1 more... )
• ProbableSource ( type: esriFieldTypeString, alias: Probable Source, length: 255 , Coded Values: [MAIN: Main] , [SERV: Service] , [SERVTAP: Service Tap] , ...5 more... )
• IfMeterLocationonMeter ( type: esriFieldTypeString, alias: Location on Meter, length: 255 , Coded Values: [Above: Above Grade] , [Below: Below Grade] , [Grease Plug: Grease Plug On Meter Stop] , ...19 more... )
• IfMeterBodyManufacturer ( type: esriFieldTypeString, alias: Meter Manufacturer, length: 255 )
• IfMeterSize ( type: esriFieldTypeString, alias: Meter Size, length: 255 )
• IfMainorServiceMaterial ( type: esriFieldTypeString, alias: Material, length: 255 , Coded Values: [PLASTIC: PLASTIC] , [BARE STEEL: BARE STEEL] , [COATED STEEL: COATED STEEL] , ...4 more... )
• IfMainorServiceSize ( type: esriFieldTypeString, alias: Size, length: 255 , Coded Values: [.25: 1/4"] , [.5: 1/2"] , [.75: 3/4"] , ...12 more... )
• ProbableCause ( type: esriFieldTypeString, alias: Probable Cause, length: 255 , Coded Values: [Corrosion: Corrosion] , [Natural Forces: Natural Forces] , [Excavation: Excavation] , ...8 more... )
• IfExcavationDamageLocateCalled ( type: esriFieldTypeString, alias: Located Called In, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• IfExcavationDamageLocateNumber ( type: esriFieldTypeString, alias: Locate Number, length: 255 )
• IfExcavationDamageExcavatorName ( type: esriFieldTypeString, alias: Exavator Name, length: 255 )
• IfExcavationDamageExcavatorAddr ( type: esriFieldTypeString, alias: Address, length: 255 )
• IfExcavationDamageExcavatorCity ( type: esriFieldTypeString, alias: City, length: 255 )
• IfExcavationDamageExcavatorNumb ( type: esriFieldTypeString, alias: Phone Number, length: 255 )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 255 )
• MadeSafeDate ( type: esriFieldTypeDate, alias: Made Safe Date, length: 8 )
• LeakGUID ( type: esriFieldTypeGUID, alias: LeakGUID, length: 38 )
• LeakMaintenanceType ( type: esriFieldTypeString, alias: Leak Maintenance Type, length: 50 , Coded Values: [Monitor: Monitor] , [Repair: Repair] )
• FoundGrade ( type: esriFieldTypeString, alias: Grade as Found, length: 50 , Coded Values: [1: Class 1] , [2: Class 2] , [3: Class 3] , ...1 more... )
• FoundSource ( type: esriFieldTypeString, alias: Source as Determined During Repair, length: 50 , Coded Values: [MAIN: Main] , [SERV: Service] , [SERVTAP: Service Tap] , ...5 more... )
• FoundCause ( type: esriFieldTypeString, alias: Leak Cause as Determined During Repair, length: 50 , Coded Values: [Corrosion: Corrosion] , [Natural Forces: Natural Forces] , [Excavation: Excavation] , ...8 more... )
• ExcavationType ( type: esriFieldTypeString, alias: Cause of Excavation Damage, length: 100 , Coded Values: [No Locates Requested: No Locates Requested] , [Mis-Marked Facilities: Mis-Marked Facilities] , [Facilities Not Marked: Facilities Not Marked] , ...3 more... )
• EquipmentFailureType ( type: esriFieldTypeString, alias: Equipment Failure Type, length: 100 , Coded Values: [Valve: Valve] , [Service: Service] , [Meter Regulator: Meter Regulator] , ...4 more... )
• EquipementFailureCouplingType ( type: esriFieldTypeString, alias: Mechanical Coupling Failure Type, length: 50 )
• MWJType ( type: esriFieldTypeString, alias: Material, Weld, or Joint Failure Type, length: 50 , Coded Values: [Welds: Welds] , [Split Seams: Split Seams] , [Incomplete Fusion: Incomplete Fusion] , ...2 more... )
• MWJPipeComponent ( type: esriFieldTypeString, alias: What pipe component?, length: 50 )
• PipeCondition ( type: esriFieldTypeString, alias: Pipe Condition, length: 50 , Coded Values: [Good: Good] , [Light Pitting: Light Pitting] , [Heavy Pitting: Heavy Pitting] )
• CoatingCondition ( type: esriFieldTypeString, alias: Coating Condition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
• CoatingType ( type: esriFieldTypeString, alias: Coating Type, length: 50 , Coded Values: [Xtrub: Xtrub] , [Coal Tar: Coal Tar] , [Epoxy: Epoxy] )
• CoatingRequiredRepair ( type: esriFieldTypeString, alias: Did the coating require repair?, length: 50 , Coded Values: [YES: YES] , [NO: NO] )
• DescribeCoatingRepair ( type: esriFieldTypeString, alias: Describe Coating Repair, length: 250 )
• Repaired ( type: esriFieldTypeString, alias: Was the leak repair completed?, length: 50 , Coded Values: [YES: YES] , [NO: NO] )
• DescribeLeakRepair ( type: esriFieldTypeString, alias: Describe Leak Repair, length: 250 )
• RepairedBy ( type: esriFieldTypeString, alias: Repaired By, length: 250 )
• RepairedDate ( type: esriFieldTypeDate, alias: Repaired Date, length: 8 )
• MonitorGrade ( type: esriFieldTypeString, alias: Monitor Grade, length: 50 , Coded Values: [1: Class 1] , [2: Class 2] , [3: Class 3] , ...1 more... )
• MonitorDescription ( type: esriFieldTypeString, alias: Monitor Description, length: 50 )
• MonitorDate ( type: esriFieldTypeDate, alias: Monitor Date, length: 8 )
• MonitorBy ( type: esriFieldTypeString, alias: Monitored Performed By, length: 250 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ReportedDate ( type: esriFieldTypeDate, alias: Reported Date, length: 8 )
• SqlAddDate ( type: esriFieldTypeDate, alias: AddDate, length: 8 )
• SqlStartDate ( type: esriFieldTypeDate, alias: StartDate, length: 8 )
• SqlEndDate ( type: esriFieldTypeDate, alias: EndDate, length: 8 )
• SqlStatus ( type: esriFieldTypeString, alias: Status, length: 50 )
• SqlSystemLeakIsOn2 ( type: esriFieldTypeString, alias: SystemLeakIsOn2, length: 50 )
• SqlDOTCauseOfLeak2 ( type: esriFieldTypeString, alias: DOTCauseOfLeak2, length: 50 )
• SqlRepairType2 ( type: esriFieldTypeString, alias: RepairType2, length: 50 )
• RelatedGuid ( type: esriFieldTypeGUID, alias: RelatedGuid, length: 38 )
• LeakStatus ( type: esriFieldTypeString, alias: LeakStatus, length: 50 , Coded Values: [Active: Active] , [Cleared: Cleared] , [Repaired: Repaired] , ...1 more... )
• MonitorGasPercent ( type: esriFieldTypeDouble, alias: MonitorGasPercent )
• GasDetectionEquipment ( type: esriFieldTypeString, alias: Gas Detection Equipment, length: 50 , Coded Values: [CGI: CGI] , [Flame Pack: Flame Pack] , [HLMD: Hawk Laser Methane Detector] , ...8 more... )
• OtherGasDetectionEquipment ( type: esriFieldTypeString, alias: Other Gas Detection Equipment, length: 50 )

Relationships:

• Leak (0) -- Related To: Leak All (1)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata