Google Answers Logo
View Question
Q: Google API for querying businesses on ( No Answer,   2 Comments )
Subject: Google API for querying businesses on
Category: Computers > Software
Asked by: swdenton-ga
List Price: $15.00
Posted: 09 Nov 2006 09:24 PST
Expires: 09 Dec 2006 09:24 PST
Question ID: 781372
I am an ASP.NET web developer (both VB/C#) and I want to create a web
page where, onload, a script will run that will query the database and return an array of every golf
course,address,city,state,and zip in the United States.

To further explain, say I was writing a SQL statement.  The
pseudo-code would look something like this:

SELECT Name,Address,City,State,Zip FROM
WHERE What="Golf Course"

I don't need the code written for me or anything, I just need to know
a) if this is possible, b) which GoogleAPI I would use to accomplish
this, and c) (optional) a shove in the right direction, such as a URL
with this sample code, or a website that currently does this, or
suggestions, or whatever.
There is no answer at this time.

Subject: Re: Google API for querying businesses on
From: pooranprasad-ga on 29 Nov 2006 12:28 PST
a) It is possible
b) You can store the coordinates in database and search for them
  The procedure is to
1. Geocode all the Golfcourse manually 
Usually you will be using host of polygons to represent a golf course
perimeter, which would be something like this..

var polyline = new GPolyline([
    new GLatLng(37.4419, -122.1419),
    new GLatLng(37.4519, -122.1519),
    new GLatLng( 37.4619, -122.1819)
], "#FF0000", 10);
Check also ://

2. Then you can store the longitude and latitude info along with name
in your database.
  You can store '37.4419, -122.1419 37.4519, -122.1519 37.4619,
-122.1819' as varchar, and 'XYZ Golf Club' as string to represent your
golf club. Also you can add more information as in

3. You can show all golf clubs like the example in
Subject: Re: Google API for querying businesses on
From: pooranprasad-ga on 29 Nov 2006 12:31 PST
Also, you can use search like 

Query like 
SELECT Name,Address,City,State,Zip FROM
WHERE What="Golf Course"
is possible.. 
You should be able to generate on the fly xml based on the query for
the required golf course and do something similar to example in

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy