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.766 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-02 13:50:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 13:50:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 13:50:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 13:50: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

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. 

Survival Russian
February 01, 2009

Survival Russian

Survival Russian is an intensely practical guide to conversational, colloquial and culture-rich Russian. It uses humor, current events and thematically-driven essays to deepen readers’ understanding of Russian language and culture. This enlarged Second Edition of Survival Russian includes over 90 essays and illuminates over 2000 invaluable Russian phrases and words.

93 Untranslatable Russian Words
December 01, 2008

93 Untranslatable Russian Words

Every language has concepts, ideas, words and idioms that are nearly impossible to translate into another language. This book looks at nearly 100 such Russian words and offers paths to their understanding and translation by way of examples from literature and everyday life. Difficult to translate words and concepts are introduced with dictionary definitions, then elucidated with citations from literature, speech and prose, helping the student of Russian comprehend the word/concept in context.

Fearful Majesty
July 01, 2014

Fearful Majesty

This acclaimed biography of one of Russia’s most important and tyrannical rulers is not only a rich, readable biography, it is also surprisingly timely, revealing how many of the issues Russia faces today have their roots in Ivan’s reign.

Russian Rules
November 16, 2011

Russian Rules

From the shores of the White Sea to Moscow and the Northern Caucasus, Russian Rules is a high-speed thriller based on actual events, terrifying possibilities, and some really stupid decisions.

The Latchkey Murders
July 01, 2015

The Latchkey Murders

Senior Lieutenant Pavel Matyushkin is back on the case in this prequel to the popular mystery Murder at the Dacha, in which a serial killer is on the loose in Khrushchev’s Moscow...

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