View In:   ArcGIS Online Map Viewer

Name: RadfordGISData.DBO.Water_Device

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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

Supports Datum Transformation: true

Extent:

XMin: 8837830.055783302
YMin: 5394233.901865721
XMax: 8857553.970403641
YMax: 5407783.528309733
Spatial Reference: 102747  (2284)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [141, 145, 61, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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: true
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: false
Supports Query With LOD Spatial Reference: false

HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• assetgroup ( type: esriFieldTypeInteger, alias: Asset group, editable: true, nullable: false, defaultValue: 0, modelName: assetgroup )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: false, defaultValue: 0, modelName: assettype )
• associationstatus ( type: esriFieldTypeSmallInteger, alias: Association status, editable: true, nullable: false, defaultValue: 0, modelName: associationstatus )
• issubnetworkcontroller ( type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, editable: true, nullable: false, defaultValue: 0, modelName: issubnetworkcontroller )
• isconnected ( type: esriFieldTypeSmallInteger, alias: Is connected, editable: true, nullable: false, defaultValue: 2, modelName: isconnected )
• subnetworkcontrollername ( type: esriFieldTypeString, alias: Subnetwork controller name, editable: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: subnetworkcontrollername )
• tiername ( type: esriFieldTypeInteger, alias: Tier name, editable: true, nullable: false, defaultValue: 0, modelName: tiername )
• tierrank ( type: esriFieldTypeInteger, alias: Tier rank, editable: true, nullable: false, defaultValue: 0, modelName: tierrank )
• terminalconfiguration ( type: esriFieldTypeString, alias: Terminal path, editable: true, nullable: false, length: 128, defaultValue: Default, modelName: terminalconfiguration )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: creationdate )
• creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: creator )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lastupdate )
• updatedby ( type: esriFieldTypeString, alias: Updated by, editable: true, nullable: true, length: 255, defaultValue: null, modelName: updatedby )
• globalid ( type: esriFieldTypeGUID, alias: Global ID, editable: true, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• cpsubnetworkname ( type: esriFieldTypeString, alias: CP Subnetwork Name, editable: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: cpsubnetworkname )
• supportedsubnetworkname ( type: esriFieldTypeString, alias: Supported subnetwork name, editable: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: supportedsubnetworkname )
• systemsubnetworkname ( type: esriFieldTypeString, alias: System Subnetwork Name, editable: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: systemsubnetworkname )
• pressuresubnetworkname ( type: esriFieldTypeString, alias: Pressure Subnetwork Name, editable: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: pressuresubnetworkname )
• isolationsubnetworkname ( type: esriFieldTypeString, alias: Isolation Subnetwork Name, editable: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: isolationsubnetworkname )
• dmasubnetworkname ( type: esriFieldTypeString, alias: DMA Subnetwork Name, editable: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: dmasubnetworkname )
• diameter ( type: esriFieldTypeDouble, alias: diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight, editable: true, nullable: true, defaultValue: null, modelName: diameter )
• secondarydiameter ( type: esriFieldTypeDouble, alias: secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width, editable: true, nullable: true, defaultValue: null, modelName: secondarydiameter )
• pressure ( type: esriFieldTypeDouble, alias: pressure: Amperage, Pressure, Rated Pressure, Volume, editable: true, nullable: true, defaultValue: null, modelName: pressure )
• designtype ( type: esriFieldTypeSmallInteger, alias: designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count, editable: true, nullable: true, defaultValue: null, modelName: designtype )
• normalstatus ( type: esriFieldTypeSmallInteger, alias: Normal Status, editable: true, nullable: true, defaultValue: null, modelName: normalstatus )
• presentstatus ( type: esriFieldTypeSmallInteger, alias: Present Status, editable: true, nullable: true, defaultValue: null, modelName: presentstatus )
• additionaldetails ( type: esriFieldTypeSmallInteger, alias: additionaldetails: Clockwise to Close, Cooling Method, Critical, Material, editable: true, nullable: true, defaultValue: null, modelName: additionaldetails )
• designinfo ( type: esriFieldTypeDouble, alias: designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage, editable: true, nullable: true, defaultValue: null, modelName: designinfo )
• operable ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: false, defaultValue: 1, modelName: operable )
• name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 64, defaultValue: null, modelName: name )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: assetid )
• accountid ( type: esriFieldTypeString, alias: Account ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: accountid )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: ownedby )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: maintby )
• additionaldevice ( type: esriFieldTypeSmallInteger, alias: additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered, editable: true, nullable: true, defaultValue: null, modelName: additionaldevice )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• symbolrotation ( type: esriFieldTypeSmallInteger, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: symbolrotation )
• lastmaint ( type: esriFieldTypeDate, alias: Last Maintenance, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lastmaint )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: false, defaultValue: 0, modelName: lifecyclestatus )
• bondedinsulated ( type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, editable: true, nullable: true, defaultValue: null, modelName: bondedinsulated )
• cptraceability ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, editable: true, nullable: true, defaultValue: 0, modelName: cptraceability )
• inservicedate ( type: esriFieldTypeDate, alias: In-Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inservicedate )
• retireddate ( type: esriFieldTypeDate, alias: Retired Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: retireddate )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source, editable: true, nullable: true, defaultValue: null, modelName: spatialsource )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence, editable: true, nullable: true, defaultValue: null, modelName: spatialconfidence )
• cpoverride ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, editable: true, nullable: true, defaultValue: null, modelName: cpoverride )
• manufacturer ( type: esriFieldTypeSmallInteger, alias: Manufacturer, editable: true, nullable: true, defaultValue: null, modelName: manufacturer )
• operator ( type: esriFieldTypeSmallInteger, alias: Postindicator Valve, editable: true, nullable: true, defaultValue: null, modelName: operator )

Templates:

• Name: RadfordGISData.DBO.Water_Device
  Description:
  Prototype:
  manufacturer: null
  operator: null
  assetgroup: 0
  assettype: 0
  associationstatus: 0
  issubnetworkcontroller: 0
  isconnected: 2
  subnetworkcontrollername: Unknown
  tiername: 0
  tierrank: 0
  terminalconfiguration: Default
  creationdate: null
  creator: null
  lastupdate: null
  updatedby: null
  globalid: {00000000-0000-0000-0000-000000000000}
  cpsubnetworkname: Unknown
  supportedsubnetworkname: Unknown
  systemsubnetworkname: Unknown
  pressuresubnetworkname: Unknown
  isolationsubnetworkname: Unknown
  dmasubnetworkname: Unknown
  diameter: null
  secondarydiameter: null
  pressure: null
  designtype: null
  normalstatus: null
  presentstatus: null
  additionaldetails: null
  designinfo: null
  operable: 1
  name: null
  installdate: null
  assetid: null
  accountid: null
  ownedby: 1
  maintby: 1
  additionaldevice: null
  notes: null
  symbolrotation: null
  lastmaint: null
  lifecyclestatus: 0
  bondedinsulated: null
  cptraceability: 0
  inservicedate: null
  retireddate: null
  spatialsource: null
  spatialconfidence: null
  cpoverride: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata