I have 3 questions as part of a market penetration project:
1. Building Duplicate Removal
I have a collection of various files housing latitude/longitudes of buildings. Unfortunately, many buildings are repeated (with slightly different lat and longs). I am looking for a way to:
- identify the duplicate buildings - assume buildings within 20m of each other are duplicates, and
- keep one and filter out the rest - based on the order of the files - some files are more important/accurate than others
Any ideas of how to do this efficiently?
2. Market penetration by polygon
The second part deals with understanding market penetrations. Once the duplicates are removed (as above), I’d need to count a certain set of buildings - let’s say my retail stores, and divide it by the total retail stores within a spatial polygon (.shp file). I can then get the market share/penetration of my stores, out of all the stores in that area which sell the same thing. Are there nodes which do this type of analysis?
3. Chloropleth mapping
Lastly, I’d like to map the above using a chloropleth map, does OpenStreetMaps have this functionality, or could I export to Tableau to allow it to be interactive?