search

skinkie / reference

Personal repository where I collect working examples to understand inner workings while building PyNeTExConv
GNU Affero General Public License v3.0
0 stars 1 forks source link

blablacar gtfs -> NeTEX EPIP: Also losses in epip_db_to_db.py #37

Closed ue71603 closed 2 months ago

ue71603 commented 2 months ago 
python gtfs_import_to_db.py C:/Users/ue71603/MG_Daten/conversion/blablacar/gtfs.zip  C:/Users/ue71603/MG_Daten/conversion/blablacar/gtfs-import.duckdb
python gtfs_convert_to_db.py C:/Users/ue71603/MG_Daten/conversion/blablacar/gtfs-import.duckdb C:/Users/ue71603/MG_Daten/conversion/blablacar/netex-import.duckdb
python epip_db_to_db.py C:/Users/ue71603/MG_Daten/conversion/blablacar/netex-import.duckdb C:/Users/ue71603/MG_Daten/conversion/blablacar/netex-import-epip.duckdb
python epip-db-to-xm.py C:/Users/ue71603/MG_Daten/conversion/blablacar/netex-import.duckdb C:/Users/ue71603/MG_Daten/conversion/blablacar/netex-import-epip.duckdb C:/Users/ue71603/MG_Daten/conversion/blablacar/netex.xml.gz
del C:/Users/ue71603/MG_Daten/conversion/blablacar/*.duckdb

gtfs.zip

previous step:

Line 4856
Codespace 1
DataSource 1
Version 1
Operator 1
ScheduledStopPoint 312
StopPlace 312
PassengerStopAssignment 312
AvailabilityCondition 11474
 ServiceJourney 6877

result:

epip_line_memory
Line 4856
epip_scheduled_stop_point_memory
ScheduledStopPoint 312
epip_site_frame_memory
PassengerStopAssignment 312
StopPlace 312
epip_service_journey_generator
 ServiceJourney 16

ServiceJourneyPattern 16
ServiceCalendar 1
 ServiceJourneyPattern 16

 Direction 1
skinkie commented 2 months ago

Lossless operation:

(.venv312) [skinkie@archlinux tmp]$ /home/skinkie/Sources/duckdb/build/duckdb /home/netex/gtfs-blabla.duckdb 
v1.0.1-dev1907 9dc0e2658b
Enter ".help" for usage hints.
D select  count(*) from trips;
┌──────────────┐
│ count_star() │
│    int64     │
├──────────────┤
│         6877 │
└──────────────┘

(.venv312) [skinkie@archlinux tmp]$ /home/skinkie/Sources/duckdb/build/duckdb /home/netex/netex-blabla.duckdb 
v1.0.1-dev1907 9dc0e2658b
Enter ".help" for usage hints.
D select  count(*) from ServiceJourney;
┌──────────────┐
│ count_star() │
│    int64     │
├──────────────┤
│         6877 │
└──────────────┘
D 

(.venv312) [skinkie@archlinux tmp]$ /home/skinkie/Sources/duckdb/build/duckdb /home/netex/netex-blabla-epip.duckdb
v1.0.1-dev1907 9dc0e2658b
Enter ".help" for usage hints.
D select count(*) from ServiceJourney;
┌──────────────┐
│ count_star() │
│    int64     │
├──────────────┤
│         6877 │
└──────────────┘
D