DB内の緯度と経度の値に関する問題

Question

<\/HEAD>私はMicroStrategy Cloud Expressのユーザーで、新しいESRIマップビジュアライゼーションを使っています。DBに緯度と経度の値を読み込んで、レコードを地図上に表示しようとしました。しかし、郵便番号に関連付けられた緯度・経度属性を作成するまで、レコードが地図に表示されませんでした。残念ながら、郵便番号に関連付けられた緯度・経度の値は十分に詳細ではありません。郵便番号内のインシデントを地図化したいのです。<\/SPAN> 単独の緯度・経度の値は小数点以下6桁までの度数で表されています。MicroStrategyアプリケーション内でこれらの緯度・経度レコードを「latitude」と「longitude」属性として割り当てています。ほかに何をすべきかわかりません。マップを機能させるためには、場所属性として郵便番号や市区町村を使う必要がありますか？<\/SPAN> ご助力いただければ幸いです。よろしくお願いいたします。<\/SPAN><\/BODY><\/HTML>

ScottMasson · Answer

Hi, I believe that you are trying to leverage the out of the box capabilities that MicroStrategy included in their latest releases, and not Esri Maps for MicroStrategy, is this correct? I believe that MicroStrategy has imposed some limitations to the level of granularity that they will plot on the map. For example, I was never able to get data to visualize lower than at a ZIP code level as well.

My suggestion would be to contact MSTR Support to see if they have any guidance or white papers.

Scott

DavidFabi · Answer

I am a MicroStrategy Cloud Express User and I've been working with the new ESRI map visualizations.  I loaded latitude and longitude values into my DB to chart records on a map.  However, I wasn't able to get the records to show up on a map until I created latitude and longitude attributes associated with a zip code.  Unfortunately, the lat/long values associated with zip codes aren't granular enough - I would like to chart incidents within a zip code.

The standalone lat/long values are in degrees down to six decimal places.  I assign the lat / long records as "latitude" and "longitude" attributes within the MicroStrategy application.  I'm not sure what else I need to do.  Am I obligated to use zip code or city as a location attibute to get the maps to work?

Thanks in advance for any help.

Hi,

I'm getting the same results as you.  MS will extract Long/Lat from my Country or State and display it properly if used within the Map control, but will not display a single pin if I use the Long or Lat dimension.  The Long Lat is extracted from two Excel columns.  Here is a sample from the excel test data:

Long Lat Country
30,252257 62,419543 Belgium
30,324375 62,348622 Belgium
30,367740 62,264855 Belgium

Have you had any luck?

Kind regards,

David