[gdal-dev] OGR dynamic query
Hey guys, I'm using ogr to perform select statement in a database for a mapserver/gis. I would like to know something. Is it possible to build dynamic query ? Here is an example: Select * from Table where field1 X Where X can vary depending on the query. I would like to use this feature for time display (display information since a date and this date can be feed by the user in the user interface). Thx for you help. Frédéric Therrien ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] Oracle OCI driver and Oracle views
Hi, I tried to convert data from Oracle spatial view (not table) with ogr2ogr. Result was not successful. Instead I got this message: ERROR 1: ORA-04043: object MY_VIEW does not exist in OCIDescribeAny The view exists in the database, it is registered in ALL_SDO_GEOM_METADATA and I can use it through SQL. Now I wonder if ogr2ogr OCI driver supports the use of Oracle views at all. The documentation at http://gdal.org/ogr/drv_oci.html does not say anything about views. -Jukka Rahkonen- ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] OGR dynamic query
Frédéric Therrien wrote: Hey guys, I'm using ogr to perform select statement in a database for a mapserver/gis. I would like to know something. Is it possible to build dynamic query ? Here is an example: Select * from Table where field1 X Where X can vary depending on the query. I would like to use this feature for time display (display information since a date and this date can be feed by the user in the user interface). Thx for you help. Frédéric, I don't know anything about your application, but of course it is generally possible to do dynamic queries. This would normally be accomplished by assembling the query string dynamically in your application before passing it to ExecuteSQL() or SetAttributeFilter(). Note that OGR SQL requires that the right side of any comparison be a constant, so you can't compare two fields in a non-database datasource (if that is what you were thinking). You can do anything supported by SQL in a real RDBMS. Best regards, -- ---+-- I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush| Geospatial Programmer for Rent ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
RE: [gdal-dev] OGR dynamic query
Hey, thx for the answer, but maybe I wasn't clear enought. I'm using ogr with a map file for a mapserver (an later on a GIS). My question is, is it possible to pass a parameter from the gis/wms call to the ogr query, passing by openlayer-ms4w then the map file. Frank, you said I can use SetAttributeFilter, but how does it work ? Thx for your help Frédéric Therrien Date: Mon, 22 Sep 2008 10:46:35 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] OGR dynamic query Frédéric Therrien wrote: Hey guys, I'm using ogr to perform select statement in a database for a mapserver/gis. I would like to know something. Is it possible to build dynamic query ? Here is an example: Select * from Table where field1 X Where X can vary depending on the query. I would like to use this feature for time display (display information since a date and this date can be feed by the user in the user interface). Thx for you help. Frédéric, I don't know anything about your application, but of course it is generally possible to do dynamic queries. This would normally be accomplished by assembling the query string dynamically in your application before passing it to ExecuteSQL() or SetAttributeFilter(). Note that OGR SQL requires that the right side of any comparison be a constant, so you can't compare two fields in a non-database datasource (if that is what you were thinking). You can do anything supported by SQL in a real RDBMS. Best regards, -- ---+-- I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush| Geospatial Programmer for Rent ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] Out of Office
Vielen Dank für Ihre Nachricht. Ich bin bis einschließlich 26.09.2008 nicht im Büro und kann Ihre Anfrage leider nicht bearbeiten. Ihre Nachricht wird nicht automatisch weitergeleitet. Ich werde Ihre eMail gerne nach meiner Rückkehr beantworten. Thank you very much for your message. I'm out of office until Sep 26,2008. I'll deal with your email when I return. Mit freundlichen Grüßen / Best regards, Philip Paar If you questions concerning - Dejavu3D please write to Dr. Liviu Coconu, [EMAIL PROTECTED] - Entree3D and Marche3D please write to Peter Benedix, [EMAIL PROTECTED] - Projects please write to Agnes Kirchhoff, [EMAIL PROTECTED] ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] MEM size limit
Hello everyone, According to the documentation in gdal.org, the in-memory file format (MEM) has a 2GB size limit. I recently used MEM to process an image whose size is larger than 2GB without encountering any error message. The output seems to be fine as well. Has the MEM driver been upgraded to handle image 2 GB. I am using GDAL v1.5.2. Thanks. Ozy ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] MEM size limit
Ozy Sjahputera wrote: Hello everyone, According to the documentation in gdal.org, the in-memory file format (MEM) has a 2GB size limit. I recently used MEM to process an image whose size is larger than 2GB without encountering any error message. The output seems to be fine as well. Has the MEM driver been upgraded to handle image 2 GB. I am using GDAL v1.5.2. Ozy, Yes, it appears that as part of treating bug #1503 this limitation was removed on 64bit platforms. I have removed the 2GB limit mention in the formats_list.html file. Best regards, -- ---+-- I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush| Geospatial Programmer for Rent ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] how can use gdalce.dll and gdalce_i.lib in vc2005 smart device application to open image(tif)?
Hi liudaojie, of course you cannot use the same libraries as in the desktop version, but the includes stay the same. As stated on the website you could compile the libraries for smart device processors (like ARM for example). Also, the methods you call and the way things work is the same - despite the fact that you often have much lesser memory then on desktop. And please, if you respond to a mail - send the mail to the group (some e-mail programs have buttuns like respond and respond all)- this way the mailing list is getting a carbon copy and all could read what you have written (and respond or benefit to/from it). bye, Tom liu_daojie schrieb: hello: here I have a question in wince you use the same lib and include as in vc6.0 ? or others ? can you list them?the method is same in wince as in vc6 to open image(tiff)? thanks liudaojie [] http://popme.163.com/link/003984_0919_8949.html ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] MapInfo error handling
Linda Thompson wrote: We have quite few customers with problems in their Mapinfo .map files. We would like to allow the user to see the .dat information and report the problem with their .map file. I have created a patch for the problem that allows me to continue displaying data for the customer and allows more flexibility in dealing with the error. Do you think this may be a benefit to others using MITAB? For the record, we took this off-list with Linda and it turns out that the files that lead to this patch are corrupt and can't even be read by MapInfo itself. The proposed patch would effectively disable a validation of the source data in MITAB to accomodate for corrupt files so we're not going to include it for now. Daniel -- Daniel Morissette http://www.mapgears.com/ ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] Status of RFC 4: Geolocation Arrays especially Envisat wrt GCPs
Frank, The short story: I've got some Single Look Complex EnviSat data I need to process. Will gdalwarp do a piecewise (triangulated) warp using GCPs or only(!) use them to calculate an image-wide polynomial? The longer story: ESA's Best (http://earth.esa.int/services/best/) does an OK job extracting the amplitude from the data, but because it uses tiff files for intermediate storage, and their implementation is limited to 2gb tiffs, it's necessary to tile an input image. Best assigns a different affine transformation to each output GeoTiff tile, which causes a mis-alignment of the tiles when re-assembling them (using gdalwarp etc). Best does output an extensive metadata text file with each tile including a geolocation array of latitude and longitude. Unfortunately the array is not regular (eg, my test tile has values for lines 1, 811, 812, 1622, 1623, 2240; every 165 pixels except the last interval which is 195 pixels). If gdalwarp would use this semi-regular array to triangulate the pixel locations, that would be great, otherwise I'll have to use something else... Thanks! Brent Fraser ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] Re: Status of RFC 4: Geolocation Arrays especially Envisat wrt GCPs
Brent Fraser wrote: Frank, The short story: I've got some Single Look Complex EnviSat data I need to process. Will gdalwarp do a piecewise (triangulated) warp using GCPs or only(!) use them to calculate an image-wide polynomial? Brent, There are two choices from GCPs. Either polynomial (1st to 3rd order) or thin plate splines. Thin Plate Splines are nice in that the transformation is exact at all GCPs, and it will give similar, but more continuous results to piecewise triangulated warps which I don't support. But TPS is likely to be slow on a large dataset with a lot of GCPs. The longer story: ESA's Best (http://earth.esa.int/services/best/) does an OK job extracting the amplitude from the data, but because it uses tiff files for intermediate storage, and their implementation is limited to 2gb tiffs, it's necessary to tile an input image. Best assigns a different affine transformation to each output GeoTiff tile, which causes a mis-alignment of the tiles when re-assembling them (using gdalwarp etc). Best does output an extensive metadata text file with each tile including a geolocation array of latitude and longitude. Unfortunately the array is not regular (eg, my test tile has values for lines 1, 811, 812, 1622, 1623, 2240; every 165 pixels except the last interval which is 195 pixels). If gdalwarp would use this semi-regular array to triangulate the pixel locations, that would be great, otherwise I'll have to use something else... There is no mechanism to use geolocation arrays that are irregular in this way, and even for regular geolocation arrays the existing code is a bit questionable. Best regards, -- ---+-- I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush| Geospatial Programmer for Rent ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
