Name: TB_Projects

Display Field: ProjectName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: TB_Projects
  Description:
  Prototype:
  FinalQuantityCY: null
  DMPANames: null
  ProjectID: null
  GlobalID: null
  ProjectName: null
  ProjectType: null
  FY_AnchorDate: null
  IssueSolicitationDate: null
  ProjectStatus: null
  Owner: null
  Notes: null
  ProjectSubtype: null
  FiscalYear: null
  FileNumber: null
  PONumber: null
  ContractName: null
  ProjectReach: null
  ProjectAOIStation: null
  DredgeName: null
  DredgeType: null
  CTRequiredDepthFT: null
  BidOpeningDate: null
  AwardDate: null
  RequiredCompletionDate: null
  ActualCompletionDate: null
  SolicitationNumber: null
  ContractNumber: null
  Contractor: null
  ActiveConstruction: null
  PlacementAreaName: null
  FacilityName: null
  LocationDescription: null
  DataSource: null
  Comments: null
  PrimaryDocURL: null
  SourceJobID: null
  SourceSystem: null
  StartDate: null
  EstimatedQuantityCY: null
  CTAwardAmountUSD: null
  CTFinalAmountUSD: null
  ContractQuantityCY: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata