Name: SSGravityMainToDoSS7604

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 144448

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9023361.9434
YMin: 4021774.1386
XMax: -9015374.6155
YMax: 4039140.1909
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[165,83,183,255],"width":1}},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LEGACYID (type: esriFieldTypeString, alias: Legacy ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ABS: ABS Plastic], [AC: Asbestos Cement], [ASP: Asphalt], ... 37 more ...)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [1.25: 1 1/4"], ... 34 more ...)
• MAINSHAPE (type: esriFieldTypeString, alias: Main Shape, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A: Arched], [B: Barrel], [C: Circular], ... 8 more ...)
• WIDTH (type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HEIGHT (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LINEDYEAR (type: esriFieldTypeString, alias: Year Lined, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LINERMAT (type: esriFieldTypeString, alias: Liner Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LINERTYPE (type: esriFieldTypeString, alias: Liner Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CP: Cured in Place], [FF: Fold and Form or Deform/Reform], [SN: Segmented Panel], ... 3 more ...)
• FROMMH (type: esriFieldTypeString, alias: From Manhole, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• TOMH (type: esriFieldTypeString, alias: To Manhole, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• SUMFLOW (type: esriFieldTypeDouble, alias: Flow Summary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DSDEPTHFROMRIM (type: esriFieldTypeDouble, alias: DS Depth From Rim, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOWNELEV (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USDEPTHFROMRIM (type: esriFieldTypeDouble, alias: US Depth From Rim, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UPELEV (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLOPE (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeSmallInteger, alias: PACP Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Minor defect grade], [2: Minor to Moderate], [3: Moderate defect grade], ... 2 more ...)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Active: Active], [Inactive: Inactive], [Proposed: Proposed], ... 3 more ...)
• ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: City of Columbia], [2: Alpine Utilites], [3: Town of Batesburg-Leesville], ... 28 more ...)
• MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: City of Columbia], [2: Alpine Utilites], [3: Town of Batesburg-Leesville], ... 28 more ...)
• LOCATION (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• SUBBASIN (type: esriFieldTypeString, alias: Subbasin, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• DATASOURCE (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [ASB: Asbuilt/Record Drawing], [DES: Design Drawing], [IMG: Imagery], ... 12 more ...)
• DESIGNLENGTH (type: esriFieldTypeDouble, alias: Design Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LASTUPDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CREATOR (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CREATIONDATE (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LEGACYPIPEASSETID (type: esriFieldTypeString, alias: Legacy Pipe Asset ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• PRECLEANINGTYPE (type: esriFieldTypeString, alias: Pre-Cleaning Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [J: Jetting], [H: Heavy cleaning], [N: No pre-cleaning], ... 1 more ...)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• CCTVDATE (type: esriFieldTypeDate, alias: CCTV Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CCTV_ID (type: esriFieldTypeString, alias: CCTV Inspection ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INTEGRATIONSTATUS (type: esriFieldTypeString, alias: Integration Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• DateInsp (type: esriFieldTypeDate, alias: Date Inspected, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspected (type: esriFieldTypeString, alias: Inspected, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• TVOP (type: esriFieldTypeString, alias: TV Operator, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CommentsWP (type: esriFieldTypeString, alias: Comments WP, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PipeCleaningLevel (type: esriFieldTypeString, alias: Pipe Cleaning Level, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [N: No Pre-Cleaning], [J: Jetting], [H: Heavy Cleaning])
• Cleaning_Comments (type: esriFieldTypeString, alias: Cleaning Comments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• DateCleaned (type: esriFieldTypeDate, alias: Date Cleaned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReCleaning_Needed (type: esriFieldTypeString, alias: Re-Cleaning Needed, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Pipe_ReCleaning_Level (type: esriFieldTypeString, alias: Pipe Re-Cleaning Level, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [N: No Pre-Cleaning], [J: Jetting], [H: Heavy Cleaning])
• ReCleaned_Date (type: esriFieldTypeDate, alias: Re-Cleaned Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CCTV_Revisit_Complete (type: esriFieldTypeString, alias: CCTV Revisit Complete, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Full_Asset_Name (type: esriFieldTypeString, alias: Full Asset Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Diameter_1 (type: esriFieldTypeInteger, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pipe_Length (type: esriFieldTypeInteger, alias: Pipe Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Subbasin_1 (type: esriFieldTypeString, alias: Subbasin, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Inspection_Type (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CCTVComplete (type: esriFieldTypeString, alias: CCTV Complete?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Not yet attempted: Not yet attempted], [Reverse setup required : Reverse setup required], [Complete: Complete], ... 2 more ...)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ACTIVEFLAG: 1
• OWNEDBY: 1
• MAINTBY: 1
• ENABLED: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/21/2023 3:00:49 PM

Schema Last Edit Date: 8/21/2023 2:50:49 PM

Data Last Edit Date: 8/21/2023 3:00:49 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat