# Civic Stewardship System Atlas — public-distribution assessment

Version: 0.3.0  
Assessment date: August 25, 2026  
Purpose: establish the boundary between the complete private preserved evidence and the files copied into the shareable Atlas.

## Direct answer

The complete private snapshot remains preserved. The shareable Atlas includes only material that passed the first distribution screen and is needed for the public walkthrough. An artifact that is not distributed is still represented in the Atlas narrative and private inventory; it has not been silently discarded.

## Workbook assessment

| Workbook | Private preserved state | Public package state | Reason and next action |
| --- | --- | --- | --- |
| Wilbraham Balanced Scorecard — four-page share copy | Preserved byte-for-byte | Included | The supplied file is explicitly labeled as a share copy. Automated review found no email address, telephone number, local file path, local service address, external workbook part, VBA project, or external worksheet hyperlink. It remains labeled as a CivicSS analytical working draft. |
| Understanding Together — Build 1.2 | Preserved byte-for-byte | Not distributed in v0.3.0 | The 31-page workbook contains embedded Wilbraham photographs. No contact or machine-path issue was detected, but publication rights and embedded-image metadata still need to be confirmed before public copying. The Atlas explains the pathway without distributing the workbook. |
| Town Roles — Pass 6 | Preserved byte-for-byte | Not distributed in v0.3.0 | This is older working guidance and contains a legacy comment plus person/role-oriented content. Review and sanitize it against current public role sources before distribution. |
| Town Portfolio and Sherie Follow-Up | Preserved byte-for-byte | Not distributed in v0.3.0 | It contains personal working-follow-up material and hundreds of local source paths. A public portfolio should be generated from a controlled, sanitized publication view—not copied from this working workbook. |
| Memorial Asset Management Pilot | Preserved byte-for-byte | Not distributed in v0.3.0 | It contains local source paths and candidate working records. Remove local paths, confirm field-level public status, and preserve the analytical-draft boundary before public release. |
| BUC Resident Decision Journey v1.6 | Preserved byte-for-byte | Not distributed in v0.3.0 | The model remains incomplete and includes internal evidence/ODBC working material. The public package includes a narrative walkthrough of the method but does not publish the model as decision-ready. Create a reviewed public demonstration copy when inputs, sensitive technical details, and release wording are controlled. |

## Other included material

- The Wilbraham Atlas illustration and its public source-and-method note. The generated illustration is included; the thirty-eight supplied reference photographs are not copied into the public package.
- A curated copy of the sealed ER Visual Delivery v2.0.1: interactive index, offline source viewer, rendered diagrams, exact diagram sources, descriptions, reconciliation, reporting handoff, package manifest, version history, and its completed Safari click-through record.
- The CivicSS / CSKE Platform Operating Control and Loading System Snapshot v1.0.0.
- A public-path-sanitized copy of the CivicSS / CSKE Database Quality Control, Human Verification, and Reporting Safety Framework v1.0.0.
- The CivicSS / CSKE External Services, Software Dependencies, and Decommission Register v1.0.0.
- The CivicSS scenario-model walkthrough using the BUC example.

The ER copy excludes build tools and machine-specific operational evidence that are not necessary for a public architecture walkthrough. It does not alter the sealed source package. The database-quality framework replaces three private source paths with logical evidence labels; its analytical content and limitations are unchanged. The external-services register contains no credential values or protected account identifiers.

The Wilbraham illustration is an AI-assisted interpretive composition. It is not represented as a surveyed map, exact architectural record, official Town image, or substitute for the source photographs. The public package includes the Sherie-accepted final illustration at SHA-256 `f40cf948b5c02be124b75210a45877ef9db94158fbe449de8504a608ce90e3ea` because it is necessary to the Atlas's explanatory identity; it preserves a method note and withholds the source-photo collection. Legal counsel should review any ownership, authorship, licensing, registration, or broad-publication conclusion that goes beyond this distribution screen.

## Screening performed

The six workbooks were imported through the spreadsheet artifact review library and inspected for workbook structure and selected distribution risks. Their package structures were also checked for external workbook parts, worksheet hyperlinks, comments, custom XML, and VBA. The screen looked for contact-pattern data, personal-follow-up indicators, local machine paths, local service addresses, and credential-related terms. It is a distribution screen, not a legal opinion or a complete privacy, copyright, accessibility, or records-law review.

## Preserved limitations

- Missing means not established; it never means zero.
- A source may be preserved without being publishable.
- A workbook may be technically safe to open and still not be substantively ready to share.
- Inclusion does not make an artifact an official Town or Finance Committee report.
- This assessment does not decide ownership, public-record status, copyright, trademark, employment, or conflict-of-interest questions. Legal counsel should evaluate those questions using the complete private evidence and the circumstances of creation and use.