| 1 | <?xml version="1.0"?> |
|---|
| 2 | <resources xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" |
|---|
| 3 | xsi:noNamespaceSchemaLocation="http://wrs.postlbs.org/xsd/1.1.0/resource.xsd"> |
|---|
| 4 | <resource type="database" name="pgrouting" |
|---|
| 5 | title="pgRouting instance on Dumbo server"> |
|---|
| 6 | <description>pgRouting 1.0.1, PostGIS 1.11, PostgreSQL 8.1</description> |
|---|
| 7 | <parameters> |
|---|
| 8 | <parameter name="srid" constant="true" type="integer" key="srid" value="EPSG:4326" /> |
|---|
| 9 | <parameter name="units" constant="true" type="string" key="units" value="dd" /> |
|---|
| 10 | <parameter name="rbox" type="double" key="box" value="0.1" /> |
|---|
| 11 | <parameter name="box" type="double" key="box" value="0.01" /> |
|---|
| 12 | <parameter name="cost_value" type="string" key="cost_value" value="length" /> |
|---|
| 13 | <parameter name="reverse_cost_value" type="string" key="reverse_cost_value" value="reverse_cost" /> |
|---|
| 14 | <parameter name="directed" type="boolean" key="directed" |
|---|
| 15 | value="true" /> |
|---|
| 16 | <parameter name="hasrc" type="boolean" key="hasrc" value="true" /> |
|---|
| 17 | <parameter name="table" type="string" key="table" |
|---|
| 18 | value="_hcc_algo_shooting" /> |
|---|
| 19 | |
|---|
| 20 | <parameter name="id" type="integer" key="a.gid"/> |
|---|
| 21 | <parameter name="cost" type="double" key="length(a.the_geom)"/> |
|---|
| 22 | <parameter name="rlength" type="double" key="b.length"/> |
|---|
| 23 | <parameter name="line" type="geometry" key="astext(a.the_geom)"/> |
|---|
| 24 | <parameter name="polygon" type="geometry" key="astext(a.the_geom)"/> |
|---|
| 25 | |
|---|
| 26 | </parameters> |
|---|
| 27 | <services> |
|---|
| 28 | <sref ref="route" enabled="true" /> |
|---|
| 29 | <sref ref="travel" enabled="true" /> |
|---|
| 30 | <sref ref="catch" enabled="true" /> |
|---|
| 31 | </services> |
|---|
| 32 | <url>jdbc:postgresql://192.168.20.177:5432/hcc</url> |
|---|
| 33 | <user>postgres</user> |
|---|
| 34 | <password></password> |
|---|
| 35 | <query> |
|---|
| 36 | SELECT $output$ FROM $function$($input$) a, _hcc_algo_shooting b where a.gid=b.gid |
|---|
| 37 | </query> |
|---|
| 38 | </resource> |
|---|
| 39 | |
|---|
| 40 | <resource type="database" name="geocoder" |
|---|
| 41 | title="Geocoder Dumbo server"> |
|---|
| 42 | <description>PostgreSQL 8.1</description> |
|---|
| 43 | <parameters> |
|---|
| 44 | <parameter name="srid" constant="true" type="integer" key="srid" value="EPSG:4612" /> |
|---|
| 45 | <parameter name="units" constant="true" type="string" key="units" value="dd" /> |
|---|
| 46 | |
|---|
| 47 | <parameter name="precision" type="integer" key="code"/> |
|---|
| 48 | <parameter name="point" type="double" key="astext(point)"/> |
|---|
| 49 | <parameter name="address" type="string" key="address"/> |
|---|
| 50 | </parameters> |
|---|
| 51 | <services> |
|---|
| 52 | <sref ref="geocode" enabled="true" /> |
|---|
| 53 | </services> |
|---|
| 54 | <url>jdbc:postgresql://192.168.20.177:5432/address</url> |
|---|
| 55 | <user>postgres</user> |
|---|
| 56 | <password></password> |
|---|
| 57 | <query> |
|---|
| 58 | SELECT $output$ FROM $function$($input$) |
|---|
| 59 | </query> |
|---|
| 60 | </resource> |
|---|
| 61 | |
|---|
| 62 | <resource type="self" name="self" |
|---|
| 63 | title="Inner services"> |
|---|
| 64 | <description>Inner services which are available for all profiles by default</description> |
|---|
| 65 | <parameters> |
|---|
| 66 | <parameter name="dummy" type="string" key="dummy"/> |
|---|
| 67 | </parameters> |
|---|
| 68 | <services> |
|---|
| 69 | <sref ref="capabilities" enabled="true" /> |
|---|
| 70 | </services> |
|---|
| 71 | <url>http://localhost</url> |
|---|
| 72 | <user></user> |
|---|
| 73 | <password></password> |
|---|
| 74 | <query></query> |
|---|
| 75 | </resource> |
|---|
| 76 | |
|---|
| 77 | <resource type="database" name="osm_pgrouting" |
|---|
| 78 | title="pgRouting instance on Dumbo server"> |
|---|
| 79 | <description>pgRouting 1.0.1, PostGIS 1.11, PostgreSQL 8.1.11</description> |
|---|
| 80 | <parameters> |
|---|
| 81 | <parameter name="srid" constant="true" type="integer" key="srid" value="EPSG:4326" /> |
|---|
| 82 | <parameter name="units" constant="true" type="string" key="units" value="meters" /> |
|---|
| 83 | <parameter name="rbox" type="double" key="box" value="0.11" /> |
|---|
| 84 | <parameter name="box" type="double" key="box" value="0.1" /> |
|---|
| 85 | <parameter name="cost_value" type="string" key="cost_value" value="meters" /> |
|---|
| 86 | <parameter name="reverse_cost_value" type="string" key="reverse_cost_value" value="meters_rc" /> |
|---|
| 87 | <parameter name="directed" type="boolean" key="directed" |
|---|
| 88 | value="true" /> |
|---|
| 89 | <parameter name="hasrc" type="boolean" key="hasrc" value="true" /> |
|---|
| 90 | <parameter name="table" type="string" key="table" |
|---|
| 91 | value="sydney_pedestrians" /> |
|---|
| 92 | |
|---|
| 93 | <parameter name="id" type="integer" key="a.gid"/> |
|---|
| 94 | <parameter name="cost" type="double" key="b.meters"/> |
|---|
| 95 | <parameter name="rlength" type="double" key="b.meters"/> |
|---|
| 96 | <parameter name="line" type="geometry" key="astext(a.the_geom)"/> |
|---|
| 97 | <parameter name="polygon" type="geometry" key="astext(a.the_geom)"/> |
|---|
| 98 | |
|---|
| 99 | </parameters> |
|---|
| 100 | <services> |
|---|
| 101 | <sref ref="route" enabled="true" /> |
|---|
| 102 | <sref ref="travel" enabled="true" /> |
|---|
| 103 | <sref ref="catch" enabled="true" /> |
|---|
| 104 | </services> |
|---|
| 105 | <url>jdbc:postgresql://192.168.20.177:5432/australia</url> |
|---|
| 106 | <user>postgres</user> |
|---|
| 107 | <password></password> |
|---|
| 108 | <query> |
|---|
| 109 | SELECT $output$ FROM $function$($input$) a left join sydney b on (a.gid=b.gid) |
|---|
| 110 | </query> |
|---|
| 111 | </resource> |
|---|
| 112 | |
|---|
| 113 | <resource type="database" name="suuchi" |
|---|
| 114 | title="pgRouting instance on Dumbo server"> |
|---|
| 115 | <description>pgRouting 1.0.1, PostGIS 1.11, PostgreSQL 8.1</description> |
|---|
| 116 | <parameters> |
|---|
| 117 | <parameter name="srid" constant="true" type="integer" key="srid" value="EPSG:4612" /> |
|---|
| 118 | <parameter name="units" constant="true" type="string" key="units" value="dd" /> |
|---|
| 119 | <parameter name="rbox" type="double" key="box" value="0.1" /> |
|---|
| 120 | <parameter name="box" type="double" key="box" value="0.01" /> |
|---|
| 121 | <parameter name="cost_value" type="string" key="cost_value" value="length" /> |
|---|
| 122 | <parameter name="reverse_cost_value" type="string" key="reverse_cost_value" value="reverse_cost" /> |
|---|
| 123 | <parameter name="directed" type="boolean" key="directed" |
|---|
| 124 | value="true" /> |
|---|
| 125 | <parameter name="hasrc" type="boolean" key="hasrc" value="true" /> |
|---|
| 126 | <parameter name="table" type="string" key="table" |
|---|
| 127 | value="suuchi_kanagawa_topo" /> |
|---|
| 128 | |
|---|
| 129 | <parameter name="id" type="integer" key="a.gid"/> |
|---|
| 130 | <parameter name="cost" type="double" key="length(a.the_geom)"/> |
|---|
| 131 | <parameter name="rlength" type="double" key="b.length"/> |
|---|
| 132 | <parameter name="line" type="geometry" key="astext(a.the_geom)"/> |
|---|
| 133 | <parameter name="polygon" type="geometry" key="astext(a.the_geom)"/> |
|---|
| 134 | |
|---|
| 135 | </parameters> |
|---|
| 136 | <services> |
|---|
| 137 | <sref ref="route" enabled="true" /> |
|---|
| 138 | <sref ref="catch" enabled="true" /> |
|---|
| 139 | </services> |
|---|
| 140 | <url>jdbc:postgresql://192.168.20.177:5432/suuchi</url> |
|---|
| 141 | <user>postgres</user> |
|---|
| 142 | <password></password> |
|---|
| 143 | <query> |
|---|
| 144 | SELECT $output$ FROM $function$($input$) a, suuchi_kanagawa_topo b where a.gid=b.gid |
|---|
| 145 | </query> |
|---|
| 146 | </resource> |
|---|
| 147 | |
|---|
| 148 | </resources> |
|---|