RouteXL now supports advanced dynamic quantitive vehicle routing abilities

First step define your service points. You don’t need to specially format your data, just make sure it includes latitude and longitude columns. Just tell RouteXL which column means what and you are set to go.

Next define your fleet. This is also user formatted data, just tell RouteXL where to get the capacities, shift times, start and end points.

Now you need to build your matrix, which pre calculates all times and distances between the points to be used later in optimization. RouteXL can calculate millions of these pairs in minutes.

If you add new points to your point set, RouteXL only calculates the distances and times for the new points to save you time.

All this data is saved in a QVRW file, a project file for your routing exercise.

Now you are ready to segment your points and allocate trucks.

All you do is choose the “Dynamic optimize” option. RouteXL automatically plots your points and lets you select points.

Immediately after points are added or removed from the selection, RouteXL calculates the trucks needed and their routes. You can even have RouteXL display the routes, or just straight lines for clarity if needed.

If your selection has no solution, you can click the previous button to go back to the last working selection and try another.

When you are ready you can add these points to a cluster, say for example “Monday shift”

You can do what ifs, by selecting points and then adjusting truck capacities and shift times and clicking “Refresh routes” to calculate the best truck allocation and routes.

Once all clusters have been created you can recalculate all clusters and generate an output report in graphics and spreadsheet showing all the truck allocations, travel times shift times etc.

 

You can save your routes to any spatial format: shape files etc.

You can perform any spatial analysis on the results using themes and heat maps etcetera.

 

GeologXL – Advanced enterprise geological mapping

GeologXL provides advanced geological mapping abilities.

It is completely  customizable and allows storing your geological data in almost any database or data format.

Supported databases include:

  1. SQL Server (All versions including Express)
  2. Oracle (All versions from 9 up)
  3. Postgres
  4. MySQL
  5. MS Access
  6. SQLite

GeologXL allows offline operation. Before leaving for the field, download the data you wish to work with. This includes your own custom metadata. Then while out you can modify, delete and add new geological data. When you return to the office just click on the synchronize button and your data is uploaded and synchronized with the server database.

GeologXL allows total freedom over the fields captured. It allows defining custom lookups, validation rules etcetera.

The geological data is stored as native 3D spatial data in the database. Thus in Oracle it supports Oracle Spatial. In SQL server it supports the native SQL 2d geometries, and using our SpatialBase it supports any 3d data. If you don’t need to manipulate the 3d data inside Sql server then the data is stored in binary form on the database and can be manipulated in the GeologXL front end.

Relations can be defined between geological data tables allowing for capture of master detail data.

Data can be exported to almost any graphic format including:

  1. Microstation DGN
  2. Autodesk DWG/DXF
  3. Datamine
  4. ESRI shape files
  5. Mapinfo TAB files
  6. Modelmaker TOT files
  7. and many other lesser known formats

Any external spatial data can be loaded and overlaid. Data can be loaded from the following sources:

  1. Microstation DGN
  2. Autodesk DWG/DXF
  3. Datamine
  4. ESRI shape files
  5. Mapinfo TAB files
  6. Whittle block models
  7. All image file formats
  8. ModelMaker TOT files
  9. LandXML files
  10. KML/Kmz files
  11. and many more

Data can be coordinated by placement of tapes and construction points.

Data can be captured in freehand as well as needed.

Dashboards available on all our Spatial products

dashboardviewersxl

All our Spatial products now feature a built in dashboard designer. Create your mining dashboards right inside SpatialXL, or SamplingXL!

Any number of dashboards can be created. In SpatialXL the dashboards are saved with your workbook. In other packages the dashboards are saved with your data.

Dashboards can access all the local spatial data, plus any external source as desired.

Dashboards automatically update as data is changed. Also filters can be specified per dashboard.

Dashboard designer built into ALL our Spatial Products
Dashboard designer built into ALL our Spatial Products

External database levels in Microstation!

MineModeller Version 4.0 allows Microstation Levels to store data from an external spatial database.

The data in the levels can be synchronised with the database after either database changes have been made or elements have been added, updated or deleted in Microstation.

When the level is synchronised, its data with all attributes is stored inside the Microstation design file, allowing it to be inspected and browsed offline from the database.

MMOracleLayers

The grid can be sorted, filtered and grouped and then selected rows can be selected in graphics.

Also selected elements in Microstation can be filtered in any open data grids for easy location of data spatially.

Each level can be individually configured to link to its own database and table.

MMLevelSettings

A query and link column is specified per level to link the tabular data with the Microstation elements.

MMLayerQuery

It is possible to link to Oracle native spatial columns, Oracle OGC Well Known Binary columns (WKB), as well as SQL Server native and WKB columns. Finally you can link to our famous full 3D spatial extension to SQL Server SpatialBase.

MMLayerTypes

This is an excellent solution for doing Geological modelling in Microstation. You can filter your geological data with complex attribute filters, and then spatially operate to build surfaces or model structures as needed. All the data can be stored in a central spatial database and thus securely shared within your organisation.

Also it is then possible to work offline and when ready then publish your results to the central database.

SpatialBase – 3D spatial database for mining and engineering

SpatialBase is an Extension to SQL server and Oracle that provides advanced 3D capabilities for spatial storage and manipulation.

It is ideal for storing Mining data and natively supports mining objects such as Tapes, Boreholes, Histograms, Variograms, Coordinate transformations and Triangulated Irregular Network surfaces.

There are operations to compute contours, heat maps, Voroni diagrams, coordinate transformations, 2.5 D projections and boolean operations.

SpatialBase supports the OGC standards for SQL Geometries and has its own high performance indexing which works on 2D and 3D geometries.

SpatialBaseSpatialBase

SamplingXL – Underground sampling solution

SamplingXL is the most advanced underground sampling solution available.

Based on our high performance graphics engine SamplingXL allows you to view any other spatial data with your sampling data. Both Sql Server and Oracle are supported as database backends.

SamplingXL exports sample sections directly to graphics, and there is a hot link from graphics to your sampling sheets and vice versa.

Sample sheet reports can be exported as PDF and sample sheets can even be mailed via e-mail.SamplingXL

Sections can be coordinated by placing tape, relative to pegs, and the full construction is saved with the sample sheet.

RouteXL – Optimised routing and transportation scheduling

RouteXL is an add-in to SpatialXL that allows optimised routing, transportation scheduling and high speed bulk routing operations.

Key Features:

  1. Load road networks from various sources, or create your own
  2. Calculate routing matrices for millions of routes for use in 3rd part optimization applications
  3. Allocate points to nearest in time or distance service points
  4. Calculate drive time/distance polygons
  5. Advanced quantitative vehicle routing:
    1. Define your fleet
    2. Load your service points and their demands
    3. Segment your service points into clusters
    4. Optimize vehicles and routes to service all points in shortest time
    5. Dynamic route and re-route to design optimal clusters
    6. Works with thousands on service points and hundreds of vehicles