Thank you! Yes I do have both of those datasets. I'll run the spatial join that way and see what happens. *fingers crossed*
On Jul 11, 2011, at 5:20 AM, James David Smith <[email protected]> wrote: > 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
