Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Clean the ori_por_non_iata.csv data file #4

Open
da115115 opened this issue Jan 26, 2013 · 3 comments
Open

Clean the ori_por_non_iata.csv data file #4

da115115 opened this issue Jan 26, 2013 · 3 comments
Assignees
Milestone

Comments

@da115115
Copy link
Member

As mentioned in the comments for ee60b66, the ori_por_non_iata needs to be reformatted with the very same format of ori_por_public

@ghost ghost assigned da115115 Jan 26, 2013
@da115115
Copy link
Member Author

Only the "unkown" POR entries are remaining. Indeed, only the IATA code and the geographical coordinates are known. To display them, just execute the following command:

$ grep "^TODO" ori_por_non_iata.csv

A script may then be written, using GeoBase, in order to get the details of the nearest POR of the same location type (if possible). It could be written in Python.

@da115115
Copy link
Member Author

In order to have that whole process more robust, I intend to write a validation script for the expected format. That way, when the format evolves, the validation script will tell what is wrong.

@alexprengere
Copy link
Member

If we take the example of the line for TODO:HEW, after geocode extraction, you can retrieve the closest element with the same location type using:

$ GeoBase -E location_type -e CA -c 37.95, 23.81 -C 1 -q

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants