Hey Rich, I'm a newbie myself, but it seems to me that you either need a table that defines the geometry of the continents (so that you can do a spatial join with the points), or the points table itself needs a column which tells you in which continent that point is located. Do you have either of these at the moment?
Cheers James On 10 July 2011 20:34, Rich B <[email protected]> wrote: > Hello all, > > I have a newbie question for you guys…here goes : > > > > I have a large dataset (a geonames world data-dump) that I’ve imported into > Postgis. > > I want to know how to do a Spatial Join with this dataset so that I can > split the millions of points up into chunks by continent. > > For example : > > A user connects to the database in QGIS and wants to select all of the > cities (I’m going to trim the data down a little more using a query later > on) and they want to bring in only the points that fall in Europe or Africa. > > In a nutshell I want a user to select all the points by continent instead of > loading the whole dataset. > > > > I’m sure there’s an easy way to do this , and I’m probably going to slap > myself for not thinking of this earlier. > > I’m relatively new to OSGIS and I’m getting the hang of it. I’ve been an > ESRI guy for a while. > > > > Thanks in advance for the feedback. > > > > Cheers!!! > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
