{"action":"created","issue":{"url":"https://api.github.com/repos/ucd-cws/calvin-network-data/issues/63","repository_url":"https://api.github.com/repos/ucd-cws/calvin-network-data","labels_url":"https://api.github.com/repos/ucd-cws/calvin-network-data/issues/63/labels{/name}","comments_url":"https://api.github.com/repos/ucd-cws/calvin-network-data/issues/63/comments","events_url":"https://api.github.com/repos/ucd-cws/calvin-network-data/issues/63/events","html_url":"https://github.com/ucd-cws/calvin-network-data/issues/63","id":166435377,"number":63,"title":"Missing Link Cost (Penalties) on PMP links","user":{"login":"msdogan","id":14085662,"avatar_url":"https://avatars.githubusercontent.com/u/14085662?v=3","gravatar_id":"","url":"https://api.github.com/users/msdogan","html_url":"https://github.com/msdogan","followers_url":"https://api.github.com/users/msdogan/followers","following_url":"https://api.github.com/users/msdogan/following{/other_user}","gists_url":"https://api.github.com/users/msdogan/gists{/gist_id}","starred_url":"https://api.github.com/users/msdogan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/msdogan/subscriptions","organizations_url":"https://api.github.com/users/msdogan/orgs","repos_url":"https://api.github.com/users/msdogan/repos","events_url":"https://api.github.com/users/msdogan/events{/privacy}","received_events_url":"https://api.github.com/users/msdogan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-07-19T21:05:06Z","updated_at":"2016-07-19T21:51:16Z","closed_at":null,"body":"@qjhart @jrmerz I opened the same issue under HOBBEStoPRM repo (https://github.com/msdogan/HOBBEStoPRMcomparison/issues/4), but I guess this is a better place. We discovered that cost values are missing for following pumping plant links:\r\n\r\n    PMP-DOS AMIGOS_D744A\r\n    PMP-ONEIL_D814\r\n    PMP-WHEELERRIDGE_D862A\r\n    PMP-OSO_D884\r\n    PMP-SOUTHBAY_D891\r\n    PMP-DEL VALLE_SR-DLV\r\n    PMP-GIANELLI_SR-SNL\r\n    PMP-CONTRA COSTA 1_C70\r\n    PMP-BANKS_D800\r\n    PMP-TRACY_D701\r\n    PMP-BADGER HILL_D847\r\n    PMP-LASPERILLAS_PMP-BADGERHILL\r\n    PMP-BUENAVISTA_D860\r\n    PMP-EDMONSTON_C103\r\n    PMP-PEARBLOSSOM_C124\r\n    PMP-CHRISMAN_D862B\r\n\r\nThey all have piecewise cost curve penalties (PQ). The missing cost curves could be because of Microsoft Access Database. So, I made some changes to that for those links.\r\n- Updated month information\r\n- Updated link label\r\n\r\nHopefully with those changes, your script can read from updated `S09I05.mdb`, which is attached here and write cost values to `.pri` for those links.\r\n\r\n[S09I05.zip](https://github.com/ucd-cws/calvin-network-data/files/372458/S09I05.zip)\r\n"},"comment":{"url":"https://api.github.com/repos/ucd-cws/calvin-network-data/issues/comments/233777672","html_url":"https://github.com/ucd-cws/calvin-network-data/issues/63#issuecomment-233777672","issue_url":"https://api.github.com/repos/ucd-cws/calvin-network-data/issues/63","id":233777672,"user":{"login":"jrmerz","id":1852393,"avatar_url":"https://avatars.githubusercontent.com/u/1852393?v=3","gravatar_id":"","url":"https://api.github.com/users/jrmerz","html_url":"https://github.com/jrmerz","followers_url":"https://api.github.com/users/jrmerz/followers","following_url":"https://api.github.com/users/jrmerz/following{/other_user}","gists_url":"https://api.github.com/users/jrmerz/gists{/gist_id}","starred_url":"https://api.github.com/users/jrmerz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jrmerz/subscriptions","organizations_url":"https://api.github.com/users/jrmerz/orgs","repos_url":"https://api.github.com/users/jrmerz/repos","events_url":"https://api.github.com/users/jrmerz/events{/privacy}","received_events_url":"https://api.github.com/users/jrmerz/received_events","type":"User","site_admin":false},"created_at":"2016-07-19T21:51:16Z","updated_at":"2016-07-19T21:51:16Z","body":"We should probably be making all changes to data repository (https://github.com/ucd-cws/calvin-network-data).  That's our 'database'.  Unfortunately we would have to wait to script those changes as I do not have a Access DB license.\r\n\r\nIf you are able to pull out the data, in say, csv format, you or I could manually update.\r\n\r\nJust a reminder, the app (https://cwn.casil.ucdavis.edu/#info/PMP_ONeill-D814) has 'Download data file excel' button.  This will download a specially formatted Excel file that can be used to make modifications to the data repo via to cnf tool's excel command.\r\n\r\n```bash\r\ncnf excel -x /path/to/PMP_ONeill-D814.xls\r\n```\r\n\r\nNow this command is a little difficult to use to add data, cause you need to understand the header line as well as manually modify the GeoJSON for the node/link.   Its primary purpose is easier data edits.\r\n\r\n"}}
{"actor":{"display_login":"jrmerz"}}