MapForums

I'm attempting to generate drive time polygons to answer a basic question. We have members all geocoded in SQL Server 2008, which supports geospatial operations. We have "crow flies" distances to our facilities for each member, but desire an area drawn that describes a 20 drive *time*.

Of course, this is easy to show on a MapPoint map. We need to then determine which members (potentially 250K) are in the 20 minute bounday of the polygon. This is easy if a data filled shapefile can be exported of the points of the polygon into ESRI and another utility is used to import into SQL and the operations are done from SQL server, not the Mappoint desktop.

I've tried the MPSuperShape add in, but no dbf contents seem to be exported in the project . I can simplify the polygon to a dozen points and put in pushpins and read the lat/long of each pushpin in the status bar. Now here's where I need help: Can I programmatically enum and export the lats and longs or better yet, a data filled polygon?

Any help is appreciated. Thanks in advance.

Michael Clifford

Hi Michael,

We create our own utils in C#; that one is most useful.
Interestingly, shapes in MapPoint cannot exist with a hole in them,
so shapes overlap.

You'd use:

Foreach Shape
{
dataSet.QueryShape
}

Michael R Mattys
Business Process Developers
Mattys Consulting Maps & Custom Programming

Sorry, I'm not comprehending. What utility?

Michael

Hi Michael,

We make our own Addins in C# using Visual Studio.
We also program SQL Server 2008 Geography/Geometry.


Michael R Mattys
Business Process Developers
Mattys Consulting Maps & Custom Programming