import { $ as RouteAttribute, $n as GtfsFieldDefinition, $t as tripsDatedVehicleJourney, A as GtfsRealtimeAlertSeverity, An as pathways, At as VehicleLocation, B as Location, Bn as fareProducts, Bt as tripsPerformed, C as FareRule, Cn as stops, Ct as Translation, D as Frequency, Dn as routes, Dt as TripUpdate, E as FeedInfo, En as shapes, Et as TripPerformed, F as GtfsRealtimeTripScheduleRelationship, Fn as levels, Ft as GtfsScheduleTableName, G as OpsLocation, Gn as calendarDates, Gt as operators, H as LocationGroupStop, Hn as fareLegRules, Ht as stopVisits, I as GtfsRealtimeVehicleStopStatus, In as frequencies, It as index_d_exports, J as RideFeedInfo, Jn as attributions, Jt as runsPieces, K as PassengerEvent, Kn as calendar, Kt as fareTransactions, L as GtfsRealtimeWheelchairAccessible, Ln as feedInfo, Lt as vehicles, M as GtfsRealtimeDropOffPickupType, Mn as locations, Mt as VehicleTrainCar, N as GtfsRealtimeOccupancyStatus, Nn as locationGroups, Nt as GtfsDatabase, O as GtfsRealtimeAlertCause, On as routeNetworks, Ot as TripsDatedVehicleJourney, P as GtfsRealtimeStopTimeScheduleRelationship, Pn as locationGroupStops, Pt as GtfsFileBackedTableName, Q as Route, Qn as GtfsEnumerationValue, Qt as deadheadTimes, R as GtfsTableRow, Rn as fareTransferRules, Rt as vehicleTrainCars, S as FareProduct, Sn as timeframes, St as Transfer, T as FareTransferRule, Tn as stopAreas, Tt as TripCapacity, U as Network, Un as fareLegJoinRules, Ut as stationActivities, V as LocationGroup, Vn as fareMedia, Vt as trainCars, W as Operator, Wn as fareAttributes, Wt as passengerEvents, X as RiderTrip, Xn as agency, Xt as opsLocations, Y as RiderCategory, Yn as areas, Yt as runEvents, Z as Ridership, Zn as GtfsDatabaseFromTables, Zt as deadheads, _ as Direction, _n as serviceAlerts, _t as TimetableNoteScope, a as gtfsScheduleReferenceRevision, an as tripCapacity, ar as GtfsQuery, at as ServiceAlertRow, b as FareLegRule, bn as translations, bt as TimetableStopOrder, c as Attribution, cn as rideFeedInfo, cr as GtfsRow, ct as Stop, d as Calendar, dn as routeAttributes, dr as GtfsStoredRow, dt as StopTime, en as timetables, er as GtfsFieldKind, et as RouteNetwork, f as CalendarAttribute, fn as directions, fr as GtfsTableDefinition, ft as StopTimeUpdate, g as Device, gn as stopTimeUpdates, gr as gtfsNamespaces, gt as TimetableNote, h as DeadheadTime, hn as tripUpdates, hr as defineGtfsTable, ht as Timetable, i as gtfsManifest, in as timetableNotes, ir as GtfsPresence, it as ServiceAlertInformedEntity, j as GtfsRealtimeCongestionLevel, jn as networks, jt as VehiclePosition, k as GtfsRealtimeAlertEffect, kn as riderCategories, kt as Vehicle, l as BoardAlight, ln as boardAlight, lr as GtfsSemanticConstraint, lt as StopArea, m as Deadhead, mn as vehiclePositions, mr as GtfsValuePresence, mt as Timeframe, n as GtfsManifestEntry, nn as timetablePages, nr as GtfsInsert, nt as RunPiece, o as Agency, on as ridership, or as GtfsRangeConstraint, ot as Shape, p as CalendarDate, pn as calendarAttributes, pr as GtfsTableName, pt as StopVisit, q as Pathway, qn as bookingRules, qt as devices, r as gtfsJoins, rn as timetableNotesReferences, rr as GtfsNamespace, rt as ServiceAlert, s as Area, sn as riderTrip, sr as GtfsReference, st as StationActivity, t as GtfsJoinDefinition, tn as timetableStopOrder, tr as GtfsFieldOptions, tt as RunEvent, u as BookingRule, un as stopAttributes, ur as GtfsStorageDefinition, ut as StopAttribute, v as FareAttribute, vn as serviceAlertInformedEntities, vt as TimetableNotesReference, w as FareTransaction, wn as stopTimes, wt as Trip, x as FareMedia, xn as transfers, xt as TrainCar, y as FareLegJoinRule, yn as trips, yt as TimetablePage, z as Level, zn as fareRules, zt as vehicleLocations } from "./index-DgxrDgyc.js"; import { Options } from "csv-parse"; import Database$1, { Database } from "better-sqlite3"; import { Kysely } from "kysely"; import "gtfs-realtime-bindings"; //#region src/reporting/types.d.ts /** Output threshold for a run. */ type LogLevel = 'silent' | 'error' | 'warning' | 'info'; type LogMessageLevel = Exclude; /** Receives non-progress log messages. */ type LogFunction = (message: string, level?: LogMessageLevel) => void; interface ReportingOptions { /** * Whether to print progress output. * * @deprecated Use `logLevel`. `false` maps to `warning`. */ verbose?: boolean; /** How much to print. Defaults to `info`. */ logLevel?: LogLevel; /** Optional destination for non-progress log messages. */ logFunction?: LogFunction; } //#endregion //#region src/lib/errors.d.ts declare const GtfsErrorCategory: { readonly CONFIG: 'config'; readonly DOWNLOAD: 'download'; readonly ZIP: 'zip'; readonly VALIDATION: 'validation'; readonly DATABASE: 'database'; readonly PARSE: 'parse'; readonly QUERY: 'query'; readonly INTERNAL: 'internal'; }; type GtfsErrorCategory = (typeof GtfsErrorCategory)[keyof typeof GtfsErrorCategory]; /** * Error codes are a public API contract and must remain stable across * minor/patch releases. */ declare const GtfsErrorCode: { readonly GTFS_DOWNLOAD_HTTP: 'GTFS_DOWNLOAD_HTTP'; readonly GTFS_DOWNLOAD_FAILED: 'GTFS_DOWNLOAD_FAILED'; readonly GTFS_ZIP_INVALID: 'GTFS_ZIP_INVALID'; readonly GTFS_REQUIRED_FIELD_MISSING: 'GTFS_REQUIRED_FIELD_MISSING'; readonly GTFS_INVALID_DATE: 'GTFS_INVALID_DATE'; readonly GTFS_CONFIG_INVALID: 'GTFS_CONFIG_INVALID'; readonly GTFS_CONFIG_FILE_NOT_FOUND: 'GTFS_CONFIG_FILE_NOT_FOUND'; readonly GTFS_CONFIG_PARSE_FAILED: 'GTFS_CONFIG_PARSE_FAILED'; readonly DB_OPEN_FAILED: 'DB_OPEN_FAILED'; readonly GTFS_DB_OPERATION_FAILED: 'GTFS_DB_OPERATION_FAILED'; readonly GTFS_JSON_INVALID: 'GTFS_JSON_INVALID'; readonly GTFS_UNSUPPORTED_FILE_TYPE: 'GTFS_UNSUPPORTED_FILE_TYPE'; readonly GTFS_CSV_PARSE_FAILED: 'GTFS_CSV_PARSE_FAILED'; readonly GTFS_QUERY_INVALID: 'GTFS_QUERY_INVALID'; }; type GtfsErrorCode = (typeof GtfsErrorCode)[keyof typeof GtfsErrorCode]; declare const GtfsWarningCode: { readonly GTFS_DUPLICATE_PRIMARY_KEY: 'GTFS_DUPLICATE_PRIMARY_KEY'; }; type GtfsWarningCode = (typeof GtfsWarningCode)[keyof typeof GtfsWarningCode]; interface GtfsWarning { code: GtfsWarningCode; message: string; details?: Record; } interface ImportReport { errors: GtfsError[]; warnings: GtfsWarning[]; errorCountsByCode: Partial>; warningCountsByCode: Partial>; } interface GtfsErrorOptions { code: GtfsErrorCode; category: GtfsErrorCategory; isOperational?: boolean; statusCode?: number; details?: Record; cause?: unknown; } declare class GtfsError extends Error { code: GtfsErrorCode; category: GtfsErrorCategory; isOperational: boolean; statusCode?: number; details?: Record; constructor(message: string, options: GtfsErrorOptions); } declare function isGtfsError(error: unknown): error is GtfsError; declare function isGtfsValidationError(error: unknown): error is GtfsError; declare function formatGtfsError(error: unknown, options?: { verbosity: 'user' | 'developer'; }): string; //#endregion //#region src/lib/database-dialects.d.ts type GtfsDatabaseDialect = 'mysql' | 'postgres' | 'sqlite'; //#endregion //#region src/lib/kysely-gtfs-writer.d.ts type KyselyImportDialect = GtfsDatabaseDialect; /** Options for importing static GTFS into a caller-owned Kysely database. */ interface KyselyImportOptions { /** Caller-owned Kysely instance. */ db: Kysely; /** Kysely SQL dialect. */ dialect: KyselyImportDialect; /** * Drop and recreate GTFS tables and indexes. * * @defaultValue true */ manageSchema?: boolean; /** Write node-GTFS-generated columns. Defaults to `manageSchema`. */ includeNodeGtfsExtras?: boolean; } //#endregion //#region src/types/config.d.ts interface SqliteConnectionOptions { /** Existing synchronous SQLite connection. */ db?: Database; /** SQLite database path. Defaults to an in-memory database. */ sqlitePath?: string; } interface GtfsRealtimeEndpoint { url: string; headers?: Readonly>; } interface GtfsFeedOptions { /** File-backed tables to exclude from this feed. */ exclude?: readonly GtfsFileBackedTableName[]; /** HTTP headers used when downloading the static feed. */ headers?: Readonly>; realtimeAlerts?: GtfsRealtimeEndpoint; realtimeTripUpdates?: GtfsRealtimeEndpoint; realtimeVehiclePositions?: GtfsRealtimeEndpoint; /** Prefix applied to identifiers while merging feeds. */ prefix?: string; fillEmptyAgencyId?: boolean; agencyId?: string; } type StaticGtfsSource = { url: string; path?: never; } | { path: string; url?: never; }; /** One static GTFS feed and its optional Realtime endpoints. */ type GtfsFeedConfig = GtfsFeedOptions & StaticGtfsSource; /** One set of GTFS-Realtime endpoints. A static source is not required. */ interface GtfsRealtimeFeedConfig { realtimeAlerts?: GtfsRealtimeEndpoint; realtimeTripUpdates?: GtfsRealtimeEndpoint; realtimeVehiclePositions?: GtfsRealtimeEndpoint; prefix?: string; } interface DownloadOptions { /** Download timeout in milliseconds. Defaults to 30000. */ downloadTimeout?: number; } interface ImportBehaviorOptions { csvOptions?: Options; ignoreDuplicates?: boolean; ignoreErrors?: boolean; includeImportReport?: boolean; } /** Database-independent static GTFS import configuration. */ interface GtfsImportConfig extends DownloadOptions, ImportBehaviorOptions, ReportingOptions { agencies: readonly GtfsFeedConfig[]; /** Realtime row lifetime in seconds. Defaults to 0. */ gtfsRealtimeExpirationSeconds?: number; } /** Static GTFS import configuration for the built-in SQLite writer. */ interface GtfsSqliteImportConfig extends GtfsImportConfig, SqliteConnectionOptions {} /** Configuration for exporting an existing SQLite GTFS database. */ interface GtfsExportConfig extends SqliteConnectionOptions, ReportingOptions { exportPath?: string; } /** Configuration for refreshing GTFS-Realtime data in SQLite. */ interface GtfsRealtimeConfig extends SqliteConnectionOptions, DownloadOptions, ReportingOptions { agencies: readonly GtfsRealtimeFeedConfig[]; gtfsRealtimeExpirationSeconds?: number; ignoreErrors?: boolean; } type ImportConfigWithReport = GtfsImportConfig & { includeImportReport: true; }; type SqliteImportConfigWithReport = GtfsSqliteImportConfig & { includeImportReport: true; }; //#endregion //#region src/lib/import-gtfs.d.ts /** Imports GTFS into SQLite. */ declare function importGtfs(initialConfig: GtfsSqliteImportConfig & { includeImportReport: true; }): Promise; declare function importGtfs(initialConfig: GtfsSqliteImportConfig & { includeImportReport?: false | undefined; }): Promise; declare function importGtfs(initialConfig: GtfsSqliteImportConfig): Promise; /** Imports static GTFS through a caller-owned Kysely instance. */ declare function importGtfsToKysely(initialConfig: GtfsImportConfig & { includeImportReport: true; }, databaseOptions: KyselyImportOptions): Promise; declare function importGtfsToKysely(initialConfig: GtfsImportConfig & { includeImportReport?: false | undefined; }, databaseOptions: KyselyImportOptions): Promise; declare function importGtfsToKysely(initialConfig: GtfsImportConfig, databaseOptions: KyselyImportOptions): Promise; //#endregion //#region src/lib/import-gtfs-realtime.d.ts /** * Main function to update GTFS Realtime data */ declare function updateGtfsRealtime(initialConfig: GtfsRealtimeConfig): Promise; //#endregion //#region src/lib/export.d.ts declare const exportGtfs: (initialConfig: GtfsExportConfig) => Promise; //#endregion //#region src/lib/sqlite-db.d.ts declare function openDb(config?: { db?: Database$1.Database; sqlitePath?: string; } | null): Database$1.Database; declare function closeDb(db?: Database$1.Database | null): void; declare function deleteDb(db?: Database$1.Database | null): void; //#endregion //#region src/types/query.d.ts type QueryScalar = string | number | bigint | boolean | null | undefined; type DynamicQuery = Record; type RowQueryScalar = Extract | null | undefined; type RowQuery = Partial<{ [Field in Extract]: RowQueryScalar | readonly RowQueryScalar[]; }>; type SortDirection = 'ASC' | 'DESC'; type RowOrderBy = readonly (readonly [Extract, SortDirection])[]; type SelectedRow = [Fields] extends [never] ? Row : Pick; interface SqliteQueryOptions { db?: Database; } interface StopQueryOptions extends SqliteQueryOptions { bounding_box_side_m?: number; } type AdvancedQueryJoinType = 'INNER' | 'LEFT' | 'LEFT OUTER' | 'CROSS'; interface AdvancedQueryJoin { type?: AdvancedQueryJoinType; table: string; /** Raw SQL join expression. Identifiers and values are not escaped. */ on: string; } interface AdvancedQueryOptions { db?: Database; query?: DynamicQuery; fields?: readonly string[]; orderBy?: readonly (readonly [string, SortDirection])[]; join?: readonly AdvancedQueryJoin[]; } type DatabaseResultValue = string | number | bigint | Uint8Array | null; type DynamicQueryResult = Record; //#endregion //#region src/lib/advanced-query.d.ts declare function advancedQuery(table: string, advancedQueryOptions: AdvancedQueryOptions): DynamicQueryResult[]; //#endregion //#region src/lib/file-utils.d.ts /** * Prepares a directory for saving files by clearing its contents * @param {string} exportPath - Path to the directory to prepare * @returns {Promise} * @example * await prepDirectory('./output'); */ declare function prepDirectory(exportPath: string): Promise; /** * Extracts contents of a zip file to specified directory * @param {string} zipfilePath - Path to the zip file * @param {string} exportPath - Directory to extract contents to * @returns {Promise} * @throws {Error} If zip file cannot be opened or extracted * @example * await unzip('./data.zip', './extracted'); */ declare function unzip(zipfilePath: string, exportPath: string): Promise; /** * Generates a safe folder name from input string * Converts to snake_case and removes unsafe characters * @param {string} folderName - Input string to convert to folder name * @returns {string} Sanitized folder name * @example * generateFolderName('My Folder!') // returns 'my_folder' */ declare function generateFolderName(folderName: string): string; /** * Converts a tilde path to a full path * @param pathWithTilde The path to convert * @returns The full path */ declare function untildify(pathWithTilde: string): string; //#endregion //#region src/lib/gtfs/agencies.d.ts /** * Returns an array of all agencies that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getAgencies(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly agency_id: string | null; readonly agency_name: string; readonly agency_url: string; readonly agency_timezone: string; readonly agency_lang: string | null; readonly agency_phone: string | null; readonly agency_fare_url: string | null; readonly agency_email: string | null; readonly cemv_support: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/areas.d.ts /** * Returns an array of all areas that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getAreas(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly area_id: string; readonly area_name: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/attributions.d.ts /** * Returns an array of all attributions that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getAttributions(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly attribution_id: string | null; readonly agency_id: string | null; readonly route_id: string | null; readonly trip_id: string | null; readonly organization_name: string; readonly is_producer: number | null; readonly is_operator: number | null; readonly is_authority: number | null; readonly attribution_url: string | null; readonly attribution_email: string | null; readonly attribution_phone: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/booking-rules.d.ts /** * Returns an array of all booking rules that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getBookingRules(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly booking_rule_id: string; readonly booking_type: number; readonly prior_notice_duration_min: number | null; readonly prior_notice_duration_max: number | null; readonly prior_notice_last_day: number | null; readonly prior_notice_last_time: string | null; readonly prior_notice_start_day: number | null; readonly prior_notice_start_time: string | null; readonly prior_notice_service_id: string | null; readonly message: string | null; readonly pickup_message: string | null; readonly drop_off_message: string | null; readonly phone_number: string | null; readonly info_url: string | null; readonly booking_url: string | null; } & { readonly prior_notice_last_timestamp: number | null; readonly prior_notice_start_timestamp: number | null; }, Fields>[]; //#endregion //#region src/lib/gtfs/calendars.d.ts /** * Returns an array of calendars that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getCalendars(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly service_id: string; readonly monday: number; readonly tuesday: number; readonly wednesday: number; readonly thursday: number; readonly friday: number; readonly saturday: number; readonly sunday: number; readonly start_date: number; readonly end_date: number; } & {}, Fields>[]; /** * Returns an array of service_ids that are active on the given date. * @param date Date in `YYYYMMDD` format * @param options Query options, including the database to read from * @returns Service IDs running on that date, combining the weekday pattern in * calendar.txt with the exceptions in calendar_dates.txt */ declare function getServiceIdsByDate(date: number, options?: SqliteQueryOptions): string[]; //#endregion //#region src/lib/gtfs/calendar-dates.d.ts /** * Returns an array of calendarDates that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getCalendarDates(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly service_id: string; readonly date: number; readonly exception_type: number; readonly holiday_name: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/fare-attributes.d.ts /** * Returns an array of all fare attributes that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getFareAttributes(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly fare_id: string; readonly price: number; readonly currency_type: string; readonly payment_method: number; readonly transfers: number | null; readonly agency_id: string | null; readonly transfer_duration: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/fare-leg-join-rules.d.ts /** * Returns an array of all fare leg join rules that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getFareLegJoinRules(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly from_network_id: string; readonly to_network_id: string; readonly from_stop_id: string | null; readonly to_stop_id: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/fare-leg-rules.d.ts /** * Returns an array of all fare leg rules that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getFareLegRules(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly leg_group_id: string | null; readonly network_id: string | null; readonly from_area_id: string | null; readonly to_area_id: string | null; readonly from_timeframe_group_id: string | null; readonly to_timeframe_group_id: string | null; readonly fare_product_id: string; readonly rule_priority: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/fare-media.d.ts /** * Returns an array of all fare media that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getFareMedia(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly fare_media_id: string; readonly fare_media_name: string | null; readonly fare_media_type: number; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/fare-products.d.ts /** * Returns an array of all fare products that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getFareProducts(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly fare_product_id: string; readonly rider_category_id: string | null; readonly fare_product_name: string | null; readonly fare_media_id: string | null; readonly amount: number; readonly currency: string; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/fare-rules.d.ts /** * Returns an array of all fare rules that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getFareRules(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly fare_id: string; readonly route_id: string | null; readonly origin_id: string | null; readonly destination_id: string | null; readonly contains_id: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/fare-transfer-rules.d.ts /** * Returns an array of all fare transfer rules that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getFareTransferRules(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly from_leg_group_id: string | null; readonly to_leg_group_id: string | null; readonly transfer_count: number | null; readonly duration_limit: number | null; readonly duration_limit_type: number | null; readonly fare_transfer_type: number; readonly fare_product_id: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/feed-info.d.ts /** * Returns an array of all feed info that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getFeedInfo(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly feed_publisher_name: string; readonly feed_publisher_url: string; readonly feed_lang: string; readonly default_lang: string | null; readonly feed_start_date: number | null; readonly feed_end_date: number | null; readonly feed_version: string | null; readonly feed_contact_email: string | null; readonly feed_contact_url: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/frequencies.d.ts /** * Returns an array of all frequencies that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getFrequencies(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly trip_id: string; readonly start_time: string; readonly end_time: string; readonly headway_secs: number; readonly exact_times: number | null; } & { readonly end_timestamp: number; readonly start_timestamp: number; }, Fields>[]; //#endregion //#region src/lib/gtfs/levels.d.ts /** * Returns an array of all levels that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getLevels(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly level_id: string; readonly level_index: number; readonly level_name: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/location-group-stops.d.ts /** * Returns an array of all location group stops that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getLocationGroupStops(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly location_group_id: string; readonly stop_id: string; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/location-groups.d.ts /** * Returns an array of all location groups that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getLocationGroups(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly location_group_id: string; readonly location_group_name: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/locations.d.ts /** * Returns an array of all locations that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getLocations(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly geojson: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/networks.d.ts /** * Returns an array of all networks that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getNetworks(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly network_id: string; readonly network_name: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/pathways.d.ts /** * Returns an array of all pathways that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getPathways(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly pathway_id: string; readonly from_stop_id: string; readonly to_stop_id: string; readonly pathway_mode: number; readonly is_bidirectional: number; readonly length: number | null; readonly traversal_time: number | null; readonly stair_count: number | null; readonly max_slope: number | null; readonly min_width: number | null; readonly signposted_as: string | null; readonly reversed_signposted_as: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/rider-categories.d.ts /** * Returns an array of all rider categories that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getRiderCategories(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly rider_category_id: string; readonly rider_category_name: string; readonly is_default_fare_category: number | null; readonly eligibility_url: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/route-networks.d.ts /** * Returns an array of all route_networks that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getRouteNetworks(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly network_id: string; readonly route_id: string; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/routes.d.ts /** * Returns an array of routes that match the query parameters. A `stop_id` * query parameter may be passed to find all routes that contain that stop. * A `service_id` query parameter may be passed to limit routes to specific * calendars. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getRoutes(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly route_id: string; readonly agency_id: string | null; readonly route_short_name: string | null; readonly route_long_name: string | null; readonly route_desc: string | null; readonly route_type: number; readonly route_url: string | null; readonly route_color: string | null; readonly route_text_color: string | null; readonly route_sort_order: number | null; readonly continuous_pickup: number | null; readonly continuous_drop_off: number | null; readonly network_id: string | null; readonly cemv_support: number | null; } & {}, Fields>[]; //#endregion //#region node_modules/.pnpm/@types+geojson@7946.0.16/node_modules/@types/geojson/index.d.ts /** * The value values for the "type" property of GeoJSON Objects. * https://tools.ietf.org/html/rfc7946#section-1.4 */ type GeoJsonTypes = GeoJSON["type"]; /** * Bounding box * https://tools.ietf.org/html/rfc7946#section-5 */ type BBox = [number, number, number, number] | [number, number, number, number, number, number]; /** * A Position is an array of coordinates. * https://tools.ietf.org/html/rfc7946#section-3.1.1 * Array should contain between two and three elements. * The previous GeoJSON specification allowed more elements (e.g., which could be used to represent M values), * but the current specification only allows X, Y, and (optionally) Z to be defined. * * Note: the type will not be narrowed down to `[number, number] | [number, number, number]` due to * marginal benefits and the large impact of breaking change. * * See previous discussions on the type narrowing: * - {@link https://github.com/DefinitelyTyped/DefinitelyTyped/pull/21590|Nov 2017} * - {@link https://github.com/DefinitelyTyped/DefinitelyTyped/discussions/67773|Dec 2023} * - {@link https://github.com/DefinitelyTyped/DefinitelyTyped/discussions/71441| Dec 2024} * * One can use a * {@link https://www.typescriptlang.org/docs/handbook/2/narrowing.html#using-type-predicates|user-defined type guard that returns a type predicate} * to determine if a position is a 2D or 3D position. * * @example * import type { Position } from 'geojson'; * * type StrictPosition = [x: number, y: number] | [x: number, y: number, z: number] * * function isStrictPosition(position: Position): position is StrictPosition { * return position.length === 2 || position.length === 3 * }; * * let position: Position = [-116.91, 45.54]; * * let x: number; * let y: number; * let z: number | undefined; * * if (isStrictPosition(position)) { * // `tsc` would throw an error if we tried to destructure a fourth parameter * [x, y, z] = position; * } else { * throw new TypeError("Position is not a 2D or 3D point"); * } */ type Position = number[]; /** * The base GeoJSON object. * https://tools.ietf.org/html/rfc7946#section-3 * The GeoJSON specification also allows foreign members * (https://tools.ietf.org/html/rfc7946#section-6.1) * Developers should use "&" type in TypeScript or extend the interface * to add these foreign members. */ interface GeoJsonObject { // Don't include foreign members directly into this type def. // in order to preserve type safety. // [key: string]: any; /** * Specifies the type of GeoJSON object. */ type: GeoJsonTypes; /** * Bounding box of the coordinate range of the object's Geometries, Features, or Feature Collections. * The value of the bbox member is an array of length 2*n where n is the number of dimensions * represented in the contained geometries, with all axes of the most southwesterly point * followed by all axes of the more northeasterly point. * The axes order of a bbox follows the axes order of geometries. * https://tools.ietf.org/html/rfc7946#section-5 */ bbox?: BBox | undefined; } /** * Union of GeoJSON objects. */ type GeoJSON = G | Feature | FeatureCollection; /** * Geometry object. * https://tools.ietf.org/html/rfc7946#section-3 */ type Geometry = Point | MultiPoint | LineString | MultiLineString | Polygon | MultiPolygon | GeometryCollection; /** * Point geometry object. * https://tools.ietf.org/html/rfc7946#section-3.1.2 */ interface Point extends GeoJsonObject { type: "Point"; coordinates: Position; } /** * MultiPoint geometry object. * https://tools.ietf.org/html/rfc7946#section-3.1.3 */ interface MultiPoint extends GeoJsonObject { type: "MultiPoint"; coordinates: Position[]; } /** * LineString geometry object. * https://tools.ietf.org/html/rfc7946#section-3.1.4 */ interface LineString extends GeoJsonObject { type: "LineString"; coordinates: Position[]; } /** * MultiLineString geometry object. * https://tools.ietf.org/html/rfc7946#section-3.1.5 */ interface MultiLineString extends GeoJsonObject { type: "MultiLineString"; coordinates: Position[][]; } /** * Polygon geometry object. * https://tools.ietf.org/html/rfc7946#section-3.1.6 */ interface Polygon extends GeoJsonObject { type: "Polygon"; coordinates: Position[][]; } /** * MultiPolygon geometry object. * https://tools.ietf.org/html/rfc7946#section-3.1.7 */ interface MultiPolygon extends GeoJsonObject { type: "MultiPolygon"; coordinates: Position[][][]; } /** * Geometry Collection * https://tools.ietf.org/html/rfc7946#section-3.1.8 */ interface GeometryCollection extends GeoJsonObject { type: "GeometryCollection"; geometries: G[]; } type GeoJsonProperties = { [name: string]: any; } | null; /** * A feature object which contains a geometry and associated properties. * https://tools.ietf.org/html/rfc7946#section-3.2 */ interface Feature extends GeoJsonObject { type: "Feature"; /** * The feature's geometry */ geometry: G; /** * A value that uniquely identifies this feature in a * https://tools.ietf.org/html/rfc7946#section-3.2. */ id?: string | number | undefined; /** * Properties associated with this feature. */ properties: P; } /** * A collection of feature objects. * https://tools.ietf.org/html/rfc7946#section-3.3 */ interface FeatureCollection extends GeoJsonObject { type: "FeatureCollection"; features: Array>; } //#endregion //#region src/lib/gtfs/shapes.d.ts /** * Returns array of shapes that match the query parameters. A `route_id` query * parameter may be passed to find all shapes for a route. A `trip_id` query * parameter may be passed to find all shapes for a trip. A `direction_id` * query parameter may be passed to find all shapes for a direction. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getShapes(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly shape_id: string; readonly shape_pt_lat: number; readonly shape_pt_lon: number; readonly shape_pt_sequence: number; readonly shape_dist_traveled: number | null; } & {}, Fields>[]; /** * Returns geoJSON of the shapes that match the query parameters. A `route_id` * query parameter may be passed to find all shapes for a route. A `trip_id` * query parameter may be passed to find all shapes for a trip. A * `direction_id` query parameter may be passed to find all shapes for a * direction. * @param query Column values to match, as single values or arrays * @param options Query options, including the database to read from * @returns A GeoJSON FeatureCollection with one feature per route, carrying * the route's attributes and agency name. Routes with no shapes are * omitted */ declare function getShapesAsGeoJSON(query?: RowQuery, options?: SqliteQueryOptions): FeatureCollection; //#endregion //#region src/lib/gtfs/stop-areas.d.ts /** * Returns an array of all stop areas that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getStopAreas(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly area_id: string; readonly stop_id: string; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/stop-times.d.ts /** * Returns an array of stoptimes that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getStoptimes(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly trip_id: string; readonly arrival_time: string | null; readonly departure_time: string | null; readonly location_group_id: string | null; readonly location_id: string | null; readonly stop_id: string | null; readonly stop_sequence: number; readonly stop_headsign: string | null; readonly start_pickup_drop_off_window: string | null; readonly end_pickup_drop_off_window: string | null; readonly pickup_type: number | null; readonly drop_off_type: number | null; readonly continuous_pickup: number | null; readonly continuous_drop_off: number | null; readonly shape_dist_traveled: number | null; readonly timepoint: number | null; readonly pickup_booking_rule_id: string | null; readonly drop_off_booking_rule_id: string | null; } & { readonly arrival_timestamp: number | null; readonly departure_timestamp: number | null; readonly end_pickup_drop_off_window_timestamp: number | null; readonly start_pickup_drop_off_window_timestamp: number | null; }, Fields>[]; //#endregion //#region src/lib/gtfs/stops.d.ts type StopQuery = RowQuery; /** * Returns an array of stops that match the query parameters. A `route_id` * query parameter may be passed to find all stops for a route. A `trip_id` * query parameter may be passed to find all stops for a trip. A * `direction_id` query parameter may be passed to find all stops for a * direction. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from and * `bounding_box_side_m` to search a box centred on * `stop_lat`/`stop_lon` * @returns Matching rows, containing only `fields` when it is not empty. * Sorted nearest-first when `bounding_box_side_m` is set and * `orderBy` is empty */ declare function getStops(query?: StopQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: StopQueryOptions): SelectedRow<{ readonly stop_id: string; readonly stop_code: string | null; readonly stop_name: string | null; readonly tts_stop_name: string | null; readonly stop_desc: string | null; readonly stop_lat: number | null; readonly stop_lon: number | null; readonly zone_id: string | null; readonly stop_url: string | null; readonly location_type: number | null; readonly parent_station: string | null; readonly stop_timezone: string | null; readonly wheelchair_boarding: number | null; readonly level_id: string | null; readonly platform_code: string | null; readonly stop_access: number | null; } & {}, Fields>[]; /** * Returns geoJSON with stops. A `route_id` query parameter may be passed to * find all stops for a route. A `trip_id` query parameter may be passed to * find all stops for a trip. A `direction_id` query parameter may be passed * to find all stops for a direction. * @param query Column values to match, as single values or arrays * @param options Query options, including the database to read from * @returns A GeoJSON FeatureCollection of stop points, each carrying its stop * attributes, serving routes, and agency name. Stops belonging to no * route are omitted */ declare function getStopsAsGeoJSON(query?: StopQuery, options?: StopQueryOptions): FeatureCollection; //#endregion //#region src/lib/gtfs/timeframes.d.ts /** * Returns an array of all timeframes that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTimeframes(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly timeframe_group_id: string; readonly start_time: string | null; readonly end_time: string | null; readonly service_id: string; } & { readonly end_timestamp: number | null; readonly start_timestamp: number | null; }, Fields>[]; //#endregion //#region src/lib/gtfs/transfers.d.ts /** * Returns an array of all transfers that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTransfers(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly from_stop_id: string | null; readonly to_stop_id: string | null; readonly from_route_id: string | null; readonly to_route_id: string | null; readonly from_trip_id: string | null; readonly to_trip_id: string | null; readonly transfer_type: number | null; readonly min_transfer_time: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/translations.d.ts /** * Returns an array of all translations that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTranslations(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly table_name: string; readonly field_name: string; readonly language: string; readonly translation: string; readonly record_id: string | null; readonly record_sub_id: string | null; readonly field_value: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs/trips.d.ts /** * Returns an array of all trips that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTrips(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly route_id: string; readonly service_id: string; readonly trip_id: string; readonly trip_headsign: string | null; readonly trip_short_name: string | null; readonly direction_id: number | null; readonly block_id: string | null; readonly shape_id: string | null; readonly wheelchair_accessible: number | null; readonly bikes_allowed: number | null; readonly cars_allowed: number | null; readonly safe_duration_factor: number | null; readonly safe_duration_offset: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-realtime/service-alert-informed-entities.d.ts /** * Returns an array of all service alert informed entities that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getServiceAlertInformedEntities(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly alert_id: string; readonly agency_id: string | null; readonly stop_id: string | null; readonly route_id: string | null; readonly route_type: number | null; readonly trip_id: string | null; readonly trip_route_id: string | null; readonly trip_direction_id: number | null; readonly trip_start_time: string | null; readonly trip_start_date: string | null; readonly trip_schedule_relationship: "ADDED" | "CANCELED" | "DELETED" | "DUPLICATED" | "NEW" | "REPLACEMENT" | "SCHEDULED" | "UNSCHEDULED" | (string & Record) | null; readonly trip_modified_trip_modifications_id: string | null; readonly trip_modified_trip_affected_trip_id: string | null; readonly trip_modified_trip_start_time: string | null; readonly trip_modified_trip_start_date: string | null; readonly direction_id: number | null; readonly created_timestamp: number; readonly expiration_timestamp: number; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-realtime/service-alerts.d.ts type ServiceAlertQuery = RowQuery; /** * Returns an array of all service alerts that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getServiceAlerts(query?: ServiceAlertQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): { id: string; active_period: string | null; communication_period: string | null; impact_period: string | null; cause: "ACCIDENT" | "CONSTRUCTION" | "DEMONSTRATION" | "HOLIDAY" | "MAINTENANCE" | "MEDICAL_EMERGENCY" | "OTHER_CAUSE" | "POLICE_ACTIVITY" | "SPECIAL_EVENT" | "STRIKE" | "TECHNICAL_PROBLEM" | "UNKNOWN_CAUSE" | "WEATHER" | (string & Record) | null; effect: "ACCESSIBILITY_ISSUE" | "ADDITIONAL_SERVICE" | "DETOUR" | "MODIFIED_SERVICE" | "NO_EFFECT" | "NO_SERVICE" | "OTHER_EFFECT" | "REDUCED_SERVICE" | "SIGNIFICANT_DELAYS" | "STOP_MOVED" | "UNKNOWN_EFFECT" | (string & Record) | null; url: string | null; url_translations: string | null; start_time: number | null; end_time: number | null; header_text: string; header_text_translations: string | null; description_text: string; description_text_translations: string | null; tts_header_text: string | null; tts_header_text_translations: string | null; tts_description_text: string | null; tts_description_text_translations: string | null; severity_level: "INFO" | "SEVERE" | "UNKNOWN_SEVERITY" | "WARNING" | (string & Record) | null; image: string | null; image_alternative_text: string | null; image_alternative_text_translations: string | null; cause_detail: string | null; cause_detail_translations: string | null; effect_detail: string | null; effect_detail_translations: string | null; created_timestamp: number; expiration_timestamp: number; informed_entities: ({ readonly alert_id: string; readonly agency_id: string | null; readonly stop_id: string | null; readonly route_id: string | null; readonly route_type: number | null; readonly trip_id: string | null; readonly trip_route_id: string | null; readonly trip_direction_id: number | null; readonly trip_start_time: string | null; readonly trip_start_date: string | null; readonly trip_schedule_relationship: "ADDED" | "CANCELED" | "DELETED" | "DUPLICATED" | "NEW" | "REPLACEMENT" | "SCHEDULED" | "UNSCHEDULED" | (string & Record) | null; readonly trip_modified_trip_modifications_id: string | null; readonly trip_modified_trip_affected_trip_id: string | null; readonly trip_modified_trip_start_time: string | null; readonly trip_modified_trip_start_date: string | null; readonly direction_id: number | null; readonly created_timestamp: number; readonly expiration_timestamp: number; } & {})[]; }[]; //#endregion //#region src/lib/gtfs-realtime/stop-time-updates.d.ts /** * Returns an array of all stop time updates that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getStopTimeUpdates(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly trip_update_id: string; readonly trip_id: string | null; readonly trip_start_time: string | null; readonly trip_start_date: string | null; readonly direction_id: number | null; readonly route_id: string | null; readonly trip_schedule_relationship: "ADDED" | "CANCELED" | "DELETED" | "DUPLICATED" | "NEW" | "REPLACEMENT" | "SCHEDULED" | "UNSCHEDULED" | (string & Record) | null; readonly stop_id: string | null; readonly stop_sequence: number | null; readonly arrival_delay: number | null; readonly arrival_timestamp: number | null; readonly arrival_uncertainty: number | null; readonly arrival_scheduled_timestamp: number | null; readonly departure_delay: number | null; readonly departure_timestamp: number | null; readonly departure_uncertainty: number | null; readonly departure_scheduled_timestamp: number | null; readonly departure_occupancy_status: "CRUSHED_STANDING_ROOM_ONLY" | "EMPTY" | "FEW_SEATS_AVAILABLE" | "FULL" | "MANY_SEATS_AVAILABLE" | "NOT_ACCEPTING_PASSENGERS" | "NOT_BOARDABLE" | "NO_DATA_AVAILABLE" | "STANDING_ROOM_ONLY" | (string & Record) | null; readonly schedule_relationship: "NO_DATA" | "SCHEDULED" | "SKIPPED" | "UNSCHEDULED" | (string & Record) | null; readonly assigned_stop_id: string | null; readonly stop_headsign: string | null; readonly pickup_type: "COORDINATE_WITH_DRIVER" | "NONE" | "PHONE_AGENCY" | "REGULAR" | (string & Record) | null; readonly drop_off_type: "COORDINATE_WITH_DRIVER" | "NONE" | "PHONE_AGENCY" | "REGULAR" | (string & Record) | null; readonly created_timestamp: number; readonly expiration_timestamp: number; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-realtime/trip-updates.d.ts /** * Returns an array of all trip updates that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTripUpdates(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly id: string; readonly vehicle_id: string | null; readonly vehicle_label: string | null; readonly vehicle_license_plate: string | null; readonly vehicle_wheelchair_accessible: "NO_VALUE" | "UNKNOWN" | "WHEELCHAIR_ACCESSIBLE" | "WHEELCHAIR_INACCESSIBLE" | (string & Record) | null; readonly trip_id: string | null; readonly trip_start_time: string | null; readonly direction_id: number | null; readonly route_id: string | null; readonly start_date: string | null; readonly timestamp: number | null; readonly schedule_relationship: "ADDED" | "CANCELED" | "DELETED" | "DUPLICATED" | "NEW" | "REPLACEMENT" | "SCHEDULED" | "UNSCHEDULED" | (string & Record) | null; readonly modified_trip_modifications_id: string | null; readonly modified_trip_affected_trip_id: string | null; readonly modified_trip_start_time: string | null; readonly modified_trip_start_date: string | null; readonly delay: number | null; readonly trip_properties_trip_id: string | null; readonly trip_properties_start_date: string | null; readonly trip_properties_start_time: string | null; readonly trip_properties_shape_id: string | null; readonly trip_properties_trip_headsign: string | null; readonly trip_properties_trip_short_name: string | null; readonly created_timestamp: number; readonly expiration_timestamp: number; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-realtime/vehicle-positions.d.ts /** * Returns an array of all vehicle positions that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getVehiclePositions(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly id: string; readonly trip_id: string | null; readonly route_id: string | null; readonly direction_id: number | null; readonly trip_start_time: string | null; readonly trip_start_date: string | null; readonly schedule_relationship: "ADDED" | "CANCELED" | "DELETED" | "DUPLICATED" | "NEW" | "REPLACEMENT" | "SCHEDULED" | "UNSCHEDULED" | (string & Record) | null; readonly modified_trip_modifications_id: string | null; readonly modified_trip_affected_trip_id: string | null; readonly modified_trip_start_time: string | null; readonly modified_trip_start_date: string | null; readonly vehicle_id: string | null; readonly vehicle_label: string | null; readonly vehicle_license_plate: string | null; readonly vehicle_wheelchair_accessible: "NO_VALUE" | "UNKNOWN" | "WHEELCHAIR_ACCESSIBLE" | "WHEELCHAIR_INACCESSIBLE" | (string & Record) | null; readonly bearing: number | null; readonly latitude: number | null; readonly longitude: number | null; readonly speed: number | null; readonly odometer: number | null; readonly current_stop_sequence: number | null; readonly stop_id: string | null; readonly vehicle_stop_status: "INCOMING_AT" | "IN_TRANSIT_TO" | "STOPPED_AT" | (string & Record) | null; readonly current_status: "INCOMING_AT" | "IN_TRANSIT_TO" | "STOPPED_AT" | (string & Record) | null; readonly congestion_level: "CONGESTION" | "RUNNING_SMOOTHLY" | "SEVERE_CONGESTION" | "STOP_AND_GO" | "UNKNOWN_CONGESTION_LEVEL" | (string & Record) | null; readonly occupancy_status: "CRUSHED_STANDING_ROOM_ONLY" | "EMPTY" | "FEW_SEATS_AVAILABLE" | "FULL" | "MANY_SEATS_AVAILABLE" | "NOT_ACCEPTING_PASSENGERS" | "NOT_BOARDABLE" | "NO_DATA_AVAILABLE" | "STANDING_ROOM_ONLY" | (string & Record) | null; readonly occupancy_percentage: number | null; readonly multi_carriage_details: string | null; readonly timestamp: number | null; readonly created_timestamp: number; readonly expiration_timestamp: number; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-plus/calendar-attributes.d.ts /** * Returns an array of all calendar_attributes that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getCalendarAttributes(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly service_id: string | null; readonly service_description: string; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-plus/directions.d.ts /** * Returns an array of all directions that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getDirections(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly route_id: string; readonly direction_id: number | null; readonly direction: string; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-plus/route-attributes.d.ts /** * Returns an array of all route_attributes that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getRouteAttributes(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly route_id: string | null; readonly category: number; readonly subcategory: number; readonly running_way: number; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-plus/stop-attributes.d.ts /** * Returns an array of all stop attributes that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getStopAttributes(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly stop_id: string; readonly accessibility_id: number | null; readonly cardinal_direction: string | null; readonly relative_position: string | null; readonly stop_city: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-ride/board-alights.d.ts /** * Returns an array of all board-alights that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getBoardAlights(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly trip_id: string; readonly stop_id: string; readonly stop_sequence: number; readonly record_use: number; readonly schedule_relationship: number | null; readonly boardings: number | null; readonly alightings: number | null; readonly current_load: number | null; readonly load_count: number | null; readonly load_type: number | null; readonly rack_down: number | null; readonly bike_boardings: number | null; readonly bike_alightings: number | null; readonly ramp_used: number | null; readonly ramp_boardings: number | null; readonly ramp_alightings: number | null; readonly service_date: number | null; readonly service_arrival_time: string | null; readonly service_departure_time: string | null; readonly source: number | null; } & { readonly service_arrival_timestamp: number | null; readonly service_departure_timestamp: number | null; }, Fields>[]; //#endregion //#region src/lib/gtfs-ride/ride-feed-info.d.ts /** * Returns an array of all ride-feed-info that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getRideFeedInfo(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly ride_files: number; readonly ride_start_date: number | null; readonly ride_end_date: number | null; readonly gtfs_feed_date: number | null; readonly default_currency_type: string | null; readonly ride_feed_version: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-ride/rider-trips.d.ts /** * Returns an array of all rider trips that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getRiderTrips(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly rider_id: string | null; readonly agency_id: string | null; readonly trip_id: string | null; readonly boarding_stop_id: string | null; readonly boarding_stop_sequence: number | null; readonly alighting_stop_id: string | null; readonly alighting_stop_sequence: number | null; readonly service_date: number | null; readonly boarding_time: string | null; readonly alighting_time: string | null; readonly rider_type: number | null; readonly rider_type_description: string | null; readonly fare_paid: number | null; readonly transaction_type: number | null; readonly fare_media: number | null; readonly accompanying_device: number | null; readonly transfer_status: number | null; } & { readonly alighting_timestamp: number | null; readonly boarding_timestamp: number | null; }, Fields>[]; //#endregion //#region src/lib/gtfs-ride/ridership.d.ts /** * Returns an array of all ridership that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getRidership(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly total_boardings: number; readonly total_alightings: number; readonly ridership_start_date: number | null; readonly ridership_end_date: number | null; readonly ridership_start_time: string | null; readonly ridership_end_time: string | null; readonly service_id: string | null; readonly monday: number | null; readonly tuesday: number | null; readonly wednesday: number | null; readonly thursday: number | null; readonly friday: number | null; readonly saturday: number | null; readonly sunday: number | null; readonly agency_id: string | null; readonly route_id: string | null; readonly direction_id: number | null; readonly trip_id: string | null; readonly stop_id: string | null; } & { readonly ridership_end_timestamp: number | null; readonly ridership_start_timestamp: number | null; }, Fields>[]; //#endregion //#region src/lib/gtfs-ride/trip-capacities.d.ts /** * Returns an array of all trip-capacities that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTripCapacities(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly agency_id: string | null; readonly trip_id: string | null; readonly service_date: number | null; readonly vehicle_description: string | null; readonly seated_capacity: number | null; readonly standing_capacity: number | null; readonly wheelchair_capacity: number | null; readonly bike_capacity: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-to-html/timetable-notes.d.ts /** * Returns an array of all timetable notes that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTimetableNotes(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly note_id: string; readonly symbol: string | null; readonly note: string | null; readonly scope: string | null; readonly timetable_id: string | null; readonly route_id: string | null; readonly trip_id: string | null; readonly stop_id: string | null; readonly stop_sequence: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-to-html/timetable-notes-references.d.ts /** * Returns an array of all timetable note references that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTimetableNotesReferences(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly note_id: string; readonly timetable_id: string | null; readonly route_id: string | null; readonly trip_id: string | null; readonly stop_id: string | null; readonly stop_sequence: number | null; readonly show_on_stoptime: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-to-html/timetable-pages.d.ts /** * Returns an array of all timetable pages that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTimetablePages(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly timetable_page_id: string; readonly timetable_page_label: string | null; readonly filename: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-to-html/timetable-stop-order.d.ts /** * Returns an array of all timetable stop orders that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTimetableStopOrders(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly timetable_id: string; readonly stop_id: string; readonly stop_sequence: number; } & {}, Fields>[]; //#endregion //#region src/lib/gtfs-to-html/timetables.d.ts /** * Returns an array of all timetables that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTimetables(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly timetable_id: string; readonly route_id: string; readonly direction_id: number | null; readonly start_date: number | null; readonly end_date: number | null; readonly monday: number; readonly tuesday: number; readonly wednesday: number; readonly thursday: number; readonly friday: number; readonly saturday: number; readonly sunday: number; readonly start_time: string | null; readonly end_time: string | null; readonly timetable_label: string | null; readonly service_notes: string | null; readonly orientation: string | null; readonly timetable_page_id: string | null; readonly timetable_sequence: number | null; readonly direction_name: string | null; readonly include_exceptions: number | null; readonly show_trip_continuation: number | null; } & { readonly end_timestamp: number | null; readonly start_timestamp: number | null; }, Fields>[]; //#endregion //#region src/lib/noptis/trips-dated-vehicle-journey.d.ts /** * Returns an array of all dated vehicle journeys that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTripsDatedVehicleJourneys(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly trip_id: string; readonly operating_day_date: string; readonly dated_vehicle_journey_gid: string; readonly journey_number: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/tods/deadhead-times.d.ts /** * Returns an array of all deadhead times that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getDeadheadTimes(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly deadhead_id: string; readonly arrival_time: string; readonly departure_time: string; readonly ops_location_id: string | null; readonly stop_id: string | null; readonly location_sequence: number; readonly shape_dist_traveled: number | null; } & { readonly arrival_timestamp: number; readonly departure_timestamp: number; }, Fields>[]; //#endregion //#region src/lib/tods/deadheads.d.ts /** * Returns an array of all deadheads that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getDeadheads(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly deadhead_id: string; readonly service_id: string; readonly block_id: string; readonly shape_id: string | null; readonly to_trip_id: string | null; readonly from_trip_id: string | null; readonly to_deadhead_id: string | null; readonly from_deadhead_id: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/tods/ops-locations.d.ts /** * Returns an array of all ops locations that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getOpsLocations(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly ops_location_id: string; readonly ops_location_code: string | null; readonly ops_location_name: string; readonly ops_location_desc: string | null; readonly ops_location_lat: number; readonly ops_location_lon: number; } & {}, Fields>[]; //#endregion //#region src/lib/tods/run-events.d.ts /** * Returns an array of all run events that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getRunEvents(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly run_event_id: string; readonly piece_id: string; readonly event_type: number; readonly event_name: string | null; readonly event_time: string; readonly event_duration: number; readonly event_from_location_type: number | null; readonly event_from_location_id: string | null; readonly event_to_location_type: number | null; readonly event_to_location_id: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/tods/runs-pieces.d.ts /** * Returns an array of all run pieces that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getRunsPieces(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly run_id: string; readonly piece_id: string; readonly start_type: number; readonly start_trip_id: string; readonly start_trip_position: number | null; readonly end_type: number; readonly end_trip_id: string; readonly end_trip_position: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/tides/devices.d.ts /** * Returns an array of all devices that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getDevices(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly device_id: string; readonly stop_id: string | null; readonly vehicle_id: string | null; readonly train_car_id: string | null; readonly device_type: string | null; readonly device_vendor: string | null; readonly device_model: string | null; readonly device_location: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/tides/fare-transactions.d.ts /** * Returns an array of all fare transactions that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getFareTransactions(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly transaction_id: string; readonly service_date: number; readonly event_timestamp: string; readonly location_ping_id: string | null; readonly amount: number; readonly currency_type: string | null; readonly fare_action: string; readonly trip_id_performed: string | null; readonly trip_id_scheduled: string | null; readonly pattern_id: string | null; readonly trip_stop_sequence: number | null; readonly scheduled_stop_sequence: number | null; readonly vehicle_id: string | null; readonly device_id: string | null; readonly fare_id: string | null; readonly stop_id: string | null; readonly num_riders: number | null; readonly fare_media_id: string | null; readonly rider_category: string | null; readonly fare_product: string | null; readonly fare_period: string | null; readonly fare_capped: string; readonly token_id: string | null; readonly balance: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/tides/operators.d.ts /** * Returns an array of all operators that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getOperators(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly operator_id: string; } & {}, Fields>[]; //#endregion //#region src/lib/tides/passenger-events.d.ts /** * Returns an array of all passenger events that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getPassengerEvents(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly passenger_event_id: string; readonly service_date: number; readonly event_timestamp: string; readonly location_ping_id: string | null; readonly trip_id_performed: string | null; readonly trip_id_scheduled: string | null; readonly trip_stop_sequence: number; readonly scheduled_stop_sequence: number | null; readonly event_type: string; readonly vehicle_id: string; readonly device_id: string | null; readonly train_car_id: string | null; readonly stop_id: string | null; readonly pattern_id: string | null; readonly event_count: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/tides/station-activities.d.ts /** * Returns an array of all station activities that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getStationActivities(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly service_date: number; readonly stop_id: string; readonly time_period_start: string; readonly time_period_end: string; readonly time_period_category: string | null; readonly total_entries: number | null; readonly total_exits: number | null; readonly number_of_transactions: number | null; readonly bike_entries: number | null; readonly bike_exits: number | null; readonly ramp_entries: number | null; readonly ramp_exits: number | null; } & {}, Fields>[]; //#endregion //#region src/lib/tides/stop-visits.d.ts /** * Returns an array of all stop visits that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getStopVisits(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly service_date: number; readonly trip_id_performed: string; readonly trip_stop_sequence: number; readonly scheduled_stop_sequence: number | null; readonly pattern_id: string | null; readonly vehicle_id: string | null; readonly dwell: number | null; readonly stop_id: string | null; readonly timepoint: string | null; readonly schedule_arrival_time: string | null; readonly schedule_departure_time: string | null; readonly actual_arrival_time: string | null; readonly actual_departure_time: string | null; readonly distance: number | null; readonly boarding_1: number | null; readonly alighting_1: number | null; readonly boarding_2: number | null; readonly alighting_2: number | null; readonly departure_load: number | null; readonly door_open: string | null; readonly door_close: string | null; readonly door_status: string | null; readonly ramp_deployed_time: number | null; readonly ramp_failure: string | null; readonly kneel_deployed_time: number | null; readonly lift_deployed_time: number | null; readonly bike_rack_deployed: string | null; readonly bike_load: number | null; readonly revenue: number | null; readonly number_of_transactions: number | null; readonly schedule_relationship: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/tides/train-cars.d.ts /** * Returns an array of all train cars that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTrainCars(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly train_car_id: string; readonly model_name: string | null; readonly facility_name: string | null; readonly capacity_seated: number | null; readonly capacity_wheelchair: number | null; readonly capacity_bike: number | null; readonly bike_rack: string | null; readonly capacity_standing: number | null; readonly train_car_type: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/tides/trips-performed.d.ts /** * Returns an array of all performed trips that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getTripsPerformed(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly service_date: number; readonly trip_id_performed: string; readonly vehicle_id: string; readonly trip_id_scheduled: string | null; readonly route_id: string | null; readonly route_type: string | null; readonly ntd_mode: string | null; readonly route_type_agency: string | null; readonly shape_id: string | null; readonly pattern_id: string | null; readonly direction_id: number | null; readonly operator_id: string | null; readonly block_id: string | null; readonly trip_start_stop_id: string | null; readonly trip_end_stop_id: string | null; readonly schedule_trip_start: string | null; readonly schedule_trip_end: string | null; readonly actual_trip_start: string | null; readonly actual_trip_end: string | null; readonly trip_type: string | null; readonly schedule_relationship: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/tides/vehicle-locations.d.ts /** * Returns an array of all vehicle locations that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getVehicleLocations(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly location_ping_id: string; readonly service_date: number | null; readonly event_timestamp: string; readonly trip_id_performed: string | null; readonly trip_id_scheduled: string | null; readonly trip_stop_sequence: number | null; readonly scheduled_stop_sequence: number | null; readonly vehicle_id: string; readonly device_id: string | null; readonly pattern_id: string | null; readonly stop_id: string | null; readonly current_status: string | null; readonly latitude: number | null; readonly longitude: number | null; readonly gps_quality: string | null; readonly heading: number | null; readonly speed: number | null; readonly odometer: number | null; readonly schedule_deviation: number | null; readonly headway_deviation: number | null; readonly trip_type: string | null; readonly schedule_relationship: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/tides/vehicle-train-cars.d.ts /** * Returns an array of all vehicle train cars that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getVehicleTrainCars(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly vehicle_id: string; readonly train_car_id: string; readonly train_car_order: number | null; readonly operator_id: string | null; } & {}, Fields>[]; //#endregion //#region src/lib/tides/vehicles.d.ts /** * Returns an array of all vehicles that match the query parameters. * @param query Column values to match, as single values or arrays * @param fields Columns to select, or every column when empty * @param orderBy Column and direction pairs to sort by * @param options Query options, including the database to read from * @returns Matching rows, containing only `fields` when it is not empty */ declare function getVehicles(query?: RowQuery, fields?: readonly Fields[], orderBy?: RowOrderBy, options?: SqliteQueryOptions): SelectedRow<{ readonly vehicle_id: string; readonly vehicle_start: string | null; readonly vehicle_end: string | null; readonly model_name: string | null; readonly facility_name: string | null; readonly capacity_seated: number | null; readonly capacity_wheelchair: number | null; readonly capacity_bike: number | null; readonly bike_rack: string | null; readonly capacity_standing: number | null; } & {}, Fields>[]; //#endregion export { type AdvancedQueryJoin, type AdvancedQueryJoinType, type AdvancedQueryOptions, type Agency, type Area, type Attribution, type BoardAlight, type BookingRule, type Calendar, type CalendarAttribute, type CalendarDate, type DatabaseResultValue, type Deadhead, type DeadheadTime, type Device, type Direction, type DownloadOptions, type DynamicQuery, type DynamicQueryResult, type FareAttribute, type FareLegJoinRule, type FareLegRule, type FareMedia, type FareProduct, type FareRule, type FareTransaction, type FareTransferRule, type FeedInfo, type Frequency, type GtfsDatabase, type GtfsDatabaseFromTables, type GtfsEnumerationValue, GtfsError, GtfsErrorCategory, GtfsErrorCode, type GtfsExportConfig, type GtfsFeedConfig, type GtfsFieldDefinition, type GtfsFieldKind, type GtfsFieldOptions, type GtfsFileBackedTableName, type GtfsImportConfig, type GtfsInsert, type GtfsJoinDefinition, type GtfsManifestEntry, type GtfsNamespace, type GtfsPresence, type GtfsQuery, type GtfsRangeConstraint, type GtfsRealtimeAlertCause, type GtfsRealtimeAlertEffect, type GtfsRealtimeAlertSeverity, type GtfsRealtimeConfig, type GtfsRealtimeCongestionLevel, type GtfsRealtimeDropOffPickupType, type GtfsRealtimeEndpoint, type GtfsRealtimeFeedConfig, type GtfsRealtimeOccupancyStatus, type GtfsRealtimeStopTimeScheduleRelationship, type GtfsRealtimeTripScheduleRelationship, type GtfsRealtimeVehicleStopStatus, type GtfsRealtimeWheelchairAccessible, type GtfsReference, type GtfsRow, type GtfsScheduleTableName, type GtfsSemanticConstraint, type GtfsSqliteImportConfig, type GtfsStorageDefinition, type GtfsStoredRow, type GtfsTableDefinition, type GtfsTableName, type GtfsTableRow, type GtfsValuePresence, type GtfsWarning, GtfsWarningCode, type ImportBehaviorOptions, type ImportConfigWithReport, type ImportReport, type KyselyImportDialect, type KyselyImportOptions, type Level, type Location, type LocationGroup, type LocationGroupStop, type LogFunction, type LogLevel, type LogMessageLevel, type Network, type Operator, type OpsLocation, type PassengerEvent, type Pathway, type QueryScalar, type ReportingOptions, type RideFeedInfo, type RiderCategory, type RiderTrip, type Ridership, type Route, type RouteAttribute, type RouteNetwork, type RowOrderBy, type RowQuery, type RunEvent, type RunPiece, type SelectedRow, type ServiceAlert, type ServiceAlertInformedEntity, type ServiceAlertRow, type Shape, type SortDirection, type SqliteConnectionOptions, type SqliteImportConfigWithReport, type SqliteQueryOptions, type StationActivity, type Stop, type StopArea, type StopAttribute, type StopQueryOptions, type StopTime, type StopTimeUpdate, type StopVisit, type Timeframe, type Timetable, type TimetableNote, type TimetableNoteScope, type TimetableNotesReference, type TimetablePage, type TimetableStopOrder, type TrainCar, type Transfer, type Translation, type Trip, type TripCapacity, type TripPerformed, type TripUpdate, type TripsDatedVehicleJourney, type Vehicle, type VehicleLocation, type VehiclePosition, type VehicleTrainCar, advancedQuery, agency, areas, attributions, boardAlight, bookingRules, calendar, calendarAttributes, calendarDates, closeDb, deadheadTimes, deadheads, defineGtfsTable, deleteDb, devices, directions, exportGtfs, fareAttributes, fareLegJoinRules, fareLegRules, fareMedia, fareProducts, fareRules, fareTransactions, fareTransferRules, feedInfo, formatGtfsError, frequencies, generateFolderName, getAgencies, getAreas, getAttributions, getBoardAlights, getBookingRules, getCalendarAttributes, getCalendarDates, getCalendars, getDeadheadTimes, getDeadheads, getDevices, getDirections, getFareAttributes, getFareLegJoinRules, getFareLegRules, getFareMedia, getFareProducts, getFareRules, getFareTransactions, getFareTransferRules, getFeedInfo, getFrequencies, getLevels, getLocationGroupStops, getLocationGroups, getLocations, getNetworks, getOperators, getOpsLocations, getPassengerEvents, getPathways, getRideFeedInfo, getRiderCategories, getRiderTrips, getRidership, getRouteAttributes, getRouteNetworks, getRoutes, getRunEvents, getRunsPieces, getServiceAlertInformedEntities, getServiceAlerts, getServiceIdsByDate, getShapes, getShapesAsGeoJSON, getStationActivities, getStopAreas, getStopAttributes, getStopTimeUpdates, getStopVisits, getStops, getStopsAsGeoJSON, getStoptimes, getTimeframes, getTimetableNotes, getTimetableNotesReferences, getTimetablePages, getTimetableStopOrders, getTimetables, getTrainCars, getTransfers, getTranslations, getTripCapacities, getTripUpdates, getTrips, getTripsDatedVehicleJourneys, getTripsPerformed, getVehicleLocations, getVehiclePositions, getVehicleTrainCars, getVehicles, gtfsJoins, gtfsManifest, gtfsNamespaces, gtfsScheduleReferenceRevision, importGtfs, importGtfsToKysely, isGtfsError, isGtfsValidationError, levels, locationGroupStops, locationGroups, locations, networks, openDb, operators, opsLocations, passengerEvents, pathways, prepDirectory, rideFeedInfo, riderCategories, riderTrip, ridership, routeAttributes, routeNetworks, routes, runEvents, runsPieces, serviceAlertInformedEntities, serviceAlerts, shapes, stationActivities, stopAreas, stopAttributes, stopTimeUpdates, stopTimes, stopVisits, stops, index_d_exports as tables, timeframes, timetableNotes, timetableNotesReferences, timetablePages, timetableStopOrder, timetables, trainCars, transfers, translations, tripCapacity, tripUpdates, trips, tripsDatedVehicleJourney, tripsPerformed, untildify, unzip, updateGtfsRealtime, vehicleLocations, vehiclePositions, vehicleTrainCars, vehicles }; //# sourceMappingURL=index.d.ts.map