diff options
Diffstat (limited to 'doc/import')
-rw-r--r-- | doc/import/README.md | 32 | ||||
-rw-r--r-- | doc/import/readme.txt | 10 |
2 files changed, 32 insertions, 10 deletions
diff --git a/doc/import/README.md b/doc/import/README.md new file mode 100644 index 0000000..b65225e --- /dev/null +++ b/doc/import/README.md @@ -0,0 +1,32 @@ +## Parsing Resources + +The script `parser.rb` creates a file named `Locations.geojson`, which contains +all the points from the ConcertES and Dewey Maps databases. It parses the .csv +files from the Concertes folder and the .json files from the Dewey folder. To +run it: `ruby parser.rb` + +The main files it uses are: + +- `Concertes/20200312_EntreprisesSignaletique.csv` which contains the name of + the points from the Concertes data +- `Concertes/20200312_EntreprisesCoordonnees.csv` which contains the coordinates + of the points from the Concertes data and +- `Dewey/dewey-maps-markers.json` which contains the data of the points from the + Dewey data + +## Importing to Database + +Once you have `Locations.geojson`, connect to the Rails console: + +```ruby +# Load the GeoJSON into an Array +locs = JSON.parse(IO.read('doc/import/Locations.geojson')) +# Get related Agent records. You must have run `rails db:seed` beforehand. +dewey = Agent.find_by(name: 'Dewey') +concertes = Agent.find_by(name: 'ConcertES') +# Create Resource records +locs['features'].each do |f| + agent = f['properties']['source'] == dewey['name'] ? dewey : concertes + Resource.create(agent_id: agent.id, feature: f) +end +``` diff --git a/doc/import/readme.txt b/doc/import/readme.txt deleted file mode 100644 index b534433..0000000 --- a/doc/import/readme.txt +++ /dev/null @@ -1,10 +0,0 @@ -The script LocationsParser.rb creates a file named "Locations.json", which contains all the points from the Concertes and Dewey database. -It parses the .csv files from the Concertes folder and the .json files from the Dewey folder. -To run it: - ruby parser.rb - -The main files it uses are: - Concertes/20200312_EntreprisesSignaletique.csv which contains the name of the points from the Concertes data - Concertes/20200312_EntreprisesCoordonnees.csv which contains the coordinates of the points from the Concertes data -and - Dewey/dewey-maps-markers.json which contains the data of the points from the Dewey data |