Name: HYDRO_VW_LOGGER

Display Field: assetname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4b740a76bf9344b2b39c000a7cbbfd0f

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: true
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• smarttag ( modelName: SMARTTag, nullable: true, editable: true, defaultValue: null, length: 50, alias: SMARTTag, type: esriFieldTypeString )
• legacyid ( modelName: LegacyID, nullable: true, editable: true, defaultValue: null, length: 255, alias: LegacyID, type: esriFieldTypeString )
• assetname ( modelName: AssetName, nullable: true, editable: true, defaultValue: null, length: 125, alias: AssetName, type: esriFieldTypeString )
• assetdescription ( modelName: AssetDescription, nullable: true, editable: true, defaultValue: null, length: 125, alias: AssetDescription, type: esriFieldTypeString )
• manufacturer ( modelName: Manufacturer, nullable: true, editable: true, defaultValue: null, length: 100, alias: Manufacturer, type: esriFieldTypeString )
• modelnumber ( modelName: ModelNumber, nullable: true, editable: true, defaultValue: null, length: 200, alias: ModelNumber, type: esriFieldTypeString )
• serialnumber ( modelName: SerialNumber, nullable: true, editable: true, defaultValue: null, length: 200, alias: SerialNumber, type: esriFieldTypeString )
• assetsubtype ( modelName: AssetSubType, nullable: true, editable: true, defaultValue: null, length: 125, alias: AssetSubType, type: esriFieldTypeString )
• associatedequip ( modelName: AssociatedEquip, nullable: true, editable: true, defaultValue: null, length: 200, alias: AssociatedEquip, type: esriFieldTypeString )
• quantity ( modelName: Quantity, nullable: true, editable: true, defaultValue: null, alias: Quantity, type: esriFieldTypeDouble )
• material ( modelName: Material, nullable: true, editable: true, defaultValue: null, length: 50, alias: Material, type: esriFieldTypeString )
• size1 ( modelName: Size1, nullable: true, editable: true, defaultValue: null, length: 25, alias: Size1, type: esriFieldTypeString )
• unit1 ( modelName: Unit1, nullable: true, editable: true, defaultValue: null, length: 25, alias: Unit1, type: esriFieldTypeString )
• size2 ( modelName: Size2, nullable: true, editable: true, defaultValue: null, length: 25, alias: Size2, type: esriFieldTypeString )
• unit2 ( modelName: Unit2, nullable: true, editable: true, defaultValue: null, length: 25, alias: Unit2, type: esriFieldTypeString )
• size3 ( modelName: Size3, nullable: true, editable: true, defaultValue: null, length: 25, alias: Size3, type: esriFieldTypeString )
• unit3 ( modelName: Unit3, nullable: true, editable: true, defaultValue: null, length: 25, alias: Unit3, type: esriFieldTypeString )
• size4 ( modelName: Size4, nullable: true, editable: true, defaultValue: null, length: 25, alias: Size4, type: esriFieldTypeString )
• unit4 ( modelName: Unit4, nullable: true, editable: true, defaultValue: null, length: 25, alias: Unit4, type: esriFieldTypeString )
• installdate ( modelName: InstallDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: InstallDate, type: esriFieldTypeDate )
• warrantydate ( modelName: WarrantyDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: WarrantyDate, type: esriFieldTypeDate )
• site ( modelName: Site, nullable: true, editable: true, defaultValue: null, length: 50, alias: Site, type: esriFieldTypeString )
• sitealias ( modelName: SiteAlias, nullable: true, editable: true, defaultValue: null, length: 50, alias: SiteAlias, type: esriFieldTypeString )
• location ( modelName: Location, nullable: true, editable: true, defaultValue: null, length: 50, alias: Location, type: esriFieldTypeString )
• locationtype ( modelName: LocationType, nullable: true, editable: true, defaultValue: null, length: 100, alias: LocationType, type: esriFieldTypeString )
• usefullife_am ( modelName: UsefulLIfe_am, nullable: true, editable: true, defaultValue: null, alias: UsefulLIfe_am, type: esriFieldTypeDouble )
• condition ( modelName: Condition, nullable: true, editable: true, defaultValue: null, alias: Condition, type: esriFieldTypeDouble )
• conditioncomment ( modelName: ConditionComment, nullable: true, editable: true, defaultValue: null, length: 255, alias: ConditionComment, type: esriFieldTypeString )
• conditiondate ( modelName: ConditionDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ConditionDate, type: esriFieldTypeDate )
• pof ( modelName: POF, nullable: true, editable: true, defaultValue: null, alias: POF, type: esriFieldTypeDouble )
• cof ( modelName: COF, nullable: true, editable: true, defaultValue: null, alias: COF, type: esriFieldTypeDouble )
• bre ( modelName: BRE, nullable: true, editable: true, defaultValue: null, alias: BRE, type: esriFieldTypeDouble )
• replacementcost ( modelName: ReplacementCost, nullable: true, editable: true, defaultValue: null, alias: ReplacementCost, type: esriFieldTypeDouble )
• replacementcostvar ( modelName: ReplacementCostVar, nullable: true, editable: true, defaultValue: null, alias: ReplacementCostVar, type: esriFieldTypeDouble )
• lastrehabyear ( modelName: LastRehabYear, nullable: true, editable: true, defaultValue: null, alias: LastRehabYear, type: esriFieldTypeDouble )
• rehabfrequency1 ( modelName: RehabFrequency1, nullable: true, editable: true, defaultValue: null, alias: RehabFrequency1, type: esriFieldTypeDouble )
• rehabcost1 ( modelName: RehabCost1, nullable: true, editable: true, defaultValue: null, alias: RehabCost1, type: esriFieldTypeDouble )
• rehabfrequency2 ( modelName: RehabFrequency2, nullable: true, editable: true, defaultValue: null, alias: RehabFrequency2, type: esriFieldTypeDouble )
• rehabcost2 ( modelName: RehabCost2, nullable: true, editable: true, defaultValue: null, alias: RehabCost2, type: esriFieldTypeDouble )
• percentconsumed ( modelName: PercentConsumed, nullable: true, editable: true, defaultValue: null, alias: PercentConsumed, type: esriFieldTypeDouble )
• annualdepreciation ( modelName: AnnualDepreciation, nullable: true, editable: true, defaultValue: null, alias: AnnualDepreciation, type: esriFieldTypeDouble )
• lifecyclestatus ( modelName: LifecycleStatus, nullable: true, editable: true, defaultValue: null, length: 50, alias: LifecycleStatus, type: esriFieldTypeString )
• lastupdated ( modelName: LastUpdated, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LastUpdated, type: esriFieldTypeDate )
• lasteditor ( modelName: LastEditor, nullable: true, editable: true, defaultValue: null, length: 50, alias: LastEditor, type: esriFieldTypeString )
• comments ( modelName: Comments, nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• image_path ( modelName: Image_Path, nullable: true, editable: true, defaultValue: null, length: 255, alias: Image_Path, type: esriFieldTypeString )
• parentassetid ( modelName: ParentAssetID, nullable: true, editable: true, defaultValue: null, length: 50, alias: ParentAssetID, type: esriFieldTypeString )
• assetid ( modelName: AssetID, nullable: true, editable: true, defaultValue: null, length: 50, alias: AssetID, type: esriFieldTypeString )

Templates:

• Name: HYDRO_VW_LOGGER
  Description:
  Prototype:
  parentassetid: null
  smarttag: null
  rehabcost2: null
  installdate: null
  rehabcost1: null
  associatedequip: null
  pof: null
  lastrehabyear: null
  unit1: null
  assetname: null
  unit2: null
  assetsubtype: null
  unit3: null
  manufacturer: null
  lifecyclestatus: null
  assetdescription: null
  conditioncomment: null
  percentconsumed: null
  size3: null
  unit4: null
  bre: null
  size4: null
  size1: null
  size2: null
  replacementcostvar: null
  warrantydate: null
  replacementcost: null
  conditiondate: null
  rehabfrequency1: null
  quantity: null
  comments: null
  serialnumber: null
  rehabfrequency2: null
  sitealias: null
  lasteditor: null
  annualdepreciation: null
  site: null
  condition: null
  material: null
  usefullife_am: null
  assetid: null
  modelnumber: null
  image_path: null
  legacyid: null
  lastupdated: null
  location: null
  locationtype: null
  cof: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• gis_hydro_cmms_dev.DBO.WELL (10) -- Related To: HYDRO_WELL (21)

Capabilities: Query

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata