Layers:

Layer: Wells (0)

Name: Wells

Display Field: common_well_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 4b740a76bf9344b2b39c000a7cbbfd0f

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
XMin: 6435718.428639755
YMin: 1739112.048955813
XMax: 6561613.699158415
YMax: 1833119.4747857302
Spatial Reference: 102645  (2229)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID_1 )
• wrdid ( modelName: WRDID, nullable: true, editable: true, defaultValue: null, alias: WRDID, type: esriFieldTypeInteger )
• x ( modelName: X, nullable: true, editable: true, defaultValue: null, alias: X, type: esriFieldTypeDouble )
• y ( modelName: Y, nullable: true, editable: true, defaultValue: null, alias: Y, type: esriFieldTypeDouble )
• agency_short ( modelName: Agency_Short, nullable: true, editable: true, defaultValue: null, length: 25, alias: Agency_Short, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• cmms_well ( modelName: CMMS_Well, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CMMS_Well, type: esriFieldTypeString )
• well_zone ( modelName: Well_Zone, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Well_Zone, type: esriFieldTypeString )
• common_well_name ( modelName: Common_Well_Name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Common Well Name, type: esriFieldTypeString )
• f4_digit ( modelName: F4_digit, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: 4_digit, type: esriFieldTypeString )
• field ( modelName: field, nullable: true, editable: true, defaultValue: null, alias: Field, type: esriFieldTypeInteger )
• entityuid ( modelName: entityuid, nullable: true, editable: true, defaultValue: null, length: 255, alias: EntityUID, type: esriFieldTypeString )
Templates:
• Name: Wells
  Description:
  Prototype:
  cmms_well: null
  entityuid: null
  field: null
  wrdid: null
  f4_digit: null
  x: null
  y: null
  common_well_name: null
  well_zone: null
  agency_short: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• Hydro_Sites (0) -- Related To: Sites (1)

Layer: Sites (1)

Name: Sites

Display Field: hydrocmms_wells_cmms_well

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 4b740a76bf9344b2b39c000a7cbbfd0f

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
XMin: 6435668.428739741
YMin: 1739062.048727721
XMax: 6561663.6990584135
YMax: 1833169.4746857285
Spatial Reference: 102645  (2229)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [115, 178, 115, 255]
Outline:
N/A
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: true
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID_1 )
• hydrocmms_wells_cmms_well ( modelName: HydroCMMS_Wells_CMMS_Well, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CMMS_Well, type: esriFieldTypeString )
• hydrocmms_wells_f4_digit ( modelName: HydroCMMS_Wells_F4_digit, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: 4-Digit SCADA Code, type: esriFieldTypeString )
• streetname ( modelName: streetname, nullable: true, editable: true, defaultValue: null, length: 100, alias: StreetName, type: esriFieldTypeString )
• city_state ( modelName: city_state, nullable: true, editable: true, defaultValue: null, length: 50, alias: City_State, type: esriFieldTypeString )
• zip ( modelName: zip, nullable: true, editable: true, defaultValue: null, length: 20, alias: Zip, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )
Templates:
• Name: Sites
  Description:
  Prototype:
  zip: null
  hydrocmms_wells_f4_digit: null
  city_state: null
  streetname: null
  hydrocmms_wells_cmms_well: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• Hydro_Wells (0) -- Related To: Wells (0)

Tables:

Table: HYDRO_AUTOMATED_SAMPLER (2)

Name: HYDRO_AUTOMATED_SAMPLER

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_AUTOMATED_SAMPLER
  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

Table: HYDRO_COM_CABLE (3)

Name: HYDRO_COM_CABLE

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_COM_CABLE
  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 (1) -- Related To: HYDRO_WELL (21)

Table: HYDRO_COMPRESSOR (4)

Name: HYDRO_COMPRESSOR

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_COMPRESSOR
  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

Table: HYDRO_FLOW_CELL (5)

Name: HYDRO_FLOW_CELL

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_FLOW_CELL
  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 (2) -- Related To: HYDRO_WELL (21)

Table: HYDRO_FORKLIFT (6)

Name: HYDRO_FORKLIFT

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_FORKLIFT
  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

Table: HYDRO_FORKLIFT_CHARGER (7)

Name: HYDRO_FORKLIFT_CHARGER

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_FORKLIFT_CHARGER
  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

Table: HYDRO_GENERATOR (8)

Name: HYDRO_GENERATOR

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_GENERATOR
  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

