My goal is to create an application in which I have 2 "types" of data that I will be querying against. I will have points and polygons. Ultimately I will be querying to find all of the polygons that a specific point exists in. I have downloaded the worlds admin level data, once in 6 separate shapefiles (one for each admin level), and in another instance, all in 1 shapefile (combining each admin level). I am also going to have to get different shapefiles from different sources besides GADM such as OSM, or census.gov.
Is it ideal to combine all of the polygon data into one table regardless of admin level, municipality, natural feature, etc, or to create a table for each potential type (adm1, adm1, locality, etc)?
My hunch is that combining them all makes the most sense because I wouldn't have to query a variable number of tables if I am looking for all of the polygons that a point lays within.
At the same time, I worry of such a potentially large table. Again, my goal is to load massive amounts of data into this table.
Has anyone done something similar to this, and can maybe shed some light on the problem?