Differences between revisions 1 and 3 (spanning 2 versions)
Revision 1 as of 2007-10-23 20:27:21
Size: 2054
Editor: biodhcp-185-207
Comment: changes added
Revision 3 as of 2007-10-24 18:05:58
Size: 2430
Editor: biodhcp-185-207
Comment: search guidance
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
## This next line says who can make changes to the list of administrators!
#acl BabaseWikiAdminGroup:read,write,delete,revert,admin All:read
Line 2: Line 4:

This page can be searched using your browser's 'find' function. Since some of the descriptions of changes only include ranges of numbers, it can be useful to try searching at first using only the first few numbers of a given ID.

This page contains details of the changes made to the data contained within Babase 2.0. These changes will primarily be made by Tabby and Lacey, but if for some reason changes are made by someone else, please just be sure record changes with all possible pertinent identifying information here.

This page can be searched using your browser's 'find' function. Since some of the descriptions of changes only include ranges of numbers, it can be useful to try searching at first using only the first few numbers of a given ID.

Date

Initials

Details

07AUG2007

LKM

one psion file was double entered so the associated rows had to be deleted using 'delete from where between ;' These deletions removed the following id's from babase. SID's 38529 to 38546, IID's 602800 to 602810, pntid's 416895 to 417063, the tables affected are parts, interact_data, neighbors, point_data, fpoints, samples. These id numbers will not be 'query-able' as the have been removed from the database. I just thought it important to note where these numbers disappeared to.

08OCT2007

LKM

"ISO's name was initially OXF, so OXF showed up in Psion data but wasn't in biograph. The neighbors entries were originally changed to 998's but I changed them to ISO after figuring this out (For reference, the associated pntid in neighbors was 428168)

02OCT2007

LKM

In the census table I previously changed BOR group to 10.00 with code of 'A', this was the wrong way to handle this, to correct it, I went back in and changed the group back to 1.00 and 'A'. This cenid was 1910452. I subsequently added a row using demog_census for BOR as being in group 10.00 (alone) on 28/10/86 this data is also saved as BOR demog notes.txt in Historical Census Folder at Duke. This created a new row with cenid=1927725.

02OCT2007

LKM

In the census table I previously changed BOR group to 10.00 with code of 'A', this was the wrong way to handle this, to correct it, I went back in and changed the group back to 1.00 and 'A' This cenid was 1899540. I subsequently added a row using demog_census for BOR as being in group 10.00 (alone) on 31/10/85 this data is also saved as BOR demog notes.txt in Historical Census Folder at Duke. This created a new row with cenid 1927724.

BabaseChangelog (last edited 2024-05-23 23:57:08 by NikiLearn)

Wiki content based upon work supported by the National Science Foundation under Grant Nos. 0323553 and 0323596. Any opinions, findings, conclusions or recommendations expressed in this material are those of the wiki contributor(s) and do not necessarily reflect the views of the National Science Foundation.