Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

patent classes **bug** #8

Open
laironald opened this issue Jan 18, 2013 · 3 comments
Open

patent classes **bug** #8

laironald opened this issue Jan 18, 2013 · 3 comments
Labels

Comments

@laironald
Copy link

it looks as if there are lots of duplicated values/entries in the class file. for example, look at 07012073 in the class.sqlite3. running the following code shows issues:

select count(*) from (select * from class where prim=1 group by patent having count(*)>1);
  • Translates to: how many of the patents have more than 1 primary class listed?
  • the answer results to: 139,594 which seems a bit weird!
@doolin
Copy link
Member

doolin commented Jan 18, 2013

I ran a query on 07012073 in class.sqlite3:

sqlite> select * from class where patent = "07012073";
Patent|Prim|Class|SubClass
07012073|1|514|217.07
07012073|1|514|21707
07012073|0|540|597
sqlite>

Interesting.

This is a good statistic to track in any case.

@laironald
Copy link
Author

there are many more examples. i believe this is some duplication error. 21707 looks suspiciously like 217.07...

@doolin
Copy link
Member

doolin commented Jan 18, 2013

I'm real curious where that is in the parser...

On Fri, Jan 18, 2013 at 12:15 PM, Ron Lai [email protected] wrote:

there are many more examples. i believe this is some duplication error.
21707 looks suspiciously like 217.07...


Reply to this email directly or view it on GitHubhttps://github.com//issues/8#issuecomment-12439075.

primus inter parse

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants