Somerville Permit and License Applications Since 2014

Over 90,000 applications for permits and licenses processed by the City of Somerville since 2014. Records originate from the Inspectional Services Department and City Clerk's office via the Citizenserve application system. The dataset is refreshed daily by data.somervillema.gov.

Use Cases

• Predict application `Status` based on `Department`, `Application Type`, and `Application Date` using classification models.
• Analyze temporal trends in `Application Subtype` or `Application Category` to inform city policy and staffing.
• Geocode `Application Address` to create spatial visualizations of permit density and urban development.
• Forecast future application volumes using historical `Application Date` and `Active in [Year]` columns as time-series features.

Strengths

• Over 90,000 application records providing substantial sample size for analysis.
• Data coverage includes approximately 90% of applications processed by the city.
• Daily refresh schedule ensures current data.

Limitations

• Some applications lack `Application Date` or `Issue Date`, causing them to be filtered out in official visualizations.
• Data currently covers primarily two departments (ISD, City Clerk), not all city teams.
• Presence of multiple `Active in [Year]` flags suggests a denormalized structure that may require cleaning.

Provenance

Source

City of Somerville via Citizenserve application system.

Collection Method

One row per application submitted through the city's permit and license system.

Time Range

2014 to present.

Freshness

Refreshed daily.

Geography

City of Somerville, Massachusetts, USA.