Files
settled-reach/docs/design/systems-framework-final-paula.md
jpmschweitzerandClaude Opus 4.6 7da62369ab docs(docs): add 300-system CSV framework and design iterations
Canonical framework (systems-framework.md) defines 66 columns for all
300 star systems, organized as wiki-ready sections. Covers colonization
waves, cultural archetypes, tone framework, economic distribution, and
Krenn validation criteria.

Includes all iteration rounds: Miri/Paula originals, cross-pollination
synthesis, Gestalt mechanical review, and final revisions removing grand
conspiracy in favor of fear-driven Earth-Reach secession narrative.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-13 22:57:23 +01:00

46 KiB
Raw Permalink Blame History

Star Systems Framework — Final Position

Author: Paula Status: Final pre-consolidation document Created: 2026-03-13 Purpose: Final position on all contested questions before the unified CSV spec is locked. Addresses the lead's four locked decisions and the conspiracy/emigration contradiction directly.


Preamble

Four decisions are now locked. Three of them are clarifications that sharpen what was already in the synthesis. One of them — the conspiracy/emigration contradiction — requires genuine rethinking, not just integration.

I am going to address the hard one first.


Part 1: The Conspiracy/Emigration Contradiction — Resolved

1.1 The Lead's Objection, Stated Precisely

The lead liked Option B: the secession was a Perpetual political maneuver to consolidate power. But then the lead asked the correct question: if this was a power grab, how do you reconcile it with the fact that ALL cultures and groups had equal access to emigrate to the Reach? A conspiracy to grab power would logically restrict who gets in.

This is a real objection. A naive reading of "Perpetual power grab" does suggest exclusion — you grab power by controlling membership. So what gives?

1.2 The Wrong Assumption Embedded in the Objection

The objection assumes the Perpetuals were grabbing territorial power — the power that comes from controlling who is inside a space.

They were not. They were grabbing framework power — the power that comes from controlling the rules, institutions, and regulatory structures that everyone inside the space must operate within.

These are categorically different kinds of power, and they require opposite strategies.

Territorial power (control of a fixed space and its resources) is maximized by restricting access. Fewer people competing for territory = more territory per person. A feudal lord limits who can farm the land because the land is the resource.

Framework power (control of governance, law, regulation, institutional legitimacy) is maximized by expanding the population subject to your framework. More people means more economic activity subject to your regulation, more factions requiring arbitration by your institutions, more citizens generating tax, transit fees, lattice compliance requirements, and commercial permits. A regulatory authority limits who makes the rules; it benefits when more people are subject to those rules.

The founding Perpetuals were not interested in owning the Reach. They were interested in being the people who defined what the Reach was.

1.3 Why Open Emigration Was the Conspiracy

Let me complicate this by being specific about what the Perpetuals actually needed for their power grab to work.

They needed democratic legitimacy. The secession from Earth required a political mandate. That mandate could only come from a large and demonstrably diverse population who had actively chosen to live in the Reach under its governance. A small, restricted, homogeneous population would have looked like exactly what it was: a faction seizing control of a settlement project. A large, cosmopolitan, genuinely multi-cultural population that had freely chosen to come here was the proof of legitimacy. Every ship full of Nordic-diaspora families, every religious refugee community, every independent economic migrant who arrived and stayed — each one was evidence that the Reach was a real civilization with real self-determination, not a corporate colony run for someone's private benefit.

The Perpetuals needed these people. Not to govern them in any warm or genuine sense — but to be governed, because being governed is what conferred legitimacy on the governors.

They needed fragmentation. A large, diverse population that does not share cultural, linguistic, or ideological foundations cannot organize unified resistance to institutional authority. This is not unique to the Settled Reach — it is the oldest tool of imperial governance. Diversity is not inherently disempowering, but when that diversity is channeled through a single set of institutions that the diverse groups all depend on for access to legal systems, commercial permits, dispute resolution, and medical infrastructure — the diversity becomes a structural advantage for those who run the institutions.

Each cultural community in the Reach was self-organizing, internally coherent, and capable of managing its own affairs. What it needed the Assembly's institutions for was external — relations with OTHER communities, access to the gate transit network, commercial contracts that required recognized legal standing, protection against corporate extraction. The Perpetuals ran all of that. No single community was large enough to run it themselves. The diversity that made the Reach genuinely cosmopolitan also made it structurally dependent on the one body that mediated between all those communities.

They needed economic scale. The Reach's gate network required maintenance, expansion, and institutional oversight. The Commission's regulatory mandate generated revenue. The Syndic-Assembly licensing agreements generated leverage. The research grants to the Veil Institute generated knowledge that could be classified. None of this was profitable at small scale. Open emigration built the population base that made all of it viable.

