For partners
Many organisations in Sault Ste. Marie already log incidents: BIA ambassadors, security firms, property managers, a mall, transit, shelters, libraries. Those logs never reach a public record. SooLedger takes them as a spreadsheet and counts them on the hundred-block, without naming the organisation.
No account and no software to install: a spreadsheet, sent by email.
What is published
Each row becomes one incident of its type, on its date, on a hundred-block. The block page shows the count only once three partners have rows on that block, so no single organisation's log can be read off the page. A partner is never named.
Addresses are turned into blocks and not kept. Notes and reference numbers stay private. The public sees a count on a block, a type and a date, nothing else.
How to send rows
- Email a spreadsheet.Attach a CSV or Excel file and send it from your own domain to your feed address,
feed+<token>@communityledger.ca. You get the address when you join. Mail from another domain is ignored. - Upload on your feed page.The same file, from a phone or computer. The page shows what was accepted and why any row was not.
- Send JSON from your own system.POST to
/v1/partners/<token>/incidents:{ "rows": [{ "date": "2026-09-01", "time": "14:30", "type": "theft", "location": "200 block Queen Street East", "ref": "A-1042" }] }
Download the template (CSV). The columns are below; the order does not matter.
The columns
| Column | What goes in it |
|---|---|
| date | YYYY-MM-DD, or a spreadsheet date. Required. |
| time | Optional, HH:MM. Only the six-hour band is kept: overnight, morning, afternoon or evening. |
| type | A taxonomy label, or plain words: theft, shoplifting, mischief, vandalism, graffiti, break in, assault, robbery, trespass, loitering, disturbance, encampment, weapons, drugs, needles, arson, other. |
| location | A civic address, an intersection such as “Queen St E & Bruce St”, or “200 block Queen Street East”. Turned into a hundred-block; the address is not kept. |
| notes | Optional. Private; never published. |
| ref | Optional. Your own id for the incident. Private; stops the same row being counted twice. |
| place | Optional. Where it happened: retail, restaurant/bar, street, parking, park, transit, shelter, or your own word. |
Rules: a date in the future, or older than three years, is refused. A row with a ref already on file, or the same day, place, type and time as one on file, is skipped as a duplicate. Up to 2,000 rows per file.
Walk a block
Your feed page also has a five-minute condition checklist: boarded storefronts, vacant units, graffiti, needles, broken glass, dark light fixtures, cameras, an encampment. Stand on the block and count.
The condition is shown on a block page once two different people have walked that block in 90 days. Who walked it is never published.
The privacy rules
Block level only. Counts appear once three partners have rows on a block. No names, no addresses, no notes, no reference numbers. Takedowns are honoured.
Pause or end your feed at any time; your rows are withdrawn from the counts. The privacy policy and terms have the full text.