Name: District of Sechelt Buinding Assets

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 25524059b63c498183dc15a608057000

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: true
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: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: FACILTYID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FacilityID )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AcquisitionDate )
• AcquisitionDate ( type: esriFieldTypeDate, alias: AcquisitionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AcquisitionCost )
• AcquisitionCost ( type: esriFieldTypeDouble, alias: AcquisitionCost, editable: true, nullable: true, defaultValue: null, modelName: ExpectedLife )
• ExpectedLife ( type: esriFieldTypeDouble, alias: Usefull Life, editable: true, nullable: true, defaultValue: null, modelName: ResidualValue )
• DepreciationMethod ( type: esriFieldTypeString, alias: DepreciationMethod, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AssetDisposed )
• LegacyAssetID ( type: esriFieldTypeString, alias: LegacyAssetID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ReplacementCost )
• FacilitySiteID ( type: esriFieldTypeString, alias: FacilitySiteID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FacilitySiteID )
• SalvageValue ( type: esriFieldTypeDouble, alias: SalvageValue, editable: true, nullable: true, defaultValue: null, modelName: SalvageValue )
• AssetDisposed ( type: esriFieldTypeString, alias: AssetDisposed, editable: true, nullable: true, length: 5, defaultValue: null, modelName: AssetDisposed )
• Equip_Class ( type: esriFieldTypeString, alias: Equip_Class, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Equip_Class , Coded Values: [Backhole: Back Hoe] , [Crane: Crane] , [Dump Truck: Dump Truck] )
• Acct_Class ( type: esriFieldTypeString, alias: Acct_Class, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Acct_Class , Coded Values: [Common Services-6100: Common Services 6100] , [Parks-7200: Parks 7200] , [Public Works-6300: Public Works 6300] , ...9 more... )
• ProRated ( type: esriFieldTypeSmallInteger, alias: ProRated, editable: true, nullable: true, defaultValue: null, modelName: ProRated )
• Conditon_Score_Rating ( type: esriFieldTypeSmallInteger, alias: Conditon_Score_Rating, editable: true, nullable: true, defaultValue: null, modelName: Conditon_Score_Rating )
• Condition_Score_Date ( type: esriFieldTypeDate, alias: Condition_Score_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Condition_Score_Date )
• Acct_Group ( type: esriFieldTypeString, alias: Acct_Group, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Acct_Group , Coded Values: [850-Automotive Equipment: 850 Automotive Equipment] , [810-Land: 810 Land] , [820-Buildings: 820 Buildings] , ...3 more... )
• Acquisition_Month ( type: esriFieldTypeSmallInteger, alias: Acquisition_Month, editable: true, nullable: true, defaultValue: null, modelName: Acquisition_Month )
• Acquisiton_Year ( type: esriFieldTypeSmallInteger, alias: Acquisiton_Year, editable: true, nullable: true, defaultValue: null, modelName: Acquisiton_Year )
• Round_to_Dollars ( type: esriFieldTypeString, alias: Round_to_Dollars, editable: true, nullable: true, length: 10, defaultValue: F, modelName: Round_to_Dollars )
• Convention ( type: esriFieldTypeString, alias: Convention, editable: true, nullable: true, length: 20, defaultValue: FullMonth, modelName: Convention )
• Accelerator ( type: esriFieldTypeSmallInteger, alias: Accelerator, editable: true, nullable: true, defaultValue: null, modelName: Accelerator )
• Category ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Category )
• SubClassID ( type: esriFieldTypeString, alias: SubClassID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SubClassID )
• Building_Type ( type: esriFieldTypeString, alias: Building_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Building_Type )
• Building_Component ( type: esriFieldTypeString, alias: Building_Component, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Building_Component )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Notes )

Templates:

• Name: District of Sechelt Buinding Assets
  Description:
  Prototype:
  Building_Component: null
  Notes: null
  FacilityID: null
  Description: null
  AcquisitionDate: null
  AcquisitionCost: null
  ExpectedLife: null
  DepreciationMethod: null
  LegacyAssetID: null
  FacilitySiteID: null
  SalvageValue: null
  AssetDisposed: null
  Equip_Class: null
  Acct_Class: null
  ProRated: null
  Conditon_Score_Rating: null
  Condition_Score_Date: null
  Acct_Group: null
  Acquisition_Month: null
  Acquisiton_Year: null
  Round_to_Dollars: F
  Convention: FullMonth
  Accelerator: null
  Category: null
  SubClassID: null
  Building_Type: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata