US Golf Courses Database (2008 Edition) with Geocodes - New and Updated Version

[soundofvtec]

Welcome to US Golf Courses Database

Description:

This database includes golf courses with high detailed information and it's completely uptodate(2008).

Please be sure that this is the newest version of our OLD "US Golf Courses Database".

What's the differences between old and new one?

- Fully updated 2008 Edition
- The most important difference is that we've added "STATE", "ZIPCODE" and "PHONE" fields into the database. So the database is able to be sorted by this fields easily.

Regarding to "old" customers, if you're an old customer for the previous "US Golf Courses Database", please inform us.

The database is available with SQL and EXCEL versions.

Fields:

1) ID
2) CAT
3) COURSE NAME
4) TYPE
5) NUMBER OF HOLES
6) ADDRESS
7) STATE
8) ZIPCODE
9) PHONE
10) YEAR BUILT
11) GREEN GRASS TYPE
12) FAIRWAYS GRASS TYPE
13) WATER HAZARDS
14) SAND BUNKERS
15) YARDAGE MARKERS
16) ACCEPT TEA TIMES
17) EARLIES CALL TEA TIME
18) TRAINING FACILITIES
19) ONSITE GOLF PRO
20) SPIKES
21) GUESTS
22) ACCESS
23) DISCOUNTS
24) RENTAL CLUBS
25) CARTS
26) CART FEES
27) PULLCARTS
28) WALKING
29) RESTAURANT
30) BAR
31) HOURS
32) AVAILABLE PRODUCTS
33) COUNTY
34) HOMES ON COURSE
35) GOLF COMMUNITY
36) LATITUDE
37) LONGITUDE

Structure:

CREATE TABLE USgolf3
(
    ID int ,
    CAT varchar(255),
    COURSE_NAME varchar(255),
    TYPE varchar(255),
    NUMBEROFHOLES varchar(255),
    ADDRESS varchar(255),
    STATE varchar(255),
    ZIPCODE varchar(255),
    PHONE varchar(255),
    YEARBUILT varchar(255),
    GREENGRASSTYPE varchar(255),
    FAIRWAYSGRASSTYPE varchar(255),
    WATERHAZARDS varchar(255),
    SANDBUNKERS varchar(255),
    YARDAGEMARKERS varchar(255),
    ACCEPTTEATIMES varchar(255),
    EARLIESCALLTEATIME varchar(255),
    TRAININGFACILITIES varchar(255),
    ONSITEGOLFPRO varchar(255),
    SPIKES varchar(255),
    GUESTS varchar(255),
    ACCESS varchar(255),
    DISCOUNTS varchar(255),
    RENTALCLUBS varchar(255),
    CARTS varchar(255),
    CARTFEES varchar(255),
    PULLCARTS varchar(255),
    WALKING varchar(255),
    RESTAURANT varchar(255),
    BAR varchar(255),
    HOURS varchar(255),
    AVAILABLEPRODUCTS varchar(255),
    COUNTY varchar(255),
    HOMESONCOURSE varchar(255),
    GOLFCOMMUNITY varchar(255),
    LATITUDE varchar(255),
    LONGITUDE varchar(255)
)ENGINE=MyISAM  DEFAULT CHARACTER SET utf8; 

Sample from db:

INSERT INTO `USgolf3` VALUES(1, 'H', 'Highland Park Golf Course', 'Public', '18', '3300 Highland Ave S Birmingham Alabama 35205-1411', 'Alabama', '35205-1411', '(205) 322 1902', '1998', 'Bent Grass', 'Bermuda Grass', 'Yes', '61-70', '200, 150, 100 Yrd Markers and Sprinkler Heads Marked', 'Yes', '7', 'Putting Green, Teaching Pro', 'Greg Gossett', 'No', 'Open', 'Path', 'Junior,Senior', 'Yes', 'Electric, Path access', '$5-10 per cart (18 holes)', '$0-5', 'Allowed', 'Restaurant, Snack Bar, Beverage Cart', 'Full Bar', 'Open 7', 'Clubs, Apparel, Accessories', 'Jefferson', 'No', 'No', '33.511615', '-86.778809'); 

Filetypes: SQL and EXCEL

Records: 17.000

Price: 69$

Regards

[FSGDAG]

Just out of curiosity, why does this one not have the url addresses and the UK one does?

[soundofvtec]

Just out of curiosity, why does this one not have the url addresses and the UK one does?

Well, because of most US ones don't have url address, we hadn't put them into