[pgrouting-users] Converting a shape file to a network

[Dave Potts]

I tried this and got an error message to the effect missing column

med_proj=# \d tmp;
                                     Table "public.tmp"
  Column  |          Type           | Collation | Nullable |
 Default
----------+-------------------------+-----------+----------+---------------------------------
 id       | integer                 |           | not null |
nextval('tmp_id_seq'::regclass)
 the_geom | geometry(Geometry,3857) |           |          |

med_proj=# \d tmp_noded;
                                     Table "public.tmp_noded"
  Column  |          Type           | Collation | Nullable |
Default
----------+-------------------------+-----------+----------+---------------------------------------
 id       | integer                 |           | not null |
nextval('tmp_noded_id_seq'::regclass)
 old_id   | bigint                  |           |          |
 sub_id   | bigint                  |           |          |
 source   | bigint                  |           |          |
 target   | bigint                  |           |          |
 the_geom | geometry(Geometry,3857) |           |          |

Invoking this, should put the results in tmp_noded, which according to the
above and the manual at
https://docs.pgrouting.org/2.6/en/pgr_nodeNetwork.html has all the right
column

Doing this
med_proj=# select pgr_createTopology('tmp',1);

Given an error,  I don't  think there is anything wrong with the functions,
it most be my table layout, but according to the documents,everything is
correct.
NOTICE:  PROCESSING:
NOTICE:  pgr_createTopology('tmp', 1, 'the_geom', 'id', 'source', 'target',
rows_where := 'true', clean := f)
NOTICE:  Performing checks, please wait .....
NOTICE:  ----> PGR ERROR in pgr_createTopology: Column source not found
HINT:    ----> Check your column name
NOTICE:  Unexpected error raise_exception
 pgr_createtopology
--------------------
 FAIL

any ideas what I am doing wrong ?

Dave.




On 17 May 2018 at 21:35, Vicky Vergara <vicky at georepublic.de> wrote:

> Hi Dave,
>
> Have you tried:
>
> https://docs.pgrouting.org/2.6/en/pgr_nodeNetwork.html
>
> Its has some issues, but does a reasonable work for pgRouting purposes.
> Fixing the geometry would be using postGIS
>
>
>
> On Thu, May 17, 2018 at 2:47 PM, Dave Potts <mrdapotts at gmail.com> wrote:
>
>> Hi,
>>
>> I am trying to convert a shapefile of linestrings into a suitable form
>> for pgroute.  The type of issue that I am getting is that from a casual
>> look its looks fine, but if you drill down in to the map, you find there
>> are some line segments should connect, but they don't due to the way that
>> the data was entered.
>>
>> Q. Has anybody attempt this type of thing before and what if any
>> solutions did they find ?
>> Dave.
>>
>> _______________________________________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>
>
>
>
> --
>
> Georepublic UG (haftungsbeschränkt)
> Salzmannstraße 44,
> 81739 München, Germany
>
> Vicky Vergara
> Operations Research
>
> eMail: vicky at georepublic.de
> Web: https://georepublic.info
>
> Tel: +49 (089) 4161 7698-1
> Fax: +49 (089) 4161 7698-9
>
> Commercial register: Amtsgericht München, HRB 181428
> CEO: Daniel Kastl
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20180519/378cbe25/attachment.html>