Name: CIP Tracker

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Description This feature class is published to the City of Arlington's Enterprise Portal with ESRI. The feature service is consumed in an application that allows interdepartmental planning and reporting to streamline the CIP process, save money by combining CIP efforts across departments, and reduce inconvenience to the public. Extent Description Citywide DatasetSpatial Reference Type ProjectedGeographic Coordinate Reference Projection NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_FeetWell-Known Identifier 2276Current Data status Data updated continuallyUpdate Frequency Continual ProcessUpdate Method Data is edited from ArcGIS Online Web Application Editor by Public Works, Python Automation, and manually from ArcGIS Pro by PWIS Updated by Public Works StaffContact's Department Name Public Works Information ServicesContact's Position/Title Information Services CoordinatorContact Phone Number x6561Contact Email PWIS@arlingtontx.govIntegrations PW Cartegraph, ArcGIS Online

Copyright Text: City of Arlington, Public Works Staff

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

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: -1.0823424940336132E7
YMin: 3840968.30897977
XMax: -1.0802047803358978E7
YMax: 3870838.9953585956
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ProjectPhase
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSFSDiagonalCross
Color: [0, 0, 0, 255]
Outline:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 0
Default Label: Project Phase Unknown
UniqueValueInfos:
• Value: Bidding
  Label: Bidding; Construction
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [202, 122, 245, 255]
  Outline:
  Style: esriSLSSolid
  Color: [202, 122, 245, 255]
  Width: 1
• Value: Construction
  Label: Bidding; Construction
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [202, 122, 245, 255]
  Outline:
  Style: esriSLSSolid
  Color: [202, 122, 245, 255]
  Width: 1
• Value: Complete
  Label: Complete; Warranty / Maintenance
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [78, 78, 78, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 0]
  Width: 2
• Value: Warranty / Maintenance
  Label: Complete; Warranty / Maintenance
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [78, 78, 78, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 0]
  Width: 2
• Value: Design
  Label: Design
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [230, 152, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [230, 152, 0, 255]
  Width: 0
• Value: Equipment / Services
  Label: Equipment / Services
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [181, 53, 53, 255]
  Outline:
  Style: esriSLSSolid
  Color: [168, 0, 0, 255]
  Width: 0
• Value: Planning
  Label: Planning
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [115, 178, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [115, 178, 255, 255]
  Width: 0
• Value: Study / Evaluation
  Label: Study / Evaluation
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [230, 230, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [230, 230, 0, 255]
  Width: 0
Transparency: 30
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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, length: 250 )
• StreetName ( type: esriFieldTypeString, alias: Street Name, length: 50 )
• FromStreet ( type: esriFieldTypeString, alias: From Street, length: 50 )
• ToStreet ( type: esriFieldTypeString, alias: To Street, length: 50 )
• ProjectLocation ( type: esriFieldTypeString, alias: Project Location (eBuilder), length: 1500 )
• ProjectScope ( type: esriFieldTypeString, alias: Project Scope, length: 1500 )
• WaterProject ( type: esriFieldTypeString, alias: Water Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• SewerProject ( type: esriFieldTypeString, alias: Sewer Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• StreetProject ( type: esriFieldTypeString, alias: Street Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• DrainageProject ( type: esriFieldTypeString, alias: Drainage Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• SidewalkProject ( type: esriFieldTypeString, alias: Sidewalk Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• TrafficProject ( type: esriFieldTypeString, alias: Traffic Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• ParksProject ( type: esriFieldTypeString, alias: Parks Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• BuildingProject ( type: esriFieldTypeString, alias: Building Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• MillOverlayProject ( type: esriFieldTypeString, alias: Mill Overlay Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• ReclamationProject ( type: esriFieldTypeString, alias: Reclamation Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• MicrosealProject ( type: esriFieldTypeString, alias: Microseal Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• HeaterRepaverProject ( type: esriFieldTypeString, alias: Heater Repaver Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• PanelReplacementProject ( type: esriFieldTypeString, alias: Panel Replacement Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• ManagingDivision ( type: esriFieldTypeString, alias: Managing Division, length: 4 , Coded Values: [PWDR: Public Works Drainage] , [PWSM: Public Works Street Maintenance] , [PWST: Public Works Engineering (Streets)] , ...8 more... )
• CityDepartment ( type: esriFieldTypeString, alias: City Department, length: 2 , Coded Values: [PW: Public Works] , [WU: Water Utilities] , [CM: Construction Management] , ...1 more... )
• PrimaryProjectNumber ( type: esriFieldTypeString, alias: Primary Project Number, length: 50 )
• SecondaryProjectNumber ( type: esriFieldTypeString, alias: Secondary Project Number, length: 50 )
• PrimaryProjectManager ( type: esriFieldTypeString, alias: PrimaryProjectManager, length: 100 )
• PrimaryPMPhone ( type: esriFieldTypeString, alias: Primary Project Manager's Phone Number, length: 15 )
• PrimaryPMEmail ( type: esriFieldTypeString, alias: Primary Project Manager's E-mail, length: 50 )
• SecondaryProjectManager ( type: esriFieldTypeString, alias: Secondary Project Manager, length: 30 )
• CouncilDistrict ( type: esriFieldTypeString, alias: Council District, length: 15 )
• SubsCompleteMonth ( type: esriFieldTypeString, alias: Substantially Complete Month, length: 3 , Coded Values: [JAN: January] , [FEB: February] , [MAR: March] , ...9 more... )
• SubsCompleteCalendarYear ( type: esriFieldTypeSmallInteger, alias: Substantially Complete Calendar Year )
• SubsCompleteFiscalQuarter ( type: esriFieldTypeSmallInteger, alias: Substantially Complete Fiscal Quarter )
• SubsCompleteFiscalYear ( type: esriFieldTypeSmallInteger, alias: Substantially Complete Fiscal Year )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 30 )
• HikeBikePlan ( type: esriFieldTypeString, alias: Hike/Bike Plan, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• SquareYard ( type: esriFieldTypeDouble, alias: Square Yard )
• LaneMile ( type: esriFieldTypeDouble, alias: Lane Mile )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 255 )
• CurrentActivity ( type: esriFieldTypeString, alias: Current Activity, length: 3500 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 50 )
• AnticipatedCompletionDate ( type: esriFieldTypeDate, alias: Anticipated Completion Date, length: 8 )
• LastUpdatedDate ( type: esriFieldTypeDate, alias: Last Updated Date, length: 8 )
• LastUpdatedByEBuilder ( type: esriFieldTypeDate, alias: Last Updated by e-Builder, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• SubsCompleteQtr ( type: esriFieldTypeString, alias: Substantially Complete Quarter, length: 10 )
• CIP_ID ( type: esriFieldTypeString, alias: CIP ID, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• EditedLastBy ( type: esriFieldTypeString, alias: EditedLastBy, length: 50 )
• LastEditedDate ( type: esriFieldTypeDate, alias: LastEditedDate, length: 8 )
• BondProgramYear ( type: esriFieldTypeSmallInteger, alias: Bond Program Year )
• BondProjectCategory ( type: esriFieldTypeString, alias: Bond Project Category, length: 30 , Coded Values: [Public Safety: Public Safety] , [Parks & Recreation: Parks & Recreation] , [Public Works/Streets: Public Works/Streets] , ...2 more... )
• ProjectStatus ( type: esriFieldTypeString, alias: Project Status, length: 50 )
• ProjectPhase ( type: esriFieldTypeString, alias: Project Phase, length: 50 )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• ConstructionStartYear ( type: esriFieldTypeSmallInteger, alias: Construction Start Year )

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

  Iteminfo   Thumbnail   Metadata