1. I have CollisionDetection enabled with Priority Column. But that does not help my situation as that helps only collision not filtering out data.
2. I used ogr2ogr to reduce some unwanted columns and records. from the ShapeFile
I am using the new ShapeFile for the label layer. It still has 35k data. I do not want to reduce it further.
I need to have some method to keep this ShapeFile intact, but setup a column with a Y/N and load/display only those labels that have a Y.
This way the customer can keep adding & deleting the cities as the need arises.
When you said
<QUOTE> create views (DataBase) and pass their name as table name </QUOTE>
Do you mean port the shapefile to SQL database & set a filter there & load only required labels?
If so, what is a good tool to convert the ShapeFile to SQL?