Welcome to Your Ultimate Guide to Open Water Events Worldwide!.

.results-table { border-collapse: collapse; } .results-table th, .results-table td { border: 1px solid #ddd; padding: 8px; text-align: left; } Select a continent Africa Americas Asia Europe Oceania Select a region Select a country Search document.addEventListener("DOMContentLoaded", function() { const csvUrl = "https://wwopenwater.com/wp-content/uploads/2024/06/Open-Water-Database-Sheet1.csv"; const regions = { "Africa": { "Northern Africa": ["Algeria", "Egypt", "Libya", "Morocco", "Sudan", "Tunisia"], "Sub-Saharan Africa": ["Angola", "Benin", "Botswana", "Burkina Faso", "Burundi", "Cameroon", "Cape Verde", "Central African Rep", "Chad", "Comoros", "Congo", "Congo {Democratic Rep}", "Djibouti", "Equatorial Guinea", "Eritrea", "Eswatini (Swaziland)", "Ethiopia", "Gabon", "Gambia", "Ghana", "Guinea", "Guinea-Bissau", "Ivory Coast", "Kenya", "Lesotho", "Liberia", "Madagascar", "Malawi", "Mali", "Mauritania", "Mauritius", "Mozambique", "Namibia", "Niger", "Nigeria", "Rwanda", "Sao Tome & Principe", "Senegal", "Seychelles", "Sierra Leone", "Somalia", "South Africa", "South Sudan", "Tanzania", "Togo", "Uganda", "Zambia", "Zimbabwe"] }, "Americas": { "North America": ["Canada", "United States", "Mexico"], "South America": ["Argentina", "Bolivia", "Brazil", "Chile", "Colombia", "Ecuador", "Guyana", "Paraguay", "Peru", "Suriname", "Uruguay", "Venezuela"], "Central America": ["Belize", "Costa Rica", "El Salvador", "Guatemala", "Honduras", "Nicaragua", "Panama"], "Caribbean": ["Antigua & Deps", "Bahamas", "Barbados", "Cuba", "Dominica", "Dominican Republic", "Grenada", "Haiti", "Jamaica", "St Kitts & Nevis", "St Lucia", "Saint Vincent & the Grenadines", "Trinidad & Tobago"] }, "Asia": { "Northern Asia": ["Russian Federation"], "Central Asia": ["Kazakhstan", "Kyrgyzstan", "Tajikistan", "Turkmenistan", "Uzbekistan"], "Eastern Asia": ["China", "Japan", "Korea North", "Korea South", "Mongolia", "Taiwan"], "South-eastern Asia": ["Brunei", "Cambodia", "East Timor", "Indonesia", "Laos", "Malaysia", "Myanmar, {Burma}", "Philippines", "Singapore", "Thailand", "Vietnam"], "Southern Asia": ["Afghanistan", "Bangladesh", "Bhutan", "India", "Iran", "Maldives", "Nepal", "Pakistan", "Sri Lanka"], "Western Asia": ["Armenia", "Azerbaijan", "Bahrain", "Cyprus", "Georgia", "Iraq", "Israel", "Jordan", "Kuwait", "Lebanon", "Oman", "Qatar", "Saudi Arabia", "Syria", "Turkey", "United Arab Emirates", "Yemen"] }, "Europe": { "Eastern Europe": ["Belarus", "Bulgaria", "Czech Republic", "Hungary", "Moldova", "Poland", "Romania", "Russian Federation", "Slovakia", "Ukraine"], "Northern Europe": ["Denmark", "Estonia", "Finland", "Iceland", "Ireland {Republic}", "Latvia", "Lithuania", "Norway", "Sweden", "United Kingdom"], "Southern Europe": ["Albania", "Andorra", "Bosnia Herzegovina", "Croatia", "Greece", "Italy", "Kosovo", "Malta", "Montenegro", "North Macedonia", "Portugal", "San Marino", "Serbia", "Slovenia", "Spain"], "Western Europe": ["Austria", "Belgium", "France", "Germany", "Liechtenstein", "Luxembourg", "Monaco", "Netherlands", "Switzerland"] }, "Oceania": { "Australia": ["Australia"], "New Zealand": ["New Zealand"], "Melanesia": ["Fiji", "Papua New Guinea", "Solomon Islands", "Vanuatu"], "Micronesia": ["Kiribati", "Marshall Islands", "Micronesia", "Nauru", "Palau"], "Polynesia": ["Samoa", "Tonga", "Tuvalu"] } }; function populateRegions(continent) { const regionDropdown = document.getElementById("regionDropdown"); const countryDropdown = document.getElementById("countryDropdown"); regionDropdown.innerHTML = 'Select a region'; countryDropdown.innerHTML = 'Select a country'; countryDropdown.disabled = true; if (continent) { regionDropdown.disabled = false; const continentRegions = regions[continent]; for (const region in continentRegions) { const option = document.createElement("option"); option.value = region; option.textContent = region; regionDropdown.appendChild(option); } } else { regionDropdown.disabled = true; countryDropdown.disabled = true; } document.getElementById("searchButton").disabled = true; } function populateCountries(region) { const countryDropdown = document.getElementById("countryDropdown"); countryDropdown.innerHTML = 'Select a country'; if (region) { countryDropdown.disabled = false; const selectedContinent = document.getElementById("continentDropdown").value; const regionCountries = regions[selectedContinent][region]; regionCountries.forEach(country => { const option = document.createElement("option"); option.value = country; option.textContent = country; countryDropdown.appendChild(option); }); } else { countryDropdown.disabled = true; } document.getElementById("searchButton").disabled = true; } async function fetchCSV(url) { try { const response = await fetch(url); const data = await response.text(); console.log("Fetched CSV Data:", data); // Debug log const rows = data.split("\n").map(row => row.split(",")); return rows; } catch (error) { console.error("Error fetching CSV data:", error); return []; } } function displayResults(rows, selectedCountry) { const resultsDiv = document.getElementById("results"); resultsDiv.innerHTML = ""; const filteredData = rows.filter(row => row[1] && row[1].trim() === selectedCountry); console.log("Filtered Data:", filteredData); // Debug log if (filteredData.length > 0) { const table = document.createElement("table"); table.classList.add("results-table"); const headerRow = document.createElement("tr"); const headers = ["Region", "Country", "Name of Organization", "Link"]; headers.forEach(headerText => { const header = document.createElement("th"); header.textContent = headerText; headerRow.appendChild(header); }); table.appendChild(headerRow); filteredData.forEach(row => { const rowElement = document.createElement("tr"); const regionCell = document.createElement("td"); regionCell.textContent = row[0] ? row[0].trim() : ""; const countryCell = document.createElement("td"); countryCell.textContent = row[1] ? row[1].trim() : ""; const nameCell = document.createElement("td"); nameCell.textContent = row[2] ? row[2].trim() : ""; const urlCell = document.createElement("td"); if (row[3]) { const link = document.createElement("a"); link.href = row[3].trim(); link.textContent = row[3].trim(); urlCell.appendChild(link); } rowElement.appendChild(regionCell); rowElement.appendChild(countryCell); rowElement.appendChild(nameCell); rowElement.appendChild(urlCell); table.appendChild(rowElement); }); resultsDiv.appendChild(table); } else { resultsDiv.textContent = "No data available for the selected country."; } } document.getElementById("continentDropdown").addEventListener("change", function() { populateRegions(this.value); }); document.getElementById("regionDropdown").addEventListener("change", function() { populateCountries(this.value); }); document.getElementById("countryDropdown").addEventListener("change", function() { document.getElementById("searchButton").disabled = !this.value; }); document.getElementById("searchButton").addEventListener("click", async function() { const selectedCountry = document.getElementById("countryDropdown").value; const csvData = await fetchCSV(csvUrl); displayResults(csvData, selectedCountry); }); });