diff options
Diffstat (limited to 'src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs')
14 files changed, 0 insertions, 411 deletions
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/DirectionId.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/DirectionId.cs deleted file mode 100644 index cbcf80b..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/DirectionId.cs +++ /dev/null @@ -1,7 +0,0 @@ -namespace Costasdev.ServiceViewer.Data.Gtfs.Enums; - -public enum DirectionId -{ - Outbound = 0, - Inbound = 1 -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/ExceptionType.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/ExceptionType.cs deleted file mode 100644 index 0ad0345..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/ExceptionType.cs +++ /dev/null @@ -1,7 +0,0 @@ -namespace Costasdev.ServiceViewer.Data.Gtfs.Enums; - -public enum ExceptionType -{ - Added = 1, - Removed = 2 -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/RouteType.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/RouteType.cs deleted file mode 100644 index e19d02a..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/RouteType.cs +++ /dev/null @@ -1,15 +0,0 @@ -namespace Costasdev.ServiceViewer.Data.Gtfs.Enums; - -public enum RouteType -{ - Tram = 0, - Subway = 1, - Rail = 2, - Bus = 3, - Ferry = 4, - CableTram = 5, - AerialLift = 6, - Funicular = 7, - Trolleybus = 11, - Monorail = 12 -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripBikesAllowed.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripBikesAllowed.cs deleted file mode 100644 index 838bc81..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripBikesAllowed.cs +++ /dev/null @@ -1,8 +0,0 @@ -namespace Costasdev.ServiceViewer.Data.Gtfs.Enums; - -public enum TripBikesAllowed -{ - Empty = 0, - CanAccommodate = 1, - NotAllowed = 2 -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripWheelchairAccessible.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripWheelchairAccessible.cs deleted file mode 100644 index e84b699..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripWheelchairAccessible.cs +++ /dev/null @@ -1,8 +0,0 @@ -namespace Costasdev.ServiceViewer.Data.Gtfs.Enums; - -public enum TripWheelchairAccessible -{ - Empty = 0, - CanAccommodate = 1, - NotAccessible = 2 -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/WheelchairBoarding.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/WheelchairBoarding.cs deleted file mode 100644 index 3cc550f..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/WheelchairBoarding.cs +++ /dev/null @@ -1,8 +0,0 @@ -namespace Costasdev.ServiceViewer.Data.Gtfs.Enums; - -public enum WheelchairBoarding -{ - Unknown = 0, - SomeVehicles = 1, - NotPossible = 2 -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Feed.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Feed.cs deleted file mode 100644 index 065250b..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Feed.cs +++ /dev/null @@ -1,21 +0,0 @@ -using System.ComponentModel.DataAnnotations; -using System.ComponentModel.DataAnnotations.Schema; - -namespace Costasdev.ServiceViewer.Data.Gtfs; - -[Table("feeds")] -public class Feed -{ - /// <summary> - /// Auto-incrementing ID value for each feed, to identify it and its version - /// </summary> - [Key] - public int Id { get; set; } - - [MaxLength(32)] public string ShortName { get; set; } - [MaxLength(32)] public string LongName { get; set; } - [MaxLength(255)] public string DownloadUrl { get; set; } - [MaxLength(32)] public string Etag { get; set; } - - public DateTime InsertedAt { get; set; } -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsAgency.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsAgency.cs deleted file mode 100644 index 89b5518..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsAgency.cs +++ /dev/null @@ -1,46 +0,0 @@ -using System.ComponentModel.DataAnnotations; -using System.ComponentModel.DataAnnotations.Schema; -using Microsoft.EntityFrameworkCore; - -namespace Costasdev.ServiceViewer.Data.Gtfs; - -[Table("gtfs_agencies")] -[PrimaryKey(nameof(Id), nameof(FeedId))] -public class GtfsAgency -{ - [Key] - [Column("agency_id")] - [MaxLength(255)] - public required string Id { get; set; } - - [Column("feed_id")] public int FeedId { get; set; } - [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; } - - [Column("agency_name")] - [MaxLength(255)] - public string Name { get; set; } = string.Empty; - - [Column("agency_url")] - [MaxLength(255)] - public string Url { get; set; } = string.Empty; - - [Column("agency_timezone")] - [MaxLength(50)] - public string Timezone { get; set; } = string.Empty; - - [Column("agency_lang")] - [MaxLength(5)] - public string Language { get; set; } = string.Empty; - - [Column("agency_phone")] - [MaxLength(30)] - public string? Phone { get; set; } = string.Empty; - - [Column("agency_email")] - [MaxLength(255)] - public string? Email { get; set; } = string.Empty; - - [Column("agency_fare_url")] - [MaxLength(255)] - public string? FareUrl { get; set; } = string.Empty; -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendar.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendar.cs deleted file mode 100644 index cfb144c..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendar.cs +++ /dev/null @@ -1,45 +0,0 @@ -using System.ComponentModel.DataAnnotations; -using System.ComponentModel.DataAnnotations.Schema; -using Microsoft.EntityFrameworkCore; - -namespace Costasdev.ServiceViewer.Data.Gtfs; - -[Table("gtfs_calendar")] -[PrimaryKey(nameof(ServiceId), nameof(FeedId))] -public class GtfsCalendar -{ - [Key] - [Column("service_id")] - [MaxLength(32)] - public string ServiceId { get; set; } = null!; - - [Column("feed_id")] public int FeedId { get; set; } - [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; } - - [Column("monday")] - public bool Monday { get; set; } - - [Column("tuesday")] - public bool Tuesday { get; set; } - - [Column("wednesday")] - public bool Wednesday { get; set; } - - [Column("thursday")] - public bool Thursday { get; set; } - - [Column("friday")] - public bool Friday { get; set; } - - [Column("saturday")] - public bool Saturday { get; set; } - - [Column("sunday")] - public bool Sunday { get; set; } - - [Column("start_date")] - public DateOnly StartDate { get; set; } - - [Column("end_date")] - public DateOnly EndDate { get; set; } -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendarDate.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendarDate.cs deleted file mode 100644 index 1543ef5..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendarDate.cs +++ /dev/null @@ -1,24 +0,0 @@ -using System.ComponentModel.DataAnnotations; -using System.ComponentModel.DataAnnotations.Schema; -using Costasdev.ServiceViewer.Data.Gtfs.Enums; -using Microsoft.EntityFrameworkCore; - -namespace Costasdev.ServiceViewer.Data.Gtfs; - -[Table("gtfs_calendar_dates")] -[PrimaryKey(nameof(ServiceId), nameof(Date), nameof(FeedId))] -public class GtfsCalendarDate -{ - [Column("service_id")] - [MaxLength(32)] - public required string ServiceId { get; set; } - - [Column("date")] - public required DateTime Date { get; set; } - - [Column("feed_id")] public int FeedId { get; set; } - [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; } - - [Column("exception_type")] - public required ExceptionType ExceptionType { get; set; } -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs deleted file mode 100644 index c34353c..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs +++ /dev/null @@ -1,70 +0,0 @@ -using System.ComponentModel.DataAnnotations; -using System.ComponentModel.DataAnnotations.Schema; -using Costasdev.ServiceViewer.Data.Gtfs.Enums; -using Microsoft.EntityFrameworkCore; - -namespace Costasdev.ServiceViewer.Data.Gtfs; - -[Table("gtfs_routes")] -[PrimaryKey(nameof(Id), nameof(FeedId))] -public class GtfsRoute -{ - [Column("route_id")] - [MaxLength(255)] - public required string Id { get; set; } - - public string SafeId => Id.Replace(" ", "_").Replace("-", "_"); - - [Column("feed_id")]public int FeedId { get; set; } - [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; } - - [Column("agency_id")] - [ForeignKey(nameof(Agency))] - [MaxLength(255)] - public required string AgencyId { get; set; } - - [ForeignKey(nameof(AgencyId))] - public GtfsAgency Agency { get; set; } = null!; - - /// <summary> - /// Short name of a route. Often a short, abstract identifier (e.g., "32", "100X", "Green") - /// that riders use to identify a route. Both route_short_name and route_long_name may be defined. - /// </summary> - [Column("route_short_name")] - [MaxLength(32)] - public string ShortName { get; set; } = string.Empty; - - /// <summary> - /// Full name of a route. This name is generally more descriptive than the route_short_name and often - /// includes the route's destination or stop. Both route_short_name and route_long_name may be defined. - /// </summary> - [Column("route_long_name")] - [MaxLength(255)] - public string LongName { get; set; } = string.Empty; - - [Column("route_desc")] - [MaxLength(255)] - public string? Description { get; set; } = string.Empty; - - [Column("route_type")] - public RouteType Type { get; set; } = RouteType.Bus; - - [Column("route_url")] - [MaxLength(255)] - public string? Url { get; set; } = string.Empty; - - [Column("route_color")] - [MaxLength(7)] - public string? Color { get; set; } = string.Empty; - - [Column("route_text_color")] - [MaxLength(7)] - public string? TextColor { get; set; } = string.Empty; - - /// <summary> - /// Orders the routes in a way which is ideal for presentation to customers. - /// Routes with smaller route_sort_order values should be displayed first. - /// </summary> - [Column("route_sort_order")] - public int SortOrder { get; set; } = 1; -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStop.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStop.cs deleted file mode 100644 index f604c5f..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStop.cs +++ /dev/null @@ -1,51 +0,0 @@ -using System.ComponentModel.DataAnnotations; -using System.ComponentModel.DataAnnotations.Schema; -using Costasdev.ServiceViewer.Data.Gtfs.Enums; -using Microsoft.EntityFrameworkCore; -using NetTopologySuite.Geometries; - -namespace Costasdev.ServiceViewer.Data.Gtfs; - -[Table("gtfs_stops")] -[PrimaryKey(nameof(Id), nameof(FeedId))] -public class GtfsStop -{ - [Column("stop_id")] - [MaxLength(32)] - public required string Id { get; set; } - - [Column("feed_id")]public int FeedId { get; set; } - [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; } - - [Column("stop_code")] - [MaxLength(32)] - public string Code { get; set; } = string.Empty; - - [Column("stop_name")] - [MaxLength(255)] - public string Name { get; set; } = string.Empty; - - [Column("stop_desc")] - [MaxLength(255)] - public string? Description { get; set; } - - [Column("stop_pos")] - public Point? Position { get; set; } - - [Column("stop_url")] - [MaxLength(255)] - public string? Url { get; set; } - - [Column("stop_timezone")] - [MaxLength(50)] - public string? Timezone { get; set; } - - [Column("wheelchair_boarding")] - public WheelchairBoarding WheelchairBoarding { get; set; } = WheelchairBoarding.Unknown; - - // [Column("location_type")] - // public int LocationType { get; set; } - // - // [Column("parent_station")] - // public int? ParentStationId { get; set; } -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStopTime.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStopTime.cs deleted file mode 100644 index 9599947..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStopTime.cs +++ /dev/null @@ -1,44 +0,0 @@ -using System.ComponentModel.DataAnnotations; -using System.ComponentModel.DataAnnotations.Schema; -using Costasdev.ServiceViewer.Data.Extensions; -using Microsoft.EntityFrameworkCore; - -namespace Costasdev.ServiceViewer.Data.Gtfs; - -[Table("gtfs_stop_times")] -[PrimaryKey(nameof(TripId), nameof(StopSequence), nameof(FeedId))] -public class GtfsStopTime -{ - [Column("trip_id")] - [ForeignKey("TripId")] - [MaxLength(32)] - public string TripId { get; set; } = null!; - - [Column("feed_id")]public int FeedId { get; set; } - [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; } - - [ForeignKey(nameof(TripId))] public GtfsTrip GtfsTrip { get; set; } = null!; - - [Column("arrival_time")] public string Arrival { get; set; } - public TimeSpan ArrivalTime => TimeSpan.FromGtfsTime(Arrival); - - [Column("departure_time")] public string Departure { get; set; } - public TimeSpan DepartureTime => TimeSpan.FromGtfsTime(Departure); - - [Column("stop_id")] - [ForeignKey(nameof(GtfsStop))] - [MaxLength(32)] - public required string StopId { get; set; } - - [ForeignKey(nameof(StopId))] public GtfsStop GtfsStop { get; set; } = null!; - - [Column("stop_sequence")] public int StopSequence { get; set; } = 0; - - // [Column("pickup_type")] - // public int? PickupType { get; set; } - // - // [Column("drop_off_type")] - // public int? DropOffType { get; set; } - - [Column("shape_dist_traveled")] public double? ShapeDistTraveled { get; set; } = null!; -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsTrip.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsTrip.cs deleted file mode 100644 index 3614120..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsTrip.cs +++ /dev/null @@ -1,57 +0,0 @@ -using System.ComponentModel.DataAnnotations; -using System.ComponentModel.DataAnnotations.Schema; -using Costasdev.ServiceViewer.Data.Gtfs.Enums; -using Microsoft.EntityFrameworkCore; - -namespace Costasdev.ServiceViewer.Data.Gtfs; - -[Table("gtfs_trips")] -[PrimaryKey(nameof(Id), nameof(FeedId))] -public class GtfsTrip -{ - [Column("trip_id")] [MaxLength(32)] public string Id { get; set; } = null!; - - [Column("feed_id")] public int FeedId { get; set; } - [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; } - - [Column("route_id")] - [MaxLength(32)] - [ForeignKey(nameof(Route))] - public string RouteId { get; set; } = null!; - - [ForeignKey(nameof(RouteId))] public GtfsRoute Route { get; set; } = null!; - - [Column("service_id")] [MaxLength(32)] public string ServiceId { get; set; } = null!; - - [Column("trip_headsign")] - [MaxLength(255)] - public string? TripHeadsign { get; set; } - - [Column("trip_short_name")] - [MaxLength(255)] - public string? TripShortName { get; set; } - - [Column("direction_id")] public DirectionId DirectionId { get; set; } = DirectionId.Outbound; - - /// <summary> - /// Identifies the block to which the trip belongs. A block consists of a single trip or many - /// sequential trips made using the same vehicle, defined by shared service days and block_id. - /// A block_id may have trips with different service days, making distinct blocks. - /// </summary> - [Column("block_id")] - [MaxLength(32)] - public string? BlockId { get; set; } - - /// <summary> - /// Identifies a geospatial shape describing the vehicle travel path for a trip. - /// </summary> - /// <remarks>To be implemented: will be stored as a GeoJSON file instead of database records.</remarks> - [Column("shape_id")] - [MaxLength(32)] - public string? ShapeId { get; set; } - - [Column("trip_wheelchair_accessible")] - public TripWheelchairAccessible TripWheelchairAccessible { get; set; } = TripWheelchairAccessible.Empty; - - [Column("trip_bikes_allowed")] public TripBikesAllowed TripBikesAllowed { get; set; } = TripBikesAllowed.Empty; -} |