Name: WS88_Contractor_Work_Summary_Pipes

Display Field: city_project_number

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 5f5fa911e4ff4ccdbd7c5dd876299a59

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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: false
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• date_of_work_completion ( modelName: date_of_work_completion, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date_of_Work_Completion, type: esriFieldTypeDate )
• work_summary_form_submittal_num ( modelName: work_summary_form_submittal_num, nullable: true, editable: true, defaultValue: null, alias: Work_Summary_Form_Submittal_Number, type: esriFieldTypeInteger )
• city_project_number ( modelName: city_project_number, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: City_Project_Number, type: esriFieldTypeString )
• upstream_swdrainpipe_asset_id ( modelName: upstream_swdrainpipe_asset_id, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Upstream_swDrainPipe_Asset_ID, type: esriFieldTypeString )
• watershed_id ( modelName: watershed_id, nullable: true, editable: true, defaultValue: null, alias: Watershed_ID, type: esriFieldTypeInteger )
• nearest_address ( modelName: nearest_address, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Nearest_Address, type: esriFieldTypeString )
• pipe_diameter ( modelName: pipe_diameter, nullable: true, editable: true, defaultValue: null, alias: Pipe_Diameter, type: esriFieldTypeInteger )
• length_of_cleaning ( modelName: length_of_cleaning, nullable: true, editable: true, defaultValue: null, alias: Length_of_Cleaning, type: esriFieldTypeDouble )
• heavy_cleaning ( modelName: heavy_cleaning, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Heavy_Cleaning, type: esriFieldTypeString )
• light_cleaning ( modelName: light_cleaning, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Light_Cleaning, type: esriFieldTypeString )
• survey_length ( modelName: survey_length, nullable: true, editable: true, defaultValue: null, alias: Survey_Length, type: esriFieldTypeDouble )
• cctv_for_connectivity ( modelName: cctv_for_connectivity, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CCTV_for_Connectivity, type: esriFieldTypeString )
• post_cleaning_cctv__x_if_applic ( modelName: post_cleaning_cctv__x_if_applic, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Post_Cleaning_CCTV (X_if_applicable), type: esriFieldTypeString )
• partial_cctv ( modelName: partial_cctv, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Partial_CCTV, type: esriFieldTypeString )
• structural_rehab_needed ( modelName: structural_rehab_needed, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Structural_Rehab_Needed, type: esriFieldTypeString )
• structural_rating_ ( modelName: structural_rating_, nullable: true, editable: true, defaultValue: null, alias: Structural_Rating_, type: esriFieldTypeInteger )
• maintenance_rating_ ( modelName: maintenance_rating_, nullable: true, editable: true, defaultValue: null, alias: Maintenance_Rating_, type: esriFieldTypeInteger )
• accessibility_rating_ ( modelName: accessibility_rating_, nullable: true, editable: true, defaultValue: null, alias: Accessibility_Rating_, type: esriFieldTypeInteger )
• contractor_comments ( modelName: contractor_comments, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Contractor_Comments, type: esriFieldTypeString )
• field20 ( modelName: field20, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Field20, type: esriFieldTypeString )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: editdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: null, length: 255, alias: Editor, type: esriFieldTypeString )

Templates:

• Name: WS88_Contractor_Work_Summary_Pipes
  Description:
  Prototype:
  contractor_comments: null
  survey_length: null
  partial_cctv: null
  upstream_swdrainpipe_asset_id: null
  watershed_id: null
  maintenance_rating_: null
  work_summary_form_submittal_num: null
  pipe_diameter: null
  cctv_for_connectivity: null
  heavy_cleaning: null
  structural_rating_: null
  date_of_work_completion: null
  city_project_number: null
  structural_rehab_needed: null
  post_cleaning_cctv__x_if_applic: null
  field20: null
  light_cleaning: null
  accessibility_rating_: null
  nearest_address: null
  length_of_cleaning: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata