I managed to catch up with Stuart and Scott from Southwark and ask them about the great work they have been doing with Stratus.
Hi Scott and Stuart, can you just introduce yourself and your role at Southwark?
SC: Hello, my name is Stuart Carter and I’m Southwark’s Corporate GIS manager
SD: Hello, my name is Scott Day and I’m Southwark’s Corporate GIS officer
What gave you the idea for the integration between MapInfo Stratus and the TFL xml camera feed?
SC: I was introduced to the London Datastore (http://data.london.gov.uk/) at a recent GLA GI forum meeting. It’s a GLA managed web portal allowing London’s public organisations to upload and download spatial data. But importantly London Datastore also provides links to spatial data feeds already uploaded to the data cloud. Data providers include London boroughs, ONS, GLA, TfL and British Transport Police.
I came across TfL’s traffic camera feed service holding spatial coordinates within the XML code. There was clearly an opportunity to link up to TfL’s data cloud data bringing the data feed into our own Stratus service.
The days of only providing spatial data held by and managed by the council have ended. The concept of open data is very important in our spatial data infrastructure (SDI) plans; moreover, it fits in nicely with the council’s overall web strategy.
SD: On top of what Stuart has already mentioned, the GIS team has a good working relationship with the CCTV camera operatives in Southwark, however until recently we have not had the tools available to integrate live CCTV feeds into the maps that they use (without a lot of specialist bespoke development). We are still a long way from fully integration live CCTV feeds into the maps that the CCTV operators use, but the data from the London Datastore is a good indication that the technology is now available (without specialist bespoke development).
How long did this integration take to set-up?
SD: Once we had a raw XML file from an RSS feed (downloaded from the London Datastore), the creation of the map was very quick (little over an hour). With the map created we could link directly to the source feed from the TFL website (all the relevant information was contained within the single RSS feed).
What level of technical understanding is needed to set this up?
SD: The main technical knowledge that is needed to do this is: A basic understanding of XML and HTML.
As far as I know MapInfo Pro cannot read an XML file without some extra work, so the route I took was to simply convert the XML into a CSV file. Once the data was in a CSV file the map could be drawn using geo:easting and geo:northing from the RSS feed. One really good feature of MapInfo stratus is that to display information into a call out bubble it needs to convert the r MapInfo attributes into HTML. So if you have HTML in your MapInfo layer MapInfo stratus will simply translate that code into whatever the HTML tells it to. When we first got MapInfo stratus I enjoyed showing potential users that the call out bubble could display anything they wanted – even a Google search engine!
Were there any challenges that you faced?
SC: I needed to check on the legality of the mash-up. But after contacting TfL directly and reviewing their small print it became clear that we could proceed.
SD: The most difficult part of the implementation was to get the XML data into MapInfo Pro. There are many tools and techniques to do this, some easier and quicker than others. As I’m not an expert in XML I chose to convert the file into CSV which I’m more comfortable with.
Do you have any future plans to enhance this mashup, or add additional feeds to Stratus?
SC: There are other spatial datasets on London Datastore that are of interest, especially those of demographic and social nature. Ultimately, we’ll move forward with cloud data mash-ups where there is a strong user relevance and system compatibility. A
We’re also looking into bringing re-rendered Open Street Map (OSM) mapping into Stratus Connect. Initially it would be direct data supply but it’ll evolve into a WMS feed bringing OSM mapping direct from the cloud.
SD: To go with the TFL traffic cams it would be great to link to other live webcams (e.g. http://www.camvista.com/england/london/trafalgarsquare_streaming.php). I’ve already toyed with integrating live video feeds from a number of tourist webcams. Although technically possible, we’d need to first check with the camera owners before we take this one further.
Additional information on general Connect enhancements
The following is not actually related to the TFL traffic cams mashup but is still a very exciting future development. We now have a prototype integration into our CMS which will soon allow small map widgets to be embedded throughout the council’s website. The page owner would utilise the widget without any technical GI knowledge.
In addition to this our maps could also be embedded into external websites. Moreover, at some point in the future we will have a wizard allowing anyone to generate a map widget for their own website. A demo of this can be seen using the following HTML…
<iframe width=”480″ height=”300″ frameborder=”0″ scrolling=”no” marginheight=”0″ marginwidth=”0″ src=”http://maps.southwark.gov.uk/connect/embedded_s.jsp?mapcfg=simple&mylayer0=TFL_traffic_CCTV&x=532037&y=178892&z=11″></iframe>
Many thanks to Stuart and Scott for taking the time to talk through their implementation, I’m sure you will agree their web mapping is is looking fantastic! Its also providing a great service to the citizens of Southwark. If there are other organisations would like to feature their work on the blog please get in touch.