A Database Implementation of LADM Valuation Information Model in Turkish Case Study

Abdullah Kara, Ümit Işıkdağ, Volkan Çağdaş, Peter van Oosterom, Christiaan Lemmen, Erik Stubkjær

    Research output: Chapter in Book/Conference proceedings/Edited volumeConference contributionScientificpeer-review

    42 Downloads (Pure)

    Abstract

    A recently started joint activity under International Federation of Surveyors (FIG) Commission 9 (Valuation and the Management of Real Estate) and FIG Commission 7 (Cadastre and Land Management) has started development of an information model for the specification of valuation information maintained by public authorities especially for property taxation. In this initiative, ISO 19152:2012 Land Administration Domain Model (LADM) has been taken as the basis for the development of a Valuation Information Model. A first version of the LADM Valuation Information Model was created based on standards, literature survey and data gained from questionnaires replied by the national delegates of FIG Commission 9 and FIG Commission 7. The conceptual model was represented through class diagrams of the Unified Modeling Language (UML).
    This paper describes the development of a prototype for the implementation of the conceptual model in terms of a Turkish case study. The main aim of this paper is to assess and improve the proposed conceptual LADM Valuation Information Model. In the development part, the classes, attributes, constraints, cardinalities and relations between classes of the conceptual model were converted to technical (physical) model, namely the Oracle Spatial 11g database schema has been generated from the conceptual model definitions. The conceptual schema definitions were implemented into the database, which next was loaded with sample datasets related to property valuation and taxation in Turkey. The sample data includes valuation units that are the subjects of recurrently levied property taxes in Turkey, such as unimproved urban parcel and parcel and improvements together as condominium property, valuation and taxation information of the valuation units in different years, and as well as geometries of valuation units. The technical model of LADM Valuation Information Model Turkish Country Profile has been tested in evaluation phase through SQL queries and visualization tools, respectively. In this phase, it is investigated that whether the both conceptual and technical models fulfill the needs of information management aspects of valuation activities for property taxation.
    Original languageEnglish
    Title of host publicationProceedings of the 7th Land Administration Domain Model Workshop
    EditorsC. Lemmen, P. van Oosterom, E. Fendel
    Place of PublicationCopenhagen
    PublisherInternational Federation of Surveyors (FIG)
    Pages19-34
    Number of pages16
    ISBN (Electronic)978-87-92853-69-1
    ISBN (Print)978-87-92853-68-4
    Publication statusPublished - 2018
    Event7th Land Administration Domain Model Workshop - Zagreb, Croatia
    Duration: 11 Apr 201813 Apr 2018

    Workshop

    Workshop7th Land Administration Domain Model Workshop
    Country/TerritoryCroatia
    CityZagreb
    Period11/04/1813/04/18

    Keywords

    • LADM Valuation Information Model
    • ISO 19152:2012 Land Administration Domain Model (LADM)
    • Immovable Property Valuation

    Fingerprint

    Dive into the research topics of 'A Database Implementation of LADM Valuation Information Model in Turkish Case Study'. Together they form a unique fingerprint.

    Cite this