I am very new to this so please only smile if a dumb question. I have divided the oceans into 31 regions. Each region has various sub regions, example I have region 08; of which it is further broken down to region 0801; region 0802....
Also, my end game is having all of this data in a SQLite database for use in an iOS APP.
I have already defined these regions and subregions in Google Earth. I am exported them into kml format and know how to import them. However, two questions:
I am not sure if it is better to create one shape, called Region 08 and have this shape with categories equaled to the sub regions. I am not sure if the db or app can see each category within a shape; or do I need to import each region and subregion as an individual shape.
My database has two tables, RL_Regions and RL_Subregions. All of the data is there (already imported from Google earth). Is it easier to extract the data from the db and create shapes, or to create the shapes first and add to the db?
I really have tried to research this on my own, but nothing seems to match with what I need. Unfortunately, the app is nearly completed and I do not have the luxury of flexibility with the db design.