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
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
RowID | rowid | rowid | Number | Unique identifier |
Date | date | date | Calendar date | When the golf round was played in date format |
Calendar Year | calendar_year | calendar_year | Text | Calendar year |
Fiscal Year | fiscal_year | fiscal_year | Text | Specifies the fiscal year by the two-year designation. The City of Mesa fiscal year for all departments is July 1 - June 30. |
Month | month | month | Text | Calendar month |
Day | day | day | Number | Day of the month |
Day of Week | day_of_week | day_of_week | Text | The day of the week (ex. Sunday, Wednesday) |
Sunrise | sunrise | sunrise | Text | Time of sunrise |
Sunset | sunset | sunset | Text | Time of sunset |
Cart Rentals | cart_rentals | cart_rentals | Number | Number of carts used in golf rounds. Derived from Cart Revenue |
Cart Revenue | cart_revenue | cart_revenue | Number | Revenue earned from cart rentals |
Club Rentals | club_rentals | club_rentals | Number | Number of club rentals. Derived from club rental revenue |
Club Revenue | club_revenue | club_revenue | Number | Revenue earned from golf club rentals |
Food and Beverage | food_and_beverage | food_and_beverage | Number | Revenue earned from food and beverage sales |
Green Fees | green_fees | green_fees | Number | Revenue earned from green fees |
Merchandise Revenue | merchandise_revenue | merchandise_revenue | Number | Revenue earned from merchandise revenue sales |
Range Sales | range_sales | range_sales | Number | Revenue earned from driving range use |
Rounds Possible | rounds_possible | rounds_possible | Number | Number 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 Rate | round_capacity | round_capacity | Number | Percent of possible rounds that were played |
Rounds Played | rounds_played | rounds_played | Number | Number of rounds played |
Total Revenue | total_revenue | total_revenue | Number | Sum of all revenues (Cart Revenue, Club Revenue, Merchandise Revenue, Green Fees, Range Sales, and Food and Beverage) |
Revenue/Round | revenue_round | revenue_round | Number | Calculation: Total Revenue/Rounds |
Upstream Metadata