Parent Layer: Project Tracking

Name: Project Tracking-Non Survey

Display Field: PROJNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: This feature class tracks the documentation “lifecycle” from construction to record drawing. Gathering data along the lifecycle and most importantly raises red flags when the record drawing is “missing”. The end result brings transparency, data management, data stewardship and socialization to the buried Infrastructure GIS workflow process.Project Name - Name of the Project.Project Number - Assigned project number.Salesforce Development Permit Number - Salesforce assigned Development number.Construction Plan Delivery Date - The date the construction document was approved (Development Plans), or when the project was awarded (CIP Plans). This serves as the trigger to GIS staff a construction needs to be entered into GIS. (Note: This is inclusive for Stormwater, Water, Sewer, Reclaimed)W/S/R Construction Plan Editor - Initials of the responsible editor entering the Water, Sewer, or Reclaimed construction assets in GIS.W/S/R Construction Plan Digitized - Date the Water, Sewer, or Reclaimed construction assets were entered into GIS. Stormwater Construction Plan Editor - Initials of the responsible editor entering the Stormwater construction assets in GIS.Stormwater Construction Plan Digitized - Date the Stormwater construction assets were entered into GIS. Warranty Start Date - The date the warranty letter was written and serves as the trigger the record drawing should have been approved and accepted.Record Plan Delivery - The date the record plan document was approved and accepted. This serves as the trigger to GIS staff a record drawing needs to be entered into GIS. (Note: This is inclusive for Stormwater, Water, Sewer, Reclaimed, but not SCM)W/S/R Record Plan Editor - Initials of the responsible editor entering the Water, Sewer, or Reclaimed record plan assets in GIS.W/S/R Record Plan Digitized - Date the Water, Sewer, or Reclaimed record plan assets were entered into GIS. Stormwater Record Plan Editor - Initials of the responsible editor entering the Stormwater record plan assets in GIS.Stormwater Record Plan Digitized - Date the Stormwater record plan assets were entered into GIS. Record Plan Delivery Stormwater SCM - Date the stormwater SCM record plan document was approved and accepted.Stormwater SCM Record Plan Editor - Initials of the responsible editor entering the SCM record plan asset in GIS.Stormwater SCM Record Plan Digitized - Date the SCM record plan asset was entered into GIS. Record Plan Archival - Date of archiving the record drawing.Water - A T/F field to represent if the project has water assets.Sewer- A T/F field to represent if the project has sewer assets.Stormwater - A T/F field to represent if the project has stormwater assets.Reclaimed - A T/F field to represent if the project has Reclaimed assets.Project Type - Indicates if this project is development, Capital Improvement, PWUT In house, or NCDOT project.Construction Plan Link - Link to the construction plan document.Record Plan Link - Link to the record plan document.Salesforce Record Link - Link to the Salesforce record.Notes- A field to record additional notes.created_user, created_date, last_edited_user, last_edited_date - Standard ESRI automatic editor tracking fields.

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Effective Min Scale: 300000

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -8796626.954213394
YMin: 4236997.916126718
XMax: -8763963.625469455
YMax: 4286463.020162462
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PROJTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [122, 245, 202, 255]
Outline:
Style: esriSLSNull
Color: [110, 110, 110, 255]
Width: 0
Default Label:
UniqueValueInfos:
• Value: DP
  Label: Development Project
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 211, 127, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 0
• Value: CIP
  Label: Capital Improvement Project
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [115, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 0
• Value: NCDOT
  Label: NC Department of Transportation
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [124, 202, 222, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: PWUT
  Label: Public Works/Utility In house Project
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [233, 255, 190, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 0
Transparency: 50
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PROJNAME ( type: esriFieldTypeString, alias: Project Name, length: 75 )
• PROJNUM ( type: esriFieldTypeString, alias: Project Number, length: 75 )
• SALESFORDEVPERM ( type: esriFieldTypeString, alias: Salesforce Development Permit Number, length: 100 )
• CONSPLANDEL ( type: esriFieldTypeDate, alias: Construction Plan Delivery, length: 8 )
• UTILCONSPLANEDITOR ( type: esriFieldTypeString, alias: W/S/R Construction Plan Editor, length: 20 )
• UTILCONSPLANDIGIT ( type: esriFieldTypeDate, alias: W/S/R Construction Plan Digitized, length: 8 )
• SWCONSPLANEDITOR ( type: esriFieldTypeString, alias: Stormwater Construction Plan Editor, length: 20 )
• SWCONSPLANDIGIT ( type: esriFieldTypeDate, alias: Stormwater Construction Plan Digitized, length: 8 )
• WARRSTART ( type: esriFieldTypeDate, alias: Warranty Start Date, length: 8 )
• RECPLANDELIVERY ( type: esriFieldTypeDate, alias: Record Plan Delivery, length: 8 )
• UTILRECPLANEDITOR ( type: esriFieldTypeString, alias: W/S/R Record Plan Editor, length: 20 )
• UTILRECPLANDIGIT ( type: esriFieldTypeDate, alias: W/S/R Record Plan Digitized, length: 8 )
• SWRECPLANEDITOR ( type: esriFieldTypeString, alias: Stormwater Record Plan Editor, length: 20 )
• SWRECPLANDIGIT ( type: esriFieldTypeDate, alias: Stormwater Record Plan Digitized, length: 8 )
• SWSCMRECPLANDEL ( type: esriFieldTypeDate, alias: Record Plan Delivery Stormwater SCM, length: 8 )
• SWSCMRECPLANEDITOR ( type: esriFieldTypeString, alias: Stormwater SCM Record Plan Editor, length: 30 )
• SWSCMRECPLANDIGIT ( type: esriFieldTypeDate, alias: Stormwater SCM Record Plan Digitized, length: 8 )
• RECPLANARCHIV ( type: esriFieldTypeDate, alias: Record Plan Archival, length: 8 )
• WATER ( type: esriFieldTypeSmallInteger, alias: Water , Coded Values: [0: False] , [1: True] )
• SEWER ( type: esriFieldTypeSmallInteger, alias: Sewer , Coded Values: [0: False] , [1: True] )
• STORMWATER ( type: esriFieldTypeSmallInteger, alias: Stormwater , Coded Values: [0: False] , [1: True] )
• RECLAIMED ( type: esriFieldTypeSmallInteger, alias: Reclaimed , Coded Values: [0: False] , [1: True] )
• PROJTYPE ( type: esriFieldTypeString, alias: Project Type, length: 50 , Coded Values: [CIP: Capital Improvement Project] , [DP: Development Project] , [PWUT: Public Works/Utility In house Project] , ...2 more... )
• CONSTLINK ( type: esriFieldTypeString, alias: Construction Plan Link, length: 255 )
• RECLINK ( type: esriFieldTypeString, alias: Record Plan Link, length: 255 )
• SALESFORLINK ( type: esriFieldTypeString, alias: Salesforce Record Link, length: 255 )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• SCM ( type: esriFieldTypeSmallInteger, alias: Stormwater SCM , Coded Values: [0: False] , [1: True] )
• SURVEYDEL ( type: esriFieldTypeDate, alias: Survey Delivery Date, length: 8 )
• SURVEYEDITOR ( type: esriFieldTypeString, alias: Survey Editor, length: 20 )
• SURVEYDIGITIZED ( type: esriFieldTypeDate, alias: Survey Digitized Date, length: 8 )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

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

  Iteminfo   Thumbnail   Metadata