Add Excel Widget uploaded to the Resource Center

[AnthonyGiles]

All,

Please find a link to an add Excel Widget:

http://www.arcgis.com/home/item.html?id=b8d2f6a9063e44669eddfdd2d32244e8

Thank You Robert for hosting sample application for me

Feedback welcome

Regards

Anthony

[JeffersonFerreira_Ferreira]

Hi Anthony! Great work! Congratulations. It is primordial for a GIS user's somethings like this.

But, A little question: How can I plot the coordinates in DD.DDD (decimal degreees) instead WebMercator metrical coordinates?

The widget recognizes the webmercator coordinates, but it's too confusing to a kind of users. Furthermore all my application display the wgs84 decimal degrees system. I'm not a "hard developer", but I can set up my "Frankensteins" takeing a piece here, another there and customizing my widgets. The CoordinateMenu widget can Go To coordinates entered as WGS decimal degrees, even behind the "backstages" the webmercator is acting. So it would be the same thing with your widget: enter wgs decimal degrees coordinates by the UI, that passes through webmercator and are ploted at the right place. 

Is it possible? Do you've done like this? If not, we can think in. I could help you if I can.

Best Regards

[AnthonyGiles]

Jefferson,

If your basemap is projected in geographics then you can just have the values in your spreadsheet as decimal degrees and it will plot ok, this is how I originally developed the widget I only have the demo in web mercator to work with the esri base maps.

Regards

Anthony

[JeffersonFerreira_Ferreira]

Jefferson,

If your basemap is projected in geographics then you can just have the values in your spreadsheet as decimal degrees and it will plot ok, this is how I originally developed the widget I only have the demo in web mercator to work with the esri base maps.

Regards

Anthony

Anthony, thanks for you attention. But "houston, we have a problem...!
When I upload a sheet in decimal degrees they are ploted at webmercator and all at the same place. Exemple, in my sheet:
X Y
-64.84071 -3.04574
-64.85397 -3.03276
-64.85832 -2.98987
-64.83300 -3.06294
-64.84892 -3.04203
-64.77522 -3.10844
-64.79987 -3.10231

The first coordinate pair, for exemple, represent -7218035.058740 -339215.035943 in webmercator, but they are ploted at the -64.84071 -3.04574 webmercator...

Any idea?

[AnthonyGiles]

Jefferson,

I think I understand what you are after now, you want to have your basemap in web Mercator projection then upload coordinates that are in decimal degrees. This is not achievable without modifying the source code as you will need to reproject each point before plotting. If you have the capability to adapt the source code this should be easy to do but it is not something I plan on doing as I have no requirement to do so.

Regards

Anthony

[JeffersonFerreira_Ferreira]

Jefferson,

I think I understand what you are after now, you want to have your basemap in web Mercator projection then upload coordinates that are in decimal degrees. This is not achievable without modifying the source code as you will need to reproject each point before plotting. If you have the capability to adapt the source code this should be easy to do but it is not something I plan on doing as I have no requirement to do so.

Regards

Anthony

Hi Anthony;

In fact, I have 4 basemaps. Three of them are bingmaps mapservice (webmercator) and one is an image service that I've published. Originally it is in WG84. These bing services determine that all my application are in webmercator? Even if all of my operational layers and my image service as a basemap are in WGS geographic? 
A schematic image is attached.
Thanks

Thanks

[AnthonyGiles]

Jefferson,

If you add your image service as your first base map then your application will be in WGS84 as the projection of our first base map determines the projection of you application.

You can also set the projection of your application using the wkid attribute in your map tag in the main config file, see:


http://help.arcgis.com/en/webapps/flexviewer/help/index.html#/Main_configuration_file/01m30000001800...

Regards

Anthony

[JeffersonFerreira_Ferreira]

Jefferson,

If you add your image service as your first base map then your application will be in WGS84 as the projection of our first base map determines the projection of you application.

You can also set the projection of your application using the wkid attribute in your map tag in the main config file, see:


http://help.arcgis.com/en/webapps/flexviewer/help/index.html#/Main_configuration_file/01m30000001800...

Regards

Anthony

Great Anthony! It was the first basemap. A simple question... Now the points are correctly ploted.
Thanks for your advice!

[RhettZufelt]

Great Anthony! It was the first basemap. A simple question... Now the points are correctly ploted.
Thanks for your advice!

Hi Jefferson,

If they are plotting correctly then you must have got the map wkid to WGS84 so they display correctly.

However, that means that your map is now WGS84 and the Bing maps are tiled in the webmercator system.  Did you find a way to load Bing maps as dynamic so they actually overlay, or did you give up on having a bing map as well?

Thanks,

R_

[KennethLyons]

I'm having a similar issue with the points in my spreadsheets not plotting correctly.  the Sample that came with the download loads with no issue, but when I create my own the points end up in the middle of the ocean.  I'm not sure where the disconnect is on my end.  I've tried using several different coordinate types in the spreadsheet, but they all plot in the same area. 

Any thoughts??

Thanks