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> |
---|