View In:   ArcGIS Online Map Viewer

Name: NBGIS.DBO.wFitting

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: 795044.9452726394
YMin: 2677513.4136043936
XMax: 819853.2339105606
YMax: 2747580.43193464
Spatial Reference: 102686  (2249)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [38, 142, 76, 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 )
• LEGACYID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LEGACYID )
• PERMITID ( type: esriFieldTypeString, alias: Permit ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PERMITID )
• 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 )
• LocationDescription ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LocationDescription )
• OwnedBy ( type: esriFieldTypeString, alias: Owned By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnedBy , Coded Values: [PRV: Private] , [STT: State] , [OTH: Other] , ...5 more... )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintainedBy , Coded Values: [PRV: Private] , [STT: State] , [OTH: Other] , ...5 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: 100, defaultValue: null, modelName: WaterSubtype )
• WaterSubtypeno ( type: esriFieldTypeInteger, alias: Water Subtype Number, editable: true, nullable: true, defaultValue: null, modelName: WaterSubtypeno )
• Diameter1 ( type: esriFieldTypeDouble, alias: Diameter 1, editable: true, nullable: true, defaultValue: null, modelName: Diameter1 , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...28 more... )
• Diameter2 ( type: esriFieldTypeDouble, alias: Diameter 2, editable: true, nullable: true, defaultValue: null, modelName: Diameter2 )
• Diameter3 ( type: esriFieldTypeDouble, alias: Diameter 3, editable: true, nullable: true, defaultValue: null, modelName: Diameter3 )
• Diameter4 ( type: esriFieldTypeDouble, alias: Diameter 4, editable: true, nullable: true, defaultValue: null, modelName: Diameter4 )
• DiameterDescription ( type: esriFieldTypeString, alias: Diameter Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DiameterDescription )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Material )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• ApproxInstallYear ( type: esriFieldTypeInteger, alias: Approximate Install Year, editable: true, nullable: true, defaultValue: null, modelName: ApproxInstallYear )
• JointType ( type: esriFieldTypeString, alias: JointType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: JointType )
• PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PressureZone )
• Depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: Depth )
• HydrantLatFlag ( type: esriFieldTypeSmallInteger, alias: Hydrant Lat Flag, editable: true, nullable: true, defaultValue: null, modelName: HydrantLatFlag )
• 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 )
• HyperlinkLocal ( type: esriFieldTypeString, alias: Hyperlink Local, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HyperlinkLocal )
• HyperlinkWeb ( type: esriFieldTypeString, alias: Hyperlink Web, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HyperlinkWeb )
• LinkCheck ( type: esriFieldTypeString, alias: Link Check, editable: true, nullable: true, length: 5, 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.wFitting
  Description:
  Prototype:
  Editor: null
  EditDate: null
  FACILITYID: null
  LEGACYID: null
  PERMITID: null
  Street: null
  Municipality: null
  LocationDescription: null
  OwnedBy: null
  MaintainedBy: null
  Status: null
  WaterSubtype: null
  WaterSubtypeno: null
  Diameter1: null
  Diameter2: null
  Diameter3: null
  Diameter4: null
  DiameterDescription: null
  Material: null
  InstallDate: null
  ApproxInstallYear: null
  JointType: null
  PressureZone: null
  Depth: null
  HydrantLatFlag: null
  Comments: null
  GPSDate: null
  Latitude: null
  Longitude: null
  HyperlinkStreet: null
  HyperlinkLocal: null
  HyperlinkWeb: 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