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:
Sample from db:PHP Code: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;
Filetypes: SQL and EXCELPHP Code: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');
Records: 17.000
Price: 69$
Regards



