MapFilters seeds data for PostgreSQL

seeds.rb

require Rails.root.join('lib/shapefile_importer')

# PostgreSQL data preparation
Shapefile.delete_all
ActiveRecord::Base.connection.execute("TRUNCATE #{Shapefile.table_name} RESTART IDENTITY")

ShapefilesImporter.new(shapefile_path: Rails.root.join('db/shapefiles/postal_district.shp')).call

Location.delete_all
ActiveRecord::Base.connection.execute("TRUNCATE #{Location.table_name} RESTART IDENTITY")

# create some locations inside and around Bromley, London
(51.272..51.449).step(0.002).each do |lat|
  (0.008..0.180).step(0.002).each do |lng|
    Location.create!(coordinates: "POINT(#{lng.round(3)} #{lat.round(3)})")
  end
end