DATABASE: 18,972 Golf Courses with 50,597 reviews and MORE! Price: $39

[chatmasta]

Golf Course Database

For sale is a database of 18,972 golf courses from 50 US States and 6 Canadian Provinces. Every golf course entry is very detailed and includes a fulltext description. Accompanying the courses are 14,486 country clubs and 50,597 reviews of the courses.Every review has at least a username and course rating, and over 33,000 have a fulltext comment. Each review also includes the user's average score, and sometimes includes their handicap. There's a lot more data too! See the database layout below for more details.

What You Can Do With It

• Make a content site for indexing power. Eli (Bluehatseo) recommends using databases just like this to quickly build vast content sites. You can easily create thousands of pages for google to index. Then you can put a link on every page, giving you immense indexing power.
• Geotarget people. If you know your visitor's location, you can show them all the nearby golf courses! Combine this with other geotargeting data for strong content.
• Lots more! This is a versatile database and the possibilities are endless.

I'm sure you can think of plenty more creative uses for this database. Those listed above are just a few. Theres definitely a lot of potential in combining this with other techniques.

Features

• Massive. With just under 19,000 courses, this encompasses almost all of the golf courses in the United States and a lot in Canada.
• Normalized and optimized. The database structure is normalized and optimized for fast, efficient querying.
• A flattened table. While a "normalized and optimized" database structure may be fast, it can get complicated. If querying is too much of a pain, or you don't want your data to be normalized for some reason (maybe you need to plug it into a content generation script), a separate table is included.
• Complete and comprehensive readme file. To help you set everything up as fast as possible, I included a very comprehensive and detailed readme file with the database. It includes sample queries for most common tasks.
• A functions.php file to show you how to query the database. To assist in getting your site up and running ASAP, there is a functions.php file filled with common functions for querying the database. Functions include getCoursesByCity, getCitiesByState, etc.

Database Schema

As I said, if you don't like this schema or have different needs, the courses_flat table is for you.

CREATE TABLE IF NOT EXISTS `cities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `state_id` int(11) NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `state_id` (`state_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6537 ;

CREATE TABLE IF NOT EXISTS `clubs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `club` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14487 ;

CREATE TABLE IF NOT EXISTS `courses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `club_id` int(11) NOT NULL,
  `golflink_id` int(20) NOT NULL,
  `city_id` int(11) NOT NULL,
  `state_id` int(11) NOT NULL,
  `country` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `distance_from_city_center` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `zip_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `address_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `website` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `about_course` text COLLATE utf8_unicode_ci NOT NULL,
  `about_facility` text COLLATE utf8_unicode_ci NOT NULL,
  `rating_overall` float NOT NULL,
  `rating_amenities` float NOT NULL,
  `rating_difficulty` float NOT NULL,
  `rating_maintenance` float NOT NULL,
  `rating_scenery` float NOT NULL,
  `rating_value` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `golflink_id` (`golflink_id`,`city_id`,`state_id`,`zip_code`,`rating_overall`),
  KEY `course_name` (`course_name`),
  KEY `club_id` (`club_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=22260 ;

CREATE TABLE IF NOT EXISTS `courses_flat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `club_id` int(11) NOT NULL,
  `golflink_id` int(20) NOT NULL,
  `city_id` int(11) NOT NULL,
  `state_id` int(11) NOT NULL,
  `country` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `distance_from_city_center` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `zip_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `address_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `website` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `about_course` text COLLATE utf8_unicode_ci NOT NULL,
  `about_facility` text COLLATE utf8_unicode_ci NOT NULL,
  `rating_overall` float NOT NULL,
  `rating_amenities` float NOT NULL,
  `rating_difficulty` float NOT NULL,
  `rating_maintenance` float NOT NULL,
  `rating_scenery` float NOT NULL,
  `rating_value` float NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `state_abbreviation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `golflink_id` (`golflink_id`,`city_id`,`state_id`,`zip_code`,`rating_overall`),
  KEY `course_name` (`course_name`),
  KEY `club_id` (`club_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=22260 ;

CREATE TABLE IF NOT EXISTS `reviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL,
  `date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `rating` float NOT NULL,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_handicap` int(3) DEFAULT NULL,
  `user_average` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`,`user_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=50598 ;

CREATE TABLE IF NOT EXISTS `states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `state` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `abbreviation` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `state` (`state`,`abbreviation`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=59 ;

If you would like your database in a form other than MySQL (I support CSV, CSV for excel, Open Document Spreadsheets, XML, YAML), just let me know.

Bonus!
Also included are 15 golf course thumbnails. They look like this:

Pricing

Price: $39
Payment via PayPal only. PM me or post here to purchase.

 

[chatmasta]

Nobody buying at $39, guess it's too high!

PRICE IS NOW $29*






*$49 at digitalpoint

 

[jelf]

economy is collapsing, review copiez haha

 

[martinelli]

I will buy for $29. PM me please.