data-infra
data-infra copied to clipboard
cal-itp
Cal-ITP data infrastructure
# Description This PR creates new unique intermediate tables for the two remaining batch types of Elavon transactions found in `stg_elavon__transactions` that are not yet exposed in tables New batch...
# Description As we look to ingest more NTD data tables and years, we need to modify the existing scrape_ntd.py to utilize the DOT API instead of scraping Excel files...
**Goal**: Produce a report detailing the stations by date and route with the highest number of CCJPA passengers on board (see attached mockup excel file). **Datasets Used:** Payments - CCJPA/mart_payments/Fct...
SBMTD has a question about Metabase data: When I look at the number of unique riders receiving adjusted price rides, grouped by month, I know the time based cap is...
# Description Simple docs edit to add reminders and links to mermaid in both the portfolio and docs contribution sections. Resolves #\[issue\] ## Type of change - [ ] Bug...
## User story / feature request Requesting the addition of a new column to [`dim_gtfs_dataset`](https://console.cloud.google.com/bigquery?project=cal-itp-data-infra&pli=1&ws=!1m5!1m4!4m3!1scal-itp-data-infra!2smart_transit_database!3sdim_gtfs_datasets), that marks non-public feeds that we don't want to be published to the [open data...
i. I’m getting blanks in ‘card scheme’ within ‘FCT Payments Rides V2’– see below. Is this test data? There isn’t a specific time for the blanks – which are scattered...
From Rebel: Is it a feature or a bug that the "Fct Elavon Transactions" table only has batch type B and D transactions? I see that there are 4 other...