Database content - Access to VisitOSLO's database API - Content for your own site - Travel trade, media and cruise -

Content in the database

An overview of content in the database and how you can use it in your own channels.

The database contains thousands of products in different categories. Most of the products represent offers located in Oslo, and are registered with many bits of information: text, photos, address, hours, contact info, map coordinates, public transport info, prices, videos and links to profiles in social media. (Note: Event products do not usually have photos.)

Languages: All products have Norwegian and English text. Many also have text in German, Spanish, Italian and French.

Database categories 

In order to be able list information from the database, we use a set of categories, each with its own unique ID. The database categories are organised in three levels (hierarchically): 

  • Level 1: Main category
    • Level 2: Sub category 1
      • Level 3: Sub category 2

All products in the database have a main category and sub category 1. In some cases sub category 2 is also used. 


Level 1: Main categories

VisitOSLO uses 12 main categories: Accommodation, events, activities, attractions, places, food & drink, transport, shops, services, travel package, rental, news. 

Level 2: Sub category 1

Below each category there is a number of sub categories. Sub category 1 is used on all products in the database. Examples of sub category 1:

  • Main category: Accommodation
    • Sub category 1: Hotel
  • Main category: Accommodation
    • Sub category 1: Camp site
  • Main category: Food & drink
    • Sub category 1: Bar/pub


Level 3: Sub category 2
Sub category 2 is used in some cases to further specify the product type. Examples:

  • Main category: Food & drink
    • Sub category 1: Restaurant
      • Sub category 2: Vegetarian
  • Main category: Shopping
    • Sub category 1: Shops
      • Sub category 2: Souvenirs

Note that sub category 2 is not necessarily used on all products, even if a suitable category exists. For example a restaurant may be vegetarian, but not marked with subcategory 2: vegetarian. Therefore, sub category 2 does not always provide a representative result. 


General recommendation

As sub category 2 will not always contain a representative selection, we generally do not recommend using this level for filtering. 

Filter tags  

The products can also have what we call publishing filters, a type of "tagging" used across categories. Publishing filters are used to extract a selection of products for a particular target group or to make tailor-made lists. For example: Products that are recommended for families with children are tagged with "Children/Family", regardless of product category, so this tag will give you both events, attractions and acctivities.  


Boroughs/areas in the database

Products with an address are connected to a predefined area in Oslo, giving you the possibility of listing products in one particular area. 


Show a selection of the content

If you don't want to show complete lists from the database, you can filter to get a selection based on category, publishing filter or area. You can get a complete list of restaurants, but you can also show only Italian restaurants or restaurants only in the Grünerløkka area. in the same way you can choose to show all attractions, or only attractions for children or only galleries. 

You can also use the products' map coordinated to make a selection. This way you can show only products located close to your own hotel/office.  

Of course, it is also possible to "hand pick" producst, to get data for particular products based on product ID. 

If you have questions related to the content of the database, contact
For technical questions, please see the technical documentation.