Use Cases

{
  "countries": [
    {
      "name": "United States",
      "iso2": "US",
      "currency": "USD", 
      "currency_symbol": "$",
      "emoji": "🇺🇸"
    },
    {
      "name": "United Kingdom",
      "iso2": "GB", 
      "currency": "GBP",
      "currency_symbol": "£", 
      "emoji": "🇬🇧"
    }
  ]
}

// Load countries data
const countries = exportData.countries;

// Populate dropdown
countries.forEach(country => {
  const option = document.createElement('option');
  option.value = country.iso2;
  option.textContent = `${country.emoji} ${country.name}`;
  countrySelect.appendChild(option);
});

// Update currency display when country changes
countrySelect.addEventListener('change', (e) => {
  const selectedCountry = countries.find(c => c.iso2 === e.target.value);
  updatePriceDisplay(selectedCountry.currency_symbol);
});

struct City: Codable {
    let name: String
    let countryCode: String
    let stateCode: String
    let latitude: Double
    let longitude: Double
}

// Filter cities by country or region if needed
let filteredCities = cities.filter { $0.countryCode == "US" }

// Integrate with weather service
func getWeatherForCity(_ city: City) {
    let weatherAPI = "https://api.weather.com/v1/current"
    let url = "\(weatherAPI)?lat=\(city.latitude)&lng=\(city.longitude)"
    
    // Use coordinates for weather API integration
    // ... weather integration
}

// Excel Power Query M formula
let
    Source = Csv.Document(File.Contents("C:\exports\countries_analytics.csv")),
    Headers = Table.PromoteHeaders(Source),
    
    // Add calculated columns
    WithPhonePrefix = Table.AddColumn(Headers, "PhonePrefix", 
        each "+" & [phonecode]),
    
    WithCurrencyInfo = Table.AddColumn(WithPhonePrefix, "CurrencyDisplay",
        each [currency_symbol] & " (" & [currency] & ")"),
        
    // Group by region for analysis
    GroupedByRegion = Table.Group(WithCurrencyInfo, {"region"}, 
        {{"Countries", each _, type table}})
in
    GroupedByRegion

// Currency Zone Display
[currency_symbol] + " " + [currency_name]

// Phone Code Formatting  
"+" + [phonecode]

// Regional Country Count
COUNT([name])

// Country data with translations
const countryData = {
  "US": {
    "name": "United States", 
    "native": "United States",
    "translations": {
      "es": "Estados Unidos",
      "fr": "États-Unis", 
      "de": "Vereinigte Staaten"
    },
    "nationality": "American",
    "emoji": "🇺🇸"
  }
};

// Localization function
function getLocalizedCountryName(countryCode, locale = 'en') {
  const country = countryData[countryCode];
  
  if (locale === 'en') return country.name;
  if (locale === country.native.toLowerCase().slice(0, 2)) return country.native;
  if (country.translations[locale]) return country.translations[locale];
  
  return country.name; // Fallback to English
}

// Usage in React component
function CountrySelector({ locale }) {
  return (
    <select>
      {Object.keys(countryData).map(code => (
        <option key={code} value={code}>
          {countryData[code].emoji} {getLocalizedCountryName(code, locale)}
        </option>
      ))}
    </select>
  );
}

// database/migrations/001_seed_geographical_data.js
const fs = require('fs');
const path = require('path');

exports.up = async function(knex) {
  // Read the CSC-generated SQL file
  const sqlFile = path.join(__dirname, '../seeds/csc_export.sql');
  const sqlContent = fs.readFileSync(sqlFile, 'utf8');
  
  // Execute the SQL statements
  const statements = sqlContent.split(';').filter(stmt => stmt.trim());
  
  for (const statement of statements) {
    if (statement.trim()) {
      await knex.raw(statement);
    }
  }
  
  console.log('Geographical data seeded successfully');
};

exports.down = async function(knex) {
  await knex('states').del();
  await knex('countries').del();
};

# Dockerfile for PostgreSQL with geographical data
FROM postgres:14

# Copy CSC export SQL file
COPY ./exports/geographical_data.sql /docker-entrypoint-initdb.d/

# Environment variables
ENV POSTGRES_DB=myapp
ENV POSTGRES_USER=app_user 
ENV POSTGRES_PASSWORD=secure_password

# The SQL file will be automatically executed on container startup

version: '3.8'
services:
  database:
    build: ./database
    ports:
      - "5432:5432"
    volumes:
      - pgdata:/var/lib/postgresql/data
      - ./exports:/tmp/exports
    environment:
      - POSTGRES_DB=myapp
      
volumes:
  pgdata: