{"action":"created","issue":{"url":"https://api.github.com/repos/ioos/i52n-sos/issues/20","labels_url":"https://api.github.com/repos/ioos/i52n-sos/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/ioos/i52n-sos/issues/20/comments","events_url":"https://api.github.com/repos/ioos/i52n-sos/issues/20/events","html_url":"https://github.com/ioos/i52n-sos/issues/20","id":53318399,"number":20,"title":"Updating phenomenon URI's in 52N SOS database","user":{"login":"emiliom","id":742403,"avatar_url":"https://avatars.githubusercontent.com/u/742403?v=3","gravatar_id":"","url":"https://api.github.com/users/emiliom","html_url":"https://github.com/emiliom","followers_url":"https://api.github.com/users/emiliom/followers","following_url":"https://api.github.com/users/emiliom/following{/other_user}","gists_url":"https://api.github.com/users/emiliom/gists{/gist_id}","starred_url":"https://api.github.com/users/emiliom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/emiliom/subscriptions","organizations_url":"https://api.github.com/users/emiliom/orgs","repos_url":"https://api.github.com/users/emiliom/repos","events_url":"https://api.github.com/users/emiliom/events{/privacy}","received_events_url":"https://api.github.com/users/emiliom/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-01-03T23:10:14Z","updated_at":"2015-01-08T20:43:11Z","closed_at":"2015-01-07T08:30:00Z","body":"_(I posted this to the i52n list a few days ago, but I don't see it in the archives at http://librelist.com/browser/i52n/, so I assume it got lost in the librelist flakyness)_\r\nHi @shane-axiom  (et al),\r\n\r\nI have some phenomenon URI's I need to update in a 52N SOS database. The ones entered originally (via sos-injector-db) were interim or incorrect (my fault, not sos-injector-db's).\r\n\r\nWhat tables+fields have this information, so I can update them manually via SQL UPDATE queries? Is there a documentation page where I can find this myself, so you don't have to list them explicitly for me? Or is there a name or naming pattern used by these fields? eg, all such field names include the string \"phenomenon\".\r\n\r\nThanks, and Happy New Year."},"comment":{"url":"https://api.github.com/repos/ioos/i52n-sos/issues/comments/69245761","html_url":"https://github.com/ioos/i52n-sos/issues/20#issuecomment-69245761","issue_url":"https://api.github.com/repos/ioos/i52n-sos/issues/20","id":69245761,"user":{"login":"emiliom","id":742403,"avatar_url":"https://avatars.githubusercontent.com/u/742403?v=3","gravatar_id":"","url":"https://api.github.com/users/emiliom","html_url":"https://github.com/emiliom","followers_url":"https://api.github.com/users/emiliom/followers","following_url":"https://api.github.com/users/emiliom/following{/other_user}","gists_url":"https://api.github.com/users/emiliom/gists{/gist_id}","starred_url":"https://api.github.com/users/emiliom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/emiliom/subscriptions","organizations_url":"https://api.github.com/users/emiliom/orgs","repos_url":"https://api.github.com/users/emiliom/repos","events_url":"https://api.github.com/users/emiliom/events{/privacy}","received_events_url":"https://api.github.com/users/emiliom/received_events","type":"User","site_admin":false},"created_at":"2015-01-08T20:43:11Z","updated_at":"2015-01-08T20:43:11Z","body":"@shane-axiom, thanks for pointing out that other field to update. Yikes! I definitely wouldn't have caught it. Your SQL statement seems about right. I'll report back once I've made all updates, to both tables."}}