Hi,
I have not tied this myself but what happens if you make a view in the
db which orders your data by id like
CREATE VIEW ordered_view AS
SELECT * FROM table
ORDER BY id;
and load that into QGIS?
Bernhard
Am 27.03.2013 10:29, schrieb José Pedro Santos:
I don't understand exactly why you want to change the ID number but be
careful doing that, like Stefano said and correctly, you can corrupt the
all table.
Best Regards,
Jose Santos
------------------------------------------------------------------------
Date: Tue, 26 Mar 2013 18:45:12 +0100
From: [email protected]
To: [email protected]
CC: [email protected]
Subject: Re: [Qgis-user] manually change FID/OID
Maybe I misunderstood what are you trying to do, just be aware that
manually modifying FID or OID in a shapefile or geoDb feature class is
likely to corrupt them.
Cheers,
Stefano
Il giorno 26/mar/2013 18:40, "Christian Röttger" <[email protected]
<mailto:[email protected]>> ha scritto:
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: [email protected] <mailto:[email protected]>
To: [email protected] <mailto:[email protected]>
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
[email protected] <mailto:[email protected]>
http://lists.osgeo.org/__mailman/listinfo/qgis-user
<http://lists.osgeo.org/mailman/listinfo/qgis-user>
_________________________________________________
Qgis-user mailing list
[email protected] <mailto:[email protected]>
http://lists.osgeo.org/__mailman/listinfo/qgis-user
<http://lists.osgeo.org/mailman/listinfo/qgis-user>
_______________________________________________ Qgis-user mailing list
[email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
__________ Information from ESET Mail Security, version of virus signature
database 8166 (20130327) __________
The message was checked by ESET Mail Security.
http://www.eset.com
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
