We are looking to investigate use of an iPAD to show visual information about our customers on a map. We're just looking for a demonstration of the kinds of thing that are possible, so a rough working prototype is all we need.
Test data is available in the following fields (example in brackets):
Name (ABC electrical)
UK Postcode (HG1 4DH)
Months since last order (3)
Type (E or W or O)
Sales this month (12.2)
Sales this quarter (21.5)
Sales this Year (232)
www ([url removed, login to view])
memo text (buyer is Joe, specialise in electric heating)
Phone 01235 654875
What we want is to be able to display a map on an ipad or iphone with "pins" accurately located showing the location of each customer and the data fields visible if you touch the pin.
we'd like the pins to be different (colours/shapes/sizes) depending on the data (say Type E one colour, type P another.). Maybe excel rules calculate pin colours types.
It would also be good if ift were possible to show more than one layer separately, for example just showing customers with a certain spend or of a certain type (these could be multiple boolean selections). This could be done by creating a separate kml (?) file for each layer, so you couldnt view a new layer that wasnt previsouly uploaded, or maybe it is possble to do the search in real time so the user can select what cstomers to see.
we'd also like suggestions of any other features that might interestng and useful. The whole point is we are looking to explore possibilities.
Note we hold UK post codes not geo co-ordinates so we need a way of converting these for accurate display. Conversions are once-only, customers are added rarely.
We do want to keep things very simple. If all we have is an excel macro that generates kml files tah tmight be OK. But if you think there is a better solution, please suggest. We are fairly good at non-macro excel but not experienced in KML/GIS.
We have around 1000 live customers and maybe 4000 more in total. We might present subsets in diffeerent layers - so we might only display a couple of hundred in any one layer.