Top 5 Recent Articles
- Biography (1)
- Blog (41)
- Changes (1)
- Customers (1)
- Data Models (1)
- Education (2)
- General Software (21)
- Georaptor Blog (5)
- Image Catalog (2)
- Licensing (1)
- ManifoldGIS (3)
- MySQL Blog (4)
- MySQL Spatial (3)
- Networking and Routing (including Optimization) (3)
- Oracle Spatial (171)
- Philosophy (1)
- PostGIS (30)
- Press Releases (1)
- Source code (24)
- Space Curves (1)
- Spatial DB comparison (1)
- SQL (1)
- SQL Server Blog (58)
- SQL Server Spatial (General) (15)
- SQL Server Spatial (LRS) (37)
- Stored Procedure (2)
- Training (1)
- XML (5)
There’s Network Analysis, and then there IS Network Analysis
Solutions are built by layering technology, from the simple to the complex.
Nothing more illustrates this than considering network analysis.
Firstly, most Geographic Information Systems (insert your favorite here), and database vendors like Oracle and PostgreSQL/PostGIS provide a basic routing engine.
And what they offer is generally basic: a network or graph model, functions for loading data such as street data into it, and some basic functions for querying such as Shortest Path and Traveling Salesman.
Sometimes one thinks there is a confusion about the basic offerings mentioned above: they are not a solution, only a basic tool.
Consider this: a basic network/routing package so mentioned, cannot provide functionality that can analyse a water network: there are too many domain-specific variables and functionality to implement and manage.
Specialist software is needed to develop and deliver solutions.
It has always been surprising that geospatial professionals confused their technologies with solutions.
Now, before Google Maps, there were precious little networking and routing solutions which were targeted at the public.
And Google Map has done this well: the ubiquitous network data; an excellent address search engine that includes not just street addresses but points of interest; business data; and street view.
Google Maps ability to generate directions from point A to point B with multiple stops is excellent.
But note: the stops have to be traversed in the input order: the stops are fixed.
What the user wants, the user wants!
What Google maps does well, it does well.
Users love it.
Note that, with Google, the only optimization is in the choice of streets between the requested points. However, the inputs to this are not just the street network but the time to travel a street determined by speed and capacity (e.g. dynamic load).
But when it comes to route optimization and scheduling of complex problems, e.g. OptimoRoute, real domain knowledge expressed in powerful algorithms and functionality is required.
Such functionality includes:
- User defined time and date constraints;
- Repeatable date schedules;/li>
- Inputs that include vehicle size (motor cycle through, van, to semi-rigid, and B-Double etc);/li>
- Loading and Unloading times;/li>
- Load priority;/li>
- Fuel Economy inputs./li>
As you can see there are lots of potential parameters that need to be implement; a basic network (graph) and routing engine isn’t enough.
In the past, real route optimization was specialist stuff only accessible by business that could afford it. But in these days of Cloud computer: Software As A Service (SAAS) etc, highly functional services can be accessed by businesses of any size at a price that fits their needs.
So, as was said at the start, the really interesting stuff, is the way technology is layered from the basic to the sophisticated.
A solution is available for most or all: just know what is needed and step out from there!