Name: TB_Projects

Display Field: ProjectName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ProjectID ( type: esriFieldTypeInteger, alias: Project ID )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• ProjectType ( type: esriFieldTypeString, alias: Project Type, length: 50 , Coded Values: [Dredging: Dredging] , [PlacementArea: PlacementArea] , [Other: Other] )
• FY_AnchorDate ( type: esriFieldTypeDate, alias: FY_AnchorDate, length: 8 )
• IssueSolicitationDate ( type: esriFieldTypeDate, alias: IssueSolicitationDate, length: 8 )
• ProjectStatus ( type: esriFieldTypeString, alias: Project Status, length: 25 , Coded Values: [Advertised: Advertised] , [Awarded: Awarded] , [In Progress: In Progress] , ...3 more... )
• Owner ( type: esriFieldTypeString, alias: Project Owner, length: 50 , Coded Values: [USACE: USACE] , [PHA: PHA] , [OTHER: OTHER] )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• ProjectSubtype ( type: esriFieldTypeString, alias: ProjectSubtype, length: 255 , Coded Values: [Dredging: Dredging] , [PlacementArea: PlacementArea] , [Other: Other] )
• FiscalYear ( type: esriFieldTypeSmallInteger, alias: FiscalYear )
• FileNumber ( type: esriFieldTypeString, alias: FileNumber, length: 255 )
• PONumber ( type: esriFieldTypeString, alias: PONumber, length: 255 )
• ContractName ( type: esriFieldTypeString, alias: ContractName, length: 255 )
• ProjectReach ( type: esriFieldTypeString, alias: ProjectReach, length: 255 )
• ProjectAOIStation ( type: esriFieldTypeString, alias: ProjectAOIStation, length: 255 )
• DredgeName ( type: esriFieldTypeString, alias: DredgeName, length: 255 )
• DredgeType ( type: esriFieldTypeString, alias: DredgeType, length: 255 , Coded Values: [CSD: CSD] , [TSHD: TSHD] , [Mechanical: Mechanical] )
• CTRequiredDepthFT ( type: esriFieldTypeDouble, alias: CTRequiredDepthFT )
• BidOpeningDate ( type: esriFieldTypeDate, alias: BidOpeningDate, length: 8 )
• AwardDate ( type: esriFieldTypeDate, alias: AwardDate, length: 8 )
• RequiredCompletionDate ( type: esriFieldTypeDate, alias: RequiredCompletionDate, length: 8 )
• ActualCompletionDate ( type: esriFieldTypeDate, alias: ActualCompletionDate, length: 8 )
• SolicitationNumber ( type: esriFieldTypeString, alias: SolicitationNumber, length: 64 )
• ContractNumber ( type: esriFieldTypeString, alias: ContractNumber, length: 64 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 128 )
• ActiveConstruction ( type: esriFieldTypeString, alias: ActiveConstruction, length: 255 )
• PlacementAreaName ( type: esriFieldTypeString, alias: PlacementAreaName, length: 128 )
• FacilityName ( type: esriFieldTypeString, alias: FacilityName, length: 128 )
• LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, length: 255 )
• DataSource ( type: esriFieldTypeString, alias: DataSource, length: 255 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 2000 )
• PrimaryDocURL ( type: esriFieldTypeString, alias: PrimaryDocURL, length: 1024 )
• SourceJobID ( type: esriFieldTypeString, alias: SourceJobID, length: 64 )
• SourceSystem ( type: esriFieldTypeString, alias: SourceSystem, length: 64 )
• StartDate ( type: esriFieldTypeDate, alias: StartDate, length: 8 )
• EstimatedQuantityCY ( type: esriFieldTypeDouble, alias: EstimatedQuantityCY )
• CTAwardAmountUSD ( type: esriFieldTypeDouble, alias: CTAwardAmountUSD )
• CTFinalAmountUSD ( type: esriFieldTypeDouble, alias: CTFinalAmountUSD )
• ContractQuantityCY ( type: esriFieldTypeDouble, alias: ContractQuantityCY )
• FinalQuantityCY ( type: esriFieldTypeDouble, alias: FinalQuantityCY )
• 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 )
• DMPANames ( type: esriFieldTypeString, alias: DMPANames, length: 255 , Coded Values: [Alexander_Island_PA: Alexander Island PA] , [Bolivar: Bolivar Marsh] , [Atikinson_M12: Atikinson M12] , ...24 more... )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata