Archive: Location: Template

Location Franchise Table Template

Purpose

Create a standardized table showing baseball team franchises that played in a specific location.

The table should:

• List every team franchise associated with the location.
• Include the league or leagues in which each franchise played.
• Include the years the franchise played at that location.
• Link each team name to its corresponding franchise-level thought inside the Baseball brain.
• Keep external StatsCrew URLs on the individual franchise thoughts as URL attachments.
• Preserve the StatsCrew location source link in the location thought.

Required Source Data

Use a reliable location source, preferably a StatsCrew “sports places” page.

The source should provide:

• League name or names.
• Team or franchise name.
• Years of operation at the location.
• A resource link for each team franchise.

If the source data has been pasted into the location thought’s notes, read that pasted content directly. Do not rely only on the source page title or a manually summarized list.

Source-Table and Final-Table Column Order

The pasted source table may use this order:

\| League | Team | Years |

This source order must not be treated as the required final order. When executing this workflow, preserve the source values but reorganize the completed location table into this standardized order:

\| Team | League | Years |
\|---|---|---:|
\| [Franchise Thought] | [League] | [Years] |

The Team column comes first because the table is primarily a list of franchise thoughts associated with the location. The League column is supporting classification information. Do not confuse the source-table order with the required final order.

Standard Final Table Format

Teams that played in **[Location]**

\| Team | League | Years |
\|---|---|---:|
\| [Franchise Thought] | [League] | [Years] |

Source: [StatsCrew — [Location]]([StatsCrew Location URL])

Formatting Rules

• Use a standard Markdown table.
• The final table must use three columns in this order: Team, League, and Years.
• Extract and preserve the source table’s League, Team, and Years values, even when the source places League first.
• Move the source Team value into the first final-table column.
• Use the franchise name without an appended season or year in the Team column.
• Use an en dash (–) for year ranges.
• Preserve multiple leagues in the same cell, separated by commas.
• Use plain text and standard Markdown links.
• Do not use TheBrain inline color wrappers such as :{text}:(style="...").
• Do not use external StatsCrew URLs as the table’s team links.
• The team name in the final table must link to an internal franchise-level thought in the Baseball brain.

Thought-Matching and Franchise/Season Hierarchy Workflow

For every team franchise in the source list:

1. Read the pasted source content directly and extract each League, Team, Years, and StatsCrew team URL value.
2. Ignore the source column order when constructing the final table; map values by their headings or list structure.
3. Search the Baseball brain for the exact franchise name.
4. Prefer an existing franchise-level thought whose name does not include a season or year.
5. Never use a thought named in the form Team Name - YEAR as the franchise link when a franchise-level thought exists.
6. If the franchise-level thought does not exist, create a new thought using the team franchise name exactly as listed by the source, without appending a year.
7. Link the franchise-level thought as a child of the location thought.
8. Preserve any existing relationships the franchise thought already has.
9. Do not delete, rename, or replace existing year-specific team thoughts.
10. Link each applicable year-specific thought beneath its corresponding franchise-level thought as a child. Year-specific thoughts should remain named with their appended year, such as Team Name - 1904.
11. If an existing franchise thought is already a child of the location thought, do not create a duplicate link.
12. If an existing year-specific thought is already a child of the franchise thought, do not create a duplicate link.
13. Generate a valid internal thought link for the franchise-level thought.
14. Place the internal franchise link in the first column of the final table, not in the League column.

Important Distinction

The location table represents franchises, not individual seasons. For example:

Location thought
└── Corsicana Oil City Oilers
    └── Corsicana Oil City Oilers - 1904

The table links to Corsicana Oil City Oilers; it must not link directly to Corsicana Oil City Oilers - 1904.

Franchise Thought Naming

Use the franchise name as listed by the source, without adding unnecessary years.

Examples:

Pawtucket Red Sox
Pawtucket Indians
Pawtucket Rovers
Pawtucket Tigers

Use a year in the thought name only for a season-specific child thought when the source or existing brain structure clearly identifies that season.

StatsCrew URL Workflow

For each franchise:

1. Obtain the franchise’s resource URL from the pasted source data.
2. Attach that URL to the corresponding franchise-level thought.
3. Use a descriptive attachment title, such as StatsCrew — [Team Name].
4. Do not place the StatsCrew team URL in the location table.
5. Keep the StatsCrew location/source URL in the location thought.
6. If a StatsCrew team URL is already attached to another thought, do not duplicate the attachment. Record that the URL is intentionally shared or already represented elsewhere.

Icon Workflow

Icons provide a visual status cue, but icon absence must not be used to infer that a source URL is missing.

• When a thought has a unique source URL and a source-derived icon is available, retain or apply that icon.
• When a source URL is intentionally not attached because it duplicates a URL already attached elsewhere, apply a neutral stock baseball icon (Sports/baseball) so the thought is not visually mistaken for an unresolved record.
• When no source URL has been found or the source is unresolved, use a distinct “needs research” icon if an appropriate stock icon is available, and report the unresolved source.
• Do not replace an existing meaningful custom icon without a specific reason.
• If using a stock icon, search for the icon first and use the exact returned icon path; do not guess icon paths.

