Validate your OCD division identifiers w/ Google Spreadsheet

118 views
Skip to first unread message

Aaron Strauss

unread,
May 22, 2013, 4:57:26 PM5/22/13
to open-civic-data
Open data mavens:

  I'm happy to release a validator for checking that your OCD division identifiers (i.e., the ones you add to your datasets) agree with what's in github. It's darn easy to use -- make a copy of the spreadsheet, add the identifiers from your dataset, and run the script (you may have to permission the script). Note there's a help tab in the spreadsheet if you have trouble. You'll also want to read that fine print if you have thousands of identifiers to check.

  Feedback is appreciated of course. I want to make this tool as easy as possible, as I believe it will aid in adoption of the identifiers. So, please let me know about your experience.

Enjoy!
Aaron

dmcg...@azavea.com

unread,
Aug 25, 2014, 5:13:03 PM8/25/14
to open-ci...@googlegroups.com
Does anyone know who is currently maintaining this project? It seems Aaron is no longer with Google.

Thanks

Aaron B Strauss

unread,
Aug 25, 2014, 6:39:59 PM8/25/14
to open-ci...@googlegroups.com
I'm still on this list though! Is it broken? Email me what's up and I'll try to find time to fix it.

Nolan Love

unread,
Sep 4, 2016, 10:53:36 PM9/4/16
to Open Civic Data
Hey Aaron,

Not sure if you're still checking this, but I'm using your OCD-ID validator (awesome) and I'm having a hard time figuring out what to do with American Samoa legislative houses, upper and lower. Any ideas? I didn't see the IDs in github, or in the exceptions list.

Thanks!
~Nolan Love at PollVault dot com

Aaron B Strauss

unread,
Sep 7, 2016, 9:01:39 AM9/7/16
to open-ci...@googlegroups.com
Hi Nolan,
  It's been a while since I added to OCD IDs, but I bet the legislative houses for territories aren't in there. By all means create a pull request to add them; they'd be a welcome addition.

For others who are curious, the latest, working version of the validator is here.

Aaron
Reply all
Reply to author
Forward
0 new messages