View In:   ArcGIS Online Map Viewer

Name: Service Connections

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 9705b0f073b442788bbea7cd3443ce72

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: 1755797.5241363049
YMin: 347157.1178123057
XMax: 1775660.7048823088
YMax: 369843.6656149775
Spatial Reference: 102749  (2286)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• ACCOUNTID ( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ACCOUNTID )
• METSERVICE ( type: esriFieldTypeString, alias: Metered Service, editable: true, nullable: true, length: 5, defaultValue: null, modelName: METSERVICE , Coded Values: [Y: Yes] , [N: No] )
• SERVICETYPE ( type: esriFieldTypeString, alias: Service Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERVICETYPE , Coded Values: [Domestic: Domestic] , [Commercial: Commercial] , [Industrial: Industrial] , ...3 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• LOCATIONID ( type: esriFieldTypeString, alias: Location Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LOCATIONID )
• CRITICAL ( type: esriFieldTypeSmallInteger, alias: CriticalCustomer, editable: true, nullable: true, defaultValue: 0, modelName: CRITICAL , Coded Values: [0: False] , [1: True] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• ActivityID ( type: esriFieldTypeString, alias: ActivityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ActivityID )
• LastActivity ( type: esriFieldTypeString, alias: LastActivity, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LastActivity , Coded Values: [UPDT: Update Information] , [READ: Meter Read] , [INST: New Installation] , ...7 more... )
• DateStamp ( type: esriFieldTypeDate, alias: DateStamp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateStamp )
• ComputerName ( type: esriFieldTypeString, alias: ComputerName, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ComputerName )
• OperatedBy ( type: esriFieldTypeString, alias: OperatedBy, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OperatedBy )
• ServiceNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ServiceNumber )
• MeterNumber ( type: esriFieldTypeString, alias: MeterNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MeterNumber )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SerialNumber )
• FireService ( type: esriFieldTypeString, alias: FireService, editable: true, nullable: true, length: 1, defaultValue: null, modelName: FireService , Coded Values: [Y: Yes] , [N: No] )
• MeterSize ( type: esriFieldTypeDouble, alias: MeterSize, editable: true, nullable: true, defaultValue: null, modelName: MeterSize , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...27 more... )
• PreviousReading ( type: esriFieldTypeDouble, alias: PreviousReading, editable: true, nullable: true, defaultValue: null, modelName: PreviousReading )
• PresentReadOld ( type: esriFieldTypeDouble, alias: PresentReadOld, editable: true, nullable: true, defaultValue: null, modelName: PresentReadOld )
• PresentReadNew ( type: esriFieldTypeDouble, alias: PresentReadNew, editable: true, nullable: true, defaultValue: null, modelName: PresentReadNew )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Remarks )
• Name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Name )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Address )
• InstalledandReadBy ( type: esriFieldTypeString, alias: InstalledandReadBy, editable: true, nullable: true, length: 30, defaultValue: null, modelName: InstalledandReadBy )
• EnteredBy ( type: esriFieldTypeString, alias: EnteredBy, editable: true, nullable: true, length: 30, defaultValue: null, modelName: EnteredBy )
• ReasonforoffRead ( type: esriFieldTypeString, alias: ReasonforoffRead, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ReasonforoffRead )
• OpTime ( type: esriFieldTypeString, alias: OpTime, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OpTime )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status )
• PurchaseDate ( type: esriFieldTypeDate, alias: PurchaseDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PurchaseDate )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• RegisterType ( type: esriFieldTypeString, alias: RegisterType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RegisterType )
• RegisterID ( type: esriFieldTypeDouble, alias: RegisterID, editable: true, nullable: true, defaultValue: null, modelName: RegisterID )
• ReadType ( type: esriFieldTypeString, alias: ReadType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReadType )
• RegisterPurchaseDate ( type: esriFieldTypeDate, alias: RegisterPurchaseDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RegisterPurchaseDate )
• AMRType ( type: esriFieldTypeString, alias: Tested, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AMRType )
• InterfaceNumber ( type: esriFieldTypeString, alias: InterfaceNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InterfaceNumber )
• PortNumber ( type: esriFieldTypeString, alias: PortNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PortNumber )
• MXUInstallDate ( type: esriFieldTypeDate, alias: MXUInstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MXUInstallDate )
• PortType ( type: esriFieldTypeString, alias: PortType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PortType )
• RemovalDate ( type: esriFieldTypeDate, alias: RemovalDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RemovalDate )
• AbandonedDate ( type: esriFieldTypeDate, alias: AbandonedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AbandonedDate )
• Crew ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Crew )
• RemovalComment ( type: esriFieldTypeString, alias: RemovalComment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RemovalComment )
• StandbyDate ( type: esriFieldTypeDate, alias: StandbyDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StandbyDate )
• OnEstDate ( type: esriFieldTypeDate, alias: OnEstDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OnEstDate )
• OnDate ( type: esriFieldTypeDate, alias: OnDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OnDate )
• StandbyRemark ( type: esriFieldTypeString, alias: StandbyRemark, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StandbyRemark )
• OldMeterNumber ( type: esriFieldTypeString, alias: OldMeterNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldMeterNumber )
• MaterialsUsed ( type: esriFieldTypeString, alias: MaterialsUsed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaterialsUsed )
• MeterMake ( type: esriFieldTypeString, alias: MeterMake, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MeterMake )
• RegisterNumber ( type: esriFieldTypeString, alias: RegisterNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RegisterNumber )
• MXUNumber ( type: esriFieldTypeString, alias: 520SPMXUNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MXUNumber )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitdue ( type: esriFieldTypeDouble, alias: Longitdue, editable: true, nullable: true, defaultValue: null, modelName: Longitdue )
• TWLBVBS ( type: esriFieldTypeString, alias: TWLBVBS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TWLBVBS )
• TWLBVSxS ( type: esriFieldTypeString, alias: TWLBVSxS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TWLBVSxS )
• mbxBrand ( type: esriFieldTypeString, alias: mbxBrand, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mbxBrand )
• mbxModelNumber ( type: esriFieldTypeString, alias: mbxModelNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mbxModelNumber )
• mbxLidType ( type: esriFieldTypeString, alias: mbxLidType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mbxLidType )
• mbxLocation ( type: esriFieldTypeString, alias: mbxLocation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: mbxLocation )
• mbxLocationDirection ( type: esriFieldTypeString, alias: mbxLocationDirection, editable: true, nullable: true, length: 2, defaultValue: null, modelName: mbxLocationDirection )
• mbxLocationSize ( type: esriFieldTypeDouble, alias: mbxLocationSize, editable: true, nullable: true, defaultValue: null, modelName: mbxLocationSize )
• mbxLocationMaterial ( type: esriFieldTypeString, alias: mbxLocationMaterial, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mbxLocationMaterial )
• TapSize ( type: esriFieldTypeDouble, alias: TapSize, editable: true, nullable: true, defaultValue: null, modelName: TapSize )
• TapBrand ( type: esriFieldTypeString, alias: TapBrand, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TapBrand )
• TapDepth ( type: esriFieldTypeDouble, alias: TapDepth, editable: true, nullable: true, defaultValue: null, modelName: TapDepth )
• ServiceSize ( type: esriFieldTypeDouble, alias: ServiceSize, editable: true, nullable: true, defaultValue: null, modelName: ServiceSize )
• ServiceDepth ( type: esriFieldTypeDouble, alias: ServiceDepth, editable: true, nullable: true, defaultValue: null, modelName: ServiceDepth )
• ServiceLength ( type: esriFieldTypeDouble, alias: ServiceLength, editable: true, nullable: true, defaultValue: null, modelName: ServiceLength )
• ServiceLineType ( type: esriFieldTypeString, alias: ServiceLineType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ServiceLineType )
• ExistingService ( type: esriFieldTypeString, alias: ExistingService, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ExistingService )
• NewService ( type: esriFieldTypeString, alias: NewService, editable: true, nullable: true, length: 1, defaultValue: null, modelName: NewService )
• RepairService ( type: esriFieldTypeString, alias: RepairService, editable: true, nullable: true, length: 1, defaultValue: null, modelName: RepairService )
• MeterRepair ( type: esriFieldTypeString, alias: MeterRepair, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MeterRepair )
• MeterTesting ( type: esriFieldTypeString, alias: MeterTesting, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MeterTesting )
• RegisterChange ( type: esriFieldTypeString, alias: RegisterChange, editable: true, nullable: true, length: 1, defaultValue: null, modelName: RegisterChange )
• MXUSPChange ( type: esriFieldTypeString, alias: MXUSPChange, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MXUSPChange )
• MeterChange ( type: esriFieldTypeString, alias: MeterChange, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MeterChange )
• Residential ( type: esriFieldTypeString, alias: Residential, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Residential )
• Commercial ( type: esriFieldTypeString, alias: Commercial, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Commercial )
• TapType ( type: esriFieldTypeString, alias: TapType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TapType )
• PreviousMake ( type: esriFieldTypeString, alias: PreviousMake, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PreviousMake )
• PreviousSize ( type: esriFieldTypeString, alias: PreviousSize, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PreviousSize )
• TWLBVOS ( type: esriFieldTypeString, alias: TWLBVOS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TWLBVOS )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Service Connections
  Description:
  Prototype:
  TWLBVOS: null
  FACILITYID: null
  ACCOUNTID: null
  METSERVICE: null
  SERVICETYPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  LOCATIONID: null
  CRITICAL: 0
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  ActivityID: null
  LastActivity: null
  DateStamp: null
  ComputerName: null
  OperatedBy: null
  ServiceNumber: null
  MeterNumber: null
  SerialNumber: null
  FireService: null
  MeterSize: null
  PreviousReading: null
  PresentReadOld: null
  PresentReadNew: null
  Remarks: null
  Name: null
  Address: null
  InstalledandReadBy: null
  EnteredBy: null
  ReasonforoffRead: null
  OpTime: null
  Manufacturer: null
  Model: null
  Status: null
  PurchaseDate: null
  Comments: null
  RegisterType: null
  RegisterID: null
  ReadType: null
  RegisterPurchaseDate: null
  AMRType: null
  InterfaceNumber: null
  PortNumber: null
  MXUInstallDate: null
  PortType: null
  RemovalDate: null
  AbandonedDate: null
  Crew: null
  RemovalComment: null
  StandbyDate: null
  OnEstDate: null
  OnDate: null
  StandbyRemark: null
  OldMeterNumber: null
  MaterialsUsed: null
  MeterMake: null
  RegisterNumber: null
  MXUNumber: null
  Latitude: null
  Longitdue: null
  TWLBVBS: null
  TWLBVSxS: null
  mbxBrand: null
  mbxModelNumber: null
  mbxLidType: null
  mbxLocation: null
  mbxLocationDirection: null
  mbxLocationSize: null
  mbxLocationMaterial: null
  TapSize: null
  TapBrand: null
  TapDepth: null
  ServiceSize: null
  ServiceDepth: null
  ServiceLength: null
  ServiceLineType: null
  ExistingService: null
  NewService: null
  RepairService: null
  MeterRepair: null
  MeterTesting: null
  RegisterChange: null
  MXUSPChange: null
  MeterChange: null
  Residential: null
  Commercial: null
  TapType: null
  PreviousMake: null
  PreviousSize: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata