Name: MH Components

Display Field: CSHAPE

Type: Table

Geometry Type: N/A

Description:

Service Item Id: dc1ed560a3b1414f9e85ab83cbaa0863

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 )
• CSHAPE ( type: esriFieldTypeString, alias: Cover Shape, editable: true, nullable: true, length: 2, defaultValue: C, modelName: CSHAPE , Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more... )
• CMATERIAL ( type: esriFieldTypeString, alias: Cover Material, editable: true, nullable: true, length: 4, defaultValue: CAS, modelName: CMATERIAL , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CTYPE ( type: esriFieldTypeSmallInteger, alias: Cover Type, editable: true, nullable: true, defaultValue: null, modelName: CTYPE , Coded Values: [1: Solid] , [2: Vented/Slots] , [3: Gasketed] , ...4 more... )
• CFF ( type: esriFieldTypeString, alias: Cover / Frame Fit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CFF , Coded Values: [O: Oversized] , [G: Good] , [U: Undersized] , ...1 more... )
• MHARC ( type: esriFieldTypeSmallInteger, alias: MH Cover Adjustment Ring Condition, editable: true, nullable: true, defaultValue: null, modelName: MHARC , Coded Values: [1: Sound] , [2: Cracked] , [3: Broken] , ...3 more... )
• MHARH ( type: esriFieldTypeDouble, alias: MH Adjustment Ring Height, editable: true, nullable: true, defaultValue: null, modelName: MHARH , Range: [0, 96] )
• FRAMEM ( type: esriFieldTypeString, alias: Frame Material, editable: true, nullable: true, length: 4, defaultValue: null, modelName: FRAMEM , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• FRAMEC ( type: esriFieldTypeSmallInteger, alias: Frame Condition, editable: true, nullable: true, defaultValue: null, modelName: FRAMEC , Coded Values: [1: Sound] , [2: Cracked] , [3: Broken] , ...3 more... )
• FRAMESC ( type: esriFieldTypeSmallInteger, alias: Frame Seal Condition, editable: true, nullable: true, defaultValue: null, modelName: FRAMESC , Coded Values: [1: Sound] , [2: Cracked] , [3: Loose / Not Attached] , ...1 more... )
• FRAMESI ( type: esriFieldTypeString, alias: Frame Seal Infiltration / Inflow, editable: true, nullable: true, length: 2, defaultValue: null, modelName: FRAMESI , Coded Values: [IW: Weeper] , [ID: Dripper] , [IR: Runner] , ...3 more... )
• CMATERIAL1 ( type: esriFieldTypeString, alias: Chimney Material 1, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CMATERIAL1 , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CINFLOW ( type: esriFieldTypeString, alias: Chimney Infiltration / Inflow, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CINFLOW , Coded Values: [IW: Weeper] , [ID: Dripper] , [IR: Runner] , ...3 more... )
• CCOATLINER1 ( type: esriFieldTypeString, alias: Int. Chim. Coating / Liner, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CCOATLINER1 , Coded Values: [NC: No coating] , [C: Cementitious] , [E: Epoxy] , ...7 more... )
• CONETYPE ( type: esriFieldTypeString, alias: Cone Type, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CONETYPE , Coded Values: [FT: Flattop] , [CC: Conical Centered] , [CO: Conical Off-Centered] )
• CONEMATERIAL ( type: esriFieldTypeString, alias: Cone Material, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CONEMATERIAL , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CONELINER1 ( type: esriFieldTypeString, alias: Int Cone Coating / Liner, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CONELINER1 , Coded Values: [NC: No coating] , [C: Cementitious] , [E: Epoxy] , ...7 more... )
• WALLDL ( type: esriFieldTypeDouble, alias: Wall Dia Length, editable: true, nullable: true, defaultValue: null, modelName: WALLDL , Range: [0, 96] )
• WALLDW ( type: esriFieldTypeDouble, alias: Wall Dia Width, editable: true, nullable: true, defaultValue: null, modelName: WALLDW , Range: [0, 96] )
• WALLM ( type: esriFieldTypeString, alias: Wall Material, editable: true, nullable: true, length: 3, defaultValue: null, modelName: WALLM , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• WALLCOAT1 ( type: esriFieldTypeString, alias: Int. Wall Coating / Liner, editable: true, nullable: true, length: 3, defaultValue: null, modelName: WALLCOAT1 , Coded Values: [NC: No coating] , [C: Cementitious] , [E: Epoxy] , ...7 more... )
• BENCH ( type: esriFieldTypeString, alias: Bench Present?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BENCH , Coded Values: [Y: Yes] , [P: Partial] )
• BENCHM ( type: esriFieldTypeString, alias: Bench Material, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BENCHM , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CHANNEL ( type: esriFieldTypeString, alias: Channel Installed, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CHANNEL , Coded Values: [Y: Yes] , [P: Partial] )
• CHANNELT ( type: esriFieldTypeString, alias: Channel Type, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CHANNELT , Coded Values: [P: Pipe] , [F: Formed] , [R: Precast] , ...1 more... )
• CHANNELE ( type: esriFieldTypeString, alias: Channel Exposure, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CHANNELE , Coded Values: [F: Fully Open] , [P: Partially Open] )
• STEPSN ( type: esriFieldTypeSmallInteger, alias: Number of Steps, editable: true, nullable: true, defaultValue: null, modelName: STEPSN )
• STEPSM ( type: esriFieldTypeString, alias: Step Material, editable: true, nullable: true, length: 3, defaultValue: null, modelName: STEPSM , Coded Values: [M: Metal] , [P: Plastic] , [B: Brick] , ...1 more... )
• MHID ( type: esriFieldTypeString, alias: Manhole No., editable: true, nullable: true, length: 20, defaultValue: null, modelName: MHID )
• CWINFLOW ( type: esriFieldTypeString, alias: Cone & Wall Infiltration and Inflow, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CWInFlow , Coded Values: [IW: Weeper] , [ID: Dripper] , [IR: Runner] , ...3 more... )
• EPIPES ( type: esriFieldTypeSmallInteger, alias: External Pipes, editable: true, nullable: true, defaultValue: null, modelName: EPipes , Range: [1, 20] )
• MHMATERIAL ( type: esriFieldTypeSmallInteger, alias: Manhole Material, editable: true, nullable: true, defaultValue: null, modelName: MHMaterial , Coded Values: [0: Concrete] , [1: Brick] )
• INWHELLLANE ( type: esriFieldTypeSmallInteger, alias: Casting in Wheel Lane, editable: true, nullable: true, defaultValue: null, modelName: InWhellLane , Coded Values: [0: False] , [1: True] )
• WATERTYPE ( type: esriFieldTypeString, alias: WaterType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WaterType , Coded Values: [SS: Sanitary] , [SW: Stormwater] , [PR: Processes] , ...7 more... )
• RECOVERY_ ( type: esriFieldTypeString, alias: Recovery, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Recovery , Coded Values: [B: Buried] , [R: Recovered] , [O: Original] )
• STATUS ( type: esriFieldTypeString, alias: Edit Status, editable: true, nullable: true, length: 30, defaultValue: APP, modelName: Status , Coded Values: [DUP: Duplicate - Delete] , [CONVCB: Convert to Catch Basin] , [CONVMH: Convert to Manhole] , ...10 more... )
• FKEY ( type: esriFieldTypeString, alias: Foreign Key, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FKEY )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: MH Components
  Description:
  Prototype:
  FKEY: null
  STATUS: APP
  CSHAPE: C
  CMATERIAL: CAS
  CTYPE: null
  CFF: null
  MHARC: null
  MHARH: null
  FRAMEM: null
  FRAMEC: null
  FRAMESC: null
  FRAMESI: null
  CMATERIAL1: null
  CINFLOW: null
  CCOATLINER1: null
  CONETYPE: null
  CONEMATERIAL: null
  CONELINER1: null
  WALLDL: null
  WALLDW: null
  WALLM: null
  WALLCOAT1: null
  BENCH: null
  BENCHM: null
  CHANNEL: null
  CHANNELT: null
  CHANNELE: null
  STEPSN: null
  STEPSM: null
  MHID: null
  CWINFLOW: null
  EPIPES: null
  MHMATERIAL: null
  INWHELLLANE: null
  WATERTYPE: null
  RECOVERY_: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ssMHComponents (1) -- Related To: Manholes (2)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

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