Introduction to system
I am tasked to develop a web based interface for real estate management system for a client. The requirements so far are
- The admin must be able to view all the plots in the society
- The users must be able to search plots in the society with different filters like plot size, type (residential,commercial) etc.
- The society has following structure at top there are sectors which then have blocks and each block has a certain amount of residential, commercial plots
The total no of plots provided to me so far are around 14000 and they are expected to grow 3X more. I have been given a shapefile of digitized plots and asked to convert them into a MySQL database. The total size of the table is around 60MB.
Problem
- How do I proceed to show plots because showing all plots at first will strain the server, user system and internet.
- Should a dynamic GeoJSON be created and fetched from the database or should I store a GeoJSON with all the data. But an already created GeoJSON will amount to around 60MBs as well.
- The search functionality must show all the plots that meet the criteria that is specified in the search irrespective of the sectors and blocks.
Here is a picture of the masterplan of the site it has all the plots with demarcation, blocks and sectors.
