[postgis-users] How to change srid

[Fred Lehodey]

Hi,
UpdateGeometrySRID()
http://postgis.refractions.net/documentation/manual-1.5/UpdateGeometrySRID.html

Fred




2010/3/30 Marko Čubranić <mcubranic at gmail.com>

> thank you,
>
> i think this will help me.
>
> Marko
>
> 2010/3/30 Nicolas Gillet - MARKET-IP <nicolas.gillet at market-ip.com>
>
>   Hello,
>>
>>
>>
>> Editing the geometry_column table is half part of the job.
>>
>>
>>
>> You have to update the geometries too.
>>
>>
>>
>> UPDATE table SET the_geom  = ST_SetSRID(the_geom, 4326).
>>
>>
>>
>> Usually the SRID is -1 when you forget to set the srid when you import a
>> shape file.
>>
>>
>>
>> Hope this helps.
>>
>>
>>
>> Nicolas.
>>
>>
>>
>> *De :* postgis-users-bounces at postgis.refractions.net [mailto:
>> postgis-users-bounces at postgis.refractions.net] *De la part de* Marco
>> Lechner - FOSSGIS e.V.
>> *Envoyé :* mardi 30 mars 2010 9:00
>> *À :* postgis-users at postgis.refractions.net
>> *Objet :* Re: [postgis-users] How to change srid
>>
>>
>>
>> change the SRID in the geometry_columns table. There should be a
>> corresponding recordset defining the SRID, geometry type, geometry column
>> and so on of your table.
>>
>> Marco
>>
>> Am 30.03.2010 08:53, schrieb Marko Čubranić:
>>
>> dear,
>>
>> iv loaded data to postgis and for all geometry srid  is -1.
>> if i want to change srid without doing and transformations, can i do that
>> and how?
>>
>> Thank you,
>>
>> Marko Cubranic
>>
>>
>>
>>
>>
>> _______________________________________________
>>
>> postgis-users mailing list
>>
>> postgis-users at postgis.refractions.net
>>
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100330/b3feeada/attachment.html>