MapForums
Community of VE/MapPoint Users and Developers
Draw shape, select zip codes and export to SQL
This is a discussion on Draw shape, select zip codes and export to SQL within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hello people... Any ideas on how to draw a polygon on a geomap of zip codes, have the user select ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-01-2007
| |||
| |||
 Draw shape, select zip codes and export to SQL Any ideas on how to draw a polygon on a geomap of zip codes, have the user select the area,trap the zips in the shape and export to a dataset? I am using mappoint 2006 in visual studio 2005 via activex, VB. Best M. Martin         |
|
04-02-2007
| |||
| |||
| Re: Draw shape, select zip codes and export to SQL
1) Display the drawing toolbar, which allows the user to activate the polygon tool. See the Control.Toolbars property. 2) Check to see which shape (polygon) is selected using the Selection property. Or in a click event, use ObjectsFromPoint to get the underlying shape. 3) Assuming you have coded pushpins for all zipcodes (easily done using the data mapping wizard and a demographic set), you can retrieve all zipcodes within the selected shape using the QueryShape method. 4) Use your favorite VB ADO method to export the returned pushpin information to a dataset. HTH Paul |
 |
| Tags |
| codes, draw, export, select, shape, sql, zip |
| ||||
| Posted By | For | Type | Date | |
| MapPoint Gets New General Manager - MapPoint News - MP2K Magazine | This thread | Refback | 04-14-2007 10:03 AM | |
| Determing Whether A Point Is Located Inside Polygon - MapPoint Articles - MP2K Magazine | This thread | Refback | 04-11-2007 03:10 PM | |
| Spatial Data Importer Contest Submission - MP2K Magazine | This thread | Refback | 04-09-2007 05:19 PM | |
| Using MS MapPoint in PowerBuilder - MapPoint Articles - MP2K Magazine | This thread | Refback | 04-05-2007 02:21 PM | |
| The Magazine for MapPoint - MP2K Magazine | This thread | Refback | 04-05-2007 01:19 PM | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Start Draw shape (freeform) | Anonymous | MapPoint 2006/2009 Discussion | 2 | 10-24-2006 07:37 PM |
| Export Zip Codes To Excel | JimS | MapPoint 2006/2009 Discussion | 4 | 01-24-2006 02:46 PM |
| zip codes within a shape or radius | rforkner | MapPoint 2006/2009 Discussion | 2 | 01-12-2005 08:25 PM |
| Find and Export of ZIP Codes | Anonymous | Wish List | 1 | 01-16-2003 07:22 PM |
| If I draw a closed shape around some pushpins, and.... | Anonymous | MapPoint 2006/2009 Discussion | 1 | 03-09-2002 11:48 PM |
All times are GMT -5. The time now is 04:47 PM.
