Visokio website     Downloads     Video tutorials     KnowledgeBase  
Map View: New GIS data files - Shapefiles, KML (2.8+) - Visokio Forums
Map View: New GIS data files - Shapefiles, KML (2.8+)
  •     steve May 10, 2013 12:13PM
    From Omniscope 2.8 Beta, you can now import data from ESRI Shapefiles (.shp) and Google Earth (.kml) files.

    These files typically contain geographic data, such as points, polygons and polylines, with additional metadata.

    Omniscope allows you to import this data as a flat table of fields and records, take advantage of the powerful ETL DataManager merging and transforming operations, and/or open in Omniscope for exploring and analysing in the Map and other views.

    When imported into Omniscope, the data is treated no differently to non-geo data. You can filter and aggregate, for example. Typically two fields will contain the lat/lon coordinates of each point or vertex, and other fields might exist for metadata or path ID purposes.
  • 7 Comments
  •     paola June 7, 2013 12:45PM
    image
    Please see the demo file.
  •        daniel June 12, 2013 9:01AM
    I wanted to get a clarification on the shapefiles allowed, is there an issue where the shapefiles using OSGB coordinates do not work as overlays? I'm having trouble getting any to show up the way they do in the examples.

    I am testing with the following:

    http://www.ons.gov.uk/ons/guide-method/geography/products/census/spatial/2011/index.html
  •     richard June 12, 2013 10:40AM
    Hi Daniel - Omniscope's Map View only supports plotting coordinates in the WGS84 Geographic Coordinate System. However, Omniscope can load shapefiles in any Geographic or Projected Coordinate System (including OSGB).

    There is an existing function for converting OSGB X & Y values to WGS84 Latitude and Longitudes. So all you need to do is;

    1. Load the shapefile data (values are in OSGB)
    2. Use a Field Organiser block and add in 2 new fields (latitude and longitude) using the formula functions CONVERT_OSGB_TO_LAT & CONVERT_OSGB_TO_LON
    3. Create a map view which plots the WGS84 Latitude and Longitude (not OSGB X and Y)

    In 2.9 we are intending on building a connector for various Esri ArcServer services. One of these will likely be a coordinate conversion service which will open up the possibility of converting a wider variety of coordinate systems into WGS84.

    Thanks, Richard
  •        daniel June 12, 2013 11:31AM
    I did got them to load that way but I really hoping to get the overlay to do it so I could have shaded areas instead of just the outlines. Is there a way I'm overlooking to connect the points and shade the individual shapes using the existing map view options?
  •     richard June 12, 2013 12:15PM
    In 2.8, if you want to use this data as an overlay then you will need to save it out to a file with the WGS84 coordinates included.

    The reason for this is that the Map View currently only supports plotting overlay data which is already formatted correctly. It cannot carry out additional transformations, e.g. coordinate conversion like the DataManager.

    You can save out in any of the supported file types, e.g. CSV, IOK etc and a Map View will be able to build the overlay layer. When importing the data back in to a Map View you will be prompted to choose the data type (in your case 'Area') and the Overlay ID, Overlay Sub-path ID, Longitude & Latitude columns. The field options should already be populated but just check that they are correct.

    If run into any problems with this then we can do a quick screen share. We are in the process of creating more demo's and tutorials on how to use the this functionality.

    In 2.9 we will be streamlining this process by allowing you to do a full DataManager ETL workflow into an 'embedded dataset' block. This can then be used as an overlay layer and refreshed automatically etc. -Richard
  •        daniel June 13, 2013 7:10AM
    Got it working, will Visokio consider making overlays a possible look up resource like with the postcode look up files?

    It took a bit of work to process down the shapefiles to csv.

    image

    Attachments
    Screenshot (51).png 970K
  •     richard June 13, 2013 8:39AM
    Yes, in 2.9 we intend on adding in a selection of GIS lookup files which will work directly with the map views without requiring transformations

    We haven't yet decided what will be available.

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership