[mapguide-users] does MapGuide display circle geometries?

GordonL gordon.luckett at arrowgeomatics.com
Fri Oct 9 09:34:33 PDT 2020


I put that geometry in my table called "CIRCLES"


INSERT INTO CIRCLES(GEOM)  
VALUES (geometry::STGeomFromText('POLYGON ((20.141062507772002
13.48126983816301, 20.165603736294916
13.481571019466806, 20.19013018209942 13.482474381957838, 20.21462707137167
13.483979381484319, 20.239079648101562 13.486085111490812,
20.263473182971218 13.488790303564299, 20.287792982227362
13.492093328198228, 20.3120243965323 13.495992195774068, 20.33615282978813
13.500484557759778, 20.360163747928873 13.505567708124481,
20.384042687675265 13.511238584968465, 20.4077752652469 13.517493772367569,
20.431347185026464 13.524329502430799, 20.454744248170893
13.531741657569972, 20.47795236116422 13.539725772979986, 20.500957544306988
13.548277039328269, 20.52374594013709 13.557390305651721, 20.546303821776991
13.567060082459477, 20.568617601202284 13.577280545039564,
20.590673837426607 13.588045536967492, 20.612459244598 13.599348573814652,
20.633960700001786 13.611182847054296, 20.655165251965222
13.623541228162734, 20.6760601276591 13.6364162729133, 20.696632740791603
13.649800225860462, 20.716870699189847 13.663685025011423,
20.736761812264433 13.678062306682362, 20.75629409835263 13.6929234105364,
20.775455791935649 13.70825938480027, 20.794235350725778 13.724060991656522,
20.81262146261902 13.740318712808048, 20.830603052509069 13.757022755211539,
20.848169288958548 13.774163056976459, 20.86530959072347 13.791729293425938,
20.882013633126959 13.809710883315987, 20.898271354278485
13.828096995209229, 20.914072961134739 13.84687655399936, 20.929408935398609
13.866038247582377, 20.944270039252647 13.885570533670572,
20.958647320923586 13.905461646745159, 20.972532120074547
13.925699605143402, 20.985916073021709 13.946272218275908,
20.998791117772274 13.967167093969783, 21.011149498880712
13.988371645933221, 21.022983772120355 14.009873101337007,
21.034286808967519 14.031658508508398, 21.045051800895443
14.053714744732723, 21.055272263475533 14.076028524158014,
21.064942040283288 14.098586405797914, 21.074055306606741
14.121374801628017, 21.082606572955022 14.144379984770785, 21.09059068836504
14.167588097764112, 21.098002843504212 14.190985160908541,
21.104838573567442 14.214557080688106, 21.111093760966547 14.23828965825974,
21.11676463781053 14.262168598006134, 21.121847788175231 14.286179516146875,
21.126340150160942 14.310307949402702, 21.130239017736784
14.334539363707641, 21.133542042370713 14.358859162963787, 21.1362472344442
14.383252697833443, 21.138352964450693 14.407705274563336,
21.139857963977175 14.432202163835585, 21.140761326468205
14.456728609640091, 21.141062507772002 14.481269838163003,
21.140761326468205 14.505811066685915, 21.139857963977175
14.530337512490421, 21.138352964450693 14.554834401762671, 21.1362472344442
14.579286978492563, 21.133542042370713 14.603680513362219,
21.130239017736784 14.628000312618365, 21.126340150160942
14.652231726923304, 21.121847788175231 14.676360160179131, 21.11676463781053
14.700371078319872, 21.111093760966547 14.724250018066266,
21.104838573567442 14.7479825956379, 21.098002843504212 14.771554515417465,
21.09059068836504 14.794951578561895, 21.082606572955022 14.818159691555222,
21.074055306606741 14.84116487469799, 21.064942040283288 14.863953270528093,
21.055272263475533 14.886511152167992, 21.045051800895443
14.908824931593283, 21.034286808967519 14.930881167817608,
21.022983772120355 14.952666574989, 21.011149498880712 14.974168030392786,
20.998791117772274 14.995372582356223, 20.985916073021709
15.016267458050098, 20.972532120074547 15.036840071182604,
20.958647320923586 15.057078029580847, 20.944270039252647
15.076969142655434, 20.929408935398609 15.096501428743629,
20.914072961134739 15.115663122326646, 20.898271354278485
15.134442681116777, 20.882013633126959 15.15282879301002, 20.86530959072347
15.170810382900068, 20.848169288958548 15.188376619349548,
20.830603052509069 15.205516921114468, 20.81262146261902 15.222220963517959,
20.794235350725778 15.238478684669484, 20.775455791935649
15.254280291525737, 20.75629409835263 15.269616265789606, 20.736761812264433
15.284477369643644, 20.716870699189847 15.298854651314583,
20.696632740791603 15.312739450465545, 20.6760601276591 15.326123403412707,
20.655165251965222 15.338998448163272, 20.633960700001786 15.35135682927171,
20.612459244598 15.363191102511355, 20.590673837426607 15.374494139358514,
20.568617601202284 15.385259131286443, 20.546303821776991
15.395479593866529, 20.52374594013709 15.405149370674286, 20.500957544306988
15.414262636997737, 20.47795236116422 15.42281390334602, 20.454744248170893
15.430798018756034, 20.431347185026464 15.438210173895207, 20.4077752652469
15.445045903958437, 20.384042687675265 15.451301091357541,
20.360163747928873 15.456971968201525, 20.33615282978813 15.462055118566228,
20.3120243965323 15.466547480551938, 20.287792982227362 15.470446348127778,
20.263473182971218 15.473749372761707, 20.239079648101562
15.476454564835194, 20.21462707137167 15.478560294841687, 20.19013018209942
15.480065294368169, 20.165603736294916 15.4809686568592, 20.141062507772002
15.481269838162996, 20.116521279249088 15.4809686568592, 20.091994833444584
15.480065294368169, 20.067497944172334 15.478560294841687,
20.043045367442442 15.476454564835194, 20.018651832572786
15.473749372761707, 19.994332033316642 15.470446348127778,
19.970100619011703 15.466547480551938, 19.945972185755874
15.462055118566228, 19.921961267615131 15.456971968201525,
19.898082327868739 15.451301091357541, 19.874349750297103
15.445045903958437, 19.85077783051754 15.438210173895207, 19.827380767373111
15.430798018756034, 19.804172654379784 15.42281390334602, 19.781167471237016
15.414262636997737, 19.758379075406914 15.405149370674286,
19.735821193767013 15.395479593866529, 19.71350741434172 15.385259131286443,
19.691451178117397 15.374494139358514, 19.669665770946004
15.363191102511355, 19.648164315542218 15.35135682927171, 19.626959763578782
15.338998448163272, 19.606064887884905 15.326123403412707, 19.5854922747524
15.312739450465545, 19.565254316354157 15.298854651314583,
19.545363203279571 15.284477369643644, 19.525830917191374
15.269616265789606, 19.506669223608355 15.254280291525737,
19.487889664818226 15.238478684669484, 19.469503552924984
15.222220963517959, 19.451521963034935 15.205516921114468,
19.433955726585456 15.188376619349548, 19.416815424820534
15.170810382900068, 19.400111382417045 15.15282879301002, 19.383853661265519
15.134442681116777, 19.368052054409265 15.115663122326646,
19.352716080145395 15.096501428743629, 19.337854976291357
15.076969142655434, 19.323477694620419 15.057078029580847,
19.309592895469457 15.036840071182604, 19.296208942522295
15.016267458050098, 19.28333389777173 14.995372582356223, 19.270975516663292
14.974168030392786, 19.259141243423649 14.952666574989, 19.247838206576485
14.930881167817608, 19.237073214648561 14.908824931593283,
19.226852752068471 14.886511152167992, 19.217182975260716
14.863953270528093, 19.208069708937263 14.84116487469799, 19.199518442588982
14.818159691555222, 19.191534327178964 14.794951578561895,
19.184122172039793 14.771554515417465, 19.177286441976563 14.7479825956379,
19.171031254577457 14.724250018066266, 19.165360377733474
14.700371078319872, 19.160277227368773 14.676360160179131,
19.155784865383062 14.652231726923304, 19.15188599780722 14.628000312618365,
19.148582973173291 14.603680513362219, 19.145877781099806
14.579286978492563, 19.143772051093311 14.554834401762671,
19.142267051566829 14.530337512490421, 19.1413636890758 14.505811066685915,
19.141062507772002 14.481269838163003, 19.1413636890758 14.456728609640091,
19.142267051566829 14.432202163835585, 19.143772051093311
14.407705274563336, 19.145877781099806 14.383252697833443,
19.148582973173291 14.358859162963787, 19.15188599780722 14.334539363707641,
19.155784865383062 14.310307949402702, 19.160277227368773
14.286179516146875, 19.165360377733474 14.262168598006134,
19.171031254577457 14.23828965825974, 19.177286441976563 14.214557080688106,
19.184122172039793 14.190985160908541, 19.191534327178964
14.167588097764112, 19.199518442588982 14.144379984770785,
19.208069708937263 14.121374801628017, 19.217182975260716
14.098586405797914, 19.226852752068471 14.076028524158014,
19.237073214648561 14.053714744732723, 19.247838206576485
14.031658508508398, 19.259141243423649 14.009873101337007,
19.270975516663292 13.988371645933221, 19.28333389777173 13.967167093969783,
19.296208942522295 13.946272218275908, 19.309592895469457
13.925699605143402, 19.323477694620419 13.905461646745159,
19.337854976291357 13.885570533670572, 19.352716080145395
13.866038247582377, 19.368052054409265 13.84687655399936, 19.383853661265519
13.828096995209229, 19.400111382417045 13.809710883315987,
19.416815424820534 13.791729293425938, 19.433955726585456
13.774163056976459, 19.451521963034935 13.757022755211539,
19.469503552924984 13.740318712808048, 19.487889664818226
13.724060991656522, 19.506669223608355 13.70825938480027, 19.525830917191374
13.6929234105364, 19.545363203279571 13.678062306682362, 19.565254316354157
13.663685025011423, 19.5854922747524 13.649800225860462, 19.606064887884905
13.6364162729133, 19.626959763578782 13.623541228162734, 19.648164315542218
13.611182847054296, 19.669665770946004 13.599348573814652,
19.691451178117397 13.588045536967492, 19.71350741434172 13.577280545039564,
19.735821193767013 13.567060082459477, 19.758379075406914
13.557390305651721, 19.781167471237016 13.548277039328269,
19.804172654379784 13.539725772979986, 19.827380767373111
13.531741657569972, 19.85077783051754 13.524329502430799, 19.874349750297103
13.517493772367569, 19.898082327868739 13.511238584968465,
19.921961267615131 13.505567708124481, 19.945972185755874
13.500484557759778, 19.970100619011703 13.495992195774068,
19.994332033316642 13.492093328198228, 20.018651832572786
13.488790303564299, 20.043045367442442 13.486085111490812,
20.067497944172334 13.483979381484319, 20.091994833444584
13.482474381957838, 20.116521279249088 13.481571019466806,
20.141062507772002 13.48126983816301))', 4326));

Notice I set the SRID to 4326 "LL84"

When I created a data source in MapGuide to this, I also assigned the
Coordinate System to LL84  4326

It appeared in MapGuide without issue (MGOS 3.1.2)


Also, whenever possible, I recommend "geometry" in SQL Server rather than
"geography".

<http://osgeo-org.1560.x6.nabble.com/file/t195347/circle.jpg> 


 



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html


More information about the mapguide-users mailing list