<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body text="#000000" bgcolor="#FFFFFF">
hello list-members<br>
<br>
<p>I can read my FileGDB (ArcGIS 10.1) with GDAL-library (1.10)
using ogrinfo and sql filtering datasets by FID</p>
<pre style="" class="lang-sql prettyprint prettyprinted"><code><span class="pln">ogrinfo </span><span class="str">"...\test.gdb"</span><span class="pln"> </span><span class="pun">-</span><span class="pln">sql </span><span class="str">"SELECT edited FROM 'plz_simple_copy' WHERE fid = 1864"</span><span class="pln"> </span><span class="com">--debug on -dialect OGRSQL</span></code></pre>
<p>or this way by OBJECTID</p>
<pre style="" class="lang-sql prettyprint prettyprinted"><code><span class="pln">ogrinfo </span><span class="str">"...\test\plz.gdb"</span><span class="pln"> </span><span class="str">"plz_simple_copy"</span><span class="pln"> </span><span class="pun">-</span><span class="kwd">where</span><span class="pln"> OBJECTID</span><span class="pun">=</span><span class="lit">1864</span></code></pre>
<p>The result is:</p>
<pre style="" class="lang-sql prettyprint prettyprinted"><code><span class="kwd">using</span><span class="pln"> driver </span><span class="pun">`</span><span class="pln">FileGDB</span><span class="str">'</span><span class="pln"> successful</span><span class="pun">.</span><span class="pln">
Layer name</span><span class="pun">:</span><span class="pln"> plz_simple_copy
Geometry</span><span class="pun">:</span><span class="pln"> Multi Polygon
</span><span class="pun">.....</span><span class="pln">
plz </span><span class="pun">(</span><span class="pln">String</span><span class="pun">)</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">26452</span><span class="pln">
quelle </span><span class="pun">(</span><span class="pln">String</span><span class="pun">)</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> osm
osm_id </span><span class="pun">(</span><span class="pln">String</span><span class="pun">)</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">-1187754</span><span class="pln">
edited </span><span class="pun">(</span><span class="pln">DateTime</span><span class="pun">)</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">2013</span><span class="pun">/</span><span class="lit">07</span><span class="pun">/</span><span class="lit">09</span><span class="pln"> </span><span class="lit">17</span><span class="pun">:</span><span class="lit">34</span><span class="pun">:</span><span class="lit">49</span><span class="pln">
Shape_Length </span><span class="pun">(</span><span class="pln">Real</span><span class="pun">)</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">0.401490815379519</span><span class="pln">
Shape_Area </span><span class="pun">(</span><span class="pln">Real</span><span class="pun">)</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">0.00612509834536042</span></code></pre>
<p>...but I need to filter the data by the date field "edited". I
tried a lot of variations e.g.</p>
<pre style="" class="lang-sql prettyprint prettyprinted"><code><span class="pln">ogrinfo </span><span class="str">"...\test.gdb"</span><span class="pln"> </span><span class="str">"plz_simple_copy"</span><span class="pln"> </span><span class="pun">-</span><span class="kwd">where</span><span class="pln"> edited </span><span class="pun">=</span><span class="pln"> </span><span class="str">'2013/07/09 17:34:49'</span><span class="pln">
ogrinfo </span><span class="str">"...\test.gdb"</span><span class="pln"> </span><span class="str">"plz_simple_copy"</span><span class="pln"> </span><span class="pun">-</span><span class="kwd">where</span><span class="pln"> edited </span><span class="pun">=</span><span class="pln"> </span><span class="str">'2013-07-09 17:34:49'</span><span class="pln">
ogrinfo </span><span class="str">"...\test.gdb"</span><span class="pln"> </span><span class="str">"plz_simple_copy"</span><span class="pln"> </span><span class="pun">-</span><span class="kwd">where</span><span class="pln"> </span><span class="str">"edited"</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> date </span><span class="str">'2013-07-09 17:34:49'</span></code></pre>
<p>.. but I didn't get it. Somebody has an idea how to solve that
problem?</p>
<p>best greetings from Berlin ralf</p>
</body>
</html>