View In:   ArcGIS Online Map Viewer

Name: Leak Active

Display Field: Address

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -121521300
YMin: -93934000
XMax: 3733823.121577874
YMax: 614108.7477905601
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LeakType
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [0, 150, 115, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: Above
  Label: Above Ground
  Description:
  Symbol:
  
• Value: Below
  Label: Below Ground
  Description:
  Symbol:
  
• Value: Broke
  Label: Broke Line
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: LeakType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LeakID ( type: esriFieldTypeString, alias: LeakID, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LeakID )
• DateFound ( type: esriFieldTypeDate, alias: DateFound, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateFound )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Address )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 250, defaultValue: null, modelName: City , Coded Values: [01: Sevierville] , [02: Pigeon Forge] , [03: Gatlinburg] , ...2 more... )
• GISArea ( type: esriFieldTypeString, alias: GISArea, editable: true, nullable: true, length: 250, defaultValue: null, modelName: GISArea , Coded Values: [01: Sevierville] , [02: Pigeon Forge] , [03: Gatlinburg] , ...2 more... )
• LocationNumber ( type: esriFieldTypeString, alias: LocationNumber, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LocationNumber )
• LeakClass ( type: esriFieldTypeString, alias: LeakClass, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LeakClass , Coded Values: [1: Class 1] , [2: Class 2] , [3: Class 3] , ...1 more... )
• LeakType ( type: esriFieldTypeString, alias: Leak Type, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LeakType , Coded Values: [Above: Above Ground] , [Below: Below Ground] , [Broke: Broke Line] )
• LeakStatus ( type: esriFieldTypeString, alias: LeakStatus, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LeakStatus , Coded Values: [Active: Active] , [Cleared: Cleared] , [Repaired: Repaired] , ...1 more... )
• GasDetectionEquip ( type: esriFieldTypeString, alias: GasDetectionEquip, editable: true, nullable: true, length: 250, defaultValue: null, modelName: GasDetectionEquip , Coded Values: [CGI: CGI] , [Flame Pack: Flame Pack] , [HLMD: Hawk Laser Methane Detector] , ...8 more... )
• AboveBelowGrnd ( type: esriFieldTypeString, alias: Above or Below Ground?, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LeakType , Coded Values: [Above: Above Ground] , [Below: Below Ground] )
• Collecting ( type: esriFieldTypeString, alias: Collecting, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Collecting , Coded Values: [In Air: In Air] , [In Soil: In Soil] , [Near Building: Near Building] )
• ProbableSource ( type: esriFieldTypeString, alias: ProbableSource, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ProbableSource , Coded Values: [MAIN: Main] , [SERV: Service] , [SERVTAP: Service Tap] , ...5 more... )
• Soil ( type: esriFieldTypeString, alias: Soil, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Soil , Coded Values: [CLAY: Clay] , [ROCK: Rock] , [SAND: Sand] , ...4 more... )
• PercentGas ( type: esriFieldTypeDouble, alias: PercentGas, editable: true, nullable: true, defaultValue: null, modelName: PercentGas )
• PercentLEL ( type: esriFieldTypeDouble, alias: PercentLEL, editable: true, nullable: true, defaultValue: null, modelName: PercentLEL )
• PPM ( type: esriFieldTypeDouble, alias: PPM, editable: true, nullable: true, defaultValue: null, modelName: PPM )
• RiserType ( type: esriFieldTypeString, alias: RiserType, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RiserType , Coded Values: [Anodeless: Anodeless] , [Anodeless inserted: Anodeless Inserted] , [Steel - field fab: Steel Field Fab] , ...13 more... )
• CustomerClass ( type: esriFieldTypeString, alias: CustomerClass, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CustomerClass )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• TechID ( type: esriFieldTypeString, alias: TechID, editable: true, nullable: true, length: 250, defaultValue: null, modelName: TechID , Coded Values: [ahuskey: Andrew Huskey] , [bdrinnen: bdrinnen] , [bmanning: Bentley Manning] , ...53 more... )
• CustomerName ( type: esriFieldTypeString, alias: CustomerName, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CustomerName , Coded Values: [Commercial: Commercial] , [Residential: Residential] )
• XCoordinate ( type: esriFieldTypeDouble, alias: XCoordinate, editable: true, nullable: true, defaultValue: null, modelName: XCoordinate )
• DOTCause ( type: esriFieldTypeString, alias: DOTCause, editable: true, nullable: true, length: 250, defaultValue: null, modelName: DOTCause , Coded Values: [Corrosion: Corrosion] , [Natural Forces: Natural Forces] , [Excavation: Excavation] , ...8 more... )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Contractor )
• DateRepaired ( type: esriFieldTypeDate, alias: DateRepaired, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateRepaired )
• RepeatingLeak ( type: esriFieldTypeString, alias: RepeatingLeak, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RepeatingLeak )
• AboveGround ( type: esriFieldTypeString, alias: AboveGround, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AboveGround , Coded Values: [Above: Above Grade] , [Below: Below Grade] , [Grease Plug: Grease Plug On Meter Stop] , ...19 more... )
• AboveGro_1 ( type: esriFieldTypeString, alias: AboveGro_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AboveGro_1 , Coded Values: [AboveGrndInlet: Above Ground Inlet Piping] , [Farm Tap: Farm Tap] , [Heater Piping: Heater Piping] , ...6 more... )
• Comments1 ( type: esriFieldTypeString, alias: Comments1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments1 )
• Comments2 ( type: esriFieldTypeString, alias: Comments2, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments2 )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• AreaLocation ( type: esriFieldTypeString, alias: AreaLocation, editable: true, nullable: true, length: 250, defaultValue: null, modelName: AreaLocation , Coded Values: [School: School] , [Hospital: Hospital] , [Commercial: Commercial] , ...1 more... )
• ProbableCause ( type: esriFieldTypeString, alias: ProbableCause, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ProbableCause , Coded Values: [Corrosion: Corrosion] , [Natural Forces: Natural Forces] , [Excavation: Excavation] , ...8 more... )
• MadeSafeDate ( type: esriFieldTypeDate, alias: MadeSafeDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MadeSafeDate )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• TNOneCall ( type: esriFieldTypeString, alias: TNOneCall, editable: true, nullable: true, length: 250, defaultValue: null, modelName: TNOneCall )
• ReportSource ( type: esriFieldTypeString, alias: Report Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReportSource , Coded Values: [Leak Survey: Leak Survey] , [Mobile FI: Mobile FI] , [Public: Public] , ...4 more... )

Types:

ID: Above
Name: Above
Domains:
• City:
  Inherited
• GISArea:
  Inherited
• LeakClass:
  Inherited
• LeakType:
  Inherited
• LeakStatus:
  Inherited
• GasDetectionEquip:
  Inherited
• AboveBelowGrnd:
  Inherited
• Collecting:
  Inherited
• ProbableSource:
  Inherited
• Soil:
  Inherited
• RiserType:
  Inherited
• TechID:
  Inherited
• CustomerName:
  Inherited
• DOTCause:
  Inherited
• AboveGround:
  Inherited
• AboveGro_1:
  Inherited
• AreaLocation:
  Inherited
• ProbableCause:
  Inherited
• ReportSource:
  Inherited
• SurfaceType:
  Inherited
• PipeMaterial:
  Inherited
• PipeSize:
  Inherited
• IfLeakFoundGrade:
  Inherited
• GasOdorDetected:
  Inherited
• Negative:
  Inherited
• Soap:
  Inherited
• Visual:
  Inherited
• PressureSystem:
  Inherited
• IfMeterLocationonMeter:
  Inherited
• IfExcavationDamageLocateCalled:
  Inherited
Templates:
• Name: Above Ground
  Description:
  Prototype:
  LeakClass: null
  TNOneCall: null
  LeakID: null
  DateFound: null
  Address: null
  City: null
  GISArea: null
  LocationNumber: null
  LeakType: Above
  LeakStatus: null
  GasDetectionEquip: null
  AboveBelowGrnd: null
  Collecting: null
  ProbableSource: null
  Soil: null
  PercentGas: null
  PercentLEL: null
  PPM: null
  RiserType: null
  CustomerClass: null
  Comments: null
  TechID: null
  CustomerName: null
  XCoordinate: null
  DOTCause: null
  Contractor: null
  DateRepaired: null
  RepeatingLeak: null
  AboveGround: null
  AboveGro_1: null
  Comments1: null
  Comments2: null
  ASSETID: null
  ReportSource: null
  AreaLocation: null
  ProbableCause: null
  MadeSafeDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Below
Name: Below
Domains:
• City:
  Inherited
• GISArea:
  Inherited
• LeakClass:
  Inherited
• LeakType:
  Inherited
• LeakStatus:
  Inherited
• GasDetectionEquip:
  Inherited
• AboveBelowGrnd:
  Inherited
• Collecting:
  Inherited
• ProbableSource:
  Inherited
• Soil:
  Inherited
• RiserType:
  Inherited
• TechID:
  Inherited
• CustomerName:
  Inherited
• DOTCause:
  Inherited
• AboveGround:
  Inherited
• AboveGro_1:
  Inherited
• AreaLocation:
  Inherited
• ProbableCause:
  Inherited
• ReportSource:
  Inherited
• SurfaceType:
  Inherited
• PipeMaterial:
  Inherited
• PipeSize:
  Inherited
• IfLeakFoundGrade:
  Inherited
• GasOdorDetected:
  Inherited
• Negative:
  Inherited
• Soap:
  Inherited
• Visual:
  Inherited
• PressureSystem:
  Inherited
• IfMeterLocationonMeter:
  Inherited
• IfExcavationDamageLocateCalled:
  Inherited
Templates:
• Name: Below Ground
  Description:
  Prototype:
  LeakClass: null
  TNOneCall: null
  LeakID: null
  DateFound: null
  Address: null
  City: null
  GISArea: null
  LocationNumber: null
  LeakType: Below
  LeakStatus: null
  GasDetectionEquip: null
  AboveBelowGrnd: null
  Collecting: null
  ProbableSource: null
  Soil: null
  PercentGas: null
  PercentLEL: null
  PPM: null
  RiserType: null
  CustomerClass: null
  Comments: null
  TechID: null
  CustomerName: null
  XCoordinate: null
  DOTCause: null
  Contractor: null
  DateRepaired: null
  RepeatingLeak: null
  AboveGround: null
  AboveGro_1: null
  Comments1: null
  Comments2: null
  ASSETID: null
  ReportSource: null
  AreaLocation: null
  ProbableCause: null
  MadeSafeDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Broke
Name: Broke
Domains:
• City:
  Inherited
• GISArea:
  Inherited
• LeakClass:
  Inherited
• LeakType:
  Inherited
• LeakStatus:
  Inherited
• GasDetectionEquip:
  Inherited
• AboveBelowGrnd:
  Inherited
• Collecting:
  Inherited
• ProbableSource:
  Inherited
• Soil:
  Inherited
• RiserType:
  Inherited
• TechID:
  Inherited
• CustomerName:
  Inherited
• DOTCause:
  Inherited
• AboveGround:
  Inherited
• AboveGro_1:
  Inherited
• AreaLocation:
  Inherited
• ProbableCause:
  Inherited
• ReportSource:
  Inherited
• SurfaceType:
  Inherited
• PipeMaterial:
  Inherited
• PipeSize:
  Inherited
• IfLeakFoundGrade:
  Inherited
• GasOdorDetected:
  Inherited
• Negative:
  Inherited
• Soap:
  Inherited
• Visual:
  Inherited
• PressureSystem:
  Inherited
• IfMeterLocationonMeter:
  Inherited
• IfExcavationDamageLocateCalled:
  Inherited
Templates:
• Name: Broke Line
  Description:
  Prototype:
  LeakClass: null
  TNOneCall: null
  LeakID: null
  DateFound: null
  Address: null
  City: null
  GISArea: null
  LocationNumber: null
  LeakType: Broke
  LeakStatus: null
  GasDetectionEquip: null
  AboveBelowGrnd: null
  Collecting: null
  ProbableSource: null
  Soil: null
  PercentGas: null
  PercentLEL: null
  PPM: null
  RiserType: null
  CustomerClass: null
  Comments: null
  TechID: null
  CustomerName: null
  XCoordinate: null
  DOTCause: null
  Contractor: null
  DateRepaired: null
  RepeatingLeak: null
  AboveGround: null
  AboveGro_1: null
  Comments1: null
  Comments2: null
  ASSETID: null
  ReportSource: null
  AreaLocation: null
  ProbableCause: null
  MadeSafeDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• LeakMonitor (0) -- Related To: SCUDGIS.DBO.LeakMonitor (5)
• LeakRepair (1) -- Related To: SCUDGIS.DBO.LeakRepair (6)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata