Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 9 of 9

better import - better code - migrating to web service

This is a discussion on better import - better code - migrating to web service within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi! I need, starting from an access table, to find addresses on the map putting a pushpin on each address ...

  1. #1
    pileggi is offline Junior Member Yellow Belt
    Join Date
    Jul 2005
    Posts
    23

    better import - better code - migrating to web service

    Hi!
    I need, starting from an access table, to find addresses on the map putting a pushpin on each address finded. If I use the guided-import many addresses are not found and many others finded only at the city-level (not at the street-level). Then I have developed a lot of VB code and I have obtained somthing better but still not satisfying. The problem is that if the datas are not EXACTLY like the datas that MapPoint want, the addesses result not found. I.e. in Italy I look for "Via Giuseppe Garibaldi" ("Garibaldi Street") but MapPoint wants "Via Garibaldi Giuseppe" and doesn't find the address. Now I see that exist Bing-Maps and I see that it finds all addesses wathever mode I digit them (like Google-Maps do). I suppose that Bing-Maps is based on MapPoint cartography. Why with my MapPoint I can't have the same results of Bing-Maps?

    Practice can you please help me to get better my VBA code?

    Private Sub TryAddresses()
    Dim s(3) As String
    Dim rs As New ADODB.Recordset
    Dim strSQL As String
    Dim MPApp As New MapPoint.Application
    Dim oMap As New MapPoint.Map
    Dim objFindResults As MapPoint.FindResults

    strSQL = "select * from Indirizzi"
    rs.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
    Do While Not rs.EOF
    Set objFindResults = oMap.FindAddressResults(rs!Indirizzo, rs!Comune, , rs!Provincia, rs!Cap, geoCountryItaly)

    'some string-operations to compare the MapPoint-result with the original datas
    s(0) = objFindResults.Item(1).Name
    s(0) = Replace(s(0), Chr(146), Chr(39))
    s(1) = InStr(1, s(0), rs!Indirizzo, 1)
    s(3) = Mid(s(0), Len(s(0)) - 1, 2)
    If LCase(s(3)) = LCase(rs!Provincia) And s(1) <> "0" Then
    'the address is found
    rs!NonTrovato = 0
    rs.Update
    ElseIf LCase(s(3)) = LCase(rs!Provincia) Then
    rs!NonTrovato = 1
    'some code - it finds only the city
    Else
    rs!NonTrovato = 1
    'some code - it completely loses the address
    End If
    Loop

    MPApp.ActiveMap.Saved = True
    MPApp.Quit
    Set MPApp = Nothing
    rs.Close
    Set rs = Nothing
    End Sub

    Or you suggest me to use Bing-Maps Web-Service?
    Thank you,
    Pileggi

  2. #2
    alexramo is offline Member Green Belt
    Join Date
    Sep 2008
    Posts
    63

    Re: better import - better code - migrating to web service

    I too have this same concern, anyone want to chime in on this one?
    Is the Bing Webservice similar to the desktop version with respect to uploading addresses with the import tool?

    Thank you,
    -Alex

  3. #3
    pileggi is offline Junior Member Yellow Belt
    Join Date
    Jul 2005
    Posts
    23

    Re: better import - better code - migrating to web service

    Someone have suggest me to migrate to Bing-Web Services, he says that MapPoint has an old tecnology and it will no more developed by Microsoft in the future. But I've not written all (sorry). I need to put the pushpins of the addresses found on the map, then I need to draw an area, to have the best route between the addresses in the area, and to export in exel the list of the addresses. Can the eBing Maps web services do all these things? If yes, I think it will be more difficult to develope these things with Bing-Maps that with MapPoint (MapPoint does itself all these things). Why, if Microsoft doesn't want to develope MapPoint in the future, I can find MapPoint 2009 Europe edition, and I see that there is the beta-edition of MapPoint 2010 North America Edition? And, expecially, why Bill Gates takes my money and gives me a product that doesn't work? Does he know how much time and money I have lost to try to work with MapPoint?
    Sorry for my outburst, can you (please) help me to do the right choice?
    Thanks,
    Pileggi

  4. #4
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: better import - better code - migrating to web service

    I'm not sure I'll be much help but could you post up say 4 full addresses (including cap) that you know are valid but which MP can't locate. I've not done any geocoding in Italy but I have used MP in the UK, France, Spain and Germany so I'll see if any of the experience from these helps with Italy. Also would it be a possibility to use a specialist Italian web-agency to geocode your addresses (attach lat and long) and then use desktop MP for your analysis and mapping?
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  5. #5
    pileggi is offline Junior Member Yellow Belt
    Join Date
    Jul 2005
    Posts
    23

    Re: better import - better code - migrating to web service

    Thank you very much for your interest!

    These are 6 examples of failed addresses in Rimini (italian city):

    For each search:
    city: RIMINI
    province: RN
    postal-code: 47900
    in the address, after the comma, there is the 'house number'

    ********************

    Search:
    address: VIA CAMPANA DARIO, 92

    Google-Maps result:
    address: VIA DARIO CAMPANA

    ********************

    Search:
    address: VIA CECCARELLI, 7

    Google-Maps result:
    address: VIA GUIDO MARIA CECCARELLI

    ********************

    Search:
    address: VIA CADUTI DI MARZABOTTO, 12

    Google-Maps result:
    address: VIA CADUTI DI MARZABOTTO

    (MapPoint has "VIA MARZABOTTO")

    ********************

    Search:
    address: VIA ISOTTA, 30

    Google-Maps result:
    address: VIA ISOTTA DEGLI ATTI

    ********************

    Search:
    address: VIA SIGISMONDO, 9

    Google-Maps result:
    address: VIA SIGISMONDO PANDOLFO MALATESTA

    (MapPoint has "VIA PANDOLFO SIGISMONDO MALATESTA")

    ********************

    Search:
    address: VIA DELL' ALBERO, 30

    Google-Maps result:
    address: VIA DELL'ALBERO, 30

    (NB: MapPoint has "VIA DELL'ALBERO 30" - THE ONLY DIFFERENCE IS A "SPACE" CHARACTER)

    ********************

  6. #6
    pileggi is offline Junior Member Yellow Belt
    Join Date
    Jul 2005
    Posts
    23

    Re: better import - better code - migrating to web service

    If you don't have a solution for the problems in my previous post...

    You said: "Also would it be a possibility to use a specialist Italian web-agency to geocode your addresses (attach lat and long) and then use desktop MP for your analysis and mapping?"

    If the "specialist Italian web-agency" is free it would be better. Anyway we can value your suggestion.

    What do you think about the following idea that I had?
    I could use Bing-Maps to find the coordinates of each address (if it will takes long time, patience!) With these coordinates I could find the points on a MapPoint map. And with the points I could do all the remaining operations with the MapPoint engine.
    You think is it possible? May there be some problems with the Bing-Maps license?
    Thank you,
    Pileggi

  7. #7
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: better import - better code - migrating to web service

    Sorry, canít see any way round this. As you point out, based on the 6 addresses there appears to be very little format flexibility in the way MapPoint searches for the addresses. Iím amazed by the VIA DELL' ALBERO space issue. Iím surprised you say you got Bing maps to find them, because I couldnít on 4. Google maps appeared to work well. Clearly MP wonít meet your geocoding needs unless thereís a consistency in the way addresses vary that you could code as part of your geocoding routine. Sorry I couldnít help.
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  8. #8
    pileggi is offline Junior Member Yellow Belt
    Join Date
    Jul 2005
    Posts
    23

    Re: better import - better code - migrating to web service

    Quote Originally Posted by davidb View Post
    Sorry, can’t see any way round this. As you point out, based on the 6 addresses there appears to be very little format flexibility in the way MapPoint searches for the addresses. I’m amazed by the VIA DELL' ALBERO space issue. I’m surprised you say you got Bing maps to find them, because I couldn’t on 4. Google maps appeared to work well. Clearly MP won’t meet your geocoding needs unless there’s a consistency in the way addresses vary that you could code as part of your geocoding routine. Sorry I couldn’t help.
    You have reason: Bing fails 3 addresses on 6. I have done not enough tests. Then I'll use Google maps (to retrive the coordinates of the addresses). Do You think it's a good choice? If tomorrow I decide to sell my application will I have some problem?
    Thank you,
    Pileggi
    PS It could be a great thing to notify to microsoft that in Italy we are in so bud situation!

  9. #9
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: better import - better code - migrating to web service

    Quote Originally Posted by pileggi View Post
    If tomorrow I decide to sell my application will I have some problem?
    If you use a 3rd party application for geocoding then usually, as far as I'm aware, you have to pay.
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Import postcodes and name each one with a code
    By richard in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 12-03-2008, 02:25 PM
  2. How to import NMEA code into Mappoint
    By Atseer in forum Development
    Replies: 2
    Last Post: 11-28-2008, 12:29 PM
  3. Reporting service coverage by zip code and radius
    By jjmmbb in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-05-2004, 05:13 PM
  4. Zip code Import
    By ashort001 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-25-2002, 07:09 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57