How to use spatial data

10 posts, 3 answers
  1. Christian
    Christian avatar
    81 posts
    Member since:
    Aug 2008

    Posted 04 Mar 2010 Link to this post

    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
  2. Answer
    Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 05 Mar 2010 Link to this post

    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.
  3. DevCraft banner
  4. Christian
    Christian avatar
    81 posts
    Member since:
    Aug 2008

    Posted 02 Jun 2010 Link to this post

    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
  5. Answer
    Jordan
    Admin
    Jordan avatar
    547 posts

    Posted 04 Jun 2010 Link to this post

    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.
  6. Christian
    Christian avatar
    81 posts
    Member since:
    Aug 2008

    Posted 03 Aug 2010 Link to this post

    Hi.
    I have read the features of the current version. My question: Are spatial datatypes now available?
    Thanks.
    Christian
  7. Alexander
    Admin
    Alexander avatar
    727 posts

    Posted 04 Aug 2010 Link to this post

    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
    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
  8. Christian
    Christian avatar
    81 posts
    Member since:
    Aug 2008

    Posted 16 Sep 2011 Link to this post

    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
  9. Answer
    Ady
    Admin
    Ady avatar
    589 posts

    Posted 21 Sep 2011 Link to this post

    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

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>

  10. Duncan
    Duncan avatar
    93 posts
    Member since:
    Jul 2012

    Posted 06 Jan 2012 Link to this post

    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
  11. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 09 Jan 2012 Link to this post

    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

    SP1 for Q3’11 of Telerik OpenAccess ORM is available for download

Back to Top
DevCraft banner