Tagged Questions
4
votes
2answers
5k views
Adding shapefiles to PostGIS database
I was able to create a Postgresql database and then I executed,
createlang plpgsql geospecies
psql -d geospecies -f postgis.sql
psql -d geospecies -f spatial_ref_sys.sql
So now can I directly ...
6
votes
3answers
1k views
How to load OSM data into PostGIS preserving all Tags?
I am new to the field of GIS and am trying to view source tags in OSM. I have downloaded the shapefiles from http://downloads.cloudmade.com and have loaded them into Postgres. When I view the data, I ...
1
vote
0answers
32 views
How to load or query data directly to R from a PostGIS database using RPostgreSQL and rgdal [duplicate]
Is it possible to load/query a shapefile to R, which is stored in a postgres/postgis database? I've built up a connection to my postgres database via DBI, RPostgreSQL and I want to make some ...
1
vote
2answers
170 views
How to remove shapefile from PostGIS
I added a shapefile to the PostGIS using,
ogr2ogr -f PostgreSQL PG:"host=server_ip user=username dbname=dbname password=password" yourshapefile.shp;
Now I want to remove it. What is the command ...