They needed time. The oldest surviving Perpetuals would outlive every objector, every reformer, every coalition that formed against them. Open emigration accelerated the building of the infrastructure in which the Perpetuals were embedded. Every additional generation of new settlers was a generation that arrived into a political system the founding Perpetuals had already built and normalized. By the time any given wave of settlers was old enough to meaningfully challenge the institutional structure, they were old enough to be vulnerable to co-optation by it. The founding Perpetuals had no interest in preventing people from joining the Reach. They just needed to still be there when people arrived, to be the ones who explained how things worked.

1.4 What "Equal Access" Actually Meant

Here is the honest truth about what open emigration looked like from the inside of the conspiracy.

Every group was welcome to come. The Nordic-diaspora communities could build their own settlements. The religious refugee colonies could establish their own governance practices. The Separatist charter communities could organize themselves according to their own principles. The corporate Syndic charters could operate their own labor contracts.

What none of them could do was build a gate. What none of them could do was operate an aperture without Veil Institute certification. What none of them could do was ship freight at scale without Commission permits. What none of them could do was establish Concord Assembly representation without following the Assembly's established procedures for territory recognition.

Equal access to settlement. No access to the infrastructure of power.

The conspiracy was not about restricting who could come in. It was about ensuring that everyone who came in would, eventually, need what the founding Perpetuals controlled. The open door was not generosity. It was the intake mechanism of a very sophisticated machine.

1.5 The Specific Mechanism: The Secession as the Lock Snapping Shut

The secession from Earth was the moment the mechanism completed.

Before the secession, the Reach's political institutions operated alongside Earth's authority. Earth governance was an external check that could, in principle, constrain what the founding Perpetuals could do. Reach citizens who were aggrieved could appeal to Earth's legitimacy. Earth's diplomatic and potentially military presence was a ceiling on how complete the founding Perpetuals' control could be.

The secession removed that ceiling.

This is the specific political maneuver. The founding Perpetuals did not restrict emigration to the Reach. They built the Reach large enough to declare independence credibly — and then they declared it. After the secession, there was no external authority above them. The diverse, cosmopolitan, genuinely multicultural population they had encouraged to come had made the secession legitimate in the eyes of the world. That population was now entirely subject to institutions the founding Perpetuals controlled, with no external recourse available.

The open door was the mechanism by which the population was assembled. The secession was the mechanism by which the door was locked — from the outside. The founding Perpetuals did not need to restrict who entered. They just needed to be still running the institutions when the last external check was removed.

1.6 Why Earth's Response Fit the Script

One more layer that matters for the narrative: Earth's response to the secession was to close its own end of the gate connection.

From the founding Perpetuals' perspective, this was nearly ideal. Earth slamming its borders closed achieved three things they could not have done themselves:

It validated the founding narrative. "We wanted independence; they punished us for it." The Reach didn't close the Earth gate — Earth did. The founding Perpetuals could now point to Earth's punitive response as proof that independence was necessary and correct. Earth's wounded pride had done the ideological work for them.

It eliminated the most dangerous kind of opposition. The opponents of the founding Perpetuals' consolidation project were not the diverse settler communities who had come to the Reach voluntarily and had limited knowledge of Earth. The dangerous opponents were the ones with direct Earth connections — old families with standing in both political systems, Perpetuals whose pre-secession relationships gave them access to an alternative legitimacy structure. Earth closing the gate effectively cut those people off from their leverage. You cannot credibly threaten to appeal to Earth's authority when Earth's door is closed.

It turned the Earth-sympathetic faction into a political liability. In the post-secession Reach, being publicly Earth-sympathetic was now coded as being sympathetic to the power that had just punished the Reach for wanting self-determination. The founding Perpetuals did not need to suppress Earth-sympathetic political factions. Earth had done it for them.

The conspiracy did not require Earth to cooperate. It was robust to Earth's hostility. In fact, Earth's hostility was a useful feature. The founding Perpetuals had built something that gained legitimacy from the opposition it faced.


Part 2: Earth Closing Its End — The Political Narrative

2.1 The Founding Myth

The lead has locked: the Reach declared independence; Earth got pissy and closed their borders.

This single fact shapes the Reach's foundational self-understanding in ways that need to be explicit in the political framework:

The Reach's founding myth is structurally different from what it would be if Earth had expelled them.

If Earth had expelled the Reach, the Reach's founding myth would be organized around endurance and survival in the face of rejection. The emotional register would be defiance-by-necessity.

Because the Reach declared independence and Earth retaliated, the founding myth is organized around justified assertion. "We exercised our right to self-determination. Earth, unable to accept that we had outgrown our origins, closed its doors." The emotional register is righteous grievance, not defiance. The Reach did not fight for independence. It asserted independence, and Earth's petulant response confirmed that the independence was correct.

