[GRASS-user] Importing data w/o coordinates

GRASS GRASS user
1

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.

2

Hi Ken,

Try: https://grass.osgeo.org/grass70/manuals/db.in.ogr.html
and then: https://grass.osgeo.org/grass70/manuals/v.db.join.html

Cheers
Stefan

3

* Ken Mankoff:

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.

The examples at https://grass.osgeo.org/grass70/manuals/v.db.join.html
should be really useful.

Nikos