locked
how to make valid -- emergency RRS feed

  • Question

  • I want to make valid this but I cannot do this. How can I make valid in sql server ?

    thank you.

    declare @y as  geography
    set @y = geography::STGeomFromWKB(0x050000000071A3E6ABF83B40307A5E83BE664440101AACA069F53D40F8E91F80D4CA44400A000000C167000000000000AE0000005904000005070000520700007F080000740900008009000095090000EE330000D03A60CFD7243D40E051F36C566D44404083A143E0243D400053B7054B6D4440A0299185E8243D40A8B750D8456D444050B66937FA243D40589316D34C6D4440802D4F89EB243D408022EDCF456D444020E37116F6243D40501CEAAA406D444060289A560A253D4078E954C03D6D4440F03068A33A253D40585E6F5D316D4440301FF4893C253D40B04E50DF326D4440A00CA80A46253D4030C90B55316D4440F02BE60643253D40F09C65C22F6D444010C9B59C4B253D40788233492C6D4440701FAD264F253D40C8D4F6B52E6D444040573E1A4E253D4028586C382C6D4440F044AB376A253D4068AB7D24256D4440200898A773253D4020C4CCC8206D44400061D0FF72253D408857C7681D6D4440A0D183E97B253D402019471D1D6D444070FA9A2E8B253D40F0843194136D44408076C35F93253D40B8282318076D444070A09E3D97253D40E878177D056D44408066B8AE98253D40E8EA0419016D44407000A2A696253D403082BDBC006D44406064631399253D40881C93E7FA6C4440D006A17895253D4078C36A09F96C4440500460AA99253D4098E72EF5F36C4440503E463998253D40A002C3BAF16C4440A02D96B88E253D40202D00E5EF6C4440B003BBDA8A253D40F026FDBFEA6C44409086CE108E253D4070D9BF42E66C4440A0D81B6492253D40E805DCEEE56C4440408224DA8E253D4068E09ACDE36C44406069E5AF90253D40A861BBB4E16C4440B049BB8097253D40C01A6D8FDE6C4440401D9FD497253D405814F450DB6C4440B01066F4A3253D40A07214E5D26C444020D8FC9AAC253D4030EBF0D8CF6C4440F00F8E8EAB253D4098B1F67CCD6C4440607C9741B5253D4070110A60CA6C4440809A11A5BD253D4088D5444FCA6C4440607D2844C0253D40B808C66CC96C444040366405BF253D4038330397C76C44406050EDCEDA253D40E85729CFBC6C444080F7B476DB253D40508B2006BA6C4440C091570BEC253D406854DD91B16C4440D0CD9235EA253D40786F7157AF6C44402093D440F3253D40C0E9B6B3AF6C4440F06A62CBF2253D40F006A014AD6C444080AE5439ED253D40905B2E36AD6C4440604CFC34EE253D40D86F5D8AAB6C444090850A5EF4253D4070E15EF3AA6C44409084795BE9253D40781EE89C9F6C444020F3D7A9F2253D401890E9059F6C444090D9F3AFE5253D40680D8FF9806C4440E0A22655DB253D4058B3D518746C4440404E9833DB253D4050F2B7B06E6C4440B00915C3D5253D40A0667001686C4440E03609D5CD253D405874B0FD646C444030603FE3C2253D40C8835962656C44403055B6CEBF253D405041A5F9636C4440F06599E5B2253D40D01668CF656C444050F5E5FBA9253D40908ABED3646C444030B819CFA0253D40F06D37BF616C4440109529F697253D40B03C9523646C44406024760C8F253D408857B3CF636C444020254E7287253D4080ECA0BE656C4440A006E8DB82253D40F0E5B166646C4440A0C1783881253D4098A55299626C444030FAE19178253D4050912345646C4440704E84807C253D40103D8156606C44403094CB8976253D4040B57117616C4440B07B789274253D407010EF90626C4440200D1A446B253D40B85729E9616C4440A0A9440A65253D4000675C34646C4440C0FA005B5E253D40187B156F646C4440C00A0C0C59253D40E81F98F5626C4440B082C9C342253D40C0E53B4D666C4440A0572A4D4A253D4038F5E4B1666C4440A03B058541253D40F8565183696C4440E0F42C793C253D40F8565183696C444010E3B85F3E253D4088ADBE266B6C44405010AD7136253D40A0F482656C6C4440C0F7597A34253D40C823D0656A6C444070220DBE30253D40D8FF81936D6C4440C0A14E232D253D4020973A376D6C444070D78A7B2C253D4068FBE7D66B6C444030BDCE1B27253D4078871BB96E6C4440404E849A21253D40B0BA9CD66D6C4440804C1B321E253D4058D544696F6C444010056BC020253D40B015A436716C4440B0CE899812253D4060EBDC25716C4440106AF0C517253D4030EB660C736C4440B0CE899812253D405015B803756C4440607D14AB06253D40680CFEF6756C4440700ECA2901253D4018DD3ADD796C4440B06C642AFD243D40A07D132D796C4440D0470BE9F0243D40C01AE3C2816C4440A01F9973F0243D40F0A86B40846C444090E6BDE0D3243D4028657D25906C4440D03FE26BCF243D4060099E5F946C444070986127BC243D4098BA26309D6C4440B040ED67B1243D40F84825C79D6C4440D0D1A2E6AB243D4060AAA565A46C4440A06EB9DFA1243D40208F9B86A86C444090C6603596243D40C08EAF53AC6C4440C09EDAF291243D40684E5086AA6C4440300E443D7D243D402878B54AB06C4440F05D8F7F66243D40780311C7BA6C444050BE7E1B62243D40D098EAE8B86C4440604AB2FD64243D40F8F546E4BB6C4440607D00124D243D401043982EC46C444000ED22F94A243D4088CABB3AC76C4440706D28F73B243D4050973A1DC86C4440407F9C103A243D4050F2417DCB6C44405010528F34243D40D06CFDF2C96C444040C98D5033243D4068567903CC6C4440D0AA5A5018243D401887B952CF6C4440D0AA5A5018243D40B85ED1C3D06C444080CA847F11243D4038B10A4AD16C444090DA8F300C243D4018FF33FAD16C4440A020C36C02243D40E0F9C1D7D76C44403094A35703243D40401DAE5DDA6C4440A0049EA4F9233D40485B4276DE6C4440805DD6FCF8233D4078E9CAF3E06C4440302E8D4F01243D40E805DCEEE56C4440F02FF6B704243D40A05DCA1AF56C4440807479280A243D409087A5F8F86C4440D094482712243D4060872FDFFA6C4440802090D618243D40F055172AFF6C4440D04A57E718243D40B8EA8EFF026D444080CB15821C243D409038B8AF036D4440607FCFA623243D40903E45BB0A6D444070906B5A29243D40101408910C6D4440E02D27232E243D40B0BEA109146D444070E5E5AE25243D40D87B016E166D44405044257F30243D4088A1B8A8166D4440B0ABB8BC39243D4078269BE61D6D4440A0C4F7E637243D40087D088A1F6D4440E07EB0DD3D243D406833037D226D4440607C6F0F42243D40D80AA5D4256D44402044F2E846243D4058AD5CA6266D444060EE9F2E52243D40F0415E622C6D4440F006F32554243D40B8B962F0306D4440203F704C4F243D4010C7B6B9316D444070B4B99F53243D40C0146A50346D4440D0153A3E5A243D40D8E3B3E7326D444040A3EA5564243D40B8DC6243376D444070154E0B5E243D4018B0D07D396D44408091763C66243D40D806B43A396D44409023BDBD6B243D40A09B2B103D6D4440D06754FB74243D40E04448533D6D4440B0C693CB7F243D40C86FB4334C6D444070C76B3178243D406076A38B4D6D4440F01FB8567B243D4078186F2A526D44408049A70183243D4000594411526D444050BCAF868B243D403875DFF2586D4440307069AB92243D4078CB1D53776D4440D0E59E3193243D40D0B602CC7C6D444010DFB32C98243D40D0C18BE07F6D4440D03597E997243D40B8254D4D826D4440B0894DA59F243D4038FB0F23846D444020B7FA53AA243D40B88054AD856D444020FDFAF9B6243D40D82D2FF4886D44404076F629C7243D40E85E5B76886D444040BD87D2DE243D40201F5EF5806D44409092D48EE2243D4010E8A4677A6D444060DA7033DC243D40D03DF7216F6D444000BE5F38D7243D40887E42226D6D44405003BB0ED5243D4008FEF9A0676D444010490218CF243D4060B0460A656D4440F0E6A913D0243D40F86B39B35D6D4440F0574930D5243D40E88F87855A6D44408020A46FD2243D40002CC618586D4440D03A60CFD7243D40E051F36C566D444050C81230BA203D4038E0847824704440D017EC1ED9203D40E8477EE2007044402012182312213D40E00F77D503704440F0A64CE82E213D4040BBE8B303704440B0B0DECD53213D40985B4BEA04704440F066A62A6D213D40D0C6D314017044406083B72572213D4070324872F96F4440107515DD7A213D4090E41EC2F86F4440208D490B97213D40203B8C65FA6F4440507BD5F198213D40F0B290F3FE6F4440F07AE9BE9C213D40D89ED7B8FE6F444030DF965E9B213D4058011CF0F96F4440805B782CB6213D40F0679444F66F4440D092EA56CF213D40F0348940F56F444070499EE6E4213D4030D9A97AF96F4440D0498A19E1213D40585DB4520870444050E745E2E5213D40D01CDF6B087044407099969EE9213D40A82BE300FA6F44406027B9EF18223D40C8A5B243FC6F4440804AA9C821223D40D84E596DFE6F444030CCF86530223D40F81DA304FD6F4440D072A1444B223D4098A53C2AFE6F444030C4163257223D40A84EE35300704440507C7A8D5D223D4078D6F292FF6F4440205408185D223D405008F77AF76F4440005ECD936B223D4078425323F46F44401025780778223D4010B4548CF36F44401031921E86223D4010E75F90F46F4440E0AE23B891223D40602E9AE8F36F4440708E2123A0223D4000B6330EF56F4440305735FFAF223D40A0B4B6D8ED6F444040544F4700233D4028220AB8E76F444040A7FA0626233D4030D67C06D46F444090C6380323233D40085E8C45D36F4440C03BFC4FFE223D40981B1B60E66F444010B4A53AE4223D40E86DDECCE86F44406093EA08E0223D4038C523D6E26F4440E07A9711DE223D4028447908E36F4440404C26CADE223D4098939507E96F444010567166BB223D40D08C3096E96F4440A0B8B59DB6223D40F0286F29E76F4440006FB090B9223D402006E5EFDE6F444080DD0EDFC2223D401007336FD56F4440F006CBF3E0223D40B80A38D6C56F4440B0AE376BF0223D40B8DDB9DDCB6F4440A093A3A5F2223D40705110E2CA6F4440C023C821E2223D4040FB8E71C56F444000848427F4223D40585939ECBE6F44405065EBFA05233D4010220A45BA6F44408039741E15233D40F8E65F1DC76F444020998B5418233D40E8822897C66F444000912F410D233D40D0F563B2B86F4440B0389CB81C233D4038295BE9B56F444000C0069B3A233D4010C28048BF6F444070D18E813C233D4040F50166BE6F4440E0FB882826233D4090193C6BB76F4440A0B26F4E25233D402092185FB46F444070DC17963F233D404021EF5BAD6F4440400920753B233D40C0B81D19AB6F444060C183D041233D40D8A4DAF7A86F4440703223ED46233D4068ABC94FAA6F4440B0914EF04D233D407016DC60A86F4440E00FCCBC55233D40D88767B0A96F444060C81B4B58233D40C040A371A86F444040CB484C50233D40D8A9D600A56F444010822F724F233D40B8247EA99F6F4440A0CCC58157233D40F05CFBCF9A6F4440606427486C233D40705F3C9E966F4440B0B59C3578233D4088A600DD976F4440504411E676233D40302E9A02996F444060D657677C233D40A8D051D4996F4440C0C638E97D233D40284B0D4A986F4440E0CE94FC88233D4020E0FA389A6F444070F883A790233D40389EA81C936F4440202337EB8C233D40E0E0D29E926F4440008C7AF486233D400849B8AE986F4440A08AFDBE7F233D4098F49FA6966F4440F04325B37A233D40687CAFE5956F4440F0B9466C77233D4060DE91D0966F4440D051DBC875233D40D09233D5936F444090EEBE2B82233D4018F64F72876F4440906AE75C8A233D4070532287886F444020D33E3388233D4050B7E3F38A6F444070C31FB589233D4068CB9C2E8B6F444050FC41AB93233D40603170B3786F4440802F3D3597233D40281B62DD786F4440706923C495233D40082E570C576F4440A0419D8191233D4068D9C8EA566F444060D657677C233D40483170404B6F444070189A0986233D40E0DC5738496F444060D1D5CA84233D4028D41345486F444070B7059E7B233D4060629CC24A6F444050A996EB6D233D40B8D47591426F4440B09D68075C233D40D06BB81B446F44407083ACA756233D40081CB0E9416F444050580D315E233D40381C2603406F44407039BB675D233D40903489743F6F4440006C1D4949233D4038823C0B426F4440B030BA8443233D40F8FA8E183D6F444030DA8F6456233D40205DE71C3C6F4440A006AC1056233D40601113083B6F4440C0B1645243233D40981C12363C6F4440C021736C3D233D4028F57726346F4440104E5C8253233D40D00497A4326F4440A081433F53233D40307DFD7E316F4440B040C5353E233D4078EC3333336F4440308875A73B233D4038ED0B992B6F4440E07451C24C233D40D07B80492A6F44403084840D4F233D40C0D2D91F286F4440F095F8264D233D4030FFF5CB276F444000B18CEC4A233D40C898F390296F4440E0A21D3A3D233D4078A137842A6F444060CB7BE239233D4018BD2D96226F4440704DB7B244233D4010F71325216F4440A04F0C4E44233D40F892DC9E206F444040A3096D39233D40986AF40F226F44407036148733233D4048B716A4196F4440605B6DC83F233D40105C992A186F4440A04E7B4B39233D4060A3D382176F4440C0B0D34F38233D40D8EA83F4146F4440A0090CA837233D40C0FEC615176F4440701AEFBE2A233D4010298E26176F4440200A2B711D233D40C0422B4A096F4440D040F8CB27233D40601F3FC4066F4440800BA8A624233D40A050E15F046F4440409C71F222233D40A0A05FAB046F444020A5A56B26233D40C0CAB0A2066F4440302BD2D51D233D4040A07378086F4440F0BA0A1F11233D4048D2ED79FE6E444040B705B820233D40480AF586FB6E4440F0C624361F233D4080EDF758FA6E4440906F9CA910233D40306EB6F3FD6E4440609CA4880C233D4050927ADFF86E444040B705B820233D4018A9EA01F36E44407034F2811D233D4060BD1956F16E44402038F7E80D233D40487CE222F76E4440009CB85510233D40982E2F8CF46E4440A00BDB3C0E233D4068B63ECBF36E4440C09107A705233D40D0BCB709F76E4440A09E2CBAF5223D40B0E7E066F16E444040E4402D06233D400855BE2CED6E444050207C5704233D409062880FEC6E444090780FE0F4223D40A854D2F9F06E44408086C5F5EF223D40A8F9CA99ED6E4440809D682101233D4080B9E1E5E96E4440C00116C1FF223D4018DB6403E96E4440403DAC1BEF223D4090959313ED6E4440C09FF052EA223D40884CF052EA6E4440D07124DBF9223D40C007F7C8E66E4440A049B265F9223D40B041DD57E56E4440A0F828ABE9223D40308F1AD5E96E4440D0F85B41D3223D407842B5BDDD6E4440B05C1DAED5223D40E8CED4D2DC6E4440F01545A2D0223D40D8252EA9DA6E444090B0D369DD223D40B002B83CD66E444000988072DB223D403060006BD56E4440D04DD695CF223D40F0565A2BDA6E4440F0BF394BC9223D40B8C8D1ADD76E444050C0257EC5223D40F8A4F9F4D86E4440B0FAF73FC0223D40B0E544F5D66E444050A622BBD2223D40083D8AFED06E444010C31FE9D3223D4098E871F6CE6E444080389CD2C1223D40D0B48E8CD56E4440C0C5934DB9223D40D059872CD26E4440A095723AC9223D4050D93EABCC6E444020DD22ACC6223D40800CC0C8CB6E444000C42AE5B5223D40082017B7D16E4440109A4F07B2223D40D8741BF2CF6E444070B7F104C2223D409077D2D9C96E444090533098BF223D4078C31C08C96E4440B0496B1CB1223D40C010E46BCF6E4440D09A276DAA223D4058775CC0CB6E4440D09C4972C0223D4098E7E0F3C36E4440608BC18BBE223D4008C47E54C36E4440A0D2B860A9223D40C082D107CB6E4440909BFFD2A2223D40105291B8C76E4440B0496B1CB1223D4008C47E54C36E444080E1FF78AF223D4008E1F19BC26E4440D09FA909A2223D4008BF824BC76E4440B0F2CEC29E223D40102A955CC56E444030ACAF53AC223D40805BAD11C16E444040C74319AA223D40789593A0BF6E444020B9D4669C223D40981AECF7C46E4440D0D8FE9595223D40D0A2E769C06E444050E2D7DEA7223D4000DB6490BB6E4440E01BD23AAA223D40D024E0B6B66E4440401CBE6DA6223D40D0D4616BB66E4440C0636EDFA3223D4050052CA1BB6E444050E6C87894223D40789593A0BF6E4440805DAECA85223D4058153752B66E4440A02CB5519D223D40588724EEB16E4440F09062F19B223D40E86517EAB06E4440903E5C0185223D40704663D4B56E4440B0F52E5A80223D40A89478B7B26E44403084707495223D403895DA03AD6E44407048217D93223D40E8D70486AC6E4440804C121780223D40A01EDD91B16E4440D086E4D87A223D40D88965BCAD6E4440A0812FA699223D4078D866D2A66E4440A05B12CC98223D4088099354A66E444040A3F5D37F223D40406DDEA7AA6E44403077C55A7C223D4020438DB0A86E4440B0EB364888223D404810F8C5A56E4440A013F02076223D40E82C7FDAA86E4440D030D98173223D4070F5D919A66E444010EB917879223D4070C2CE15A56E4440C0991C8B6D223D4010175D37A56E44403025AB9D61223D4098D92A6B9B6E4440F0D199B168223D40B8A874029A6E4440D024BF6A65223D40F03BF988986E444070DED2915C223D40C03B836F9A6E44405064465F41223D4068C70D2F886E4440C0F2877956223D40F877F12F826E44409068F09540223D408879E47E876E4440905754E23A223D40B096CDDF846E4440203CD4E940223D4098FF8A55836E4440A0499ECC3F223D40981CFE9C826E4440F0BD561D39223D4050B850FD836E4440F05CC2B12E223D403033F8A57E6E4440F01D5A8638223D4078CFAC527A6E44407005078F36223D4040D611C4796E4440D0AFE76A2B223D4080404C6F7F6E44404030ED681C223D40208A517C7C6E4440A0F8141230223D4040AE1568776E444040E78C2B2E223D40387B0A64766E4440E0DF087E1B223D4068D18BD47B6E4440A0E0E0E313223D40002DF580796E4440E07A837824223D40705E0D36756E4440A0316A9E23223D4008D00E9F746E4440F0A491EC11223D40881D4C1C796E4440C015786C04223D4060825B08726E44400025ABB706223D40481E2482716E4440807C66DAFE213D4008E7F4DA6C6E4440602597EA02223D4038CAF7AC6B6E4440B00AEF5701223D40E08998DF696E44400097DBD616223D40D868770E656E4440F0AF1A0115223D40D8356C0A646E444070B7DD6B08223D4088B62AA5676E4440305D28DE01223D4058C6BF3C646E4440A0C68AB0E1213D40309DBCC4586E444030F10A5EF4213D40E887FC6D4F6E4440D03A106BF1213D404050E1934E6E444070D8FEC9DF213D4090F8AF57586E4440908839A8C4213D40106DDEC14F6E4440A07470F3C6213D40083AD3BD4E6E4440A05E5ECAC0213D40809EF6764B6E4440F03FC59DD2213D400851B9F9466E4440E05804C8D0213D40A0723C17466E4440204B8148BF213D40804E782B4B6E444010DF63C8B1213D4008D93E52446E4440C09F0F6ABF213D4038613AC43F6E4440E05CF561BD213D40A06CAF0B3F6E4440806B83DDB0213D4090C995ED436E4440A0B7C9B8A9213D4068A61F813F6E4440E05B645FB2213D40E8D05CAB3D6E4440B017CD21A9213D40601311143F6E4440B027D8D2A3213D4028527D923B6E4440C09908F2B3213D4090680182396E4440F0DC0E2DB2213D4028A7F7E6376E4440D0CE9F7AA4213D4030F09AA73A6E4440B0C1C1CAA1213D4028A7F7E6376E4440908617A3AE213D404093B4C5356E444080C0FD31AD213D40284CF086346E444030CF8BADA0213D4070EE313F376E44404045AD669D213D40D8D1AA2A346E4440B0D25D7EA7213D40B0C4CC7A316E4440908A083D9B213D4090627476326E44404050367BA0213D4028A16ADB306E4440B02647D098213D4028F1E826316E4440D0DF3B2EAA213D4038AA9A012E6E4440C09877EFA8213D40A8A3ABA92C6E4440701D272499213D40305CFB372F6E444070D2A4E194213D40F00C5552276E4440A054134889213D4068F9FD63216E44405013A90B78213D40F0DECBEA1D6E444090ACBA9D7D213D4070B98AC91B6E44406023B4BC72213D405817BF2A176E4440F0ACA6D079213D40B84AB661146E444040DCEF7D71213D406848EBAC166E4440003DCB4C69213D40A0D0E61E126E4440C0F4427573213D409875DFBE0E6E4440203A9E4B71213D401002FFD30D6E444070C9EA6168213D40886CAF98116E4440B01786D860213D4078F61373106E4440607B8EA850213D4050A61F0E126E444060760C0C59213D4030D1486B0C6E4440F0BF111956213D40400275ED0B6E4440B0FACF0D4D213D40D8E6F4F4116E444020E1EB1340213D4098BA4E62106E444060C57FE849213D40B0A07E35076E444090426CB246213D40D0A2D3D0066E4440C06F60C43E213D40307CCE16106E444070FA16713A213D4068425EA10F6E4440E071B55F3E213D40A0ADE6CB0B6E4440A0889FEE3C213D40005958AA0B6E4440B05EC41039213D40C8EDCF7F0F6E4440806FA7272C213D40F8ED45990D6E44408070382A37213D4038145F20086E4440F0363ECE34213D4048458BA2076E4440207FC6A52A213D4090AFC54D0D6E4440D0FEF33D23213D40A0FD64170C6E444090005DA626213D40C004B6BB076E4440C0B72FFF21213D40781883C30B6E4440E0BD75340E213D40D8186FF6076E4440A00FD75416213D40C076A357036E444070CB3F170D213D4070DAEEAA076E4440004F2BB308213D4020CD9AE1066E44400010C38712213D407084E353006E4440B0DA72620F213D40E86081B4FF6D4440C065154207213D40207D1C96066E4440E0115F86FF203D4078627403056E4440006ABF7806213D4070F1D4E6FF6D444080A0D336FE203D400053CB9E046E4440103F5398F7203D403836CE70036E44400014B421FF203D40402966DAFE6D4440D08AAD40F4203D4078EAF95B026E444080094AD6E1203D40D0A142CEFB6D4440507C525BEA203D4070CED493F96D4440B06BA2DAE0203D4040CE5E7AFB6D4440502BC9A0DA203D40B86A8940F56D4440E03C841DC6203D40A06DB641ED6D4440D01C6EBBD0203D40E06B4DD9E96D4440E0370281CE203D40109FCEF6E86D4440C0F5BFDEC4203D4000C9A9D4EC6D4440409CE2B6B6203D40882BEE0BE86D444040F2ED0DBE203D4050EDE3D9E56D4440A092D6D7BA203D401011BC92E46D4440208F0407B4203D40701735D1E76D4440A030B169A5203D402835807EDF6D4440808FF039B0203D4088ADE658DE6D4440D014453EAF203D40E8254D33DD6D44407068425DA4203D404066AC00DF6D4440E017A5D590203D40A8A9AEE8D66D4440F0A7C95180203D403067FA7FD56D4440705590CB7F203D4000448413D16D444070996E6C76203D4080633829CC6D444020199C046F203D40784DA06CCA6D4440C018B0D172203D4008F98764C86D4440B09C87A06A203D40B8CEC053C86D4440C0B083EB51203D40C8F95FCAC06D44403093AE5758203D40D814F48FBE6D444080575F6056203D400898F3F8BD6D444040BE4DCE50203D40E02A8C4CC06D4440A0AD9D4D47203D400065E8F4BC6D4440004E861744203D407025618DB36D44402006EA724A203D40D0D0D26BB36D4440B073B7BE48203D4038694FA8A76D4440A0C9C21550203D40E83E8897A76D44403077898F4F203D403053B7EBA56D44406049F0AD48203D4060CBA7ACA66D444020F54DBF44203D4060CF9846936D4440C059E7913F203D4020F370FF916D4440E0B0B6813B203D405098DFB88C6D4440306ADE7536203D409041FCFB8C6D4440B0C22A9B39203D401810E446916D444030BF58CA32203D403857A885926D4440404585342A203D4040C2BA96906D4440B0D1A44929203D40D0C21CE38A6D4440606906103E203D40F041E82E896D444000130F863A203D40E048C3B9866D444040A5889D29203D40B8D0D2F8856D4440C0362A4F20203D40984B7AA1806D444040500E492D203D407066984D806D444010289CD32C203D40182639807E6D4440404F7D4622203D409035E2E47E6D444000A6600322203D40682804357C6D4440D033FD4D28203D40803CBD6F7C6D4440B07C2AF52C203D4018A831CD746D4440103294E524203D4078032560746D444020B33EB324203D40287E56EF706D444030DEDD291D203D40B89B2B836A6D4440906D2A4014203D407064FCDB656D4440E0E1E2900D203D4020019DBB5D6D444040EEE8DA17203D40308247895D6D44407071E84317203D40F0382EAF5C6D4440E0E1E2900D203D4090DD3A1C5D6D4440D0AA290307203D4088660EF4506D4440203B071C09203D40A8B1C3CC3E6D4440D000355A0E203D40304713083B6D4440101068A510203D4070C7A2EC2D6D4440D0D268E21D203D405802D7FA226D4440F0C4B2CC22203D40A82611001C6D4440E04499012E203D403044E693156D444070DE96C62F203D40F0943C450E6D444030918C5242203D40C8FFD83C0E6D4440E066C54142203D4038C6DEE00B6D4440103325E82F203D4018F794490D6D444080E91FDB32203D40986536A8FD6C4440B0D9CDC64A203D40C801EBE1CB6C44404013C8224D203D40C821BEC0AC6C4440A0B9B76455203D4028499BE09B6C4440E058DC955D203D4018DFD64E946C4440C0B71B6668203D4018DFD64E946C444090F42EF65E203D40207DF463936C4440F08F952364203D401855B5847C6C444020BD89355C203D40881E1BC05B6C44400000A43D5E203D4018CA02B8596C4440109CE2D05B203D4008215C8E576C4440B0F101F566203D40B0357715526C44401047687C5F203D40C876AE484C6C4440101F299D48203D404873620B416C4440E0F6B62748203D40C8BA127D3E6C4440A01223533E203D40D07A9FE2386C444040519F4B38203D402865F358336C44408098962023203D404861BBE82B6C4440506E02A60C203D4080CC4313286C4440606B5BC5E21F3D4088DBBDC1176C444020D1B830D21F3D40806491990B6C4440B0B4A735CD1F3D40581E1BDA006C4440F0B3CFCFD41F3D40E0906AC2F66B4440E01E29B7ED1F3D40887D89EDEE6B4440909FE751F11F3D40C8C511C5E46B4440F004598AE41F3D40E86BCEFDD56B4440B04E912DCB1F3D402886CD6DC26B4440E07C1642CE1F3D40D0CDF3F8BD6B444090362A69C51F3D4040D28DB5BF6B4440001955D5CB1F3D40A0CCECDCB46B4440A023F2B6D21F3D40B0F28F4AB16B444000E797C3EE1F3D406072BDE2A96B444050F6CA0EF11F3D4028D9AB50A46B444070043AC1FE1F3D4008D1C9A99D6B4440B058DCAF02203D40203365BE836B4440F0BC894F01203D4000868A77806B4440B01D651EF91F3D40B8BB4C637B6B444060DCFAE1E71F3D40E8DD31CD746B4440B00531F0DC1F3D40E82C1F166A6B4440D04CF52EDE1F3D4008D9685A626B444020D1B830D21F3D40B06A8025576B4440300872BED81F3D4030453F04556B444050AF3966D91F3D40209C98DA526B4440A068615AD41F3D4020B90B22526B444070060956D51F3D40A0C6D504516B4440A0CDE65FCB1F3D4050B9813B506B444070956939D01F3D40E0ECEE8B4B6B444070EF652AC41F3D4030E4AA984A6B4440805F7444BE1F3D40303925ED466B4440D0DF46ACC51F3D40602E12F2416B444090E01E12BE1F3D4048FC546D376B444060294CB9C21F3D40B012D95C356B44404061DDACC11F3D40D0FE953B336B444010FA020CCB1F3D40C87083D72E6B4440D050E6C8CA1F3D40E8EF4E232D6B44400028CF83BB1F3D40189B4AE82E6B444010536EFAB31F3D40802FD68A366B444060272AB4AC1F3D40A8A7C64B376B44402019886BB51F3D40485260C43E6B4440C0667E129F1F3D4040EDDABE476B4440203E9A63791F3D400888DF9F526B444060FC43F46B1F3D4090F0B0E2546B444090D29BAC511F3D40F8CE2DC5556B4440E0D645E3501F3D4060953369536B444080821DEE231F3D4068B0C72E516B4440D04B5093191F3D402041917A4F6B4440500922BE131F3D4088B21CCA506B444060D32CC9011F3D40E87A01F04F6B444010434FB0FF1E3D4058C98CEC4A6B444030441349F41E3D40908F1C774A6B4440108126D9EA1E3D40D881DC7A4D6B4440401FBA07E81E3D40C0C82AA0506B44403092F522DA1E3D40A0C6D504516B4440E0AB0CB3D01E3D4008FACC3B4E6B444090CAA5DFBE1E3D4050EC8C3F516B4440E03E5E30B81E3D40F0F09C15516B4440506AE9D9AC1E3D40D088B7054B6B444040EEC0A8A41E3D408807971E4D6B4440E08C400A9E1E3D40A8A3D5B14A6B4440E08A1E05881E3D4030C737514B6B444030FFD655811E3D40908F1C774A6B444000D764E0801E3D4070BA45D4446B44406037547C7C1E3D40F0C213AE476B4440F0542910761E3D40185877B6476B44406076BCA7721E3D4020B37E164B6B44406091506D701E3D40C0348B30456B444090ADA8CB621E3D4050EBFB3C466B4440E026E3B8531E3D40A0C048F9496B444000D32CFD4B1E3D4008DD59F44E6B444020C4E5E4451E3D40388855B9506B4440F0394E01301E3D40B08CEF75526B4440E0B71231251E3D40C0C82AA0506B4440E0C71DE21F1E3D40F8D329CE516B444090212EA0171E3D4028241E33506B4440903CC265151E3D4048F367CA4E6B444010E47540121E3D4008DD59F44E6B4440902B26B20F1E3D4028572937516B4440209E759A051E3D4088CF8F11506B4440A040B3FF011E3D4040C05CC64D6B444010224D69FD1D3D40603A2C09506B4440C096F1ECF21D3D4018A37365506B4440B06AC173EF1D3D40582A2158556B4440506F57DDEA1D3D4008B0DBFB546B4440B0CF4679E61D3D402807ABEB506B444000D35FADDA1D3D40C0C82AA0506B4440101E1586C81D3D40E01A78F3546B4440505501AAB81D3D4038AB550C576B444020E78E8EAB1D3D40209C98DA526B4440203180CEA41D3D4058CF19F8516B444010A4BBE9961D3D4078F96AEF536B444040DC3810921D3D40F85BAF264F6B4440A00B82BD891D3D4050F188484D6B4440E0C318AF791D3D4088240A664C6B4440D02BCBB5681D3D40C0C29D94496B44405082F5D5551D3D4030E4AA984A6B444020A2529B381D3D40D8DCE3DA506B444010DC382A371D3D40506407E7536B444020DBA7272C1D3D4088A21119566B4440B0192420261D3D405863B9675D6B4440B008886C201D3D406829D3D85E6B444030C659971A1D3D40D85AEB8D5A6B44407048C8FD0E1D3D40982949F25C6B4440901A2F1C081D3D40309B4A5B5C6B444070F6AD40F41C3D40C82F4C17626B4440F0037823F31C3D4070288559686B444090476A91ED1C3D403074596E696B444080CAB05DDA1C3D40F8ADC9E3696B444010A3164ED21C3D40602B6F4A796B4440A021804DD61C3D40E050B06B7B6B4440C023D5E8D51C3D40B81CE1CE856B4440D0AF08CBD81C3D4010D5BA438A6B4440105AB610E41C3D40E83F573B8A6B4440304C00FBE81C3D4080D954008C6B444060DA8878EB1C3D402029E718906B4440D04F0562D91C3D40108C5A069C6B44405050242BBF1C3D40B03BF0879F6B4440E05265F9BA1C3D40A0B549B1A36B444030E34212BD1C3D40887A9F89B06B4440D08C4B88B91C3D40A8E28499B66B4440A0472348A51C3D4060BE4A94BD6B4440C04CD87A861C3D4030F1DF7EC06B444000DD2F8D5F1C3D40C812639CBF6B444050005F23491C3D401077103CBE6B444030A166B62B1C3D40B85324B6BB6B444060D9E3DC261C3D40D87D75ADBD6B4440D09FE980241C3D4048892D78D16B4440104A97C62F1C3D40E0503A38D86B4440505D02F5661C3D4008A8C617ED6B444070C81479921C3D40C0611DC2F86B4440C0B62666BD1C3D40A84E6FF6076C4440D0A3EEB3CA1C3D406850D85E0B6C4440A0CA3664031D3D4060EB5259146C4440607D2CF0151D3D40F0F7CEBC1C6C444080EC2F0E2E1D3D40906F5D31236C4440C0B17119371D3D40885F5280286C444020B3EE4E3E1D3D4000A893F4306C4440D0E4390D511D3D4068A9CD19516C44408055EDF6591D3D4080E086A7576C44406063A30C551D3D40D8AEF8D85D6C4440C0038CD6511D3D40907965A3736C444080440AFA0B1D3D40301151C3B76C444070B74515FE1C3D40C03A406EBF6C44404039C848F61C3D406883F7FBC56C444030B81D7BF61C3D4008DE1229CD6C4440E0D747AAEF1C3D4078FA2324D26C4440F03D5EB2F11C3D40B8FE47C7D56C444090EB57C2DA1C3D4070C9B491EB6C4440A05B66DCD41C3D40204A732CEF6C44402018A704C41C3D40D0ADBE7FF36C4440509A156BB81C3D4088F4968BF86C4440C0FF86A3AB1C3D40089DDB68006D4440701FB1D2A41C3D409000B1A2066D4440303A8CFB8F1C3D40884BAD510F6D44403079F426861C3D40705AF469156D444090CE5AAE7E1C3D40A00B7D3A1E6D444020FBA9F0671C3D40787CA63D256D4440301A2F50521C3D40B0A3CA332F6D444050005F23491C3D40F8857F86376D4440900378573D1C3D4078B7DABE476D44405065E428401C3D4048BDF1B0506D444060EB57DC7F1C3D40008D5A84626D444010D833F7901C3D4020DAABCE6A6D4440200BFCEAAA1C3D4030E57766826D4440902C8F82A71C3D404855C903916D4440701FB1D2A41C3D4028BF177C9A6D4440E04E2D16861C3D40A0EB33289A6D444080A3BB37861C3D40085DBF779B6D4440A0A726B1A41C3D40588786889B6D4440A0A726B1A41C3D40301A1FDC9D6D444030C5FB449E1C3D40407E56629E6D444090E68EDC9A1C3D40300339A0A56D44405028E54BA81C3D404084E36DA56D4440B08EE786A61C3D40E80B7D93A66D4440B02D531B9C1C3D40D8BDDDC9A76D44404056B1C3981C3D40A01F4A9BAA6D4440205A6FC79B1C3D40C8E7B8A7AB6D444030CB0EE4A01C3D40D818E529AB6D44400053988FA41C3D4068974E29AF6D4440901BF3CEA11C3D406032C923B86D4440603CE1968F1C3D40C898CB5EB66D444070BD8B648F1C3D40C0DD3A02B86D4440C0F4FD8EA81C3D40D824FF40B96D4440901BF3CEA11C3D40C05B42B5C16D4440F071EA58A51C3D4060004F22C26D4440502D67E89F1C3D40381671C5C56D444020E9CFAA961C3D40F81CD636C56D444030847D3B891C3D40B8463BFBCA6D444000017ED2891C3D40E019331CCF6D444040AB2B18951C3D4060EFF5F1D06D44408065E40E9B1C3D40E8A74580D36D444080566A60AB1C3D40882FDFA5D46D444020B68196AE1C3D4040601FF5D76D444010E1ED76BD1C3D40982E9126DE6D4440200D1EF0C01C3D40F8D90205DE6D44409042A1ABAD1C3D40000C7D06D46D444050A59E7FBB1C3D4060B7EEE4D36D44405040197AC41C3D40F0BDDD3CD56D444050359065C11C3D40D8219FA9D76D444050A62F82C61C3D4068CD86A1D56D4440E0852DEDD41C3D40C8D3FFDFD86D4440F0414F4CDE1C3D404066AC00DF6D4440C0D9E3A8DC1C3D40A0A5BD4EEA6D444080BF2749D71C3D40D01DAE0FEB6D4440E030B398D81C3D40985DAB90F26D4440C0D9E3A8DC1C3D4088BF8D7BF36D44401004ABB9DC1C3D40E0AA72F4F86D4440309951D2C31C3D40909D1E2BF86D44402018A704C41C3D40D029C826F96D4440F0B2EE68E31C3D40D83F60E3FA6D44404039C848F61C3D40D8EAE58EFE6D4440C02BFE65F71C3D40B899A3AA096E444060146F07EA1C3D4048BD054A0A6E444030079157E71C3D400004DE550F6E4440B0E799BED71C3D40886CAF98116E4440F0F6CC09DA1C3D40C02D431A156E4440D0F9F90AD21C3D4028174911196E4440006C5DC0CB1C3D4078741B261A6E4440000A3852B61C3D4098F3E671186E444060C5B4E1B01C3D40000A6B61166E444050D75B91981C3D40B872B2BD166E4440003B6461881C3D40E86D2CCE186E4440D0820006821C3D4088C2BAEF186E444010118983841C3D40B81D38691A6E4440305C3E5C721C3D40A81F17EB1B6E444060E935D7691C3D40A0B900E3196E444050ABE4CE4C1C3D40B850436D1B6E4440301A2F50521C3D4020EACA181F6E444060D68345451C3D4090004F081D6E4440007FFBB8361C3D40D87A94641D6E4440C069C1F5281C3D40C871643E206E444010E9025B251C3D40A87A1E4B1F6E444080BF13B01D1C3D40B090B607216E4440504005E10A1C3D40C871643E206E444040B4D1FE071C3D40D02CF59A1E6E444090A3217EFE1B3D40A08786E1236E44408061DFDBF41B3D4028C85BC8236E4440F026547DE71B3D405002B870206E4440E09A209BE41B3D40084E8C85216E4440E0BA36FDD91B3D40C8A46F42216E44402059CA2BD71B3D40E873B9D91F6E4440F01433EECD1B3D40D8F20E0C206E4440D02D7218CC1B3D40F8C158A31E6E4440B0DB24C5C71B3D4040810DA3206E4440E058118FC41B3D40286D5468206E444050852D3BC41B3D40E840AED51E6E444070B0CCB1BC1B3D40D0DC764F1E6E4440C02F0E17B91B3D40E0B8287D216E444060DE9829AD1B3D4060E365A71F6E4440A04DCFDDAE1B3D4000E37974236E444030162A1DAC1B3D4060DE699E236E4440E0EAD109A11B3D4010B99E961F6E4440C033FFB0A51B3D4038C67C46226E4440407BAF22A31B3D4098547BDD226E4440C08DFBA1991B3D4040318F57206E444020DEDF8C9A1B3D40B8EBBD67246E444050604EF38E1B3D4048F2ACBF256E4440C08C6A9F8E1B3D4010872495296E444040E425C2861B3D4098550CE02D6E444070B68CE07F1B3D402063D6C22C6E444030E6C1C0731B3D40B87F5DD72F6E4440402E1702801B3D408835F67D386E444050643F8D7B1B3D40D80A433A3C6E4440E0729A72851B3D40A0F434643C6E444080E2BC59831B3D40D0EFAE743E6E4440C0D5CADC7C1B3D4008FBADA23F6E4440D0905B397B1B3D4088B3FD30426E4440A01EF883811B3D40409FCEDC436E4440007BF685901B3D40706C39F2406E4440B017DAE89C1B3D40C09104FA446E4440A0D1A6ACA61B3D4098AC22A6446E44401024E032A71B3D403834BCCB456E4440F00788D4B41B3D4048825B95446E4440E04D887AC11B3D4048275435416E444080AE30B3CF1B3D40185FE528406E4440C09D4D9CDC1B3D4048CC4CD53D6E4440702A264EEE1B3D4060C392C83E6E4440108BCE86FC1B3D4038A6A967416E44402007F7B7041C3D40601311143F6E44409099296C061C3D40A044B3AF3C6E4440F0EA9E59121C3D40A011A8AB3B6E444050A1994C151C3D4030A01C5C3A6E44405003BFBA2A1C3D40B8A8EA353D6E444000E511C1381C3D40A0F434643C6E44402082E156411C3D40F884127D3E6E44407018C6E74E1C3D40F884127D3E6E4440C0727B75551C3D40F01EFC743C6E4440F0CDB5DE6F1C3D40D8B5C8E53F6E4440F0122582711C3D40D8604E91436E4440F083C49E761C3D40E010D045436E4440E0AD9F7C7A1C3D40A88247C8406E444090CBFA169D1C3D4048D7D5E9406E444070F05358A91C3D40A8DD4E28446E4440F0891E87C11C3D4020200391456E444040D00A60CA1C3D4090E60835436E444020DB60DEE31C3D408048EB1F446E444030AD9466F31C3D40B0F3E6E4456E4440003CC2B3041D3D4040C2CE2F4A6E444030004026191D3D404073E1E6546E44406028B29B191D3D406830414B576E4440A033F44C2F1D3D4038EB5B8E576E4440901FF801481D3D4060F8393E5A6E4440E0BBEF31581D3D4028C0BC175F6E4440902CA31B611D3D40F07C3049656E4440B066BC40491D3D4068CA6DC6696E444030DA9C2B4A1D3D40481897766A6E4440C0541591611D3D40C8CA59F9656E444010907855671D3D40D0586C5D6A6E4440F01C849D621D3D4008E7F4DA6C6E4440D0E65B12671D3D40D05EF968716E4440809E4D34481D3D4048192879756E4440B066BC40491D3D40D81F17D1766E4440F0D2925D691D3D40B08FAFD1726E4440E01D15A06D1D3D4088A5D174766E44404046BAAB571D3D40B8953CDD796E4440A0B967006F1D3D4018C93314776E4440E00888527B1D3D40A0E2170E846E4440108FE7525C1D3D40E8F14A59866E44406059ABFA5C1D3D4060E48076876E444000D1F65E7C1D3D40E0DBB29C846E444010A8AC83831D3D40E0E2D0AA966E44403082C23F6C1D3D40B8FDEE56966E4440501E01D3691D3D40A0113278986E44409034CC98821D3D40E075DF17976E444080092D228A1D3D40C8A69580986E4440F0FB623F8B1D3D40D82DCD599F6E4440F03327C9731D3D407865E833A06E4440A0D19B2E8B1D3D40B87BF609A06E4440D033F4328A1D3D4008844ECAA46E444010EC8A247A1D3D40585E978FA46E444080092D228A1D3D4038ACC03FA56E444050E1BAAC891D3D4078BBF38AA76E444060C6597D751D3D4068A73A50A76E44401098A1D2881D3D4040F56300A86E4440F03549CE891D3D40B0A48368AD6E4440F0D32360741D3D40680242B0AA6E4440A00960B8731D3D4028DC2829B06E4440A0B57666821D3D4088D71853B06E44400061E844821D3D4008ADDB28B26E4440E00D0AEF721D3D406808CFBBB16E4440B0DF84DA6F1D3D40C83D6264C96E444070BE3000541D3D4078A1ADB7CD6E4440102E53E7511D3D40E84A4014CC6E4440C0038CD6511D3D4068F384F1D36E4440A0EA930F411D3D40481F3F51D96E4440E0DDA1923A1D3D4080E5CEDBD86E4440A0B0AD80421D3D40C81CFE82DD6E444000ADA819521D3D400843170AD86E444000F217BD531D3D401081AB22DC6E444090912821581D3D40A0879A7ADD6E4440C00E15EB541D3D4090940211E26E4440303B3197541D3D4080DB5036E56E4440505F3893361D3D4020B864B0E26E444050DACFC1331D3D40C8001C3EE96E4440B0CB4146401D3D4078F8C37DE46E4440D0742BF3561D3D40603F12A3E76E4440902B1219561D3D402807957CEC6E4440E09FCA694F1D3D40B8DA78D0EC6E444070C828124C1D3D40C09B9638F26E4440B086D2A23E1D3D40F06E8E59F66E444060A0E932351D3D40A0E9BFE8F26E444060A0E932351D3D40B0E7E066F16E4440700B82D72E1D3D4080E76A4DF36E444010161FB9351D3D40A8AFD959F46E4440B024AD34291D3D406861C476F76E4440F05DBB5D2F1D3D40F0191405FA6E44407082286C3F1D3D40F0E60801F96E4440604D91E34E1D3D40F8E5BA81026F444040B0C14D461D3D40C03C9E3E026F4440B06B3EDD401D3D40C85DBF0F076F4440101DB7334C1D3D40F8B340800C6F444060F203F04F1D3D40A0A6ECB60B6F4440C002FBD3461D3D4060CFC078066F4440E09FCA694F1D3D406074B918036F444020FFF56C561D3D40A8566E6B0B6F444050C8F57B621D3D4010A0FD5E0A6F444070906488631D3D40C83B50BF0B6F4440F071FEF15E1D3D4060F2C0CB0C6F4440406370766B1D3D409869630D176F444070F067F1621D3D40E028180D196F4440507E043C691D3D4028705265186F444060C5C87A6A1D3D4090315C001A6F444090E6A275541D3D4078459F211C6F4440C0AE1182551D3D40C00454211E6F4440103BFE006B1D3D40E88E2E151B6F4440600A381E6C1D3D4008B97F0C1D6F4440E0C89A4B711D3D4058C6D3D51D6F4440405EEED9731D3D402078BEF2206F444080F5E98D5A1D3D4050064770236F4440000E3D855C1D3D4000047CBB256F444040FEEA70741D3D4010DAA0DD216F44407047044B751D3D4010852689256F444050C8F57B621D3D40D8E6925A286F4440400D651F641D3D4040A89CF5296F444050DF98A7731D3D4028CCEAC7266F4440D0F87CA1801D3D4010A826DC2B6F4440405365C5701D3D40203AE7C9356F444030E2C5A86B1D3D4070B42C26366F444060C5C87A6A1D3D40C0566EDE386F4440000054D9771D3D4000C1A8893E6F4440805D16747B1D3D40D038AD17436F444020FC95D5741D3D40408DC51F456F44407047044B751D3D403872315A476F4440205692C6681D3D40A8FE506F466F4440001BE89E751D3D4060EA211B486F4440108C87BB7A1D3D4090B81D33506F4440A002C83D5D1D3D4060B8A719526F4440908CA684601D3D401854FA79536F444090DEC0417B1D3D40B8300EF4506F4440708D04F1811D3D4028DB31535A6F444070E1ED42731D3D400052E861686F4440001A579C6A1D3D40C8B354336B6F4440801938D3841D3D4058C0D096736F4440607DF93F871D3D40680E7060726F4440A00AF1BA7E1D3D40D0F1E84B6F6F4440508BAF55821D3D40486CA4C16D6F4440B0F7B8088C1D3D40607B61F3716F4440B0E1A6DF851D3D40D895936C756F4440B0EDC0F6931D3D40B888B5BC726F44406018743A901D3D40801D2D92766F4440D0EA93F59B1D3D4078EA218E756F4440C01FF8E7A21D3D4050FAB625726F4440009CD9B5BD1D3D4000F3EF67786F4440E03981B1BE1D3D40B8E3BC1C766F4440B072A3A7C81D3D4020A5C6B7776F4440E03A12B4C91D3D407024081D746F4440501D3D20D01D3D4098EC7629756F4440A03BEA19C21D3D402821EFE87F6F4440403BFEE6C51D3D40681A8A77806F4440802A1BD0D21D3D40C814E99E756F4440701A101FD81D3D40F88CD95F766F44409071DF0ED41D3D4090F9DEBF796F444010540A7BDA1D3D4028E35AD07B6F444040370D4DD91D3D40A8B2909A766F444050C4D131E71D3D4000F3EF67786F4440C0FAE5EFDE1D3D40C027DE40816F4440A0A31600E31D3D4058CCEAAD816F4440E0FDCB8DE91D3D4088C6D3BB786F444030CE96ADF51D3D4090F9DEBF796F44407027BB38F11D3D4090CC60C77F6F444010CC4112F61D3D40A84B2C137E6F4440A0DF1E94F71D3D40E023A6D0796F4440F0CA7D79011E3D4068647BB7796F4440E0AC891C221E3D4080D9C85D846F444030E2D941251E3D4068CB9C2E8B6F444040B8FE63211E3D4018A1D51D8B6F444030F2E4F21F1E3D40B84ADE93876F4440A09D56D11F1E3D40F00B72158B6F4440A012E787111E3D40D0E7AD29906F44405038182F161E3D4010E148B8906F444060BA53FF201E3D40802FD4B48B6F44409038D1CB281E3D401003B8088C6F4440E0FC81D4261E3D4088FB7A31946F444010472CB1321E3D4098A4215B966F4440508BC3EE3B1E3D40B8A676F6956F444070F9350A491E3D40382CBB80976F444050E866C0591E3D408873F5D8966F444010A560855B1E3D4058CE861F9C6F4440C0251F205F1E3D40684F31ED9B6F444020C0F44A591E3D407036AF3F896F4440F0E77A8D5D1E3D409005F9D6876F44404079E9A86A1E3D40500C5E48876F444060D750137D1E3D4038701FB5896F4440602CCB67791E3D404874CD3E8F6F444090C5DCF97E1E3D40A0AE9F008A6F4440500D46088F1E3D40C0D8F0F78B6F444030107309871E3D40087636A7926F4440300D1372A51E3D40181FDDD0946F4440A044B832A81E3D40A004AB57916F4440F0248E03AF1E3D402057E4DD916F4440706C3E75AC1E3D40E0584D46956F4440E0E852D9B01E3D40C82721C4956F4440706DCF77B71E3D4088456C718D6F4440902F2BE5B51E3D40C8C10ABC936F444020949121C71E3D4058FB0418966F444030E6DE74CB1E3D40C8990E60916F444070908CBAD61E3D40803561C0926F4440B0D81492CC1E3D40E096E15E996F4440E04B094AD11E3D40E8796E179A6F4440C05A5062D71E3D40B0E05C85946F4440C071F38DE81E3D40B00859E1966F4440A0B8FE2FD71E3D4048D6F2ACA46F444080C74548DD1E3D40C878AA7EA56F444090F406C4EB1E3D40A0D72C5F976F4440D034AD67081F3D40503B78B29B6F4440E0CF5AF8FA1E3D40680044A4A66F4440C018889FFF1E3D4098783465A76F4440504D005F0A1F3D4040BACDE49B6F4440D0353E6A131F3D404880E7559D6F4440E0CD8B63241F3D4020B9094CA76F444080221A85241F3D40183184F3A96F4440801E29EB371F3D40E0E26E10AD6F4440A0F1200C3C1F3D4088A20F43AB6F444030AC929F541F3D4060F038F3AB6F444090B707E7531F3D4030404125AE6F444080EC6BD95A1F3D40D094CF46AE6F444050C4F9635A1F3D4098844E7CB56F4440E0E25FFA5E1F3D4070EFEA73B56F444020470D9A5D1F3D40585D2A86AB6F4440C0FC2F27681F3D40184EF73AA96F4440400B8B0C721F3D4008005871AA6F4440A0EF5177651F3D4000F6D9CBB66F4440805313E4671F3D4000465817B76F444030CF4FE2731F3D4048A974B4AA6F44403020D99C831F3D4018548446B06F4440E0A488D1731F3D408836AFB2B66F4440D0C3DA9A741F3D4078608A90BA6F4440D07689C3991F3D40006FE575C46F444080AD561EA41F3D4048DE1B2AC66F4440100B9FBFD01F3D40D0017EC9C66F444070B18E01D91F3D4008900647C96F4440008963EFC51F3D40B050387CD26F4440F051AA61BF1F3D4060D6F21FD26F4440A0DDF110C61F3D40D02A0B28D46F4440607553D7DA1F3D40D0C976BCC96F4440602CF399EC1F3D40E01DA391CF6F4440F0567347FF1F3D404007A988D36F44406035AD1919203D40B0C8B223D56F4440A0995AB917203D405056D954DD6F4440F06F387826203D4060FF7F7EDF6F4440700C633E20203D4020E08405F76F444060FC578D25203D4038F43D40F76F444080B4BBE82B203D40A0F81A0DE06F4440B005458996203D40B03561A6ED6F444030426CE690203D409066170FEF6F4440E017A5D590203D40F0D981E0F16F4440D04C09C897203D4090DE91B6F16F44407041948098203D4050DA6D13EE6F444080A72468CC203D40700A4C16F76F444020D504ADC0203D40287FAD8905704440E0D66D15C4203D4030E5C39107704440C0CD80FFAD203D40F8035D312370444050C81230BA203D4038E084782470444090E79B2155183D40A04CB224407144404013E0675C183D40B898726C3D714440B0E6902573183D4050EFDF0F3F71444080C425287E183D405898863941714440508CA80183183D4038BEB38D3F714440E037D37C95183D4068E6250340714440A0354B4BAC183D40688B1EA33C714440404C0244C1183D40004D9E573C714440A082E36BCF183D40D05124473A714440A0248636DE183D40D06FAF6B3A714440B01A3165E0183D40304D14713A714440909C0F88E4183D40E88F0D8B36714440B02BCD18E6183D4050215A113571444030198199EF183D40F8E0FA43337144401088FD1702193D409058492F327144401034E2C803193D40C8D5FB1532714440406B674209193D40F0B627232E71444060B4B4300B193D40103FA5BE2C714440E0635E6940193D40406B29451F71444000B800E143193D40D0896E641E714440001E17E945193D40D011F4BC1B71444080E05E8940193D40E802ADA415714440201EB4F662193D400875EE4D00714440C0DC268C66193D40008D4415FE704440E0FDD27868193D40082D12A9FE70444050B61D7F69193D40686BC1F7FE704440805EF2717D193D407039A407F1704440C083BB9D7D193D4090F40AE9F0704440107A4C3080193D4068CD1EBFEF70444090B1547F84193D40C84220CCED70444030484FBE8C193D4070CCF31FD5704440E05744C18C193D4040451E17D5704440E058D5C397193D40B093A913D0704440E0D09C39A2193D40E0A998D7CD7044407038D32EA6193D40107722FFCC704440B0265F15A8193D4068CE6708C770444060F10EF0A4193D4098CEDD21C5704440605725F8A6193D408808C4B0C370444000469D11A5193D40D01CF304C270444020A8F515A4193D409040CBBDC0704440103756F99E193D40C0EBC682C270444040E39F3D97193D40E825232BBF70444030253889B0193D40A03CD516A6704440809F17ABB1193D40F8376FF7A4704440D089481CB2193D4068933387A47044401073AF9CC2193D40F0C0E5E6A1704440A0C464B3C7193D40A8559217A1704440005F6242CC193D40102BD85DA0704440D0F6F69ECA193D404025C16B97704440907C37D6C5193D40904F887C97704440F0090917C6193D40A84B2F6C99704440006F6DF3C6193D40C0B09201A0704440A0A77277C2193D40D85E10CAA0704440F02587AFAF193D40A059C311A4704440C04F345AAD193D40607B65B8A5704440F0C4F243A5193D40C8443271AB704440D0E4421297193D4018D4FC0BBD70444090AB9C8893193D4088BC406FC17044403012FDB792193D4070C1FF71C2704440505A306490193D40085C4FF7C1704440E08901D369193D40B81F2006BA70444080B2640368193D40089D0D8EB1704440A0042BA567193D4080DC5FD5AF704440F0A4959867193D4018AD8D9AAF704440C0E840A374193D408058FF78AF704440101308B474193D40A8A8F3DDAD704440C0CC1BDB6B193D40801390D5AD704440B01AC0B56B193D40E82F9B2AA8704440D04DC6A86B193D40207F0433A6704440D0C7A9A672193D4098A00C26A6704440101308B474193D40D0543D22A670444070C8C53688193D40F859ED1A95704440A0BC9E9F89193D40783BFCDF93704440B069B8DA8A193D408871F7CC92704440D0C68E4292193D402078E62494704440B00433D593193D40D89BBEDD92704440200161048D193D40D02523B89170444080672E6D8F193D40184D2FB28F7044403072002192193D4040573B6D8D70444000E8E6C196193D40C070B6328E7044401081473998193D40488A46718E704440E0A8CD7B9C193D40D8B2A4198B70444070C6A20F96193D400896A7EB8970444040950D07A8193D4038BF705B7A704440C089E14CA9193D40E0CA31417970444030DFAEA3AA193D4050C63E1878704440D0C4BFADBB193D4028A955B77A70444030364BFDBC193D40F8E0E6AA7970444070C8C414AC193D4000696C037770444050B53679C6193D4078EDCBCF60704440D030DD2DC9193D40209121895E704440209664D4D3193D40A866B55B60704440E078326FD5193D40E00F01A260704440D07DC77FD7193D40B88450E85E704440F0DC85E4D9193D4058A84AE85C7044406016EE37DA193D40509197A25C70444050F2E63BF8193D40580237BF61704440F0AC8B65FA193D4038D8E5C75F704440407AAFA4DC193D4008D2E2A25A70444010A235E7E0193D4008D7DEAB56704440B02F1995D4193D40C0172AAC54704440A0A09ED5F6193D4070E7C6973A70444090611DF0F9193D408056D93A38704440B05A1240201A3D4068EFBFA54370444080788D85211A3D404053C006447044400097F31B261A3D40507963744070444020C5F229001A3D40888EE0473570444000783B0CAD1A3D4058CC747ADE6F44407049CAC4AD1A3D4050D34F05DC6F444000679F58A71A3D4048F0C24CDB6F444060678B8BA31A3D408839DC26DC6F4440E0F50F2DA01A3D40F0C6B2EFDD6F44404001FBA36F1A3D40B003E7A4F76F4440E06CD1486F1A3D40106E668AF76F4440507078BB5E1A3D4090119DBAF26F444050EDD78D5A1A3D40900846C5F46F444010CCDD14561A3D40D0B5BDF4F66F44400075A685571A3D403837FD64F76F444070BCBE96571A3D4000DE2F6AF76F4440C0870AEF5A1A3D4068462ED4F56F4440508D4C2C5C1A3D409090C03DF56F4440B0BBE6305F1A3D40E86E6FCFF36F444000563B276E1A3D40A833C923F86F444010398C976E1A3D4038274944F86F444040F44F8A561A3D40E00F77D50370444030A38F6F561A3D40F08F81CD03704440C0F5FF55471A3D40382DD64FFF6F4440307214BA4B1A3D40D0883FFCFC6F4440602FFAB1491A3D40E0B96B7EFC6F4440909CC287451A3D40D8F70F88FE6F44407020B399431A3D400017C879FF6F44403000F274451A3D406888B90300704440305A13F5541A3D407078878304704440302E3619551A3D40E0F2038E04704440C03A6FF9481A3D40A01C69520A70444020D02BE5481A3D40E8F80B4D0A70444020893D062B1A3D4040385F640270444090220835431A3D40F8FAA2B1F66F444030B17CE5411A3D406827BF5DF66F4440F015D2B23D1A3D40389D9B65F86F4440B017B2B6291A3D40B0647B10027044404026A1BB291A3D40E02829F60170444090155D1B2A1A3D40F0E59BF7FF6F4440108E74EB0E1A3D4050A7CEEFF66F4440D0A645300E1A3D40F8FAA2B1F66F4440E0CC26991D1A3D4078F6B557F16F4440A040FC91221A3D40D05FB29DEF6F444090F93753211A3D40B8FB7A17EF6F4440808D1AD3131A3D4070AF44B6F36F4440A0C3425E0F1A3D40F0890395F16F4440D0ABC7CC051A3D40284B9716F56F4440A038D314011A3D40E86E6FCFF36F4440B0D631FA011A3D4010C7617CED6F4440202B0932021A3D40D0B42CF2EB6F444030534811191A3D4048FCDC63E96F4440008BD904181A3D4008703368E86F4440908473882E1A3D4028CE523EE56F44401024B800341A3D40C81B9179E46F4440B0B22CB1321A3D4050D9DC10E36F444000C5BF93161A3D40186E54E6E66F4440D0F54A9E001A3D40F03A30DACF6F4440B0F36371FF193D4028155F9ECE6F44407051680D2D1A3D4008053446C86F4440105E9E8F321A3D40D8E40A82C76F4440F0FBC9B92B1A3D40B8C34A63C06F444090B559B22A1A3D40D068E250BF6F4440B0B9C42B491A3D4060FC520ABA6F4440A0E5C10E631A3D40588C44F0BF6F4440609E612E5D1A3D4050767F95C16F444080AE08815C1A3D40405009C6C16F44400072D2025E1A3D40505AAC23C26F4440A08E1DCF601A3D40E89D88D1C26F444080641741631A3D40D0A67669C36F444020D73087631A3D402808D108C36F4440301FBC6A651A3D40B0491A6EC06F44405027187E701A3D40B892BD2EC36F44408097260F6B1A3D403072F4E7C46F44407018D1656A1A3D40B027AB1DC56F4440501E3D836B1A3D40F02E9863C56F444040DBF2426E1A3D4048A40110C66F4440B07286F3701A3D4088D7B6B8C66F444020E9F526711A3D4010212465C66F444090364BC9721A3D40607A5ABDC36F4440F0E24DAA7D1A3D40F803D364C66F4440D0E44AA9771A3D4000C6B0FBC76F444010340AFB761A3D40909DD029C86F4440F000F49F781A3D40184DFE94C86F4440206B75737B1A3D409824384DC96F4440D0E0F80E7E1A3D40E8DD2FF7C96F4440601F5F477E1A3D40A033C49FC96F444060F94B06801A3D4070560CEBC66F4440F0FA81D8991A3D403003FBFECD6F4440E041602A9B1A3D40188341C8CD6F4440A020B37F9E1A3D4070790C3ECD6F44402013E99C9F1A3D4078349D9ACB6F4440B059C1C2491A3D40703F69BFB56F4440F01158B4391A3D40A87D73F1B76F4440B061A3F6221A3D40188D1C56B86F444070F1DB3F161A3D4018AA8F9DB76F4440009B1766A1193D4060119DD4976F4440808CBC8097193D40C82194B88E6F4440A08E111C97193D40F0B06AB5876F4440106522718F193D4040E02DCF836F4440D01FFA307B193D40705DA02C7C6F4440E0D9F98A6E193D4098EC7629756F4440F0F90FED63193D40B0721D00716F44406082F71E2E193D40F0E723D0606F44402006165113193D40387E4B71556F4440A00C48B9FB183D406095A7C64B6F444040B6502FF8183D40A8DCE11E4B6F444030CF8F59F6183D40A016C8AD496F4440609BEFFFE3183D4028071F49496F44408058D5F7E1183D4048FE643C4A6F444040F39655D8183D40D07145274B6F4440D0810B06D7183D40F00D84BA486F4440D0D6855AD3183D40F05D0206496F4440F01D4A99D4183D40B06FF08B4B6F44409016C316D3183D40202745734B6F4440E0FD3B1DCF183D4070D650324B6F4440C0D9B25BCB183D40E8F2EFF44A6F44401003E969C0183D40A82151C24C6F44404088045BBC183D40807AC2B64E6F4440C0E82C0ABB183D40506F04594F6F4440F05E58D3BA183D40686ABD5D4F6F444080DDEA58A5183D40F8D92A37516F4440500AF337A1183D400062B08F4E6F4440C02573309B183D40206F8E3F516F4440A0C2892991183D40B8E08FA8506F4440509D44B588183D4090F024404D6F4440A07C898384183D40408DC51F456F4440A0810B207C183D40305C999D456F4440A0C67AC37D183D40F8001C24446F44407048FDF675183D40103248A6436F4440103D88AF76183D40E8246AF6406F444040B3DCFE5C183D40B8AC7935406F444060AF1EFB59183D40B096E1783E6F444080A94A1938183D40281E0585416F444030FF705339183D40803886E3406F444030CF7BC03C183D40684FA7203F6F444060BAE50E43183D40F8B41E763D6F4440B022464948183D40F8C783143C6F444090DB810A47183D405090683A3B6F4440A0F00E5839183D4078EDC4353E6F4440D0B65B5F24183D4060390F643D6F444070BBF1C81F183D40B096E1783E6F4440401037D41F183D40C80DEE703F6F4440603A47FB1F183D4068FA2, 4326);

     

    Thursday, November 10, 2011 9:53 PM

