Following this tutorial but using my own data. How do I create the from_node and to_node columns?
I am using Spatialite and Sqlite3. I'd prefer to not use a gui as I'm working remotely via ssh on a server.
The network is currently held in a spatialite database with a geometry column e.g:
id | road_name | geometry
1 | Phil Street |
I wish to, using sql, add column to and from node e.g.:
id | road_name | from_node | to_node | geometry
1 | Phil Street | 1 | 2 |