View In:   ArcGIS Online Map Viewer

Name: Leak All

Display Field: CustomerName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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:
Simple Renderer:
Symbol:
Label:
Description:
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:

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... )
• MeterNumber ( type: esriFieldTypeString, alias: MeterNumber, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MeterNumber )
• 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... )
• 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 )
• SurfaceType ( type: esriFieldTypeString, alias: SurfaceType, editable: true, nullable: true, length: 250, defaultValue: null, modelName: SurfaceType , Coded Values: [CONC: Concrete] , [GRAS: Grass] , [GRAV: Gravel] , ...13 more... )
• PipeMaterial ( type: esriFieldTypeString, alias: PipeMaterial, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PipeMaterial , Coded Values: [CS: Coated Steel] , [PL: Plastic] , [OTH: Other] , ...3 more... )
• PipeSize ( type: esriFieldTypeString, alias: PipeSize, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PipeSize , Coded Values: [.25: 1/4"] , [.5: 1/2"] , [.75: 3/4"] , ...12 more... )
• 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 )
• YCoordinate ( type: esriFieldTypeDouble, alias: YCoordinate, editable: true, nullable: true, defaultValue: null, modelName: YCoordinate )
• LeakDrawing ( type: esriFieldTypeString, alias: LeakDrawing, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LeakDrawing )
• LeakSurveyArea ( type: esriFieldTypeString, alias: LeakSurveyArea, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LeakSurveyArea )
• Picture ( type: esriFieldTypeString, alias: Picture, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Picture )
• 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 )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Type )
• 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 )
• 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... )
• IfLeakFoundGrade ( type: esriFieldTypeString, alias: IfLeakFoundGrade, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IfLeakFoundGrade , Coded Values: [1: Class 1] , [2: Class 2] , [3: Class 3] , ...1 more... )
• GasOdorDetected ( type: esriFieldTypeString, alias: GasOdorDetected, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GasOdorDetected , Coded Values: [YES: YES] , [NO: NO] )
• Negative ( type: esriFieldTypeString, alias: Negative, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Negative , Coded Values: [YES: YES] , [NO: NO] )
• Soap ( type: esriFieldTypeString, alias: Soap, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Soap , Coded Values: [YES: YES] , [NO: NO] )
• Visual ( type: esriFieldTypeString, alias: Visual, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Visual , Coded Values: [YES: YES] , [NO: NO] )
• PressureSystem ( type: esriFieldTypeString, alias: PressureSystem, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PressureSystem , Coded Values: [LOW: LOW: 0-59] , [MED: MEDIUM: 60-100] , [HIGH: HIGH: ABOVE 101] , ...1 more... )
• 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 )
• IfMeterLocationonMeter ( type: esriFieldTypeString, alias: IfMeterLocationonMeter, editable: true, nullable: true, length: 250, defaultValue: null, modelName: IfMeterLocationonMeter , Coded Values: [Above: Above Grade] , [Below: Below Grade] , [Grease Plug: Grease Plug On Meter Stop] , ...19 more... )
• IfMeterBodyManufacturer ( type: esriFieldTypeString, alias: IfMeterBodyManufacturer, editable: true, nullable: true, length: 250, defaultValue: null, modelName: IfMeterBodyManufacturer )
• IfMeterSize ( type: esriFieldTypeString, alias: IfMeterSize, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IfMeterSize )
• IfExcavationDamageLocateCalled ( type: esriFieldTypeString, alias: IfExcavationDamageLocateCalled, editable: true, nullable: true, length: 5, defaultValue: null, modelName: IfExcavationDamageLocateCalled , Coded Values: [YES: YES] , [NO: NO] )
• IfExcavationDamageLocateNumber ( type: esriFieldTypeString, alias: IfExcavationDamageLocateNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IfExcavationDamageLocateNumber )
• IfExcavationDamageExcavatorName ( type: esriFieldTypeString, alias: IfExcavationDamageExcavatorName, editable: true, nullable: true, length: 250, defaultValue: null, modelName: IfExcavationDamageExcavatorName )
• IfExcavationDamageExcavatorAddr ( type: esriFieldTypeString, alias: IfExcavationDamageExcavatorAddr, editable: true, nullable: true, length: 250, defaultValue: null, modelName: IfExcavationDamageExcavatorAddr )
• IfExcavationDamageExcavatorCity ( type: esriFieldTypeString, alias: IfExcavationDamageExcavatorCity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IfExcavationDamageExcavatorCity )
• IfExcavationDamageExcavatorNumb ( type: esriFieldTypeString, alias: IfExcavationDamageExcavatorNumb, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IfExcavationDamageExcavatorNumb )
• 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... )

Templates:

• Name: Leak All
  Description:
  Prototype:
  TNOneCall: null
  LeakID: null
  DateFound: null
  Address: null
  City: null
  GISArea: null
  MeterNumber: null
  LocationNumber: null
  LeakClass: null
  GasDetectionEquip: null
  AboveBelowGrnd: null
  Collecting: null
  ProbableSource: null
  Soil: null
  PercentGas: null
  PercentLEL: null
  PPM: null
  SurfaceType: null
  PipeMaterial: null
  PipeSize: null
  RiserType: null
  CustomerClass: null
  Comments: null
  TechID: null
  CustomerName: null
  XCoordinate: null
  YCoordinate: null
  LeakDrawing: null
  LeakSurveyArea: null
  Picture: null
  DOTCause: null
  Contractor: null
  DateRepaired: null
  RepeatingLeak: null
  Type: null
  AboveGround: null
  AboveGro_1: null
  Comments1: null
  Comments2: null
  ASSETID: null
  ReportSource: null
  LeakType: null
  LeakStatus: null
  IfLeakFoundGrade: null
  GasOdorDetected: null
  Negative: null
  Soap: null
  Visual: null
  PressureSystem: null
  AreaLocation: null
  ProbableCause: null
  MadeSafeDate: null
  IfMeterLocationonMeter: null
  IfMeterBodyManufacturer: null
  IfMeterSize: null
  IfExcavationDamageLocateCalled: null
  IfExcavationDamageLocateNumber: null
  IfExcavationDamageExcavatorName: null
  IfExcavationDamageExcavatorAddr: null
  IfExcavationDamageExcavatorCity: null
  IfExcavationDamageExcavatorNumb: 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