Write a PostgreSQL code to count the unique footfalls inside each mall basis it's date. I'll provide the malls' bounding boxes in a shape file. And will also provide the list of footfalls. You need to count the unique footfalls for each date in a mall. The output should be as mentioned in the output file below. Moreover, we even need the intermediate file as shown below.
Greetings! I hope you are doing well. I can write a postgresql script for calculating all the footfal count inside mall boundaries. Get in touch. REgards, Alauddin
2 pekerja bebas membida secara purata ₹2750 untuk pekerjaan ini
I have worked on footfall counts previously for a huge retail client. You can get the required output file in the desired format in expected timeline