View In:   ArcGIS Online Map Viewer

Name: swDrainPipe

Display Field: facilityid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 5f5fa911e4ff4ccdbd7c5dd876299a59

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -9035986.1453
YMin: 4020327.2048000023
XMax: -8994039.5994
YMax: 4056729.030500002
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

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

Feature Draw Order:

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: System-maintained ObjectID, alias: OBJECTID )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 25, alias: Facility ID, type: esriFieldTypeString )
• facilityindex ( modelName: FACILITYINDEX, nullable: true, editable: true, defaultValue: null, alias: Facility ID Index, type: esriFieldTypeInteger )
• usnodeid ( modelName: USNODEID, nullable: true, editable: true, defaultValue: null, length: 50, alias: From Node, type: esriFieldTypeString )
• dsnodeid ( modelName: DSNODEID, nullable: true, editable: true, defaultValue: null, length: 50, alias: To Node, type: esriFieldTypeString )
• legacyid ( modelName: LEGACYID, nullable: true, editable: true, defaultValue: null, length: 25, alias: Legacy ID, type: esriFieldTypeString )
• draintype ( modelName: DRAINTYPE, nullable: true, editable: true, defaultValue: null, length: 50, alias: DrainType, type: esriFieldTypeString , Coded Values: [Pipe: Pipe] , [Culvert: Culvert] , [Other: Other] , ...1 more... )
• installdate ( modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• material ( modelName: MATERIAL, nullable: true, editable: true, defaultValue: null, length: 50, alias: Material, type: esriFieldTypeString , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...36 more... )
• diameter ( modelName: DIAMETER, nullable: true, editable: true, defaultValue: null, alias: Diameter, type: esriFieldTypeDouble , Coded Values: [6: 6"] , [8: 8"] , [10: 10"] , ...28 more... )
• height ( modelName: HEIGHT, nullable: true, editable: true, defaultValue: null, alias: Height, type: esriFieldTypeDouble , Coded Values: [6: 6"] , [8: 8"] , [10: 10"] , ...28 more... )
• width ( modelName: WIDTH, nullable: true, editable: true, defaultValue: null, alias: Width, type: esriFieldTypeDouble , Coded Values: [6: 6"] , [8: 8"] , [10: 10"] , ...28 more... )
• mainshape ( modelName: MAINSHAPE, nullable: true, editable: true, defaultValue: null, length: 25, alias: Main Shape, type: esriFieldTypeString , Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...10 more... )
• usinvertdepth ( modelName: USINVERTDEPTH, nullable: true, editable: true, defaultValue: null, alias: US Invert Depth, type: esriFieldTypeDouble )
• dsinvertdepth ( modelName: DSINVERTDEPTH, nullable: true, editable: true, defaultValue: null, alias: DS Invert Depth, type: esriFieldTypeDouble )
• slope ( modelName: SLOPE, nullable: true, editable: true, defaultValue: null, alias: Slope, type: esriFieldTypeDouble )
• flowpresent ( modelName: FLOWPRESENT, nullable: true, editable: true, defaultValue: null, length: 50, alias: Flow Present, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• subwatershed ( modelName: SUBWATERSHED, nullable: true, editable: true, defaultValue: null, length: 50, alias: Subwatershed, type: esriFieldTypeString )
• lifecyclestatus ( modelName: LIFECYCLESTATUS, nullable: true, editable: true, defaultValue: Active, length: 25, alias: Life Cycle Status, type: esriFieldTypeString , Coded Values: [Active: Active] , [Inactive: Inactive] , [Proposed: Proposed] , ...3 more... )
• activeflag ( modelName: ACTIVEFLAG, nullable: true, editable: true, defaultValue: null, alias: Active Flag, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• ownedby ( modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [1: City of Columbia] , [2: SCDOT] , [3: Richland County] , ...6 more... )
• maintainedby ( modelName: MAINTAINEDBY, nullable: true, editable: true, defaultValue: 1, alias: Managed By, type: esriFieldTypeSmallInteger , Coded Values: [1: City of Columbia] , [2: SCDOT] , [3: Richland County] , ...6 more... )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 250, alias: Location Description, type: esriFieldTypeString )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 250, alias: Comments, type: esriFieldTypeString )
• datasource ( modelName: DATASOURCE, nullable: true, editable: true, defaultValue: null, length: 25, alias: Data Source, type: esriFieldTypeString , Coded Values: [ASB: Asbuilt/Record Drawing] , [DES: Design Drawing] , [IMG: Imagery] , ...10 more... )
• lasteditor ( modelName: LASTEDITOR, nullable: true, editable: false, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• lastupdate ( modelName: LASTUPDATE, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Last Update Date, type: esriFieldTypeDate )
• creator ( modelName: CREATOR, nullable: true, editable: false, defaultValue: null, length: 50, alias: Creator, type: esriFieldTypeString )
• creationdate ( modelName: CREATIONDATE, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Creation Date, type: esriFieldTypeDate )
• gpswho ( modelName: GPSWHO, nullable: true, editable: true, defaultValue: null, length: 50, alias: GPS Who, type: esriFieldTypeString )
• gpsdate ( modelName: GPSDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: GPS Date, type: esriFieldTypeDate )
• upnorthing ( modelName: UPNORTHING, nullable: true, editable: true, defaultValue: null, alias: Upstream Northing, type: esriFieldTypeDouble )
• upeasting ( modelName: UPEASTING, nullable: true, editable: true, defaultValue: null, alias: Upstream Easting, type: esriFieldTypeDouble )
• dnnorthing ( modelName: DNNORTHING, nullable: true, editable: true, defaultValue: null, alias: Downstream Northing, type: esriFieldTypeDouble )
• dneasting ( modelName: DNEASTING, nullable: true, editable: true, defaultValue: null, alias: Downstream Easting, type: esriFieldTypeDouble )
• upelev ( modelName: UPELEV, nullable: true, editable: true, defaultValue: null, alias: Upstream Surveyed Elevation, type: esriFieldTypeDouble )
• downelev ( modelName: DOWNELEV, nullable: true, editable: true, defaultValue: null, alias: Downstream Surveyed Elevation, type: esriFieldTypeDouble )
• upinvelev ( modelName: UPINVELEV, nullable: true, editable: true, defaultValue: null, alias: Upstream Pipe Invert Elevation, type: esriFieldTypeDouble )
• dninvelev ( modelName: DNINVELEV, nullable: true, editable: true, defaultValue: null, alias: Downstream Pipe Invert Elevation, type: esriFieldTypeDouble )
• enabled ( modelName: ENABLED, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: swDrainPipe
  Description:
  Prototype:
  maintainedby: 1
  facilityid: null
  installdate: null
  enabled: 1
  dsnodeid: null
  dnnorthing: null
  lifecyclestatus: Active
  upinvelev: null
  diameter: null
  mainshape: null
  facilityindex: null
  usinvertdepth: null
  dneasting: null
  gpsdate: null
  dsinvertdepth: null
  ownedby: 1
  draintype: null
  height: null
  comments: null
  upnorthing: null
  slope: null
  usnodeid: null
  downelev: null
  activeflag: null
  dninvelev: null
  subwatershed: null
  upelev: null
  material: null
  datasource: null
  gpswho: null
  flowpresent: null
  width: null
  legacyid: null
  upeasting: null
  location: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• swConveyanceCondition (3) -- Related To: swConveyanceCondition (19)

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: lastupdate
• Editor Field: lasteditor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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