I'm in need of hints about the database design on a small study I'm currently conducting on.
Here are the specifications of the database which is stored in Excel file
• Number of data collection sites: 11 (from ID_1 up to ID_11)
• Number of data collection days: 4 days (April 7, April 8, April 9, April 11)
• Time of data collection in each day: 6 times (9:00 am, 12:00 pm, 3:00 pm, 6:00 pm, 9:00 pm; 12:00 am)
• Types (categories) of data collected at each time: 4 types (A, B, C, D)
What I did was, save the excel file in CSV, import it to the ArcMap 10.1; and Join it to the layer which consists the sample site locations. However, when I checked the merged Attribute table, not all the data was imported. I'm suspecting that the type of my data base is not compatible. I need your suggestions. Below, I have appended the database I created in Excel/CSV format.
ID Date Time DataType Frequency
01 7-Apr 9:00 AM A 0
01 7-Apr 9:00 AM B 8
01 7-Apr 9:00 AM C 4
01 7-Apr 9:00 AM D 2
01 7-Apr 12:00 PM A 0
01 7-Apr 12:00 PM B 8
01 7-Apr 12:00 PM C 3
01 7-Apr 12:00 PM D 0
01 7-Apr 3:00 PM A 0
01 7-Apr 3:00 PM B 3
01 7-Apr 3:00 PM C 6
01 7-Apr 3:00 PM D 1
01 7-Apr 6:00 PM A 0
01 7-Apr 6:00 PM B 8
01 7-Apr 6:00 PM C 6
01 7-Apr 6:00 PM D 1
01 7-Apr 9:00 PM A 0
01 7-Apr 9:00 PM B 6
01 7-Apr 9:00 PM C 5
01 7-Apr 9:00 PM D 2
02 7-Apr 9:00 AM A 0
02 7-Apr 9:00 AM B 5
02 7-Apr 9:00 AM C 6
02 7-Apr 9:00 AM D 0
02 7-Apr 12:00 PM A 0
02 7-Apr 12:00 PM B 8
02 7-Apr 12:00 PM C 8
02 7-Apr 12:00 PM D 0
02 7-Apr 3:00 PM A 0
02 7-Apr 3:00 PM B 8
02 7-Apr 3:00 PM C 7
02 7-Apr 3:00 PM D 4
02 7-Apr 6:00 PM A 0
02 7-Apr 6:00 PM B 7
02 7-Apr 6:00 PM C 8
02 7-Apr 6:00 PM D 1
02 7-Apr 9:00 PM A 0
02 7-Apr 9:00 PM B 8
02 7-Apr 9:00 PM C 5
02 7-Apr 9:00 PM D 0
03 7-Apr 9:00 AM A 0
03 7-Apr 9:00 AM B 4
03 7-Apr 9:00 AM C 6
03 7-Apr 9:00 AM D 1
03 7-Apr 12:00 PM A 0
03 7-Apr 12:00 PM B 8
03 7-Apr 12:00 PM C 4
03 7-Apr 12:00 PM D 0
03 7-Apr 3:00 PM A 0
03 7-Apr 3:00 PM B 3
03 7-Apr 3:00 PM C 2
03 7-Apr 3:00 PM D 0
03 7-Apr 6:00 PM A 0
03 7-Apr 6:00 PM B 5
03 7-Apr 6:00 PM C 6
03 7-Apr 6:00 PM D 0
03 7-Apr 9:00 PM A 0
03 7-Apr 9:00 PM B 7
03 7-Apr 9:00 PM C 5
03 7-Apr 9:00 PM D 0
04 7-Apr 9:00 AM A 0
04 7-Apr 9:00 AM B 7
04 7-Apr 9:00 AM C 5
04 7-Apr 9:00 AM D 0
04 7-Apr 12:00 PM A 0
04 7-Apr 12:00 PM B 7
04 7-Apr 12:00 PM C 7
04 7-Apr 12:00 PM D 0
04 7-Apr 3:00 PM A 0
04 7-Apr 3:00 PM B 8
04 7-Apr 3:00 PM C 7
04 7-Apr 3:00 PM D 1
04 7-Apr 6:00 PM A 0
04 7-Apr 6:00 PM B 6
04 7-Apr 6:00 PM C 7
04 7-Apr 6:00 PM D 2
04 7-Apr 9:00 PM A 0
04 7-Apr 9:00 PM B 7
04 7-Apr 9:00 PM C 6
04 7-Apr 9:00 PM D 1
05 7-Apr 9:00 AM A 8
05 7-Apr 9:00 AM B 8
05 7-Apr 9:00 AM C 8
05 7-Apr 9:00 AM D 4
05 7-Apr 12:00 PM A 8
05 7-Apr 12:00 PM B 7
05 7-Apr 12:00 PM C 8
05 7-Apr 12:00 PM D 5
05 7-Apr 3:00 PM A 8
05 7-Apr 3:00 PM B 7
05 7-Apr 3:00 PM C 8
05 7-Apr 3:00 PM D 5
05 7-Apr 6:00 PM A 8
05 7-Apr 6:00 PM B 7
05 7-Apr 6:00 PM C 8
05 7-Apr 6:00 PM D 2
05 7-Apr 9:00 PM A 8
05 7-Apr 9:00 PM B 8
05 7-Apr 9:00 PM C 8
05 7-Apr 9:00 PM D 8
06 7-Apr 9:00 AM A 0
06 7-Apr 9:00 AM B 10
06 7-Apr 9:00 AM C 7
06 7-Apr 9:00 AM D 3
06 7-Apr 12:00 PM A 0
06 7-Apr 12:00 PM B 8
06 7-Apr 12:00 PM C 8
06 7-Apr 12:00 PM D 0
06 7-Apr 3:00 PM A 0
06 7-Apr 3:00 PM B 8
06 7-Apr 3:00 PM C 8
06 7-Apr 3:00 PM D 0
06 7-Apr 6:00 PM A 0
06 7-Apr 6:00 PM B 8
06 7-Apr 6:00 PM C 7
06 7-Apr 6:00 PM D 3
06 7-Apr 9:00 PM A 0
06 7-Apr 9:00 PM B 8
06 7-Apr 9:00 PM C 8
06 7-Apr 9:00 PM D 5
07 7-Apr 9:00 AM A 0
07 7-Apr 9:00 AM B 7
07 7-Apr 9:00 AM C 7
07 7-Apr 9:00 AM D 2
07 7-Apr 12:00 PM A 0
07 7-Apr 12:00 PM B 8
07 7-Apr 12:00 PM C 3
07 7-Apr 12:00 PM D 7
07 7-Apr 3:00 PM A 0
07 7-Apr 3:00 PM B 6
07 7-Apr 3:00 PM C 5
07 7-Apr 3:00 PM D 4
07 7-Apr 6:00 PM A 0
07 7-Apr 6:00 PM B 8
07 7-Apr 6:00 PM C 2
07 7-Apr 6:00 PM D 4
07 7-Apr 9:00 PM A 0
07 7-Apr 9:00 PM B 7
07 7-Apr 9:00 PM C 4
07 7-Apr 9:00 PM D 2
08 7-Apr 9:00 AM A 0
08 7-Apr 9:00 AM B 4
08 7-Apr 9:00 AM C 0
08 7-Apr 9:00 AM D 0
08 7-Apr 12:00 PM A 0
08 7-Apr 12:00 PM B 2
08 7-Apr 12:00 PM C 0
08 7-Apr 12:00 PM D 0
08 7-Apr 3:00 PM A 0
08 7-Apr 3:00 PM B 8
08 7-Apr 3:00 PM C 0
08 7-Apr 3:00 PM D 0
08 7-Apr 6:00 PM A 0
08 7-Apr 6:00 PM B 7
08 7-Apr 6:00 PM C 0
08 7-Apr 6:00 PM D 0
08 7-Apr 9:00 PM A 0
08 7-Apr 9:00 PM B 4
08 7-Apr 9:00 PM C 1
08 7-Apr 9:00 PM D 0
09 7-Apr 9:00 AM A 0
09 7-Apr 9:00 AM B 3
09 7-Apr 9:00 AM C 7
09 7-Apr 9:00 AM D 0
09 7-Apr 12:00 PM A 0
09 7-Apr 12:00 PM B 7
09 7-Apr 12:00 PM C 7
09 7-Apr 12:00 PM D 0
09 7-Apr 3:00 PM A 0
09 7-Apr 3:00 PM B 7
09 7-Apr 3:00 PM C 5
09 7-Apr 3:00 PM D 0
09 7-Apr 6:00 PM A 0
09 7-Apr 6:00 PM B 4
09 7-Apr 6:00 PM C 3
09 7-Apr 6:00 PM D 0
09 7-Apr 9:00 PM A 0
09 7-Apr 9:00 PM B 5
09 7-Apr 9:00 PM C 5
09 7-Apr 9:00 PM D 0
10 7-Apr 9:00 AM A 0
10 7-Apr 9:00 AM B 6
10 7-Apr 9:00 AM C 2
10 7-Apr 9:00 AM D 1
10 7-Apr 12:00 PM A 0
10 7-Apr 12:00 PM B 8
10 7-Apr 12:00 PM C 3
10 7-Apr 12:00 PM D 0
10 7-Apr 3:00 PM A 0
10 7-Apr 3:00 PM B 6
10 7-Apr 3:00 PM C 3
10 7-Apr 3:00 PM D 0
10 7-Apr 6:00 PM A 0
10 7-Apr 6:00 PM B 1
10 7-Apr 6:00 PM C 0
10 7-Apr 6:00 PM D 0
10 7-Apr 9:00 PM A 0
10 7-Apr 9:00 PM B 2
10 7-Apr 9:00 PM C 1
10 7-Apr 9:00 PM D 0
11 7-Apr 9:00 AM A 0
11 7-Apr 9:00 AM B 2
11 7-Apr 9:00 AM C 2
11 7-Apr 9:00 AM D 0
11 7-Apr 12:00 PM A 0
11 7-Apr 12:00 PM B 2
11 7-Apr 12:00 PM C 0
11 7-Apr 12:00 PM D 0
11 7-Apr 3:00 PM A 0
11 7-Apr 3:00 PM B 0
11 7-Apr 3:00 PM C 0
11 7-Apr 3:00 PM D 0
11 7-Apr 6:00 PM A 0
11 7-Apr 6:00 PM B 0
11 7-Apr 6:00 PM C 1
11 7-Apr 6:00 PM D 0
11 7-Apr 9:00 PM A 0
11 7-Apr 9:00 PM B 0
11 7-Apr 9:00 PM C 0
11 7-Apr 9:00 PM D 0
01 8-Apr 9:00 AM A 0
01 8-Apr 9:00 AM B 7
01 8-Apr 9:00 AM C 3
01 8-Apr 9:00 AM D 1
01 8-Apr 12:00 PM A 0
01 8-Apr 12:00 PM B 8
01 8-Apr 12:00 PM C 4
01 8-Apr 12:00 PM D 0
