instantatlas server workshop presentations - london 2014
DESCRIPTION
In this video you will see presentations by Richard McMahon (Senior Support Consultant) of InstantAtas talks about IA Server version 6.5.2, which is latest release of IA Server. Our second presentation is by Keith Morrison, InstantAtlas senior developer. Keith's presentation takes a look at the latest developments in the area of data loading.TRANSCRIPT
InstantAtlas ServerVersion 6.5.2
Richard McMahon,
Senior Support Consultant
Presentation Overview
• What is in this release– Enhancements– Bug fixes
• How to apply the patch
• NOMIS tool live demo
Enhancements
• Linking to outputs that are only available on a single mini-site
• Support for HTML Dynamic Report templates
• Metadata links in Profiles and Advanced Profiles
Enhancements (2)
• Widget Properties– Grouped by behaviour under headings– Improved control over chart labels
• JavaScript API for embedding content in other websites
• Comparison areas in Profiles– Default/optional areas– Ordering– Subsets/related geo-types
Bugs
• Cross site scripting vulnerability
• HTML5 reports not loading
• ‘Add to favourites’
• Spacer/header in table widgets
• Removing widgets (Firefox)
• Server Publisher fixes
NOMIS Data Transfer Tool
• New, standalone, desktop tool to import data into IAS – wizard based
• Can be one-off import of data or scheduled imports
• Uses the NOMIS REST API (& XML)
• Gives easy access to labour market statistics for IAS customers
How to apply the upgrade
• Deployed as a patch
• Does not require any new pre-requisites
• Does require IAS 6.5.1
• Not expected to have an impact on custom branding
Thank you for listening!
Any questions?
Data: Transfer Tools & APIs
Data loading, linkage, tools and dissemination with InstantAtlas
Server (IAS)Keith Morrison, GeoWise
Outline
• Data Loading• Existing methods and tools• Data from NOMIS – new IAS tool• Census data and the future…
• Data Linkage• IAS and other databases
• Linked & Open Data• IAS, CKAN, links and downloads
Data Loading: Files
• XML• Primary loading method• OCSI Data Packs• Excel Data Manager
• CSV• Very limited
Data Loading: APIs (1)
• NeSS Data Exchange“The Neighbourhood Statistics (NeSS) Data Exchange (NDE) is the name given to the Application Programming Interface (API) designed for NeSS. ”
•Standalone, desktop tool to import data into IAS – wizard based•Can be one-off import of data or scheduled imports•Uses the NeSS REST API (& XML)•Gives easy access to Census 2011 data for IAS customers
Data Loading: APIs (2)
• NOMIS“Nomis is a service provided by the Office for National Statistics, ONS, to give you free access to the most detailed and up-to-date UK labour market statistics from official sources.”
•New, standalone, desktop tool to import data into IAS – wizard based•Can be one-off import of data or scheduled imports•Uses the NOMIS REST API (& XML)•Gives easy access to labour market statistics for IAS customers (including some Census tables)
NOMIS Wizard
Data Loading: APIs (3)
• ONS Open API “ONS produces a wide variety of different data, made available on our website in various ways… The ONS Application Programming Interface (API) is the way in which ONS can help [third-party applications]...”
•Designed initially for Census 2011 data•Is currently in “public beta”•Uses a(nother) REST API (& XML)•Very limited at the moment - most of the data is also available through NOMIS, NeSS or in bulk•IAS integration? Tools? Maybe…
IAS: Data Sources
Data
InstantAtlas Server (IAS)
Data base(s)
XML
CSV
NOMIS
NeSS
IAS
Via Tools
Data Linkage: Databases
• IAS can link directly to tables in your corporate database• No need to transfer or duplicate
data – can be a “live link” (but you can “grab and go” if you want)
• Used successfully by Vermont – uses their “data warehouse” directly
Open
Data
IAS: Outputs, Linking & Sharing
Data
InstantAtlas Server (IAS)
XML
CSV
Data base(s)
NOMIS
NeSS
IAS
Via Tools
HTML XML CSV Excel JSON
Linked Data? Open Data?
• Linked Data"a term used to describe a recommended best practice for exposing, sharing, and connecting pieces of data, information, and knowledge on the Semantic Web using URIs and RDF.“ (Wikipedia, via linkeddata.org)
• For IAS it’s about making data discoverable (linked) and re-useable (open)•New “linked data API” for IAS•New “publish via CKAN” function•Support for different data file formats, alongside visualisations etc.
Open
Data
IAS: Outputs, Linking & Sharing
HTML XML CSV Excel JSON
InstantAtlas Server (IAS) CKAN
Register
Reference
Linked
Data HTML RDF JSON
Reference
Open
Data
IAS: Outputs, Linking & Sharing - ExampleHTML XML CSV Excel JSON
Linked
Data HTML RDF JSONInstantAtlas
Server (IAS)
online.instantatlas.com/instantatlas-demo-pages
Future Plans
• What do you want?• We’re always looking at:
• New data APIs (Census, Crime…)• Streamlining loading code (&
therefore speed)• Reducing complexity (metadata!)• Exposing IAS data via APIs
Links
• NeSS neighbourhood.statistics.gov.uk/dissemination/ • NOMIS www.nomisweb.co.uk/ • ONS Open API www.ons.gov.uk/ons/about-ons/who-ons-are/programmes-
and-projects/enhancing-access/ons-api/index.html • Linked data linkeddata.org • CKAN ckan.org • Open Data Handbook – file formats
opendatahandbook.org/en/appendices/file-formats.html• Linked data and JavaScript example:
http://online.instantatlas.com/instantatlas-demo-pages/hampshire-ias-api/data-integrate-scripted.html