c# - Edge with antipodal points exception with POLYGON 180-90 -


creating dbgeography text using dbgeography.fromtext(polygonastext, 4326); generates quoted exception. box dimensions have been provided google geocoding result suggested viewport dimension. coordinates dud? order used in construction of polygon wrong?

the latitude/longitude ordering has provided accurate results other coordinates, except one.

north east longitude: 180.0 north east latitude: 90.0

south west longitude: -180.0 south west latitude: -90.0

polygon((180 90, -180 90, -180 -90, 180 -90, 180 90))

the exception:

24206: specified input cannot accepted because contains edge antipodal points.

why don't these coordinates result in valid polygon?

there nice easy way address problem (assuming have sql server 2012 or onwards - john barca points out absolutely required build spatial object covering more half hemisphere).

try following:

// let's use nice , simple "fullglobe" statement create polygon covering earth sqlgeography geography = sqlgeography.stgeomfromtext("fullglobe", 4326); dbgeography dbgeography = dbgeography.fromtext(geography.tostring(), 4326);

the conversion (second line) taken previous answer of mine on so here.


Comments

Post a Comment

Popular posts from this blog

rdbms - what exactly the undo information lives in oracle? -

some docs says, there "undo tablespaces" implies should create tablespace undo imformation. some docs says, there "undo segment" implies undo information lives in normal tablespaces , use of it's segment. so, undo information lives , organized? earlier releases of oracle database used rollback segments store undo. oracle9i introduced automatic undo management, simplifies undo space management eliminating complexities associated rollback segment management. oracle recommends (oracle 9i , on words) use undo tablespace (automatic undo management) manage undo rather rollback segments. when creating undo tablespace, these automatically created: n undo segments (based on sessions parameter value) named _syssmun$ owned public (usable ops configuration) not manually manageable
Read more

bash - How do you programmatically add a bats test? -

i'd have bats test created every file in directory, i'm not sure best way done is. approach below creates single test when there many files in directory. #!/usr/bin/env bats in $(ls) @test "testing $i" { pwd } done to extract ls output not batter solution go wrong on filenames spaces. you can below shopt -s nullglob file in /dir/* //test command on $file done shopt -u nullglob you can using find command also find /some/directory -maxdepth 1 -type f -exec cmd option {} \;
Read more

clojure - 'get' replacement that throws exception on not found? -

i'd access values in maps , records, throwing exception when key isn't present. here's i've tried. there better strategy? this doesn't work because throw evaluated every time: (defn get-or-throw-1 [rec key] (get rec key (throw (exception. "no value.")))) maybe there's simple method using macro? well, isn't it; has same problem first definition, if evaluation of throw happens later: (defmacro get-or-throw-2 [rec key] `(get ~rec ~key (throw (exception. "no value.")))) this 1 works letting get return value (in theory) never generated other way: (defn get-or-throw-3 [rec key] (let [not-found-thing :i_would_never_name_some_thing_this_021138465079313 value (get rec key not-found-thing)] (if (= value not-found-thing) (throw (exception. "no value.")) value))) i don't having guess keywords or symbols never occur through other processes. (i use gensym generate special value of...
Read more