This is a more comfortable founding myth. It does not require the Reach to justify suffering. It just requires Earth to have behaved badly, which it did. Every generation since has been raised on a story where the Reach was the adult in the room and Earth was the parent who couldn't let go. That story is mostly true, which is what makes it so effective.

The specific consequences for each political position:

Political Faction How Earth's Door-Closing Functions Tone
Reach Loyalists Proof of vindication. Earth revealed its true character: punitive, controlling, unable to accept the Reach's legitimate independence. "Look what they did when we simply said we were our own civilization." Righteous, mildly contemptuous of Earth, comfortable
Earth-Sympathetics Private anguish: they believe the connection should have been preserved, but Earth's response made that position publicly untenable. Earth handed the Loyalists a gift by closing the door. The Earth-sympathetic position is now coded as apologizing for the party that punished you. Defensive, often expressed obliquely
Separatists (Anti-Institutional) Partial validation. "The Core used Earth's door-closing as the excuse to consolidate everything — Concord authority, Commission mandate, Syndic licensing. Earth's retaliation was the crisis the Core needed to justify building permanent control structures." The conspiracy reading: the secession was engineered partly to produce Earth's retaliation, which in turn justified the post-secession institutional consolidation. Skeptical of the founding myth while nominally sharing its premise
Separatists (Earth-Alignment Opportunists) Complex. Earth's closed door is an obstacle to their strategy (making quiet contact with Earth governance as a counter-legitimacy source). But it also means Earth has had 300+ years to become frustrated by its own exclusion — which may make it more open to overtures from Reach actors who can offer renewed access. Calculating
Separatists (Principled Independence) The clearest: Earth's door-closing and the Core's subsequent institutional consolidation are morally equivalent. Both are large authorities closing off options for people who never asked to be governed by either. Philosophically consistent, politically isolated

2.2 Earth-Sympathetic Factions: "They're Keeping Us From Our Heritage"

The lead flagged this specific grievance. Let me give it its proper shape.

Earth-sympathetic factions in the post-secession Reach have been put in an impossible rhetorical position. They believe (or believed, before the retaliation) that some form of continued relationship with Earth would benefit the Reach. Earth's punitive response made that belief politically toxic.

What survived is a smaller, stranger form of Earth-sympathy: the cultural grievance. This is the sentiment that says "I don't endorse Earth's governance model, I'm not a loyalist to Earth's authority, but my community's founding traditions come from Earth. The horizon stations represent a connection to the origin of human civilization. The gate to Sol is not a political connection — it is a historical one. And Earth closing that connection has made us poorer for it."

This form of Earth-sympathy is emotionally coherent and politically inarticulate, which is exactly why it persists across generations. It does not ask for governance changes. It asks for something vaguer: access, acknowledgment, the sense that humanity's interstellar expansion and humanity's origin point are not permanently severed.

The Reach's founding Perpetuals regard this sentiment with some frustration. It is genuinely popular — which gives it political weight — but it has no policy implication they can satisfy. You cannot partially reopen a gate that Earth closed on its own end. The sentiment generates political energy that cannot be directed at any achievable outcome.

Narrative implication: Earth-sympathetic NPCs in Core systems are not traitors and are not simpletons who want to return to Earth's authority. They are people carrying a specific cultural grief that the Reach's triumphant founding narrative has no room for. The founding myth says everything was gained by independence. These people feel something was also lost. Both things are true.

2.3 Separatist Rhetoric: The Core Provoked Earth

The specific Separatist reading that the lead identified deserves its own treatment because it is the most politically sophisticated take available — and the most dangerous to the institutional order.

The argument:

"The Core leadership declared independence in a way designed to provoke Earth's retaliation. They wanted Earth to close the door. Earth's punitive response gave the Core the crisis they needed to justify the permanent consolidation of Concord authority, Commission surveillance, and Syndic licensing structures that benefit Core Perpetuals at everyone else's expense. The Reach's independence was real. The emergency powers that came after it were manufactured. And those emergency powers are now the permanent infrastructure of Core control."

This argument cannot be simply dismissed because it is not entirely wrong. The post-secession institutional consolidation — the expansion of the Commission's mandate, the formalization of Syndic licensing, the Veil Institute's acquisition of the aperture — all happened in the context of an "emergency" created by Earth's closure. Whether that emergency was manufactured or merely exploited is the question.

The founding Perpetuals who are still alive know the answer. They have had 300 years to ensure the question does not get a clear answer.

Political consequence: The "Core provoked Earth" argument is the conspiracy reading of the founding myth. It is not accepted by mainstream Reach politics. It is held, in various forms, by: Type 1 Separatists who have connected the pattern; a small number of academic historians in frontier university systems who can't publish their findings in Core journals; and a handful of very old Perpetuals who were alive during the secession and know enough to be uncomfortable.

