Details

Keywords Change this

Add this

Foundation

Massachusetts, USA

Selected Architecture


Practice / Active in Change this

Preston Scott Cohen, Inc.
179 Sidney Street, 1st Floor
MA 02139 Cambridge, Massachusetts, USA

www.pscohen.com

Preston Scott Cohen Change this

Change thisCambridge, Massachusetts, USA
est. Massachusetts
1 of 1

About Change this

Preston Scott Cohen is a full service firm created by the architect of the same name with a team of six architectural designers and two project architects. Commissions encompass projects of diverse scales and types including houses, educational facilities, cultural institutions and urban designs for private owners, government agencies and corporations.

Preston ScottCohen received his Bachelor of Fine Arts and Bachelor of Architecture degrees from the Rhode Island School of Design in 1982 and 1983 (respectively). In 1985, he received his Master of Architecture degree from the Harvard GSD. Gaining professorship there in 2003, he also served as the Director of the Architecture degree program. In 2008, he was appointed Chair of the GSD, a position held just prior by Toshiko Mori, and at one point by Walter Gropius.

Comments

Register to join to conversation.

(default) 63 queries took 328 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `architects`54543
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';112
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';113
4SHOW FULL COLUMNS FROM `users`38383
5SHOW FULL COLUMNS FROM `roles`663
6SHOW FULL COLUMNS FROM `countries`333
7SHOW FULL COLUMNS FROM `states`332
8SHOW FULL COLUMNS FROM `auth_keys`772
9SHOW FULL COLUMNS FROM `auth_key_types`223
10SHOW FULL COLUMNS FROM `feeds`663
11SHOW FULL COLUMNS FROM `top_list_items`773
12SHOW FULL COLUMNS FROM `top_lists`553
13SHOW FULL COLUMNS FROM `architecture_types`333
14SHOW FULL COLUMNS FROM `architecture_conditions`332
15SHOW FULL COLUMNS FROM `articles`22223
16SHOW FULL COLUMNS FROM `object_views`553
17SHOW FULL COLUMNS FROM `images`22223
18SHOW FULL COLUMNS FROM `sources`773
19SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';113
20SHOW FULL COLUMNS FROM `hp_features`443
21SHOW FULL COLUMNS FROM `architects_architectures`553
22SHOW FULL COLUMNS FROM `architecture_partners`663
23SHOW FULL COLUMNS FROM `partner_roles`222
24SHOW FULL COLUMNS FROM `comments`16163
25SHOW FULL COLUMNS FROM `wall_posts`773
26SHOW FULL COLUMNS FROM `profile_visits`443
27SHOW FULL COLUMNS FROM `login_tokens`773
28SHOW FULL COLUMNS FROM `watched_objects`662
29SHOW FULL COLUMNS FROM `comments_users`662
30SHOW FULL COLUMNS FROM `tags`553
31SHOW FULL COLUMNS FROM `architectures_tags`662
32SHOW FULL COLUMNS FROM `architects_tags`663
33SHOW FULL COLUMNS FROM `versions`883
34SHOW FULL COLUMNS FROM `associates`662
35SHOW FULL COLUMNS FROM `timelines`662
36SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
37SHOW FULL COLUMNS FROM `likes`552
38SELECT `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification`, `Role`.`id`, `Role`.`name`, `Role`.`permissions`, `Role`.`description`, `Role`.`created`, `Role`.`modified` FROM `users` AS `User` LEFT JOIN `roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `login` = 'guest@architectuul.com' LIMIT 11128
39SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
40SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
41UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-07-22 19:33:38', `modified` = '2019-07-22 19:33:38' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
42SELECT `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11110
43SELECT `Architect`.`id`, `Architect`.`old_id`, `Architect`.`user_id`, `Architect`.`comment_count`, `Architect`.`image_count`, `Architect`.`views`, `Architect`.`views_last_day`, `Architect`.`views_last_week`, `Architect`.`views_last_month`, `Architect`.`last_viewed`, `Architect`.`likes`, `Architect`.`nonlikes`, `Architect`.`created`, `Architect`.`modified`, `Architect`.`title`, `Architect`.`slug`, `Architect`.`date_of_birth`, `Architect`.`date_of_death`, `Architect`.`birthplace_city`, `Architect`.`birthplace_country`, `Architect`.`bio`, `Architect`.`html_biography`, `Architect`.`education`, `Architect`.`awards`, `Architect`.`company`, `Architect`.`history`, `Architect`.`quote`, `Architect`.`materials`, `Architect`.`sectors`, `Architect`.`tags`, `Architect`.`is_featured`, `Architect`.`last_featured_on`, `Architect`.`biography`, `Architect`.`start_year`, `Architect`.`start_month`, `Architect`.`start_day`, `Architect`.`end_year`, `Architect`.`end_month`, `Architect`.`end_day`, `Architect`.`texts`, `Architect`.`links`, `Architect`.`person`, `Architect`.`practice`, `Architect`.`practice_address`, `Architect`.`practice_city`, `Architect`.`practice_state`, `Architect`.`practice_zip`, `Architect`.`practice_country_id`, `Architect`.`practice_website`, `Architect`.`associates`, `Architect`.`deleted`, `Architect`.`deleted_date`, `Architect`.`is_incomplete`, `Architect`.`incomplete_date`, `PracticeCountry`.`id`, `PracticeCountry`.`name`, `PracticeCountry`.`user_count` FROM `architects` AS `Architect` LEFT JOIN `countries` AS `PracticeCountry` ON (`Architect`.`practice_country_id` = `PracticeCountry`.`id`) WHERE `Architect`.`deleted` = 0 AND `Architect`.`slug` = 'preston-scott-cohen' LIMIT 1116
44SELECT `PracticeCountry`.`id`, `PracticeCountry`.`name`, `PracticeCountry`.`user_count` FROM `countries` AS `PracticeCountry` WHERE `PracticeCountry`.`id` = '4936948a-7de0-4a3f-9aa3-4aed1030b5da' 112
45SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('51baf419-bdcc-4ac9-a201-5bbe6d7b5f76') 226
46SELECT `Timeline`.`date`, `Timeline`.`description`, `Timeline`.`architect_id` FROM `timelines` AS `Timeline` WHERE `Timeline`.`architect_id` = ('51baf419-bdcc-4ac9-a201-5bbe6d7b5f76') ORDER BY `Timeline`.`date` asc 004
47SELECT `Associate`.`user_id`, `Associate`.`type`, `Associate`.`architect_id` FROM `associates` AS `Associate` WHERE `Associate`.`architect_id` = ('51baf419-bdcc-4ac9-a201-5bbe6d7b5f76') 003
48SELECT `Tag`.`slug`, `Tag`.`name`, `ArchitectsTag`.`id`, `ArchitectsTag`.`architect_id`, `ArchitectsTag`.`tag_id`, `ArchitectsTag`.`old_id`, `ArchitectsTag`.`old_architect_id`, `ArchitectsTag`.`old_tag_id` FROM `tags` AS `Tag` JOIN `architects_tags` AS `ArchitectsTag` ON (`ArchitectsTag`.`architect_id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76' AND `ArchitectsTag`.`tag_id` = `Tag`.`id`) 005
49SELECT `Image`.`id`, `Image`.`aiid`, `Image`.`user_id`, `Image`.`model`, `Image`.`foreign_id`, `Image`.`description`, `Image`.`author`, `Image`.`license`, `Image`.`source_name`, `Image`.`source_link`, `Image`.`orig_url`, `Image`.`lg_url`, `Image`.`bg_url`, `Image`.`md_url`, `Image`.`sm_url`, `Image`.`th_url`, `Image`.`is_cropped`, `Image`.`orig_width`, `Image`.`orig_height`, `Image`.`_order`, `Image`.`modified`, `Image`.`created`, `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification` FROM `images` AS `Image` LEFT JOIN `users` AS `User` ON (`Image`.`user_id` = `User`.`id`) WHERE `foreign_id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 1152
50SELECT `Version`.`id`, `Version`.`version_id`, `Version`.`user_id`, `Version`.`model`, `Version`.`foreign_id`, `Version`.`result`, `Version`.`comment`, `Version`.`created` FROM `versions` AS `Version` WHERE `Version`.`foreign_id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76' ORDER BY `Version`.`version_id` desc LIMIT 1002
51SELECT `Version`.`id`, `Version`.`version_id`, `Version`.`user_id`, `Version`.`model`, `Version`.`foreign_id`, `Version`.`result`, `Version`.`comment`, `Version`.`created`, `User`.`username`, `User`.`slug` FROM `versions` AS `Version` LEFT JOIN `users` AS `User` ON (`Version`.`user_id` = `User`.`id`) WHERE `Version`.`foreign_id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76' AND `Version`.`version_id` IS NULL LIMIT 1002
52SELECT `Associate`.`id`, `Associate`.`user_id`, `Associate`.`architect_id`, `Associate`.`past`, `Associate`.`type`, `Associate`.`created` FROM `associates` AS `Associate` WHERE ((`architect_id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76') OR (`user_id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76')) 002
53SELECT DISTINCT CommentsUser.comment_id, CommentsUser.parent_id, Comment.body, Comment.last_message_id, `Comment`.`id` FROM `comments_users` AS `CommentsUser` LEFT JOIN `comments` AS `Comment` ON (`CommentsUser`.`comment_id` = `Comment`.`id`) WHERE `CommentsUser`.`foreign_id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76' ORDER BY `Comment`.`id` desc 002
54SELECT `ArchitectsArchitecture`.`id`, `ArchitectsArchitecture`.`architect_id`, `ArchitectsArchitecture`.`architecture_id`, `ArchitectsArchitecture`.`_order`, `ArchitectsArchitecture`.`created`, `Architecture`.`id`, `Architecture`.`user_id`, `Architecture`.`old_id`, `Architecture`.`old_architect_id`, `Architecture`.`comment_count`, `Architecture`.`image_count`, `Architecture`.`views`, `Architecture`.`views_last_day`, `Architecture`.`views_last_week`, `Architecture`.`views_last_month`, `Architecture`.`last_viewed`, `Architecture`.`likes`, `Architecture`.`nonlikes`, `Architecture`.`created`, `Architecture`.`modified`, `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`html_description`, `Architecture`.`also_known_as`, `Architecture`.`address`, `Architecture`.`city`, `Architecture`.`state`, `Architecture`.`country_id`, `Architecture`.`zip`, `Architecture`.`lat`, `Architecture`.`lng`, `Architecture`.`area`, `Architecture`.`team`, `Architecture`.`partners`, `Architecture`.`client`, `Architecture`.`client_website`, `Architecture`.`company`, `Architecture`.`cost`, `Architecture`.`cost_currency`, `Architecture`.`architecture_type_id`, `Architecture`.`architecture_condition_id`, `Architecture`.`old_building_condition_id`, `Architecture`.`old_building_type_id`, `Architecture`.`structural_engineers`, `Architecture`.`service_engineers`, `Architecture`.`site_supervision`, `Architecture`.`project_management`, `Architecture`.`start_date`, `Architecture`.`end_date`, `Architecture`.`movements`, `Architecture`.`materials`, `Architecture`.`tags`, `Architecture`.`is_featured`, `Architecture`.`last_featured_on`, `Architecture`.`description`, `Architecture`.`start_year`, `Architecture`.`start_month`, `Architecture`.`start_day`, `Architecture`.`end_year`, `Architecture`.`end_month`, `Architecture`.`end_day`, `Architecture`.`texts`, `Architecture`.`links`, `Architecture`.`website`, `Architecture`.`deleted`, `Architecture`.`deleted_date`, `Architecture`.`is_incomplete`, `Architecture`.`incomplete_date` FROM `architects_architectures` AS `ArchitectsArchitecture` LEFT JOIN `architectures` AS `Architecture` ON (`ArchitectsArchitecture`.`architecture_id` = `Architecture`.`id`) WHERE `ArchitectsArchitecture`.`architect_id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76' ORDER BY `Architecture`.`views` desc LIMIT 6116
55SELECT `Architecture`.`id`, `Architecture`.`user_id`, `Architecture`.`old_id`, `Architecture`.`old_architect_id`, `Architecture`.`comment_count`, `Architecture`.`image_count`, `Architecture`.`views`, `Architecture`.`views_last_day`, `Architecture`.`views_last_week`, `Architecture`.`views_last_month`, `Architecture`.`last_viewed`, `Architecture`.`likes`, `Architecture`.`nonlikes`, `Architecture`.`created`, `Architecture`.`modified`, `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`html_description`, `Architecture`.`also_known_as`, `Architecture`.`address`, `Architecture`.`city`, `Architecture`.`state`, `Architecture`.`country_id`, `Architecture`.`zip`, `Architecture`.`lat`, `Architecture`.`lng`, `Architecture`.`area`, `Architecture`.`team`, `Architecture`.`partners`, `Architecture`.`client`, `Architecture`.`client_website`, `Architecture`.`company`, `Architecture`.`cost`, `Architecture`.`cost_currency`, `Architecture`.`architecture_type_id`, `Architecture`.`architecture_condition_id`, `Architecture`.`old_building_condition_id`, `Architecture`.`old_building_type_id`, `Architecture`.`structural_engineers`, `Architecture`.`service_engineers`, `Architecture`.`site_supervision`, `Architecture`.`project_management`, `Architecture`.`start_date`, `Architecture`.`end_date`, `Architecture`.`movements`, `Architecture`.`materials`, `Architecture`.`tags`, `Architecture`.`is_featured`, `Architecture`.`last_featured_on`, `Architecture`.`description`, `Architecture`.`start_year`, `Architecture`.`start_month`, `Architecture`.`start_day`, `Architecture`.`end_year`, `Architecture`.`end_month`, `Architecture`.`end_day`, `Architecture`.`texts`, `Architecture`.`links`, `Architecture`.`website`, `Architecture`.`deleted`, `Architecture`.`deleted_date`, `Architecture`.`is_incomplete`, `Architecture`.`incomplete_date` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '51baf6d7-fec0-4991-9c93-65ae6d7b5f76' 112
56SELECT `Image`.`id`, `Image`.`aiid`, `Image`.`user_id`, `Image`.`model`, `Image`.`foreign_id`, `Image`.`description`, `Image`.`author`, `Image`.`license`, `Image`.`source_name`, `Image`.`source_link`, `Image`.`orig_url`, `Image`.`lg_url`, `Image`.`bg_url`, `Image`.`md_url`, `Image`.`sm_url`, `Image`.`th_url`, `Image`.`is_cropped`, `Image`.`orig_width`, `Image`.`orig_height`, `Image`.`_order`, `Image`.`modified`, `Image`.`created` FROM `images` AS `Image` WHERE `Image`.`foreign_id` = ('51baf6d7-fec0-4991-9c93-65ae6d7b5f76') ORDER BY `_order` asc, `created` asc 4439
57SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76' 112
58SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76' 112
59UPDATE `architects` SET `id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76', `views` = 1452, `views_last_day` = 1, `views_last_week` = 1, `views_last_month` = 13, `last_viewed` = '2019-07-22 19:33:38', `modified` = '2013-06-20 14:22:25' WHERE `architects`.`id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76'13
60SELECT `Architect`.`user_id` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76' AND `Architect`.`deleted` <> 1 LIMIT 1112
61SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`user_id` = '51926479-9a10-4a9b-a9fb-5d196d7b5f76' AND `Architect`.`deleted` <> 1 116
62UPDATE `users` AS `User` LEFT JOIN `roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) LEFT JOIN `countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`User`.`state_id` = `State`.`id`) SET `User`.`architect_count` = 68 WHERE `User`.`id` = '51926479-9a10-4a9b-a9fb-5d196d7b5f76'03
63UPDATE `articles` AS `Article` LEFT JOIN `architects` AS `Architect` ON (`Article`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Article`.`foreign_id` = `Architecture`.`id`) SET `Article`.`views` = "1452", `Article`.`views_last_day` = "1", `Article`.`views_last_week` = "1", `Article`.`views_last_month` = "13", `Article`.`last_viewed` = "2019-07-22 19:33:38" WHERE `foreign_id` = '51baf419-bdcc-4ac9-a201-5bbe6d7b5f76'133