View In:   ArcGIS Online Map Viewer

Name: Gas Service

Display Field: SIZE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 4515

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: 1368283.3336227238
YMin: 492431.46677421033
XMax: 1405345.9346942306
YMax: 534835.170352459
Spatial Reference: 102723  (3735)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 2
  Label: City Side
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [130, 72, 0, 255]
  Width: 1
• Value: 1
  Label: Customer Side
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 153, 64, 255]
  Width: 1
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: SUBTYPECD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SIZE ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SIZE , Coded Values: [.25: 1/4"] , [.5: 1/2"] , [.75: 3/4"] , ...16 more... )
• INTERNALSIZE ( type: esriFieldTypeString, alias: Internal Size, editable: true, nullable: true, length: 20, defaultValue: null, modelName: INTERNALSIZE )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MATERIAL , Coded Values: [BS: Bare Steel] , [CI: Cast Iron] , [CS: Coated Steel] , ...4 more... )
• COATINGTYPE ( type: esriFieldTypeString, alias: Coating Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COATINGTYPE , Coded Values: [CTE: Coal Tar Enamel] , [MW: Mill Wrap] , [UVTP: UV Tape] , ...6 more... )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MANUFACTURER , Coded Values: [PER: Performance] , [USP: US Poly] , [DRC: Drisco] , ...10 more... )
• OPERATINGPRESSURE ( type: esriFieldTypeString, alias: Operating Pressure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OPERATINGPRESSURE , Coded Values: [7: Intermediate (7 lb)] , [20: Medium (20 lb)] , [30: Medium (30 lb)] , ...9 more... )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: In-Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSERVICEDATE )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LOCATION )
• DEPTH ( type: esriFieldTypeString, alias: Depth (Inches), editable: true, nullable: true, length: 20, defaultValue: null, modelName: DEPTH )
• OWNER ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OWNER , Coded Values: [CITY: City] , [OTH: Other] )
• INSTALLER ( type: esriFieldTypeString, alias: Installer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: INSTALLER , Coded Values: [Hamilton: City of Hamilton] , [Contractor: Contractor] , [Unknown: Unknown] )
• CONTRACTOR ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACTOR )
• INSTALLATIONMETHOD ( type: esriFieldTypeString, alias: Installation Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSTALLATIONMETHOD , Coded Values: [TRN: Trenching] , [INS: Insertion] , [BOR: Jack and Bore] , ...2 more... )
• CATHODICINDICATOR ( type: esriFieldTypeString, alias: Cathodic Protection, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CATHODICINDICATOR , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• SYSTEMPRESSURE ( type: esriFieldTypeDouble, alias: Standard System Pressure, editable: true, nullable: true, defaultValue: null, modelName: SYSTEMPRESSURE )
• CPREADING ( type: esriFieldTypeString, alias: CP Reading, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CPREADING )
• INSULATEDINDICATOR ( type: esriFieldTypeString, alias: Insulated Indicator, editable: true, nullable: true, length: 15, defaultValue: null, modelName: INSULATEDINDICATOR , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• WALLTHICKNESS ( type: esriFieldTypeString, alias: Wall Thickness, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WALLTHICKNESS )
• MAOP ( type: esriFieldTypeInteger, alias: MAOP, editable: true, nullable: true, defaultValue: null, modelName: MAOP )
• SDR ( type: esriFieldTypeString, alias: SDR, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SDR )
• MEASUREDLENGTH ( type: esriFieldTypeDouble, alias: Measured Length, editable: true, nullable: true, defaultValue: null, modelName: MEASUREDLENGTH , Range: [1, 1000000000] )
• LENGTHSOURCE ( type: esriFieldTypeString, alias: Length Source, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LENGTHSOURCE , Coded Values: [FM: Field Measurement] , [MS: Mapping System] , [USER: User-Derived] , ...1 more... )
• LASTLEAKSURVEY ( type: esriFieldTypeDate, alias: Last Leak Survey, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTLEAKSURVEY )
• LEAKSURVEYFREQUENCY ( type: esriFieldTypeString, alias: Leak Survey Frequency, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LEAKSURVEYFREQUENCY )
• PIPETESTDATE ( type: esriFieldTypeDate, alias: Pipe Test Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PIPETESTDATE )
• PIPETESTDURATION ( type: esriFieldTypeString, alias: Pipe Test Duration, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPETESTDURATION )
• PIPETESTPRESSURE ( type: esriFieldTypeString, alias: Pipe Test Pressure, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPETESTPRESSURE )
• PIPETESTTYPE ( type: esriFieldTypeString, alias: Pipe Test Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PIPETESTTYPE , Coded Values: [AIR: Air] , [NTA: Nitrogen and Air] , [HYD: Hydrostatic] , ...1 more... )
• REGULATORTYPE ( type: esriFieldTypeString, alias: Regulator Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REGULATORTYPE , Coded Values: [SPRING: Spring Loaded] , [PILOT: Pilot Loaded] , [MON: Monitor] , ...2 more... )
• REGULATORMANUFACTURER ( type: esriFieldTypeString, alias: Regulator Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REGULATORMANUFACTURER , Coded Values: [AMR: American] , [FSH: Fisher] , [REL: Reliance] , ...4 more... )
• REGULATORMODEL ( type: esriFieldTypeString, alias: Regulator Model, editable: true, nullable: true, length: 30, defaultValue: null, modelName: REGULATORMODEL )
• REGULATORSETPRESSURE ( type: esriFieldTypeString, alias: Regulator Set Pressure, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REGULATORSETPRESSURE )
• RISER ( type: esriFieldTypeString, alias: Riser, editable: true, nullable: true, length: 15, defaultValue: null, modelName: RISER , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• RISERSIZE ( type: esriFieldTypeString, alias: Riser Size, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RISERSIZE , Coded Values: [.25: 1/4"] , [.5: 1/2"] , [.75: 3/4"] , ...16 more... )
• RISERMATERIAL ( type: esriFieldTypeString, alias: Riser Material, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RISERMATERIAL , Coded Values: [Plastic: Plastic] , [UNK: Unknown] , [Coated Steel: Coated Steel] , ...1 more... )
• RISERMANUFACTURER ( type: esriFieldTypeString, alias: Riser Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RISERMANUFACTURER , Coded Values: [PER: Perfection] , [NORMAC: Normac] , [CON: Contential] , ...2 more... )
• RISERCONDITION ( type: esriFieldTypeString, alias: Riser Condition, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RISERCONDITION , Coded Values: [EXCELLENT: Excellent] , [FAIR: Fair] , [GOOD: Good] , ...3 more... )
• RISERCONNECTION ( type: esriFieldTypeString, alias: Riser Connection Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RISERCONNECTION , Coded Values: [Fused: Fused] , [Stab: Stab] , [Electorfusion: Electrofusion] , ...2 more... )
• RISERONLY ( type: esriFieldTypeString, alias: Riser Only, editable: true, nullable: true, length: 15, defaultValue: null, modelName: RISERONLY , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• STUB ( type: esriFieldTypeString, alias: Service Stub, editable: true, nullable: true, length: 15, defaultValue: null, modelName: STUB , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• MULTIMETER ( type: esriFieldTypeString, alias: Multimeter, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MULTIMETER , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• PINCHABLE ( type: esriFieldTypeString, alias: Pinchable, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PINCHABLE , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENTS )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACILITYID )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LegacyID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Side, editable: true, nullable: true, defaultValue: 2, modelName: SUBTYPECD )
• PROJECTLINK ( type: esriFieldTypeString, alias: Project Link, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROJECTLINK )
• INGROUNDSTATUS ( type: esriFieldTypeString, alias: In Ground Status, editable: true, nullable: true, length: 30, defaultValue: InService, modelName: INGROUNDSTATUS , Coded Values: [Proposed: Proposed] , [InService: In-Service] , [Removed: Removed] , ...1 more... )
• 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 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS )
• ASSETID ( type: esriFieldTypeString, alias: Cityworks AssetID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ASSETID )

Types:

ID: 2
Name: City Side
Domains:
• SIZE:
  Inherited
• MATERIAL:
  Inherited
• COATINGTYPE:
  Inherited
• MANUFACTURER:
  Inherited
• OPERATINGPRESSURE:
  Inherited
• OWNER:
  Inherited
• INSTALLER:
  Inherited
• INSTALLATIONMETHOD:
  Inherited
• CATHODICINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• MEASUREDLENGTH:
  Inherited
• LENGTHSOURCE:
  Inherited
• PIPETESTTYPE:
  Inherited
• REGULATORTYPE:
  Inherited
• REGULATORMANUFACTURER:
  Inherited
• RISER:
  Inherited
• RISERSIZE:
  Inherited
• RISERMATERIAL:
  Inherited
• RISERMANUFACTURER:
  Inherited
• RISERCONDITION:
  Inherited
• RISERCONNECTION:
  Inherited
• RISERONLY:
  Inherited
• STUB:
  Inherited
• MULTIMETER:
  Inherited
• PINCHABLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: City Side
  Description:
  Prototype:
  COMMENTS: null
  ASSETID: null
  ADDRESS: null
  SIZE: null
  INTERNALSIZE: null
  MATERIAL: null
  COATINGTYPE: null
  MANUFACTURER: null
  OPERATINGPRESSURE: null
  INSTALLATIONDATE: null
  INSERVICEDATE: null
  LOCATION: null
  DEPTH: null
  OWNER: null
  INSTALLER: null
  CONTRACTOR: null
  INSTALLATIONMETHOD: null
  CATHODICINDICATOR: null
  SYSTEMPRESSURE: null
  CPREADING: null
  INSULATEDINDICATOR: null
  WALLTHICKNESS: null
  MAOP: null
  SDR: null
  MEASUREDLENGTH: null
  LENGTHSOURCE: null
  LASTLEAKSURVEY: null
  LEAKSURVEYFREQUENCY: null
  PIPETESTDATE: null
  PIPETESTDURATION: null
  PIPETESTPRESSURE: null
  PIPETESTTYPE: null
  REGULATORTYPE: null
  REGULATORMANUFACTURER: null
  REGULATORMODEL: null
  REGULATORSETPRESSURE: null
  RISER: null
  RISERSIZE: null
  RISERMATERIAL: null
  RISERMANUFACTURER: null
  RISERCONDITION: null
  RISERCONNECTION: null
  RISERONLY: null
  STUB: null
  MULTIMETER: null
  PINCHABLE: null
  ENABLED: 1
  FACILITYID: null
  LegacyID: null
  SUBTYPECD: 2
  PROJECTLINK: null
  INGROUNDSTATUS: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: Customer Side
Domains:
• SIZE:
  Inherited
• MATERIAL:
  Inherited
• COATINGTYPE:
  Inherited
• MANUFACTURER:
  Inherited
• OPERATINGPRESSURE:
  Inherited
• OWNER:
  Inherited
• INSTALLER:
  Inherited
• INSTALLATIONMETHOD:
  Inherited
• CATHODICINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• MEASUREDLENGTH:
  Inherited
• LENGTHSOURCE:
  Inherited
• PIPETESTTYPE:
  Inherited
• REGULATORTYPE:
  Inherited
• REGULATORMANUFACTURER:
  Inherited
• RISER:
  Inherited
• RISERSIZE:
  Inherited
• RISERMATERIAL:
  Inherited
• RISERMANUFACTURER:
  Inherited
• RISERCONDITION:
  Inherited
• RISERCONNECTION:
  Inherited
• RISERONLY:
  Inherited
• STUB:
  Inherited
• MULTIMETER:
  Inherited
• PINCHABLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: Customer Side
  Description:
  Prototype:
  COMMENTS: null
  ASSETID: null
  ADDRESS: null
  SIZE: null
  INTERNALSIZE: null
  MATERIAL: null
  COATINGTYPE: null
  MANUFACTURER: null
  OPERATINGPRESSURE: null
  INSTALLATIONDATE: null
  INSERVICEDATE: null
  LOCATION: null
  DEPTH: null
  OWNER: null
  INSTALLER: null
  CONTRACTOR: null
  INSTALLATIONMETHOD: null
  CATHODICINDICATOR: null
  SYSTEMPRESSURE: null
  CPREADING: null
  INSULATEDINDICATOR: null
  WALLTHICKNESS: null
  MAOP: null
  SDR: null
  MEASUREDLENGTH: null
  LENGTHSOURCE: null
  LASTLEAKSURVEY: null
  LEAKSURVEYFREQUENCY: null
  PIPETESTDATE: null
  PIPETESTDURATION: null
  PIPETESTPRESSURE: null
  PIPETESTTYPE: null
  REGULATORTYPE: null
  REGULATORMANUFACTURER: null
  REGULATORMODEL: null
  REGULATORSETPRESSURE: null
  RISER: null
  RISERSIZE: null
  RISERMATERIAL: null
  RISERMANUFACTURER: null
  RISERCONDITION: null
  RISERCONNECTION: null
  RISERONLY: null
  STUB: null
  MULTIMETER: null
  PINCHABLE: null
  ENABLED: 0
  FACILITYID: null
  LegacyID: null
  SUBTYPECD: 1
  PROJECTLINK: null
  INGROUNDSTATUS: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

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   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata