Remove unused codes
Updating schema with links to observations
Adding all static codes