Name: sde.LUCITY_USER_COP_SEWERPIPECUSTOMVIEW

Display Field: PipeNumber

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7b951c8c7ded402f86277f4bcd45f30e

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 )
• PipeNumber ( type: esriFieldTypeString, alias: PipeNumber, editable: true, nullable: true, length: 61, defaultValue: null, modelName: PipeNumber )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Material )
• Length ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• PipeSize ( type: esriFieldTypeDouble, alias: PipeSize, editable: true, nullable: true, defaultValue: null, modelName: PipeSize )
• Slope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: Slope )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Owner )
• LastCCTVDate ( type: esriFieldTypeDate, alias: LastCCTVDate, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: LastCCTVDate )
• NextCCTVDue ( type: esriFieldTypeDate, alias: NextCCTVDue, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: NextCCTVDue )
• CCTVFrequency ( type: esriFieldTypeString, alias: CCTVFrequency, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CCTVFrequency )
• NT_USER32TY ( type: esriFieldTypeString, alias: NT_USER32TY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NT_USER32TY )
• LastCleanDate ( type: esriFieldTypeDate, alias: LastCleanDate, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: LastCleanDate )
• NextCleanDate ( type: esriFieldTypeDate, alias: NextCleanDate, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: NextCleanDate )
• CleanFrequency ( type: esriFieldTypeString, alias: CleanFrequency, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CleanFrequency )
• CleanStatus ( type: esriFieldTypeString, alias: CleanStatus, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CleanStatus )
• LastRootCut ( type: esriFieldTypeDate, alias: LastRootCut, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: LastRootCut )
• NextRootCut ( type: esriFieldTypeDate, alias: NextRootCut, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: NextRootCut )
• RootCutFreq ( type: esriFieldTypeString, alias: RootCutFreq, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RootCutFreq )
• RootCutStatus ( type: esriFieldTypeString, alias: RootCutStatus, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RootCutStatus )
• LastFoaming ( type: esriFieldTypeDate, alias: LastFoaming, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: LastFoaming )
• NextFoaming ( type: esriFieldTypeDate, alias: NextFoaming, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: NextFoaming )
• FoamFrequency ( type: esriFieldTypeString, alias: FoamFrequency, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FoamFrequency )
• FoamStatus ( type: esriFieldTypeString, alias: FoamStatus, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FoamStatus )

Templates:

• Name: sde.LUCITY_USER_COP_SEWERPIPECUSTOMVIEW
  Description:
  Prototype:
  FoamFrequency: null
  PipeNumber: null
  Material: null
  Length: null
  PipeSize: null
  Slope: null
  Owner: null
  LastCCTVDate: null
  NextCCTVDue: null
  CCTVFrequency: null
  NT_USER32TY: null
  LastCleanDate: null
  NextCleanDate: null
  CleanFrequency: null
  CleanStatus: null
  LastRootCut: null
  NextRootCut: null
  RootCutFreq: null
  RootCutStatus: null
  LastFoaming: null
  NextFoaming: null
  FoamStatus: 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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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