[OSGeo-UK] Linking into IMB cognos

[Jo Cook]

Hi Rachel,

Thanks for subscribing to the OSGeo UK mailing list. In answer to your
second question first- about the map projections- the gotcha is probably
that you need to allow QGIS to switch between different projections "on the
fly". The easiest way to make this work is to open a blank QGIS project,
then go to File/Project Properties and choose the Coordinate Reference
System tab. Tick the box marked "enable on the fly CRS transformation" and
then in the filter box type 27700 (the EPSG code for British National
Grid). If you select that and click the "apply" button and then "OK" to
close the window, you should see in the bottom right-hand corner of your
QGIS window that you're now in British National Grid/EPSG:27700. If you now
add your nuts 3 data (which I'm assuming you've grabbed from here:
http://epp.eurostat.ec.europa.eu/portal/page/portal/gisco_Geographical_information_maps/popups/references/administrative_units_statistical_units_1
and
then something from the UK, you should now see that the data overlays
itself correctly.

One thing that you might find really useful if you're learning QGIS is the
new manual: http://docs.qgis.org/html/en/docs/user_manual/index.html

I'm not sure what sort of economic data that you're using, but the best way
of getting data that automatically updates itself is to find datasets that
use web mapping services (WMS) rather than static mapinfo or shapefiles.
Data.gov.uk has a lot of these. You add them into QGIS in a similar way to
adding a static file, only you choose "Add WMS layer", and you give it a
web address rather than a file location. An example of this is the British
Geological Survey-
http://data.gov.uk/dataset/bgs-detailed-bedrock-and-superficial-geology-ogc-wxs.
The "direct link" in the page I've just linked to is what you'd need to add
in QGIS. The relevant section of the manual is here:
http://docs.qgis.org/html/en/docs/user_manual/working_with_ogc/ogc_client_support.html#wms-client

Finally, you might want to get in touch with the people from the AGI
Scotland group, as I think they are doing a workshop on open source fairly
soon- Abigail Page lurks on this list and is involved in that event so
should be able to give you some more information on it.

Hope that all helps, and don't hesitate to shout if you need more help!

All the best

Jo


On Thu, Jan 10, 2013 at 4:19 PM, Rachel Forrest
<rachel.forrest at hient.co.uk>wrote:

> **
> Hello everyone,
>
> I am new to mapping and am in need of some advice and guidance.  I have
> previously posted on the non-uk mailing list but have some questions that
> are more specific to the UK.  Apologise if anyone receives both.
>
> My project basically involves collating internal and external data and
> displaying it on a map within the company's intranet to share with all
> staff.
>
> The internal data is on IBM Cognos.  This information is updated in real
> time and needs to be displayed on the map in real time.  Following
> recommendations from IBM, my company installed MapInfo to display outputs.
> It took 32 weeks to get it but they did.  The problem is that it is only on
> one computer at a different office from me and apparently the training is
> really expensive and it sounds really hard to use without the training. I
> would like to see if it would be possible to use QGIS as so far it has been
> easy to use and available on my own PC.
>
> The other question is that I am wondering if there are any existing
> databases that stores up-to-date economic data so the maps I create could
> update themselves automatically once my placement ends.  If such a thing
> doesn't exist I am considering creating and maintaining once when I go back
> to consultancy once my placement ends.
>
> One other little problem I've been having, I've managed to open the
> shapefiles for the european boundry lines of nuts 3, but the map seems to
> be distorted.  I gather it is something to do with the map projections.  I
> tried various different ones but the map either stayed the same or
> disappeared completely.
>
> Thanks,
>
> Rachel
>
>
> Rachel Forrest
> Economics Intelligence Officer
> Highlands and Islands Enterprise
> Cowan House
> Inverness Retail and Business Park
> Inverness IV2 7GF
>
> +44(0) 1463 244 433
> Email: rachel.forrest at hient.co.uk
> www.hie.co.uk
>
>
>
> ------------------------------
>
> This document is confidential and intended solely for the use of the
> addressee(s). If you are not the intended recipient, please inform the
> sender immediately. Any unauthorised use of this document is strictly
> prohibited. HIE uses filter software to protect its staff and will
> automatically delete any email that contains offensive or profane content.
>
>
> Tha an teachdaireachd seo dìomhair agus 's ann dhan neach-ainmichte
> a-mhàin a tha i. Ma 's e is gun d'fhuair sibh le mearachd i, feuchaibh is
> leigibh fios sa spot dhan neach bhon tàinig i. Tha cleachdadh
> neo-cheadaichte na teachdaireachd seo fìor-thoirmisgte. Tha HIE a'
> cleachdadh bathar-bog gus luchd-obrach na buidhne a dhìon is cuiridh i às
> do phost-dealain sam bith sa bheil càil oilbheumach no truailleach.
>
>
> _______________________________________________
> UK mailing list
> UK at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/uk
>
>


-- 
***Jo Cook*
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
7RL, UK
t:+44 750 095 8167
iShare - Data integration and publishing platform<http://www.isharemaps.com/>

*****************************************

 Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/uk/attachments/20130111/06127ed8/attachment.html>