<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><font style="font-size:10pt;" color="#000000" size="2" face="Courier New,sans-serif">That's interesting Thomas. Hadn't really noticed that before, but when I add in feature classes in the same manner, I can see the OBJECTID for some but not others. Seems random at the moment...<br></font><div id="inlineImage0" style="display: inline-block"><script type="jsv#990_"></script> <span contenteditable="true"></span> <div initwidth="1036" initheight="455" class="inlineImage" style="display: inline-block" unselectable="on" contenteditable="false"><img src="cid:inlineImage0" height="455" width="1036"></div> <span contenteditable="true"> </span><script type="jsv/990_"></script></div><font style="font-size:10pt;" color="#000000" size="2" face="Courier New,sans-serif"><br></font>James<br><br><div>> Date: Wed, 16 Dec 2015 14:04:51 +0100<br>> From: t.schuettenberg@mailbox.org<br>> To: qgis-user@lists.osgeo.org<br>> Subject: [Qgis-user] FileGDB: missing FID column<br>> <br>> 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>> <br>> -- <br>> QGIS-DE e.V. | http://qgis.de<br>> _______________________________________________<br>> Qgis-user mailing list<br>> Qgis-user@lists.osgeo.org<br>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user<br>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user<br></div> </div></body>
</html>