This menu allows you to search by the three key criteria which allows cataloguing the data according to:
- Type of Structure
- Investors
- Contractors
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: Type of Structure allows database users to search data grouped according to a structure type, such as: building, multi-storey garage, bridge, fence, monument, façade etc.
Category 2: Investors allows users to search data related to any of the listed investors.
Category 3: Contractors consists of 4 sub-categories:
- A) Authors: One can select all authors, or select specific authors of the design proposals.
- B) Construction companies: One can select presentation of data for some, or for all of the construction companies participating in the project.
- C) Foundries: One can select a display of data for one or for several foundries participating in the project.
- D) Other: Here one can select companies contracted to perform other serviced previously not listed, such as: maintenance, security, provision of office equipment etc.
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: Structure, Type of Structure, Investors or Contractors.
1. If, in the search criteria, you select Buildings only (in Type of Structure), the displayed table results would be as follows:
- table Structure: displays all the buildings which are in the ‘type of structure’, and shows their value in Euros and in Denars;
- table Type of Structure: displays all types of structures (in this case buildings only) and their value in Euros and in Denars;
- table Investors: shows all investors that financed the construction of structures of the type ‘buildings’ and the sum they invested, in Euros and in Denars;
- table Contractors: shows all contractors taking part in the construction of the ‘building’ type of structure and the sum they received (from the investors) in Euros and in Denars.
2. If, in the search criteria, you select Municipality of Centre only, the table results would be displayed as follows:
- table Structures: shows all the structures to whose investor was the Municipality of Centre, and the sum the investor paid for each separate structure, in Euros and in Denars;
- table Type of Structure: shows all types of structures whose investor is the Municipality of Centre and the amount the investor paid for each separate structure, in Euros and in Denars (how much the investor paid for buildings, how much for facades etc.);
- table Investors: displays all investors (in this case, the Municipality of Centre only) and the invested amount of money, in Euros and Denars;
- table Contractors: displays all the contractors and the sum received by the investors, in Euros and Denars.
3. If, in the search criteria, the contractor ‘Beton’ Skopje is selected, the displayed table results would be as follows:
- table Structure: showing all the structures constructed by ‘Beton’ Skopje and the sum the contractor received for each individual structure, displayed in Euros and Denars;
- table Type of Structure: showing all types of structures constructed by ‘Beton’ Skopje and the sum the contractor received for each individual structure, displayed in Euros and Denars (how much it was paid for buildings, for facades etc.);
- table Investors: revealing all the investors that paid the contractor ‘Beton’ Skopje for building various structures and the sum it was paid, in Euros and Denars;
- table Contractors: shows all contractors (in this case ‘Beton’ Skopje only) and the sum they have received, in Euros and Denars.
4. If in the search criteria one selects the Municipality of Centre in Investors and ‘Beton’ Skopje in Contractors, the displayed table results would be as follows:
- table Structure: revealing all the structures where the Municipality of Centre is an investor, and ‘Beton’ Skopje is a contractor, and the sum the investor paid to the contractor, in Euros and Denars;
- table Type of Structure: shows all types of structures where Municipality of Centre is an investor, and ‘Beton’ Skopje is a contractor, and the sum the investor paid to the contractor, in Euros and Denars (how much money the contractor received for buildings, facades etc.);
- table Investors: shows all the investors (in this case, the Municipality of Centre only) that paid the contractor ‘Beton’ Skopje for building the structures, and the sum they paid, in Euros and Denars;
- table Contractors: showing all the contractors (in this case only ‘Beton’ Skopje) and the sum they received by the investor Municipality of Centre, in Euros and Denars.
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.