View In:   ArcGIS Online map viewer

Name: Basin 2 Sewer Mains Greater Than 18 inch Diameter

Display Field: PIPEUSE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 3454ccbfcb4c43a5a9f06709018f7dd1

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 120000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 788530.5018749982
YMin: 1128226.840625003
XMax: 835778.629999999
YMax: 1191470.9293750003
Spatial Reference: 102671  (3435)  VCSWkid(115702)  LatestVCSWkid(115702)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [255, 0, 197, 255]
Width: 5
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PIPEUSE ( type: esriFieldTypeString, alias: Use of Sewer, editable: true, nullable: true, length: 20, defaultValue: SS, modelName: PipeUse , Coded Values: [SS: Sanitary] , [SW: Stormwater] , [PR: Processes] , ...7 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Pipe Material, editable: true, nullable: true, length: 5, defaultValue: VCP, modelName: Material , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CROSXSHAP ( type: esriFieldTypeString, alias: Pipe Shape, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CrosXShap , Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more... )
• SPCOND ( type: esriFieldTypeString, alias: Pipe Special Condition, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SPCond , Coded Values: [OU: Outside Drop Upper] , [OL: Outside Drop Lower] , [IU: Inside Drop Upper] , ...4 more... )
• PINVU ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: PInvU )
• PINVD ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: PInvD )
• PSCONDU ( type: esriFieldTypeString, alias: Pipe Seal Condition US, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PSCondU , Coded Values: [S: Sound] , [H: Hole] , [IW: Weeper] , ...5 more... )
• PSCONDD ( type: esriFieldTypeString, alias: Pipe Seal Condition DS, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PSCondD , Coded Values: [S: Sound] , [H: Hole] , [IW: Weeper] , ...5 more... )
• SYSOWNER ( type: esriFieldTypeString, alias: System Owner, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SysOwner , Coded Values: [MZ: Mt. Zion] , [FH: Forsyth] , [COD: City of Decatur] , ...4 more... )
• PIPEID ( type: esriFieldTypeString, alias: Pipe Segment Reference, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PipeID )
• MHNOUS ( type: esriFieldTypeString, alias: Upstream manhole number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MHNoUS )
• MHNODS ( type: esriFieldTypeString, alias: Downstream manhole number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MHNoDS )
• RIMINVUS ( type: esriFieldTypeDouble, alias: Upstream Rim to Invert, editable: true, nullable: true, defaultValue: null, modelName: RimInvUS )
• RIMINVDS ( type: esriFieldTypeDouble, alias: Downstream Rim to Invert, editable: true, nullable: true, defaultValue: null, modelName: RimInvDS )
• INSTLDATE ( type: esriFieldTypeDate, alias: Year Constructed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstlDate )
• REHBDATE ( type: esriFieldTypeDate, alias: Year Rehabilitated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RehbDate )
• APN ( type: esriFieldTypeSmallInteger, alias: Asset Priority Number, editable: true, nullable: true, defaultValue: null, modelName: APN )
• LROOTCUT ( type: esriFieldTypeDate, alias: Last Root Cut, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LRootCut )
• LJETDATE ( type: esriFieldTypeDate, alias: Last Jet Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LJetDate )
• LHRBDATE ( type: esriFieldTypeDate, alias: Last Herbicide Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LHrbDate )
• LDGRDATE ( type: esriFieldTypeDate, alias: Last Degrease Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LDgrDate )
• LTELDATE ( type: esriFieldTypeDate, alias: Last Televise Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LTelDate )
• TAPENO ( type: esriFieldTypeString, alias: Tape / Media No_, editable: true, nullable: true, length: 24, defaultValue: null, modelName: TapeNo )
• POF ( type: esriFieldTypeDouble, alias: Probability of Failure, editable: true, nullable: true, defaultValue: null, modelName: POF )
• COF ( type: esriFieldTypeDouble, alias: Criticality of Failure, editable: true, nullable: true, defaultValue: null, modelName: COF )
• PIPEDIA ( type: esriFieldTypeString, alias: Pipe Diameter, editable: true, nullable: true, length: 7, defaultValue: null, modelName: PipeDia , Coded Values: [1: 1"] , [2: 2"] , [4: 4"] , ...40 more... )
• LCLNDATE ( type: esriFieldTypeDate, alias: Last Cleaned Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LCLNDATE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENTS )
• REHBMAT ( type: esriFieldTypeString, alias: REHBMAT, editable: true, nullable: true, length: 4, defaultValue: null, modelName: REHBMAT )
• REHBCNTR ( type: esriFieldTypeString, alias: REHBCNTR, editable: true, nullable: true, length: 35, defaultValue: null, modelName: REHBCNTR )
• HERBICIDE ( type: esriFieldTypeString, alias: HERBICIDE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: HERBICIDE )
• FLOWTYPE ( type: esriFieldTypeString, alias: Flow Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FLOWTYPE )
• OM_SCORE ( type: esriFieldTypeDouble, alias: OM Score, editable: true, nullable: true, defaultValue: null, modelName: OM_SCORE )
• SURFCOND ( type: esriFieldTypeString, alias: Surface Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SURFCOND )
• TVLENGTH ( type: esriFieldTypeDouble, alias: Televised Length, editable: true, nullable: true, defaultValue: null, modelName: TVLENGTH )
• PIPEWIDTH ( type: esriFieldTypeDouble, alias: Pipe Width, editable: true, nullable: true, defaultValue: null, modelName: PIPEWIDTH )
• ASSETSPLIT ( type: esriFieldTypeString, alias: Asset Split, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ASSETSPLIT )
• SPLITDATE ( type: esriFieldTypeDate, alias: Split Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SPLITDATE )
• SUCCESSORASSET ( type: esriFieldTypeString, alias: Successor Assets, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SUCCESSORASSET )
• OLDSPLITASSET ( type: esriFieldTypeString, alias: Old Split Asset, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OLDSPLITASSET )
• PACP_PIPE ( type: esriFieldTypeDouble, alias: PACP Pipe Rating, editable: true, nullable: true, defaultValue: null, modelName: PACP_PIPE )
• CUES_TOTAL ( type: esriFieldTypeDouble, alias: CUES Total Pipe Rating, editable: true, nullable: true, defaultValue: null, modelName: CUES_TOTAL )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• 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 )
• PACP_QUICK ( type: esriFieldTypeString, alias: PACP Quick Rating, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PACP_QUICK )
• Deferred ( type: esriFieldTypeString, alias: Deferred, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Deferred , Coded Values: [Yes: Yes] , [No: No] )
• Deferred_Date ( type: esriFieldTypeDate, alias: Deferred Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Deferred_Date )
• Defer_Reason ( type: esriFieldTypeString, alias: Reason for Deferment, editable: true, nullable: true, length: 24, defaultValue: null, modelName: Defer_Reason , Coded Values: [BlindTap: Blind Tap] , [DiameterPipeSize: Diameter/Pipe Size] , [OffRoad: Off Road] , ...3 more... )
• def_other_reason ( type: esriFieldTypeString, alias: Other Reason, editable: true, nullable: true, length: 255, defaultValue: null, modelName: def_other_reason )
• Sewer_Basin ( type: esriFieldTypeString, alias: Basin, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Sewer_Basin , Coded Values: [1: Basin 1] , [2: Basin 2] , [3: Basin 3] , ...2 more... )
• VERIFIED_CLEAN_DATE ( type: esriFieldTypeDate, alias: Verified Clean Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VERIFIED_CLEAN_DATE )
• TYPE_OF_VERIFICATION ( type: esriFieldTypeString, alias: Type of Verification, editable: true, nullable: true, length: 24, defaultValue: null, modelName: TYPE_OF_VERIFICATION , Coded Values: [CCTV: CCTV] , [Sounding: Sounding] , [MH Visual: MH Visual] , ...6 more... )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )

Templates:

• Name: Basin 2 Sewer Mains Greater Than 18 inch Diameter
  Description:
  Prototype:
  TYPE_OF_VERIFICATION: null
  VERIFIED_CLEAN_DATE: null
  PIPEUSE: SS
  MATERIAL: VCP
  CROSXSHAP: null
  SPCOND: null
  PINVU: null
  PINVD: null
  PSCONDU: null
  PSCONDD: null
  SYSOWNER: null
  PIPEID: null
  MHNOUS: null
  MHNODS: null
  RIMINVUS: null
  RIMINVDS: null
  INSTLDATE: null
  REHBDATE: null
  APN: null
  LROOTCUT: null
  LJETDATE: null
  LHRBDATE: null
  LDGRDATE: null
  LTELDATE: null
  TAPENO: null
  POF: null
  COF: null
  PIPEDIA: null
  LCLNDATE: null
  COMMENTS: null
  REHBMAT: null
  REHBCNTR: null
  HERBICIDE: null
  FLOWTYPE: null
  OM_SCORE: null
  SURFCOND: null
  TVLENGTH: null
  PIPEWIDTH: null
  ASSETSPLIT: null
  SPLITDATE: null
  SUCCESSORASSET: null
  OLDSPLITASSET: null
  PACP_PIPE: null
  CUES_TOTAL: null
  Sewer_Basin: null
  def_other_reason: null
  Defer_Reason: null
  Deferred_Date: null
  Deferred: null
  PACP_QUICK: null
  
  Drawing Tool: esriFeatureEditToolLine

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

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

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