View In:   ArcGIS Online Map Viewer

Name: Project Polygon

Display Field: ContractNumber

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Polygon Projects for ProTrack+.These polygons are selected from the Project Initiation polygons 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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 390268.23650000244
YMin: 127916.30070000142
XMax: 407719.9765999988
YMax: 146935.34279999882
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:
  Style: esriSFSSolid
  Color: [33, 150, 243, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 77, 168, 255]
  Width: 1
• Value: 2
  Label: Pending NTP
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [168, 0, 0, 255]
  Width: 1
• Value: 3
  Label: Under Construction
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [245, 124, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [230, 76, 0, 255]
  Width: 1
• Value: 4
  Label: Under Design
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 183, 77, 255]
  Outline:
  Style: esriSLSSolid
  Color: [230, 152, 0, 255]
  Width: 1
• Value: 5
  Label: Under Planning
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 152, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [168, 112, 0, 255]
  Width: 1
• Value: 6
  Label: Under Study
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 224, 178, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 1
• Value: 9
  Label: Substantially Complete
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [76, 204, 80, 255]
  Outline:
  Style: esriSLSSolid
  Color: [85, 255, 0, 255]
  Width: 1
• Value: 10
  Label: Completed
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 175, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 1
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: true
Supports Returning Geometry Centroid: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ProjectStatus

Fields:

