Re: [gdal-dev] trying create a new SHP with Ogr2ogr from ODBC: SQL SERVER

2010-02-02 Thread Antonio Castillo
Hello Jose I can create the Shapefile from "ODBC:SQL Server 2008" connection, with the OGR VRT :D thank you!!! :P the .ovf file -- puentes.ovf -- ODBC:INACMASQL SELECT p.nombre AS nombre,replace(t.latitud,',','.') AS lat,replace(t.lon

Re: [gdal-dev] trying create a new SHP with Ogr2ogr from ODBC: SQL SERVER

2010-02-02 Thread Jose Gomez-Dans
Hi On 2 February 2010 17:11, Antonio Castillo wrote: > ogr2ogr -f "ESRI Shapefile" -a_srs "EPSG:4326" "puentes.shp" > "ODBC:INACMASQL" -nlt POINT -sql "SELECT > p.nombre,t.latitud,t.longitud,t.altura FROM puente p,trayectoria t WHERE > p.id_trajectory = t.id_trayectoria" I think your problem s

[gdal-dev] trying create a new SHP with Ogr2ogr from ODBC: SQL SERVER

2010-02-02 Thread Antonio Castillo
Good morning for all I'm begin to work with ogr2ogr, and i'm trying create a new .shp file from a connection ODBC, but when i add the .shp file created in MapWindow or in Quantum GIS these no display the points in the map window,when i open the attribute table window of my .shp file, i can see all