TDWGtoITIS

tblTDWGtoITIS, for conversion of the TDWG geo classification to the ITIS geo classification.

• TDWGcode, text, 8 bytes maximum, TDWG classification
• Level1, character, 1 byte, TDWG classification, = tblGeoLevel1.Level1ID
• Level2, character, 1 byte, TDWG classification, = tblGeoLevel2.Level2ID
• Level3, character, 3 bytes, TDWG classification, = tblGeoLevel3.Level3ID
• Location, text, 50 bytes maximum, TDWG classification
• Jurisdiction, text, 50 bytes maximum, ITIS classification
• Geographic, text, 50 bytes maximum, ITIS classification