Link direction = -1: sqlite3.IntegrityError: CHECK constraint failed: LENGTH(direction)==1

Tim Klein

unread,

Nov 25, 2024, 9:41:43 AM11/25/24

to AequilibraE

Hi,

(it's an issue on aequilibrae 0.9.5, so maybe this is obsolete)

when i want to introduce oneway streets with the link.direction attribute, i can't set that to -1 because of a check constraint that does not allow for values with a length other than 1.

I tried to change that with the db browser for sqlite, but that did not work either. If there is any other workaround for it, i'll be happy to read about it...

cheers, tim

Pedro Camargo

unread,

Nov 25, 2024, 2:04:33 PM11/25/24

to tristram...@gmail.com, aequi...@googlegroups.com

Hi Tim,

This was a serious bug fixed on 1.1.3.

You will have to upgrade to the latest version, create an empty project, and move all your data there.

Cheers,

Pedro

---- On Tue, 26 Nov 2024 00:41:43 +1000 tristram...@gmail.com wrote ----

--
You received this message because you are subscribed to the Google Groups "AequilibraE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to aequilibrae...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/aequilibrae/e4c74bdf-53b9-4e5c-abcc-34fcff15855cn%40googlegroups.com.

Tim Klein

unread,

Nov 26, 2024, 1:56:48 AM11/26/24

to AequilibraE

Ok, thanks. Which python release do you recommend for that?

If i don't want to change horses in the middle of the stream, i guess i can set speed_ab to 0.0?

Best, Tim

Op maandag 25 november 2024 om 20:04:33 UTC+1 schreef Pedro Camargo:

Chris Burns

unread,

Nov 26, 2024, 7:42:01 AM11/26/24

to Tim Klein, AequilibraE

As a workaround, you could flip the direction of these 'backwards' one-way streets using the reverse line direction tool in QGIS (under vector geometry). Then you can set the direction to 1.

Chris

From: aequi...@googlegroups.com <aequi...@googlegroups.com> on behalf of Tim Klein <tristram...@gmail.com>
Sent: Monday, November 25, 2024 11:56:48 PM
To: AequilibraE <aequi...@googlegroups.com>
Subject: Re: Link direction = -1: sqlite3.IntegrityError: CHECK constraint failed: LENGTH(direction)==1

To view this discussion visit https://groups.google.com/d/msgid/aequilibrae/6bc42374-6ef7-44ef-b8cf-1b70f171407dn%40googlegroups.com.

Tim Klein

unread,

Nov 27, 2024, 1:34:35 AM11/27/24

to AequilibraE

Hi Chris,

thanks, I will try that next. Setting the speed to 0.0 would have worked in Visum, but in aequilibrae the travel time calculation had already happened (in my workflow at least).