View In:   ArcGIS Online Map Viewer

Name: swNetworkStructure

Display Field: facilityid

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: -9018845.451454401
YMin: 4033364.8687866703
XMax: -9016130.529695757
YMax: 4035628.3116578013
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 133, 102, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 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 )
• facilityidindex ( modelName: FACILITYIDINDEX, nullable: true, editable: true, defaultValue: null, alias: Facility ID Index, type: esriFieldTypeInteger )
• 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 )
• structuretype ( modelName: STRUCTURETYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Structure Type, type: esriFieldTypeString , Coded Values: [Blind Junction: Blind Junction] , [Diversion Box: Diversion Box] , [Junction Box: Junction Box] , ...7 more... )
• structurematerial ( modelName: STRUCTUREMATERIAL, nullable: true, editable: true, defaultValue: null, length: 20, alias: Structure Material, type: esriFieldTypeString , Coded Values: [Pre-Cast Concrete: Pre-Cast Concrete] , [Brick: Brick] , [Masonry: Masonry] , ...4 more... )
• structuredepth ( modelName: STRUCTUREDEPTH, nullable: true, editable: true, defaultValue: null, alias: Structure Center Depth, type: esriFieldTypeDouble )
• accesstype ( modelName: ACCESSTYPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Access Type, type: esriFieldTypeString , Coded Values: [Grate: Grate] , [Manhole: Manhole] , [No Access: No Access] , ...2 more... )
• subwatershed ( modelName: SUBWATERSHED, nullable: true, editable: true, defaultValue: null, length: 50, alias: Subwatershed, type: esriFieldTypeString )
• invertdepth ( modelName: INVERTDEPTH, nullable: true, editable: true, defaultValue: null, alias: Invert Depth, type: esriFieldTypeDouble )
• stubpt ( modelName: STUBPT, nullable: true, editable: true, defaultValue: null, length: 30, alias: Stub Point, type: esriFieldTypeString , Coded Values: [Stub Point: Stub Point] , [N/A: N/A] )
• reasonforstub ( modelName: REASONFORSTUB, nullable: true, editable: true, defaultValue: null, length: 255, alias: Reason For Stub Point, type: esriFieldTypeString , Coded Values: [Edge of Basin: Edge of Basin] , [Edge of Project Area: Edge of Project Area] , [Inaccessible: Inaccessible] , ...5 more... )
• flowpresent ( modelName: FLOWPRESENT, nullable: true, editable: true, defaultValue: null, length: 50, alias: Flow Present, type: esriFieldTypeString , Coded Values: [D: Dry Flow Present] , [N: No Dry Weather Flow] , [P: Perennial Waterbody] )
• outfall ( modelName: OUTFALL, nullable: true, editable: true, defaultValue: null, length: 50, alias: Outfall, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• 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: 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 )
• northing ( modelName: NORTHING, nullable: true, editable: true, defaultValue: null, alias: Northing, type: esriFieldTypeDouble )
• easting ( modelName: EASTING, nullable: true, editable: true, defaultValue: null, alias: Easting, type: esriFieldTypeDouble )
• elevation ( modelName: ELEVATION, nullable: true, editable: true, defaultValue: null, alias: Surveyed Elevation, type: esriFieldTypeDouble )
• enabled ( modelName: ENABLED, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• ancillaryrole ( modelName: ANCILLARYROLE, nullable: true, editable: true, defaultValue: null, length: 10, alias: Ancillary Role, type: esriFieldTypeString , Coded Values: [None: None] , [Source: Source] , [Sink: Sink] )
• additionalpipe ( modelName: ADDITIONALPIPE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Additional Pipes Present, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• centerelev ( modelName: CENTERELEV, nullable: true, editable: true, defaultValue: null, alias: Structure Center Elevation, type: esriFieldTypeDouble )
• 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 )

Templates:

• Name: swNetworkStructure
  Description:
  Prototype:
  maintainedby: 1
  maintcomments: null
  date_of_assessment: null
  creationdate: null
  facilityid: null
  facilityidindex: null
  installdate: null
  outfall: null
  invertdepth: null
  cond_access_rating: null
  northing: null
  enabled: 1
  lifecyclestatus: Active
  facilityid_1: null
  reasonforstub: null
  gpsdate: null
  ownedby: 1
  elevation: null
  cond_struct_rating: null
  accesstype: null
  creator: null
  comments: null
  easting: null
  cond_maint_rating: null
  structuretype: null
  stubpt: null
  ancillaryrole: null
  centerelev: null
  additionalpipe: null
  structcomments: null
  structurematerial: null
  lasteditor: null
  accesscomments: null
  activeflag: null
  manyid: null
  subwatershed: null
  structuredepth: null
  datasource: null
  flowpresent: null
  gpswho: null
  legacyid: null
  location: null
  lastupdate: null
  objectid: null
  
  Drawing Tool: esriFeatureEditToolPoint

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