{"action":"created","issue":{"url":"https://api.github.com/repos/graphhopper/graphhopper/issues/1483","repository_url":"https://api.github.com/repos/graphhopper/graphhopper","labels_url":"https://api.github.com/repos/graphhopper/graphhopper/issues/1483/labels{/name}","comments_url":"https://api.github.com/repos/graphhopper/graphhopper/issues/1483/comments","events_url":"https://api.github.com/repos/graphhopper/graphhopper/issues/1483/events","html_url":"https://github.com/graphhopper/graphhopper/pull/1483","id":370021194,"node_id":"MDExOlB1bGxSZXF1ZXN0MjIyNzk4MDEx","number":1483,"title":"Postgis 0.11","user":{"login":"mbasa","id":462884,"node_id":"MDQ6VXNlcjQ2Mjg4NA==","avatar_url":"https://avatars0.githubusercontent.com/u/462884?v=4","gravatar_id":"","url":"https://api.github.com/users/mbasa","html_url":"https://github.com/mbasa","followers_url":"https://api.github.com/users/mbasa/followers","following_url":"https://api.github.com/users/mbasa/following{/other_user}","gists_url":"https://api.github.com/users/mbasa/gists{/gist_id}","starred_url":"https://api.github.com/users/mbasa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbasa/subscriptions","organizations_url":"https://api.github.com/users/mbasa/orgs","repos_url":"https://api.github.com/users/mbasa/repos","events_url":"https://api.github.com/users/mbasa/events{/privacy}","received_events_url":"https://api.github.com/users/mbasa/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2018-10-15T06:47:49Z","updated_at":"2018-11-09T02:31:19Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/graphhopper/graphhopper/pulls/1483","html_url":"https://github.com/graphhopper/graphhopper/pull/1483","diff_url":"https://github.com/graphhopper/graphhopper/pull/1483.diff","patch_url":"https://github.com/graphhopper/graphhopper/pull/1483.patch"},"body":"Creates a PostGIS data reader to convert road networks located in PostGIS directly into GraphHopper's native network format. Please see the README.postgis for more information."},"comment":{"url":"https://api.github.com/repos/graphhopper/graphhopper/issues/comments/437228797","html_url":"https://github.com/graphhopper/graphhopper/pull/1483#issuecomment-437228797","issue_url":"https://api.github.com/repos/graphhopper/graphhopper/issues/1483","id":437228797,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNzIyODc5Nw==","user":{"login":"mbasa","id":462884,"node_id":"MDQ6VXNlcjQ2Mjg4NA==","avatar_url":"https://avatars0.githubusercontent.com/u/462884?v=4","gravatar_id":"","url":"https://api.github.com/users/mbasa","html_url":"https://github.com/mbasa","followers_url":"https://api.github.com/users/mbasa/followers","following_url":"https://api.github.com/users/mbasa/following{/other_user}","gists_url":"https://api.github.com/users/mbasa/gists{/gist_id}","starred_url":"https://api.github.com/users/mbasa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbasa/subscriptions","organizations_url":"https://api.github.com/users/mbasa/orgs","repos_url":"https://api.github.com/users/mbasa/repos","events_url":"https://api.github.com/users/mbasa/events{/privacy}","received_events_url":"https://api.github.com/users/mbasa/received_events","type":"User","site_admin":false},"created_at":"2018-11-09T02:31:19Z","updated_at":"2018-11-09T02:31:19Z","author_association":"NONE","body":"This came about when we had a project that needed the very detailed Digital Road Map (DRM) data of Japan for GraphHopper usage. The data was already in PostGIS and converting the ~20 million road data into OSM was very painful due to the way the OSM data is structured. We also had to use the DRM's attributes when determining the cost in the route creation.\r\n\r\nSo the benefit of a PostGIS reader for us is:\r\n1. ability to use non-OSM data (i.e. Navteq) easily with GraphHopper\r\n2. ability to have dynamic cost for route creation (i.e. Traffic data)\r\n\r\nI blogged about this here: \r\n\r\nhttps://georepublic.info/en/blog/2018/graphhopper-with-postgis-data-reader/\r\n\r\nAnd I agree with everybody that this can be a separate repository. This was beneficial for us and it was hoped that it can be useful for others as well. "}}
{"actor":{"display_login":"mbasa"}}