It sounds like your spatial_ref_sys table is empty. Load it up with the entries in spatial_ref_sys.sql
Hope that helps, Regina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Anisha Kaul Sent: Monday, January 11, 2010 2:23 AM To: [email protected] Subject: Re: [postgis-users] pgsql2shp usage Hi, Many thanks to all of you for bothering to reply !! >From Chris Hermansen > Anisha, why are you converting to shape file? I failed to load the map directly from the database ! So I thought it will be a boostup for me if I manage to load the map from a shape file, and then I can go for the database reading ! I didn't have any problem in loading a world map from a shape file directly downloaded from the internet, but I am facing problems when I convert the postgres data in a shape file and then try to load it. >From Regina > Never worked with osm data, but since I created the .prj generator in > pgsql2shp, I can tell you it reads the srid of the geometry and looks > up the > srtext in spatial ref and outputs that to the .prj file. > I suspect osm data is in Mercator not long lat. If you want your > output to be in long lat, you need to transform and use an sql > statement > pgsql2shp -f "/path/to/filename" -h myserver -u apguser -P apgpassword > mygisdb > "SELECT field1 AS hs_num, field2...., ST_Transform(the_geom,4326) As > the_geom FROM planet_osm_line" I tried what u said as follows: ______________________________________________ pgsql2shp -f ../data/myfile gis "SELECT *, ST_Transform(way,4326) As the_geom FROM planet_osm_line" Output: Preparing table for user query... Failed: ERROR: AddToPROJ4SRSCache: Cannot find SRID (4326) in spatial_ref_sys ______________________________________________ Then With reference to this http://postgis.refractions.net/pipermail/postgis-users/2008-February/018486. html web page I executed the following in the postgres database ______________________________________________ gis=# SELECT UpdateGeometrySRID ('public', 'planet_osm_polygon','way', 4236); Output: ERROR: constraint "enforce_srid_way" of relation "planet_osm_polygon" does not exist CONTEXT: SQL statement "ALTER TABLE public.planet_osm_polygon DROP constraint enforce_srid_way" PL/pgSQL function "updategeometrysrid" line 53 at EXECUTE statement SQL statement "SELECT UpdateGeometrySRID('', $1 , $2 , $3 , $4 )" PL/pgSQL function "updategeometrysrid" line 4 at SQL statement ______________________________________________ I don't know what to do now, please guide ! -- Regards, Anisha Kaul ------------------------------------- Hi-Tech Gears Limited, Gurgaon, India _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
