Name: Valves

Display Field: ENGROUTENAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10933747.8235
YMin: 3396184.9972
XMax: -10843962.7529
YMax: 3636255.5306
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"1588b63631cf17fb9ccb5b60c8045411","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAKCAYAAABrGwT5AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAANRJREFUKJGlzqEvxHEYBvAPu+1bpF90k1TBJJsmilRFNMEuCcx2FIJgLgoSSVbMH2DzB2i67TuK7ZkxAdvt3BE87X32fran5R9pQSmlm+QQL3+Bpmnma61tXLYgyS7WsIWLEW4SB7XW1VLKXpJP/JUpnGOjaZrNWuvdV1/QwTYmfsweyEKt9RZnuMY+podNGYZhHHOllKck7RE/Q/EjdnCa5B0nOMLyb/i1lNJL0sVzX/+AlVLKYpJjzAziK3SS3I+amOQGs1hPMtaPl0ahgbyh9318AIfIRwf22sf6AAAAAElFTkSuQmCC","contentType":"image/png","width":11,"height":7,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":"","rotationType":"geographic","rotationExpression":"90"},"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• CREATIONUSER (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LEGACYID (type: esriFieldTypeString, alias: Legacy ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• INSTALLATIONDATE (type: esriFieldTypeDate, alias: InstallationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Proposed Retired: Proposed Retired], [Inactive: Inactive], ... 4 more ...)
• FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• WORKORDERID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• INSERVICEDATE (type: esriFieldTypeDate, alias: In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PROJECTNUMBER (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ASSETUNITCODE (type: esriFieldTypeString, alias: Asset Unit Code, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GASTRACEWEIGHT (type: esriFieldTypeInteger, alias: Gas Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SYMBOLROTATION (type: esriFieldTypeDouble, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [A: PE2406], [B: PE2708], [C: PE3408], ... 29 more ...)
• DIAMETER (type: esriFieldTypeDouble, alias: Valve Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.25: 1/4"], [0.38: 3/8"], [0.5: 1/2"], ... 28 more ...)
• VALVETYPE (type: esriFieldTypeString, alias: Valve Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Ball: Ball], [Check: Check], [Butterfly: Butterfly], ... 9 more ...)
• VALVEUSE (type: esriFieldTypeString, alias: Valve Use, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Bypass: Bypass], [Isolation: Isolation], [Purge: Purge], ... 1 more ...)
• BONDEDINDICATOR (type: esriFieldTypeString, alias: Bonded Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• CLOCKWISETOCLOSE (type: esriFieldTypeString, alias: Clockwise to Close, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• TURNSTOCLOSE (type: esriFieldTypeInteger, alias: Turns to Close, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEPTH (type: esriFieldTypeDouble, alias: Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEPTHTONUT (type: esriFieldTypeDouble, alias: Depth to Nut, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSULATEDINDICATOR (type: esriFieldTypeString, alias: Insulated Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• NORMALSTATUS (type: esriFieldTypeInteger, alias: Normal Position, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
• PRESENTSTATUS (type: esriFieldTypeInteger, alias: Present Position, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
• OPERATINGCLASSIFICATION (type: esriFieldTypeString, alias: Operating Classification, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [Non-Critical: Non-Critical], [Critical Inspection Required: Critical Inspection Required], [Critical Inspection Not Required: Critical Inspection Not Required])
• LOCATIONDESCRIPTION (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SYSTEMTYPE (type: esriFieldTypeString, alias: Sytstem Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Distribution: Distribution], [Transmission: Transmission], [Gathering: Gathering], ... 2 more ...)
• BARCODE (type: esriFieldTypeString, alias: Barcode, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [35: Industrial Pipe Fittings], [73: Plasson], [AD: A-D technologies], ... 22 more ...)
• MANUFACTURELOTNO (type: esriFieldTypeString, alias: Manufacture Lot No, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MANUFACTUREDATE (type: esriFieldTypeDate, alias: ManufactureDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MANUFACTUREMODEL (type: esriFieldTypeString, alias: Manufacturer Model, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [V0: Other Valve], [V1: Ball Valve], [V2: Butterfly Valve], ... 5 more ...)
• MAOPDESIGN (type: esriFieldTypeDouble, alias: MAOP Design, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAOPTEST (type: esriFieldTypeDouble, alias: MAOP Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAOPRECORD (type: esriFieldTypeDouble, alias: MAOP Record, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAOPUNITOFMEASURE (type: esriFieldTypeString, alias: MAOP Unit Of Measure, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Pounds/Square Inch: Pounds/Square Inch], [Inch Water Column: Inch Water Column], ... 1 more ...)
• PRESSURESYSTEM_GlobalID (type: esriFieldTypeGUID, alias: PressureSystem_GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CPSYSTEM_GlobalID (type: esriFieldTypeGUID, alias: CPSystem_GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ACCESSIBLE (type: esriFieldTypeSmallInteger, alias: Accessible, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• EVENTID (type: esriFieldTypeString, alias: EventID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• FROMDATE (type: esriFieldTypeDate, alias: From Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TODATE (type: esriFieldTypeDate, alias: To Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LOCATIONERROR (type: esriFieldTypeString, alias: Location Error, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ENGROUTEID (type: esriFieldTypeString, alias: Engineering RouteID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ENGROUTENAME (type: esriFieldTypeString, alias: Engineering Route Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ENGM (type: esriFieldTypeDouble, alias: Engineering Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONTINROUTEID (type: esriFieldTypeString, alias: Continuous Route ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CONTINROUTENAME (type: esriFieldTypeString, alias: Continuous Route Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CONTINM (type: esriFieldTypeDouble, alias: Continuous From Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPATIALACCURACY (type: esriFieldTypeSmallInteger, alias: Spatial Accuracy, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Greater than 300 Meters], [2: 101-300 Meters], ... 8 more ...)
• GPSX (type: esriFieldTypeDouble, alias: GPS X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPSY (type: esriFieldTypeDouble, alias: GPS Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REFMETHOD (type: esriFieldTypeSmallInteger, alias: Reference Method, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REFOFFSET (type: esriFieldTypeString, alias: Reference Offset, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• REFLOCATION (type: esriFieldTypeString, alias: Reference Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Valves
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Enabled: 1
• STATUS: Proposed
• SYMBOLROTATION: 0
• NORMALSTATUS: 1
• PRESENTSTATUS: 1
• SYSTEMTYPE: Distribution
• ACCESSIBLE: 1
• SPATIALACCURACY: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/15/2019 5:58:15 PM

Schema Last Edit Date: 5/15/2019 5:58:15 PM

Data Last Edit Date: 5/15/2019 5:58:15 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat