Re: [gdal-dev] Ogr2ogr

2011-11-17 Thread Fred Jones
dbo.qaBtcSubLocs" -nln "btcSubLocs" -nlt POINT It may still need some tweaking. I haven't layered it on other maps to see if the points are in the proper locations. However, I think I'm a lot closer. Thanks to everyone who helped me! I may have more questions. ;-) Fre

Re: [gdal-dev] Ogr2ogr

2011-11-17 Thread Fred Jones
reference identifier (SRID) is not valid. The specified SRID must match one of the supported SRIDs displayed in the sys.spatial_reference_systems catalog view. System.FormatException: On Thu, Nov 17, 2011 at 11:33 AM, Fred Jones wrote: > There is a GEOGRAPHY::STGeomFromText('POINT(x,y)&#

Re: [gdal-dev] Ogr2ogr

2011-11-17 Thread Fred Jones
erSRS element. > Finally run the following command. > > ogr2ogr -overwrite -s_srs EPSG:32002 -t_srs EPSG:4326 -f MSSQLSpatial > "MSSQL:server=ELMER;database= > CENSUS_2010;trusted_connection=yes" qaBtcSubLocs.vrt -nln "btcSubLocs" > > [1]: http://www.gdal.org/

Re: [gdal-dev] Ogr2ogr

2011-11-17 Thread Fred Jones
ve an > entry in the geometry_columns table. You can bypass this by using the > 'Tables' parameter in the connection string[1]. > > [1]: http://www.gdal.org/ogr/drv_mssqlspatial.html > > On Thu, Nov 17, 2011 at 9:28 PM, Fred Jones wrote: > >> This is what I

Re: [gdal-dev] Ogr2ogr

2011-11-17 Thread Fred Jones
type CENSUS_2010 dbo btcsublocs ogr_geometry 2 4326GEOMETRY Fred On Thu, Nov 17, 2011 at 1:48 AM, Luca Sigfrido Percich wrote: > Hi Fred, > > Il giorno mer, 16/11/2011 alle 10.11 -0700, Fred Jones ha scritto: > > Hi Sig, > > > > I have a SQL tabl

[gdal-dev] Re: OGR2OGR and SQL Spatial

2011-11-16 Thread Fred Jones
Hi Sig, This is the command I have so far. When I execute it, I just get the help returned, no error and no table created: ogr2ogr -overwrite -s_srs EPSG:32100 -t_srs EPSG:4326 -f "MSSQL:server=ELMER;database=CENSUS_2010;trusted_connection=yes" "MSSQL:server=ELMER;database=HT_2010_10;tables=temp_

[gdal-dev] Ogr2ogr

2011-11-15 Thread Fred Jones
I'm new to OGR and am having difficulty creating a command. I have GDAL v1.8. I have x/y points in Montana State Plane NAD 27 central in a SQL 2008 database. I'm trying to use the SQLSpatial driver to grab the x/y from SQL, project the points to either geometry or geography, and direct the outp