root/tools/routingservice/trunk/configuration.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
<restlet>
        <port>8182</port>
        <log mode="3">./log/access.log</log>
        
        <providers>
                <!--HCC-->
                <provider name="hcc" title="hcc">
                        <description>Webrouting Service</description>
                        <services>
                                <service name="closest_edge" title="Closest Edge" enable="true">
                                        <description>Returns the closest node link to an arbitrary point</description>
                                        <connection driver="org.postgresql.Driver">
                                                <url>jdbc:postgresql://127.0.0.1:5432/hcc</url>
                                                <user>postgres</user>
                                                <password></password>
                                        </connection>
                                        <projection srid="4612"></projection>
                                        <limit distance="100000" />
                                        <sql>
                                                <query transformProjectionIn="false" transformProjectionOut="false">SELECT gid, source, target, AsText(the_geom) AS wkt, distance(the_geom, GeometryFromText('POINT($sonPx$ $sonPy$)',$sridProvider$)) AS dist FROM hcc_20090121 WHERE the_geom &amp;&amp; setsrid('BOX3D($sonPxM$ $sonPyM$,$sonPxP$ $sonPyP$)'::box3d, $sridProvider$) ORDER BY dist LIMIT 1</query>
                                                <query transformProjectionIn="false" transformProjectionOut="true">SELECT gid, source, target, AsText(transform(setSRID(the_geom,$sridProvider$), $sridOut$)) AS wkt, distance(the_geom, GeometryFromText('POINT($sonPx$ $sonPy$)',$sridProvider$)) AS dist FROM hcc_20090121 WHERE the_geom &amp;&amp; setsrid('BOX3D($sonPxM$ $sonPyM$,$sonPxP$ $sonPyP$)'::box3d, $sridProvider$) ORDER BY dist LIMIT 1</query>
                                                <query transformProjectionIn="true" transformProjectionOut="false">SELECT gid, source, target, AsText(the_geom) AS wkt, distance(the_geom, transform(GeometryFromText('POINT($sonPx$ $sonPy$)',$sridIn$),$sridProvider$)) AS dist FROM hcc_20090121 WHERE the_geom &amp;&amp; transform(setsrid('BOX3D($sonPxM$ $sonPyM$,$sonPxP$ $sonPyP$)'::box3d, $sridIn$), $sridProvider$) ORDER BY dist LIMIT 1</query>
                                                <query transformProjectionIn="true" transformProjectionOut="true">SELECT gid, source, target, AsText(transform(setSRID(the_geom,$sridProvider$), $sridOut$)) AS wkt, distance(the_geom, transform(GeometryFromText('POINT($sonPx$ $sonPy$)',$sridIn$),$sridProvider$)) AS dist FROM hcc_20090121 WHERE the_geom &amp;&amp; transform(setsrid('BOX3D($sonPxM$ $sonPyM$,$sonPxP$ $sonPyP$)'::box3d, $sridIn$), $sridProvider$) ORDER BY dist LIMIT 1</query>
                                        </sql>
                                        <parameters>
                                                <parameter name="point" type="text" codename="point" required="true" />
                                                <parameter name="sridInput" type="integer" codename="sridIn" required="false" />
                                                <parameter name="sridOutput" type="integer" codename="sridOut" required="false" />
                                                <parameter name="bbox" type="integer" codename="bbox" required="false" default="0.0005" />
                                                <parameter name="request_id" type="text" codename="request_id" required="false" />
                                        </parameters>
                                        <formats>
                                                <format name="gml" input="true" output="true" />
                                                <format name="xml" input="false" output="true" />
                                                <format name="html" input="false" output="true" />
                                                <format name="geojson" input="true" output="true" />
                                                <format name="id" input="false" output="true" />
                                                <format name="lonlat" input="true" output="false" />
                                                <format name="wkt" input="true" output="true" />
                                                <format name="kml" input="true" output="true" srid="4326" />
                                        </formats>
                                </service>

                                <service name="shortest_path" title="Shortest Path" enable="true">
                                        <description>Returns the shortest path between two arbitrary points</description>
                                        <connection driver="org.postgresql.Driver">
                                                <url>jdbc:postgresql://127.0.0.1:5432/hcc</url>
                                                <user>postgres</user>
                                                <password></password>
                                        </connection>
                                        <projection srid="4612"></projection>
                                        <limit distance="10000.0" />
                                        <sql>
                                                <query transformProjectionIn="false" transformProjectionOut="false">SELECT gid, AsText(the_geom) AS wkt FROM shootingstar_sp_smart('hcc_20090121', $sonStartX$, $sonStartY$, $sonEndX$, $sonEndY$, $saBoxSize$,'length',true,true)</query>
                                                <query transformProjectionIn="false" transformProjectionOut="true">SELECT gid, AsText(transform(setSRID(the_geom,$sridProvider$), $sridOut$)) AS wkt FROM shootingstar_sp_smart('hcc_20090121', $sonStartX$, $sonStartY$, $sonEndX$, $sonEndY$, $saBoxSize$,'length',true,true)</query>
                                                <query transformProjectionIn="true" transformProjectionOut="false">SELECT gid, AsText(the_geom) AS wkt FROM shootingstar_sp_smart('hcc_20090121', X(transform(GeometryFromText('POINT($sonStartX$ $sonStartY$)',$sridIn$),$sridProvider$)), Y(transform(GeometryFromText('POINT($sonStartX$ $sonStartY$)',$sridIn$),$sridProvider$)), X(transform(GeometryFromText('POINT($sonEndX$ $sonEndY$)',$sridIn$),$sridProvider$)), Y(transform(GeometryFromText('POINT($sonEndX$ $sonEndY$)',$sridIn$),$sridProvider$)), $saBoxSize$,'length',true,true)</query>
                                                <query transformProjectionIn="true" transformProjectionOut="true">SELECT gid, AsText(transform(setSRID(the_geom,$sridProvider$), $sridOut$)) AS wkt FROM shootingstar_sp_smart('hcc_20090121', X(transform(GeometryFromText('POINT($sonStartX$ $sonStartY$)',$sridIn$),$sridProvider$)), Y(transform(GeometryFromText('POINT($sonStartX$ $sonStartY$)',$sridIn$),$sridProvider$)), X(transform(GeometryFromText('POINT($sonEndX$ $sonEndY$)',$sridIn$),$sridProvider$)), Y(transform(GeometryFromText('POINT($sonEndX$ $sonEndY$)',$sridIn$),$sridProvider$)), $saBoxSize$,'length',true,true)</query>
                                        </sql>
                                        <parameters>
                                                <parameter name="point_start" type="text" codename="start" required="true" />
                                                <parameter name="point_end" type="text" codename="end" required="true" />
                                                <parameter name="sridInput" type="integer" codename="sridIn" required="false" />
                                                <parameter name="sridOutput" type="integer" codename="sridOut" required="false" />
                                                <parameter name="bbox" type="integer" codename="bbox" required="false" default="0.004" />
                                                <parameter name="request_id" type="text" codename="request_id" required="false" />
                                        </parameters>
                                        <formats>
                                                <format name="gml" input="true" output="true" template="multilinestring_gml" />
                                                <format name="xml" input="false" output="true" template="multilinestring_xml" />
                                                <format name="html" input="false" output="true" template="multilinestring_html" />
                                                <format name="geojson" input="true" output="true" template="multilinestring_geojson" />
                                                <format name="lonlat" input="true" output="false" />
                                                <format name="wkt" input="true" output="true" template="multilinestring_wkt" />
                                                <format name="kml" input="true" output="true" srid="4326" template="multilinestring_kml" />
                                        </formats>
                                </service>

                                <service name="driving_distance" title="Driving Distance" enable="true">
                                        <description>Returns a driving distance polygon</description>
                                        <connection driver="org.postgresql.Driver">
                                                <url>jdbc:postgresql://127.0.0.1:5432/hcc</url>
                                                <user>postgres</user>
                                                <password></password>
                                        </connection>
                                        <projection srid="4612"></projection>
                                        <sql>
                                                <query transformProjectionIn="false" transformProjectionOut="false">SELECT AsText(the_geom) AS wkt FROM points_as_polygon('SELECT a.vertex_id::integer AS id, b.x1::double precision AS x, b.y1::double precision AS y FROM driving_distance(''''SELECT gid AS id,source::integer,target::integer,length::double precision AS cost FROM hcc_20090121'''',(select id from find_node_by_nearest_link_within_distance(''''POINT($sonPx$ $sonPy$)'''',$bbox$,''''hcc_20090121'''')),$distance$,false,false) a, hcc_20090121 b WHERE a.vertex_id = b.source');</query>
                                                <query transformProjectionIn="false" transformProjectionOut="true">SELECT AsText(transform(setsrid(the_geom, $sridProvider$), $sridOut$)) AS wkt FROM points_as_polygon('SELECT a.vertex_id::integer AS id, b.x1::double precision AS x, b.y1::double precision AS y FROM driving_distance(''''SELECT gid AS id,source::integer,target::integer,length::double precision AS cost FROM hcc_20090121'''',(select id from find_node_by_nearest_link_within_distance(''''POINT($sonPx$ $sonPy$)'''',$bbox$,''''hcc_20090121'''')),$distance$,false,false) a, hcc_20090121 b WHERE a.vertex_id = b.source');</query>
                                                <query transformProjectionIn="true" transformProjectionOut="false">SELECT AsText(the_geom) AS wkt FROM points_as_polygon('SELECT a.vertex_id::integer AS id, b.x1::double precision AS x, b.y1::double precision AS y FROM driving_distance(''''SELECT gid AS id,source::integer,target::integer,length::double precision AS cost FROM '''',(select id from find_node_by_nearest_link_within_distance(text2text_transform(''''POINT($sonPx$ $sonPy$)'''',$sridIn$,$sridProvider$),$bbox$,''''hcc_20090121'''')),$distance$,false,false) a, hcc_20090121 b WHERE a.vertex_id = b.source');</query>
                                                <query transformProjectionIn="true" transformProjectionOut="true">SELECT AsText(transform(setSRID(the_geom,$sridProvider$), $sridOut$)) AS wkt FROM points_as_polygon('SELECT a.vertex_id::integer AS id, b.x1::double precision AS x, b.y1::double precision AS y FROM driving_distance(''''SELECT gid AS id,source::integer,target::integer,length::double precision AS cost FROM hcc_20090121'''',(select id from find_node_by_nearest_link_within_distance(text2text_transform(''''POINT($sonPx$ $sonPy$)'''',$sridIn$,$sridProvider$),$bbox$,''''hcc_20090121'''')),$distance$,false,false) a, hcc_20090121 b WHERE a.vertex_id = b.source');</query>
                                        </sql>
                                        <parameters>
                                                <parameter name="point" type="text" codename="data" required="true" />
                                                <parameter name="time" type="integer" codename="time" required="false" />
                                                <parameter name="length" type="integer" codename="length" required="false" />
                                                <parameter name="speed" type="integer" codename="speed" required="false" default="80" />
                                                <parameter name="sridInput" type="integer" codename="sridIn" required="false" />
                                                <parameter name="sridOutput" type="integer" codename="sridOut" required="false" />
                                                <parameter name="bbox" type="integer" codename="bbox" required="false" default="0.004" />
                                                <parameter name="request_id" type="text" codename="request_id" required="false" />
                                        </parameters>
                                        <formats>
                                                <format name="gml" input="true" output="true" />
                                                <format name="xml" input="false" output="true" />
                                                <format name="html" input="false" output="true" />
                                                <format name="geojson" input="true" output="true" />
                                                <format name="lonlat" input="true" output="false" />
                                                <format name="wkt" input="true" output="true" />
                                                <format name="kml" input="true" output="true" srid="4326" />
                                        </formats>
                                </service>
                        </services>
                </provider>
        </providers>
</restlet>