Albania's Urban Renaissance

How to Use This Database?

The database for the project 'Albania’s Urban Renaissance’ contains data for over 500 projects, which have been completed or are under construction as a part of the massive building by the Albanian government under the Fund for the Development of Regions.

The search can be be done in two ways:

1. Directly Selecting a Project

One can directly select a Project from the menu Select a Project or directly click on some of the marked projects on the map of Albania, at the end of the Home Page.

Display of results: Searching in this way directly leads you to the link of the selected project, where one gets access to the key information about the respective project, (to the documentation used as a basis to obtain the data); you can also continue to new, advanced search by various categories. This is done by clicking on the links of the separate categories: Project type, Investors, Contractors or Municipalities.

2. Advanced Search

Clicking the Advanced Search button from the central menu leads you to the menu for advanced database search.

This menu allows you to search by the four key criteria which allows cataloguing the data according to:

1. Project Types

2. Investors

3. Contractors

4. Municipalities

The advanced search can be done by combining (selecting) several data from each category; by selecting only one type of data by category, or to select all the data from one/each category.

Category 1: Project Types allows database users to search data grouped according to a Projecttype, such as: schools and kindergartens, building, roads, revitalization projects, facades, green projects, etc.

Category 2: Investors allows users to search data related to any of the listed investors.

Category 3: Contractors consists of 5 sub-categories:

1. Joint-Ventures: One can select all Joint-Ventures, or select specific joint-venture between two or more companies.

2. Construction companies: One can select presentation of data for some, or for all of the construction companies participating in the project.

3. Design companies: One can select presentation of data for some, or for all of the design companies participating in the project.

4. Supervisory companies: One can select presentation of data for some, or for all of the supervisory companies participating in the project.

5. Technology companies: One can select presentation of data for some, or for all of the technology companies participating in the project.

In the category Investors, you can select only one, several or all the available data in the menu, at a category or a subcategory level.

If you like to choose only one subcategory, then you should click on its name.

Display of results: The results from the advanced search are displayed on a group results page. The group results page offers three types of search results, split in three parts.

In the upper part, there is a visual representation of the results. The selected parameters reveal information about the percentage / fraction of the requested data in the overall project value; make comparison of the most expensive with the cheapest structure; list the biggest investors or contractors.

In the lower part, the data is provided in tables. Here, one can request that the results are displayed in categories: Projects, Project Types, Investors or Contractors.

1. If, in the search criteria, you select Buildings only (in Project Typës), the displayed table results would be as follows:

• table Projects: displays all the buildings which are in the ‘Projects, and shows their value in Euros and in Lek;

• table Project Type: displays all types of projects (in this case buildings only) and their value in Euros and in Lek;

• table Investors: shows all investors that financed the construction of structures of the type ‘buildings’ and the sum they invested, in Euros and in Lek;

• table Contractors: shows all contractors taking part in the construction of the ‘building’ type of projects and the sum they received (from the investors) in Euros and in Lek.

2. If, in the search criteria, you select Municipality of Berat only, the table results would be displayed as follows:

• table Projects: shows all the projects to whose investor was the Municipality of Berat, and the sum the investor paid for each separate structure, in Euros and in Lek;

• table Project Types: shows all types of projects whose investor is the Municipality of Berat and the amount the investor paid for each separate structure, in Euros and in Lek (how much the investor paid for buildings, how much for facades etc.);

• table Investors: displays all investors (in this case, the Municipality of Berat only) and the invested amount of money, in Euros and Lek;

• table Contractors: displays all the contractors and the sum received by the investors, in Euros and Lek.

3. If, in the search criteria, the contractor ‘Salillari’ is selected, the displayed table results would be as follows:

table Projects: showing all the projects constructed by Salillari and the sum the contractor received for each individual structure, displayed in Euros and Lek;

table Project Types: showing all types of projects constructed by Salillari and the sum the contractor received for each individual structure, displayed in Euros and Lek (how much it was paid for buildings, for facades etc.);

table Investors: revealing all the investors that paid the contractor Salillari for building various structures and the sum it was paid, in Euros and Lek;

table Contractors: shows all contractors (in this case Salillari only) and the sum they have received, in Euros and Lek

4. If in the search criteria one selects the Municipality of Berat in Investors and Salillari in Contractors, the displayed table results would be as follows:

• table Projects: revealing all the Projects where the Municipality of Berat is an investor, and Salillari is a contractor, and the sum the investor paid to the contractor, in Euros and Lek;

• table Project Typws: shows all types of structures where Municipality of Berat is an investor, and Salillari is a contractor, and the sum the investor paid to the contractor, in Euros and Lek (how much money the contractor received for buildings, facades etc.);

• table Investors: shows all the investors (in this case, the Municipality of Berat only) that paid the contractor Salillari for building the projects , and the sum they paid, in Euros and Lek;

• table Contractors: showing all the contractors (in this case only Salillari) and the sum they received by the investor Municipality of Berat, in Euros and Lek.

The remaining combinations of the criteria have also a similar interpretation as in the four examples provided above.

At the bottom of the page for group results, there is a map which reveals the locations of the structures from the search results.

Downloading Data

The database offers two types of downloading data: Documentation for the Projects and Display of Results in Tables.

The documentation for the structures can be downloaded from the page of any selected structure, and often, it contains contracts or other types of documents related to the building and the preparation stage. The documents are in pdf format.

The results displayed in tables are downloaded in excel format, and the download is available under any displayed table, in the page for group presentation of the results.