Skip to content

Latest commit

 

History

History
102 lines (66 loc) · 2.43 KB

README.md

File metadata and controls

102 lines (66 loc) · 2.43 KB
Raw

Local Setup Guide for Routify

Welcome to Routify! This guide will walk you through setting up the project locally on your machine.

Prerequisites

Make sure you have the following installed:

  • PostgreSQL
  • PostGIS
  • PgRouting
  • GeoServer (Install on default port 8080)
  • Leaflet JS (No Installation required)
  • GDAL (ogr2ogr)

Setup Steps

Step 1: Create Database

Create a database with the required extensions:

CREATE DATABASE your_database_name;
CREATE EXTENSION postgis;
CREATE EXTENSION pgrouting;

Step 2: Load Network Data

Run the following command in PowerShell in the correct directory where new.geojson is present:

ogr2ogr -select 'name,highway,oneway,surface' -lco GEOMETRY_NAME=the_geom -lco FID=id -f PostgreSQL PG:"dbname=your_database_name user=your_username password=your_password" -nln edges new.geojson

Replace your_database_name, your_username, and your_password with your database details.

Step 3: Add Source and Target Columns

ALTER TABLE edges ADD source INT4;
ALTER TABLE edges ADD target INT4;

Step 4: Split Nodes

SELECT pgr_nodeNetwork('edges', 0.00001);

Step 5: Create Topology

SELECT pgr_createTopology('edges_noded', 0.00001);

Step 6: Copy Attribute Information

ALTER TABLE edges_noded
 ADD COLUMN name VARCHAR,
 ADD COLUMN type VARCHAR;

UPDATE edges_noded AS new
 SET name=old.name, 
   type=old.highway 
FROM edges as old
WHERE new.old_id=old.id;

Step 7: Determine Cost

ALTER TABLE edges_noded ADD distance FLOAT8;

UPDATE edges_noded SET distance = ST_Length(ST_Transform(the_geom, 4326)::geography) / 1000;

Step 8: Test Shortest Path

SELECT * FROM pgr_dijkstra('SELECT id,source,target,distance as cost FROM edges_noded',1,2,false);

Step 9: Publishing to GeoServer

On GeoServer:

  • Create a new store and connect to PostGIS database.
  • Create new layers to store edges_noded and edges_noded_vertices_pgr.
  • Create 2 parameterized SQL Views in new layers: nearest_vertex and shortest_path. See instructions in the provided documentation.

Step 10: Install CORS Plugin

Install the CORS Unblock plugin for your browser: CORS Unblock

Make sure ad blockers are disabled on your browser.

Enable the plugin and access the frontend via Routify.