How to use spatial data

[Christian]

Hi,
We want to create an application where we want to store geographic information. Therefore we want to use the new spatial features of the SQL Server 2008 from Microsoft. How can we use this new data types with the OR-Mapper?
Thanks.
Christian

[Jan Blessenohl]

Hello Christian,
We will implement support for special types like this directly after the Q1 release. At the moment it is not possible.

Kind regards,
Jan Blessenohl
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Christian]

Hello,
is there a new roadmap for spatial data? I can't find any reference to this topic. It's still important for us.
Thanks.
Christian

[Jordan]

Hi Christian,

Spatial types are important for us also. This is one of the reasons  behind the custom type support that we have planned to implement. Unfortunately I cannot give you  a specific time frame for this functionality. I can tell you however that we will probably not have it before the Q2 2010 release.

Kind regards,
Jordan
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Christian]

Hi.
I have read the features of the current version. My question: Are spatial datatypes now available?
Thanks.
Christian

[Alexander]

Hello Christian,

I am afraid that the type converter framework that will allow the usage of those types is still under development. It should be ready soon and we will most probably introduce it in a service pack in a few weeks.

Sincerely yours,
Alexander
the Telerik team

[Christian]

Hi,
I have read the link about the spatial data type (Blog). How can I use this data type with a project that was created with "old" forward-mapping?
Kind regards.
Christian

[Ady]

Hello Christian,

 In case you want to work with the sql server data types you would need to do the following

1. Add a reference to the 'Microsoft.SqlServer.Types' assembly
2. define the fields you require your class. For example - private SqlGeography geographyField;
3. For each such field the mapping in the app.config file should be as follows

<field name="geographyField">
              <extension key="db-column" value="mssql">
                <extension key="db-type" value="LONGVARBINARY" />
                <extension key="db-column-name" value="geographyColumn" />
                <extension key="db-sql-type" value="geography" />
              </extension>
</field>

That's all that is required to work with spatial data types and classic approach.

Do get back in case you need further assistance.
Regards,
Ady
the Telerik team

[Duncan]

Sorry to bring this topic up again, i wanted to revist it as i am thinking of using Geography spatial data type. Does the latest version of OpenAccess support it, and what would the data type be in my code?

Am i better off just sticking with decimals?

Duncan

[Ralph Waldenmaier]

Hi Duncan,

Telerik OpenAccess ORM supports the usage of spatial data types. The data type for your Geography property would be SqlGeography. You can find an example of using spatial data types in our SDK "Basic Spatial Data With OpenAccess" or you can look into this blog post, where spatial data is used with a RadMap.

I hope this information is helpful for you. 

Greetings,
Ralph
the Telerik team