3. Landmarks: Merged, Moved

By Gene Stavrou
May 2022

Defining LANDMARK relationships (continued)

The first building to be called the Waldorf-Astoria Hotel started as two hotels: the Waldorf Hotel and the adjoining Astoria Hotel.

Merged

So, the Waldorf-Astoria facing Fifth Avenue between 33rd and 34th Streets succeeded both the Waldorf Hotel and the Astoria Hotel. That combined structure was replaced by the Empire State Building in 1931. The present Waldorf-Astoria on Park Avenue succeeded the first Waldorf-Astoria on Fifth.

[Waldorf Hotel (1893)] succeeded_by [Waldorf-Astoria (1897)
[Astor Hotel (1897)] succeeded_by [Waldorf-Astoria (1897)]
[Waldorf-Astoria (1897)] replaced_by [Empire State Building]
[Waldorf-Astoria (1897)] succeeded_by [Waldorf-Astoria (1929)]

Year is added to the landmark name to differentiate between incarnations. There is only one Empire State Building, so its year is not noted. Although their structures were not physically replaced, The Waldorf and The Astoria ceased to be, so our notation in the database records them as having been replaced on the site as well as succeeded by the first Waldorf-Astoria.

[Waldorf Hotel (1893)] replaced_by [Waldorf-Astoria (1897)
[Astor Hotel (1897)] replaced_by [Waldorf-Astoria (1897)]

Moved

Buildings are not always permanently sited. For example, Alexander Hamilton's uptown country house, Hamilton Grange, has been lifted off of its foundation and moved twice. The house, built in 1802, predated the 1811 Commissioner's (street grid) Plan, which mapped Manhattan's streets up to 155th Street. A corner of the house, in its original location, would have overlapped with 143rd Street. It was moved to Convent Avenue in the 1889 and then to Saint Nicholas Park in 2006.

[Hamilton Grange (1802)] moved_to [Hamilton Grange (1802, 1889 location)]
[Hamilton Grange (1802, 1889 location)] moved_to [Hamilton Grange (1802, 2006 location)]

Recent Nodes

	Empire State Building 30-March
	Waldorf Hotel 26-March
	Cass Gilbert 25-March
	Henry Janeway Hardenbergh 25-March
	New York Life Building (1928) 24-March
	Augustus Saint-Gaudens 23-March
	Richard Morris Hunt 22-March
	Lenox Library 21-March
	Madison Square Garden (1968) 20-March
	Stanford White 19-March
	New York and Harlem Railroad Madison Square Depot 19-March
	Madison Square Garden (1925) 19-March
	Madison Square Garden (1879) 18-March
	Madison Square Garden (1890) 18-March

Recent Edges

30-March	Henry Janeway Hardenbergh architect_of Waldorf Hotel
25-March	Cass Gilbert architect_of New York Life Building (1928)
25-March	Madison Square Garden (1890) replaced_by New York Life Building (1928)
25-March	Madison Square Garden (1890) succeeded_by Madison Square Garden (1925)
24-March	Richard Morris Hunt architect_of Lenox Library
23-March	Stanford White architect_of Madison Square Garden (1890)

2. Landmarks Can Change Over Time

By Gene Stavrou
April 2022

Treebase's data structure is meant to model the real world with an eye toward generating insights and visualizations. The database itself is made up of two basic constructs. NODES represent people, places, things, and ideas. EDGES describe relationships between nodes. This month we'll be defining characteristics of the LANDMARK node type (used to describe buildings, natural landscape features, works of art, and other objects) and its relationships. A building and its architect, for example, have the relationship "[building name] designed_by [architect name]," where designed_by is the edge between the building and architect nodes.

Although a landmark can be built on a foundation or rooted to the ground, its context can change over time. The landmark node type and its related edges must be able to note that context. We'll use real-world scenarios as use cases to create the language for describing landmark nodes and relationships.

Succeeded vs Replaced

We'll start with a particularly historic New York City building: the second Madison Square Garden (MSG2), built in 1890 on the site of the first Madison Square Garden (MSG1). Image: The second Madison Square Garden. MSG2 was demolished in 1926 to make way for the new headquarters of The New York Life Insurance Company (NY Life HQ), which stands on the site today. MSG3 was built farther uptown.

In our database, we'll need to differentiate between a building's next incarnation (what succeeded it) and what took its place on its site (what replaced it). In shorthand, we'll write

[MSG1] succeeded_by [MSG2]
[MSG1] replaced_by [MSG2]
[MSG2] succeeded_by [MSG3]
[MSG2] replaced_by [NY Life HQ]

The previous NY Life Headquarters (The "Clock Tower" Building) still stands on 346 Broadway.

[NY Life Clock Tower] succeeded_by [NY Life HQ]

1. Building a History Database

By Gene Stavrou
March 2022

Atimeline is just about the simplest device available for presenting historical events over time. It's a list of related milestones organized within a timeframe—a kind of shorthand for communicating history. Image: A simple timeline is a list of related milestones.

A timeline's content can be contained within a simple information structure: one table with each row representing one event, and columns containing event name, description, and date. Image: A simple timeline's information structure. Events are curated to describe a particular aspect of history. A biographical timeline, for example, could include a person's major life events ("hatch, match, dispatch"). A war timeline might list lead-up events, declarations of war, battles and outcomes, and treaty signing. A corporate timeline might include the founder's big idea; the company's formation, mergers, acquisitions, divestitures; leadership changes; product introductions, and other business milestones over time.

Such simple timelines are curated to answer two types of questions: "when did notable events happen?" and "what is the temporal relationship between those events?" They can also be used to make a statement; the company timeline's message is often "you can trust us; we've been around for a while." Adding an aspect or two helps in answering more complex questions. The company aspect paired with a geopolitical or economic aspect, for example, might reveal that the company thrived during wartime or benefitted from housing booms. The message of a war timeline might take on a different tone when paired with information that clarifies the war's human toll over time. Image: Paired timeline aspects can display correlation.

While pairing timelines can display correlation (these two events happened at the same time), a more complex information structure is required to display causality (this event directly affected the outcome of another). History is multifaceted and discovering reasonable causal connections between seemingly disconnected elements is what gets the mind buzzing. Exploring history is an ongoing process of linking nodes via relationships and there is wonder in traversing such a model and adding context and connections as you learn. Discovering a missing piece can be like finding a portal at what was thought to be a dead end.

The Treebase graph database is intended to map history connections and make discovering relationships easier.

Nodes and Edges

Information will be organized into a collection of nodes (or vertices) and edges (relationships). Image: A graph database focuses on nodes and relationships. Nodes can be thought of as nouns in that they represent people, places, things, and ideas. Edges are like verbs, and they connect two nodes by describing their relationship. Storing historical information in this "graph" format makes it available for analysis and for communication through a variety of formats—from the simple timeline to the voice user interface. We'll start by building the database's structure and rules.

Getting Started: Landmarks

Treebase will focus initially on New York City history as a theme for developing the database rules. We'll start by developing and populating the landmark node type, which includes physical features, such as sculpture, shoreline, and streets, as well as notable buildings. Later, these nodes will be connected to other nodes (people, ideas) as well as mapping coordinates, images, and other relationships via edges. Track the ongoing addition of nodes and relationships on this page.

Dakota Apartments, Exterior Railing Detail, 1884