[postgis-users] pgsql2shp usage
Paragon Corporation
lr at pcorp.us
Mon Jan 11 01:08:32 PST 2010
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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Anisha
Kaul
Sent: Monday, January 11, 2010 2:23 AM
To: postgis-users at postgis.refractions.net
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
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list