Add Facility ID to Baseline List and Facility List

[rowo]

5 character ID by end of day 4/29 Monday

[rowo]

I know a 5-character ID would be useful if we wanted to continue using it as a unique ID, but something sequential (A001, A002, ...) would be more user-friendly. But either way works sufficiently.

[prabhasp]

@rowo This didn't happen today, looks like. When it does, is this what is supposed to go in the "id" column? @zmyao88 Can you provide an update when you can?

[zmyao88]

Hey guys, sorry I didn't leave any update. I've finished the scripts for generating sequential id(e.g. A001) and random id (e.g. anjur) witch are uniqu with in each lga. Salah has already conbined my scripts in to the facility analysis and will rerun the scripts later tonight when new data are coming in. Zaiming On Apr 29, 2013 8:10 PM, "prabhasp" notifications@github.com wrote:

@rowo https://github.com/rowo This didn't happen today, looks like. When it does, is this what is supposed to go in the "id" column? @zmyao88 https://github.com/zmyao88 Can you provide an update when you can?

— Reply to this email directly or view it on GitHubhttps://github.com/modilabs/mopup-seed/issues/29#issuecomment-17202669 .

[myf]

Cool, will pull when the data comes in then I will close the issue. Noted: let's perhaps not change the data structure during these two weeks when the TAs are using it On Apr 29, 2013 8:20 PM, "Zaiming Yao" notifications@github.com wrote:

Hey guys, sorry I didn't leave any update. I've finished the scripts for generating sequential id(e.g. A001) and random id (e.g. anjur) witch are uniqu with in each lga. Salah has already conbined my scripts in to the facility analysis and will rerun the scripts later tonight when new data are coming in. Zaiming On Apr 29, 2013 8:10 PM, "prabhasp" notifications@github.com wrote:

@rowo https://github.com/rowo This didn't happen today, looks like. When it does, is this what is supposed to go in the "id" column? @zmyao88 https://github.com/zmyao88 Can you provide an update when you can?

— Reply to this email directly or view it on GitHub< https://github.com/modilabs/mopup-seed/issues/29#issuecomment-17202669> .

— Reply to this email directly or view it on GitHubhttps://github.com/modilabs/mopup-seed/issues/29#issuecomment-17202987 .

[zmyao88]

Hi Myf,

Would you please double check we didn't messed up the data structure.

Zaiming On Apr 29, 2013 8:31 PM, "Myf Ma" notifications@github.com wrote:

Cool, will pull when the data comes in then I will close the issue. Noted: let's perhaps not change the data structure during these two weeks when the TAs are using it On Apr 29, 2013 8:20 PM, "Zaiming Yao" notifications@github.com wrote:

Hey guys, sorry I didn't leave any update. I've finished the scripts for generating sequential id(e.g. A001) and random id (e.g. anjur) witch are uniqu with in each lga. Salah has already conbined my scripts in to the facility analysis and will rerun the scripts later tonight when new data are coming in. Zaiming On Apr 29, 2013 8:10 PM, "prabhasp" notifications@github.com wrote:

@rowo https://github.com/rowo This didn't happen today, looks like. When it does, is this what is supposed to go in the "id" column? @zmyao88 https://github.com/zmyao88 Can you provide an update when you can?

— Reply to this email directly or view it on GitHub< https://github.com/modilabs/mopup-seed/issues/29#issuecomment-17202669> .

— Reply to this email directly or view it on GitHub< https://github.com/modilabs/mopup-seed/issues/29#issuecomment-17202987> .

— Reply to this email directly or view it on GitHubhttps://github.com/modilabs/mopup-seed/issues/29#issuecomment-17203336 .

[MartijnR]

This would also solve the issue that ID's are regenerated when the table is sorted differently (therefore didn't make this a separate issue).

[zmyao88]

I fixed Salah's scripts and save the facility list with unique IDs.

The IDs are unique within every LGA, but global uniqueness is not guaranteed.

Check out the 'random_id' and 'seq_id', we can use whichever one more appropriate for this exercise.

Btw, the data are saved at ~/Dropbox/Nigeria/Nigeria 661 Baseline Data Cleaning\in_process_data/facility_lists