How to create SqlGeography from polygon?


hi everyone, want create sqlgeography polygon, don't know how input points of polygon sqlgeography. me solve this? lot.

basically start new sqlgeographybuilder, set srid, begin polygon, add polygon lines, end figure, end geography.  have watch 1 thing though: if polygon in wrong direction you'll end polygon covers whole surface of earth except little region wanted.  can counter checking area of polygon and, if it's huge, rebuild polygon in reverse order.

the geo builder class docs can found here:  http://msdn.microsoft.com/query/dev11.query?appid=dev11idef1&l=en-us&k=k(microsoft.sqlserver.types.sqlgeographybuilder)%3bk(targetframeworkmoniker-.netframework%2cversion%3dv4.5)%3bk(devlang-vb)&rd=true



Bing Maps  >  Bing Maps WPF, WP7/8/8.1, Silverlight



Comments

Post a Comment

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

having same error microsoft.azure.documents.documentclientexception: message: {"errors":["owner resource not exist"]} , scenario. when deployed webapp azure , try document docdb throws error. docdb exists in azure , contains document looking for. weird local machine(running vs) works fine. i'm using same settings in azure , local. have , idea this. thanks Microsoft Azure  >  Azure Cosmos DB
Read more

How to fix error Msg 1801, Level 16, State 3, Line 1

msg 1801, level 16, state 3, line 1 hi needknowledge.me, >> msg 1801, level 16, state 3, line 1 did want do?  ramjaddu mentioned, might database existed already. assuming want create tables in existing database, please follow steps below: open ssms, , click "new query" (top left, underneath file). choose database you're working with, , you're off races. if need create table syntax, you'll find here . i suspect try reattach database ssms steps (click databases >> right click >>attach) or using t-sql statements. might attaching file using database name exists.  , also, it's possible database file corrupted. here thread same error message yours, please refer thread. http://social.msdn.microsoft.com/forums/eu/sqlsetupandupgrade/thread/cd4caa28-04a6-43f4-b16d-b519fbb070c6 regards, amber zhang SQL Server ...
Read more

How to Share webservice object to all user

dear all,            how share webservice object user. in pageload i have created webservice object in pages.so performance level go down.            shall create application level mean it's possible share object in user?             if 1 ,it occur deadlock or anyother problem?             or else how share webservice object user.             please me.... advance you. regards, santhosh you can use application object. if updating application object, can use  application.lock(); , then  application.unlock(); thanks, nishanth mohan visit places in london free!!! a large collection of english / hindi / malayalam / tamil sms messages a large collection of english / hindi / malayalam / tamil s...
Read more