<div dir="ltr"><div style="font-size:12.8px"><div><div>Hi!<br></div>Do not rely on the ESRI FID/ObjectID for any external purpose. <br></div>It must be treated and considered as an internal ESRI geodatabase parameter, and can be unpredicatbly rewritten any time by ESRI processes. This goes for gdb tables as well as shapefiles. Of course, if you completely externalise the data, and never intend to link it back or use it in its original environment, you can keep the FID and use it for your own purposes. But since it is never more than a random integer, it may be even better to create a UID yourself. If you do this in the original table you can safely rely on that UID even if the ESRI FID is rewritten.<br></div><div style="font-size:12.8px">It may be by purpose that you do not see the FID in QGIS, because of the above.</div><span style="font-size:12.8px">Here is a similar question from a while back. Read the helpful replies.</span><br style="font-size:12.8px"><a href="http://gis.stackexchange.com/questions/72495/how-to-copy-table-in-arcgis-for-desktop-and-keep-same-feature-id-objectid" target="_blank" style="font-size:12.8px">http://gis.stackexchange.com/questions/72495/how-to-copy-table-in-arcgis-for-desktop-and-keep-same-feature-id-objectid</a><br></div><div class="gmail_extra"><br><div class="gmail_quote">2015-12-16 14:04 GMT+01:00 Thomas Schüttenberg <span dir="ltr"><<a href="mailto:t.schuettenberg@mailbox.org" target="_blank">t.schuettenberg@mailbox.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi!<br>
<br>
please can anybody tell me why the FID column of a fileGDB-Layer is ignored and not shown in QGIS?<br>
<br>
I added a fileGDB via add vector layer>directory>type OpenFileGDB or ESRI-FileGDB and everything<br>
works fine and fast.<br>
But when looking at the attribute table or the layer propeties the column "objectid" is not there<br>
although it is part of the data (see ogrinfo below). I tested this with 2.8.4 and 2.12.1<br>
<br>
The actual reason to fumble with the FileGDB is, that i want to transfer this data to my PG. In this<br>
import process (e.g. OGR processing "Import Vector into PostGIS database") however the FID column is<br>
also ignored.<br>
A (new) FID/PK-column, that can be created during import is always filled with fresh serial values -<br>
not the original IDs from the data source -even when their name are the same.<br>
<br>
The only way I see to solve / by-pass this (in my use case) is to duplicate the objectids to a new,<br>
seperate field befor doing the ogr-import.<br>
<br>
But maybe some of you could suggest a better solution (and save me from the manual<br>
table-editing-pain? ;-)<br>
<br>
thanks in advance<br>
Thomas<br>
<br>
C:\Windows\System32>ogrinfo -so c:\zeug\kanal_end.gdb KaAnschlusspunkt<br>
Had to open data source read-only.<br>
INFO: Open of `c:\zeug\kanal_end.gdb'<br>
using driver `OpenFileGDB' successful.<br>
<br>
Layer name: KaAnschlusspunkt<br>
Geometry: Point<br>
Feature Count: 3377<br>
Extent: (8.300000, 11.186000) - (371550.148000, 5663269.606000)<br>
Layer SRS WKT:<br>
PROJCS["ETRS89 / UTM zone 32N",<br>
GEOGCS["ETRS89",<br>
DATUM["European_Terrestrial_Reference_System_1989",<br>
SPHEROID["GRS 1980",6378137,298.257222101,<br>
AUTHORITY["EPSG","7019"]],<br>
TOWGS84[0,0,0,0,0,0,0],<br>
AUTHORITY["EPSG","6258"]],<br>
PRIMEM["Greenwich",0,<br>
AUTHORITY["EPSG","8901"]],<br>
UNIT["degree",0.0174532925199433,<br>
AUTHORITY["EPSG","9122"]],<br>
AUTHORITY["EPSG","4258"]],<br>
PROJECTION["Transverse_Mercator"],<br>
PARAMETER["latitude_of_origin",0],<br>
PARAMETER["central_meridian",9],<br>
PARAMETER["scale_factor",0.9996],<br>
PARAMETER["false_easting",500000],<br>
PARAMETER["false_northing",0],<br>
UNIT["metre",1,<br>
AUTHORITY["EPSG","9001"]],<br>
AXIS["Easting",EAST],<br>
AXIS["Northing",NORTH],<br>
AUTHORITY["EPSG","25832"]]<br>
FID Column = OBJECTID<br>
Geometry Column = Shape<br>
PunktNr: String (0.0)<br>
Punktkennung: String (0.0)<br>
Kanalart: String (0.0)<br>
...<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
QGIS-DE e.V. | <a href="http://qgis.de" rel="noreferrer" target="_blank">http://qgis.de</a><br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr">______________________________________________<br>Mats Elfström, Väpplingvägen 21, SE-227 38 LUND, Sweden<br>tel: +46 46 145959 / mob: +46 70 595 39 35<br>alt e-mail: <a href="mailto:mats.elfstrom@telia.com" target="_blank">mats.elfstrom@giskraft.com</a><br><br></div></div>
</div>