Answers

  • Where did you get the WKB from?  Just looking at the start of the binary string it doesn't seem to match SQL Server types

    Try these in Management Studio:

    select geography::STGeomFromText('POINT (30 10)',4326).STAsBinary()
    select geography::STGeomFromText('LINESTRING (30 10, 10 30, 40 40)',4326).STAsBinary()
    select geography::STGeomFromText('POLYGON ((30 10, 10 20, 20 40, 40 40, 30 10))',4326).STAsBinary()
    select geography::STGeomFromText('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))',4326).STAsBinary()
    select geography::STGeomFromText('MULTILINESTRING ((10 10, 20 20, 10 40),(40 40, 30 30, 40 20, 30 10))',4326).STAsBinary()
    select geography::STGeomFromText('MULTIPOLYGON (((30 20, 10 40, 45 40, 30 20)),((15 5, 40 10, 10 20, 5 10, 15 5)))',4326).STAsBinary()
    select geography::STGeomFromText('GEOMETRYCOLLECTION( MULTIPOLYGON (((30 20, 10 40, 45 40, 30 20)),((15 5, 40 10, 10 20, 5 10, 15 5))), POINT (30 10))',4326).STAsBinary()

    You'll see the first four digits of the output are 0x0101 (POINT) through to 0x0107 (GEOMETRYCOLLECTION).  Your data begins x0500 which doesn't seem to be valid. 

     


    Andrew
    • Proposed as answer by Peja Tao Monday, November 14, 2011 5:35 AM
    • Marked as answer by Peja Tao Thursday, November 17, 2011 5:13 AM
    Friday, November 11, 2011 3:31 PM

