Closed

Quantum GIS

A simple project if you are familiar with GIS or Quantum GIS and SQL.

I have a CSV file, with the source point (the_geom) and destination point (the_geom).

I have a road network already imported into PostGIS and pgRouting and I need to have the ability to calculate the distance from a source to a destination, by using the road path as the road. After calculating, it should save the distance back into the DB in a new column.

I was told that I can run:

Code: Select all

INSERT INTO <distance table>

SELECT sum(cost) FROM shortest_path(

'SELECT id,source,target,cost FROM <road table>',

<source id>, <target id>, false, false

);

1. According to the documentation ([url removed, login to view]) , the <road table> requires a Length/Cost field, but I do not have a Length/Cost field in my Roads table.

I can use the Shortest_path module in QGIS and it works fine - But I will need to calculate in bulk and save it back into a DB.

2. <source id> and <target id> according to pgRouting it needs to accept an integer. My source table and destination table that has the Points is as following:

- Name

- Geometry

I would like QGIS to calculate:

1st row of source to 1st row of destination - save in new DB with Source and Destination and Cost

1st row of source to 2nd row of destination - Save the result with Source and Destination and Cost

1st row of source to ...

1st row of source to last row of destination - save in DB

2nd row of source to 1st row of destination - save in DB

I need someone to help me to achieve all the above.

Skills: Geolocation, Quantum

See more: point distance quantum gis, using geometry, geometry 2, point geometry, roads, quantum, quantum gis, qgis, geometry, html table save, simple gis, gis project roads, html table insert, distance calculate, sum target, bulk insert, save html sql, simple distance project, sum csv file, road distance, csv calculate sum, html table csv using, html csv using, distance table, html table csv

About the Employer:
( 6 reviews ) Ampang, Malaysia

Project ID: #2515076

3 freelancers are bidding on average $70 for this job

ShijilGIS

I think u dont have the Length of the Roads , i will help to get the road length and coast weightage then only u can really perform the routing analysis.

$130 USD in 7 days
(0 Reviews)
0.0
eXtremCode

hello. sorry delay to response u in anothre project. If we have chance to cooperate with u , please contact me.

$50 USD in 4 days
(0 Reviews)
0.0
ExtraNet

I can create your road lengths using appropriate GIS software, please see your inbox for details.

$30 USD in 2 days
(0 Reviews)
0.0