Posts: 220
Name: Baris
|
Welcome to US Golf Courses Database
Description:
I think this the best golf courses database you can find for US, even it includes longitude and latitude
Fields:
1) ID
2) CAT
3) NAME
4) ADDRESS
5) TYPE
6) YEAR BUILT
7) DESINGER
8) GREENS GRASS TYPE
9) FAIRWAYS GRASS TYPE
10) WATER HAZARDS
11) SAND BUNKERS
12) YARDAGE MARKERS
13) ACCEPT TEA TIMES
14) EARLIES CALL FOR THE TEA TIMES
15) DRIVING RANGE
16) TRAINING FACILITIES
17) ONSITE GOLF PRO
18) DRESS CODE
19) SPIKES
20) GUESTS
21) ACCESS
22) DISCOUNTS
23) RENTAL CLUBS
24) CARTS
25) CART FEES
26) PULLCARTS
27) CADDIES
28) WALKING
29) RESTAURANT
30) BAR
31) HOURS
32) AVAILABLE PRODUCTS
33) COUNTY
34) HOMES ON COURSE
35) GOLF COMMUNITY
36) LATITUDE AND LONGITUDE (yes, it's real  )
Structure:
PHP Code:
CREATE TABLE `USgolf` ( `id` bigint(20) NOT NULL auto_increment, `cat` varchar(50) NOT NULL default '', `name` varchar(255) character set utf8 collate utf8 NOT NULL default '', `addressphonefax` text character set utf8 collate utf8 NOT NULL, `type` text character set utf8 collate utf8, `yearbuilt` text character set utf8 collate utf8, `designer` text character set utf8 collate utf8, `greensgrasstype` text character set utf8 collate utf8, `fairwaysgrasstype` text character set utf8 collate utf8, `waterhazards` text character set utf8 collate utf8, `sandbunkers` text character set utf8 collate utf8, `yardagemarkers` text character set utf8 collate utf8, `acceptteatimes` text character set utf8 collate utf8, `earliescallteatime` text character set utf8 collate utf8, `drivingrange` text character set utf8 collate utf8, `trainingfacilities` text character set utf8 collate utf8, `onsitegolfpro` text character set utf8 collate utf8, `dresscode` text character set utf8 collate utf8, `spikes` text character set utf8 collate utf8, `guests` text character set utf8 collate utf8, `access` text character set utf8 collate utf8, `discounts` text character set utf8 collate utf8, `rentalclubs` text character set utf8 collate utf8, `carts` text character set utf8 collate utf8, `cartfees` text character set utf8 collate utf8, `pullcarts` text character set utf8 collate utf8, `caddies` text character set utf8 collate utf8, `walking` text character set utf8 collate utf8, `restaurant` text character set utf8 collate utf8, `bar` text character set utf8 collate utf8, `hours` text character set utf8 collate utf8, `availableproducts` text character set utf8 collate utf8, `county` text character set utf8 collate utf8, `homesoncourse` text character set utf8 collate utf8, `golfcommunity` text character set utf8 collate utf8, `latitudeandlongitude` text character set utf8 collate utf8, PRIMARY KEY (`id`), KEY `cat_index` (`cat`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17018 ;
Sample from db:
PHP Code:
INSERT INTO `USgolf` VALUES (4, 'C', 'Casperkill Country Club', '2330 South Rd - Rte 9\nPoughkeepsie, NY 12601-5587\n 845-463-0900', 'Public', '1944', 'Robert Trent Jones, Sr.', 'Poa Annua Grass', 'Poa Annua Grass', 'Yes', '31-40', '200, 150, 100 Yard Markers', 'Yes', '7:00', 'N/A', 'Putting Green, Chipping Area, Teaching Pro, Golf School', 'Rhett Myers', 'No Denim, Collared Shirt and Bermuda Shorts Required', 'No', 'Open', 'Course', 'Twilight,Junior,Senior,None', 'Yes', 'Gas, Course access$0-5', '$10-15 per cart (18 holes), N/A per cart (9 holes)', '$0-5', 'Not Available', 'Allowed', 'Restaurant, Beverage Cart', 'Full Bar', 'Open Dawn, Close Dusk', 'Clubs, Apparel, Accessories', 'Dutchess', 'No', 'No', '41.646197,-73.923924');
Records: 17.017
Price: 49$
|