Name: PIPELINE

Display Field: PIPELINE_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 0b6ea39373374d868246e69ee986e7a0

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 50 )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 255 )
• FROM_DATE ( type: esriFieldTypeDate, alias: FROM_DATE, length: 8 )
• HAS_LRS ( type: esriFieldTypeString, alias: HAS_LRS, length: 50 , Coded Values: [No: No] , [Not Applicable: Not Applicable] , [Unknown: Unknown] , ...1 more... )
• HAS_ROUTE ( type: esriFieldTypeString, alias: HAS_ROUTE, length: 50 , Coded Values: [No: No] , [Not Applicable: Not Applicable] , [Unknown: Unknown] , ...1 more... )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 50 , Coded Values: [Offshore: Offshore] , [Onshore: Onshore] , [Onshore/Offshore: Onshore/Offshore] , ...2 more... )
• OPERATIONAL_STATUS ( type: esriFieldTypeString, alias: OPERATIONAL_STATUS, length: 50 , Coded Values: [Abandoned: Abandoned] , [Active: Active] , [Conceptual: Conceptual] , ...8 more... )
• OPERATOR_COMPANY_ID ( type: esriFieldTypeGUID, alias: OPERATOR_COMPANY_ID, length: 38 )
• PARENT_PIPELINE_RFX ( type: esriFieldTypeGUID, alias: PARENT_PIPELINE_RFX, length: 38 )
• PIPELINE_NAME ( type: esriFieldTypeString, alias: PIPELINE_NAME, length: 90 )
• PIPELINE_ORDER ( type: esriFieldTypeInteger, alias: PIPELINE_ORDER )
• PIPELINE_TAG ( type: esriFieldTypeString, alias: PIPELINE_TAG, length: 25 )
• PIPELINE_TYPE ( type: esriFieldTypeString, alias: PIPELINE_TYPE, length: 50 , Coded Values: [Dumpline: Dumpline] , [Export: Export] , [Flowline: Flowline] , ...24 more... )
• PRESERVE_RELATE_IDENTIFIER ( type: esriFieldTypeGUID, alias: PRESERVE_RELATE_IDENTIFIER, length: 38 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 , Coded Values: [Current: Current] , [Historic: Historic] , [Unknown: Unknown] , ...1 more... )
• SYSTEM_TYPE ( type: esriFieldTypeString, alias: SYSTEM_TYPE, length: 50 , Coded Values: [Distribution: Distribution] , [Gathering: Gathering] , [Transmission: Transmission] , ...2 more... )
• TO_DATE ( type: esriFieldTypeDate, alias: TO_DATE, length: 8 )
• UNIQUE_ID ( type: esriFieldTypeGUID, alias: UNIQUE_ID, length: 38 )
• PL_COMPANY_NAME ( type: esriFieldTypeString, alias: PL_COMPANY_NAME, length: 75 )
• PRODUCT_TYPE ( type: esriFieldTypeString, alias: PRODUCT_TYPE, length: 50 , Coded Values: [CRD, Crude Oil: CRD, Crude Oil] , [HVL, Highly Volatile Liquid: HVL, Highly Volatile Liquid] , [NG, Natural Gas: NG, Natural Gas] , ...4 more... )
• OPID ( type: esriFieldTypeInteger, alias: OPID )
• COMPANY_ID ( type: esriFieldTypeGUID, alias: COMPANY_ID, length: 38 )
• PL_OPERATOR_NAME ( type: esriFieldTypeString, alias: PL_OPERATOR_NAME, length: 75 )

Relationships:

• pipelineFeature-PIPSG (29) -- Related To: PIPE_SEGMENT (14)
• pipelineFeature-BRNCN (10) -- Related To: BRANCH_CONNECT (134)
• pipelineFeature-DOCRN (0) -- Related To: DOCUMENT_RANGE (152)
• pipelineFeature-IILID (3) -- Related To: ILI Data (147)
• pipelineFeature-MARKR (23) -- Related To: MARKER (9)
• pipelineFeature-IILII (4) -- Related To: ILI INSPECTION (51)
• pipelineFeature-TEE (18) -- Related To: TEE (4)
• pipelineFeature-XNGPI (15) -- Related To: CROSSING_PIPELINE (0)
• pipelineFeature-PIPJR (5) -- Related To: PIPE_JURISDICTION (140)
• pipelineFeature-PIPLN (28) -- Related To: PIPE_LENGTH (119)
• pipelineFeature-VALVE (22) -- Related To: VALVE (8)
• pipelineFeature-COTNG (26) -- Related To: COATING (12)
• Matador.SDE.RECTIFIER (44) -- Related To: RECTIFIER (23)
• pipelineFeature-FLANG (13) -- Related To: FLANGE (124)
• pipelineFeature-CONSG (46) -- Related To: CONSEQUENCE_SEGMENT (176)
• networkRoute-ESNET (32) -- Related To: ENGINEERING_STA_NETWORK (16)
• pipelineProduct (47) -- Related To: PIPELINE_PRODUCT (179)
• Matador.SDE.TEST_POINT (41) -- Related To: TEST_POINT (49)
• pipelineFeature-TSPRS (2) -- Related To: TEST_PRESSURE (151)
• pipelineFeature-XNGUT (17) -- Related To: CROSSING_UTILITY (2)
• pipelineFeature-XNGTN (16) -- Related To: CROSSING_TRANSPORTATION (1)
• networkRoute-CMNET (34) -- Related To: CONTINUOUS_MEAS_NETWORK (15)
• pipelineFeature-CASNG (27) -- Related To: CASING (13)
• pipelineFeature-PIPBN (24) -- Related To: PIPE_BEND (10)
• pipelineFeature-GRTWD (20) -- Related To: GIRTH_WELD (6)
• Matador.SDE.TANK_TEST_POINT (39) -- Related To: TANK_TEST_POINT (48)
• pipelineFeature-REDCR (12) -- Related To: REDUCER (129)
• ENGINEERING_STA_NETWORK (31) -- Related To: ENGINEERING_STA_NETWORK (16)
• pipelineFeature-OWNER (7) -- Related To: OWNERSHIP (21)
• Matador.SDE.TANK_BOTTOM_INSPECTION (36) -- Related To: TANK_BOTTOM_INSPECTION (24)
• OPERATOR_COMPANY (48) -- Related To: PIPELINE_COMPANY (180)
• Matador.SDE.PIPELINE_COMPANY (49) -- Related To: PIPELINE_COMPANY (180)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata