Name: Assets Facilities

Display Field: sitename

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fe30cb8cb10043e0bab0080f62408d86

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• assetid ( modelName: AssetID, nullable: true, editable: true, defaultValue: null, length: 255, alias: AssetID, type: esriFieldTypeString )
• siteid ( modelName: SiteID, nullable: true, editable: true, defaultValue: null, length: 255, alias: SiteID, type: esriFieldTypeString )
• sitename ( modelName: SiteName, nullable: true, editable: true, defaultValue: null, length: 255, alias: SiteName, type: esriFieldTypeString )
• functionnum ( modelName: FunctionNum, nullable: true, editable: true, defaultValue: null, alias: FunctionNum, type: esriFieldTypeInteger )
• asset_group ( modelName: Asset_Group, nullable: true, editable: true, defaultValue: null, length: 255, alias: Asset_Group, type: esriFieldTypeString )
• gis_layer_name ( modelName: GIS_Layer_Name, nullable: true, editable: true, defaultValue: null, length: 255, alias: GIS_Layer_Name, type: esriFieldTypeString )
• cityworks_description_asset ( modelName: Cityworks_Description_Asset, nullable: true, editable: true, defaultValue: null, length: 255, alias: Cityworks_Description_Asset, type: esriFieldTypeString )
• component_location ( modelName: Component_Location, nullable: true, editable: true, defaultValue: null, length: 255, alias: Component_Location, type: esriFieldTypeString )
• component_description ( modelName: Component_Description, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Component_Description, type: esriFieldTypeString )
• manufacturer ( modelName: Manufacturer, nullable: true, editable: true, defaultValue: null, length: 255, alias: Manufacturer, type: esriFieldTypeString )
• model ( modelName: Model, nullable: true, editable: true, defaultValue: null, length: 255, alias: Model, type: esriFieldTypeString )
• serial_number ( modelName: Serial_Number, nullable: true, editable: true, defaultValue: null, length: 255, alias: Serial_Number, type: esriFieldTypeString )
• quantity ( modelName: Quantity, nullable: true, editable: true, defaultValue: null, alias: Quantity, type: esriFieldTypeDouble )
• unit_of_measure ( modelName: Unit_of_Measure, nullable: true, editable: true, defaultValue: null, length: 255, alias: Unit_of_Measure, type: esriFieldTypeString )
• conditionscore ( modelName: ConditionScore, nullable: true, editable: true, defaultValue: null, alias: Condition Score, type: esriFieldTypeInteger )
• condition_rating ( modelName: Condition_Rating, nullable: true, editable: true, defaultValue: null, length: 10, alias: Condition_Rating, type: esriFieldTypeString )
• condition_value ( modelName: Condition_Value, nullable: true, editable: true, defaultValue: null, length: 15, alias: Condition_Value, type: esriFieldTypeString )
• condition_by ( modelName: Condition_By, nullable: true, editable: true, defaultValue: null, length: 50, alias: Condition_By, type: esriFieldTypeString )
• condition_date ( modelName: Condition_Date, nullable: true, editable: true, defaultValue: null, length: 29, alias: Condition_Date, type: esriFieldTypeDate )
• inservice_date ( modelName: InService_Date, nullable: true, editable: true, defaultValue: null, length: 29, alias: InService_Date, type: esriFieldTypeDate )
• estimated_useful_life_years ( modelName: Estimated_Useful_Life_Years, nullable: true, editable: true, defaultValue: null, alias: Estimated_Useful_Life_Years, type: esriFieldTypeInteger )
• historical_cost ( modelName: Historical_Cost, nullable: true, editable: true, defaultValue: null, length: 255, alias: Historical_Cost, type: esriFieldTypeString )
• assessed_replacement_value ( modelName: Assessed_Replacement_Value, nullable: true, editable: true, defaultValue: null, length: 255, alias: Assessed_Replacement_Value, type: esriFieldTypeString )
• current_replacement_value ( modelName: Current_Replacement_Value, nullable: true, editable: true, defaultValue: null, length: 255, alias: Current_Replacement_Value, type: esriFieldTypeString )
• replacement_cost_date ( modelName: Replacement_Cost_Date, nullable: true, editable: true, defaultValue: null, length: 29, alias: Replacement_Cost_Date, type: esriFieldTypeDate )
• uniformat_ii_lvl1_majorgrp ( modelName: Uniformat_II_Lvl1_MajorGrp, nullable: true, editable: true, defaultValue: null, length: 255, alias: Uniformat_II_Lvl1_MajorGrp, type: esriFieldTypeString )
• uniformat_ii_lvl2_componentgrp ( modelName: Uniformat_II_Lvl2_ComponentGrp, nullable: true, editable: true, defaultValue: null, length: 255, alias: Uniformat_II_Lvl2_ComponentGrp, type: esriFieldTypeString )
• uniformat_ii_lvl3_component ( modelName: Uniformat_II_Lvl3_Component, nullable: true, editable: true, defaultValue: null, length: 255, alias: Uniformat_II_Lvl3_Component, type: esriFieldTypeString )
• insurance_value ( modelName: Insurance_Value, nullable: true, editable: true, defaultValue: null, length: 255, alias: Insurance_Value, type: esriFieldTypeString )
• assessed_date ( modelName: Assessed_Date, nullable: true, editable: true, defaultValue: null, length: 29, alias: Assessed_Date, type: esriFieldTypeDate )
• prorated_pcnt_of_cost ( modelName: Prorated_pcnt_of_Cost, nullable: true, editable: true, defaultValue: null, length: 255, alias: Prorated_pcnt_of_Cost, type: esriFieldTypeString )
• status ( modelName: Status, nullable: true, editable: true, defaultValue: null, length: 20, alias: Status, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• buildingid ( modelName: buildingid, nullable: true, editable: true, defaultValue: null, length: 255, alias: BuildingID, type: esriFieldTypeString )

Templates:

• Name: Assets Facilities
  Description:
  Prototype:
  cityworks_description_asset: null
  uniformat_ii_lvl1_majorgrp: null
  prorated_pcnt_of_cost: null
  historical_cost: null
  current_replacement_value: null
  component_location: null
  buildingid: null
  manufacturer: null
  assessed_replacement_value: null
  insurance_value: null
  functionnum: null
  condition_rating: null
  sitename: null
  siteid: null
  unit_of_measure: null
  last_edited_date: null
  model: null
  assessed_date: null
  component_description: null
  conditionscore: null
  uniformat_ii_lvl3_component: null
  quantity: null
  created_user: null
  serial_number: null
  condition_by: null
  gis_layer_name: null
  inservice_date: null
  replacement_cost_date: null
  last_edited_user: null
  uniformat_ii_lvl2_componentgrp: null
  assetid: null
  condition_value: null
  estimated_useful_life_years: null
  asset_group: null
  created_date: null
  condition_date: null
  status: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PRRD.GISOWNER.LNDPRRD_Buildings (0) -- Related To: PRRD Buildings_PFA (0)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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