Name: wtrSAPMeter

Display Field: mtrserial

Type: Table

Geometry Type: N/A

Description:

Service Item Id: eef310124b8f4299aae27a1d5f4bcb8d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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 ( modelName: OBJECTID, nullable: false, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeInteger )
• devicecat ( modelName: devicecat, nullable: true, editable: true, defaultValue: null, length: 24, alias: DeviceCat, type: esriFieldTypeString )
• equipnum ( modelName: equipnum, nullable: true, editable: true, defaultValue: null, length: 15, alias: Unique Identifier, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 12, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 12, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• objectid_1 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID_1, alias: OBJECTID_1 )
• mtrserial ( modelName: mtrserial, nullable: true, editable: true, defaultValue: null, length: 15, alias: MtrSerial, type: esriFieldTypeString )
• premnum ( modelName: premnum, nullable: true, editable: true, defaultValue: null, length: 15, alias: PremNum, type: esriFieldTypeString )
• mtrservid ( modelName: mtrservid, nullable: true, editable: true, defaultValue: null, length: 16, alias: MtrServID, type: esriFieldTypeString )
• mtrmanuf ( modelName: MtrManuf, nullable: true, editable: true, defaultValue: null, length: 25, alias: MtrManuf, type: esriFieldTypeString , Coded Values: [A_American: A_American] , [B_Badger: B_Badger] , [C_Carlon: C_Carlon] , ...14 more... )
• mtrmodel ( modelName: mtrmodel, nullable: true, editable: true, defaultValue: null, length: 25, alias: MtrModel, type: esriFieldTypeString )
• mtrsize ( modelName: MtrSize, nullable: true, editable: true, defaultValue: null, length: 6, alias: MtrSize, type: esriFieldTypeString , Coded Values: [3/4": 3/4"] , [5/8": 5/8"] , [1": 1"] , ...10 more... )
• mtrstatus ( modelName: MtrStatus, nullable: true, editable: true, defaultValue: null, length: 4, alias: MtrStatus, type: esriFieldTypeString , Coded Values: [AVLB: AVLB] , [DLFL: DLFL] , [ESTO: ESTO] , ...2 more... )
• stkrmloca ( modelName: stkrmloca, nullable: true, editable: true, defaultValue: null, length: 25, alias: StkRmLoca, type: esriFieldTypeString )
• low ( modelName: low, nullable: true, editable: true, defaultValue: null, alias: Low, type: esriFieldTypeDouble )
• med ( modelName: med, nullable: true, editable: true, defaultValue: null, alias: Med, type: esriFieldTypeDouble )
• high ( modelName: high, nullable: true, editable: true, defaultValue: null, alias: High, type: esriFieldTypeDouble )
• pipematcs ( modelName: pipematcs, nullable: true, editable: true, defaultValue: null, alias: PipeMatCS, type: esriFieldTypeInteger )
• mtrlat ( modelName: mtrlat, nullable: true, editable: true, defaultValue: null, alias: MtrLat, type: esriFieldTypeDouble )
• mtrlong ( modelName: mtrlong, nullable: true, editable: true, defaultValue: null, alias: MtrLong, type: esriFieldTypeDouble )
• manufdate ( modelName: manufdate, nullable: true, editable: true, defaultValue: null, length: 29, alias: ManufDate, type: esriFieldTypeDate )
• receiveddt ( modelName: receiveddt, nullable: true, editable: true, defaultValue: null, length: 29, alias: ReceivedDt, type: esriFieldTypeDate )
• installdt ( modelName: installdt, nullable: true, editable: true, defaultValue: null, length: 29, alias: InstallDt, type: esriFieldTypeDate )
• warrntydt ( modelName: warrntydt, nullable: true, editable: true, defaultValue: null, length: 29, alias: WarrntyDt, type: esriFieldTypeDate )
• installnum ( modelName: InstallNum, nullable: true, editable: true, defaultValue: null, length: 20, alias: InstallNum, type: esriFieldTypeString )
• installtype ( modelName: installtype, nullable: true, editable: true, defaultValue: null, length: 20, alias: InstallType, type: esriFieldTypeString )
• ratecat ( modelName: ratecat, nullable: true, editable: true, defaultValue: null, length: 10, alias: RateCat, type: esriFieldTypeString )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: editdate, nullable: true, editable: false, defaultValue: null, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: null, length: 255, alias: Editor, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: globalid, type: esriFieldTypeGlobalID )

Templates:

• Name: wtrSAPMeter
  Description:
  Prototype:
  devicecat: null
  installtype: null
  receiveddt: null
  mtrmanuf: null
  equipnum: null
  mtrlat: null
  warrntydt: null
  med: null
  manufdate: null
  installdt: null
  high: null
  low: null
  mtrlong: null
  premnum: null
  mtrsize: null
  last_edited_date: null
  installnum: null
  mtrstatus: null
  created_user: null
  ratecat: null
  mtrservid: null
  mtrserial: null
  pipematcs: null
  last_edited_user: null
  mtrmodel: null
  stkrmloca: null
  created_date: null
  objectid: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Premise (0) -- Related To: Premise (37)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata