Createing a Latitude / Longitude Database ?

Discussion in 'Javascript' started by Mel Smith, Aug 27, 2011.

  1. Mel Smith

    Mel Smith Guest

    Hi:

    (I'm a Google Maps newbie: I have created a web page that shows the
    homes in my seniors community, and yesterday, thru javascript, was able to
    place 'markers' on various homes)

    I have approx 600 addresses in my community (Arizona, USA). The
    addresses are properly formatted for the Google Geocoder. These addresses
    are currently in my own database (xBase not SQL).

    As a _one time_ task, I wish to:

    1. Pick out the each of addresses serially from my database.
    2. Pass the address to the web site:
    http://maps.googleapis.com/maps/api/geocode/json?address=some address&sensor=falso
    3. Capture the json output programmatically (I use a C-based
    language: Harbour, but can use/understand javascript in an elementary
    sense).
    4. Pick out the Latitude and Longitude from the result (e.g.,
    latlng=results[0].geometry.location)
    5. Place the result in my database in a field beside the street
    address.
    6. Start at step 1 above until finished

    Can someone help me with step 3. (Step 2 is a bit of a programming task
    too). ?

    Thank you.
    --
    Mel Smith
     
    Mel Smith, Aug 27, 2011
    #1
    1. Advertising

  2. Mel Smith

    Mel Smith Guest

    "Mel Smith" <> wrote in message
    news:...
    > As a _one time_ task, I wish to:
    >
    > 1. Pick out the each of addresses serially from my database.
    > 2. Pass the address to the web site:
    >
    > http://maps.googleapis.com/maps/api/geocode/json?address=some address&sensor=falso
    > 3. Capture the json output programmatically (I use a C-based
    > language: Harbour, but can use/understand javascript in an elementary
    > sense).
    > 4. Pick out the Latitude and Longitude from the result (e.g.,
    > latlng=results[0].geometry.location)
    > 5. Place the result in my database in a field beside the street
    > address.
    > 6. Start at step 1 above until finished



    Hi:

    After some puzzling and head-scratching, and programming this morning,
    I've solved my own problem, and am building my own harbour proggie that does
    the tasks above.

    I'll post my completed program solution later (if anyone wishes) -- but
    basically:

    I used my tIP librairies to vist the site, receive the response
    (i.e., the 'results' json data), then parse it to pick out the stuff I nedd
    (i.e., the lat and lng)


    Sorry to trouble you.

    --
    Mel Smith
     
    Mel Smith, Aug 27, 2011
    #2
    1. Advertising

  3. Mel Smith

    Mike Duffy Guest

    "Mel Smith" <> wrote in
    news::

    > Sorry to trouble you.


    You solved your own problem. That is no trouble for anyone.

    It is always interesting to see what others are doing.

    --
    http://pages.videotron.ca/duffym/index.htm#
     
    Mike Duffy, Aug 28, 2011
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. YS Sze
    Replies:
    4
    Views:
    636
    -berlin.de
    Feb 7, 2004
  2. kbperry
    Replies:
    2
    Views:
    307
    kbperry
    May 31, 2006
  3. helpneeded
    Replies:
    6
    Views:
    518
    Help needed
    Aug 1, 2006
  4. Replies:
    5
    Views:
    2,484
    Luc The Perverse
    Aug 14, 2006
  5. Penn
    Replies:
    5
    Views:
    577
Loading...

Share This Page