Dear,
I have a map in grass and I need to import datas in DBF format.
How I do this?
I'm working with GRASS 5.3, Conectiva Linux and Postgress 7.2.
I need to configure Postgress at GRASS? Where?
Please, send me step by step.
Thanks,
João
gruposig@uniplac.net
________________________________________________
Message sent using UebiMiau 2.7.8
Hi Joao,
in order to import shapes files and link them to PostgreSQL you should
follow these steps
1) IN POSTGRESQL: you need to create a database
(with the command createDB databasename )
2) IN GRASS: set a connection to such database
a) v.database driver=pg database="host=127.0.0.1, dbname=alfa,
user=yourusername" NOTICE that this works if you set postgreSQL to work
with the -i option (so the connection is through the IP localhost
127.0.0.1 )
b) db.connect driver=pg database="host=127.0.0.1, dbname=alfa,
user=yourusername" THIS open the connection
3) Import the shape files with File->import->vector or v.in....
However I'm not sure about "how good" are the database capabilities in
GRASS53, I suggest you to upgrade your system to GRASS54 or GRASS57
where the vector modules are supporting the connection with the
database.
Enjoy it
D.
Dear,
I have a map in grass and I need to import datas in DBF format.
How I do this?
I'm working with GRASS 5.3, Conectiva Linux and Postgress 7.2.
I need to configure Postgress at GRASS? Where?
Please, send me step by step.
Thanks,
João
gruposig@uniplac.net________________________________________________
Message sent using UebiMiau 2.7.8
-----------------------------------------
Stay ahead of the information curve.
Receive GIS news and jobs on your desktop daily.
Subscribe today to the GIS CafeNews newsletter.
[ http://www10.giscafe.com/nl/newsletter_subscribe.php ]
It's informative and essential.
Hi,
Most of these assume you have a shapefile, with the dbf
component containing the aspatial data.
The shapelib package includes dbfdump, which will extract the data in a
dbf file into a text file, which can be loaded into Postgres via a shell
script or reformatted & loaded using copy or other Postgres options. This
can be used with or without an accompanying shapefile, it just looks at
the dbf component.
The shp2pgsql package will take a shape file (including the dbf file) and
create a sql file which can be run by psql to create the table and load
all the dbf data as well as the geometry data into a PostGIS table.
ogr2ogr (part of the GDAL package, but deals with vector data) can take a
shapefile & dbf file & "reformat" into a PostGIS table.
QGIS (an open source GIS compatible with GRASS) has a plugin called SPIT
this is a GUI where you can select one or more shapefiles, point it at a
PostGIS database & the shape/dbf files will be imported into PostGIS
tables.
Hopefully one of these approaches will meet your needs.
Cheers,
Brent Wood
> Dear,
>
> I have a map in grass and I need to import datas in DBF format.
>
> How I do this?
>
> I'm working with GRASS 5.3, Conectiva Linux and Postgress 7.2.
>
> I need to configure Postgress at GRASS? Where?
>
> Please, send me step by step.
>
> Thanks,
>
> João
> gruposig@uniplac.net
>
>
>
> ________________________________________________
> Message sent using UebiMiau 2.7.8
>
>-----------------------------------------
Stay ahead of the information curve.
Receive GIS news and jobs on your desktop daily.
Subscribe today to the GIS CafeNews newsletter.
[ http://www10.giscafe.com/nl/newsletter_subscribe.php ]
It's informative and essential.