DX NetOps

Expand all | Collapse all

Spectrum and GIS (Google Map) integration

Anon Anon

Anon AnonSep 13, 2012 12:45 AM

  • 1.  Spectrum and GIS (Google Map) integration

    Posted Sep 07, 2012 02:25 AM
    Can spectrum be integrated with GIS systems like Google Maps?If yes,can you please help me with how to go about it?


  • 2.  RE: Spectrum and GIS (Google Map) integration
    Best Answer

    Broadcom Employee
    Posted Sep 08, 2012 02:57 PM
    Hi Lekshmi,

    I don't believe you can do so out of the box. I think this will need some change on the Spectrum side.
    Would advise that you open up an ER with CA Support for the same.

    Regards,
    Kiran Diwakar


  • 3.  RE: Spectrum and GIS (Google Map) integration

    Posted Sep 13, 2012 12:45 AM
    What is an ER?How do I open it?


  • 4.  RE: Spectrum and GIS (Google Map) integration

    Broadcom Employee
    Posted Sep 13, 2012 02:02 AM
    Hi Lekshmi,

    Sorry for assuming.

    ER is an Enhancement Request. It is a support ticket that gets tracked in the marketing queue by product management.
    Your local support contact will help you to create the same.
    If you need more information, please feel free to reach out.

    Regards,
    Kiran Diwakar


  • 5.  RE: Spectrum and GIS (Google Map) integration

    Posted Sep 14, 2012 12:50 AM
    Kiran,

    I am new to CA Portal.Could you please give me with raising a ticket as ER?


  • 6.  RE: Spectrum and GIS (Google Map) integration

    Posted Sep 14, 2012 10:44 AM
    Hi Lekshmi:

    You can click on the Support tab above (next to the Communities tab). That is where you can open a ticket. Additionally, you can click on the light bulb icon in the upper right corner of this post and open an Idea/Enhancement Request that the rest of the community can vote on. The product managers see these as well and status them for the rest of the community to see. You need to be logged in to open tickets or submit ideas.

    I hope this helps.

    Mary


  • 7.  RE: Spectrum and GIS (Google Map) integration

    Posted Sep 19, 2012 12:17 PM
    Hi,

    Service Operations Insight (SOI) has a Google Earth plugin. I have configured it once, it's pretty straight forward. It basically takes the location parameter for a service and displays the status of the service in Google Earth.

    Hope that helps

    Greetings,

    Benjamin


  • 8.  RE: Spectrum and GIS (Google Map) integration

    Posted Oct 04, 2012 12:41 AM
    Yes In SOI i have seen it.But in one of the RFC,customer asked for Spectrum GIS integration.


  • 9.  RE: Spectrum and GIS (Google Map) integration

    Posted Dec 03, 2012 08:08 AM
    I made my own integration between spectrum and google maps for a costumer of my company.



    :grin:


  • 10.  RE: Spectrum and GIS (Google Map) integration

    Posted Dec 05, 2012 02:47 AM
    Need your help.Will you help me out?


  • 11.  RE: Spectrum and GIS (Google Map) integration

    Posted Dec 18, 2012 10:51 AM
    Lekshmi, write me at dpereyra@netsol-international.com

    Diego MP.


  • 12.  RE: Spectrum and GIS (Google Map) integration

    Posted Mar 20, 2014 11:58 PM

    Hi,

     can you please provide the integration steps
     
    ramesh


  • 13.  RE: Spectrum and GIS (Google Map) integration

    Posted Mar 23, 2014 04:32 AM

    Hi All,

    What is the advantage of intergrating spectrum and google map?

    Regards



  • 14.  RE: Spectrum and GIS (Google Map) integration

    Posted Mar 24, 2014 08:29 AM

    We have been wanting to display the physical location of devices in Spectrum for years.  The world view might be able to organize devices by location, but we have never successfully been able to show that on a map.  Displaying devices on a map, with cross strreets and through a tool like Google Map makes it much easier to dispatch a technician to a problem area.  Additionally, having the information in a mapping tool like Google Map/Google Earth would also allow us to overlay other information such as weather, so that we can watch for possible impacts abd prepare the field for pending issues.  We have gone all the way to include lat/long and physical address information on all our devices, but still we don't have a solution in Spectrum.  We are looking forward to using SOI, but that even has some challenges for environments as large as ours.  As it turns out it may be too late anyway for us.  After waiting 8 yrs, our internal staff has developed their own tool for managing devices and displaying that information in a Google map.  It is a shame that we never got this capability in Spectrum.



  • 15.  RE: Spectrum and GIS (Google Map) integration

    Posted Mar 25, 2014 06:55 AM
    rampeter:

    Hi All,

    What is the advantage of intergrating spectrum and google map?

    Regards


    Just a map to see the status of most critical devices.

     

    Diego



  • 16.  RE: Spectrum and GIS (Google Map) integration

    Posted May 17, 2014 11:10 AM

    Does CA suppots this integration in Spectrum.

    Regards,



  • 17.  RE: Spectrum and GIS (Google Map) integration

    Broadcom Employee
    Posted Dec 18, 2012 03:49 AM
    Hi dpereyra,

    If you are interested, and if your solution is straightforward, we can look at considering to productize and formally support it.
    If you think you can collaborate on this front, please drop me a mail at Kiran.Diwakar@ca.com and I will schedule a discussion

    Regards,
    Kiran Diwakar


  • 18.  RE: Spectrum and GIS (Google Map) integration

    Posted Mar 06, 2014 01:24 PM

    I need to integrate Spectrum with google map? Do you have a solution?

     



  • 19.  RE: Spectrum and GIS (Google Map) integration

    Posted Mar 07, 2014 07:01 AM

    please share how you achieved this



  • 20.  RE: Spectrum and GIS (Google Map) integration

    Posted Mar 20, 2014 07:58 AM

    please share how you achieved this



  • 21.  RE: Spectrum and GIS (Google Map) integration

    Broadcom Employee
    Posted May 28, 2014 07:04 AM

    Hi Team,


    We have one engineer looking into this. I wanted to check if you guys think that for the first cut its ok to get the latitude/longitude or the location of the device from teh user itself?

    I know it would be good to get it automatically and there are a few ways being tried, but wanted to check if getting the info from user would be ok/feasible and not too much of a turn off. Comments/critque welcome.


    Regards,

    Kiran Diwakar

     



  • 22.  RE: Spectrum and GIS (Google Map) integration

    Posted May 28, 2014 09:07 AM

    Having custom attributes to store the Longtitude/Latitude on the Host Device model itself would work. Make them type TEXT so they can be written to by the REST API, also make them manually writable via the oneclick gui.



  • 23.  RE: Spectrum and GIS (Google Map) integration

    Posted May 28, 2014 03:18 PM

    Kiran,

    I don't see how you can reliably obtain the lat/long or location information from devices, so that then means there must be some way for the user to input the information.  If there were attributes that we could populate that would be used by the Google Map interface, then that would work out great for us.  By utilizing the REST interface or Modeling Gateway, we could populate it through our CMDB/provisioning system.  It would be nice to have the flexibility of using either lat/long or an address for identifying the location.  We actually have a combination of both defined for different types of devices.

    Bill



  • 24.  RE: Spectrum and GIS (Google Map) integration

    Broadcom Employee
    Posted May 29, 2014 06:24 AM

    Hi Lute,

    Yep, we are looking at something similar - but wanted to confirm the user input for lat/long and/or geo location.

    Hi Bill,

    The input helps. We are currently looking at either an attribute or an XML that Spectrum can easily read off of. Thanks a lot for the inputs.

    Regards,

    Kiran Diwakar

     



  • 25.  RE: [.CA Spectrum] RE: Spectrum and GIS (Google Map) integration

    Posted May 29, 2014 07:25 AM
    Please share your solution.

    -----------------------------------------------------------------------
    Shahla Tabarzadi
    US House of Representatives
    CAO/HIR/NAF/Data-Communications
    Desk: 202.226.6266
    Cell: 202.580.9525
    Fax: 202.226.6266
    http://www.house.gov<http://www.house.gov/>





    From: CA Infrastructure Management Global User CommunityMessage Boards [mailto:CommunityAdmin@communities-mail.ca.com]
    Sent: Thursday, May 29, 2014 6:24 AM
    To: mb_message.2239493.118532628@myca-email.ca.com
    Subject: [.CA Spectrum] RE: Spectrum and GIS (Google Map) integration


    Hi Lute,

    Yep, we are looking at something similar - but wanted to confirm the user input for lat/long and/or geo location.

    Hi Bill,

    The input helps. We are currently looking at either an attribute or an XML that Spectrum can easily read off of. Thanks a lot for the inputs.

    Regards,

    Kiran Diwakar


    Posted by:kiran_diwakar
    --
    CA Communities Message Boards
    118535168
    mb_message.2239493.118532628@myca-email.ca.com<mailto:mb_message.2239493.118532628@myca-email.ca.com>
    https://communities.ca.com


  • 26.  Re: RE: [.CA Spectrum] RE: Spectrum and GIS (Google Map) integration

    Broadcom Employee
    Posted Oct 30, 2014 04:57 AM

    Hi Folks

     

    Good news - taking inputs from this team, we are now working on this for our next release!

    Just wanted to give you a peek into it, please see attached

     

    gis.jpg

     

    We will also be showing this at CAW, so please plan to attend all the Spectrum sessions (we have 6, including a detailed roadmap for Spectrum that I will be doing).

     

    Regards,

    Kiran Diwakar



  • 27.  Re: RE: [.CA Spectrum] RE: Spectrum and GIS (Google Map) integration

    Posted Oct 30, 2014 12:24 PM

    Hi Kiran,

     

    Whether 9.3 Spectrum version users can gain this GIS.

     

    Regards,

    Issac



  • 28.  Re: Spectrum and GIS (Google Map) integration

    Posted Jan 12, 2015 12:04 PM

    We are less concerned with placing devices on the map and more concerned with placing containers on the map. When we get to a container level where we actually have devices, the topology view that spectrum already has (which needs some tweaks) is what we prefer. However, once we start moving up the tree to city, state, country, region, and world, having the children of those containers placed on a map automatically would be helpful.

     

    NetQoS started down this path, but the effort was killed during the acquisition. Whenever you created a group in NPC, there were fields to put in the lat/long of the group. This would make creating higher level maps trivial by automatically placing the children in the group according to their lat/long. For a group that contained devices (instead of being a parent group), the topology engine from NV (which wasn't as good as Spectrum's) would build a topology map.



  • 29.  Re: Spectrum and GIS (Google Map) integration

    Posted Oct 30, 2014 11:01 PM

    Kiran,

     

    Which version of Spectrum will it support and when can we expect it for using?



  • 30.  Re: Spectrum and GIS (Google Map) integration

    Broadcom Employee
    Posted Oct 31, 2014 12:07 AM

    Hi Isaac, Lekshmi,

     

    This will be like any new feature - it will be available with the new release 10.0 only.

    Anyone wanting to use it would need to update to that release

     

    Regards,

    Kiran Diwakar



  • 31.  Re: RE: [.CA Spectrum] RE: Spectrum and GIS (Google Map) integration

    Posted Jan 12, 2015 05:27 AM

    Hi All,

     

     

    I've made it exporting some attributes through CLI for a KML file, follows below the script used to do it:

     

    #connect

    export CLIMNAMEWIDTH=100

    #export CLISESSID=$$

    echo "<?xml version="1.0" encoding="UTF-8"?>

    <kml xmlns="http://earth.google.com/kml/2.1">

    <Folder><name>Lookup addresses</name>" > Test.kml

    show devices | awk '{print $1}' | sort | uniq | while read MH; do

       IP=$( show attributes attr=0x12d7f mh=$MH | awk '{print $NF}' | grep -v Value )

       DEV_LOCATION=$( show attributes attr=0x23000d mh=$MH | awk '{$1=$2=""; print $0}' | grep -v Value | cut -d',' -f1-3)

       NAME=$( show attributes attr=0x1006e mh=$MH | awk '{print $NF}' | grep -v Value )

     

    echo "<Placemark>" >> Test.kml

    echo "<NAME>$NAME</NAME>" >> Test.kml

    echo "<ADDRESS>$DEV_LOCATION</ADDRESS>" >> Test.kml

    echo "</Placemark>" >> Test.kml

    done

    echo "</Folder></kml>" >> Test.kml



  • 32.  Re: RE: [.CA Spectrum] RE: Spectrum and GIS (Google Map) integration

    Posted Jan 12, 2015 08:30 AM

    Hi marcio,

     

     

    The above script is to add the earth maps in oneclick?



  • 33.  Re: RE: [.CA Spectrum] RE: Spectrum and GIS (Google Map) integration

    Posted Jan 12, 2015 08:46 AM

    A KML file can be used to populate a GIS application (like Google Earth, Google Maps, etc.).



  • 34.  Re: RE: [.CA Spectrum] RE: Spectrum and GIS (Google Map) integration

    Posted Jan 12, 2015 08:52 AM

    Sure stuart,but what is use of above script ,



  • 35.  Re: RE: [.CA Spectrum] RE: Spectrum and GIS (Google Map) integration

    Posted Jan 12, 2015 09:32 AM

    Looks like it creates a KML file, assuming some of the attributes contain the necessary fields for each device. That KML file would then theoretically be used to display the devices on a map.



  • 36.  Re: RE: [.CA Spectrum] RE: Spectrum and GIS (Google Map) integration

    Posted Jan 12, 2015 11:46 AM

    You are correct, Stuart. I'm obtaining location trough the attribute 0x23000d "Location" and filling my KML file, but I could get location from devices using another attribute like 0x129e7 "TopologyModelNameString". In a distributed environment you'll have to run the script on every Spectrum Server.

     

    There is another way to get device's location using Spectrum REST API, as you can see below:

     

    http://<spectrum_IP>/spectrum/restful/devices?attr=0x23000d&attr=0x1006e&throttlesize=8000



  • 37.  Re: Spectrum and GIS (Google Map) integration

    Broadcom Employee
    Posted Feb 13, 2015 05:56 AM

    Hello All,

     

    While we are working towards finishing touches for GIS Map integration for Spectrum to be released with 10.0, there is one thing I am debating with our engineering team.OOTB, Google Map for example, allows placing 200 device updates per day for free. You need to procure licenses to go beyond 200 updates per day.

    Now people who are using maps in their environments - and I see Stuart, Bill, Lekshmi talking about production and I see other consultants doing this for their customers as well. So I want to believe people would have sufficient Google Map license entitlements - right? Can you folks please just say "Yay" or "Nay" on this

    email thread if you already have sufficient licenses in your organization or you plan to get it...

     

    The engineers are debating if people will have licenses and so in turn does it make sense to release this capability Urgent responses would be appreciated

     

    Regards,

    Kiran Diwakar



  • 38.  Re: Spectrum and GIS (Google Map) integration

    Posted Feb 13, 2015 09:08 AM

    We haven't integrated maps in to any of our tools yet, but the discussions have happened.  While we haven't purchased any licenses from Google I can tell you that if the functionality exists in Spectrum 10.0 and can be easily enabled, we would likely go out and purchase them.  I don't think you should worry too much about what capabilities customers may or may not have right now.  Instead just focus on putting together a cool and useful feature that competes with what other vendors are doing.  To paraphrase Field of Dreams, "If you build it, they will come."



  • 39.  Re: Spectrum and GIS (Google Map) integration

    Broadcom Employee
    Posted Feb 13, 2015 09:15 AM

    I appreciate your response jbovee. Understand your sentiment and I have been driving home the point within the team as well.
    As we have done on this community, i have been transparent about our thought process and things different groups come to table challenging each other.

    We encourage that since it keeps all of us on our toes - that is healthy.

    Having said that, my intent was to get a handful of people here respond affirmatively here, that gives me "real data" to go back and make a case with that my anecdotes. I have this community to get me some data and hence reached out.

    Point well taken and if others could back up as well, would really appreciate it.


    Regards,

    Kiran Diwakar



  • 40.  Re: Spectrum and GIS (Google Map) integration

    Posted Feb 13, 2015 02:10 PM

    I agree with this as well.  Make the feature available and let us decide how best to implement it in our environments.  However, if you don't have the feature available... well then there's not much of a discussion for your customers to have about it, is there?? 



  • 41.  Re: Spectrum and GIS (Google Map) integration

    Broadcom Employee
    Posted Feb 14, 2015 04:11 AM

    I am with you Chris and as promised at CAW you guys will see this feature in 10.0 - just that given the push back on some of these things - community members calling it out like you and jbovee makes it easier for me. So I would request other community members to comment as well. It's just a confirmation of interest - if the GIS view has enough value organisations would potentially consider getting the Google licence - right? Simple yes/no would suffice as well.

     

    Thanks so much all!

     

    Regards,

    Kiran Diwakar



  • 42.  Re: Spectrum and GIS (Google Map) integration

    Posted Feb 14, 2015 09:56 PM

    I don't know if Google licenses should be necessary. Our mapping does not

    require licenses purchased from Google. Also, we would not purchase

    licenses from Google just to enable functionality from a CA tool that we've

    already spent so much money on. Is the 200/day limitation in this

    visualization

    <https://developers.google.com/chart/interactive/docs/gallery/map> or is

    there some other API that you are trying to use? I don't see anything in

    the documentation that talks about a limitation per map, definitely nothing

    about a per day limit. I also see nothing about having to purchase any

    licenses to use this visualization.

    Looks like the limit is 400 items per map. I still see nothing about a daily limit.



  • 43.  Re: Spectrum and GIS (Google Map) integration

    Posted Feb 17, 2015 06:07 AM

    Hi Kiran,

    I know the work of Diego but recommand that not all people over the world would like to send the address to google to get the GIS-Coordinates.

    Therefore I request to perhaps integrate some lookup-options for locally stored mappings. ... address-string to GIS-Location.

     

    I have made an Worldmap without Google based on the MAPAEL-Project where I used the names of the devices to get the right Country-Code.

    Check this documentation:

    ISO-3166-1 - area codes like „US“ for USA , „GB“ for Great Britain, „DE“ for Germany etc. … they are all standard in ISO-3166-1

    http://www.unece.org/cefact/locode/service/location.html

     

    ISO-3166-1 defines codes for cities and I have seen many Spectrum-Customers where the device-names contain the Country- and City-Code based on ISO-3166-1.

     

    This codes are not an unused standard - its daily practise. Many people provide code-fragments to use these codes inside your prefered language.

    I used Array of country codes (ISO 3166-1 alpha-2) and corresponding names to translate the countrycodes. ..  MAPAEL based on Rafael needed ony the countrycode with 2 chars. .. here too: OpenGeocode.Org - FREE, Public Domain Download of Geolocation and Geospatial databases

    I also recommend to use Leaflet-JS to display Maps because it is a wrapper where customers could select the prefered MAP-Provider like Google-Maps or Openstreetmap.

    I haven´t checked Leaflet finally by myself but seems to fit better to different customers and their security-requirements.

     

    Best Regards

    Erich



  • 44.  Re: Spectrum and GIS (Google Map) integration

    Posted Sep 21, 2015 09:24 AM

    I agree with Erich, not all people will like to send location to get coordinates. Therefore I change this integration long time ago for a javascript map, like "jquery-jvectormap-2.0.1" and with an api request get the condition for each device. or groups of devices. Saving the coords in location attribute.

     

    I dind't test this feature in spectrum 10.0. yet!

     

    Right now i send coords to Kibana and show a realtime alarm map

    Selection_151.png

     

    have a nice week

    pereyrdi