Naming Convention for Israel street names

[talkat]

@talba

@talkat

or by breaking basic IT rules, like having the data in the DB in a normalized way.

Can you please explain what do you mean by that sentence?
If you meant that is it ok to assume that every residential/unclassified street that does not start with “sderot”, “derech” etc. is a “rechov” - that is false.
For example, “Razif Herbert Samuel” in Tel Aviv has no “rechov” in its full name. But it would probably be too dangerous to assume that any street that starts with “Razif” has no “rechov” in the beginning of its full name.

If that was not your intention, then excuse me, and please explain.

I mean:
“Rehov” (or “Sdera”, or "Derech, for that matter) is not part of the name of the way.
You can see it as some feature (or “type”) of the way.

That means, that in a normalized DB, we will have a table of all way name features (rehov, derech, simta, etc.) and in the ways table, there will be a column that points to that table.