Something

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 kelper.gl

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 kelper.gl (rich WebGL GIS fast browser library)

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

๐“๐ก๐ž “๐–๐ข๐ง๐ง๐ข๐ง๐ ” ๐œ๐ข๐ญ๐ข๐ž๐ฌ ๐š๐ซ๐ž: ๐“๐ž๐ฅ ๐€๐ฏ๐ข๐ฏ, ๐‡๐š๐ข๐Ÿ๐š, ๐‰๐ž๐ซ๐ฎ๐ฌ๐š๐ฅ๐ž๐ฆ, ๐‘๐š๐ฆ๐š๐ญ-๐†๐š๐ง, ๐‡๐จ๐ฅ๐จ๐ง

Jerusalem-Heatmap of old buildings

Share Post

Share on facebook
Facebook
Share on twitter
Twitter
Share on pinterest
Pinterest
Share on linkedin
LinkedIn
Share on whatsapp
WhatsApp
Share on telegram
Telegram

Leave a Reply

Your email address will not be published.

ืžืขื‘ืจ ืœื”ื•ื“ืขื”
1
Hi There,
I am Ran, Mikoomโ€™s Founder.
I will be happy to answer any question.
Just click on the button below to reach me.
Skip to content