<commit_before>namespace :import do
  # timestamp file of last import to enable dependency-driven rakes
  ts_f = "tmp/shelter-import"

  desc "import hurricane shelter data from miami-dade"
  task :shelter => ts_f

  file ts_f => %w{vendor/HurricaneShelter.shp vendor/HurricaneShelter.shx} do
    sh 'ogr2ogr -f "PostgreSQL" PG:"dbname=shelter-development" vendor/HurricaneShelter.shp -overwrite'
    sh "touch #{ts_f}"

  end
end<commit_msg>just #yoloverwrite the florida-coordinates with a sensible srid<commit_after>namespace :import do
  # timestamp file of last import to enable dependency-driven rakes
  ts_f = "tmp/shelter-import"

  desc "import hurricane shelter data from miami-dade"
  task :shelter => ts_f

  file ts_f => %w{environment vendor/HurricaneShelter.shp vendor/HurricaneShelter.shx} do
    sh 'ogr2ogr -f "PostgreSQL" PG:"dbname=shelter-development" vendor/HurricaneShelter.shx'
    ActiveRecord::Base.connection.execute <<-SQL
      UPDATE hurricaneshelter SET wkb_geometry=ST_SetSRID(ST_Point(lon, lat), 900914);
    SQL
    sh "touch #{ts_f}"

  end
end
{'fraction_non_alphanumeric': 0.0963855421686747, 'fraction_numerical': 0.0074142724745134385, 'mean_word_length': 4.56701030927835, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4586914', 'n_tokens_mistral': 398, 'n_tokens_neox': 375, 'n_words': 97}