STEPS TO UPLOADING Tree Data FROM A FIRST CENSUS ENTERED ELSEWHERE


1. Create the database

2. Call it up in MySQL

3. Create the necessary tables, indexes and constraints (New_Database_Structure.sql)

4. Insert the Family and Genus names from APG - all sites are using these same tables

5. Create the necessary Temp Tables for the ctfsweb program to work (createTempTables.sql)

6. Insert the Site information such as country, location, utm coordinates, size of the plot, etc.

7. Create staging tables with the same columns as your text files.

8. Insert your census data into the staging table

9. After doing some basic screening to make sure everything is OK, insert the corresponding fields into the TempNewPlants table

10. Insert the corresponding fields into the TempLocations table if coordinates are in a separate file

11. Load the Species data into the TempSpecies table. The ctfsweb program will upload it into the Species table

12. Load your tree/stem/measurement codes into a staging table then upload into the TSMAttributes table

13. Load the names of the personnel involved in the census

14. Load the corresponding quadrat information into the Quadrat, CensusQuadrat, and Coordinates tables

15. Now you are ready to go into ctfsweb and start screening the Temp tables for errors.

16. Once everything is OK, upload the data from the temporary tables into the database tables

17. Create ViewFullTable