Name: SDE.MunisUBData

Display Field: FULLNAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ACCOUNTID ( type: esriFieldTypeString, alias: ACCOUNTID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ACCOUNTID )
• CUSTOMERID ( type: esriFieldTypeInteger, alias: CUSTOMERID, editable: true, nullable: true, defaultValue: null, modelName: CUSTOMERID )
• METERSN ( type: esriFieldTypeString, alias: METERSN, editable: true, nullable: true, length: 15, defaultValue: null, modelName: METERSN )
• TRANSPONDERSN ( type: esriFieldTypeString, alias: TRANSPONDERSN, editable: true, nullable: true, length: 15, defaultValue: null, modelName: TRANSPONDERSN )
• REGISTERSN ( type: esriFieldTypeString, alias: REGISTERSN, editable: true, nullable: true, length: 15, defaultValue: null, modelName: REGISTERSN )
• MeterId ( type: esriFieldTypeInteger, alias: MeterId, editable: true, nullable: true, defaultValue: null, modelName: MeterId )
• SERVICEID ( type: esriFieldTypeInteger, alias: SERVICEID, editable: true, nullable: true, defaultValue: null, modelName: SERVICEID )
• COMPOUNDKEY ( type: esriFieldTypeInteger, alias: COMPOUNDKEY, editable: true, nullable: true, defaultValue: null, modelName: COMPOUNDKEY )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 1, defaultValue: null, modelName: STATUS )
• BILLINGCYCLE ( type: esriFieldTypeSmallInteger, alias: BILLINGCYCLE, editable: true, nullable: true, defaultValue: null, modelName: BILLINGCYCLE )
• SEQUENCE ( type: esriFieldTypeInteger, alias: SEQUENCE, editable: true, nullable: true, defaultValue: null, modelName: SEQUENCE )
• ROUTE ( type: esriFieldTypeString, alias: ROUTE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ROUTE )
• PREVIOUSREAD ( type: esriFieldTypeInteger, alias: PREVIOUSREAD, editable: true, nullable: true, defaultValue: null, modelName: PREVIOUSREAD )
• PREVIOUSREADDATE ( type: esriFieldTypeDate, alias: PREVIOUSREADDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PREVIOUSREADDATE )
• ServiceStopDate ( type: esriFieldTypeDate, alias: ServiceStopDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ServiceStopDate )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• INSTALLYEAR ( type: esriFieldTypeInteger, alias: INSTALLYEAR, editable: true, nullable: true, defaultValue: null, modelName: INSTALLYEAR )
• FLOWTYPE ( type: esriFieldTypeString, alias: FLOWTYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: FLOWTYPE )
• SIZE ( type: esriFieldTypeString, alias: SIZE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SIZE )
• PHYSICALADDRESS ( type: esriFieldTypeString, alias: PHYSICALADDRESS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PHYSICALADDRESS )
• FULLNAME ( type: esriFieldTypeString, alias: FULLNAME, editable: true, nullable: true, length: 64, defaultValue: null, modelName: FULLNAME )
• PHONENUMBER ( type: esriFieldTypeString, alias: PHONENUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PHONENUMBER )
• EMAILADDRESS ( type: esriFieldTypeString, alias: EMAILADDRESS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: EMAILADDRESS )
• BILLINGADDRESS ( type: esriFieldTypeString, alias: BILLINGADDRESS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: BILLINGADDRESS )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 65, defaultValue: null, modelName: Notes )
• BILLED4WATER ( type: esriFieldTypeInteger, alias: BILLED4WATER, editable: true, nullable: true, defaultValue: null, modelName: BILLED4WATER )
• BILLED4SEWER ( type: esriFieldTypeInteger, alias: BILLED4SEWER, editable: true, nullable: true, defaultValue: null, modelName: BILLED4SEWER )
• BILLED4REFUSE ( type: esriFieldTypeInteger, alias: BILLED4REFUSE, editable: true, nullable: true, defaultValue: null, modelName: BILLED4REFUSE )
• BILLED4BULKMETER ( type: esriFieldTypeInteger, alias: BILLED4BULKMETER, editable: true, nullable: true, defaultValue: null, modelName: BILLED4BULKMETER )
• BILLED4REFUSETAX ( type: esriFieldTypeInteger, alias: BILLED4REFUSETAX, editable: true, nullable: true, defaultValue: null, modelName: BILLED4REFUSETAX )
• BILLED4STORMWATER ( type: esriFieldTypeInteger, alias: BILLED4STORMWATER, editable: true, nullable: true, defaultValue: null, modelName: BILLED4STORMWATER )
• RowID ( type: esriFieldTypeString, alias: RowID, editable: true, nullable: true, length: 31, defaultValue: null, modelName: RowID )

Templates:

• Name: SDE.MunisUBData
  Description:
  Prototype:
  BILLED4STORMWATER: null
  RowID: null
  ACCOUNTID: null
  CUSTOMERID: null
  METERSN: null
  TRANSPONDERSN: null
  REGISTERSN: null
  MeterId: null
  SERVICEID: null
  COMPOUNDKEY: null
  STATUS: null
  BILLINGCYCLE: null
  SEQUENCE: null
  ROUTE: null
  PREVIOUSREAD: null
  PREVIOUSREADDATE: null
  ServiceStopDate: null
  INSTALLDATE: null
  INSTALLYEAR: null
  FLOWTYPE: null
  SIZE: null
  PHYSICALADDRESS: null
  FULLNAME: null
  PHONENUMBER: null
  EMAILADDRESS: null
  BILLINGADDRESS: null
  Notes: null
  BILLED4WATER: null
  BILLED4SEWER: null
  BILLED4REFUSE: null
  BILLED4BULKMETER: null
  BILLED4REFUSETAX: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SDE.Meters (0) -- Related To: Water Meters (42)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata