Ideally, I'd like the following delivered within a week.
We have 26 million address records (CSV format) consisting of a postcode, unique reference, grid reference. We have a separate file showing 26 million exact property locations consisting of Unique Reference number and Grid Reference. We also have a postcode boundaries file (SHA format or KML).
We want users to be able to draw onto a UK map, pan and zoom and select one of several tools (radius, drive time, continuous line (continuous line includes a line width adjustment), or a polygon). Once the drawing has been completed, we want to instantly show two record counts (1) Address records that fall within the polygon / under the continuous line. (2) Exact Locations within the polygon / under the continuous line.
Alternatively, users can type a partial postcode (either a Postcode Area AB, District AB10, Sector AB10 7) and the system draws a polygon around the boundary of the postcode area, district or sector then pans and zooms to the postcode boundary on the map, whilst showing the number of address records as described above.
The system will need to be lightening quick and keep in mind that we will be adding data to the system over time, so think about being future proof.
On the screen we will have register / login tools, save button (greyed out until logged in), download button (greyed out until logged in).
All of the work must be well designed / presented so that I can present to our partners as a finished service in order to acquire funding to develop further.
Other functionality: Register / Log In / Reset Password (First, Last, Email, Company, Address, Tel
After logging in: Switch in and out of Admin Dashboard (if admin privileges set) Save selection (specify their own reference name) List saved selections (archive, load, duplicate)
Admin Dashboard: Switch back to standard user board See list of registered users - name, email address, create date, last logged in Suspend, activate users