Geocoding and Geodata capabilities of SQL Server

Can anyone point me to where I can read about the Geocoding capabilities
available with SQL Server?
I am also looking for information about how Geodata is stored in SQL Server.
Is it only possible to use Geodata with third-party GIS systems?
There are no built-in GIS capabilities, and SQL Server lacks some of the
features that would make them easier to implement (e.g. R-Tree indexes).
MapInfo does have a SQL Server-based product that looks very interesting,
but I haven't tried it yet.
"Doug Wittich" <Doug Wittich@.discussions.microsoft.com> wrote in message
news:0E391A36-4598-4923-A83E-54E360ECDB7E@.microsoft.com...
> Can anyone point me to where I can read about the Geocoding capabilities
> available with SQL Server?
> I am also looking for information about how Geodata is stored in SQL
Server.
> Is it only possible to use Geodata with third-party GIS systems?
|||I have some clients which have used the ESRI Mapping products with SQL in a
real time ( ambulances) environment... they are OKwith it..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Doug Wittich" <Doug Wittich@.discussions.microsoft.com> wrote in message
news:0E391A36-4598-4923-A83E-54E360ECDB7E@.microsoft.com...
> Can anyone point me to where I can read about the Geocoding capabilities
> available with SQL Server?
> I am also looking for information about how Geodata is stored in SQL
Server.
> Is it only possible to use Geodata with third-party GIS systems?

Geocoding and Geodata capabilities of SQL Server

Can anyone point me to where I can read about the Geocoding capabilities
available with SQL Server?
I am also looking for information about how Geodata is stored in SQL Server.
Is it only possible to use Geodata with third-party GIS systems?There are no built-in GIS capabilities, and SQL Server lacks some of the
features that would make them easier to implement (e.g. R-Tree indexes).
MapInfo does have a SQL Server-based product that looks very interesting,
but I haven't tried it yet.
"Doug Wittich" <Doug Wittich@.discussions.microsoft.com> wrote in message
news:0E391A36-4598-4923-A83E-54E360ECDB7E@.microsoft.com...
> Can anyone point me to where I can read about the Geocoding capabilities
> available with SQL Server?
> I am also looking for information about how Geodata is stored in SQL
Server.
> Is it only possible to use Geodata with third-party GIS systems?|||I have some clients which have used the ESRI Mapping products with SQL in a
real time ( ambulances) environment... they are OKwith it..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Doug Wittich" <Doug Wittich@.discussions.microsoft.com> wrote in message
news:0E391A36-4598-4923-A83E-54E360ECDB7E@.microsoft.com...
> Can anyone point me to where I can read about the Geocoding capabilities
> available with SQL Server?
> I am also looking for information about how Geodata is stored in SQL
Server.
> Is it only possible to use Geodata with third-party GIS systems?

Geocoding and Geodata capabilities of SQL Server

Can anyone point me to where I can read about the Geocoding capabilities
available with SQL Server?
I am also looking for information about how Geodata is stored in SQL Server.
Is it only possible to use Geodata with third-party GIS systems?There are no built-in GIS capabilities, and SQL Server lacks some of the
features that would make them easier to implement (e.g. R-Tree indexes).
MapInfo does have a SQL Server-based product that looks very interesting,
but I haven't tried it yet.
"Doug Wittich" <Doug Wittich@.discussions.microsoft.com> wrote in message
news:0E391A36-4598-4923-A83E-54E360ECDB7E@.microsoft.com...
> Can anyone point me to where I can read about the Geocoding capabilities
> available with SQL Server?
> I am also looking for information about how Geodata is stored in SQL
Server.
> Is it only possible to use Geodata with third-party GIS systems?|||I have some clients which have used the ESRI Mapping products with SQL in a
real time ( ambulances) environment... they are OKwith it..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Doug Wittich" <Doug Wittich@.discussions.microsoft.com> wrote in message
news:0E391A36-4598-4923-A83E-54E360ECDB7E@.microsoft.com...
> Can anyone point me to where I can read about the Geocoding capabilities
> available with SQL Server?
> I am also looking for information about how Geodata is stored in SQL
Server.
> Is it only possible to use Geodata with third-party GIS systems?sql

generating an unique number within SSIS - looking for good examples

Does anybody know how to generate a new identity value from within SSIS. Can anybody point me to a good example using a script component?

Thanks you very much!!!!

Sergio

Here is some script to generate a new GUID.

Code Snippet

Public Sub Main()

' Generate a globally unique identifier

Dim myGuid As Guid = Guid.NewGuid()

MsgBox(myGuid.ToString())

Dts.TaskResult = Dts.Results.Success

End Sub

|||

Sergio wrote:

Does anybody know how to generate a new identity value from within SSIS. Can anybody point me to a good example using a script component?

Thanks you very much!!!!

Sergio

Like this? http://www.ssistalk.com/2007/02/20/generating-surrogate-keys/

What do you mean, "generate a new identity value"?

Generate values between a starting and stopping point (time values).

[RS 2005]

Given the starting and stopping points (time values), how do I generate values between these points.

For example, if I have 08 (representing Hour) as a starting point and 12 as a stopping point.

From this I would like to generate a data sequence like 08, 09, 10, 11, and 12.

So how do I accomplish this? In SQL or in the RS?

The only thing I can think of is using a WHILE loop and a temporary table in SQL (not to keen on doing this).

//H?kan

Use custom code in the report to achieve this. Take the start and end points as input parameters as you might be already doing. Then pass them to the function in custom code and write VB code inside that function to generate all intermediate values. Then store that array in a global variable in the custom code itself which you could refer from anywhere in your report.

Shyam

|||I would either use a function or a stored procedure or a plain query for this.

CREATE FUNCTION dbo.NumberRange

(

@.Starting INT,

@.End INT

)

RETURNS @.Numbers TABLE

(

Number INT

)

AS

BEGIN

WHILE @.Starting <= @.End

BEGIN

INSERT INTO @.Numbers VALUES (@.Starting)

SET @.Starting = @.Starting + 1

END

RETURN

END

SELECT * FROM dbo.NumberRange(1,10)

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Hakan is not keen on using SQL and WHILE loops and tables.|||I know, thats why I write the function for him.|||

H?kan,

do you need the data to be included in the dataset so that it can be rendered on the report? If so, you will have to generate it in the SQL as mentioned by Jens. If all you need to do is refer to the intermediate values from other expressions then a global array is fine, but make sure you have null and bounds checks in your custom code before trying to access the array.

|||

I guess the function also has the WHILE loop and tables.

Instead he can have a master table with just one column and values from 00 to 100 and just select the necessary numbers from that table between the given start and end.

Shyam