Post reply

MapPoint with non-spacial data

  • December 8, 2010 at 9:43 am

    #231912

    Our system stores customer addresses with street, city, state, and zip, but would this be sufficient to use the SQL Plugin with MapPoint? From the few examples I've seen MapPoint relies on spacial data. So is it possible to use MapPoint to map addresses with just the address, city, state, and zip? Or what about just City and State to give a count of customers per City or State on a map?

    The only other alternative I can think of is getting a list of all US city Lat and Long coordinates and use that with MapPoint, if that's even possible.

    Thanks for any pointers as this would be a neat analytic to have.

  • December 8, 2010 at 10:01 am

    #1260194

    samalex (12/8/2010)

    Our system stores customer addresses with street, city, state, and zip, but would this be sufficient to use the SQL Plugin with MapPoint? From the few examples I've seen MapPoint relies on spacial data. So is it possible to use MapPoint to map addresses with just the address, city, state, and zip? Or what about just City and State to give a count of customers per City or State on a map?

    The only other alternative I can think of is getting a list of all US city Lat and Long coordinates and use that with MapPoint, if that's even possible.

    Thanks for any pointers as this would be a neat analytic to have.

    Hi

    You can go for Lat and Long coordinates. With Lat and Long you can set street, city, state, and zip.

    Thanks

    Parthi

    Thanks
    Parthi

  • December 9, 2010 at 6:31 am

    #1260531

    You don't really need the SQL Plug-in, MapPoint can import address, city, state, etc. directly without needing the plugin.

    You could either do this in batch by dumping to a list first (Access, Excel, text, etc.) or pro grammatically one by one.

    Eric

    http://www.MapForums.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply