Lake Region Construction Intelligence Powered by the Sebago Lake Contractor Index
System Architecture · Data Model · Classification Standards

Record Types & Schema

Every piece of information in this system is an instance of a defined record type. This page defines those types, their fields, and how they map to the four dimensions of the system. This is the data model that makes 25,000 pages manageable.

10 Record Types Place × Topic × Time × Entity Governs All Data Collection

Why this page is public. Publishing the schema serves two purposes. First, it makes the system's logic transparent to readers — so they understand exactly what they're looking at when they read a record. Second, it provides a stable framework for AI-assisted data collection: any future collection process, human or automated, follows these definitions exactly. The schema is the system.

The Four Dimensions

Dimension 1 — Place

Where?

Town, lake, corridor, or sub-area. Required on every record.

Dimension 2 — Topic

What category?

The record type (below). Required on every record.

Dimension 3 — Time

When?

Date or date range. Required on every record.

Dimension 4 — Entity

Who/what connected?

Related trade, contractor category, project type. Optional but preferred.

Record Types

1 · Permit Record

Source: Municipal Code Enforcement · Topic: Permit Activity

A building permit issued by a municipal code enforcement office. The most granular record type in the system. Detailed permit records — especially contractor names — often require FOAA requests.

FieldTypeNotes
TitletextBrief description of permitted work
TownselectOne of 10 covered municipalities
Permit DatedateDate issued or best available date
Permit TypeselectNew construction / addition / renovation / demolition / other
SourcetextSpecific source document or FOAA request ID
ConfidenceselectVerified / Preliminary / Pending
Contractor CategoryselectIf available from public record
NotestextAdditional context; FOAA status if applicable

Example record:

Title: Residential addition — main structure
Town: Windham
Permit Date: [Date pending FOAA]
Permit Type: Addition
Source: Windham Code Enforcement — FOAA Request #[TBD]
Confidence: Pending
Contractor Category: General Contractor
Notes: FOAA request submitted [date]. Response pending within statutory window.

2 · Planning Board Action

Source: Planning Board Agendas/Minutes · Topic: Planning Board Actions

An action taken by a municipal planning board — approval, denial, continuation, or public hearing — on a site plan, subdivision, variance, or conditional use application.

FieldTypeNotes
TitletextApplication name or brief description
TownselectMunicipality of the planning board
Meeting DatedateDate of planning board meeting
Action TypeselectSite plan / Subdivision / Variance / Conditional use / Hearing / Other
OutcomeselectApproved / Denied / Continued / Tabled / Pending
SourcetextAgenda or minutes document reference
ConfidenceselectVerified / Preliminary
Related EntitytextApplicant type, project type if in public record
NotestextConditions of approval, continuance reasons, etc.

Key notes on this record type:

Planning board minutes become public records only after they are approved at the subsequent meeting — typically one month after the meeting date. This creates an inherent publication lag that will be noted in all Planning Board Action records.

Applicant names are public record but are included in this system only when necessary to identify the project being reported. Names are not highlighted or repeated beyond what the record requires.

3 · Major Project

Source: Multiple · Topic: Major Projects

A significant development project tracked over time — from application through approval through construction. A Major Project record may aggregate multiple Permit Records and Planning Board Actions related to the same development.

FieldTypeNotes
Project NametextDescriptive name — not from marketing materials
TownselectPrimary municipality
Project TypeselectResidential / Commercial / Mixed / Infrastructure / Other
StatusselectUnder Review / Approved / Under Construction / Complete / Inactive
First RecordeddateDate project first appeared in public record
Last UpdateddateMost recent public record date
SourcestextList of source records
ConfidenceselectVerified / Preliminary
Contractor CategoryselectPrimary trade(s) involved if known
NotestextTimeline notes, status changes, public hearing results

How Major Projects are identified:

A project becomes a Major Project record when it appears in multiple planning board agenda items, involves significant permit volume, or is large enough to appear in public notices or municipal announcements. Size threshold is editorial judgment, not a fixed metric.

4 · Municipal Notice

Source: Town Websites, Legal Notices · Topic: Municipal Development

A formal notice or announcement issued by a municipality: public hearing notice, bid solicitation, ordinance amendment notice, or zoning change publication. These are public records by definition.

FieldType
Titletext
Townselect
Notice Datedate
Notice Typeselect
Sourcetext
Confidenceselect
Notestext

5 · Infrastructure Project

Source: Public Works, Municipal Bids · Topic: Infrastructure & Roads

A town-initiated infrastructure project: road improvement, bridge work, utility installation, stormwater project, or capital facility construction procured through municipal bid or public works processes.

FieldType
Project Nametext
Townselect
Infrastructure Typeselect
Statusselect
Estimated Timelinetext
Sourcetext
Confidenceselect

6 · Industry Observation

Source: General Regional Context · Topic: Industry Observations

A general market observation about the regional construction industry. Always labeled as an observation, not a verified finding. Based on public context, not proprietary data. Never presented as a market study or professional analysis.

FieldType
Observationtext
Geographic Scopeselect
Datedate
Related Tradeselect
Confidenceselect — always Preliminary
Source Contexttext

7 · Trade Demand Note

Source: General Context · Topic: Trade Demand

A specific observation about demand levels for a particular construction trade in the region. Always labeled as a preliminary observation. Not a market survey or verified demand measurement.

FieldType
Tradeselect
Demand Levelselect — Active / Moderate / Low / Unknown
Geographic Scopetext
Datedate
Basistext — always labeled as observation
Confidenceselect — always Preliminary

8 · Project Spotlight

Source: Public Records · Topic: Major Projects / Spotlights

An editorial feature providing additional context on a specific project or development trend. Always clearly labeled as editorial content and based on public records. More narrative in form than standard record types.

FieldType
Titletext
Town(s)select — multi
Datedate
Related Record Typeslinks
Contractor Categoryselect
Sourcestext
Confidenceselect

9 · Property Intelligence Note

Source: Public Records · Topic: Property Intelligence

Public records context useful for property research: permit history on a parcel, planning board history, subdivision context, shoreland classification. Not an appraisal, title search, or legal opinion. Planned for a future development phase.

FieldType
Subjecttext — no private addresses
Townselect
Record Date Rangedate range
Sourcestext
Confidenceselect
Not-Advice Statementrequired — always included

10 · Source Document

Source: Public Records · Internal Reference Type

A reference to a primary source document — a planning board agenda, a municipal annual report, an FOAA response, a public notice. Source documents are the evidence base for other record types. Not displayed as primary content but referenced in all verified records.

FieldType
Document Titletext
Townselect
Document Datedate
Document Typeselect
Access Methodselect — Online / Direct Contact / FOAA
Retrieved Datedate
Notestext

This schema governs all data collection. Every record added to this system — by any contributor, by any process — must conform to one of these ten record types. No record is published without a type designation, a place, a date, a source, and a confidence level. These are the minimum required fields. This discipline is what makes the archive trustworthy at scale.