This query calls up the full list of all of SEAD’s location types (there are 14 of them) so that the location_type_id will be available to be joined to the location entity

This query calls up the full list of all of SEAD’s location types (there are 14 of them) so that the location_type_id will be available to be joined to the location entity
