SQL 2008 Geometry

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

SQL 2008 Geometry

Stanley Sufficool
Using the trunk release of uDIG, there is an option to connect to SQL
Server using the geotools add datastore menu. I have not been able to
get this to work using the "Integrated Authentication" option.

Has anyone been able to get uDiG to display and edit SQL 2008 Geometry?
_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL 2008 Geometry

Jody Garnett-2
I have not had an SQL Server to test against; the status page in the library we use does not have many open issues.


However the planned developments list "geographic" and "wkb geometry read/write". So perhaps it is only supporting WKT currently?

-- 
Jody Garnett

On Sunday, 7 August 2011 at 2:56 AM, Stanley Sufficool wrote:

Using the trunk release of uDIG, there is an option to connect to SQL
Server using the geotools add datastore menu. I have not been able to
get this to work using the "Integrated Authentication" option.

Has anyone been able to get uDiG to display and edit SQL 2008 Geometry?
_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users


_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL 2008 Geometry

Stanley Sufficool
The internal representation for SQL 2008 geometry is not WKB or WKT (.NET Serialized Geometry Class) although creating a SQL View to transform it into that would not be an issue.

The issue that is the blocker is getting a connection the server to select the table to view/edit. When using the "Integrated authentication" option the dialog will not go to the "Finish" step. The dialog reports "Connecting..." and then does not advance to the next screen. There may be an error returned by the geotools library, but it is not shown in the console or error reporting dialog.

SQL Server 2008 Express is available at no cost and would work for testing if you have a Windows box to install it on.

On Tue, Aug 9, 2011 at 4:49 PM, Jody Garnett <[hidden email]> wrote:
I have not had an SQL Server to test against; the status page in the library we use does not have many open issues.


However the planned developments list "geographic" and "wkb geometry read/write". So perhaps it is only supporting WKT currently?

-- 
Jody Garnett

On Sunday, 7 August 2011 at 2:56 AM, Stanley Sufficool wrote:

Using the trunk release of uDIG, there is an option to connect to SQL
Server using the geotools add datastore menu. I have not been able to
get this to work using the "Integrated Authentication" option.

Has anyone been able to get uDiG to display and edit SQL 2008 Geometry?
_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users



_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL 2008 Geometry

Simon Greener
On Windows?
If so, have you tried creating a plain ODBC connection and then access the data as WKB via a view?
I did this with SQL Server 2008 about 3 years ago and was able to make ogr2ogr work.
S
On Wed, 10 Aug 2011 11:45:21 +1000, Stanley Sufficool <[hidden email]> wrote:

The internal representation for SQL 2008 geometry is not WKB or WKT (.NET Serialized Geometry Class) although creating a SQL View to transform it into that would not be an issue.

The issue that is the blocker is getting a connection the server to select the table to view/edit. When using the "Integrated authentication" option the dialog will not go to the "Finish" step. The dialog reports "Connecting..." and then does not advance to the next screen. There may be an error returned by the geotools library, but it is not shown in the console or error reporting dialog.

SQL Server 2008 Express is available at no cost and would work for testing if you have a Windows box to install it on.

On Tue, Aug 9, 2011 at 4:49 PM, Jody Garnett <[hidden email]> wrote:
I have not had an SQL Server to test against; the status page in the library we use does not have many open issues.


However the planned developments list "geographic" and "wkb geometry read/write". So perhaps it is only supporting WKT currently?

-- 
Jody Garnett

On Sunday, 7 August 2011 at 2:56 AM, Stanley Sufficool wrote:

Using the trunk release of uDIG, there is an option to connect to SQL
Server using the geotools add datastore menu. I have not been able to
get this to work using the "Integrated Authentication" option.

Has anyone been able to get uDiG to display and edit SQL 2008 Geometry?
_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users





--
Holder of "2011 Oracle Spatial Excellence Award for Education and Research."
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
Email: [hidden email]
Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
NAC:W80CK 7SWP3

_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL 2008 Geometry

Stanley Sufficool
I'm sure that I could get a variety of tools to work off of a WKB view of a SQL 2008 Geometry column. The issue is getting edit and view access using uDiG. Was geotools designed to work with WKB or the native geometry data type in SQL 2008? I'm thinking native geometry.

Non-the-less, rendering and editing comes after the issue at hand, which is connecting to SQL Server using integrated authentication and listing the tables / views.

On Tue, Aug 9, 2011 at 7:31 PM, Simon Greener <[hidden email]> wrote:
On Windows?
If so, have you tried creating a plain ODBC connection and then access the data as WKB via a view?
I did this with SQL Server 2008 about 3 years ago and was able to make ogr2ogr work.
S
On Wed, 10 Aug 2011 11:45:21 +1000, Stanley Sufficool <[hidden email]> wrote:

The internal representation for SQL 2008 geometry is not WKB or WKT (.NET Serialized Geometry Class) although creating a SQL View to transform it into that would not be an issue.

The issue that is the blocker is getting a connection the server to select the table to view/edit. When using the "Integrated authentication" option the dialog will not go to the "Finish" step. The dialog reports "Connecting..." and then does not advance to the next screen. There may be an error returned by the geotools library, but it is not shown in the console or error reporting dialog.

SQL Server 2008 Express is available at no cost and would work for testing if you have a Windows box to install it on.

On Tue, Aug 9, 2011 at 4:49 PM, Jody Garnett <[hidden email]> wrote:
I have not had an SQL Server to test against; the status page in the library we use does not have many open issues.


However the planned developments list "geographic" and "wkb geometry read/write". So perhaps it is only supporting WKT currently?

-- 
Jody Garnett

On Sunday, 7 August 2011 at 2:56 AM, Stanley Sufficool wrote:

Using the trunk release of uDIG, there is an option to connect to SQL
Server using the geotools add datastore menu. I have not been able to
get this to work using the "Integrated Authentication" option.

Has anyone been able to get uDiG to display and edit SQL 2008 Geometry?
_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users





--
Holder of "2011 Oracle Spatial Excellence Award for Education and Research."
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
Email: [hidden email]
Voice: <a href="tel:%2B61%20362%20396397" value="+61362396397" target="_blank">+61 362 396397
Mobile: <a href="tel:%2B61%20418%20396391" value="+61418396391" target="_blank">+61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
NAC:W80CK 7SWP3

_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users



_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Reply | Threaded
Open this post in threaded view
|

Re: SQL 2008 Geometry

Jody Garnett-2
If you compose an email describing the problem; we can also check logs to see if there is a connection error; I can help you report the issue to the geotools devel list. Right now I don't know enough from this email to ask a sensible question.

Jody

On Wed, Aug 10, 2011 at 2:19 PM, Stanley Sufficool <[hidden email]> wrote:
I'm sure that I could get a variety of tools to work off of a WKB view of a SQL 2008 Geometry column. The issue is getting edit and view access using uDiG. Was geotools designed to work with WKB or the native geometry data type in SQL 2008? I'm thinking native geometry.

Non-the-less, rendering and editing comes after the issue at hand, which is connecting to SQL Server using integrated authentication and listing the tables / views.


On Tue, Aug 9, 2011 at 7:31 PM, Simon Greener <[hidden email]> wrote:
On Windows?
If so, have you tried creating a plain ODBC connection and then access the data as WKB via a view?
I did this with SQL Server 2008 about 3 years ago and was able to make ogr2ogr work.
S
On Wed, 10 Aug 2011 11:45:21 +1000, Stanley Sufficool <[hidden email]> wrote:

The internal representation for SQL 2008 geometry is not WKB or WKT (.NET Serialized Geometry Class) although creating a SQL View to transform it into that would not be an issue.

The issue that is the blocker is getting a connection the server to select the table to view/edit. When using the "Integrated authentication" option the dialog will not go to the "Finish" step. The dialog reports "Connecting..." and then does not advance to the next screen. There may be an error returned by the geotools library, but it is not shown in the console or error reporting dialog.

SQL Server 2008 Express is available at no cost and would work for testing if you have a Windows box to install it on.

On Tue, Aug 9, 2011 at 4:49 PM, Jody Garnett <[hidden email]> wrote:
I have not had an SQL Server to test against; the status page in the library we use does not have many open issues.


However the planned developments list "geographic" and "wkb geometry read/write". So perhaps it is only supporting WKT currently?

-- 
Jody Garnett

On Sunday, 7 August 2011 at 2:56 AM, Stanley Sufficool wrote:

Using the trunk release of uDIG, there is an option to connect to SQL
Server using the geotools add datastore menu. I have not been able to
get this to work using the "Integrated Authentication" option.

Has anyone been able to get uDiG to display and edit SQL 2008 Geometry?
_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users





--
Holder of "2011 Oracle Spatial Excellence Award for Education and Research."
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
Email: [hidden email]
Voice: <a href="tel:%2B61%20362%20396397" value="+61362396397" target="_blank">+61 362 396397
Mobile: <a href="tel:%2B61%20418%20396391" value="+61418396391" target="_blank">+61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
NAC:W80CK 7SWP3

_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users



_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users



_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users