State of IsraelMinistry of Housing and Construction

Survey of Israel

A Location Based Business Intelligence (LBBI) A Location Based Business Intelligence (LBBI) system for the Israeli real estate market

• Established in 1920 by theBritish Mandate

The SOI building in 1930

British Mandate• Employs around 300

employees. The SOI building in 1930

employees. • More than 30% of the

employees have a Masters Degree or higher Degree or higher

• Lead the Israeli inter-governmental committee for GISGIS

• Govern using ~20 orders, acts and government decisions.

The SOI building today

decisions.

State of IsraelMinistry of Housing and Construction

Survey of Israel

PolicyPolicyLicensing SurveyorsSurvey Regulations

Cadastre

Mapping &

GeodesyResearchProfessional lead

Mapping &GIS

The Survey of Israel is governmental agency for Mapping, The Survey of Israel is governm ental agency for M apping, Geodesy, Cadast re and Geo inform at ion

• Background (the problem)• Background (the problem)• Project goals• Input data• Input data• AnalysisAnalysis• Output and pilot results

• Conclusions and future work• Conclusions and future work

Housing prices – Key challenge for the Israeli government

Survey of Israel

Understanding the housing crisis requires good data

• State Com ptroller's O ffice notes that the absence of full and

Understanding the housing crisis requires good data

• State Com ptroller's O ffice notes that the absence of full and com plete data on the real-estate m arket m eans lack of proper supervision and inability to m anage the situation.

• Any activities w ithout a reliable and com prehensive database m ay not be optim al.m ay not be optim al.

• Real-estate data in Israel is entered by hand written form s.written form s.

• Data is inserted w ith no quality control

• Data is not geo-tagged

A Location Based Business Intelligence (LBBI)

Survey of Israel

• The situat ion has brought the need for efficient Locat ion Based

A Location Based Business Intelligence (LBBI) system for the Israeli real estate market

• The situat ion has brought the need for efficient Locat ion Based Business Intelligence (LBBI) system to manage the real estate market .

• A nat ional project was init iated by an intergovernmental forum• A nat ional project was init iated by an intergovernmental forum• The project has four tasks:

1. Creat ion of unified property database1. Creat ion of unified property database2. Development of Locat ion Based Business Intelligence (LBBI)

system for the Israeli real estate market 3. Development of data presentat ion and disseminat ion system 4. Format ion of management tools to supervise nat ional

const ruct ion projects const ruct ion projects

1. Creation of unified property database

• Governmental databases will be consolidated using alpha-numeric consolidated using alpha-numeric and spatial properties

• These database include (1st

phase):phase):– Topographic data (SOI)– Cadastral data– Cadastral data– Financial data (tax)– Ownership data (register

office)office)• Personal and private data will not

be used.be used.

Survey of Israel

Development of a real-estate database

1. Textual matching techniques are used to connect property recordsrecords

2. Different databases used different identifiers including street name, cadastral identifier, database number. These identifiers are not unique and may change with timeare not unique and may change with time

3. Geographic coordinates are the least common denominator among the datasets, and provide tools for quality improvement among the datasets, and provide tools for quality improvement and for data consolidation.

4. This is a classical process of geocoding:

DetailsDB noNoStreetCitySub-No

ParcelBlockNorth

CoordinateEast

Coordinate……486581LincolnTel-

Aviv433596586

CoordinateCoordinate

675934188644

Using spatial properties to obtain coordinatescoordinates

Scenario A Scenario B Scenario C

Scenario D Scenario E Scenario F

Parcel Boundary--Structure-Address -

2. Development of data presentation and dissemination system dissemination system

Special module was developed in the national geo-spatial portal to query and present real-estate dataquery and present real-estate data

3. A Location Based Business Intelligence (LBBI)

Survey of Israel

• The development of LBBI is a complicated task which was

3. A Location Based Business Intelligence (LBBI) system for the Israeli real estate market

• The development of LBBI is a complicated task which was divided into three components:

• Input: the system has to include a rich database of real estate datasets including topographic, cadast ral, f inancial, planning

• Input: the system has to include a rich database of real estate datasets including topographic, cadast ral, f inancial, planning demographic, etc. The creat ion of this integrated database is a challenging undertaking.challenging undertaking.

• Functionality: the LBBI should provide a plethora of tools, queries and analysis methods for a variety of governmental users and needs. needs.

• Output: the LBBI should be linked and connected with a variety of computerized systems and output plat forms. M oreover, the LBBI output should be diverse and include maps, report , text and output should be diverse and include maps, report , text and database files, charts and graphs.

Location based Business Intelligence Infrastructure

Charts and graphs

Advanced queries

Output to Many formats

ReportsMaps Analytics and prediction

NetworkServices

Analysis of governmental data

Multi-dimensional calculationsAdvanced query system

Analysis of governmental data

Multi-dimensional calculationsData validation and integration

Ownership and rights database

Topographic database

Planning and marketing database

Financial data WS to tax authority database

Layer of basic datasets

Analysis of a Location Based Business Intelligence (LBBI)

Survey of Israel

• Analysis goal: Identification of proper locations for renovation projects

Intelligence (LBBI)

renovation projects • Criteria:1. Parcels with no buildings1. Parcels with no buildings2. Adjacent to parcels with old (<1984) buildings and 2-4 floors3. Purpose – residential in the zoning maps3. Purpose – residential in the zoning maps4. Owned by the government5. Classified according to parcel size 5. Classified according to parcel size

An Example of the analysis results

4. Management tools to supervise national construction projects

• Interfaces between planning and construction systems

• Overseeing all the design to construction phases

construction projects

• Overseeing all the design to construction phases

• Identifying bottlenecks Construction management

DevelopmentLand

Redemption

Marketingmanagement

and QC

Propertyidentification

Planning Redemption

Business intelligence

Mapping and monitoring of all project phases (design, development, construction, intelligence (design, development, construction,

registration), using geographic information systems and aerial photographs

Management tools to supervise national construction projects construction projects

Survey of Israel

• Inform ation system s and technology have always • Inform ation system s and technology have always proved to be efficient solutions (in term s of cost and benefits) to m ange problem s that are caused by benefits) to m ange problem s that are caused by shortage of resources.

• The project deals w ith the three com ponents of • The project deals w ith the three com ponents of inform ation technology: Input data, analysis, and presentation presentation

• The national project is in progress and initia l results are showing good prospects