View In:   ArcGIS Online Map Viewer

Name: CollectionSystem.DBO.ssGravityMain

Display Field: PlaceName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: c878a44cb37b46ddbd1acd2fe85cd7b6

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: 259513.6264698282
YMin: 2169983.7134902403
XMax: 295083.7187153287
YMax: 2203992.857742153
Spatial Reference: 2244  (2965)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNEDBY
Field 2: WATERTYPE
Field 3: LINERTYPE
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 1,Combined,
  Label: Combined
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 6
• Value: 1,Combined,C
  Label: Combined - Lined
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 4
• Value: 1,Sewage,C
  Label: Gravity - Lined
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 4
• Value: 1,Sewage,
  Label: Gravity
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 6
• Value: 2,Sewage,
  Label: Gravity
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 6
• Value: -1,Sewage,
  Label: Private
  Description:
  Symbol:
  Style: esriSLSDashDot
  Color: [85, 255, 0, 255]
  Width: 2
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: OWNEDBY

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...33 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...27 more... )
• MAINSHAPE ( type: esriFieldTypeString, alias: Main Shape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINSHAPE , Coded Values: [A: Arched] , [B: Barrel] , [C: Circlular] , ...8 more... )
• LINERTYPE ( type: esriFieldTypeString, alias: Liner Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LINERTYPE , Coded Values: [FF: Fold and Form or Deform/Reform] , [SN: Segmented Panel] , [SP: Segmented Pipe] , ...10 more... )
• FROMMH ( type: esriFieldTypeString, alias: From Manhole, editable: true, nullable: true, length: 11, defaultValue: null, modelName: FROMMH )
• TOMH ( type: esriFieldTypeString, alias: To Manhole, editable: true, nullable: true, length: 11, defaultValue: null, modelName: TOMH )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WATERTYPE , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] , ...1 more... )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 26, defaultValue: null, modelName: FACILITYID )
• SRF_PACKAGE ( type: esriFieldTypeString, alias: SRF_PACKAGE, editable: true, nullable: true, length: 150, defaultValue: null, modelName: SRF_PACKAGE )
• RehabID ( type: esriFieldTypeString, alias: RehabID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RehabID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 64, defaultValue: null, modelName: City )
• Material_Itpipes ( type: esriFieldTypeString, alias: Material_Itpipes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Material_Itpipes , Coded Values: [Acrylonitrile Butadiene Styrene: Acrylonitrile Butadiene Styrene] , [Asbestos Cement: Asbestos Cement] , [Brick: Brick] , ...24 more... )
• WaterTypeITPipes ( type: esriFieldTypeString, alias: WaterTypeITPipes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: WaterTypeITPipes , Coded Values: [Combined Pipe: Combined Pipe] , [Dam Pipe: Dam Pipe] , [Force Main: Force Main] , ...7 more... )
• Shape_ITPipes ( type: esriFieldTypeString, alias: Shape_ITPipes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Shape_ITPipes , Coded Values: [Arched (with flat bottom): Arched (with flat bottom)] , [Barrel (e.g. beer barrel shape): Barrel (e.g. beer barrel shape)] , [Circular: Circular] , ...8 more... )
• pipeLiningITPipes ( type: esriFieldTypeString, alias: pipeLiningITPipes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: pipeLiningITPipes , Coded Values: [Cured-In-Place Pipe: Cured-In-Place Pipe] , [Fold and Form or Deform/Reform: Fold and Form or Deform/Reform] , [Formed-In-Place Liner: Formed-In-Place Liner] , ...11 more... )

Types:

ID: 1
Name: 1
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• MAINSHAPE:
  Inherited
• LINERTYPE:
  Inherited
• WATERTYPE:
  Inherited
• OWNEDBY:
  Inherited
• Material_Itpipes:
  Inherited
• WaterTypeITPipes:
  Inherited
• Shape_ITPipes:
  Inherited
• pipeLiningITPipes:
  Inherited
• ACTIVEFLAG:
  Inherited
• MAINTBY:
  Inherited
• PACP_Use:
  Inherited
• Location_Code:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: CollectionSystem.DBO.ssGravityMain
  Description:
  Prototype:
  WaterTypeITPipes: null
  WATERTYPE: null
  City: null
  Material_Itpipes: null
  Shape_ITPipes: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  OWNEDBY: 1
  FACILITYID: null
  SRF_PACKAGE: null
  RehabID: null
  pipeLiningITPipes: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 1, Combined,
  Description:
  Prototype:
  Shape_ITPipes: null
  WaterTypeITPipes: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  WATERTYPE: Combined
  OWNEDBY: 1
  FACILITYID: null
  SRF_PACKAGE: null
  RehabID: null
  pipeLiningITPipes: null
  City: null
  Material_Itpipes: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 1, Combined, C
  Description:
  Prototype:
  Shape_ITPipes: null
  WaterTypeITPipes: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINERTYPE: C
  FROMMH: null
  TOMH: null
  WATERTYPE: Combined
  OWNEDBY: 1
  FACILITYID: null
  SRF_PACKAGE: null
  RehabID: null
  pipeLiningITPipes: null
  City: null
  Material_Itpipes: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 1, Sewage, C
  Description:
  Prototype:
  Shape_ITPipes: null
  WaterTypeITPipes: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINERTYPE: C
  FROMMH: null
  TOMH: null
  WATERTYPE: Sewage
  OWNEDBY: 1
  FACILITYID: null
  SRF_PACKAGE: null
  RehabID: null
  pipeLiningITPipes: null
  City: null
  Material_Itpipes: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 1, Sewage,
  Description:
  Prototype:
  Shape_ITPipes: null
  WaterTypeITPipes: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  WATERTYPE: Sewage
  OWNEDBY: 1
  FACILITYID: null
  SRF_PACKAGE: null
  RehabID: null
  pipeLiningITPipes: null
  City: null
  Material_Itpipes: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: 2
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• MAINSHAPE:
  Inherited
• LINERTYPE:
  Inherited
• WATERTYPE:
  Inherited
• OWNEDBY:
  Inherited
• Material_Itpipes:
  Inherited
• WaterTypeITPipes:
  Inherited
• Shape_ITPipes:
  Inherited
• pipeLiningITPipes:
  Inherited
• ACTIVEFLAG:
  Inherited
• MAINTBY:
  Inherited
• PACP_Use:
  Inherited
• Location_Code:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: 2, Sewage,
  Description:
  Prototype:
  Shape_ITPipes: null
  WaterTypeITPipes: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  WATERTYPE: Sewage
  OWNEDBY: 2
  FACILITYID: null
  SRF_PACKAGE: null
  RehabID: null
  pipeLiningITPipes: null
  City: null
  Material_Itpipes: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: -1
Name: -1
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• MAINSHAPE:
  Inherited
• LINERTYPE:
  Inherited
• WATERTYPE:
  Inherited
• OWNEDBY:
  Inherited
• Material_Itpipes:
  Inherited
• WaterTypeITPipes:
  Inherited
• Shape_ITPipes:
  Inherited
• pipeLiningITPipes:
  Inherited
• ACTIVEFLAG:
  Inherited
• MAINTBY:
  Inherited
• PACP_Use:
  Inherited
• Location_Code:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: -1, Sewage,
  Description:
  Prototype:
  Shape_ITPipes: null
  WaterTypeITPipes: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  WATERTYPE: Sewage
  OWNEDBY: -1
  FACILITYID: null
  SRF_PACKAGE: null
  RehabID: null
  pipeLiningITPipes: null
  City: null
  Material_Itpipes: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata