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

Reply via email to