Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
Hi Martin, On Thu, 10. Apr 2014 at 23:33:00 +0200, Martin Landa wrote: C:\OSGeo4W_ociogrinfo -ro OCI:user/passwd@127.0.0.1:1251/xe -sql select count(*) from emp OGR: Auto register C:\OSGeo4W_oci\\bin\gdalplugins\ogr_OCI.dll using RegisterOGR OCI. OCI: Userid=landa, Password=stratos5, Database=127.0.0.1:1251/xe ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified in unnamed FAILURE: Unable to open datasource `OCI:landa/stratos5@127.0.0.1:1251/xe' with the follow ing drivers. Also no 11g XE at hand, but for 11g using the service name instead of the SID might help. Not sure what the default for XE is. lsnrctl status should show it. Eg. ogrinfo OCI:foo/bar@localhost/xe.world Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de QGIS PSC member (RM) Germany IRC: jef on FreeNode -- norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502 ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] gdal_retile x64 : No input files selected.
Hi list, I am using GDAL 10.1 x64 with Python 2.7.5 x64 It seems python script is not able to find the input file W:\gdal_retile.py -v -r -levels 4 -ps 2048 2048 -co TILED=YES -co COMPRESS=JPEG -targetDir w:\dem\dem_pyramid w:\dem\dem.tif 2.7.5 (default, May 15 2013, 22:44:16) [MSC v.1500 64 bit (AMD64)] Usage: gdal_retile.py [-v] [-co NAME=VALUE]* [-of out_format] [-ps pixelWidth pixelHeight] [-ot {Byte/Int16/UInt16/UInt32/Int32/Float32/Float64/ CInt16/CInt32/CFloat32/CFloat64}] [ -tileIndex tileIndexName [-tileIndexField fieldName]] [ -csv fileName [-csvDelim delimiter]] [-s_srs srs_def] [-pyramidOnly] -levels numberoflevels [-r {near/bilinear/cubic/cubicspline/lanczos}] [-useDirForEachRow] -targetDir TileDirectory input_files Can somebody tell me what is wrong with the command below is GDAL info of the geotiff file ---GDALINFO-- W:\gdalinfo dem\dem.tif Driver: GTiff/GeoTIFF Files: dem\dem.tif dem\dem.tif.aux.xml Size is 30001, 24001 Coordinate System is: GEOGCS[WGS 84, DATUM[WGS_1984, SPHEROID[WGS 84,6378137,298.257223563, AUTHORITY[EPSG,7030]], AUTHORITY[EPSG,6326]], PRIMEM[Greenwich,0], UNIT[degree,0.0174532925199433], AUTHORITY[EPSG,4326]] Origin = (59.99958323244,40.000416763514124) Pixel Size = (0.0008333,-0.0008333) Metadata: AREA_OR_POINT=Area Image Structure Metadata: INTERLEAVE=BAND Corner Coordinates: Upper Left ( 59.9995833, 40.0004168) ( 59d59'58.50E, 40d 0' 1.50N) Lower Left ( 59.9995833, 19.9995834) ( 59d59'58.50E, 19d59'58.50N) Upper Right ( 85.0004167, 40.0004168) ( 85d 0' 1.50E, 40d 0' 1.50N) Lower Right ( 85.0004167, 19.9995834) ( 85d 0' 1.50E, 19d59'58.50N) Center ( 72.500, 30.001) ( 72d30' 0.00E, 30d 0' 0.00N) Band 1 Block=30001x1 Type=Int16, ColorInterp=Gray Description = Layer_1 Min=-32768.000 Max=8469.000 Minimum=-32768.000, Maximum=8469.000, Mean=-339.616, StdDev=7609.851 NoData Value=0 Metadata: LAYER_TYPE=athematic STATISTICS_HISTOBINVALUES=35892220|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|147192240|103498980|58861348|42041116 |24849760|20456436|19853444|32923904|23568064|14391364|11251344|9393020|9059076| 8846812|7765888|6834360|6443632|6328036|5700032|5445180|5022004|4646148|4389944| 4296656|024|4944940|5610800|6424704|8513544|9714796|11723868|13505128|117576 68|8901568|6243536|4127656|2605304|1385800|671944|286624|116272|41912|27716|1352 0|10816|5408|4056|2028|676|0|0|0|676| STATISTICS_HISTOMAX=8469 STATISTICS_HISTOMIN=-32768 STATISTICS_HISTONUMBINS=256 STATISTICS_MAXIMUM=8469 STATISTICS_MEAN=-339.61644644564 STATISTICS_MEDIAN=414.8984375 STATISTICS_MINIMUM=-32768 STATISTICS_MODE=-68.34765625 STATISTICS_SKIPFACTORX=26 STATISTICS_SKIPFACTORY=26 STATISTICS_STDDEV=7609.8514119626 regards, Imran -- I.R ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] gdal_retile x64 : No input files selected.
Imran, You need to specify the resampling algorithm if you use the -r option. Choose from near, bilinear, cubic, cubicspline, lanczos. 'near' is used if you don't specify the -r option. On Fri, Apr 11, 2014 at 12:45 PM, Imran Rajjad raj...@gmail.com wrote: Hi list, I am using GDAL 10.1 x64 with Python 2.7.5 x64 It seems python script is not able to find the input file W:\gdal_retile.py -v -r -levels 4 -ps 2048 2048 -co TILED=YES -co COMPRESS=JPEG -targetDir w:\dem\dem_pyramid w:\dem\dem.tif 2.7.5 (default, May 15 2013, 22:44:16) [MSC v.1500 64 bit (AMD64)] Usage: gdal_retile.py [-v] [-co NAME=VALUE]* [-of out_format] [-ps pixelWidth pixelHeight] [-ot {Byte/Int16/UInt16/UInt32/Int32/Float32/Float64/ CInt16/CInt32/CFloat32/CFloat64}] [ -tileIndex tileIndexName [-tileIndexField fieldName]] [ -csv fileName [-csvDelim delimiter]] [-s_srs srs_def] [-pyramidOnly] -levels numberoflevels [-r {near/bilinear/cubic/cubicspline/lanczos}] [-useDirForEachRow] -targetDir TileDirectory input_files Can somebody tell me what is wrong with the command below is GDAL info of the geotiff file ---GDALINFO-- W:\gdalinfo dem\dem.tif Driver: GTiff/GeoTIFF Files: dem\dem.tif dem\dem.tif.aux.xml Size is 30001, 24001 Coordinate System is: GEOGCS[WGS 84, DATUM[WGS_1984, SPHEROID[WGS 84,6378137,298.257223563, AUTHORITY[EPSG,7030]], AUTHORITY[EPSG,6326]], PRIMEM[Greenwich,0], UNIT[degree,0.0174532925199433], AUTHORITY[EPSG,4326]] Origin = (59.99958323244,40.000416763514124) Pixel Size = (0.0008333,-0.0008333) Metadata: AREA_OR_POINT=Area Image Structure Metadata: INTERLEAVE=BAND Corner Coordinates: Upper Left ( 59.9995833, 40.0004168) ( 59d59'58.50E, 40d 0' 1.50N) Lower Left ( 59.9995833, 19.9995834) ( 59d59'58.50E, 19d59'58.50N) Upper Right ( 85.0004167, 40.0004168) ( 85d 0' 1.50E, 40d 0' 1.50N) Lower Right ( 85.0004167, 19.9995834) ( 85d 0' 1.50E, 19d59'58.50N) Center ( 72.500, 30.001) ( 72d30' 0.00E, 30d 0' 0.00N) Band 1 Block=30001x1 Type=Int16, ColorInterp=Gray Description = Layer_1 Min=-32768.000 Max=8469.000 Minimum=-32768.000, Maximum=8469.000, Mean=-339.616, StdDev=7609.851 NoData Value=0 Metadata: LAYER_TYPE=athematic STATISTICS_HISTOBINVALUES=35892220|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|147192240|103498980|58861348|42041116 |24849760|20456436|19853444|32923904|23568064|14391364|11251344|9393020|9059076| 8846812|7765888|6834360|6443632|6328036|5700032|5445180|5022004|4646148|4389944| 4296656|024|4944940|5610800|6424704|8513544|9714796|11723868|13505128|117576 68|8901568|6243536|4127656|2605304|1385800|671944|286624|116272|41912|27716|1352 0|10816|5408|4056|2028|676|0|0|0|676| STATISTICS_HISTOMAX=8469 STATISTICS_HISTOMIN=-32768 STATISTICS_HISTONUMBINS=256 STATISTICS_MAXIMUM=8469 STATISTICS_MEAN=-339.61644644564 STATISTICS_MEDIAN=414.8984375 STATISTICS_MINIMUM=-32768 STATISTICS_MODE=-68.34765625 STATISTICS_SKIPFACTORX=26 STATISTICS_SKIPFACTORY=26 STATISTICS_STDDEV=7609.8514119626 regards, Imran -- I.R ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev -- Best regards, Chaitanya kumar CH. +91-9494447584 17.2416N 80.1426E ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] AOI, Signature and Fourier Transform files' access?
Dear all, Good Morning! Is it possible to read/write ERDAS AOI, Signature (.sig) and Fast Fourier Transform image data from GDAL? If so, can anyone kindly teach me how to. With many thanks, Yours sincerely, B. Ramesh ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
Hi all, 2014-04-11 4:00 GMT+02:00 Ivan Lucena lucena_i...@hotmail.com: [...] I know that is not the same situation you have, but when I need to run GDAL build for Win32 on my Win64 machine I need to place an OCI.DLL from a InstantClient-32 first on my PATH. Otherwise it will try to load the default on DLL my system, that happens to a Win64 OCI.DLL. that was! When I removed oci.dll from c:\osgeo4w than it started magically work! ogrinfo -ro OCI:user/passwd Thanks for saving me from madness :-) Martin ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] Oracle ogrinfo insert into user_sdo_geom_metadata
All, I'm writing a batch file to automate the loading of spatial data into our Oracle database. As a check I'm testing the Oracle connection before starting the process with a command like: ogrinfo -ro -q OCI:db_schema/db_password@db_name:table_name_1,table_name_2 Which, if all ok, would result in: 1: table_name_1 2: table_name_2 I then in testing I added a non-existent table name: ogrinfo -ro -q OCI:db_schema/db_password@db_name:table_name_1,table_name_2,NOT_A_TABLE_NAME Resulting (as I was expecting) in: ERROR 1: ORA-04043: object NOT_A_TABLE_NAME does not exist in OCIDescribeAny ERROR 1: ORA-04043: object NOT_A_TABLE_NAME does not exist in OCIDescribeAny 1: table_name_1 2: table_name_2 However when checking in Oracle, the USER_SDO_GEOM_METADATA table contained an entry for NOT_A_TABLE_NAME. I deleted the row from the table in Oracle and tried the ogrinfo command again with --debug on ogrinfo -ro -q OCI:db_schema/db_password@db_name:table_name_1,table_name_2,NOT_A_TABLE_NAME --debug on Which had the same resultant command line output (obviously with all the debug text as well), however this time the row wasn't inserted into the USER_SDO_GEOM_METADATA table. Can anyone explain this behaviour, shouldn't the -ro flag prevent any inserts? Also as an aside I'd be interested in knowing why the ERROR 1: ORA-04043 is output twice? Initially using: GDAL 1.9.2 Updated same on: GDAL 1.10.1 Kind regards, Rob DISCLAIMER: The information contained in this communication/message from robert.langf...@salford.gov.uk sent on Fri Apr 11 13:14:26 2014 is confidential. It is intended solely for the addressee(s) gdal-dev@lists.osgeo.org Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. Please immediately contact the sender, robert.langf...@salford.gov.uk if you have received this message in error. For the full disclaimer please access http://www.salford.gov.uk/e-mail. Thank you. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [EXTERNAL] oci and oracle express 11
I glad to know that it solved your problem, even with my poor cellphone typing. It seems like Windows doesn't detect that the oci.dll version/architecture is wrong and loads it with without a problem, but when the GDAL driver try to call the OCI API to open a connection that error comes as a default. What is very misleading. It has nothing to deal with SID or the Listener setting. Date: Fri, 11 Apr 2014 12:08:35 +0200 Subject: Re: [gdal-dev] [EXTERNAL] oci and oracle express 11 From: landa.mar...@gmail.com To: lucena_i...@hotmail.com CC: mate...@loskot.net; gdal-dev@lists.osgeo.org; michael.sm...@erdc.dren.mil Hi all, 2014-04-11 4:00 GMT+02:00 Ivan Lucena lucena_i...@hotmail.com: [...] I know that is not the same situation you have, but when I need to run GDAL build for Win32 on my Win64 machine I need to place an OCI.DLL from a InstantClient-32 first on my PATH. Otherwise it will try to load the default on DLL my system, that happens to a Win64 OCI.DLL. that was! When I removed oci.dll from c:\osgeo4w than it started magically work! ogrinfo -ro OCI:user/passwd Thanks for saving me from madness :-) Martin ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] [ogr2ogr 1.10]EPSG 3943
Le vendredi 11 avril 2014 18:46:35, Rémy GOURRAT a écrit : Hi, At the end of my command line ogr2ogr, i Try to attribute a SRS output with this syntax : -a_srs EPSG:3946 But every time I have this message : ERROR 6: EPSG PCS/GCS code 3946 not found in EPSG support files. Is this a valid EPSG coordinate system? Failed to process SRS definition: EPSG:3946 I check the pcs.csv and i get the line 3946 with the SRS def pcs.csv is in the same directory that ogr2ogr Works for me. Check that the GDAL_DATA environment variable point to the path where the CSV files are installed. I forget something ? Thanks for your help Rémy -- Geospatial professional services http://even.rouault.free.fr/services.html ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev