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)