Re: [gdal-dev] ogr2ogr SQL Date Calculation

2011-07-11 Thread Michael Shishcu
Hi Robert, there is a Date command for windows commandline http://ss64.com/nt/date.html hope this helps regards, michael On Mon, Jul 11, 2011 at 6:11 PM, Langford, Robert < robert.langf...@salford.gov.uk> wrote: > All, > > I am trying to use ogr2ogr as a scheduled command line task to run wee

Re: [gdal-dev] OCI: ogrinfo from normal table

2010-11-15 Thread Michael Shishcu
Hi Sebastian maybe Select T.Entry_Id id, SDO_GEOMETRY(2001,8307,SDO_ POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL)* AS* geom From Lookupindex T; ? regards, michael On 15 November 2010 17:46, Sebastian E. Ovide wrote: > Hi All, > > I have a table which has an X and Y columns. It doesn't hav

Re: [gdal-dev] ogr2ogr OCI: ORA-13349 and ORA-13356

2010-10-11 Thread Michael Shishcu
I mean, you have points in your shape(s) too close to each other. When you are importing them, oracle "interprets" them as the same point (ORA-13356) or overlapping ones (ORA-13349). ways to escape - "simplify" your shapes - delete adjacent points (too close ones) - change your metadata for the lay

Re: [gdal-dev] ogr2ogr OCI: ORA-13349 and ORA-13356

2010-10-11 Thread Michael Shishcu
Also, this can be caused by too big tolerance of your coordinates, check this in your metadata regards, michael On 11 October 2010 12:28, Sebastian E. Ovide wrote: > Hi All, > > Importing shapes into Oracle I'm getting not valid geometrie: ORA-13349 and > ORA-13356. > > No problem importing the