Hi,
I have table with around 5 millions rows which I saved road's information on it. there is a field on the table which shows the road type like 'Motorway','ARoad', etc.
I want to shows specific roads on specific ZoomLevelSet.
For example: show Motorway on zoomelevel 1-5 and Motorway & ARoad on ZoomLevel 6-10 ,.... in the other word I want to show more details when we zoom in and less detail when zoom out.
Can I create different SQL-View and then use different datasource for different ZoomeLevelSet?
Would you please suggest me a way to do this?
Regards,
Ben