View In:   ArcGIS Online Map Viewer

Name: SwDrainPipe_Criticality

Display Field: facilityid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 8335dabf4e3b4db3805eb311be977e9b

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: -9020444.953798506
YMin: 4029124.3382481784
XMax: -9019033.469852518
YMax: 4030257.6416746825
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: structrating
Field 2: N/A
Field 3: N/A
Field Delimiter: N/A
Default Symbol:
Style: esriSLSSolid
Color: [170, 170, 170, 255]
Width: 1
Default Label: Other
UniqueValueInfos:
• Value: 1
  Label: 1
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
• Value: 2
  Label: 2
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 1
• Value: 3
  Label: 3
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 1
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: structrating

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 25, alias: Facility ID, type: esriFieldTypeString )
• facilityidindex ( 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 )
• 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: C, 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: PERENNIAL, nullable: true, editable: true, defaultValue: N, 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 )
• 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: 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: MAPGPS, length: 25, alias: Data Source, type: esriFieldTypeString , Coded Values: [ASB: Asbuilt/Record Drawing] , [AUTO: Auto Generated] , [DEED: Deed] , ...10 more... )
• 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] )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• watershed ( modelName: WATERSHED, nullable: true, editable: true, defaultValue: 11, length: 255, alias: Watershed, type: esriFieldTypeString )
• us_comment ( modelName: US_Comment, nullable: true, editable: true, defaultValue: null, length: 255, alias: Upstream Comment, type: esriFieldTypeString , Coded Values: [Abandoned: Abandoned] , [BEP: Bare End Pipe] , [Blind Junction: Blind Junction] , ...18 more... )
• ds_comment ( modelName: DS_Comment, nullable: true, editable: true, defaultValue: null, length: 255, alias: Downstream Comment, type: esriFieldTypeString , Coded Values: [Abandoned: Abandoned] , [BEP: Bare End Pipe] , [Blind Junction: Blind Junction] , ...18 more... )
• draintype ( modelName: DRAINTYPE, nullable: true, editable: true, defaultValue: Pipe, length: 50, alias: Drain Type, type: esriFieldTypeString , Coded Values: [Pipe: Pipe] , [Culvert: Culvert] , [Other: Other] , ...1 more... )
• lifecyclestatus ( modelName: LIFECYCLESTATUS, nullable: true, editable: true, defaultValue: Active, length: 50, alias: Life Cycle Status, type: esriFieldTypeString , Coded Values: [Active: Active] , [Inactive: Inactive] , [Proposed: Proposed] , ...3 more... )
• assessmentcomplete ( modelName: AssessmentComplete, nullable: true, editable: true, defaultValue: null, length: 25, alias: AssessmentComplete, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] , [S: Stubpoint] )
• pipebarrels ( modelName: Barrels, nullable: true, editable: true, defaultValue: S, length: 50, alias: PipeBarrels, type: esriFieldTypeString , Coded Values: [S: Single] , [D: Double] , [T: Triple] , ...1 more... )
• near_fid_rdtype ( modelName: near_fid_rdtype, nullable: true, editable: true, defaultValue: null, alias: NEAR_FID_RdType, type: esriFieldTypeInteger )
• near_dist_rdtype ( modelName: near_dist_rdtype, nullable: true, editable: true, defaultValue: null, alias: NEAR_DIST_RdType, type: esriFieldTypeDouble )
• near_fid_bldg ( modelName: near_fid_bldg, nullable: true, editable: true, defaultValue: null, alias: NEAR_FID_Bldg, type: esriFieldTypeInteger )
• near_dist_bldg ( modelName: near_dist_bldg, nullable: true, editable: true, defaultValue: null, alias: NEAR_DIST_Bldg, type: esriFieldTypeDouble )
• near_fid_row ( modelName: near_fid_row, nullable: true, editable: true, defaultValue: null, alias: NEAR_FID_ROW, type: esriFieldTypeInteger )
• near_dist_row ( modelName: near_dist_row, nullable: true, editable: true, defaultValue: null, alias: NEAR_DIST_ROW, type: esriFieldTypeDouble )
• structrating ( modelName: structrating, nullable: true, editable: true, defaultValue: null, alias: StructRating, type: esriFieldTypeInteger )
• maintrating ( modelName: maintrating, nullable: true, editable: true, defaultValue: null, alias: MaintRating, type: esriFieldTypeInteger )
• rdtype ( modelName: rdtype, nullable: true, editable: true, defaultValue: null, length: 255, alias: RdType, type: esriFieldTypeString )
• bldgloc ( modelName: bldgloc, nullable: true, editable: true, defaultValue: null, length: 255, alias: BldgLoc, type: esriFieldTypeString )
• lof_score ( modelName: lof_score, nullable: true, editable: true, defaultValue: null, alias: LoF_score, type: esriFieldTypeDouble )
• cof_score ( modelName: cof_score, nullable: true, editable: true, defaultValue: null, alias: CoF_score, type: esriFieldTypeDouble )
• total_score ( modelName: total_score, nullable: true, editable: true, defaultValue: null, alias: Total_score, type: esriFieldTypeDouble )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Types:

ID: 1
Name: 1
Domains:
None
Templates:
• Name: 1
  Description:
  Prototype:
  near_fid_rdtype: null
  watershed: 11
  creationdate: null
  facilityid: null
  facilityidindex: null
  installdate: null
  pipebarrels: S
  near_fid_row: null
  ds_comment: null
  dsnodeid: null
  dnnorthing: null
  upinvelev: null
  diameter: null
  mainshape: C
  dneasting: null
  gpsdate: null
  ownedby: -2
  draintype: Pipe
  height: null
  created_user: null
  assessmentcomplete: null
  near_dist_bldg: null
  slope: null
  rdtype: null
  downelev: null
  near_dist_row: null
  subwatershed: null
  upelev: null
  datasource: MAPGPS
  flowpresent: N
  us_comment: null
  maintainedby: -2
  lof_score: null
  bldgloc: null
  enabled: 1
  lifecyclestatus: Active
  structrating: 1
  maintrating: null
  usinvertdepth: null
  last_edited_date: null
  near_fid_bldg: null
  total_score: null
  dsinvertdepth: null
  creator: null
  comments: null
  upnorthing: null
  usnodeid: null
  dninvelev: null
  last_edited_user: null
  material: null
  near_dist_rdtype: null
  gpswho: null
  width: null
  cof_score: null
  location: null
  upeasting: null
  created_date: null
  
  Drawing Tool: N/A

---

ID: 2
Name: 2
Domains:
None
Templates:
• Name: 2
  Description:
  Prototype:
  near_fid_rdtype: null
  watershed: 11
  creationdate: null
  facilityid: null
  facilityidindex: null
  installdate: null
  pipebarrels: S
  near_fid_row: null
  ds_comment: null
  dsnodeid: null
  dnnorthing: null
  upinvelev: null
  diameter: null
  mainshape: C
  dneasting: null
  gpsdate: null
  ownedby: -2
  draintype: Pipe
  height: null
  created_user: null
  assessmentcomplete: null
  near_dist_bldg: null
  slope: null
  rdtype: null
  downelev: null
  near_dist_row: null
  subwatershed: null
  upelev: null
  datasource: MAPGPS
  flowpresent: N
  us_comment: null
  maintainedby: -2
  lof_score: null
  bldgloc: null
  enabled: 1
  lifecyclestatus: Active
  structrating: 2
  maintrating: null
  usinvertdepth: null
  last_edited_date: null
  near_fid_bldg: null
  total_score: null
  dsinvertdepth: null
  creator: null
  comments: null
  upnorthing: null
  usnodeid: null
  dninvelev: null
  last_edited_user: null
  material: null
  near_dist_rdtype: null
  gpswho: null
  width: null
  cof_score: null
  location: null
  upeasting: null
  created_date: null
  
  Drawing Tool: N/A

---

ID: 3
Name: 3
Domains:
None
Templates:
• Name: 3
  Description:
  Prototype:
  near_fid_rdtype: null
  watershed: 11
  creationdate: null
  facilityid: null
  facilityidindex: null
  installdate: null
  pipebarrels: S
  near_fid_row: null
  ds_comment: null
  dsnodeid: null
  dnnorthing: null
  upinvelev: null
  diameter: null
  mainshape: C
  dneasting: null
  gpsdate: null
  ownedby: -2
  draintype: Pipe
  height: null
  created_user: null
  assessmentcomplete: null
  near_dist_bldg: null
  slope: null
  rdtype: null
  downelev: null
  near_dist_row: null
  subwatershed: null
  upelev: null
  datasource: MAPGPS
  flowpresent: N
  us_comment: null
  maintainedby: -2
  lof_score: null
  bldgloc: null
  enabled: 1
  lifecyclestatus: Active
  structrating: 3
  maintrating: null
  usinvertdepth: null
  last_edited_date: null
  near_fid_bldg: null
  total_score: null
  dsinvertdepth: null
  creator: null
  comments: null
  upnorthing: null
  usnodeid: null
  dninvelev: null
  last_edited_user: null
  material: null
  near_dist_rdtype: null
  gpswho: null
  width: null
  cof_score: null
  location: null
  upeasting: null
  created_date: null
  
  Drawing Tool: N/A

---

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