Name: Water CIP Table

Display Field: Project_Name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4a0e46113ffe4b7eb8cf8c54499c48cf

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CIPID ( type: esriFieldTypeString, alias: CIPID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CIPID )
• Project_Name ( type: esriFieldTypeString, alias: Project_Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project_Name )
• Segment_ID ( type: esriFieldTypeInteger, alias: Segment_ID, editable: true, nullable: true, defaultValue: null, modelName: Segment_ID )
• GIS_FacilityIDs ( type: esriFieldTypeString, alias: GIS_FacilityIDs, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GIS_FacilityIDs )
• CIPID_Priority ( type: esriFieldTypeString, alias: CIPID_Priority, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CIPID_Priority )
• Year_Priority ( type: esriFieldTypeString, alias: Year_Priority, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Year_Priority )
• Proposed_Fyear ( type: esriFieldTypeInteger, alias: Proposed_Fyear, editable: true, nullable: true, defaultValue: null, modelName: Proposed_Fyear )
• Completion_Date ( type: esriFieldTypeString, alias: Completion_Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Completion_Date )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status )
• Priority_In_Year ( type: esriFieldTypeString, alias: Priority_In_Year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Priority_In_Year )
• Priority_In_Project ( type: esriFieldTypeString, alias: Priority_In_Project, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Priority_In_Project )
• Road_Name ( type: esriFieldTypeString, alias: Road_Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Road_Name )
• Project_Limits_1 ( type: esriFieldTypeString, alias: Project_Limits_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project_Limits_1 )
• Project_Limits_2 ( type: esriFieldTypeString, alias: Project_Limits_2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project_Limits_2 )
• Pipe_Age ( type: esriFieldTypeString, alias: Pipe_Age, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pipe_Age )
• Pipe_Material ( type: esriFieldTypeString, alias: Pipe_Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pipe_Material )
• Project_Length_ft ( type: esriFieldTypeInteger, alias: Project_Length_ft, editable: true, nullable: true, defaultValue: null, modelName: Project_Length_ft )
• Improvement_Type ( type: esriFieldTypeString, alias: Improvement_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Improvement_Type )
• Major_Minor ( type: esriFieldTypeString, alias: Major_Minor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Major_Minor )
• Construction__Crew ( type: esriFieldTypeString, alias: Construction__Crew, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Construction__Crew )
• Existing ( type: esriFieldTypeInteger, alias: Existing, editable: true, nullable: true, defaultValue: null, modelName: Existing )
• Future ( type: esriFieldTypeInteger, alias: Future, editable: true, nullable: true, defaultValue: null, modelName: Future )
• No_of_Hydrants ( type: esriFieldTypeInteger, alias: No_of_Hydrants, editable: true, nullable: true, defaultValue: null, modelName: No_of_Hydrants )
• No_of_ResidentServices ( type: esriFieldTypeInteger, alias: No_of_ResidentServices, editable: true, nullable: true, defaultValue: null, modelName: No_of_ResidentServices )
• No_of_Large_Services ( type: esriFieldTypeInteger, alias: No_of_Large_Services, editable: true, nullable: true, defaultValue: null, modelName: No_of_Large_Services )
• No_of_Tie_ins ( type: esriFieldTypeInteger, alias: No_of_Tie_ins, editable: true, nullable: true, defaultValue: null, modelName: No_of_Tie_ins )
• Work_Description ( type: esriFieldTypeString, alias: Work_Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Work_Description )
• Project_Costs_Hydrants_Services ( type: esriFieldTypeInteger, alias: Project_Costs_Hydrants_Services_TieIns, editable: true, nullable: true, defaultValue: null, modelName: Project_Costs_Hydrants_Services_TieIns )
• Project_Costs_Water_Main ( type: esriFieldTypeInteger, alias: Project_Costs_Water_Main, editable: true, nullable: true, defaultValue: null, modelName: Project_Costs_Water_Main )
• Project_Costs_True_Water_Main_l ( type: esriFieldTypeDouble, alias: Project_Costs_True_Water_Main_length_modifier, editable: true, nullable: true, defaultValue: null, modelName: Project_Costs_True_Water_Main_length_modifier )
• Project_Extras_Permits_Traffic_ ( type: esriFieldTypeInteger, alias: Project_Extras_Permits_Traffic_Control_Other_Work, editable: true, nullable: true, defaultValue: null, modelName: Project_Extras_Permits_Traffic_Control_Other_Work )
• Total_Project_Cost ( type: esriFieldTypeInteger, alias: Total_Project_Cost, editable: true, nullable: true, defaultValue: null, modelName: Total_Project_Cost )
• Map_primary ( type: esriFieldTypeString, alias: Map_primary, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Map_primary )
• Map_secondary ( type: esriFieldTypeString, alias: Map_secondary, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Map_secondary )
• Map_tertiary ( type: esriFieldTypeString, alias: Map_tertiary, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Map_tertiary )
• Driving_Work1 ( type: esriFieldTypeString, alias: Driving_Work1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Driving_Work1 )
• Driving_Work2 ( type: esriFieldTypeString, alias: Driving_Work2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Driving_Work2 )
• Driving_Work3 ( type: esriFieldTypeString, alias: Driving_Work3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Driving_Work3 )
• Funding_Source ( type: esriFieldTypeString, alias: Funding_Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Funding_Source )
• Leak_Count ( type: esriFieldTypeInteger, alias: Leak_Count, editable: true, nullable: true, defaultValue: null, modelName: Leak_Count )
• Year_Done ( type: esriFieldTypeString, alias: Year_Done, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Year_Done )
• Scheduled_Paving_Year ( type: esriFieldTypeString, alias: Scheduled_Paving_Year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Scheduled_Paving_Year )
• Paving_Area ( type: esriFieldTypeString, alias: Paving_Area, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Paving_Area )
• Report ( type: esriFieldTypeString, alias: Report, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Report )
• GIS ( type: esriFieldTypeString, alias: GIS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GIS )
• Water_Priority ( type: esriFieldTypeInteger, alias: Water_Priority, editable: true, nullable: true, defaultValue: null, modelName: Water_Priority )
• MainCostAlt ( type: esriFieldTypeInteger, alias: MainCostAlt, editable: true, nullable: true, defaultValue: null, modelName: MainCostAlt )
• TotalCostAlt ( type: esriFieldTypeInteger, alias: TotalCostAlt, editable: true, nullable: true, defaultValue: null, modelName: TotalCostAlt )
• countCIPID ( type: esriFieldTypeInteger, alias: countCIPID, editable: true, nullable: true, defaultValue: null, modelName: countCIPID )
• COUNT_CIPIDSegment ( type: esriFieldTypeInteger, alias: COUNT_CIPIDSegment, editable: true, nullable: true, defaultValue: null, modelName: COUNT_CIPIDSegment )
• CIPID_Year_Priority ( type: esriFieldTypeString, alias: CIPID_Year_Priority, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CIPID_Year_Priority )
• Project_Description ( type: esriFieldTypeString, alias: Project_Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project_Description )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 261, defaultValue: null, modelName: Notes )
• WTR_Project ( type: esriFieldTypeString, alias: WTR_Project, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WTR_Project )
• Interagency_Map ( type: esriFieldTypeString, alias: Interagency_Map, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Interagency_Map )
• Water_CIP_Map ( type: esriFieldTypeString, alias: Water_CIP_Map, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Water_CIP_Map )
• 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 )
• CIPComponent ( type: esriFieldTypeString, alias: CIPComponent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CIPID_Segment_formula )

