PDA

View Full Version : MapPoint Add-in for SQL Server



bisi_mapuser
10-06-2009, 09:44 AM
Good Morning,

I am a newbie with MapPoint and recently installed MapPoint 10 with the add-in for SQL Server. I am able to connect to the database using the add-in utility. On the "Add Layer" tab, I am able to view and select any table.

The problem is under Select a label column, the check box for Show labels for Map is disabled. The "Add Layer" button is disabled as well.

I am certain I am doing something wrong. Could this be the data in the table that I am selecting - it's just a code table? Does the table need to have geographical or spatial data?

I am confused. Any help or comments would be greatly appreciated.

Many thanks.

FraserBlyth
10-18-2009, 03:29 PM
I'm new here but I've just been doing the same thing for the first time.I had to add a Geography column to the table, populate it with a point representing the lat/long.

Eric Weitzman
10-29-2009, 03:59 PM
You cannot add a non-spatial table directly as a map layer because there's no location information that can be used to create a mappable feature for each row. The "Add Layer" dialog lets you see all your tables if you choose -- including those without geography columns -- because there are several ways that you could map non-spatial data.

1. Add a spatial column and populate it using some external tool/technique such as geocoding the addresses in the table. MapPoint can geocode using various file formats, but you'd have to get the info back into SQL Server.

2. Create a view in SQL Server that joins your non-spatial table to a spatial table and then add a layer based on this view.

3. Select a non-spatial table, and then use the Common Table Expression capability in the add-in's "Add Layer" dialog. This will let you define a view on the fly that joins your non-spatial table to another spatially-enabled table such as you might have used in #2. (You could also invoke SQL functions that return "geography" data, but it's not likely that you have something to do this.)

I'd recommend method #3 if you have a spatial table that you can join your non-spatial data to.

In case I misunderstood: If your table has spatial data in it, the geography columns will be shown in the list box and you can select one of them to define the location of each feature. The label columns listbox will be filled with the column names in your table that have text representations (i.e., dates, varchar, and so on, but not binary types). If there aren't any spatial columns, most of the form will be disabled since the table cannot be mapped.

- Eric

Mefior
11-19-2009, 04:08 AM
I have question how Can I retrieve spatial data from MapPoint? Is it possible?I can add my data (sales) using excel but I rather would like to do this using ms sql. How Can I add layer to map if I dont have a spatial data?

Eric Weitzman
11-20-2009, 01:55 PM
mefior,

When you import directly into MapPoint using an excel spreadsheet as a data source, MapPoint "geocodes" the data for you. That is, you tell MapPoint which column in the spreadsheet contains addresses, or city names, or state names, etc, and MapPoint uses the supporting data it comes with to convert your excel info into geographic point locations. SQL Server does not have an equivalent function, nor does it come with the data needed to do geocoding like MapPoint does.

I'd suggest using one of the techniques I outlined in my previous post.

You can write code to read your SQL data, use a web service (like Bing maps) to geocode it, and then update your SQL data with the spatial data. This is a variation of the first option I listed.

Another thing you could try is to create a spreadsheet that uses SQL server as a datasource, then use MapPoint to import the spreadsheet! :shifty2: You won't have the add-in's mapping capabilities if you go this route, though.

- Eric

slayvic
01-19-2010, 11:51 AM
hello every body!
firstly im begginer in mappoint 2009 and i must create a map connect with sql 2008 ,i install the add-in sql but i dont know whats the first step to begin can u help me please!!
regards

Jonnei
10-12-2010, 07:26 PM
I'm having a similar problem, except my database has geo coding in it. I think my problem is that latitude and longitude are two seperate columns. Is there a way to combine them within a CTE statement? Whats the best way to fix this?

Thanks for any help.

mlukianoff
12-17-2010, 01:09 PM
Does anyone know if a 64 bit version of the sql addin is planned? I'm really dissappointed to find that it's not compatible after going through an extensive upgrade.

Eric Frost
12-17-2010, 01:12 PM
Since I got a Windows 7 64-bit machine, I find having a VMWare desktop with Windows XP is invaluable, especially for development. Not too many but certainly some stuff just doesn't work in 64 bit.

Eric

Winwaed
12-20-2010, 09:02 AM
Microsoft's own Virtual PC is another alternative - I'm using it to do the same (run XP on a Win7 x64 system) - primarily for Visual Studio 6, but also an old accounting package (which will be replaced at the end of the financial year).

Richard

Mitch0620
01-20-2011, 12:59 PM
Hi! am also a newbie with Map Point. I recently downloaded the SQL addin and I have here an exe file named MPSQL. How do I use this? I mean, would there be changes on the toolbars or tools of my map point? As I understand, there would be a capability of creating map layers right? I need this badly. Please help.