Hi again,
Continuing from the following mail :
https://lists.berlios.de/pipermail/mapnik-users/2010-January/002746.html
I checked the man page of the command "pgsql2shp". It says that the specified
table should contain "spatial data"
.
I droped the database gis and then re-created it !
and issued the command:
"osm2pgsql -m -d gis east-090527.osm.bz2"
Now "gis" contains the following:
__________________________________________________________________
gis=# \d
List of relations
Schema | Name | Type | Owner
--------+--------------------+-------+--------
public | geometry_columns | table | anisha
public | planet_osm_line | table | anisha
public | planet_osm_point | table | anisha
public | planet_osm_polygon | table | anisha
public | planet_osm_roads | table | anisha
public | spatial_ref_sys | table | anisha
(6 rows)
gis=# SELECT * from geometry_columns;
f_table_catalog | f_table_schema | f_table_name | f_geometry_column |
coord_dimension | srid | type
-----------------+----------------+--------------------+-------------------+-----------------+--------+------------
| public | planet_osm_point | way |
2 | 900913 | POINT
| public | planet_osm_line | way |
2 | 900913 |
LINESTRING
| public | planet_osm_polygon | way |
2 | 900913 | GEOMETRY
| public | planet_osm_roads | way |
2 | 900913 |
LINESTRING
(4 rows)
gis=# SELECT count(*) from planet_osm_point;
count
-------
28756
(1 row)
gis=# SELECT count(*) from planet_osm_polygon;
count
-------
7993
(1 row)
gis=# SELECT count(*) from planet_osm_roads;
count
-------
14384
(1 row)
gis=# SELECT count(*) from planet_osm_line;
count
--------
104805
(1 row)
gis=# SELECT count(*) from geometry_columns;
count
-------
4
(1 row)
_________________________________________________________________________________________
Problem statement:
The "spatial_ref_sys" table doesn't contain any geometry column, is it ok ?
Which table should I specify with "pgsql2shp" command so that the data gets
converted in a shape file !
Kindly guide !
--
Regards,
Anisha Kaul
-------------------------------------
Hi-Tech Gears Limited, Gurgaon, India
_______________________________________________
Mapnik-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/mapnik-users