January 18, 2021

Not-So Smart Crosswalks


Not-So Smart Crosswalks
These stripes (or "zebras" as they are called in Russian) look more like a maze than a path. Anonymous user, the community group "In Salekhard.ru" on VKontakte 

Anyone who has walked through busy Russian streets (or has even just seen one of those crazy Russian dashcam videos online) can appreciate how useful "Smart Crosswalks" could be. Unfortunately, ideas like this sometimes don't work out the way they were intended.

Salekhard, a city in Russia’s Far North, has officially begun to implement new “Smart Crosswalks” in its streets, although with lackluster results.

While the creators had hoped to develop a tool that would make crossing the street at night or in icy conditions safer and easier, it seems to have only angered one anonymous Salekhard resident, who took to popular Russian social media site VKontakte to publish an impassioned complaint about the initiative. It seems that the projectors just can’t seem to display the stripes in a straight path, and (perhaps more importantly) the warning lights often don’t even function properly. 

These devices work by projecting the classic yellow and white stripes on the pavement as well as by using a motion sensor, video camera, and LED sign to detect and signal the presence of pedestrians.

After this public outcry, it seems that city officials have taken notice and have made a resolve to fix the situation. But in the meantime, we would just stick to using the pedestrian underpass tunnels.   

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.795 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
SELECT
tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups,
tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
tcontent.releaseDate, tcontent.lastupdate,tcontent.summary,
tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
tcontentstats.comments, tparent.type parentType,
tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
FROM
tcontent
left Join tfiles on (tcontent.fileid=tfiles.fileid)
left Join tcontentstats on (tcontent.contentid=tcontentstats.contentid
and tcontent.siteid=tcontentstats.siteid)
Left Join tcontent tparent on (tcontent.parentid=tparent.contentid
and tcontent.siteid=tparent.siteid
and tparent.active=1)
Left Join tcontentfilemetadata on (tcontent.fileid=tcontentfilemetadata.fileid
and tcontent.contenthistid=tcontentfilemetadata.contenthistid
and tcontent.siteid=tcontentfilemetadata.siteid)
WHERE
tcontent.siteid in ('default')
and tcontent.active = 1
and tcontent.Approved = 1
AND tcontent.isNav = 1
AND tcontent.moduleid = '00000000000000000000000000000000000'
AND tcontent.searchExclude = 0
AND tcontent.contentid <> '00000000000000000000000000000000001'
AND tcontent.type <>'Module'
and (
tcontent.parentid
=
'27744B86-09D9-D228-67B8AC1B81117A2B'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-01 08:35:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-01 08:35:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-01 08:35:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-01 08:35:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
Like this post? Get a weekly email digest + member-only deals

Some of our Books

Faith & Humor
December 01, 2011

Faith & Humor

A book that dares to explore the humanity of priests and pilgrims, saints and sinners, Faith & Humor has been both a runaway bestseller in Russia and the focus of heated controversy – as often happens when a thoughtful writer takes on sacred cows. The stories, aphorisms, anecdotes, dialogues and adventures in this volume comprise an encyclopedia of modern Russian Orthodoxy, and thereby of Russian life.

Driving Down Russia's Spine
June 01, 2016

Driving Down Russia's Spine

The story of the epic Spine of Russia trip, intertwining fascinating subject profiles with digressions into historical and cultural themes relevant to understanding modern Russia. 

The Pet Hawk of the House of Abbas
October 01, 2013

The Pet Hawk of the House of Abbas

This exciting new trilogy by a Russian author – who has been compared to Orhan Pamuk and Umberto Eco – vividly recreates a lost world, yet its passions and characters are entirely relevant to the present day. Full of mystery, memorable characters, and non-stop adventure, The Pet Hawk of the House of Abbas is a must read for lovers of historical fiction and international thrillers.

 
Steppe
July 15, 2022

Steppe

This is the work that made Chekhov, launching his career as a writer and playwright of national and international renown. Retranslated and updated, this new bilingual edition is a super way to improve your Russian.

The Samovar Murders
November 01, 2019

The Samovar Murders

The murder of a poet is always more than a murder. When a famous writer is brutally stabbed on the campus of Moscow’s Lumumba University, the son of a recently deposed African president confesses, and the case assumes political implications that no one wants any part of.

The Little Humpbacked Horse
November 03, 2014

The Little Humpbacked Horse

A beloved Russian classic about a resourceful Russian peasant, Vanya, and his miracle-working horse, who together undergo various trials, exploits and adventures at the whim of a laughable tsar, told in rich, narrative poetry.

About Us

Russian Life is a publication of a 30-year-young, award-winning publishing house that creates a bimonthly magazine, books, maps, and other products for Russophiles the world over.

Latest Posts

Our Contacts

Russian Life
73 Main Street, Suite 402
Montpelier VT 05602

802-223-4955