# Source Drift Review - 22 W Main Street, Ione, CA 95640

- Generated at: `2026-07-12T06:08:15.202091+00:00`
- Resolution: `manual_compare_before_merge`
- Approval gate: `manual_compare_required`
- Policy: `review-only per-property source-drift packet; publishing does not move, trash, delete, upload, or pull Dropbox files`
- Property page: https://properties.earlco.in/properties/22-w-main-street-ione-ca-95640.html

## Decision Required

Compare local-only and API-only rows for this property/root, then choose the source of truth before uploading, pulling, archiving, or moving files.

## Counts

- Root queue rows: `1`
- Local-only detail rows: `2`
- API-only detail rows: `6`
- Same-root content drift rows: `1`

## Root Queue Rows

| Class / Category | Path / Root | Hash / Counts | Action |
| --- | --- | --- | --- |
| same_root_content_drift | /real estate/ca/22 w main street, ione, ca 95640/public/07 - p&l & owner statements/cash flow statement - 22 w main st - 22 w main street, ione, ca 95640.xlsx | 8 | compare local-only and API-only rows for this normalized property root; hashes differ, so decide source of truth before upload/pull/archive |

## Local-Only Detail Rows

| Class / Category | Path / Root | Hash / Counts | Action |
| --- | --- | --- | --- |
| same_root_content_drift_local_only | /real estate/ca/22 w main street, ione, ca 95640/public/07 - p&l & owner statements/cash flow statement - 22 w main st - 22 w main street, ione, ca 95640.xlsx | 6f7231ac2e66b98f6c4d8be58d9997673fa5cba4a9d839ab1ae07ca647be0de5 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ca/22 w main street, ione, ca 95640/public/07 - p&l & owner statements/eco systems general ledger - 22 w main st - recovered 14dbf67d - 22 w main street, ione, ca 95640.csv | 952f73d98b47af574e2bb8d4966f338875276e1b2844f658171cee3d9a86e82b | review same-root API-only rows; hashes differ, so do not auto-move |

## API-Only Detail Rows

| Class / Category | Path / Root | Hash / Counts | Action |
| --- | --- | --- | --- |
| same_root_content_drift_api_only | /real estate/ca/22 w main street, ione, ca 95640/public/07 - p&l & owner statements/cash flow statement - 22 w main st.xlsx | cfe8759886d653c7456982f1d84af1da38d28ce2eef9b345625c60412162095a | review same-root local-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_api_only | /real estate/ca/22 w main street, ione, ca 95640/public/07 - p&l & owner statements/eco systems general ledger - 22 w main st.csv | 005f4ec16d1e20cff95952feb363fa9fd0c4138e1926a8748049165dd9d0c591 | review same-root local-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_api_only | /real estate/ca/22 w main street, ione, ca 95640/public/07 - p&l & owner statements/statements/p&l report 2026-01 - 22 w main st - content xxh3_712f632.xlsx | 8db6fb3295b8dfc7d6049e4d09368c2669fd2506451e3edef44ff803a0e37061 | review same-root local-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_api_only | /real estate/ca/22 w main street, ione, ca 95640/public/07 - p&l & owner statements/statements/p&l report 2026-01 - 22 w main st.xlsx | e681131c418e9d0686e1e33cca408e89213b603c98581fd276bb8e45c87668a7 | review same-root local-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_api_only | /real estate/ca/22 w main street, ione, ca 95640/public/07 - p&l & owner statements/statements/p&l report 2026-02 - 22 w main st - content xxh3_2673ae2.xlsx | 6bee142aa2031389e42630b7dbf18343c10f6e03821065fa277f1863ca9b9cd5 | review same-root local-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_api_only | /real estate/ca/22 w main street, ione, ca 95640/public/07 - p&l & owner statements/statements/p&l report 2026-02 - 22 w main st.xlsx | 10a20808055a99c3091ae8b6ee9c2542d9b304d656a7b1a0726332fd60007ef1 | review same-root local-only rows; hashes differ, so do not auto-move |

## Same-Root Content Drift Rows

| Class / Category | Path / Root | Hash / Counts | Action |
| --- | --- | --- | --- |
| same normalized property/root has unmatched local-only and API-only content; review as source drift, not an automatic move | /real estate/ca/22 w main street, ione, ca 95640/public | local  / API | same normalized property/root has unmatched local-only and API-only content; review as source drift, not an automatic move |