Google maps/earth demonstration - repost

In Progress

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.

Skills: Cartography & Maps

See more: real touch demonstration, prototype maps, prototype map, excel macro file location, creating a prototype, what is memo, google earth co, tah, shapes and sizes, see ELECTRICAL, google suggest, google earth, gis map, gis data, cartography, cartography and maps, excel shapes calculate, map data excel files, google sales maps, excel colour, google text data, iphone sales data, simple demonstration, postcode google map, www memo

Project ID: #4312834

Awarded to:


Hi I'm a Web Gis developer (since 2005) (Google Map, Google Earth, Bing, OpenLayers, Mapserver, MapGuide -Coldfsuion/ PHP /Javascript/Jquery/Json/XML/APIs - SqlServer/MySql/Oracle) I can help you with your map n More

$350 USD in 5 days
(0 Reviews)

4 freelancers are bidding on average $438 for this job


Hi, We have reviewed your project specification. Kindly check personal message box for more details on this. Thanks.

$300 USD in 10 days
(1 Review)

Hi, I can do this perfectly! Completed nearly 20 projects related to Google Map API customization with PHP + MySql. Please check PMB for more details,

$500 USD in 8 days
(0 Reviews)

Hello, I'll sent you a private message. Yours sincerely Christopher

$600 USD in 10 days
(0 Reviews)