View In:   ArcGIS Online Map Viewer

Name: swDrainPipe

Display Field: facilityid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: aaecb0ed6db8403fbf0478c9748e0a27

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: -9018943.546580866
YMin: 4033325.0032503605
XMax: -9016101.754200166
YMax: 4035673.009335488
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 143, 45, 255]
Width: 1
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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid_1 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID_1, alias: OBJECTID_1 )
• 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: -2, 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: -2, alias: Maintained 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: true, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• lastupdate ( modelName: LASTUPDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Update Date, type: esriFieldTypeDate )
• creator ( modelName: CREATOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: Creator, type: esriFieldTypeString )
• creationdate ( modelName: CREATIONDATE, nullable: true, editable: true, 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] )
• closeddischnum ( modelName: CLOSEDDISCHNUM, nullable: true, editable: true, defaultValue: null, length: 5, alias: Closed Discharge Number, type: esriFieldTypeString , Coded Values: [D: Double] , [Other: Other] , [S: Single] , ...1 more... )
• integrationstatus ( modelName: INTEGRATIONSTATUS, nullable: true, editable: true, defaultValue: null, length: 255, alias: Integration Status, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• objectid ( modelName: OBJECTID, nullable: true, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeInteger )
• facilityid_1 ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 25, alias: Facility ID, type: esriFieldTypeString )
• manyid ( modelName: MANYID, nullable: true, editable: true, defaultValue: null, alias: Many ID, type: esriFieldTypeInteger )
• date_of_assessment ( modelName: DATE_OF_ASSESSMENT, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Of Assessment, type: esriFieldTypeDate )
• cond_access_rating ( modelName: COND_ACCESS_RATING, nullable: true, editable: true, defaultValue: null, length: 30, alias: Accessibility Rating, type: esriFieldTypeString )
• accesscomments ( modelName: ACCESSCOMMENTS, nullable: true, editable: true, defaultValue: null, length: 254, alias: Accessibility Comments, type: esriFieldTypeString )
• cond_struct_rating ( modelName: COND_STRUCT_RATING, nullable: true, editable: true, defaultValue: null, length: 30, alias: Structural Rating, type: esriFieldTypeString )
• structcomments ( modelName: STRUCTCOMMENTS, nullable: true, editable: true, defaultValue: null, length: 254, alias: Structural Condition Comments, type: esriFieldTypeString )
• cond_maint_rating ( modelName: COND_MAINT_RATING, nullable: true, editable: true, defaultValue: null, length: 30, alias: Maintenance Rating, type: esriFieldTypeString )
• maintcomments ( modelName: MAINTCOMMENTS, nullable: true, editable: true, defaultValue: null, length: 254, alias: Maintenance Condition Comments, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: swDrainPipe
  Description:
  Prototype:
  creationdate: null
  facilityid: null
  installdate: null
  cond_access_rating: null
  dsnodeid: null
  dnnorthing: null
  facilityid_1: null
  upinvelev: null
  diameter: null
  mainshape: null
  facilityindex: null
  dneasting: null
  gpsdate: null
  draintype: null
  ownedby: -2
  height: null
  cond_maint_rating: null
  slope: null
  downelev: null
  accesscomments: null
  activeflag: null
  manyid: null
  subwatershed: null
  integrationstatus: null
  upelev: null
  datasource: null
  flowpresent: null
  legacyid: null
  lastupdate: null
  maintcomments: null
  maintainedby: -2
  date_of_assessment: null
  enabled: 1
  lifecyclestatus: Active
  closeddischnum: null
  usinvertdepth: null
  dsinvertdepth: null
  cond_struct_rating: null
  creator: null
  comments: null
  upnorthing: null
  structcomments: null
  lasteditor: null
  usnodeid: null
  dninvelev: null
  material: null
  gpswho: null
  width: null
  location: null
  upeasting: null
  objectid: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata