[gdal-dev] Oracle GeoRaster loading problem

2010-07-08 Thread Pasta Bolognese
Hi All, after loading a raster, I've did the traditional SELECT id, sdo_geor.validategeoraster(georaster) isvalid from arcviewgrid; and I've got: 1 13454 (http://ora-13454.ora-code.com/) therefore I've run SELECT sdo_geor.schemaValidate(georaster) from arcviewgrid; ORA-31154: invalid XML docu

Re: [gdal-dev] Oracle GeoRaster loading problem

2010-07-08 Thread Pasta Bolognese
ooo... is there any workaround ? Even any query to run in order to fix the XML... ? On Thu, Jul 8, 2010 at 5:11 PM, Ivan Lucena wrote: > See http://trac.osgeo.org/gdal/ticket/3673 > > > ---Original Message--- > > From: Pasta Bolognese > > To: gdal-dev@list

Re: [gdal-dev] Oracle GeoRaster loading problem

2010-07-09 Thread Pasta Bolognese
alue > ranges as nodata but you can do it with just one value as nodata too. That > fix will be available > shortly on GDAL trunk. > > Pasta Bolognese wrote: > > ooo... is there any workaround ? > > > > Even any query to run in order to fix the XML... ? &g

[gdal-dev] Oracle GeoRaster is not setting setModelSRID ?

2010-07-09 Thread Pasta Bolognese
Hi All, If I run gdalinfo "C:\mymodel" I can see ... ... Coordinate System is: PROJCS["OSGB 1936 / British National Grid", ... ... then, loading the model into Oracle with gdal_translate -of georaster "C:\mymodel" georaster:user/password,db,geoserver.ARCVIEWGRID,georaster -co "DESCRIPTION=(ID NU

Re: [gdal-dev] Oracle GeoRaster is not setting setModelSRID ?

2010-07-11 Thread Pasta Bolognese
What I mean is that If I can read the coordinate system (BNG), why then I am forced to set it MANUALLY ? (using -co SRID=81989 to assigned that SRID to the GeoRaster ob for example)... I know that I can run a script, get the name of the coordinate system, query the DB to get its number and then us

Re: [gdal-dev] Oracle GeoRaster is not setting setModelSRID ?

2010-07-12 Thread Pasta Bolognese
In that case, is there any way I can rise a ticket for it ? On Mon, Jul 12, 2010 at 12:57 AM, Ivan Lucena wrote: >>  What I mean is that If I can read the coordinate system (BNG), why >>  then I am forced to set it MANUALLY ? (using -co SRID=81989 to >>  assigned that SRID to the GeoRaster ob for

[gdal-dev] GeoRaster: problem updating on predefined existing table

2010-07-12 Thread Pasta Bolognese
Hi All, following http://www.gdal.org/frmt_georaster.html I've imported a small immage using: C:\>gdal_translate -of georaster c:\tmp\map.png georaster:geoserver/geoserver,MFDEVDB and it works well. Then I've imported another immage using the same command and it worked well too ! Then I have d

Re: [gdal-dev] GeoRaster: problem updating on predefined existing table

2010-07-12 Thread Pasta Bolognese
> > > >  C:\>gdal_translate -of georaster  c:\tmp\map.png > >  georaster:geoserver/geoserver,MFDEVDB > > > >  and it works well. Then I've imported another immage using the same > >  command and it worked well too ! > > Note that you didn't specify table & column so a table named "GDAL_IMPORT", >

Re: [gdal-dev] GeoRaster: problem updating on predefined existing table

2010-07-12 Thread Pasta Bolognese
SERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))" It is using the table PASTA _RASTERSThis would work all the time.. Is it working as expected ? On Mon, Jul 12, 2010 at 2:54 PM, Pasta Bolognese wrote: >> > >> >  C:\>gdal_translate -of georaster  c:\tmp\map.png >> >  ge

Re: [gdal-dev] GeoRaster: problem updating on predefined existing table

2010-07-13 Thread Pasta Bolognese
r:geoserver/geoserver,MFDEVDB,PASTA _RASTERS,raster ^ >>     -co "INSERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))" >> >>  It is using the table PASTA _RASTERSThis would work all the time.. >> >>  Is it working as expected ? >> >&g

[gdal-dev] GeoRaster COMPRESS=DEFLATE is not compressing

2010-07-13 Thread Pasta Bolognese
Hi All, to safe space, I'm trying the -co "COMPRESS=DEFLATE". but it is not compressing ! C:\tmp>gdal_translate -of georaster c:\tmp\map.png ^ More? georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta_rasters,raster ^ More?-co "INSERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))" ^ Mor

Re: [gdal-dev] GDAL2Tiles

2010-07-14 Thread Pasta Bolognese
Hi Tejas , where did you get that 30GB Tiff file from ? I tough that the maximum size for a Tiff was 4GB... On Wed, Jul 14, 2010 at 3:33 PM, Tejas Gajera wrote: > > Hi, > > I have a Tiff image of around 30GB, and I want to create tiles using > GDAL2Tiles command line utility. If anyone have us

[gdal-dev] building GDAL + OCI on linux

2010-07-16 Thread Pasta Bolognese
Hi All, as OSGeo4W doesn't have the GDAL17 GeoRaster and the 1.6 has some bugs... I'm trying to build it on a Linux Virtual Box... The first question is, HOW ??? I do have Oracle, but I dont't have the Linux version (only Windows). Where can I find all what I need to build GDAL + OCI (GeoRaster)

Re: [gdal-dev] building GDAL + OCI on linux

2010-07-16 Thread Pasta Bolognese
that I sent previously has more info. > >>  ---Original Message--- >>  From: Pasta Bolognese >>  To: gdal-dev@lists.osgeo.org >>  Subject: [gdal-dev] building GDAL + OCI on linux >>  Sent: Jul 16 '10 11:37 >> >>  Hi All, >> >>

Re: [gdal-dev] Re: ogr2ogr OCI: problem loading shapes

2010-07-27 Thread Pasta Bolognese
so with shp2sdo there is one row that is not loaded into the table: Record 28832: Rejected - Error on table SEBAS, column GEOM.SDO_ORDINATES. element count is greater than maximum allowed for the column Table SEBAS: 28891 Rows successfully loaded. 1 Row not loaded due to data errors. 0 Rows