decision support in uncertain real estate transactions

Decision Support in Uncertain Real Estate Transactions Judgment Under Uncertainty Related to Real Estate Transactions in Everyday Life Supported by Open Source GIS Tools

Dr. György Szabó1 – Ervin Wirth2

1 associate professor, University of Technology and Economics, Department of Photogrammetry and Geoinformatics, e-mail: gyszabo@eik.bme.hu2 lecturer, University of Technology and Economics, Department of Photogrammetry and Geoinformatics, e-mail: wirthervin@gmail.com

Metadata

• Open source elements• User-friendly• Browsing for real estate on map• Risk calculation - Fuzzy logic

Problem recognition• difficulty of buying an apartment• absence of necessary knowledge• mistakes are not allowed• once in a lifetime

Analysis• create knowledge base• calculate indicators

Definition• mapping of properties• deliberation, separation• ranking

Synthesis• create sample database• categorize results

A layout, Kosztolányi Dezső Square

Advertisement

Risk calculating

Web server

Delete advertisement

Browsing

For sale

For rent

Query with parameters

Display on map

Tabular browsing

Origin of spatial data

• Open Street Map (OSM) project which purpose to create a free editable map of the world

• Geofabrik (Karlsruhe)they provide up-to-date derived data from OSM for free download (.shp)

• Open Database License 1.0. data for any purpose, acknowledge OpenStreetMap as the data source

• The used layer: buildings.shp (WGS84)

Pack of EnterpriseDB

Shape file

QGIS Dufour

DB Manager of QGIS Dufour

PostgreSQL (PostGIS)

An overview of the combination of languages

Apartment area

Mamdani Inference

Facility of heat the apartment

Comfort

Modernity

Heating technology

Wall thickness

Main building material

Window surface

Levels of building

Level of apartment

Building age

Insulation

Our fuzzy inference system (FIS)

IN

PUT

SID

E O

UTPU

T SIDE

Graphical representations of Ceiling height fuzzy set

A basic sample• IF ceiling height is average THEN heating difficulty is medium• IF ceiling height is high THEN heating difficulty is hard

Lighting [%] Wall thickness [cm]

Insu

latio

n

Apartment area [m2] Ceiling height [cm]

Fa

cilit

y of

hea

ting

Thank you !