search

datagovuk / api_etl

2 stars 1 forks source link

[WIP] Load some NaPTAN ferry data #16

Closed morty closed 9 years ago

morty commented 9 years ago

I've left out a number of columns in the CSV. Need to decide which ones are needed.

rossjones commented 9 years ago

Have made the switch to postgrex now, which simplifies the code quite a lot. Also added https://github.com/bryanjos/geo so we can do 

geo = %Geo.Point{coordinates: {30, -90}, srid: 4326}
"INSERT INTO point_test VALUES ($1)", [geo]
# and equivalent selects....

Right now, I think we should special case lat/lng and/or easting/northing so we know what they are. Probably in the manifest for now. Another alternative is a postgres function to do the conversion ....

need to clear the deps with

mix deps.clean --all mix do deps,get, deps.compile

rossjones commented 9 years ago

Merged this for now so I can deploy more easily :)

rossjones commented 9 years ago

This is deployed to live now. I don't seem to be able to trigger the extent, so you have values that'll work?