Name: Water CIP Table

Display Field: Project_Name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 05b8db5751804915b405795587b57857

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
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: true
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: null

Fields:

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata