Hi Andreas.
Try with:
SELECT UpdateGeometrySRID('groads2', 'geom', 4326);
Regards,
El 16/06/2011 10:23, Andreas Forø Tollefsen escribió:
Hi,
I have merged 4 tables with line geometry. In total 1028110 rows.
However, when i had unionized the tables, i realized that i had forgot
to set the SR
Hi,
I'm a novice, but shouldn't it be something like this... ?
UPDATE table SET geom = ST_SetSRID(geom, 4326)
Cheers
James
On 16 June 2011 09:23, Andreas Forø Tollefsen wrote:
> Hi,
>
> I have merged 4 tables with line geometry. In total 1028110 rows.
> However, when i had unionized the table
Hi,
I have merged 4 tables with line geometry. In total 1028110 rows.
However, when i had unionized the tables, i realized that i had forgot
to set the SRID for 2 of the tables.
Hence, I now have a table where half of the roughly half a million
rows have a SRID.
I then tried to run the UpdateGeom
hello
why does this error occur ?
bzk2=# select updategeometrySRID('shey7','wkb_geometry',32636);
ERROR: column not found in geometry_columns table
CONTEXT: SQL statement "SELECT UpdateGeometrySRID('','', $1 , $2 ,
$3 )"
PL/pgSQL function "updategeometrysrid" line 4 at SQL statement
--
This