I want to create a new shapefile from an existing one.
I would like to create a new shapefile for next level of geo hierarchy (say regions) by grouping some of features (states) from the existing shapefile.
I have a CSV file which contains the geo hierarchy relationship (i.e., which all states to be combined to form a region).
- Imported the CSV file as a text delimited layer
- Joined it with the existing shapefile
- Using "Select Features using Expression" I am able to select all the sales which forms the particular region
- Then I went to Edit-->Merge Selected features to merge the selected featues (states) to form the region
Doing so I was able to create one region but since I want to create 100 regions by joining several states, is there not an automated way like using some SQL, etc., wherein I can create a group by query to group various states (features)? And also one region could overlap with another i.e. one state can belong to two-three regions, is it possible to have a overlapping shares layered over each other?