citydata-mesaaz-gov/dobson-ranch-golf-rounds-24g5-hb8k
Icon for Socrata external plugin
 
Preview
  • dobson_ranch_golf_rounds
     
 
Readme
Updated 1 day ago
Indexed 5 hours ago

Dobson Ranch Golf Rounds

Provides information on activity levels and revenues at Dobson Ranch Golf Course, which is operated by Paradigm Golf Group.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
RowIDrowidrowidNumberUnique identifier
DatedatedateCalendar dateWhen the golf round was played in date format
Calendar Yearcalendar_yearcalendar_yearTextCalendar year
Fiscal Yearfiscal_yearfiscal_yearTextSpecifies the fiscal year by the two-year designation. The City of Mesa fiscal year for all departments is July 1 - June 30.
MonthmonthmonthTextCalendar month
DaydaydayNumberDay of the month
Day of Weekday_of_weekday_of_weekTextThe day of the week (ex. Sunday, Wednesday)
SunrisesunrisesunriseTextTime of sunrise
SunsetsunsetsunsetTextTime of sunset
Cart Rentalscart_rentalscart_rentalsNumberNumber of carts used in golf rounds. Derived from Cart Revenue
Cart Revenuecart_revenuecart_revenueNumberRevenue earned from cart rentals
Club Rentalsclub_rentalsclub_rentalsNumberNumber of club rentals. Derived from club rental revenue
Club Revenueclub_revenueclub_revenueNumberRevenue earned from golf club rentals
Food and Beveragefood_and_beveragefood_and_beverageNumberRevenue earned from food and beverage sales
Green Feesgreen_feesgreen_feesNumberRevenue earned from green fees
Merchandise Revenuemerchandise_revenuemerchandise_revenueNumberRevenue earned from merchandise revenue sales
Range Salesrange_salesrange_salesNumberRevenue earned from driving range use
Rounds Possiblerounds_possiblerounds_possibleNumberNumber of rounds that could possibly be played on this specific day and is found based on number of total hours of daylight available
Round Booking Rateround_capacityround_capacityNumberPercent of possible rounds that were played
Rounds Playedrounds_playedrounds_playedNumberNumber of rounds played
Total Revenuetotal_revenuetotal_revenueNumberSum of all revenues (Cart Revenue, Club Revenue, Merchandise Revenue, Green Fees, Range Sales, and Food and Beverage)
Revenue/Roundrevenue_roundrevenue_roundNumberCalculation: Total Revenue/Rounds
Upstream Metadata