HasGeoLookup

gem 'has_geo_lookup'

class Listing < ApplicationRecord
  include HasGeoLookup
  
  # Your model must have these attributes:
  # - latitude (decimal)
  # - longitude (decimal)
end

# Gemfile
gem 'mysql2'

# Gemfile
gem 'activerecord-postgis-adapter'

listing = Listing.find(123)

# Find nearest populated places within 50km
places = listing.nearest_geonames(
  feature_code: "PPL",    # Populated place
  radius_km: 50,
  limit: 10
)

# Find containing administrative boundaries
boundaries = listing.containing_geoboundaries(level: "ADM2") # Counties

# Get geographic summary
summary = listing.compare_geo_sources
puts summary

# These coordinates could be in radians or degrees
lat, lng = 0.768131687, 0.077125907  # Uzès, France in radians

# Automatically detects format and converts to degrees
validated_lat, validated_lng = listing.validate_and_convert_coordinates(lat, lng, "FR")
# => [44.011, 4.419] (converted to degrees)

# Already in degrees - no conversion needed
validated_lat, validated_lng = listing.validate_and_convert_coordinates(44.011, 4.419, "FR")
# => [44.011, 4.419] (unchanged)

# Create a metro area
bay_area = Metro.create!(
  name: "San Francisco Bay Area",
  country_code: "US",
  population: 7_750_000
)

# Associate with counties (geoboundaries)
sf_county = Geoboundary.find_by(name: "San Francisco County")
alameda_county = Geoboundary.find_by(name: "Alameda County")
bay_area.geoboundaries << [sf_county, alameda_county]

# Check if coordinates are in metro area
bay_area.contains_point?(37.7749, -122.4194) # => true

# Get metro area statistics
bay_area.total_area_km2      # => 18040.5
bay_area.population_density   # => 429.8
bay_area.boundary_names      # => ["San Francisco County", "Alameda County", ...]

# Analyze data completeness
coverage = HasGeoLookup::DataCoverage.coverage_status("US")
puts coverage[:geonames_count]      # Number of geonames records
puts coverage[:boundaries_count]    # Number of boundary records
puts coverage[:feature_coverage]    # Coverage by feature type

# Check if specific data exists
HasGeoLookup::DataCoverage.has_boundary_data?("US", "ADM2")  # => true
HasGeoLookup::DataCoverage.has_geonames_data?("US")          # => true

class Listing < ApplicationRecord
  include HasGeoLookup
  
  # Define additional data sources for comparison
  def additional_source_columns
    ['api_latitude', 'api_longitude', 'geocoded_lat', 'geocoded_lng']
  end
  
  def additional_source_legend
    {
      'API' => 'Third-party API data',
      'Geocoded' => 'Address-based geocoding'
    }
  end
  
  def get_source_value(column_name)
    case column_name
    when 'api_latitude', 'api_longitude'
      # Custom logic to fetch from your API
    when 'geocoded_lat', 'geocoded_lng'  
      # Custom logic for geocoded coordinates
    end
  end
end

# Find records within radius using database query
nearby_listings = Listing.joins(:nearest_geonames)
                         .where("geonames.feature_code = 'PPL'")
                         .where(geonames: { country_code: "US" })

# Calculate distance between two points
distance_km = listing.distance_to_point(40.7128, -74.0060)

# config/application.rb
config.generators do |g|
  g.has_geo_lookup_skip_migrations = false  # Set to true to skip auto-generation
end

# In a migration or database setup
enable_extension 'postgis'

# Get performance analysis for all models
results = HasGeoLookup::IndexChecker.analyze_all_models

# Check a specific model
analysis = HasGeoLookup::IndexChecker.check_model(Listing)
puts "Missing indexes: #{analysis[:missing_indexes]}"
puts "Recommendations: #{analysis[:recommendations]}"

# Generate migration file for missing columns and indexes
migration_path = HasGeoLookup::IndexChecker.generate_index_migration
# Or for a specific model:
migration_path = HasGeoLookup::IndexChecker.generate_index_migration(Listing)

# Generate a comprehensive performance report
puts HasGeoLookup::IndexChecker.performance_report

# Coordinate indexes (essential for spatial queries)
add_index :your_table, [:latitude, :longitude]
add_index :your_table, :latitude
add_index :your_table, :longitude

# Geographic attribute indexes (for filtering and joining)
add_index :your_table, :country
add_index :your_table, :state_or_province  
add_index :your_table, :city
add_index :your_table, :postal_code

# For geoboundaries and geonames tables
add_index :geonames, [:country_code, :feature_code]
add_index :geoboundaries, [:level, :shape_iso]

# For PostGIS, spatial indexes are created automatically

# Use specific feature codes to limit results
places = listing.nearest_geonames(
  feature_code: ["PPL", "PPLA", "PPLA2"],  # Cities and towns only
  limit: 5
)

# Specify administrative levels for boundaries
boundaries = listing.containing_geoboundaries(level: ["ADM1", "ADM2"])