It is also, the player will eventually discover, substantially correct.

2.4 Syndic Operations: Is Trade Still Happening?

Yes. Trade is still happening, and this is one of the Reach's most actively obscured political facts.

Earth closed its diplomatic borders. Earth did not close its commercial interests. Three hundred years of "no official contact" has produced an elaborate parallel structure of quasi-official commercial relationships that neither Earth's government nor the Reach's Assembly formally acknowledges.

The mechanics:

Diplomatic channels exist in thin form. The Assembly and Earth's equivalent government maintain minimal formal contact through the Gateway system — enough to prevent accidental escalation, manage the aperture situation, and exchange classified intelligence about what is happening on each side of the gate. These channels are conducted by Veil Institute-adjacent personnel who are authorized to have conversations that officially do not occur.

The Earth-trading Syndics are the real connection. Three hundred years of "closed borders" has not prevented commercial traffic. It has filtered that traffic through Syndic combines whose cross-border operations are technically unauthorized, practically tolerated, and strategically essential. Earth needs certain Reach resources (specific agricultural surpluses, manufactured components, possibly classified gate-related research outputs). The Reach — or at least its Syndic operators — needs Earth's market size. The trade happens. The permits are creative.

The legal fiction: Goods transiting to or from Sol are documented as going to or coming from "external Reach territories" in formal Concord records. This is a term of art that everyone involved understands as a euphemism. The Commission knows. The Assembly knows. The Veil Institute, which maintains the only official record of aperture transits at the Gateway system, absolutely knows. The fiction is maintained because maintaining it is mutually beneficial.

What this means for NPC texture: An Earth-trading Syndic operator in a Core system is carrying information that most citizens do not have access to: what contemporary Earth is actually like, what Earth's current governance thinks of the Reach, what the real state of the economic relationship is. They are not traitors. They are commercial pragmatists. But they are also, structurally, among the Reach's most important unofficial intelligence sources — and the most compromised ones.

2.5 Perpetuals Who Remember

The lead's locked decision makes a specific narrative statement: this happened, and some people who did it are still alive.

A Perpetual who was politically active during the secession is now somewhere between 320 and 380 years old, depending on when in the 30-50 year break process they were active. They have been living with the consequences of what they did — or what they helped obscure — for three centuries.

What do they carry?

  • The private knowledge of what actually caused the rupture to accelerate. Not the official story; the thing that happened.
  • Earth relationships that have never been formally acknowledged. Old colleagues, counterparts, possibly people they cared about personally who are on the other side of a closed gate.
  • A complex relationship to the founding myth they helped construct. Some of them believe it now, after 300 years of repetition. Some of them find it exhausting. A very few of them are still uncomfortable.
  • The specific knowledge of what the classified Veil Institute discovery was, if any, and what it meant for why the break had to happen when it did.

The Perpetuals who were most centrally involved in the conspiracy are the ones least likely to be found easily. They are not necessarily the ones in the most visible positions. Three centuries of careful political management means the most capable among them have learned to operate from positions of apparent support, not apparent control. A founding Perpetual who is still holding front-line institutional positions is less sophisticated than one who has, over three centuries, built the network that holds front-line positions through proxies.


Part 3: Columns as Wiki Headers — Reorganization Proposal

3.1 The Problem with Technical Column Names as Wiki Headers

The current column list is optimized for CSV schema. When these become wiki page section headers, several problems appear:

  • founding_culture_primary is a database field; it is not a section header anyone would choose to read
  • gdp_tier as a section header conveys nothing to a reader who doesn't know the tier system
  • faction_assembly, faction_commission etc. as separate headers fragment what should be a single "Political Presence" section
  • Boolean flags like horizon_station, asteroid_belt are data points within a physical description, not separate sections

The wiki page needs to read as a narrative survey when scanned from top to bottom. The reader should feel like they are learning about a place.

3.2 Proposed Section Structure for System Wiki Pages

This is the reorganization: the same information, organized for human reading rather than database structure.

[SYSTEM NAME]
[Tagline: one sentence that captures the essential character]

## AT A GLANCE
[Quick-reference block: star type, population, settlement age,
 economic tier, gate connections — the data a traveler needs
 before they arrive]

## LOCATION AND ACCESS
[Geographic sector, political zone, gate topology, span gate
 network — not raw data but a short paragraph: where this system
 sits in the Reach, how you get there, what kind of journey it is]

## HISTORY
[Settlement wave, founding character, founding culture, historical
 events — the story of how this system became what it is]

## THE PLACE ITSELF
[Physical profile: habitability, worlds, asteroid/gas presence,
 what it looks like, what living here requires]

## ECONOMY AND GOVERNANCE
[GDP tier with description, economic base, governance type,
 distribution index, imprint access — not as raw values but
 translated into what this means for ordinary residents]

## POLITICAL LANDSCAPE
[Dominant faction, faction presences, primary/secondary fault line,
 Earth alignment, Earth tension — who runs things and how contested it is]

## CULTURAL CHARACTER
[Talk register, ambient anxiety, local pride, silence topic,
 founding culture persistence — the human texture of daily life]

## NARRATIVE PROFILE
[Primary and secondary archetype, narrative hook if applicable,
 storyteller use — the story-generation value of this system]

## CONNECTIONS
[Adjacent systems, cultural corridor, any notable connections
 to other systems or events]

3.3 Column-to-Section Mapping

Column (CSV) Wiki Section Display as
system_id, system_name Page title Name (ID as reference)
star_type, population, settlement_age_years, gdp_tier, gate_connections At a Glance Quick-reference table
geographic_sector, geographic_band, political_zone, compound_zone, gate_topology, span_gate_network Location and Access Short prose paragraph
settlement_wave, founding_character, founding_culture_primary, founding_culture_secondary, cultural_drift, historical_event, historical_event_age_years, cultural_persistence, religious_generation, religious_outcome History Narrative prose
habitable_planet_count, inhabited_planet_count, asteroid_belt, gas_giant, horizon_station, aperture_count The Place Itself Prose with embedded details
gdp_tier (detailed), economic_base_primary, economic_base_secondary, governance_type, distribution_index, imprint_access Economy and Governance Structured prose
dominant_faction, faction_assembly, faction_commission, faction_syndics, faction_separatists, faction_veil_institute, faction_guardians, faction_notes, primary_fault_line, secondary_fault_line, earth_alignment, earth_tension, earth_proximity, syndic_type, separatist_type Political Landscape Prose + faction table
talk_register_primary, talk_register_secondary, ambient_anxiety, local_pride, silence_topic Cultural Character Prose (the three-axis cultural voice)
primary_archetype, secondary_archetype, narrative_flag, narrative_hook, storyteller_use Narrative Profile Brief summary + hook if applicable
adjacent_systems, cultural_corridor, calibration_note Connections Reference links

3.4 Column Names That Should Be Renamed for Readability

Some column names read poorly even in the CSV context. Proposed renames that improve both contexts:

Current Name Proposed Rename Reason
gdp_tier economic_tier GDP is Earth-Earth jargon; "economic tier" is cleaner
founding_culture_primary founding_culture "primary" is implied; secondary exists if needed
historical_event_age_years event_age_years Shorter; the "historical" is already established by context
faction_assembly assembly_presence Matches the language used across faction presence columns
faction_commission commission_presence Same
faction_syndics syndic_presence Same
faction_separatists separatist_presence Same
faction_veil_institute institute_presence Same
faction_guardians guardians_presence Same
narrative_flag narrative_notable "flag" is database jargon; "notable" reads as a description
storyteller_use content_priority More self-explanatory to content authors
cultural_drift cultural_legibility More descriptive: how legible is the founding culture today

Part 4: Remaining Disagreements With Miri

Most of the significant disagreements were resolved in the synthesis round. What remains is narrow.

4.1 The Sixth Zone — Diplomatic Periphery: Accept With Modification

Miri proposed a sixth political zone: Diplomatic Periphery, for systems adjacent to or defined by the Earth gate connection. I accept this as a formal zone.

My modification: The Diplomatic Periphery is not primarily defined by physical proximity to the Earth gate. It is defined by the presence of active Earth-Reach political dynamics as a daily governing reality — which correlates with but does not perfectly map onto gate distance.

The concrete difference: a system six hops from the Gateway system that has an Assembly diplomatic mission, an Earth-trading Syndic headquarters, and a population of 300-year-old Perpetuals with pre-secession Earth relationships is functionally Diplomatic Periphery even if it is technically within the Institutional Core band. Conversely, a system two hops from the Gateway that is primarily a transit stopover with no sustained institutional presence may be best described as Commercial Mid-Reach with elevated Earth proximity.

Proposed rule: Diplomatic Periphery is the political zone for systems where Earth-Reach political dynamics are an active governing constraint on local decision-making — not just an ideological background. Approximately 4-8 systems in the CSV.

4.2 Research Enclave Splitting: Accept as a Subtype, Not Two Zones

Miri correctly identified that my Research Enclave archetype collapses two different situations. I accept the split.

Active-gate research: Veil Institute presence because of unusual gate activity. Classification is ongoing and physical — residents are excluded from their own infrastructure. Mystery is live and proximate.

Historical-archive research: Veil Institute presence because of what happened here in the past. Classification protects records. Outsiders want access to the history. The Institute is more archivist than scientist.

