Name: Asset Information
Display Field: room_name
Type: Table
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- assets_type (type: esriFieldTypeString, alias: assets_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- site (type: esriFieldTypeString, alias: site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- property (type: esriFieldTypeString, alias: property, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- comp_group (type: esriFieldTypeString, alias: comp_group, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- comp_type (type: esriFieldTypeString, alias: comp_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- component (type: esriFieldTypeString, alias: component, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- location (type: esriFieldTypeString, alias: location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- importance (type: esriFieldTypeInteger, alias: importance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- constr_year (type: esriFieldTypeInteger, alias: constr_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- survey_year (type: esriFieldTypeInteger, alias: survey_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- base_life (type: esriFieldTypeInteger, alias: base_life, SQL Type: sqlTypeOther, nullable: true, editable: true)
- C1 (type: esriFieldTypeInteger, alias: C1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- C2 (type: esriFieldTypeInteger, alias: C2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- C3 (type: esriFieldTypeInteger, alias: C3, SQL Type: sqlTypeOther, nullable: true, editable: true)
- C4 (type: esriFieldTypeInteger, alias: C4, SQL Type: sqlTypeOther, nullable: true, editable: true)
- C5 (type: esriFieldTypeInteger, alias: C5, SQL Type: sqlTypeOther, nullable: true, editable: true)
- appearance (type: esriFieldTypeInteger, alias: appearance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- consequence (type: esriFieldTypeInteger, alias: consequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
- safety (type: esriFieldTypeInteger, alias: safety, SQL Type: sqlTypeOther, nullable: true, editable: true)
- min_condition (type: esriFieldTypeInteger, alias: min_condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
- quantity (type: esriFieldTypeDouble, alias: quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
- unit_id (type: esriFieldTypeString, alias: unit_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- unit_rate (type: esriFieldTypeInteger, alias: unit_rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
- cost (type: esriFieldTypeInteger, alias: cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
- room_number (type: esriFieldTypeString, alias: room number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- room_name (type: esriFieldTypeString, alias: room name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- cond_conf_id (type: esriFieldTypeString, alias: cond_conf_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- created (type: esriFieldTypeDate, alias: created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- created_by (type: esriFieldTypeString, alias: created_by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- modified (type: esriFieldTypeDate, alias: modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- modified_by (type: esriFieldTypeString, alias: modified_by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Templates:
Name: Toitoi_SPM_table_final
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
- Rooms (0) -- Related To: Rooms (0)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/2/2023 5:25:24 AM
Schema Last Edit Date: 5/2/2023 5:25:24 AM
Data Last Edit Date: 5/2/2023 5:25:24 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat