View In:   ArcGIS Online Map Viewer

Name: swOpenDrain

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: -9035961.8935
YMin: 3994189.1155999973
XMax: -8974480.4801
YMax: 4057154.4842000008
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [126, 161, 0, 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 )
• facilityidindex ( modelName: FACILITYIDINDEX, 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 )
• installdate ( modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• opendraintype ( modelName: OPENDRAINTYPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Open Drain Type, type: esriFieldTypeString , Coded Values: [Ditch: Ditch] , [Swale: Swale] , [Stream: Stream] , ...3 more... )
• leftmaterial ( modelName: LEFTMATERIAL, nullable: true, editable: true, defaultValue: null, length: 50, alias: Left Material, type: esriFieldTypeString , Coded Values: [Asph: Asphalt] , [BR: Brick] , [Concrete (Non-Reinforced): Concrete (Non-Reinforced)] , ...12 more... )
• rightmaterial ( modelName: RIGHTMATERIAL, nullable: true, editable: true, defaultValue: null, length: 50, alias: Right Material, type: esriFieldTypeString , Coded Values: [Asph: Asphalt] , [BR: Brick] , [Concrete (Non-Reinforced): Concrete (Non-Reinforced)] , ...12 more... )
• bottommaterial ( modelName: BOTTOMMATERIAL, nullable: true, editable: true, defaultValue: null, length: 50, alias: Bottom Material, type: esriFieldTypeString , Coded Values: [Asph: Asphalt] , [BR: Brick] , [Concrete (Non-Reinforced): Concrete (Non-Reinforced)] , ...12 more... )
• topwidth ( modelName: TOPWIDTH, nullable: true, editable: true, defaultValue: null, alias: Top Width, type: esriFieldTypeDouble )
• bottomwidth ( modelName: BOTTOMWIDTH, nullable: true, editable: true, defaultValue: null, alias: Bottom Width, type: esriFieldTypeDouble )
• bankheight ( modelName: BANKHEIGHT, nullable: true, editable: true, defaultValue: null, alias: Bank Height, 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: Downsteam 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 )
• 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: swOpenDrain
  Description:
  Prototype:
  maintainedby: 1
  facilityid: null
  installdate: null
  facilityidindex: null
  enabled: 1
  dsnodeid: null
  dnnorthing: null
  lifecyclestatus: Active
  dneasting: null
  gpsdate: null
  bankheight: null
  ownedby: 1
  comments: null
  rightmaterial: null
  opendraintype: null
  topwidth: null
  upnorthing: null
  leftmaterial: null
  downelev: null
  usnodeid: null
  activeflag: null
  subwatershed: null
  upelev: null
  datasource: null
  gpswho: null
  bottommaterial: null
  flowpresent: null
  legacyid: null
  upeasting: null
  bottomwidth: null
  location: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• swConveyanceCondition (4) -- 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