import gis data into SQL

Question

import gis data into SQL

pingpong

SSC Eights!

Points: 836
More actions
December 5, 2003 at 2:01 pm

#160238

Hi,
Can I know if there exists any special way to import Grids ( ArcGIS ) as image into the SQL server?
I have imported it as raster dataset, but when I try to retrieve it says that there exists an image. Although it doesnot show up the image when I try viewing it through a browser. Could I get some help with this?
TIA.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

I am not sure if I understand you.

Binary data in its most simplified form is simply a chain of 0s and 1s arranged in a certain manner. SQL Server does not interpret this data in no way. This is the job of the client application.

So my guess is that something went wrong while storing and/or retrieving the data.

How did you do that?

Maybe my standard link for BLOBs is of any help to you

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

pingpong SSC Eights! Points: 836 More actions · Answer 2

Can I know what is the best way to import Grid images into the SQL Server?

Thank U!

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

It is always difficult to say what is the 'best' way.

For me the 'best' way is to use ADO and the ADO Stream object. SQL Server offers a tool called textcopy.exe to demonstrate how to handle binary data.

What specific error do you get?

What format are your pics?

What does your code to retrieve the images look like?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

pingpong SSC Eights! Points: 836 More actions · Answer 4

I have the images in the form of Grids created using ArcTools. I connect to the SQL database through ArcSDE and am uploading the Grids as I am doing the coverages. Coverages are fine as tables but the Grids when uploaded are not showing up any tables in the database.

So I was guessing if there was any other method to upload Grids through ArcSDE to the SQL database.

Thank U!

pingpong SSC Eights! Points: 836 More actions · Answer 5

Can I get some help on this plz. Am in real need of a solution to this.

Any suggestions would be great!!

Thank U.

gljjr SSChampion Points: 10080 More actions · Answer 6

Did you read the link(http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx) that Frank posted? It should give you all the information you need to know for using Blobs. Also if I remember correctly ArcTools has a very good sample application that you can use to figure this out. It's been quite a while since I played with it though so I don't remember or have any code samples to help out.

In order to help any more than Frank already has we would need to have more information on EXACTLY what you are doing, including some sample code. My guess is that what you really need to do is talk to the ArcTools tech support people to find out what you are doing wrong with their data.

Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer

This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.