One file per year
The District publishes permits, offences and 311 requests as a separate file for each year rather than as one file with a date column. A ten-year window spans eleven of those files, so it is eleven queries rather than one. This product does that fan-out for you, and names any year it could not read rather than quietly leaving it out of the total.
The zoning rides on the permit
Unusually, each permit row carries the zoning district of the lot it was issued against. Most cities make you join to a separate zoning layer. It means a permit history doubles as a record of how the lot was zoned at the time.
What the categories add
Beyond the subtype there is a category column, and it carries the things that tell you about scale: TOWER CRANE, SCAFFOLDING, UNDERGROUND STORAGE TANK, HISTORIC PROPERTY. A tower crane or a scaffolding permit is a fact about the site rather than an estimate of the job, which is the only kind of signal this product carries.