pgRouting
Increase Your Efficiency in Analysis and Routing Projects.
Database Technology for Your Routing Solutions
The combination of pgRouting and PostgreSQL provides you with a powerful open-source toolkit for route calculations. With MBI StreetMap HERE, you gain access to optimised routing data specifically tailored by casaGeo for PostgreSQL databases.
Local installation empowers users to perform unlimited analyses – precise, customisable, and seamlessly integrable into existing systems. This capability allows you to link your routing data with advanced sociodemographic data at a 100-metre grid level, enabling informed and data-driven planning decisions.Advantages at a Glance
pgRouting with PostgreSQL
OPEN SOURCE
Open-source solutions provide freedom and flexibility. PostgreSQL, as one of the leading databases, offers extensive functionality to meet diverse requirements
MBI StreetMap HERE
ROUTING NETWORK
High-quality routing networks for pinpoint-accurate analyses. Optimised for detailed adjustments to routing tables based on your organisation's specific requirements. Local data processing ensures unlimited usability and complete control
Efficient System Integration
PROFESSIONAL
Seamless alignment of your routing tables with sociodemographic data. Leverage routing data across various apps and platforms through comprehensive database integration
Who is this solution suitable for?
Our data solutions are designed for businesses and professionals across various industries
Retail Professionals
for logistics planning and site evaluations
Location Planners
conducting analyses for new business areas
GIS Experts
specialising in precise GIS analyses
Database Administrators
designing robust and efficient databases
FAQ
A local installation offers the advantage of eliminating additional costs for repeated analyses, which is particularly important when analyses are needed frequently. Furthermore, it operates based on a defined time standard, ensuring analysis results remain reproducible, comparable, and verifiable.
To begin, the PostGIS, pgRouting, and DBLink extensions are installed on your PostgreSQL database, provided they are not already in place. Next, you can establish a connection to our database via DBLink to download the data supplied. We provide scripts to manage this process, ensuring the tables are stored in a way that is specifically optimised for routing applications and the calculation of catchment areas.
Yes, the routing network can be customised. Since it is based on database tables, you have access to all customisation options supported by the database technology.
Any application connected to the database can access the routing results. This is possible through ODBC drivers, Rest API, or other technologies. It is important to note that pgRouting delivers geometry data and numerical data as results. casaGeo is available to support you with the integration process.
The implementation of routing data and functions is primarily automated using the scripts we provide. Simply run these scripts to initiate the process. Additionally, our experts are always available to offer support.
The tables include the IDs of the 100m and 1km Inspire grids of the European Union by default. Any data referenced to these grids can be linked with the routing results. At the 100m grid level, casaGeo provides micro-geographic data for Germany, including information on population, households, and other relevant characteristics.