I've replaced the <span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; ">-lco 27700 with -a_srs EPSG:27700</span><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><br>
</span></font></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">now <span class="Apple-style-span" style="font-size: 13px; ">select ST_SRID(wkb_geometry) from sebas </span></span></font></div>
<div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><br></span></font></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">gives 4... </span></font></div>
<div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><br></span></font></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">any ideas ?<br>
</span></font><br><div class="gmail_quote">On Tue, Nov 30, 2010 at 10:59 AM, Even Rouault <span dir="ltr"><<a href="mailto:even.rouault@mines-paris.org">even.rouault@mines-paris.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Selon "Sebastian E. Ovide" <<a href="mailto:sebastian.ovide@gmail.com">sebastian.ovide@gmail.com</a>>:<br>
Sebastian,<br>
<br>
The option "-lco 27700" has no effect. The correct syntax would be something<br>
like "-lco SRID=27700", but there's no such option, so don't loose your time<br>
trying that ;-)<br>
<br>
The SRID is set automatically by comparing the SRS of the source layer with what<br>
exists in the spatial_ref_sys table (or the one you can set with the -a_srs<br>
EPSG:27700 as suggested by Jorge). If there's a match, then the SRID from<br>
spatial_ref_sys will be used. Otherwise the PG driver will add a new entry in<br>
the spatial_ref_sys table (and the SRID number will not be equal to the EPSG<br>
code). Make sure you've filled the spatial_ref_sys table<br>
with the appropriate PostGIS .sql script. The '3' you get sounds like the<br>
spatial_ref_sys table of this database was empty and that the PG driver added<br>
new entries in it.<br>
<br>
Best regards,<br>
<div><div></div><div class="h5"><br>
> Hi All,<br>
><br>
> I've just uploaded a shape with<br>
><br>
> ogr2ogr -f PostgreSQL "PG:dbname='gis' host='10.0.1.40' port='5432'<br>
> user='gis' password='gis'" sebas.shp -lco 27700 -lco PRECISION=NO -progress<br>
> -lco OVERWRITE=yes -lco dim=2 -nln sebas -overwrite<br>
><br>
> but from<br>
><br>
> select ST_SRID(wkb_geometry) from sebas;<br>
><br>
> I'm getting 3<br>
><br>
> (with<br>
><br>
> select ST_SRID(ST_SetSRID(wkb_geometry,27700)) from sebas;<br>
><br>
> I'm getting the right value )<br>
><br>
> any ideas ?<br>
><br>
><br>
><br>
> --<br>
> Sebastian E. Ovide<br>
><br>
<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Sebastian E. Ovide<br><br><br><br><br>
</div>