[Qgis-user] manually change FID/OID

Christian Röttger chris.roettger at web.de
Tue Mar 26 10:40:23 PDT 2013


Hi,

no, i want to do it the other way arround. the problem is that i want to 
change the FID value, which is generated by arcgis or qgis automatically 
(the grey numbers in the first column). i have already a column with id 
values. i want to assign the FID/OID with their values.

Am 26.03.2013 17:07, schrieb José Pedro Santos:
> Hi Christian,
>
> Why you don't create a new column with the ID values that you want? If
> you want to edit some columns or rows you can use the Field Calculator.
>
> Best Regards,
> José Santos
>
> ------------------------------------------------------------------------
> Date: Tue, 26 Mar 2013 16:59:08 +0100
> From: chris.roettger at web.de
> To: qgis-user at lists.osgeo.org
> Subject: [Qgis-user] manually change FID/OID
>
> Hi,
>
> i have the following problem: If i export a postgis db with qgis it
> mixes up the rows. On the first position in the attribute table is a
> value with id 2400 but should be 0 or 1
> e.g.
>        id      objectname
> 0 | 2400 | name 2400  ...
> 1 | 828   | name 828   ...
>
> When i inspect the database, everything seems to be ok, as the line with
> id =1 shows up on the top position and id is set as primary key.
> Has anybody an idea how i can get my table back in the right order or
> how to manually update the FID/OID with my id values?
>
> I need that for an geotools importer which reads the FID and i cant
> change the import parameters.
>
> Thanks christian
>
> _______________________________________________ Qgis-user mailing list
> Qgis-user at lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user




More information about the Qgis-user mailing list