{"action":"created","issue":{"url":"https://api.github.com/repos/cooperhewitt/the-pen-data/issues/3","repository_url":"https://api.github.com/repos/cooperhewitt/the-pen-data","labels_url":"https://api.github.com/repos/cooperhewitt/the-pen-data/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/cooperhewitt/the-pen-data/issues/3/comments","events_url":"https://api.github.com/repos/cooperhewitt/the-pen-data/issues/3/events","html_url":"https://github.com/cooperhewitt/the-pen-data/issues/3","id":140396912,"number":3,"title":"mismatch with object IDs","user":{"login":"mdlincoln","id":4392604,"avatar_url":"https://avatars.githubusercontent.com/u/4392604?v=3","gravatar_id":"","url":"https://api.github.com/users/mdlincoln","html_url":"https://github.com/mdlincoln","followers_url":"https://api.github.com/users/mdlincoln/followers","following_url":"https://api.github.com/users/mdlincoln/following{/other_user}","gists_url":"https://api.github.com/users/mdlincoln/gists{/gist_id}","starred_url":"https://api.github.com/users/mdlincoln/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdlincoln/subscriptions","organizations_url":"https://api.github.com/users/mdlincoln/orgs","repos_url":"https://api.github.com/users/mdlincoln/repos","events_url":"https://api.github.com/users/mdlincoln/events{/privacy}","received_events_url":"https://api.github.com/users/mdlincoln/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-03-12T16:27:25Z","updated_at":"2016-03-16T15:14:20Z","closed_at":null,"body":"IIUC, `refers_to_object_id` should match up with the object IDs made available in https://github.com/cooperhewitt/collection\r\n\r\nHowever, when trying to join the `objects.csv` created by `bin/generate-csv-objects.py`, I find that the vast majority of `refers_to_object_id` values are not found in the `id` column of the collections data:\r\n\r\n```r\r\npen <- read.csv(\"data/pen-collected-items.csv\")\r\n\r\n# objects.csv is the file generated from bin/generate-csv-objects.py\r\nch <- read.csv(\"objects.csv\")\r\n\r\n# Unique IDs in the pen data\r\npen_ids <- unique(pen$refers_to_object_id)\r\nlength(pen_ids)\r\n#> [1] 119971\r\n\r\n# Unique IDs in all object data\r\nch_ids <- ch$id\r\nlength(ch_ids)\r\n#> [1] 194316\r\n\r\n# count of pen IDs found in object data\r\nsum(pen_ids %in% ch_ids)\r\n#> [1] 7138\r\n\r\n# count of pen IDs _not_ found in object data\r\nsum(!(pen_ids %in% ch_ids))\r\n#> [1] 112833\r\n```\r\n\r\nAm I trying to associate with the wrong column?"},"comment":{"url":"https://api.github.com/repos/cooperhewitt/the-pen-data/issues/comments/197376638","html_url":"https://github.com/cooperhewitt/the-pen-data/issues/3#issuecomment-197376638","issue_url":"https://api.github.com/repos/cooperhewitt/the-pen-data/issues/3","id":197376638,"user":{"login":"mdlincoln","id":4392604,"avatar_url":"https://avatars.githubusercontent.com/u/4392604?v=3","gravatar_id":"","url":"https://api.github.com/users/mdlincoln","html_url":"https://github.com/mdlincoln","followers_url":"https://api.github.com/users/mdlincoln/followers","following_url":"https://api.github.com/users/mdlincoln/following{/other_user}","gists_url":"https://api.github.com/users/mdlincoln/gists{/gist_id}","starred_url":"https://api.github.com/users/mdlincoln/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdlincoln/subscriptions","organizations_url":"https://api.github.com/users/mdlincoln/orgs","repos_url":"https://api.github.com/users/mdlincoln/repos","events_url":"https://api.github.com/users/mdlincoln/events{/privacy}","received_events_url":"https://api.github.com/users/mdlincoln/received_events","type":"User","site_admin":false},"created_at":"2016-03-16T15:14:20Z","updated_at":"2016-03-16T15:14:20Z","body":"Ahh that makes sense, as does the proposed change - though I guess there\nare still those 325 (well, 324 if you don't count `NA`/blank value) as\n`refers_to_object_id` in the `tool_id == 0` entries, so I'm still not sure\nwhat is happening there.\n\n\n\nOn Wed, Mar 16, 2016 at 10:26 AM, Micah Walter <notifications@github.com>\nwrote:\n\n> Matthew,\n> tool_id == 0 are things collected by the pen from our wall labels and\n> interactive tables. These should all have a refers_to_object_id. All\n> other tool_ids are applications that allows our visitors to \"create\" things\n> and so they don't refer to a specific object. It looks like instead of a\n> refers_to_object_id, we are sticking in a timestamp, which is confusing and\n> I will look into changing that so it is just NULL instead.\n>\n> —\n> You are receiving this because you authored the thread.\n> Reply to this email directly or view it on GitHub\n> <https://github.com/cooperhewitt/the-pen-data/issues/3#issuecomment-197353983>\n>\n\n\n\n-- \nMatthew D. Lincoln\nPh.D Candidate\nDepartment of Art History & Archaeology <http://arthistory.umd.edu>\nUniversity of Maryland\nCollege Park, MD 20742\n\nmlincol1@umd.edu\nmatthewlincoln.net\n"}}