Readme
Updated 1 day ago
‧ Indexed 4 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