The script was edited to add one more column in the main_table (spt_rep1_ext). This was needed because siteID was a foreign key and expected text valies while spatial extents require numeric values. In addition added some paths to easily update the test data I've been working with into the databse.
The script was edited to add one more column in the main_table (spt_rep1_ext). This was needed because siteID was a foreign key and expected text valies while spatial extents require numeric values. In addition added some paths to easily update the test data I've been working with into the databse.

bibsian/database-development