Table: HYDRO_PORTABLE_REEL (9)

Name: HYDRO_PORTABLE_REEL

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_PORTABLE_REEL
  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 (3) -- Related To: HYDRO_WELL (21)

Table: HYDRO_PUMP (10)

Name: HYDRO_PUMP

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_PUMP
  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

Table: HYDRO_PUMP_CONTROLLER (11)

Name: HYDRO_PUMP_CONTROLLER

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_PUMP_CONTROLLER
  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

Table: HYDRO_PUMPING_SKID (12)

Name: HYDRO_PUMPING_SKID

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_PUMPING_SKID
  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 (4) -- Related To: HYDRO_WELL (21)

Table: HYDRO_SONDE (13)

Name: HYDRO_SONDE

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_SONDE
  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

Table: HYDRO_TELEMETRY (14)

Name: HYDRO_TELEMETRY

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_TELEMETRY
  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 (5) -- Related To: HYDRO_WELL (21)

Table: HYDRO_TOTAL_DEPTH_TAGGER (15)

Name: HYDRO_TOTAL_DEPTH_TAGGER

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_TOTAL_DEPTH_TAGGER
  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 (6) -- Related To: HYDRO_WELL (21)

Table: HYDRO_TRANSDUCER (16)

Name: HYDRO_TRANSDUCER

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_TRANSDUCER
  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 (7) -- Related To: HYDRO_WELL (21)

Table: HYDRO_TROLL_COM (17)

Name: HYDRO_TROLL_COM

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_TROLL_COM
  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 (8) -- Related To: HYDRO_WELL (21)

Table: HYDRO_TROLL_REPLACEABLE_BATTERY_PACK (18)

Name: HYDRO_TROLL_REPLACEABLE_BATTERY_PACK

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_TROLL_REPLACEABLE_BATTERY_PACK
  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 (9) -- Related To: HYDRO_WELL (21)

Table: HYDRO_VW_LOGGER (19)

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)

Table: HYDRO_WATER_LEVEL_METER (20)

Name: HYDRO_WATER_LEVEL_METER

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_WATER_LEVEL_METER
  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 (11) -- Related To: HYDRO_WELL (21)

Table: HYDRO_WELL (21)

Name: HYDRO_WELL

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_WELL
  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.COM_CABLE (1) -- Related To: HYDRO_COM_CABLE (3)
• gis_hydro_cmms_dev.DBO.TOTAL_DEPTH_TAGGER (6) -- Related To: HYDRO_TOTAL_DEPTH_TAGGER (15)
• gis_hydro_cmms_dev.DBO.TROLL_COM (8) -- Related To: HYDRO_TROLL_COM (17)
• gis_hydro_cmms_dev.DBO.FLOW_CELL (2) -- Related To: HYDRO_FLOW_CELL (5)
• gis_hydro_cmms_dev.DBO.PORTABLE_REEL (3) -- Related To: HYDRO_PORTABLE_REEL (9)
• gis_hydro_cmms_dev.DBO.PUMPING_SKID (4) -- Related To: HYDRO_PUMPING_SKID (12)
• gis_hydro_cmms_dev.DBO.WIRELESS_TROLL_COM (12) -- Related To: HYDRO_WIRELESS_TROLL_COM (23)
• gis_hydro_cmms_dev.DBO.WATER_LEVEL_METER (11) -- Related To: HYDRO_WATER_LEVEL_METER (20)
• gis_hydro_cmms_dev.DBO.TRANSDUCER (7) -- Related To: HYDRO_TRANSDUCER (16)
• gis_hydro_cmms_dev.DBO.TROLL_REPLACEABLE_BATTERY_PACK (9) -- Related To: HYDRO_TROLL_REPLACEABLE_BATTERY_PACK (18)
• gis_hydro_cmms_dev.DBO.VW_LOGGER (10) -- Related To: HYDRO_VW_LOGGER (19)
• gis_hydro_cmms_dev.DBO.TELEMETRY (5) -- Related To: HYDRO_TELEMETRY (14)

Table: HYDRO_WELL_VAULT (22)

Name: HYDRO_WELL_VAULT

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_WELL_VAULT
  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

Table: HYDRO_WIRELESS_TROLL_COM (23)

Name: HYDRO_WIRELESS_TROLL_COM

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_WIRELESS_TROLL_COM
  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 (12) -- Related To: HYDRO_WELL (21)