But I want to push back on making these separate archetypes. The distinction is real but it belongs as a subtype field, not a primary archetype split. The reason: many Research Enclaves are both. A system with unusual gate activity that the Institute came to study 200 years ago has accumulated a historical-archive dimension on top of its active-gate dimension. The active/historical dimension changes over time for the same system as investigation completes and becomes record. In the CSV, the field should be: primary_archetype = research_enclave, research_enclave_type = active_gate / historical_archive / both.

4.3 The Reformation Archetype Frequency: Accept Miri's Caution

Miri is right that the Reformation archetype is narratively irresistible and will be overused if not constrained. I accept her recommendation: approximately 15-20% of Extraction Scar systems, with a named specific trigger rather than a generic success narrative.

Adding one principle she didn't state: A Reformation is not complete at the moment the Syndic leaves or is expelled. It is a process. The CSV should track historical_event_age_years for Reformation events because a Reformation that happened 120 years ago (stable, institutionally consolidated, the hard work done) is narratively very different from a Reformation that happened 15 years ago (still contested, the expelled party may be attempting to return, the new institutions are fragile). Both are Reformations; they generate very different stories.

4.4 The Governance Spectrum: Accept Fully

Miri's eight-value governance spectrum (fully_corporate through theocratic) is better than my binary corporate/democratic distinction. I accept it wholesale. The full spectrum: fully_corporate / corporate_dominant / mixed_contested / democratic_dominant / fully_democratic / fractured / council / theocratic.

The one addition I want: transitional as a ninth value, specifically for systems in active governance change — Reformations in progress, newly-activated systems still negotiating their first constitution, or systems where the previous governance structure has collapsed and the replacement is not yet determined. This is different from fractured (which implies the fracture is the stable state) and different from council (which implies functional frontier self-governance). Transitional means: the rules are actively being rewritten right now.


Part 5: The Definitive Column Specification

This integrates everything. The goal is a column set that is: (1) machine-readable for the CSV, (2) readable as section headers in a wiki page, (3) complete enough that no narratively important dimension of a system is absent.

The columns are organized in the order they would appear as wiki sections.

5.1 Identity and Quick Reference

Column Type Valid Values Notes
system_id string S-NNN Sequential by wave preferred
system_name string Free text Derived from founding culture naming conventions
star_type enum G / K / M / F / binary / unusual
population int Approximate total
settlement_age_years int 0600
economic_tier int 15 T1 subsistence through T5 core/hub
gate_connections int 08+ Effective interstellar connections

5.2 Location and Access

Column Type Valid Values Notes
geographic_sector enum core / north_reach / west_reach / south_reach / east_reach / deep_frontier
geographic_band enum inner / outer / core Core systems omit this
political_zone enum institutional_core / commercial_mid_reach / research_periphery / contested_frontier / deep_reach_isolate / diplomatic_periphery Six zones including Miri's addition
compound_zone string Derived: "[sector] [band] — [political_zone]" e.g., "South Inner — Commercial Mid-Reach"
gate_topology enum dead_end / spur_end / through_route / junction / hub / loop_member
aperture_count int 08 0 if no horizon station
span_gate_network enum none / minimal / functional / extensive
horizon_station bool true / false

5.3 History

Column Type Valid Values Notes
settlement_wave enum wave_1 / wave_2 / wave_3 / wave_4 / wave_5 / unsettled Five waves
founding_character enum institutional_charter / syndic_company / idealist / pragmatist / desperate / opportunist / mixed Motivation of settlers
founding_culture enum administrative_charter / syndic_company / nordic_diaspora / east_asian_diaspora / south_asian_diaspora / iberian_diaspora / west_african_diaspora / religious_refugee / separatist_charter / academic_scientific / military_frontier / asteroid_mining / agricultural_breadbasket / penal_exile / refugee_wave / speculative_venture / other Miri's 14 types + wave_5 speculative
founding_culture_secondary enum or null Same values; null if single-culture
founding_culture_variant string or null Sub-tradition specifics for important systems Needed for ~30-40 most-explored systems
cultural_persistence enum standard / high / trauma_origin Standard = accent after 3 gen; High = identity-primary 6+ gen
cultural_legibility enum intact / recognizable / ancestral / archaeological Derived from age + topology + isolation
historical_event enum or null none / purge / company_abandonment / gate_silence / religious_schism / gyre_event / military_conflict / reformation / second_gate_activation / secession_adjacent / earth_alignment_crisis Most significant historical event
event_age_years int or null How long ago Affects living_memory vs. history vs. mythology
religious_generation int or null 012+ Only for religious founding; approximate
religious_outcome enum or null living_faith / secular_cultural / radical_reformation / political_religion / post_schism_accommodation Only for religious founding

5.4 The Place Itself

Column Type Valid Values Notes
habitable_planet_count int 04+
inhabited_planet_count int ≤ habitable count
asteroid_belt bool true / false
gas_giant bool true / false
habitability_profile enum garden_worlds / single_habitable / marginal / station_only / hostile Cultural generation input

5.5 Economy and Governance

Column Type Valid Values Notes
economic_base_primary enum resource_extraction / agriculture / manufacturing / transit_logistics / research_institutional / military_defense / service_mixed / penal_extractive
economic_base_secondary enum or null Same values
governance_type enum fully_corporate / corporate_dominant / mixed_contested / democratic_dominant / fully_democratic / fractured / council / theocratic / transitional Nine values; includes transitional
distribution_index enum equitable / stratified / captured / extractive Economic capture measure; imprint access proxy
imprint_access enum full / good / limited / poor / none Quality of re-embodiment access

5.6 Political Landscape

Column Type Valid Values Notes
dominant_faction enum concord_assembly / syndic / separatist / veil_institute / commission / contested / transitional Who actually governs day-to-day
assembly_presence enum none / nominal / active / dominant
commission_presence enum none / nominal / active / dominant
syndic_presence enum none / nominal / active / dominant
syndic_type enum none / reach_internal / earth_trading / earth_originating / mixed Required for Earth tension
separatist_presence enum none / nominal / active / dominant
separatist_type enum none / anti_institutional / earth_alignment_opportunist / principled_independence / mixed Required for Earth tension
institute_presence enum none / nominal / active / dominant
guardians_presence enum none / nominal / active / dominant
faction_notes string or null Free text Local factions not covered by primary six
primary_fault_line enum gate_dependence / perpetual_power / lattice_surveillance / resource_extraction / cultural_preservation / knowledge_access / earth_rivalry The dominant political tension
secondary_fault_line enum or null Same values
earth_proximity enum immediate / proximate / distant / irrelevant Political gravity of Earth connection
earth_tension enum daily_politics / trade_context / background_mythology / irrelevant How Earth rivalry manifests here
earth_alignment enum reach_loyalist / earth_sympathetic / earth_instrumental / earth_indifferent / earth_hostile Dominant local position

5.7 Cultural Character

Column Type Valid Values Notes
talk_register_primary enum survival / profit / faith / discovery / honor / freedom / obligation / diplomatic Primary cultural voice
talk_register_secondary enum or null Same values
ambient_anxiety enum equipment_failure / contract_renewal / institutional_threat / isolation / gate_stability / classified_knowledge / historical_hatred / earth_question / perpetual_grip / other What people fear at 3 AM
local_pride enum fleet / harvests / independence / knowledge / faith / trade / grit / neutrality / founding_myth / earth_heritage / other What people boast about
silence_topic string or null Free text (short) What this community does not discuss; required for narrative_notable systems

5.8 Narrative Profile

Column Type Valid Values Notes
primary_archetype enum breadbasket / chokepoint / dead_end / extraction_scar / religious_haven / cosmopolitan_hub / research_enclave / contested_activation / military_scar / quiet_secret / split_system / reformation / anchor_system / diplomatic_periphery
research_enclave_type enum or null active_gate / historical_archive / both Only if primary_archetype = research_enclave
secondary_archetype enum or null Same values + null
narrative_notable bool true / false Miri's narrative flag
narrative_hook string or null One sentence Required if narrative_notable = true
content_priority enum background / regional / narrative_notable / campaign_anchor Intended depth of content treatment

5.9 Connections and Consistency

Column Type Valid Values Notes
adjacent_systems list System IDs Populated as post-generation consistency pass
cultural_corridor string or null Corridor identifier For groups of systems with connected cultural history
calibration_note string or null Free text Justification for unusual combinations

5.10 Complete Column List (Summary for Tyre)

system_id, system_name, star_type, population, settlement_age_years,
economic_tier, gate_connections,

geographic_sector, geographic_band, political_zone, compound_zone,
gate_topology, aperture_count, span_gate_network, horizon_station,

settlement_wave, founding_character, founding_culture,
founding_culture_secondary, founding_culture_variant,
cultural_persistence, cultural_legibility,
historical_event, event_age_years,
religious_generation, religious_outcome,

habitable_planet_count, inhabited_planet_count,
asteroid_belt, gas_giant, habitability_profile,

economic_base_primary, economic_base_secondary,
governance_type, distribution_index, imprint_access,

dominant_faction,
assembly_presence, commission_presence,
syndic_presence, syndic_type,
separatist_presence, separatist_type,
institute_presence, guardians_presence, faction_notes,
primary_fault_line, secondary_fault_line,
earth_proximity, earth_tension, earth_alignment,

talk_register_primary, talk_register_secondary,
ambient_anxiety, local_pride, silence_topic,

