Forum #23 - Topic #88 - Message List

Hello everybody, I try to get the workshop to run. Here (http://pgrouting.postlbs.org/wiki/Workshop-LoadRoutingData) it`s written that one shall use the National Road Network pf BC. Ok, I downloaded the shapes and I think we shall use:

NRN_BC_4_0_ROADSEG.shp??

Then it`s written: "Import a clip (Victoria Downtown area) of the British Columbia road network data. "

How to do that? Is there a special SQL-Command to get only the Victoria Downtown area? In the moment I have imported all the feature of the ....ROADSEG.shp to my database (220.000), seems a bit to much to test with it. Thank you very much, Kai