Geocoding in SQL Server 2000 DTS Package

Anyone have any examples or information on how to best accomplish
geocoding in a SQL Server 2000 DTS package?
Spencer"stabbert" <spencer@.tabbert.net> wrote in message
news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> Anyone have any examples or information on how to best accomplish
> geocoding in a SQL Server 2000 DTS package?
> Spencer
>
How are you doing your geocoding? Are you trying to store lats and longs?
A key that maps to lats and longs? Are you using a zipcode, or county, or
state value to determine your geocoding?
Rick Sawtell
MCT, MCSD, MCDBA|||We are attempting to store lattitude and longitude based upon full US
addresses. We need the lattitude and longitude as the input will be
the address.
Spencer
Rick Sawtell wrote:
> "stabbert" <spencer@.tabbert.net> wrote in message
> news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> How are you doing your geocoding? Are you trying to store lats and longs?
> A key that maps to lats and longs? Are you using a zipcode, or county, or
> state value to determine your geocoding?
>
>
> Rick Sawtell
> MCT, MCSD, MCDBA|||Here's as start, but you need SQL Server 2005.
http://msdn.microsoft.com/library/d...
alFuncSQL.asp
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"stabbert" <spencer@.tabbert.net> wrote in message
news:1152231254.150274.286890@.s13g2000cwa.googlegroups.com...
We are attempting to store lattitude and longitude based upon full US
addresses. We need the lattitude and longitude as the input will be
the address.
Spencer
Rick Sawtell wrote:
> "stabbert" <spencer@.tabbert.net> wrote in message
> news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> How are you doing your geocoding? Are you trying to store lats and longs?
> A key that maps to lats and longs? Are you using a zipcode, or county, or
> state value to determine your geocoding?
>
>
> Rick Sawtell
> MCT, MCSD, MCDBA|||I have written a VBscript that will be embeded in a DTS package that
will use the MSXML2.ServerXMLHTTP.3.0 object to make calls to the
Google and Yahoo API used for geocoding. The simple HTTP calls are all
that I need and are simple. I can then get the elements I need out of
the XML returned. I plan to expand this eventually ontok.com and
geocoder.us for commercial type applications and they offer the same
simple HTTP REST interface.
Spence

Geocoding in SQL Server 2000 DTS Package

Anyone have any examples or information on how to best accomplish
geocoding in a SQL Server 2000 DTS package?
Spencer"stabbert" <spencer@.tabbert.net> wrote in message
news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> Anyone have any examples or information on how to best accomplish
> geocoding in a SQL Server 2000 DTS package?
> Spencer
>
How are you doing your geocoding? Are you trying to store lats and longs?
A key that maps to lats and longs? Are you using a zipcode, or county, or
state value to determine your geocoding?
Rick Sawtell
MCT, MCSD, MCDBA|||We are attempting to store lattitude and longitude based upon full US
addresses. We need the lattitude and longitude as the input will be
the address.
Spencer
Rick Sawtell wrote:
> "stabbert" <spencer@.tabbert.net> wrote in message
> news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> > Anyone have any examples or information on how to best accomplish
> > geocoding in a SQL Server 2000 DTS package?
> > Spencer
> >
> How are you doing your geocoding? Are you trying to store lats and longs?
> A key that maps to lats and longs? Are you using a zipcode, or county, or
> state value to determine your geocoding?
>
>
> Rick Sawtell
> MCT, MCSD, MCDBA|||Here's as start, but you need SQL Server 2005.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/TblValFuncSQL.asp
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"stabbert" <spencer@.tabbert.net> wrote in message
news:1152231254.150274.286890@.s13g2000cwa.googlegroups.com...
We are attempting to store lattitude and longitude based upon full US
addresses. We need the lattitude and longitude as the input will be
the address.
Spencer
Rick Sawtell wrote:
> "stabbert" <spencer@.tabbert.net> wrote in message
> news:1152191801.603777.125550@.j8g2000cwa.googlegroups.com...
> > Anyone have any examples or information on how to best accomplish
> > geocoding in a SQL Server 2000 DTS package?
> > Spencer
> >
> How are you doing your geocoding? Are you trying to store lats and longs?
> A key that maps to lats and longs? Are you using a zipcode, or county, or
> state value to determine your geocoding?
>
>
> Rick Sawtell
> MCT, MCSD, MCDBA|||I have written a VBscript that will be embeded in a DTS package that
will use the MSXML2.ServerXMLHTTP.3.0 object to make calls to the
Google and Yahoo API used for geocoding. The simple HTTP calls are all
that I need and are simple. I can then get the elements I need out of
the XML returned. I plan to expand this eventually ontok.com and
geocoder.us for commercial type applications and they offer the same
simple HTTP REST interface.
Spence

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