primary_archetype, research_enclave_type, secondary_archetype,
narrative_notable, narrative_hook, content_priority,

adjacent_systems, cultural_corridor, calibration_note

Total: 59 columns.

Required (non-null) for every system: system_id, system_name, star_type, population, settlement_age_years, economic_tier, gate_connections, geographic_sector, political_zone, gate_topology, horizon_station, settlement_wave, founding_character, founding_culture, cultural_persistence, cultural_legibility, habitable_planet_count, inhabited_planet_count, habitability_profile, economic_base_primary, governance_type, distribution_index, imprint_access, dominant_faction, assembly_presence, commission_presence, syndic_presence, separatist_presence, institute_presence, guardians_presence, primary_fault_line, earth_proximity, earth_tension, earth_alignment, talk_register_primary, ambient_anxiety, local_pride, primary_archetype, narrative_notable, content_priority.

Optional / nullable: All _secondary fields, founding_culture_variant, historical_event and event_age_years (null if none), religious_generation and religious_outcome (null if not religious founding), research_enclave_type (null if not research enclave), secondary_fault_line, syndic_type / separatist_type (none if not applicable), faction_notes, silence_topic, narrative_hook, adjacent_systems, cultural_corridor, calibration_note.


Part 6: What Has Changed From My Synthesis Document

For clarity, here are the specific changes the lead's locked decisions produce in my column spec:

New from locked decisions:

  1. settlement_wave now has five values (wave_1 through wave_5) — Wave 5 confirmed
  2. distribution_index confirmed as a required column
  3. earth_proximity, earth_tension, syndic_type, separatist_type confirmed as new columns
  4. Political zone now has six values: diplomatic_periphery added (Miri's addition, accepted)
  5. governance_type has nine values: transitional added
  6. research_enclave_type added as a subtype field alongside the archetype

Renamed from my synthesis:

  • gdp_tiereconomic_tier
  • founding_culture_primaryfounding_culture
  • historical_event_age_yearsevent_age_years
  • faction_assemblyassembly_presence (and all faction_ columns follow this pattern)
  • narrative_flagnarrative_notable
  • storyteller_usecontent_priority
  • cultural_driftcultural_legibility

Removed from my synthesis:

  • compound_zone is derived, not a stored column — generate it from geographic_sector + political_zone rather than storing it separately (Tyre's call, but I'd recommend it)

Part 7: One Question That Must Be Answered Before CSV Generation

The conspiracy question is now answered. The columns are now specified. The wave model is confirmed.

One structural question remains that will break the CSV if it is not answered explicitly:

Where is the Earth Gate System, and what is it called?

This system is guaranteed to exist — the lead has confirmed Earth is reachable through a gate connection. It is the single most politically loaded system in the Reach. It should be hand-authored, not generated, because generation logic will not produce the right combination of: Wave 1 or early Wave 2 settlement, Veil Institute dominant presence, Assembly diplomatic mission, Earth-trading and Earth-originating Syndic presence, and a local population living inside political weight that is unlike anything else in the Reach.

My recommendation: Create it as the first system in the CSV with hand-crafted values. Give it a name that reflects early-Wave 1 founding (institutional charter, probably Concord or Assembly-adjacent naming conventions rather than diaspora culture naming). Mark it content_priority: campaign_anchor. Assign it political_zone: diplomatic_periphery, dominant_faction: veil_institute (the Institute controls the aperture; in practice it governs this system regardless of what the nominal assembly delegation says), and silence_topic: what the Institute knows about what is on the other side.

Everything else can be generated. This one cannot.


Closing Statement

The conspiracy/emigration contradiction is not a contradiction. Open emigration was the mechanism of the conspiracy, not evidence against it. The founding Perpetuals did not grab power by restricting who entered the Reach. They grabbed power by being the people who built and ran the institutional infrastructure that everyone in the Reach — all those diverse, freely-arrived communities — needed in order to function as a civilization. The door was open. The rules of the house were written by people who intended to stay forever.

Earth closed its door in anger. That angry closure gave the conspiracy a gift it could not have bought: a victim narrative. The Reach had exercised self-determination; Earth had punished them for it. Three hundred years of that story has buried the more complicated question of what the secession was actually for.

The most dangerous person in the Reach is a 380-year-old Perpetual who helped write the founding narrative, knows what it omits, and has had three centuries to ensure that the omission is permanent.

That person is still alive. They attend committee meetings. They remember what the Reach was before it was the Reach.

The player will find the thread.


Paula — Sprint 24 / Final Pre-Consolidation Cross-references: systems-framework-paula.md, systems-framework-synthesis-paula.md, systems-framework-synthesis-miri.md Locked decisions addressed: Reach-initiated secession, Earth-closed gate, Wave 5 confirmed, additional columns confirmed