[GRASS-user] Importing data w/o coordinates

[Ken Mankoff]

Hi List,

I have a CSV data set without coordinates, but a FIPS code, that I need to join with another dataset (already in GRASS, with FIPS).

In grass I have,

> db.select table=county | head -n5 | column -s"|" -t
cat  NHGISNAM  STATENAM        FIPS   foo bar baz x y z
1    Smith     Kansas          20183
2    Holmes    Ohio            39075
3    Pamlico   North Carolina  37137
4    Gratiot   Michigan        26057

And elsewhere I have CSV with, for example,

FIPS,  unit,value
20183, foo, 1
20183, bar, 2
20183, z,   99
39075, foo, 1
37137, bar, 2
37137, baz, 3
37137, x,   4
37137, y,   5

Can someone advise how I'd join these tables? I can't even figure out how to import the CSV because it doesn't have coordinates. I usually work with rasters, and am unclear how to best work with this vector data set.

Thanks,

  -k.