Listings Data Structure

This is the final proposed data structure:

{
    "Property": {
        "HotelName": "Example Hotel",
        "GPS":"",
        "Address": "123 Example Street",
        "City": "Example City",
        "LocalRegion": "Example State",
        "TotalHotelRooms": 100,
        "Photos": [
            "url_to_photo1.jpg",
            "url_to_photo2.jpg"
        ],
        "PropertyAmenities": {
          "Photos": [
            "url_to_amenity_photo1.jpg",
            "url_to_amenity_photo2.jpg"
          ],
          "WiFi": true,
          "SwimmingPool": true,
          "Parking": true,
          "Gym": true,
          "SpaServices": false,
          "Restaurant": true,
          "Bar": true,
          "RoomService": true,
          "LaundryService": true,
          "BusinessCenter": true,
          "ConferenceRooms": true,
          "BanquetFacilities": false,
          "ChildcareServices": false,
          "ConciergeService": true,
          "CurrencyExchangeService": false,
          "GiftShop": true,
          "AccessibilityFeatures": true,
          "AirportShuttle": true,
          "CarRentalDesk": false,
          "Casino": false,
          "GolfCourse": false,
          "TennisCourts": false,
          "PrivateBeachAccess": false,
          "SkiInSkiOutAccess": false,
          "BikeRental": true,
          "ElectricVehicleChargingStation": true,
          "PetFriendly": true,
          "NonSmoking": true,
          "24HourFrontDesk": true,
          "Sauna": false,
          "TurkishBath": false,
          "Solarium": false,
          "HotTub": false,
          "Library": true,
          "GameRoom": true,
          "ChildrensPlayArea": false,
          "OutdoorGrill": true,
          "PicnicArea": true,
          "FirePit": true,
          "Garden": true,
          "RooftopTerrace": true,
          "LiveEntertainment": false,
          "CookingClasses": false,
          "YogaClasses": false,
          "MeditationAreas": false,
          "WaterSportsFacilities": false,
          "DivingCenter": false,
          "Snorkeling": false,
          "SurfingLessons": false
        },
        "Rules": {
            "CheckInTime": "15:00",
            "CheckOutTime": "11:00",
      "SmokingAllowed": false,
            "PetsAllowed": true,
            "BreakfastIncluded": true
        }
    },
    "RoomType": [
        {
            "Photos": [
                "url_to_room_photo1.jpg",
                "url_to_room_photo2.jpg"
            ],
            "Beds": 2,
            "Bathrooms": 1,
            "Category": "Deluxe",
            "MaxOccupants": 4,
            "Smoking": false,
            "Amenities": {
                "WiFi": true,
                "AirConditioning": true,
                "RoomService": true,
                "AccessibilityStatus": "Wheelchair accessible",

    "Availability": [
                {
                    "RoomNumber": "101",
                    "AvailablePeriods": [
                        {
                            "StartDate": "2023-12-01",
                            "EndDate": "2023-12-15"
                        }

                    ]
                }
            ]
        }
}

This document structure will allow us to query for a wide range of user searches.

Next, we’re going to need some sample data.

Prompt: (GPT 3.5)

ChatGPT didn’t want to output ten documents, so I had to follow up my first prompt with "You Do It." I repeatedly entered the prompt, varying the city, until I have 100 listings.

Final Sample Data

Database Setup

Scroll to Top