Name: TIP_Projects

Display Field: ProjName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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:

• TIP_Year ( type: esriFieldTypeSmallInteger, alias: TIP_StartYear, editable: true, nullable: true, defaultValue: null, modelName: TIP_Year )
• ProjName ( type: esriFieldTypeString, alias: ProjectName, editable: true, nullable: false, length: 250, defaultValue: null, modelName: ProjName )
• ProjStatus ( type: esriFieldTypeString, alias: ProjectStatus, editable: true, nullable: false, length: 50, defaultValue: null, modelName: ProjStatus , Coded Values: [Advertised: Advertised] , [Cancelled: Cancelled] , [Construction - Active: Construction - Active] , ...13 more... )
• ProjDescription ( type: esriFieldTypeString, alias: ProjectDescription, editable: true, nullable: true, length: 350, defaultValue: null, modelName: ProjDescription )
• ProjProgram ( type: esriFieldTypeString, alias: ProjectProgram, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ProjProgram , Coded Values: [Major Capital Projects: Major Capital Projects] , [Minor Capital Projects: Minor Capital Projects] , [Bridge: Bridge] , ...11 more... )
• RulesEngine ( type: esriFieldTypeString, alias: RulesEngine, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: RulesEngine , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unk] )
• PTS_ID ( type: esriFieldTypeString, alias: PTS_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PTS_ID )
• ReponsibleAgency ( type: esriFieldTypeString, alias: ReponsibleAgency, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ReponsibleAgency )
• BID_Type ( type: esriFieldTypeString, alias: BID_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BID_Type )
• ADV_Date ( type: esriFieldTypeDate, alias: ADV_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ADV_Date )
• NTP_Date ( type: esriFieldTypeDate, alias: NTP_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NTP_Date )
• COMP_Date ( type: esriFieldTypeDate, alias: COMP_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COMP_Date )
• DesignCost ( type: esriFieldTypeDouble, alias: DesignCost, editable: true, nullable: true, defaultValue: null, modelName: DesignCost )
• ConstructionCost ( type: esriFieldTypeDouble, alias: ConstructionCost, editable: true, nullable: true, defaultValue: null, modelName: ConstructionCost )
• OtherCost ( type: esriFieldTypeDouble, alias: OtherCost, editable: true, nullable: true, defaultValue: null, modelName: OtherCost )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 350, defaultValue: null, modelName: Notes )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• TIP_ID ( type: esriFieldTypeInteger, alias: TIP_ID, editable: true, nullable: false, defaultValue: null, modelName: TIP_ID )
• 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 )
• ProjStartDate ( type: esriFieldTypeDate, alias: ProjStartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ProjStartDate )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Investment_Type ( type: esriFieldTypeString, alias: Investment_Type, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Investment_Type , Coded Values: [Bicycle Enhancement: Bicycle Enhancement] , [Pedestrian Enhancement: Pedestrian Enhancement] , [Debt Service: Debt Service] , ...7 more... )

Templates:

• Name: TIP_Projects
  Description:
  Prototype:
  ProjStartDate: null
  TIP_Year: null
  ProjName:
  ProjStatus:
  ProjDescription: null
  ProjProgram: null
  RulesEngine: Yes
  PTS_ID: null
  ReponsibleAgency: null
  BID_Type: null
  ADV_Date: null
  NTP_Date: null
  COMP_Date: null
  DesignCost: null
  ConstructionCost: null
  OtherCost: null
  Notes: null
  Investment_Type: null
  TIP_ID: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• AssetPolys (0) -- Related To: Bridge Assets (0)
• TIP_Projects (2) -- Related To: Project Polygons (12)
• TIP_ActualProjectFunding (3) -- Related To: ActualProjectFunding (15)

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   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata