Re: [GRASS-user] sql join in v.extract

2016-06-21 Thread Tyler Smith
To answer my own questions: > 1. Is there a way to use a complex sql statement (i.e., that includes a > join directive) in v.extract? Maybe not? > 2. If not, is the most sensible approach here to collect the output of > db.select in a python script and use that to generate the corresponding > wh

[GRASS-user] sql join in v.extract

2016-06-21 Thread Tyler Smith
Hi, I have a large vector shapefile, 'UTM_1KM_GRID', and a separate, large sql table, "EOs". The 'ATLAS_83' column in 'UTM_1KM_GRID' contains a unique name for each polygon in the shapefile. The 'SQUARE1KM' column in "EOs" contains the same names, such that the tables can be joined "1 to many": UT