How to identify if Environmental Zones are only for commercial vehicle applicable?

How to identify if Environmental Zones are only for commercial vehicle applicable?

Currently it is not possible to recognize from the documentation whether an environmental zone applies only to commercial vehicles.

In the product release information of the environmental zones xml you will only find a listing of all environmental zone names, the EZ ID and the country information. It is not possible to recognize if these only apply to cars or commercial vehicles:



But there is a possibility in RDF to find out this information using the EVZ polygone restriction.

An Environmental Zone is optionally provided with a corresponding Environmental Zone Polygon. The Polygon Restriction in table RDF_CARTO identifies whether the polygon applies to passenger cars or to trucks only. Polygon Restriction can be used to selectively filter Environmental Zone polygons not relevant for the user's profile.

For example, a driver of a passenger car may not be interested in having each truck-only Environmental Zone polygon in the map display.



With the help of the following SQL query, you can easily filter out the relevant information:

select
rc.carto_id,
rc.polygon_restriction,
rfn2.language_code,
rfn2."name"
from rdf_carto rc
inner join rdf_feature_names rfn on rfn.feature_id = rc.carto_id
inner join rdf_feature_name rfn2 on rfn2.name_id = rfn.name_id
where rc.feature_type = '9997010'



To filter out the EVZ Meta Data information from RDF, you can use:

select * from rdf_meta rm

where table_name = 'RDF_CONDITION_ENV_ZONE'

Attached the complete listing for EU 221G0 (Q422).