• ObjectID ( type: esriFieldTypeOID, alias: ObjectID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PIGlobalID ( type: esriFieldTypeGUID, alias: PIGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PIGlobalID )
• PIID ( type: esriFieldTypeInteger, alias: PIID, editable: true, nullable: true, defaultValue: null, modelName: PIID )
• PIIDBI ( type: esriFieldTypeString, alias: PIIDBI, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ProjectInitiationID )
• SolicitationNumber ( type: esriFieldTypeString, alias: SolicitationNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SolicitationNumber )
• ContractNumber ( type: esriFieldTypeString, alias: ContractNumber, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ContractNumber )
• TaskOrderRequestNumber ( type: esriFieldTypeString, alias: TaskOrderRequestNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TaskOrderRequestNumber )
• TaskOrderNumber ( type: esriFieldTypeString, alias: TaskOrderNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TaskOrderNumber )
• WorkType ( type: esriFieldTypeString, alias: WorkType, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WorkType , 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, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ProjectName )
• Label ( type: esriFieldTypeString, alias: Label, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Label )
• ProjectIdentifier ( type: esriFieldTypeString, alias: ProjectIdentifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectIdentifier , 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... )
• ProjectStatus ( type: esriFieldTypeSmallInteger, alias: ProjectStatus, editable: true, nullable: true, defaultValue: null, modelName: ProjectStatus , Coded Values: [1: Pending Award] , [2: Pending NTP] , [3: Under Construction] , ...5 more... )
• PercentCompleted ( type: esriFieldTypeSmallInteger, alias: PercentCompleted, editable: true, nullable: true, defaultValue: 0, modelName: PercentCompleted , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• EstimatedStartDate ( type: esriFieldTypeDate, alias: EstimatedStartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EstimatedStartDate )
• EstimatedCompletionDate ( type: esriFieldTypeDate, alias: EstimatedCompletionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EstimatedCompletionDate )
• ActualStartDate ( type: esriFieldTypeDate, alias: ActualStartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ActualStartDate )
• ActualCompletionDate ( type: esriFieldTypeDate, alias: ActualCompletionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ActualCompletionDate )
• RequestType ( type: esriFieldTypeSmallInteger, alias: RequestType, editable: true, nullable: true, defaultValue: null, modelName: RequestType , Coded Values: [1: Solicitation Request] , [2: A&E Task Order Request] , [3: IDIQ Task Order Request] )
• ChangeOrderNumber ( type: esriFieldTypeSmallInteger, alias: ChangeOrderNumber, editable: true, nullable: true, defaultValue: null, modelName: ChangeOrderNumber )
• BudgetYear ( type: esriFieldTypeSmallInteger, alias: BudgetYear, editable: true, nullable: true, defaultValue: null, modelName: BudgetYear , Coded Values: [2010: 2010] , [2011: 2011] , [2012: 2012] , ...23 more... )
• EstimatedCost ( type: esriFieldTypeDouble, alias: EstimatedCost, editable: true, nullable: true, defaultValue: null, modelName: EstimatedCost )
• ActualCost ( type: esriFieldTypeDouble, alias: ActualCost, editable: true, nullable: true, defaultValue: null, modelName: ActualCost )
• Ward ( type: esriFieldTypeString, alias: Ward, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Ward )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• LastUpdatedDate ( type: esriFieldTypeDate, alias: LastUpdatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastUpdatedDate )
• SMD ( type: esriFieldTypeString, alias: SMD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SMD )
• ANC ( type: esriFieldTypeString, alias: ANC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ANC )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: Description )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• DTAPLastUpdatedDate ( type: esriFieldTypeDate, alias: DTAPLastUpdatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DTAPLastUpdatedDate )
• DTAPCreatedDate ( type: esriFieldTypeDate, alias: DTAPCreatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DTAPCreatedDate )
• ContractTypeID ( type: esriFieldTypeSmallInteger, alias: ContractTypeID, editable: true, nullable: true, defaultValue: null, modelName: ContractTypeID , Coded Values: [1: A&E] , [2: IDIQ] , [3: Other] )
• SolicitationRequestID ( type: esriFieldTypeInteger, alias: SolicitationRequestID, editable: true, nullable: true, defaultValue: null, modelName: SolicitationRequestID )
• TaskOrderRequestID ( type: esriFieldTypeInteger, alias: TaskOrderRequestID, editable: true, nullable: true, defaultValue: null, modelName: TaskOrderRequestID )
• RequestIDBI ( type: esriFieldTypeString, alias: RequestIDBI, editable: true, nullable: true, length: 25, defaultValue: null, modelName: RequestIDBI )

Types:

ID: 1
Name: Pending Award
Domains:
• WorkType:
  Inherited
• ProjectIdentifier:
  Inherited
• ProjectStatus:
  Inherited
• PercentCompleted:
  Inherited
• RequestType:
  Inherited
• BudgetYear:
  Inherited
• ContractTypeID:
  Inherited
• ProjectPhase:
  Inherited
• IsDeleted:
  Inherited
• IsPublishedToPublic:
  Inherited
Templates:
• Name: Proposed
  Description:
  Prototype:
  ProjectIdentifier: null
  ProjectStatus: 1
  TaskOrderRequestID: null
  RequestIDBI: null
  PIGlobalID: null
  PIID: null
  PIIDBI: null
  SolicitationNumber: null
  ContractNumber: null
  TaskOrderRequestNumber: null
  TaskOrderNumber: null
  WorkType: null
  ProjectName: null
  Label: null
  PercentCompleted: 0
  EstimatedStartDate: null
  EstimatedCompletionDate: null
  ActualStartDate: null
  ActualCompletionDate: null
  RequestType: null
  ChangeOrderNumber: null
  BudgetYear: null
  EstimatedCost: null
  ActualCost: null
  Ward: null
  CreatedDate: null
  LastUpdatedDate: null
  SMD: null
  ANC: null
  Description: null
  Comments: null
  DTAPLastUpdatedDate: null
  DTAPCreatedDate: null
  ContractTypeID: null
  SolicitationRequestID: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 2
Name: Pending NTP
Domains:
• WorkType:
  Inherited
• ProjectIdentifier:
  Inherited
• ProjectStatus:
  Inherited
• PercentCompleted:
  Inherited
• RequestType:
  Inherited
• BudgetYear:
  Inherited
• ContractTypeID:
  Inherited
• ProjectPhase:
  Inherited
• IsDeleted:
  Inherited
• IsPublishedToPublic:
  Inherited
Templates:
• Name: Budgeted
  Description:
  Prototype:
  ProjectIdentifier: null
  ProjectStatus: 2
  TaskOrderRequestID: null
  RequestIDBI: null
  PIGlobalID: null
  PIID: null
  PIIDBI: null
  SolicitationNumber: null
  ContractNumber: null
  TaskOrderRequestNumber: null
  TaskOrderNumber: null
  WorkType: null
  ProjectName: null
  Label: null
  PercentCompleted: 0
  EstimatedStartDate: null
  EstimatedCompletionDate: null
  ActualStartDate: null
  ActualCompletionDate: null
  RequestType: null
  ChangeOrderNumber: null
  BudgetYear: null
  EstimatedCost: null
  ActualCost: null
  Ward: null
  CreatedDate: null
  LastUpdatedDate: null
  SMD: null
  ANC: null
  Description: null
  Comments: null
  DTAPLastUpdatedDate: null
  DTAPCreatedDate: null
  ContractTypeID: null
  SolicitationRequestID: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 3
Name: Under Construction
Domains:
• WorkType:
  Inherited
• ProjectIdentifier:
  Inherited
• ProjectStatus:
  Inherited
• PercentCompleted:
  Inherited
• RequestType:
  Inherited
• BudgetYear:
  Inherited
• ContractTypeID:
  Inherited
• ProjectPhase:
  Inherited
• IsDeleted:
  Inherited
• IsPublishedToPublic:
  Inherited
Templates:
• Name: Under Construction
  Description:
  Prototype:
  ProjectIdentifier: null
  ProjectStatus: 3
  TaskOrderRequestID: null
  RequestIDBI: null
  PIGlobalID: null
  PIID: null
  PIIDBI: null
  SolicitationNumber: null
  ContractNumber: null
  TaskOrderRequestNumber: null
  TaskOrderNumber: null
  WorkType: null
  ProjectName: null
  Label: null
  PercentCompleted: 0
  EstimatedStartDate: null
  EstimatedCompletionDate: null
  ActualStartDate: null
  ActualCompletionDate: null
  RequestType: null
  ChangeOrderNumber: null
  BudgetYear: null
  EstimatedCost: null
  ActualCost: null
  Ward: null
  CreatedDate: null
  LastUpdatedDate: null
  SMD: null
  ANC: null
  Description: null
  Comments: null
  DTAPLastUpdatedDate: null
  DTAPCreatedDate: null
  ContractTypeID: null
  SolicitationRequestID: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 4
Name: Under Design
Domains:
• WorkType:
  Inherited
• ProjectIdentifier:
  Inherited
• ProjectStatus:
  Inherited
• PercentCompleted:
  Inherited
• RequestType:
  Inherited
• BudgetYear:
  Inherited
• ContractTypeID:
  Inherited
• ProjectPhase:
  Inherited
• IsDeleted:
  Inherited
• IsPublishedToPublic:
  Inherited
Templates:
• Name: Completed
  Description:
  Prototype:
  ProjectIdentifier: null
  ProjectStatus: 4
  TaskOrderRequestID: null
  RequestIDBI: null
  PIGlobalID: null
  PIID: null
  PIIDBI: null
  SolicitationNumber: null
  ContractNumber: null
  TaskOrderRequestNumber: null
  TaskOrderNumber: null
  WorkType: null
  ProjectName: null
  Label: null
  PercentCompleted: 0
  EstimatedStartDate: null
  EstimatedCompletionDate: null
  ActualStartDate: null
  ActualCompletionDate: null
  RequestType: null
  ChangeOrderNumber: null
  BudgetYear: null
  EstimatedCost: null
  ActualCost: null
  Ward: null
  CreatedDate: null
  LastUpdatedDate: null
  SMD: null
  ANC: null
  Description: null
  Comments: null
  DTAPLastUpdatedDate: null
  DTAPCreatedDate: null
  ContractTypeID: null
  SolicitationRequestID: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 5
Name: Under Planning
Domains:
• WorkType:
  Inherited
• ProjectIdentifier:
  Inherited
• ProjectStatus:
  Inherited
• PercentCompleted:
  Inherited
• RequestType:
  Inherited
• BudgetYear:
  Inherited
• ContractTypeID:
  Inherited
• ProjectPhase:
  Inherited
• IsDeleted:
  Inherited
• IsPublishedToPublic:
  Inherited
Templates:
• Name: Dropped
  Description:
  Prototype:
  ProjectIdentifier: null
  ProjectStatus: 5
  TaskOrderRequestID: null
  RequestIDBI: null
  PIGlobalID: null
  PIID: null
  PIIDBI: null
  SolicitationNumber: null
  ContractNumber: null
  TaskOrderRequestNumber: null
  TaskOrderNumber: null
  WorkType: null
  ProjectName: null
  Label: null
  PercentCompleted: 0
  EstimatedStartDate: null
  EstimatedCompletionDate: null
  ActualStartDate: null
  ActualCompletionDate: null
  RequestType: null
  ChangeOrderNumber: null
  BudgetYear: null
  EstimatedCost: null
  ActualCost: null
  Ward: null
  CreatedDate: null
  LastUpdatedDate: null
  SMD: null
  ANC: null
  Description: null
  Comments: null
  DTAPLastUpdatedDate: null
  DTAPCreatedDate: null
  ContractTypeID: null
  SolicitationRequestID: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 6
Name: Under Study
Domains:
• WorkType:
  Inherited
• ProjectIdentifier:
  Inherited
• ProjectStatus:
  Inherited
• PercentCompleted:
  Inherited
• RequestType:
  Inherited
• BudgetYear:
  Inherited
• ContractTypeID:
  Inherited
• ProjectPhase:
  Inherited
• IsDeleted:
  Inherited
• IsPublishedToPublic:
  Inherited
Templates:
• Name: 6
  Description:
  Prototype:
  TaskOrderRequestID: null
  SolicitationRequestID: null
  RequestIDBI: null
  PIGlobalID: null
  PIID: null
  PIIDBI: null
  SolicitationNumber: null
  ContractNumber: null
  TaskOrderRequestNumber: null
  TaskOrderNumber: null
  WorkType: null
  ProjectName: null
  Label: null
  ProjectIdentifier: null
  ProjectStatus: 6
  PercentCompleted: 0
  EstimatedStartDate: null
  EstimatedCompletionDate: null
  ActualStartDate: null
  ActualCompletionDate: null
  RequestType: null
  ChangeOrderNumber: null
  BudgetYear: null
  EstimatedCost: null
  ActualCost: null
  Ward: null
  CreatedDate: null
  LastUpdatedDate: null
  SMD: null
  ANC: null
  Description: null
  Comments: null
  DTAPLastUpdatedDate: null
  DTAPCreatedDate: null
  ContractTypeID: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 9
Name: Substantially Complete
Domains:
• WorkType:
  Inherited
• ProjectIdentifier:
  Inherited
• ProjectStatus:
  Inherited
• PercentCompleted:
  Inherited
• RequestType:
  Inherited
• BudgetYear:
  Inherited
• ContractTypeID:
  Inherited
• ProjectPhase:
  Inherited
• IsDeleted:
  Inherited
• IsPublishedToPublic:
  Inherited
Templates:
• Name: 9
  Description:
  Prototype:
  TaskOrderRequestID: null
  SolicitationRequestID: null
  RequestIDBI: null
  PIGlobalID: null
  PIID: null
  PIIDBI: null
  SolicitationNumber: null
  ContractNumber: null
  TaskOrderRequestNumber: null
  TaskOrderNumber: null
  WorkType: null
  ProjectName: null
  Label: null
  ProjectIdentifier: null
  ProjectStatus: 9
  PercentCompleted: 0
  EstimatedStartDate: null
  EstimatedCompletionDate: null
  ActualStartDate: null
  ActualCompletionDate: null
  RequestType: null
  ChangeOrderNumber: null
  BudgetYear: null
  EstimatedCost: null
  ActualCost: null
  Ward: null
  CreatedDate: null
  LastUpdatedDate: null
  SMD: null
  ANC: null
  Description: null
  Comments: null
  DTAPLastUpdatedDate: null
  DTAPCreatedDate: null
  ContractTypeID: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 10
Name: Completed
Domains:
• WorkType:
  Inherited
• ProjectIdentifier:
  Inherited
• ProjectStatus:
  Inherited
• PercentCompleted:
  Inherited
• RequestType:
  Inherited
• BudgetYear:
  Inherited
• ContractTypeID:
  Inherited
• ProjectPhase:
  Inherited
• IsDeleted:
  Inherited
• IsPublishedToPublic:
  Inherited
Templates:
• Name: 10
  Description:
  Prototype:
  TaskOrderRequestID: null
  SolicitationRequestID: null
  RequestIDBI: null
  PIGlobalID: null
  PIID: null
  PIIDBI: null
  SolicitationNumber: null
  ContractNumber: null
  TaskOrderRequestNumber: null
  TaskOrderNumber: null
  WorkType: null
  ProjectName: null
  Label: null
  ProjectIdentifier: null
  ProjectStatus: 10
  PercentCompleted: 0
  EstimatedStartDate: null
  EstimatedCompletionDate: null
  ActualStartDate: null
  ActualCompletionDate: null
  RequestType: null
  ChangeOrderNumber: null
  BudgetYear: null
  EstimatedCost: null
  ActualCost: null
  Ward: null
  CreatedDate: null
  LastUpdatedDate: null
  SMD: null
  ANC: null
  Description: null
  Comments: null
  DTAPLastUpdatedDate: null
  DTAPCreatedDate: null
  ContractTypeID: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Relationships:

• PTPPolygon to PTPPolygonCitywork (10) -- Related To: Project Polygon Cityworks (22)
• PTPPolygon to PTPPolygonAlert (11) -- Related To: Project Polygon Alert (19)
• PTPPolygon to PTPPolygonWorkType (12) -- Related To: Project Polygon WorkType (17)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata