updated hvac scraper to foreignkey format (thought this was already done...)