{"action":"created","comment":{"url":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/comments/188344905","pull_request_review_id":120291937,"id":188344905,"diff_hunk":"@@ -331,17 +331,17 @@ CW_TEST,NUTNR-B,operating_mode,PD345,quantity,,string,,1,empty,Operating Mode,0,\n \"BETA,TRHPH_A\",TRHPH-A,hydrogen_x5,PD426,quantity,,float32,,V,-9999999,Hydrogen Sensor 25x Gain,3,,,,,,,,,,\n \"BETA,TRHPH_A\",TRHPH-A,eh_sensor,PD427,quantity,,float32,,V,-9999999,Vent Fluid Oxidation Reduction-Potential Measurement,3,,,,,,TRHPHVO_L0,\"Oxidation-Reduction Potential Measurement is the tendency of a vent fluid, and the chemical species within it, to acquire electrons (i.e. be reduced). The more positive the potential, the greater the affinity for electrons and tendency to be reduced. Used to calculate Vent Fluid Oxidation-Reduction Potential (ORP). Units: Volts\",Vent Fluid Oxidation Reduction-Potential Measurement,,L0\n \"BETA,TRHPH_A\",TRHPH-A,ref_temp_volts,PD428,quantity,,float32,,V,-9999999,Reference Thermistor Temperature Measurement,3,,,,,,TRHPHVS_L0,The Reference Thermistor Temperature is measured by the Temperature-Resistivity Probe Instrument and used to calculate Vent Fluid Temperature from TRHPH. Units: Volts,Thermistor Temperature Measurement,Unprocessed Data,L0\n-\"BETA,TRHPH_A\",TRHPH-A,ref_temp_degc,PD429,quantity,,float32,,deg_C,-9999999,Reference Thermistor Temperature,3,,,,,,,Calculated reference thermistor temperature measured in degrees Celcius.,,,\n+\"BETA,TRHPH_A\",TRHPH-A,ref_temp_degc,PD429,quantity,,float32,,ºC,-9999999,Reference Thermistor Temperature,3,,,,,,,Calculated reference thermistor temperature measured in degrees Celcius.,,,","path":"csv/ParameterDefs.csv","position":55,"original_position":55,"commit_id":"cc4f25f49e53909375068e3577ac374e7268a5ab","original_commit_id":"cc4f25f49e53909375068e3577ac374e7268a5ab","user":{"login":"danmergens","id":6914984,"avatar_url":"https://avatars1.githubusercontent.com/u/6914984?v=4","gravatar_id":"","url":"https://api.github.com/users/danmergens","html_url":"https://github.com/danmergens","followers_url":"https://api.github.com/users/danmergens/followers","following_url":"https://api.github.com/users/danmergens/following{/other_user}","gists_url":"https://api.github.com/users/danmergens/gists{/gist_id}","starred_url":"https://api.github.com/users/danmergens/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danmergens/subscriptions","organizations_url":"https://api.github.com/users/danmergens/orgs","repos_url":"https://api.github.com/users/danmergens/repos","events_url":"https://api.github.com/users/danmergens/events{/privacy}","received_events_url":"https://api.github.com/users/danmergens/received_events","type":"User","site_admin":false},"body":"remove description units","created_at":"2018-05-15T16:03:02Z","updated_at":"2018-05-15T16:08:22Z","html_url":"https://github.com/oceanobservatories/preload-database/pull/51#discussion_r188344905","pull_request_url":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/51","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/comments/188344905"},"html":{"href":"https://github.com/oceanobservatories/preload-database/pull/51#discussion_r188344905"},"pull_request":{"href":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/51"}}},"pull_request":{"url":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/51","id":183522306,"html_url":"https://github.com/oceanobservatories/preload-database/pull/51","diff_url":"https://github.com/oceanobservatories/preload-database/pull/51.diff","patch_url":"https://github.com/oceanobservatories/preload-database/pull/51.patch","issue_url":"https://api.github.com/repos/oceanobservatories/preload-database/issues/51","number":51,"state":"open","locked":false,"title":"Temperature unit change  to ºC","user":{"login":"leilabbb","id":11836767,"avatar_url":"https://avatars2.githubusercontent.com/u/11836767?v=4","gravatar_id":"","url":"https://api.github.com/users/leilabbb","html_url":"https://github.com/leilabbb","followers_url":"https://api.github.com/users/leilabbb/followers","following_url":"https://api.github.com/users/leilabbb/following{/other_user}","gists_url":"https://api.github.com/users/leilabbb/gists{/gist_id}","starred_url":"https://api.github.com/users/leilabbb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leilabbb/subscriptions","organizations_url":"https://api.github.com/users/leilabbb/orgs","repos_url":"https://api.github.com/users/leilabbb/repos","events_url":"https://api.github.com/users/leilabbb/events{/privacy}","received_events_url":"https://api.github.com/users/leilabbb/received_events","type":"User","site_admin":false},"body":"mapped the unit of measure lists:\n[deg_C, degC, deg_c, degrees Celsius] to ºC\n[mdeg_C, millidegrees Celsius] to  0.001 ºC\n\nThere is one more change that I did not know how to control. The double\nquotes at lines 3590, 3593 and 3596 were not preserved when the file\nwas read using pd.read_csv .","created_at":"2018-04-23T18:41:12Z","updated_at":"2018-05-15T16:08:22Z","closed_at":null,"merged_at":null,"merge_commit_sha":"b0316e2e977ac59cdb3c51bf5b36646daa4cc090","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/51/commits","review_comments_url":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/51/comments","review_comment_url":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/comments{/number}","comments_url":"https://api.github.com/repos/oceanobservatories/preload-database/issues/51/comments","statuses_url":"https://api.github.com/repos/oceanobservatories/preload-database/statuses/cc4f25f49e53909375068e3577ac374e7268a5ab","head":{"label":"leilabbb:master","ref":"master","sha":"cc4f25f49e53909375068e3577ac374e7268a5ab","user":{"login":"leilabbb","id":11836767,"avatar_url":"https://avatars2.githubusercontent.com/u/11836767?v=4","gravatar_id":"","url":"https://api.github.com/users/leilabbb","html_url":"https://github.com/leilabbb","followers_url":"https://api.github.com/users/leilabbb/followers","following_url":"https://api.github.com/users/leilabbb/following{/other_user}","gists_url":"https://api.github.com/users/leilabbb/gists{/gist_id}","starred_url":"https://api.github.com/users/leilabbb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leilabbb/subscriptions","organizations_url":"https://api.github.com/users/leilabbb/orgs","repos_url":"https://api.github.com/users/leilabbb/repos","events_url":"https://api.github.com/users/leilabbb/events{/privacy}","received_events_url":"https://api.github.com/users/leilabbb/received_events","type":"User","site_admin":false},"repo":{"id":130706362,"name":"preload-database","full_name":"leilabbb/preload-database","owner":{"login":"leilabbb","id":11836767,"avatar_url":"https://avatars2.githubusercontent.com/u/11836767?v=4","gravatar_id":"","url":"https://api.github.com/users/leilabbb","html_url":"https://github.com/leilabbb","followers_url":"https://api.github.com/users/leilabbb/followers","following_url":"https://api.github.com/users/leilabbb/following{/other_user}","gists_url":"https://api.github.com/users/leilabbb/gists{/gist_id}","starred_url":"https://api.github.com/users/leilabbb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leilabbb/subscriptions","organizations_url":"https://api.github.com/users/leilabbb/orgs","repos_url":"https://api.github.com/users/leilabbb/repos","events_url":"https://api.github.com/users/leilabbb/events{/privacy}","received_events_url":"https://api.github.com/users/leilabbb/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/leilabbb/preload-database","description":"database source scripts/files for preload","fork":true,"url":"https://api.github.com/repos/leilabbb/preload-database","forks_url":"https://api.github.com/repos/leilabbb/preload-database/forks","keys_url":"https://api.github.com/repos/leilabbb/preload-database/keys{/key_id}","collaborators_url":"https://api.github.com/repos/leilabbb/preload-database/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/leilabbb/preload-database/teams","hooks_url":"https://api.github.com/repos/leilabbb/preload-database/hooks","issue_events_url":"https://api.github.com/repos/leilabbb/preload-database/issues/events{/number}","events_url":"https://api.github.com/repos/leilabbb/preload-database/events","assignees_url":"https://api.github.com/repos/leilabbb/preload-database/assignees{/user}","branches_url":"https://api.github.com/repos/leilabbb/preload-database/branches{/branch}","tags_url":"https://api.github.com/repos/leilabbb/preload-database/tags","blobs_url":"https://api.github.com/repos/leilabbb/preload-database/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/leilabbb/preload-database/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/leilabbb/preload-database/git/refs{/sha}","trees_url":"https://api.github.com/repos/leilabbb/preload-database/git/trees{/sha}","statuses_url":"https://api.github.com/repos/leilabbb/preload-database/statuses/{sha}","languages_url":"https://api.github.com/repos/leilabbb/preload-database/languages","stargazers_url":"https://api.github.com/repos/leilabbb/preload-database/stargazers","contributors_url":"https://api.github.com/repos/leilabbb/preload-database/contributors","subscribers_url":"https://api.github.com/repos/leilabbb/preload-database/subscribers","subscription_url":"https://api.github.com/repos/leilabbb/preload-database/subscription","commits_url":"https://api.github.com/repos/leilabbb/preload-database/commits{/sha}","git_commits_url":"https://api.github.com/repos/leilabbb/preload-database/git/commits{/sha}","comments_url":"https://api.github.com/repos/leilabbb/preload-database/comments{/number}","issue_comment_url":"https://api.github.com/repos/leilabbb/preload-database/issues/comments{/number}","contents_url":"https://api.github.com/repos/leilabbb/preload-database/contents/{+path}","compare_url":"https://api.github.com/repos/leilabbb/preload-database/compare/{base}...{head}","merges_url":"https://api.github.com/repos/leilabbb/preload-database/merges","archive_url":"https://api.github.com/repos/leilabbb/preload-database/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/leilabbb/preload-database/downloads","issues_url":"https://api.github.com/repos/leilabbb/preload-database/issues{/number}","pulls_url":"https://api.github.com/repos/leilabbb/preload-database/pulls{/number}","milestones_url":"https://api.github.com/repos/leilabbb/preload-database/milestones{/number}","notifications_url":"https://api.github.com/repos/leilabbb/preload-database/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/leilabbb/preload-database/labels{/name}","releases_url":"https://api.github.com/repos/leilabbb/preload-database/releases{/id}","deployments_url":"https://api.github.com/repos/leilabbb/preload-database/deployments","created_at":"2018-04-23T14:08:59Z","updated_at":"2018-04-23T18:41:13Z","pushed_at":"2018-04-23T18:41:11Z","git_url":"git://github.com/leilabbb/preload-database.git","ssh_url":"git@github.com:leilabbb/preload-database.git","clone_url":"https://github.com/leilabbb/preload-database.git","svn_url":"https://github.com/leilabbb/preload-database","homepage":null,"size":6150,"stargazers_count":0,"watchers_count":0,"language":"PLpgSQL","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":null,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"oceanobservatories:master","ref":"master","sha":"c85c4733b8f62c2db07d19b81fa10dbfc250d802","user":{"login":"oceanobservatories","id":8750280,"avatar_url":"https://avatars0.githubusercontent.com/u/8750280?v=4","gravatar_id":"","url":"https://api.github.com/users/oceanobservatories","html_url":"https://github.com/oceanobservatories","followers_url":"https://api.github.com/users/oceanobservatories/followers","following_url":"https://api.github.com/users/oceanobservatories/following{/other_user}","gists_url":"https://api.github.com/users/oceanobservatories/gists{/gist_id}","starred_url":"https://api.github.com/users/oceanobservatories/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/oceanobservatories/subscriptions","organizations_url":"https://api.github.com/users/oceanobservatories/orgs","repos_url":"https://api.github.com/users/oceanobservatories/repos","events_url":"https://api.github.com/users/oceanobservatories/events{/privacy}","received_events_url":"https://api.github.com/users/oceanobservatories/received_events","type":"Organization","site_admin":false},"repo":{"id":35891249,"name":"preload-database","full_name":"oceanobservatories/preload-database","owner":{"login":"oceanobservatories","id":8750280,"avatar_url":"https://avatars0.githubusercontent.com/u/8750280?v=4","gravatar_id":"","url":"https://api.github.com/users/oceanobservatories","html_url":"https://github.com/oceanobservatories","followers_url":"https://api.github.com/users/oceanobservatories/followers","following_url":"https://api.github.com/users/oceanobservatories/following{/other_user}","gists_url":"https://api.github.com/users/oceanobservatories/gists{/gist_id}","starred_url":"https://api.github.com/users/oceanobservatories/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/oceanobservatories/subscriptions","organizations_url":"https://api.github.com/users/oceanobservatories/orgs","repos_url":"https://api.github.com/users/oceanobservatories/repos","events_url":"https://api.github.com/users/oceanobservatories/events{/privacy}","received_events_url":"https://api.github.com/users/oceanobservatories/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/oceanobservatories/preload-database","description":"database source scripts/files for preload","fork":false,"url":"https://api.github.com/repos/oceanobservatories/preload-database","forks_url":"https://api.github.com/repos/oceanobservatories/preload-database/forks","keys_url":"https://api.github.com/repos/oceanobservatories/preload-database/keys{/key_id}","collaborators_url":"https://api.github.com/repos/oceanobservatories/preload-database/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/oceanobservatories/preload-database/teams","hooks_url":"https://api.github.com/repos/oceanobservatories/preload-database/hooks","issue_events_url":"https://api.github.com/repos/oceanobservatories/preload-database/issues/events{/number}","events_url":"https://api.github.com/repos/oceanobservatories/preload-database/events","assignees_url":"https://api.github.com/repos/oceanobservatories/preload-database/assignees{/user}","branches_url":"https://api.github.com/repos/oceanobservatories/preload-database/branches{/branch}","tags_url":"https://api.github.com/repos/oceanobservatories/preload-database/tags","blobs_url":"https://api.github.com/repos/oceanobservatories/preload-database/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/oceanobservatories/preload-database/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/oceanobservatories/preload-database/git/refs{/sha}","trees_url":"https://api.github.com/repos/oceanobservatories/preload-database/git/trees{/sha}","statuses_url":"https://api.github.com/repos/oceanobservatories/preload-database/statuses/{sha}","languages_url":"https://api.github.com/repos/oceanobservatories/preload-database/languages","stargazers_url":"https://api.github.com/repos/oceanobservatories/preload-database/stargazers","contributors_url":"https://api.github.com/repos/oceanobservatories/preload-database/contributors","subscribers_url":"https://api.github.com/repos/oceanobservatories/preload-database/subscribers","subscription_url":"https://api.github.com/repos/oceanobservatories/preload-database/subscription","commits_url":"https://api.github.com/repos/oceanobservatories/preload-database/commits{/sha}","git_commits_url":"https://api.github.com/repos/oceanobservatories/preload-database/git/commits{/sha}","comments_url":"https://api.github.com/repos/oceanobservatories/preload-database/comments{/number}","issue_comment_url":"https://api.github.com/repos/oceanobservatories/preload-database/issues/comments{/number}","contents_url":"https://api.github.com/repos/oceanobservatories/preload-database/contents/{+path}","compare_url":"https://api.github.com/repos/oceanobservatories/preload-database/compare/{base}...{head}","merges_url":"https://api.github.com/repos/oceanobservatories/preload-database/merges","archive_url":"https://api.github.com/repos/oceanobservatories/preload-database/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/oceanobservatories/preload-database/downloads","issues_url":"https://api.github.com/repos/oceanobservatories/preload-database/issues{/number}","pulls_url":"https://api.github.com/repos/oceanobservatories/preload-database/pulls{/number}","milestones_url":"https://api.github.com/repos/oceanobservatories/preload-database/milestones{/number}","notifications_url":"https://api.github.com/repos/oceanobservatories/preload-database/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/oceanobservatories/preload-database/labels{/name}","releases_url":"https://api.github.com/repos/oceanobservatories/preload-database/releases{/id}","deployments_url":"https://api.github.com/repos/oceanobservatories/preload-database/deployments","created_at":"2015-05-19T15:33:15Z","updated_at":"2018-04-18T21:30:49Z","pushed_at":"2018-04-23T18:41:13Z","git_url":"git://github.com/oceanobservatories/preload-database.git","ssh_url":"git@github.com:oceanobservatories/preload-database.git","clone_url":"https://github.com/oceanobservatories/preload-database.git","svn_url":"https://github.com/oceanobservatories/preload-database","homepage":null,"size":6635,"stargazers_count":2,"watchers_count":2,"language":"PLpgSQL","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":13,"mirror_url":null,"archived":false,"open_issues_count":1,"license":null,"forks":13,"open_issues":1,"watchers":2,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/51"},"html":{"href":"https://github.com/oceanobservatories/preload-database/pull/51"},"issue":{"href":"https://api.github.com/repos/oceanobservatories/preload-database/issues/51"},"comments":{"href":"https://api.github.com/repos/oceanobservatories/preload-database/issues/51/comments"},"review_comments":{"href":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/51/comments"},"review_comment":{"href":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/oceanobservatories/preload-database/pulls/51/commits"},"statuses":{"href":"https://api.github.com/repos/oceanobservatories/preload-database/statuses/cc4f25f49e53909375068e3577ac374e7268a5ab"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"danmergens"}}