-1

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

  1. The admin must be able to view all the plots in the society
  2. The users must be able to search plots in the society with different filters like plot size, type (residential,commercial) etc.
  3. 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

  1. How do I proceed to show plots because showing all plots at first will strain the server, user system and internet.
  2. 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.
  3. 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. Masterplan with plots, sectors and blocks