View In:   ArcGIS Online Map Viewer

Name: NBGIS.DBO.wValve

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 200000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: -119851500
YMin: -94498200
XMax: 819608.9597928077
YMax: 2747484.318281725
Spatial Reference: 102686  (2249)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [83, 137, 60, 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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACILITYID )
• PERMITID ( type: esriFieldTypeString, alias: Permit ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PERMITID )
• LEGACYID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LEGACYID )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Street )
• Municipality ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Municipality , Coded Values: [1: New Bedford] )
• LocationDescription ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LocationDescription , Coded Values: [AER: Aerial] , [EST: Estimated from Plan] , [SCL: Scaled from Plan] , ...9 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Status , Coded Values: [Abandoned: Abandoned] , [Removed: Removed] , [Proposed: Proposed] , ...3 more... )
• WaterSubtype ( type: esriFieldTypeString, alias: Water Subtype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterSubtype )
• WaterSubtypeNumber ( type: esriFieldTypeInteger, alias: Water Subtype Number, editable: true, nullable: true, defaultValue: null, modelName: WaterSubtypeNumber )
• WaterType ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WaterType , Coded Values: [1: Valve] , [2: AirValve] , [3: Wastegate] , ...1 more... )
• Operable ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: null, modelName: Operable , Coded Values: [0: False] , [1: True] )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter , Coded Values: [0: Unknown] , [-1: Other] , [1: 1] , ...29 more... )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• ApproximateInstallYear ( type: esriFieldTypeInteger, alias: Approximate Install Year, editable: true, nullable: true, defaultValue: null, modelName: ApproximateInstallYear )
• ValveMake ( type: esriFieldTypeString, alias: Valve Make, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ValveMake )
• HydrantFlag ( type: esriFieldTypeSmallInteger, alias: Hydrant Flag, editable: true, nullable: true, defaultValue: null, modelName: HydrantFlag )
• ByPassValve ( type: esriFieldTypeSmallInteger, alias: Bypass Valve, editable: true, nullable: true, defaultValue: null, modelName: ByPassValve )
• Depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: Depth )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• Motorized ( type: esriFieldTypeSmallInteger, alias: Motorized, editable: true, nullable: true, defaultValue: null, modelName: Motorized , Coded Values: [0: False] , [1: True] )
• Rotation ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: Rotation )
• TurnsToClose ( type: esriFieldTypeInteger, alias: Turns To Close, editable: true, nullable: true, defaultValue: null, modelName: TurnsToClose )
• ClockwiseToClose ( type: esriFieldTypeSmallInteger, alias: Clockwise To Close, editable: true, nullable: true, defaultValue: null, modelName: ClockwiseToClose )
• NormallyOpen ( type: esriFieldTypeSmallInteger, alias: Normally Open, editable: true, nullable: true, defaultValue: null, modelName: NormallyOpen )
• CurrentlyOpen ( type: esriFieldTypeSmallInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: null, modelName: CurrentlyOpen )
• PercentOpen ( type: esriFieldTypeInteger, alias: Percent Open, editable: true, nullable: true, defaultValue: null, modelName: PercentOpen )
• PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PressureZone )
• PressureSetting ( type: esriFieldTypeString, alias: Pressure Setting, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PressureSetting )
• RegulationType ( type: esriFieldTypeString, alias: Regulation Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RegulationType )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• GPSDate ( type: esriFieldTypeDate, alias: GPS Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDate )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• HyperlinkStreet ( type: esriFieldTypeString, alias: Hyperlink Street, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HyperlinkStreet )
• HyperlinkWeb ( type: esriFieldTypeString, alias: Hyperlink Web, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HyperlinkWeb )
• HyperlinkLocal ( type: esriFieldTypeString, alias: Hyperlink Local, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HyperlinkLocal )
• LinkCheck ( type: esriFieldTypeString, alias: LinkCheck, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LinkCheck )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• LucityLink ( type: esriFieldTypeInteger, alias: LucityLink, editable: true, nullable: true, defaultValue: null, modelName: LucityLink )
• InLucity ( type: esriFieldTypeSmallInteger, alias: InLucity, editable: true, nullable: true, defaultValue: null, modelName: InLucity )
• CreatedDate ( type: esriFieldTypeDate, alias: Created Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Editor )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: NBGIS.DBO.wValve
  Description:
  Prototype:
  Editor: null
  EditDate: null
  FACILITYID: null
  PERMITID: null
  LEGACYID: null
  Street: null
  Municipality: null
  LocationDescription: null
  Status: null
  WaterSubtype: null
  WaterSubtypeNumber: null
  WaterType: null
  Operable: null
  Diameter: null
  InstallDate: null
  ApproximateInstallYear: null
  ValveMake: null
  HydrantFlag: null
  ByPassValve: null
  Depth: null
  Elevation: null
  Motorized: null
  Rotation: null
  TurnsToClose: null
  ClockwiseToClose: null
  NormallyOpen: null
  CurrentlyOpen: null
  PercentOpen: null
  PressureZone: null
  PressureSetting: null
  RegulationType: null
  Comments: null
  GPSDate: null
  Latitude: null
  Longitude: null
  HyperlinkStreet: null
  HyperlinkWeb: null
  HyperlinkLocal: null
  LinkCheck: null
  ENABLED: 1
  LucityLink: null
  InLucity: null
  CreatedDate: null
  Creator: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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