Visualize a map using zip codes
Many ordering systems store Zip codes when a customer places an order (ours is no different). It'd be very neat to be able to map all of these zip codes for the US (and maybe beyond) by either estimating a lat/long position to show pins on a map or a heat map. We store a zip code for each of our customers purchases and would love to see this info on a map. We have "stores" all over the globe and this data is very valuable to us. A bunch of 5 digit numbers mean little in table form when compared with a map representation. Some other things that might make this neat: - Aggregate functions on a map - being able to see the number (sum, count, etc) of purchases or actions from a particular zip code - Use Case: a coverable zone indicating 12 purchases from zip code 12345 - Ability to set an epicenter using variables. For example: a different color pin or marker indicating a special location such as a store with pins surrounding it. We'd really love to be able to do this through a joined table. - Use Case: we'd like to see where the store is on the map (maybe using a different color or marker style) and a bunch of other markers indicating purchases. - Different markers for different fields. If a purchase was refunded, it could show up as red. If it was a purchase that was successfully handled it could be green. This could possibly be handled by being able to overlay different maps/queries. - Use Case: Being able to see refunded purchases, completed purchases, purchas
Posted by iwaffles on Mar 28, 2017, 11:06 PM
Tags
Related issues
Raise real-world problems, find people facing the same issue, and discuss solutions.4,500 issues0 comments
github (E-commerce)
proposal: cmd/cgo: cgo without a C toolchain
Replace PowerToys Run with Command Palette
VPS with a vRack leg
Possibility of Portal 1 Code Inclusion
Introducing NewPlayer
Metrics for PRs are never expiring ("memory leak")
ship even more of the compiler in source form
Flatpak Application TRACKING ISSUE
Visualize a map using zip codes
Many ordering systems store Zip codes when a customer places an order (ours is no different). It'd be very neat to be able to map all of these zip codes for the US (and maybe beyond) by either estimating a lat/long position to show pins on a map or a heat map. We store a zip code for each of our customers purchases and would love to see this info on a map. We have "stores" all over the globe and this data is very valuable to us. A bunch of 5 digit numbers mean little in table form when compared with a map representation. Some other things that might make this neat: - Aggregate functions on a map - being able to see the number (sum, count, etc) of purchases or actions from a particular zip code - Use Case: a coverable zone indicating 12 purchases from zip code 12345 - Ability to set an epicenter using variables. For example: a different color pin or marker indicating a special location such as a store with pins surrounding it. We'd really love to be able to do this through a joined table. - Use Case: we'd like to see where the store is on the map (maybe using a different color or marker style) and a bunch of other markers indicating purchases. - Different markers for different fields. If a purchase was refunded, it could show up as red. If it was a purchase that was successfully handled it could be green. This could possibly be handled by being able to overlay different maps/queries. - Use Case: Being able to see refunded purchases, completed purchases, purchas
Comments (0)
No comments yet. Start the discussion.