search

CityofSantaMonica / mds-provider

Python tools for working with MDS Provider data
https://github.com/openmobilityfoundation/mobility-data-specification
MIT License
18 stars 20 forks source link

Bug in status_changes loading from temp table #28

Closed thekaveman closed 5 years ago

thekaveman commented 5 years ago 
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) cannot cast type double precision to uuid[]
LINE 29:         associated_trips::UUID[]

Line 29 is a reference to the SELECT clause here

thekaveman commented 5 years ago

Having a clearer understanding on CityofLosAngeles/mobility-data-specification#88 would help in figuring out a more permanent fix for this issue (i.e. does the field need to be an array type?)

But some type of hack a la #29 will probably still be needed.