[GRASS-user] Selecting entries in a vector map
neteler at osgeo.org
Mon Nov 11 14:12:41 PST 2013
On Fri, Oct 25, 2013 at 8:37 PM, Christopher Schroeder
<christopher at boozecarriage.com> wrote:
> I am new to grass, but not GIS (I was trained in ArcGIS in collage a year or
> so ago.) I feel like what I am trying to do is simple, yet I am not having
> any luck.
So let's hope to improve that :-)
> I have two vector maps, one of zipcodes in New York State, and one of New
> York counties. The goal is to have a map of New York City by zipcode. I
> was going to select the New York City counties that are NYC (the fine folks
> at the NYS gis repository already have this as a category in the County
> file.) Unfortunately, I cannot get past the first step. Trying to use the
> SQL query from the "GIS Attribute Table Manager" causes GRASS to crash (I'm
> using windows GRASS.)
Well, "this should not happen". Which version do you use exactly?
And this query?
> Using the selection option from d.vect causes it to
> display nothing. I'm not certain about the proper syntax for the SQL query,
> but I have tried all the obvious options. the field is called NYS and is
> Y/N. So as far as I can tell, the SQL query should be something like NYS =
> Y or NYS = "Y"
It depends on your DB backend. Unfortunately SQL is not SQL at 100%.
Please see also
> Do I need to install SQL under windows to have the SQL queries work?
No, nothing to install.
> It doesn't look like it as far as I can tell from the documentation. am I
> missing something with the SQL query? Is this a known bug?
We need to know you query for this and which DB backend you use.
Markus (travelling now)
More information about the grass-user