[pgrouting-users] pgrouting workshop

[Daniel Kastl]

Hi Pedro,

In which projection are your start and end point?
You need to use ST_transform(<geom>,<srid>) if the projection is different.
In the workshop the data is in 4326 (WGS84) and so you can find this SRID
in the SQL statement.

Daniel



On Tue, Jul 10, 2012 at 11:42 AM, Pedro Costa <pedrocostaarma at sapo.pt>wrote:

>  I'm trying to adapt this function (findnearestedge) [1] to my routing
> data that are in srs 27492.
>
> Someone can help me with that?
>
>
> thanks
>
>
>
>
>
> [1]
>
> $startEdge = findNearestEdge($startPoint);
>  $endEdge   = findNearestEdge($endPoint);
>
>   function findNearestEdge($lonlat) {
>
> SELECT gid, source, target, the_geom,
>                   distance(the_geom, GeometryFromText(
>                        'POINT(".$lonlat[0]." ".$lonlat[1].")', 4326)) AS
> dist
>                  FROM ".TABLE."
>                  WHERE the_geom && setsrid(
>                        'BOX3D(".($lonlat[0]-0.1)."
>                               ".($lonlat[1]-0.1).",
>                               ".($lonlat[0]+0.1)."
>                               ".($lonlat[1]+0.1).")'::box3d, 4326)
>                  ORDER BY dist LIMIT 1"
>
>
>
>
>
>
>
>
>
>
>
>
> Em 10-07-2012 09:33, Daniel Kastl escreveu:
>
> Hi Pedro,
>
>  The years before it was always available on OSGeo server:
> http://download.osgeo.org/pgrouting/foss4g2010/
>  It seems I forgot to place the 2011 workshop there as well.
>
>  The workshop documentation source is on Github:
> https://github.com/pgRouting/workshop
> So all you're missing is the sample data. But you can download any OSM
> data or even use the sample data of 2010.
>
>  In case you're using Ubuntu/Debian you can install last years workshop
> as a package easily:
> https://launchpad.net/~georepublic/+archive/pgrouting/+packages<https://launchpad.net/%7Egeorepublic/+archive/pgrouting/+packages>
> It contains the sample data of Denver as well. Or you download the tarball
> [1] and extract it.
>
>  Or, you use OSGeo Live DVD. It contains the workshop as well:
> http://live.osgeo.org/en/quickstart/pgrouting_quickstart.html (see
> "What's next" at the end of the page).
>
>  Hope that helps,
> Daniel
>
>  [1]
> https://launchpad.net/~georepublic/+archive/pgrouting/+files/pgrouting%2Bworkshop_0.6.1.orig.tar.gz<https://launchpad.net/%7Egeorepublic/+archive/pgrouting/+files/pgrouting%2Bworkshop_0.6.1.orig.tar.gz>
>
>
>
> On Tue, Jul 10, 2012 at 10:15 AM, Pedro Costa <pedrocostaarma at sapo.pt>wrote:
>
>> Hi guys,
>>
>> I'm playing with pgrouting workshop of FOSS4G 2011.
>> There is any link to download the workshop material?
>>
>> Thanks
>>
>> Pedro
>> _______________________________________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>
>
>
>
>  --
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de
> Web: http://georepublic.de
>
>
> _______________________________________________
> Pgrouting-users mailing listPgrouting-users at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120710/d2f2e6da/attachment.html>