View In:   ArcGIS Online Map Viewer

Name: utilities.SDE.wServiceConnection

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This layer depicts water meter locations within the service area of Bay County Utility Services. The basis for this layer is customer billing information that has been geocoded using county address point data. The water meter locations depicted should be considered approximate and do not represent the actual physical meter location, unless otherwise noted in the feature attributes.

Service Item Id: a18a21b4b2f841b0a5c437f321f67157

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: false

Supports Datum Transformation: true

Extent:

XMin: -9574919.409332868
YMin: 3496881.61507034
XMax: -9510001.658290384
YMax: 3554609.4119997914
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [163, 14, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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

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 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: Yes, modelName: METSERVICE )
• SERVICETYPE ( type: esriFieldTypeString, alias: Service Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERVICETYPE , Coded Values: [Domestic: Domestic] , [Commercial: Commercial] , [Industrial: Industrial] , ...7 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 )
• 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: null, modelName: OWNEDBY , Coded Values: [-1: Private] , [-2: Other] , [1: Bay County] , ...15 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: MAINTBY , Coded Values: [-1: Private] , [-2: Other] , [1: Bay County] , ...15 more... )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CREATOR ( type: esriFieldTypeString, alias: CREATOR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CREATOR )
• CREATE_DATE ( type: esriFieldTypeDate, alias: CREATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATE_DATE )
• LAST_EDITOR ( type: esriFieldTypeString, alias: LAST_EDITOR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITOR )
• LAST_EDIT_DATE ( type: esriFieldTypeDate, alias: LAST_EDIT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDIT_DATE )
• ROUTE ( type: esriFieldTypeSmallInteger, alias: Route, editable: true, nullable: true, defaultValue: null, modelName: ROUTE )
• SERVADDNUM ( type: esriFieldTypeInteger, alias: Service Address Number, editable: true, nullable: true, defaultValue: null, modelName: SERVADDNUM )
• SERVADDSTREET ( type: esriFieldTypeString, alias: Service Address Street, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SERVADDSTREET )
• SERVADDUNIT ( type: esriFieldTypeString, alias: Service Address Unit, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SERVADDUNIT )
• SERVADDCITY ( type: esriFieldTypeString, alias: Service Address City, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SERVADDCITY )
• REGISTERNUM ( type: esriFieldTypeString, alias: Register Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REGISTERNUM )
• SERIALNUM ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SERIALNUM )
• MAKE ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAKE )
• MODEL ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODEL )
• METERSIZE ( type: esriFieldTypeDouble, alias: Meter Size, editable: true, nullable: true, defaultValue: null, modelName: METERSIZE )
• MXUID ( type: esriFieldTypeString, alias: MXU ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MXUID )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WATERTYPE )
• WHOLEID ( type: esriFieldTypeString, alias: Wholesale ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WHOLEID )
• WHOLERECIP ( type: esriFieldTypeString, alias: Wholesale Recipient, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WHOLERECIP )
• LOCATEDBY ( type: esriFieldTypeString, alias: Located By, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LOCATEDBY )
• NORTHING ( type: esriFieldTypeDouble, alias: Northing, editable: true, nullable: true, defaultValue: null, modelName: NORTHING )
• EASTING ( type: esriFieldTypeDouble, alias: Easting, editable: true, nullable: true, defaultValue: null, modelName: EASTING )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• GPSTIMESTAMP ( type: esriFieldTypeDate, alias: GPS Timestamp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSTIMESTAMP )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: NOTES )
• CarteID ( type: esriFieldTypeString, alias: CarteID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CarteID )
• 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 )

Templates:

• Name: utilities.SDE.wServiceConnection
  Description:
  Prototype:
  NOTES: null
  CarteID: null
  FACILITYID: null
  ACCOUNTID: null
  METSERVICE: Yes
  SERVICETYPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  LOCATIONID: null
  CRITICAL: 0
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  GPSTIMESTAMP: null
  CREATOR: null
  CREATE_DATE: null
  LAST_EDITOR: null
  LAST_EDIT_DATE: null
  ROUTE: null
  SERVADDNUM: null
  SERVADDSTREET: null
  SERVADDUNIT: null
  SERVADDCITY: null
  REGISTERNUM: null
  SERIALNUM: null
  MAKE: null
  MODEL: null
  METERSIZE: null
  MXUID: null
  WATERTYPE: null
  WHOLEID: null
  WHOLERECIP: null
  LOCATEDBY: null
  NORTHING: null
  EASTING: null
  ELEVATION: 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

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: false

Supports Coordinates Quantization: true

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