Layer: Pipeline_Engineering_Review

View In: Map Viewer

Name: Pipeline_Engineering_Review_Database

Display Field: COA_PE_NUM

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 577790.554289

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: False

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"REVIEWEDBY","fieldDelimiter":",","uniqueValueInfos":[{"symbol":{"color":[237,81,81,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"DL","label":"Daniel Lofton"},{"symbol":{"color":[115,223,255,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"AT","label":"Alfredo Torres"},{"symbol":{"color":[167,198,54,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"LW","label":"Larry Williams"},{"symbol":{"color":[158,85,156,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"GR","label":"George Resendez"},{"symbol":{"color":[232,169,48,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"BJ","label":"Britt Jones"},{"symbol":{"color":[255,190,232,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"JBW","label":"John Bowman"},{"symbol":{"color":[230,230,0,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"JBT","label":"Jeff Betts"},{"symbol":{"color":[253,127,111,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"GJ","label":"Gabriele Juarez"},{"symbol":{"color":[0,168,132,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"RC","label":"Roverto Chapa"},{"symbol":{"color":[183,129,74,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"SH","label":"Sarah Hoes"},{"symbol":{"color":[107,107,214,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"SP","label":"Shwetha Pandurangi"},{"symbol":{"color":[153,153,153,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"JL","label":"Justin Lewis"}]},"labelingInfo":[{"labelExpression":null,"labelExpressionInfo":{"expression":"$feature[\"PROJECT\"]","value":"{PROJECT}"},"useCodedValues":true,"maxScale":0,"minScale":38823,"where":null,"labelPlacement":"esriServerPolygonPlacementAlwaysHorizontal","symbol":{"color":[51,51,51,255],"type":"esriTS","backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"haloSize":0.75,"haloColor":[255,255,255,255],"verticalAlignment":"baseline","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"text":"","rotated":false,"kerning":true,"font":{"size":8.25,"style":"normal","decoration":"none","weight":"normal","family":"Arial Unicode MS"}}}],"transparency":25}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
COA_PE_NUM (type: esriFieldTypeString, alias: COA_PE_NUM, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [SPE: SP Exempt], [SS: Site / Subdivision], [GENP: General Permit], ... 3 more ...)
SITEDEVNUM (type: esriFieldTypeString, alias: SITEDEVNUM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PROJECT (type: esriFieldTypeString, alias: PROJECT, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
ENGINEER (type: esriFieldTypeString, alias: ENGINEER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SEALINGENG (type: esriFieldTypeString, alias: SEALINGENG, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
REVIEWEDBY (type: esriFieldTypeString, alias: REVIEWEDBY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [AT: Alfredo Torres], [DL: Daniel Lofton], [GR: George Resendez], ... 21 more ...)
APPROVEDBY (type: esriFieldTypeString, alias: APPROVEDBY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [AT: Alfredo Torres], [DL: Daniel Lofton], [GR: George Resendez], ... 21 more ...)
COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
STATUS (type: esriFieldTypeSmallInteger, alias: STATUS, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Under Review], [2: Waiting on Update], [3: Closed], ... 4 more ...)
Project_Alert_Comments (type: esriFieldTypeString, alias: Project Alert Comments, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
SUB1DATE (type: esriFieldTypeDate, alias: Initial submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM1REV (type: esriFieldTypeDate, alias: 1st comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB2DATE (type: esriFieldTypeDate, alias: 2nd submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM2REV (type: esriFieldTypeDate, alias: 2nd comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB3DATE (type: esriFieldTypeDate, alias: 3rd submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM3REV (type: esriFieldTypeDate, alias: 3rd comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB4DATE (type: esriFieldTypeDate, alias: 4th submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM4REV (type: esriFieldTypeDate, alias: 4th comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB5DATE (type: esriFieldTypeDate, alias: 5th submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM5REV (type: esriFieldTypeDate, alias: 5th comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB6DATE (type: esriFieldTypeDate, alias: 6th submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM6REV (type: esriFieldTypeDate, alias: 6th comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB7DATE (type: esriFieldTypeDate, alias: 7th submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM7REV (type: esriFieldTypeDate, alias: 7th comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB8DATE (type: esriFieldTypeDate, alias: 8th submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM8REV (type: esriFieldTypeDate, alias: 8th comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB9DATE (type: esriFieldTypeDate, alias: 9th submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM9REV (type: esriFieldTypeDate, alias: 9th comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB10DATE (type: esriFieldTypeDate, alias: 10th submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM10REV (type: esriFieldTypeDate, alias: 10th comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB11DATE (type: esriFieldTypeDate, alias: 11th submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM11REV (type: esriFieldTypeDate, alias: 11th comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB12DATE (type: esriFieldTypeDate, alias: 12th submittal date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COM12REV (type: esriFieldTypeDate, alias: 12th comment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SIGNOFFD (type: esriFieldTypeDate, alias: Sign off Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PCOMP (type: esriFieldTypeSmallInteger, alias: Project Complexity, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Low], [2: Medium], [3: High])
APPROVED (type: esriFieldTypeSmallInteger, alias: APPROVED, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
ASSETI_W (type: esriFieldTypeInteger, alias: Asset Information Water, SQL Type: sqlTypeOther, nullable: true, editable: true)
ASSETI_WW (type: esriFieldTypeInteger, alias: Asset Information Wastewater, SQL Type: sqlTypeOther, nullable: true, editable: true)
ASSETI_REC (type: esriFieldTypeInteger, alias: Asset Information Reclaimed, SQL Type: sqlTypeOther, nullable: true, editable: true)
METERINFO (type: esriFieldTypeInteger, alias: METERINFO, SQL Type: sqlTypeOther, nullable: true, editable: true)
METERTYPE (type: esriFieldTypeString, alias: METER TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Displacement: Displacement], [Turbine: Turbine], [Fire Demand: Fire Demand], ... 1 more ...)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
ApprovedThirdRev (type: esriFieldTypeString, alias: Approved by 3rd Review? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)
AmandaFolderNumber (type: esriFieldTypeString, alias: Amanda Folder #, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/10/2026 1:47:03 PM

Schema Last Edit Date: 2/4/2026 5:06:30 PM

Data Last Edit Date: 4/10/2026 1:47:03 PM

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

Layer: Pipeline_Engineering_Review_Database (ID:0)