DATABASE DESIGN TO PRESENT ON THE MAP OF THE CITY FURNITURE: ADVERTISING ELEMENTS CONCERNED
AbstractCity furniture can be defined as all of the stable objects in the streets of a city that add usefulness to the streets enabling them to fulfil their function, including the electric poles, traffic lights and signs, phone booths, letter boxes, benches and grids, transport stops, street lamps, kiosks etc. However, in Turkey, city furniture produced and installed by various authorities may have different standards. Additionally, installed by different authorities, the data of various city furniture are scattered among the databases of various authorities. This situation makes transfer of data among authorities more difficult. Moreover, each authority has a different regulation about city furniture. This situation spoils the standard among the same type of elements. Considering all of these motives, a city furniture map should be established in order to include all city furniture. The characteristics and geographical location of city furniture should be pinned on this map. This way, situations that may harm the urban aesthetics in the positioning of city furniture will be prevented and a coordination can be created among authorities. Considering all these problems, our aim is to create a database system that can be represented on the map by classifying the aimed city furniture. Thus creating a base for the creation of city furniture maps. For example, the advertising elements that are part of the city furniture are chosen. It will also be determined by the geographical coordinates of the most suitable advertising area so as not to damage the aesthetic texture of the city. A design has been realized which aims to implement the advertising signboards in a way that will create an integrity in terms of visual aesthetics. In addition, all the parameters were found to respond to positional queries and were visualized on the map.