You asked

Which of the sigma 14 24mm and tamron 11 20mm would suit my city trip better for night street photos?

Here is what the site says about that.

From Tamron 11-20mm f/2.8 Di III-A RXD: Tamron 11-20mm f/2.8 Di III-A RXD: A zoom lens by Tamron for APS-C cameras, 11-20mm f/2.8.

From Sigma 14-24mm f/2.8 DG HSM Art: Sigma 14-24mm f/2.8 DG HSM Art: A zoom lens by Sigma for Full frame cameras, 14-24mm f/2.8.

Quoted from this site's pages.

From these pages

This answer is for the question above. Each answer is written for the exact question in its address, so a question with its details in it (a budget, what you shoot, what you already have) gets an answer about those details. An answer draws on all 15 pages of the guide and its catalogue of 320 cameras and 1050 lenses. Another question gets its own answer at its own address, as words after /ask/. Or fill in your own: /ask/which-camera-for-{what-you-shoot}-under-{budget}-euros or /ask/which-lens-for-{what-you-shoot}-on-{your-camera}.