Project Title: Google Maps –integration with existing query application.
I believe this is a fairly complex project – when bidding- please let me know if there are any items here which are not doable. We are looking for someone with experience in developing interactive mapping applications.
***The attached .pdf includes this project description and visual images of what we are trying to achieve (images are directional – not literal).
We have an existing web application (asp/C#) - that we use to query data on a hosted ([url removed, login to view]) SQL server database. The application is used to create summaries, lists and reports on client customer data. The query interface allows approximately 15-20 query parameters to be entered from the filter form. These query results are what will be used to create the mapping feature.
I have attached here a visual representation of how/where I would like the mapping feature integrated. Following are some of the options and requirements that we would like to have included.
Formatting: Would like to provide the user with the option to see the map with “shaded” areas OR “push pins/markers”. There will also need to be an option for mapping “routes”.
Metrics: Would like to provide the user with the option of which metric they would like to have mapped (EG: Density, Percentages, Counts, Top%/Bottom%, Indices)
Levels: Data will be available to map down to the household level. However, we will also have data grouped at the block group and zip code levels. Additionally, we’d like to give the user the option to select a radius.
Variables: The data that will be mapped will be either “customers” or “prospects”. We’d also like to be able to show both if possible. (Where customers would be marked by one color and prospects would be marked by another).
Dimensions: There are various characteristics of customers and prospects that we’d like to be able to differentiate on a map. For example, we may want to see all customers in zipcode 55555 by Campaign (Where the colors are distinguished by campaign). We would want to allow the user to select from a list of dimensions – on how they would like the customers/prospects to be viewed on the map.
Data: Data is geo coded
Other Design Elements: The map should include a logical legend.
A “header” should be returned with the map stating which filters were used to generate the map along with the date and time it was generated.
Provide a color scale selector allowing the user to control the level of shading differentiation/ transparency in the map
Process: I’m not sure exactly how the process will work, but I envision a temp table being created each time the query for a map is run and that table is then used for mapping. Of course, I’m completely open to suggestions and recommendations.
Once we move forward on the project, I will ask the coder to sign a confidentiality/work product agreement before we begin.