Name: Tourism_Asset_Detail

Display Field: AssetName

Type: Table

Geometry Type: N/A

Description: These table contains infomration about tourism asset locations in and around Strathcona County. This table is an input into a workflow that compiles 3 sources using ETL – Points of Interest, Business Directory, Tourism Asset (points that are not in the POI or Business Directory). The features in this dataset are part of the Strathcona County Tourism Strategy.For more information on the Strathcona County Tourism Strategy, visit the page on the Strathcona County website: https://www.strathcona.ca/council-county/public-engagement/tourism-strategy-and-engagement/

Copyright Text: Economic Development & Tourism, Strathcona County

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

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

Feature Draw Order:

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: 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
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeInteger, alias: Asset ID, editable: true, nullable: true, defaultValue: null, modelName: AssetID )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source )
• POIFeatType ( type: esriFieldTypeString, alias: POI Feature Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POIFeatType )
• AssetName ( type: esriFieldTypeString, alias: Asset Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: AssetName )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• HasCivicID ( type: esriFieldTypeString, alias: Has Civic ID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: HasCivicID , Coded Values: [Yes: Yes] , [No: No] )
• StrAddress ( type: esriFieldTypeString, alias: Street Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: StrAddress )
• PrimaryCo ( type: esriFieldTypeString, alias: Primary Contact, editable: true, nullable: true, length: 60, defaultValue: null, modelName: PrimaryCo )
• PhoneNo ( type: esriFieldTypeString, alias: Phone Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PhoneNo )
• Email ( type: esriFieldTypeString, alias: Email Address, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Email )
• Website ( type: esriFieldTypeString, alias: Website, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Website )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Description )
• DocSource ( type: esriFieldTypeString, alias: Document Source, editable: true, nullable: true, length: 150, defaultValue: null, modelName: DocSource )
• AssetClass ( type: esriFieldTypeString, alias: Asset Class, editable: true, nullable: true, length: 5, defaultValue: null, modelName: AssetClass )
• Category ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Category )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreatedBy )
• CreatedOn ( type: esriFieldTypeDate, alias: Created On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedOn )
• ModifiedBy ( type: esriFieldTypeString, alias: Modified By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: ModifiedBy )
• ModifiedOn ( type: esriFieldTypeDate, alias: Modified On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: ModifiedOn )

Templates:

• Name: Tourism_Asset_Detail
  Description:
  Prototype:
  Category: null
  AssetClass: null
  AssetID: null
  Source: null
  POIFeatType: null
  AssetName: null
  Location: null
  HasCivicID: null
  StrAddress: null
  PrimaryCo: null
  PhoneNo: null
  Email: null
  Website: null
  Description: null
  DocSource: 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

Edit Fields Info:

• Creation Date Field: CreatedOn
• Creator Field: CreatedBy
• Edit Date Field: ModifiedOn
• Editor Field: ModifiedBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

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