Name: Aerator

Display Field: assetname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1b5871ab16ca44f4968b04e4fcc8d95c

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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• assetid ( modelName: ASSETID_, nullable: true, editable: true, defaultValue: null, length: 100, alias: Asset ID , type: esriFieldTypeString )
• assetname ( modelName: ASSETNAME_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Asset Name , type: esriFieldTypeString )
• assettype ( modelName: ASSETTYPE_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset Type , type: esriFieldTypeString )
• assetowner ( modelName: ASSETOWNER_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset Owner , type: esriFieldTypeString , Coded Values: [Airports: Airports] , [HHSA: HHSA] , [Parks: Parks] , ...3 more... )
• legacyid ( modelName: LEGACYID_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Legacy ID , type: esriFieldTypeString )
• tagnumber ( modelName: TAGNUMBER_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tag Number , type: esriFieldTypeString )
• status ( modelName: STATUS_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Status , type: esriFieldTypeString , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Spare: Spare] )
• parentid ( modelName: PARENTID_, nullable: true, editable: true, defaultValue: null, length: 100, alias: Parent ID , type: esriFieldTypeString )
• startupdate ( modelName: STARTUPDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Startup Date , type: esriFieldTypeDate )
• warrantydate ( modelName: WARRANTYDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Warranty Date , type: esriFieldTypeDate )
• conditionscore ( modelName: CONDITIONSCORE_, nullable: true, editable: true, defaultValue: null, alias: Condition Score , type: esriFieldTypeSmallInteger )
• conditiondate ( modelName: CONDITIONDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Condition Date , type: esriFieldTypeDate )
• address ( modelName: ADDRESS_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Address , type: esriFieldTypeString )
• location ( modelName: LOCATION_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location , type: esriFieldTypeString )
• site ( modelName: SITE_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Site, type: esriFieldTypeString , Coded Values: [JUWWTP0019: Heise Park WWTP] , [PVWWTP0007: Pine Valley WWTP] , [SVWWPS0010: Rancho San Diego PS] , ...39 more... )
• manufacturer ( modelName: MANUFACTURER_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Manufacturer , type: esriFieldTypeString )
• manphone ( modelName: MANPHONE_, nullable: true, editable: true, defaultValue: null, length: 16, alias: Manufacturer Phone # , type: esriFieldTypeString )
• manwebsite ( modelName: MANWEBSITE_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Manufacturer Website , type: esriFieldTypeString )
• model ( modelName: MODEL_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Model , type: esriFieldTypeString )
• serialno ( modelName: SERIALNO_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Serial Number , type: esriFieldTypeString )
• vendor ( modelName: VENDOR_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Vendor , type: esriFieldTypeString )
• speclink ( modelName: SPECLINK_, nullable: true, editable: true, defaultValue: null, length: 64, alias: Spec Link , type: esriFieldTypeString )
• omlink ( modelName: OMLINK_, nullable: true, editable: true, defaultValue: null, length: 64, alias: O&M Link , type: esriFieldTypeString )
• system ( modelName: SYSTEM_, nullable: true, editable: true, defaultValue: null, length: 40, alias: System Designator , type: esriFieldTypeString , Coded Values: [Conveyance: Conveyance] , [Screening: Screening] , [Grit Removal: Grit Removal] , ...10 more... )
• lof ( modelName: LOF_, nullable: true, editable: true, defaultValue: null, alias: LoF Score , type: esriFieldTypeSmallInteger )
• cof ( modelName: COF_, nullable: true, editable: true, defaultValue: null, alias: CoF Score , type: esriFieldTypeSmallInteger )
• risk ( modelName: RISK_, nullable: true, editable: true, defaultValue: null, alias: Risk Score , type: esriFieldTypeSmallInteger )
• criticality ( modelName: CRITICALITY_, nullable: true, editable: true, defaultValue: null, length: 16, alias: Criticality , type: esriFieldTypeString , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• replacevalue ( modelName: REPLACEVALUE_, nullable: true, editable: true, defaultValue: null, alias: Replacement Value , type: esriFieldTypeDouble )
• valuedate ( modelName: VALUEDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Valuation Date , type: esriFieldTypeDate )
• notes ( modelName: NOTES_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes, type: esriFieldTypeString )
• creator ( modelName: CREATOR_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Creator , type: esriFieldTypeString )
• createdate ( modelName: CREATEDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Created , type: esriFieldTypeDate )
• editor ( modelName: EDITOR_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Editor , type: esriFieldTypeString )
• editdate ( modelName: EDITDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Edited , type: esriFieldTypeDate )
• aertype ( modelName: AERTYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Type, type: esriFieldTypeString , Coded Values: [Surface Mechanical: Surface Mechanical] , [Other: Other] )
• float ( modelName: FLOAT, nullable: true, editable: true, defaultValue: null, length: 30, alias: Float, type: esriFieldTypeString , Coded Values: [Fiberglass: Fiberglass] , [316 SS: 316 SS] , [304 SS: 304 SS] , ...2 more... )
• sealtype ( modelName: SEALTYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Seal Type, type: esriFieldTypeString , Coded Values: [Mechanical: Mechanical] , [Packing: Packing] )
• greasetype ( modelName: GREASETYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Lubrication, Grease, type: esriFieldTypeString , Coded Values: [Oil: Oil] , [Grease: Grease] )
• oiltype ( modelName: OILTYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Lubrication, Oil, type: esriFieldTypeString , Coded Values: [Oil: Oil] , [Grease: Grease] )
• numimpellervanes ( modelName: NUMIMPELLERVANES, nullable: true, editable: true, defaultValue: null, alias: Number of Impeller Vanes, type: esriFieldTypeSmallInteger )
• impellermat ( modelName: IMPELLERMAT, nullable: true, editable: true, defaultValue: null, length: 30, alias: Impeller Material, type: esriFieldTypeString , Coded Values: [304 SS 304 SS 304 SS 304 SS: 304 SS 304 SS 304 SS 304 SS] , [316 SS: 316 SS] , [Other: Other] )
• rotationdir ( modelName: ROTATIONDIR, nullable: true, editable: true, defaultValue: null, length: 30, alias: Rotation, type: esriFieldTypeString , Coded Values: [Clockwise: Clockwise] , [Counter-Clockwise: Counter-Clockwise] )
• drivetype ( modelName: DRIVETYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: DRIVETYPE, type: esriFieldTypeString , Coded Values: [Direct: Direct] , [Belt: Belt] , [Gear: Gear] , ...1 more... )
• couplingtype ( modelName: COUPLINGTYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Coupling Type, type: esriFieldTypeString )
• couplingmodel ( modelName: COUPLINGMODEL, nullable: true, editable: true, defaultValue: null, length: 30, alias: Coupling Model, type: esriFieldTypeString )
• couplingsize ( modelName: COUPLINGSIZE, nullable: true, editable: true, defaultValue: null, alias: COUPLINGSIZE, type: esriFieldTypeDouble )
• impellerdiam ( modelName: IMPELLERDIAM, nullable: true, editable: true, defaultValue: null, alias: IMPELLERDIAM, type: esriFieldTypeDouble )
• impellersleevediam ( modelName: IMPELLERSLEEVEDIAM, nullable: true, editable: true, defaultValue: null, alias: IMPELLERSLEEVEDIAM, type: esriFieldTypeDouble )
• suctiondiam ( modelName: SUCTIONDIAM, nullable: true, editable: true, defaultValue: null, alias: SUCTIONDIAM, type: esriFieldTypeDouble )
• servicelife ( modelName: SERVICELIFE_, nullable: true, editable: true, defaultValue: null, alias: Service Life , type: esriFieldTypeSmallInteger )
• rpm ( modelName: RPM, nullable: true, editable: true, defaultValue: null, alias: Rotations per Minute, type: esriFieldTypeSmallInteger )
• cablemooring ( modelName: CABLEMOORING, nullable: true, editable: true, defaultValue: null, alias: Cable Mooring, type: esriFieldTypeSmallInteger )
• flowrate ( modelName: FLOWRATE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Flow Rate, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: globalid )

Templates:

• Name: Aerator
  Description:
  Prototype:
  notes: null
  criticality: null
  createdate: null
  assetname: null
  replacevalue: null
  flowrate: null
  float: null
  greasetype: null
  cablemooring: null
  assetowner: null
  model: null
  aertype: null
  sealtype: null
  rotationdir: null
  conditionscore: null
  conditiondate: null
  couplingsize: null
  startupdate: null
  oiltype: null
  suctiondiam: null
  servicelife: null
  impellersleevediam: null
  tagnumber: null
  system: null
  couplingmodel: null
  legacyid: null
  editdate: null
  status: null
  lof: null
  omlink: null
  parentid: null
  manufacturer: null
  serialno: null
  impellermat: null
  speclink: null
  drivetype: null
  couplingtype: null
  vendor: null
  warrantydate: null
  assettype: null
  editor: null
  creator: null
  address: null
  rpm: null
  manwebsite: null
  numimpellervanes: null
  site: null
  assetid: null
  manphone: null
  location: null
  risk: null
  impellerdiam: null
  cof: null
  valuedate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PumpUnit (3) -- Related To: Pump Unit (45)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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