Working With Spatial Data in SQL Server

Hackforge tech talk covering the basics of working with spatial data in SQL Server, with practical examples.

[thamarakim]

Thanks my friend, your explanation it was perfect !!! helped me a lot.

[CarlosPereira]

Thank you very much for sharing this piece of information

[CarlosGonzalez-llxx]

this is genius, I thank you very much, it is as if the universe sent it to me to be able to develop a project at work, in the geography faculty they do not teach anything about geoinformatics

[AbstractViewsdesi]

Thank you so much for this video. A quick question - Lets say we have a Shape file data with geometry data type in sql server table - Like county shapes, Now i need to figure out which county based on latitude and longitude that i provide - I used STContains with Point as reference, But i am not getting any results even though one set of Latitude and longitude falls under one county, WHat i am doing wrong ?

[woleolat]

Thanks for the tutorial its very good.

I have a question though each time I convert to WKT it returns as either LINESTRING Z not LINESTRING, POINT Z not POINT. what could be the cause and more importantly what can I do about it? please help thanks