Models

The capmetrics-etl models represent data that allows for consistent comparisons of ridership and other performance data across time, routes, and service types.

class capmetrics_etl.models.DailyRidership(**kwargs)

Estimated “daily” ridership for a type of day (weekday, Saturday, Sunday) and season.

class capmetrics_etl.models.ETLReport(**kwargs)

Captures basic metrics for an ETL job.

class capmetrics_etl.models.PerformanceDocument(**kwargs)

JSON API documents with performance metrics for system trends and individual routes.

class capmetrics_etl.models.Route(**kwargs)

A geographically semi-consistent designation for transit service.

class capmetrics_etl.models.ServiceHourRidership(**kwargs)

Estimated service hour productivity for a type of day (weekday, Saturday, Sunday) and season.

class capmetrics_etl.models.SystemRidership(**kwargs)

Estimated system-wide ridership for a (1) type of day (weekday, Saturday, Sunday) by (2) season and (3) service type.

class capmetrics_etl.models.SystemTrend(**kwargs)

Aggregates SystemRidership facts to conveniently provide a performance trend for a service type across season-based measurements.

id

An integer primary key.

service_type

A string column with names for service types.

trend

A JSON string with longitudinal ridership data.

updated_on

A timezone-aware datetime.

class capmetrics_etl.models.WeeklyPerformance(**kwargs)

Estimated weekly ridership and productivity for a season.