SELECT `id` FROM `city` WHERE `name` = 'upper dublin'