Name: Project Point

Display Field: ContractNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Point Projects for ProTrack+.These points are selected from the Project Initiation points and are associated with Solicitation Number and/or Contract Number

Copyright Text: DDOT

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 101000

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: 390311.4800999984
YMin: 128404.61169999838
XMax: 407431.4849999994
YMax: 147032.46049999818
Spatial Reference: 26985  (26985)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ProjectStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Pending Award
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Pending NTP
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Under Construction
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Under Design
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Under Planning
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Under Study
  Description: N/A
  Symbol:
  
• Value: 9
  Label: Substantially Complete
  Description: N/A
  Symbol:
  
• Value: 10
  Label: Completed
  Description: N/A
  Symbol:
  
Transparency: 0
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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• ContractTypeID ( type: esriFieldTypeSmallInteger, alias: ContractTypeID , Coded Values: [1: A&E] , [2: IDIQ] , [3: Other] )
• WardAtCreation ( type: esriFieldTypeString, alias: WardAtCreation, length: 5 )
• ANCAtCreation ( type: esriFieldTypeString, alias: ANCAtCreation, length: 50 )
• SMDAtCreation ( type: esriFieldTypeString, alias: SMDAtCreation, length: 50 )
• ObjectID ( type: esriFieldTypeOID, alias: OBJECTID )
• PIUniqueID ( type: esriFieldTypeInteger, alias: PIUniqueID )
• PIGlobalID ( type: esriFieldTypeGUID, alias: PIGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• PIID ( type: esriFieldTypeInteger, alias: PIID )
• PIIDBI ( type: esriFieldTypeString, alias: PIIDBI, length: 25 )
• SolicitationNumber ( type: esriFieldTypeString, alias: SolicitationNumber, length: 50 )
• TaskOrderNumber ( type: esriFieldTypeString, alias: TaskOrderNumber, length: 50 )
• ContractNumber ( type: esriFieldTypeString, alias: ContractNumber, length: 30 )
• WorkType ( type: esriFieldTypeString, alias: WorkType, length: 15 , Coded Values: [COO-MA-ADAHIGH: ADA High Impact] , [COO-MA-ADALOW: ADA Low Impact] , [COO-MA-ADAMED: ADA Medium Impact] , ...138 more... )
• ProjectName ( type: esriFieldTypeString, alias: ProjectName, length: 150 )
• ProjectPhase ( type: esriFieldTypeString, alias: ProjectPhase, length: 20 , Coded Values: [CE: CE] , [CON: Construction] , [DESIGN: Design] , ...2 more... )
• ProjectStatus ( type: esriFieldTypeSmallInteger, alias: ProjectStatus , Coded Values: [1: Pending Award] , [2: Pending NTP] , [3: Under Construction] , ...5 more... )
• EstimatedStartDate ( type: esriFieldTypeDate, alias: EstimatedStartDate, length: 8 )
• EstimatedCompletionDate ( type: esriFieldTypeDate, alias: EstimatedCompletionDate, length: 8 )
• ActualStartDate ( type: esriFieldTypeDate, alias: ActualStartDate, length: 8 )
• ActualCompletionDate ( type: esriFieldTypeDate, alias: ActualCompletionDate, length: 8 )
• PercentCompleted ( type: esriFieldTypeSmallInteger, alias: PercentCompleted , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• RequestType ( type: esriFieldTypeSmallInteger, alias: RequestType , Coded Values: [1: Solicitation Request] , [2: A&E Task Order Request] , [3: IDIQ Task Order Request] )
• ContactEmail ( type: esriFieldTypeString, alias: ContactEmail, length: 50 )
• Description ( type: esriFieldTypeString, alias: Description, length: 2500 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• RouteName ( type: esriFieldTypeString, alias: RouteName, length: 50 )
• RouteID ( type: esriFieldTypeString, alias: RouteID, length: 50 )
• Measure ( type: esriFieldTypeDouble, alias: Measure )
• IntersectionName ( type: esriFieldTypeString, alias: IntersectionName, length: 100 )
• IntersectionID ( type: esriFieldTypeInteger, alias: IntersectionID )
• NewIntersectionID ( type: esriFieldTypeString, alias: NewIntersectionID, length: 100 )
• BudgetYear ( type: esriFieldTypeSmallInteger, alias: BudgetYear , Coded Values: [2010: 2010] , [2011: 2011] , [2012: 2012] , ...23 more... )
• FunctionalClass ( type: esriFieldTypeSmallInteger, alias: FunctionalClass , Coded Values: [11: Interstate] , [12: Other Freeway and Expressway] , [14: Primary Arterial] , ...3 more... )
• EstimatedCost ( type: esriFieldTypeDouble, alias: EstimatedCost )
• ActualCost ( type: esriFieldTypeDouble, alias: ActualCost )
• Ward ( type: esriFieldTypeString, alias: Ward, length: 5 )
• IsNHS ( type: esriFieldTypeSmallInteger, alias: IsNHS , Coded Values: [0: False] , [1: True] )
• ProjectIdentifier ( type: esriFieldTypeString, alias: ProjectIdentifier, length: 50 , Coded Values: [ALLEY_RESTORATION_PLAN_2020: Alley Restoration Plan 2020] , [ALLEY_RESTORATION_PLAN_2021: Alley Restoration Plan 2021] , [ALLEY_RESTORATION_PLAN_2022: Alley Restoration Plan 2022] , ...97 more... )
• CreatedByID ( type: esriFieldTypeGUID, alias: CreatedByID, length: 38 )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, length: 50 )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, length: 8 )
• LastUpdatedByID ( type: esriFieldTypeGUID, alias: LastUpdatedByID, length: 38 )
• LastUpdatedBy ( type: esriFieldTypeString, alias: LastUpdatedBy, length: 50 )
• LastUpdatedDate ( type: esriFieldTypeDate, alias: LastUpdatedDate, length: 8 )
• IsDeleted ( type: esriFieldTypeSmallInteger, alias: IsDeleted , Coded Values: [0: False] , [1: True] )
• IsPublishedToPublic ( type: esriFieldTypeSmallInteger, alias: IsPublishedToPublic , Coded Values: [0: False] , [1: True] )
• SMD ( type: esriFieldTypeString, alias: SMD, length: 50 )
• ANC ( type: esriFieldTypeString, alias: ANC, length: 50 )
• TaskOrderRequestNumber ( type: esriFieldTypeString, alias: TaskOrderRequestNumber, length: 50 )
• DTAPLastUpdatedByID ( type: esriFieldTypeGUID, alias: DTAPLastUpdatedByID, length: 38 )
• DTAPLastUpdatedBy ( type: esriFieldTypeString, alias: DTAPLastUpdatedBy, length: 50 )
• DTAPLastUpdatedDate ( type: esriFieldTypeDate, alias: DTAPLastUpdatedDate, length: 8 )
• DTAPCreatedByID ( type: esriFieldTypeGUID, alias: DTAPCreatedByID, length: 38 )
• DTAPCreatedBy ( type: esriFieldTypeString, alias: DTAPCreatedBy, length: 50 )
• DTAPCreatedDate ( type: esriFieldTypeDate, alias: DTAPCreatedDate, length: 8 )
• BusinessEntityID ( type: esriFieldTypeInteger, alias: BusinessEntityID )
• ChangeOrderNumber ( type: esriFieldTypeSmallInteger, alias: ChangeOrderNumber )
• Label ( type: esriFieldTypeString, alias: Label, length: 100 )
• CWComments ( type: esriFieldTypeString, alias: CWComments, length: 255 )
• SolicitationRequestID ( type: esriFieldTypeInteger, alias: SolicitationRequestID )
• TaskOrderRequestID ( type: esriFieldTypeInteger, alias: TaskOrderRequestID )
• RequestIDBI ( type: esriFieldTypeString, alias: RequestIDBI, length: 25 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• PTPPoint to PTPPointCityworks (1) -- Related To: Project Point Cityworks (20)
• PTPPoint to PTPPointAlert (2) -- Related To: Project Point Alert (23)
• PTPPoint to PTPPointWorkType (3) -- Related To: Project Point Work Type (15)

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

  Iteminfo   Thumbnail   Metadata