Migrate table 3.2 to a new Land Use table with simplified land uses

[drorgivton]

MAVAT's 3.2 which holds all the changes to the land uses has hundreds of different uses.

We want to bucket them under meaningful and simplified categories.

Pre-conditions: Table 3.2 is in the database.

• Create a resource based on this mapping from MAVAT_land_use to MEIRIM_land_use https://docs.google.com/spreadsheets/d/1K-RyQJkjq3fxaqs5sHfOVkue2rNINOS-mwGRrA5M3d0/edit#gid=805926489

• create a new db table, Plan_land_use, with the following fields:
  land_use (text), area (decimal) , is_new_value (boolean)

• add A new backend method that returns the MAVAT_land_use with parameter of MEIRIM_land_use

• add a new backend method that takes plan's table 3.2 and creates the Plan_land_use with it. The method should aggregate land-uses of the same meirim_land_use name

• extend the crawler with the above method - on new and changed plans

• create Plan_land_use for the existing plans

table_3_2_designations.csv

[GalGend]

Hi @TomerMe2 @muamichali Please update status of this task

[TomerMe2]

Hi @TomerMe2 @muamichali Please update status of this task

I'm working on the tests for the crawler of table 3.2.
This specific task hasn't started yet.

[muamichali]

The crawler outputs table 3.2 for each plan. It has n rows in it. For each row, we need to take stuff like "מסחר ותעשייה" and return ["מסחר", "תעשייה" ] (it was an easy example, we have harder examples in the data) and we need to save that to the db.

@muamichali will start with the implementation of the algorithm that translates each usage in table 3.2 to the desired output including tests.

UPDATE 2/14: un-assigning for now because of limited availability, but I will stay in touch w @TomerMe2 and hope to help on this soon.