Templates:

• Name: Water CIP Table
  Description:
  Prototype:
  Water_CIP_Map: null
  CIPComponent: null
  CIPID: null
  Project_Name: null
  Segment_ID: null
  GIS_FacilityIDs: null
  CIPID_Priority: null
  Year_Priority: null
  Proposed_Fyear: null
  Completion_Date: null
  Status: null
  Priority_In_Year: null
  Priority_In_Project: null
  Road_Name: null
  Project_Limits_1: null
  Project_Limits_2: null
  Pipe_Age: null
  Pipe_Material: null
  Project_Length_ft: null
  Improvement_Type: null
  Major_Minor: null
  Construction__Crew: null
  Existing: null
  Future: null
  No_of_Hydrants: null
  No_of_ResidentServices: null
  No_of_Large_Services: null
  No_of_Tie_ins: null
  Work_Description: null
  Project_Costs_Hydrants_Services: null
  Project_Costs_Water_Main: null
  Project_Costs_True_Water_Main_l: null
  Project_Extras_Permits_Traffic_: null
  Total_Project_Cost: null
  Map_primary: null
  Map_secondary: null
  Map_tertiary: null
  Driving_Work1: null
  Driving_Work2: null
  Driving_Work3: null
  Funding_Source: null
  Leak_Count: null
  Year_Done: null
  Scheduled_Paving_Year: null
  Paving_Area: null
  Report: null
  GIS: null
  Water_Priority: null
  MainCostAlt: null
  TotalCostAlt: null
  countCIPID: null
  COUNT_CIPIDSegment: null
  CIPID_Year_Priority: null
  Project_Description: null
  Notes: null
  WTR_Project: null
  Interagency_Map: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• CIPProjectsLocations (1) -- Related To: CIP Project Locations (1)
• CIPProjects (5) -- Related To: CIP Project Outlines (10)

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

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

Child Resources:   Field Groups   Contingent Values

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