Internal Thought Links

Use TheBrain’s generated internal thought URL format:

brain://api.thebrain.com/[brain-id]/[thought-id]/[thought-name]

Mandatory Internal-Link Safeguards

• Never manually construct, guess, edit, or infer a brain:// URL.
• Always call TheBrain’s thought-link URL generator for every internal thought link.
• Use the generator’s returned Markdown link exactly as provided; do not modify its brain ID, thought ID, slug, or formatting.
• Treat a generated link as valid only when the URL generator returns a complete URL and Markdown link for the intended thought.
• If the generator fails, returns an incomplete result, or does not return a link for the intended thought, do not create or insert a substitute URL.
• Do not use a year-specific thought’s generated link when a franchise-level thought is required.
• If a valid internal link cannot be generated, leave the team name as plain text temporarily and report the unresolved franchise clearly.
• Before writing the final note, verify that every internal table link came directly from a successful URL-generator result.

Example:

[Pawtucket Red Sox](https://app.thebrain.com/brain/7f601502-fd8b-40ea-ba42-6843c4d95fbd/00000000-0000-0000-0000-000000000000)

The generated internal link belongs in the Team column of the final table.

Link Validation

Before finalizing the table:

• Confirm that every team name has an internal franchise-level thought link in the first column.
• Confirm that no table link points to a year-specific thought when a franchise-level thought exists.
• Confirm that each linked franchise thought exists in the Baseball brain.
• Confirm that each franchise thought is a child of the location thought.
• Confirm that each year-specific thought is a child of its corresponding franchise thought, when applicable.
• Confirm that each StatsCrew team URL is attached to the corresponding franchise thought, when attachment creation succeeds.
• Confirm that the table contains no invalid or guessed brain:// URLs.
• Confirm that external StatsCrew team URLs are not used as table links.
• Confirm that the final column order is exactly Team | League | Years.
• Confirm that the source’s League | Team | Years order has been intentionally transformed rather than copied unchanged.
• Confirm that every internal link was copied exactly from a successful URL-generator response.
• Confirm that icon choices accurately distinguish duplicate-source handling from unresolved source data.

If a franchise thought ID cannot be resolved or a valid internal link cannot be generated:

• Do not guess the URL.
• Do not create a manually constructed brain:// link.
• Report the unresolved franchise clearly.
• Leave the franchise as plain text temporarily, or ask for clarification.

Location Source Link

Retain the source link at the bottom of the location note:

Source: [StatsCrew — [Location]]([StatsCrew Location URL])

The source link may remain external because it identifies the location source, not a team thought.

Preservation Rules

When updating a location thought:

• Replace or update only the location franchise table and its related instructions.
• Preserve unrelated notes already present on the location thought unless the user asks for a complete rewrite.
• Do not delete existing team thoughts.
• Do not delete existing links.
• Do not remove existing attachments unless specifically requested.
• Do not overwrite useful team information stored on individual franchise thoughts.
• Do not merge franchise-level thoughts with year-specific thoughts.
• Do not rename existing year-specific thoughts merely to make them franchise-level thoughts.

Completion Checklist

• Source list identified
• Source column order recognized and handled
• All franchises extracted
• League names preserved
• Years normalized with en dashes
• Final columns ordered Team | League | Years
• Franchise-level thoughts searched
• Missing franchise-level thoughts created without appended years
• Franchise thoughts linked as children of the location thought
• Existing year-specific thoughts linked beneath their franchise thoughts
• StatsCrew URLs attached to franchise thoughts
• Duplicate StatsCrew URLs not reattached unnecessarily
• Internal franchise links generated in the Team column
• Every internal link obtained from TheBrain’s URL generator; no manual brain:// URLs used
• Duplicate-source thoughts given a neutral stock baseball icon when appropriate
• Unresolved-source thoughts clearly distinguished and reported
• Table updated
• External team URLs removed from the table
• Location source URL retained
• Franchise and season-child links validated

Recommended Name

Location Franchise Table Template

Alternative names:

• Location Template
• Baseball Location Team Template
• Location-to-Franchise Organization Template
• Baseball Location Franchise Workflow

This is a reusable template and operating procedure. A fully automated implementation would be a script.

Versioning Record

• Previous version: Location Franchise Table v2.0
• New version: Location Franchise Table v2.1
• Change: Added a minimal-exploration workflow and append-only note-preservation rules.
• Date: 2026-09-14

Recovery Notice

The previous workflow instructions were unintentionally overwritten during the v2.1 update. The archive thought [[thought:18823dda-2af0-4e01-aaea-2401186ca50f|Location: Template — Archive — v2.0 — 2026-09-14]] records the prior version identity, but the original text could not be recovered from the available tool state. No further note edits will be made without explicit confirmation.