All replies

  • declare @geom as geometry; 
    set @geom = geometry::STGeomFromWKB(0x...,4326); 
    set @geom = @geom.MakeValid(); 
    declare @geog as geography;
    set @geog = geography::STGeomFromWKB(@geom.STAsBinary(),4326);


    • Edited by vIndEx Friday, November 11, 2011 8:24 AM
    • Proposed as answer by Peja Tao Monday, November 14, 2011 5:34 AM
    • Unproposed as answer by Peja Tao Monday, November 14, 2011 5:34 AM
    Friday, November 11, 2011 8:22 AM
  • Or, use SQL Server 2012 CTP3 and the geography MakeValid() method.
    twitter: @alastaira blog: http://alastaira.wordpress.com/
    Friday, November 11, 2011 8:40 AM
    Answerer
  • I tried this before but I have a error.

    Msg 6522, Level 16, State 1, Line 2
    A .NET Framework error occurred during execution of user-defined routine or aggregate "geometry":
    System.FormatException: 24115: The well-known binary (WKB) input is not valid.
    System.FormatException:
       at Microsoft.SqlServer.Types.OpenGisWkbReader.ParseWkb(OpenGisType type)
       at Microsoft.SqlServer.Types.OpenGisWkbReader.Read(OpenGisType type, Int32 srid)
       at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromBinary(OpenGisType type, SqlBytes binary, Int32 srid)

     

    thank you.

    Friday, November 11, 2011 12:01 PM
  • Where did you get the WKB from?  Just looking at the start of the binary string it doesn't seem to match SQL Server types

    Try these in Management Studio:

    select geography::STGeomFromText('POINT (30 10)',4326).STAsBinary()
    select geography::STGeomFromText('LINESTRING (30 10, 10 30, 40 40)',4326).STAsBinary()
    select geography::STGeomFromText('POLYGON ((30 10, 10 20, 20 40, 40 40, 30 10))',4326).STAsBinary()
    select geography::STGeomFromText('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))',4326).STAsBinary()
    select geography::STGeomFromText('MULTILINESTRING ((10 10, 20 20, 10 40),(40 40, 30 30, 40 20, 30 10))',4326).STAsBinary()
    select geography::STGeomFromText('MULTIPOLYGON (((30 20, 10 40, 45 40, 30 20)),((15 5, 40 10, 10 20, 5 10, 15 5)))',4326).STAsBinary()
    select geography::STGeomFromText('GEOMETRYCOLLECTION( MULTIPOLYGON (((30 20, 10 40, 45 40, 30 20)),((15 5, 40 10, 10 20, 5 10, 15 5))), POINT (30 10))',4326).STAsBinary()

    You'll see the first four digits of the output are 0x0101 (POINT) through to 0x0107 (GEOMETRYCOLLECTION).  Your data begins x0500 which doesn't seem to be valid. 

     


    Andrew
    • Proposed as answer by Peja Tao Monday, November 14, 2011 5:35 AM
    • Marked as answer by Peja Tao Thursday, November 17, 2011 5:13 AM
    Friday, November 11, 2011 3:31 PM