Buildings at risk. Where are they at all?

Buildings at risk. Where are they at all?

The evacuation and collapse of a building in the city of Holon and other cities in Israel had raised some questions:

Is the house I live in at risk? What are the status in my neighborhood and my city?

How can we locate buildings at risk? How

can we get this Geo Data

(GIS) and analyze and visualize it clearly on a map?

We have mapped and analyzed over 3 million buildings in the country, to try and find clusters of old buildings that pose a potential risk, to answer some of the questions.

The Source of the data came from open data released by the survey of Israel,
As a CSV file that needed data cleansing first.

Cleaning duplicate data, null values and checking the data statistics for the attribute values done using pandas python library and PostgreSQL database.

The data had聽 an X, Y coordinates fields in the file so we can use it to add it to聽 a map, after building a spatial table in PostgreSQL’s PostGIS amazing spatial extension and adding it to GIS (Geographic information system) client, such as Qgis or a web client such as

Using SQL queries and Qgis we can visualize and analyze the data for the relevant years by location clusters and heatmaps.

The map and the results show there are over 60,000 buildings throughout Israel aged 50 years and over.

The old buildings are usually concentrated in the city center and old neighborhoods.

Focusing on Tel Aviv, we Have explored the dispersal in the various聽neighborhoods, the maps speak for themselves.

Adding the data and designing it for viewing and sharing the data with (rich WebGL GIS fast browser library)

Tel aviv heatmap

This is a preliminary analysis and many other factors may have an impact. This analysis can help point out trends and options for more accurate research that can aid the decision-makers in planning urban renewal or building strengthening.

Tel Aviv - buildings colored by year map
Tel Aviv - buildings colored by year

饾悡饾悺饾悶 “饾悥饾悽饾惂饾惂饾悽饾惂饾悹” 饾悳饾悽饾惌饾悽饾悶饾惉 饾悮饾惈饾悶: 饾悡饾悶饾惀 饾悁饾惎饾悽饾惎, 饾悋饾悮饾悽饾悷饾悮, 饾悏饾悶饾惈饾惍饾惉饾悮饾惀饾悶饾惁, 饾悜饾悮饾惁饾悮饾惌-饾悊饾悮饾惂, 饾悋饾惃饾惀饾惃饾惂

heatmap jerusalem old buildings
Jerusalem-Heatmap of old buildings

If you need help, we will be happy to assist鈥馃檪

I鈥檓 Ran Tzkhori, a Geo-Spatial data and Spatial systems expert.

We help organizations find fast answers with the aid of spatial data and spatial SQL in their existing or new systems in house or in the cloud.

If you need advice, don鈥檛 hesitate to reach me.猬嗭笍

Share Post

Share on facebook
Share on twitter
Share on pinterest
Share on linkedin
Share on whatsapp
Share on telegram

Leave a Reply

Your email address will not be published.

诪注讘专 诇讛讜讚注讛
Hi There,
I am Ran, Mikoom鈥檚 Founder.
I will be happy to answer any question.
Just click on the button below to reach me.
Skip to content