Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Benjamin
"You can access the geometry like with any other ogr feature." Yes, it's right. But how string are encoded with Ogr ? Because I have to write : [code] byte[] memWkb = System.Text.Encoding.UTF8.GetBytes(memFeature.GetFieldAsString("WKB_GEOMETRY")); Geometry memGeom = Geometry.CreateFromWkb(memWkb)

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Even Rouault
Selon Benjamin : > "You can access the geometry like with any other ogr feature." > Hopefully, memFeature.GetGeometryRef() should do it ! ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] New OGR driver to read OpenStreetMap .osm / .pbf files

2012-07-18 Thread Jukka Rahkonen
Even Rouault mines-paris.org> writes: > > Hi, > > Following the recent brainstorming with Jukka, I've pushed into trunk a > driver > to read OpenStreetMap .osm / .pbf files . Driver seems to do what it promises. It is super fast in converting POI data because it is possible to skip the slowe

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Benjamin
Sorry, I was not clear. I resume from the beginning. I work with a warper C# of Ogr. I have a table dbo.MY_TABLE with 3 fields (D, CHART_ID, WKB_GEOMETRY) in a SQL server Database (in SQL Azure exactly). *My aim is to work with a copy* (in a http://www.gdal.org/ogr/drv_memory.html Memory DataS

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Chaitanya kumar CH
Benjamin, The mssql driver already does the conversion from wkb in the database to the native ogr geometry format. You don't have to create a temporary wkb geometry and then the ogr geometry. You can simply do this: [code] Geometry memGeom = memFeature.GetGeometryRef() [/code] On Wed, Jul 18, 20

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Chaitanya kumar CH
Hi Benjamin, Can you provide some more details? How did you try to retrieve the geometry? On Wed, Jul 18, 2012 at 8:02 PM, wrote: > > memFeature.GetGeometryRef(); // return null > > > Sorry, but no. > After a call to SQLExecute(), Ogr framwork doesn't recognize any geometry > in my f

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Benjamin LUX
Hi again Chaitanya, If you look my previous mail you can see the code. But in a compact way this is a copy/paste of my running code. Note that RoleEnvironment.GetConfigurationSettingValue(“”) just provide me parametrables strings (like argv[n]). [code] Ogr.RegisterAll(); string option

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Chaitanya kumar CH
Benjamin, First thing: You don't need to use a memory datasource here. OGR doesn't make round trips to the database server every time you run GetNextFeature(). Do that first. I'm sure it will make it less complicated. I don't understand why you are getting the null. Hopefully we can figure that o

Re: [gdal-dev] New OGR driver to read OpenStreetMap .osm / .pbf files

2012-07-18 Thread Even Rouault
Selon Jukka Rahkonen : > Even Rouault mines-paris.org> writes: > > > > > Hi, > > > > Following the recent brainstorming with Jukka, I've pushed into trunk a > driver > > to read OpenStreetMap .osm / .pbf files . > > Driver seems to do what it promises. It is super fast in converting POI data > be

Re: [gdal-dev] New OGR driver to read OpenStreetMap .osm / .pbf files

2012-07-18 Thread Jeff McKenna
> Even Rouault mines-paris.org> writes: >> Following the recent brainstorming with Jukka, I've pushed into trunk a >> driver >> to read OpenStreetMap .osm / .pbf files . > Fascinating. Actually I think once someone imports the points, lines, polys into a DB, then (cool!) someone could then

Re: [gdal-dev] New OGR driver to read OpenStreetMap .osm / .pbf files

2012-07-18 Thread Jukka Rahkonen
Even Rouault mines-paris.org> writes: > > Hi, > > Following the recent brainstorming with Jukka, I've pushed into trunk a > driver > to read OpenStreetMap .osm / .pbf files . . > > Testing with larger areas, like whole France or Europe, shows sluggish > performance when ways are

[gdal-dev] How to assign Text elements for related shapes (polygon) when reading .DGN files ?

2012-07-18 Thread taibc
Hi friends, When reading .DGN files, I can specify features (include attributes: Type, Level, Text, ColorIndex,...), and geometry (polygon, point) of these features. But, do you know how can we assign (or specify) Text, Level elements for a particular polygon ? For example: The map include many

[gdal-dev] Convert to temperature in degrees C in MODIS Ocean Color?

2012-07-18 Thread sigologo
Hello Everyone I'm trying import A20030012003008.L3m_8D_NSST_4, with gdal with this script: for file in A*L3m_8D_NSST_4 ; do echo "map: $file" gdal_translate -a_srs "+init=epsg:4326" -a_nodata 65535 \ -a_ullr -180 90 180 -90 -co "COMPRESS=PACKBITS" \ HDF4_SDS:UNKNOWN:"$file":0 ${fi