draw_layer.events.on({
featureadded: function() {
pgrouting(store, draw_layer, method.getValue());
}
});
drag_points.onComplete = function() {
pgrouting(store, draw_layer, method.getValue());
};
var method = new Ext.form.ComboBox({
renderTo: "method",
triggerAction: "all",
editable: false,
forceSelection: true,
store: [
["SPD", "Shortest Path Dijkstra"],
["SPA", "Shortest Path A*"],
["SPS", "Shortest Path Shooting*"]
],
listeners: {
select: function() {
pgrouting(store, draw_layer, method.getValue());
}
});
// global projection objects (uses the proj4js lib)
var epsg_4326 = new OpenLayers.Projection("EPSG:4326"),
epsg_900913 = new OpenLayers.Projection("EPSG:900913");
function pgrouting(store, layer, method) {
if (layer.features.length == 2) {
// erase the previous route
store.removeAll();
// transform the two geometries from EPSG:900913 to EPSG:4326
var startpoint = layer.features[0].geometry.clone();
startpoint.transform(epsg_900913, epsg_4326);
var finalpoint = layer.features[1].geometry.clone();
finalpoint.transform(epsg_900913, epsg_4326);
// load to route
store.load({
params: {
startpoint: startpoint.x + " " + startpoint.y,
finalpoint: finalpoint.x + " " + finalpoint.y,
method: method
}
});
}
}
var store = new GeoExt.data.FeatureStore({
layer: route_layer,
fields: [
{name: "length"}
],
proxy: new GeoExt.data.ProtocolProxy({
protocol: new OpenLayers.Protocol.HTTP({
url: './php/pgrouting.php',
format: new OpenLayers.Format.GeoJSON({
internalProjection: epsg_900913,
externalProjection: epsg_4326
})
})
})
});
// create the layer where the route will be drawn
var route_layer = new OpenLayers.Layer.Vector("route", {
styleMap: new OpenLayers.StyleMap(new OpenLayers.Style({
strokeColor: "#ff9933",
strokeWidth: 3
}))
});
DrawPoints = OpenLayers.Class(OpenLayers.Control.DrawFeature, {
// this control is active by default
autoActivate: true,
initialize: function(layer, options) {
// only point can be drawn
var handler = OpenLayers.Handler.Point;
OpenLayers.Control.DrawFeature.prototype.initialize.apply(
this, [layer, handler, options]
);
},
drawFeature: function(geometry) {
OpenLayers.Control.DrawFeature.prototype.drawFeature.apply(
this, arguments
);
if (this.layer.features.length == 1) {
// we just draw the startpoint
// note: if we want to apply a special style to the
// start point we should do this here
} else if (this.layer.features.length == 2) {
// we just draw the finalpoint
// note: if we want to apply a special style to the
// final point we should do this here
// we have all what we need; we can deactivate ourself.
this.deactivate();
}
}
});
// create the control to move the points
var drag_points = new OpenLayers.Control.DragFeature(points_layer, {
autoActivate: true
});
<body>
<div id="gxmap"></div>
<div id="method"></div>
</body>
var method = new Ext.form.ComboBox({
renderTo: "method",
triggerAction: "all",
editable: false,
forceSelection: true,
store: [
["SPD", "Shortest Path Dijkstra"],
["SPA", "Shortest Path A*"],
["SPS", "Shortest Path Shooting*"]
]
});
method.setValue("SPD");
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>A Basic GeoExt Page</title>
<script src="ext/libraries/lib/ext/adapter/ext/ext-base.js" type="text/javascript"></script>
<script src="ext/libraries/lib/ext/ext-all.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="ext/libraries/lib/ext/resources/css/ext-all.css" />
<script src="OpenLayers-2.10/lib/OpenLayers.js" type="text/javascript"></script>
<script src="GeoExt/lib/GeoExt.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="GeoExt/resources/css/geoext-all-debug.css" />
<!-- Proj4js ライブラリ -->
<script type="text/javascript" src="proj4js/lib/proj4js/lib/proj4js-compressed.js"></script>
<script type="text/javascript" src="proj4js/lib/proj4js/lib/projCode/tmerc.js"></script>
<script type="text/javascript" src="proj4js/lib/proj4js/lib/defs/EPSG2456.js"></script>
<script type="text/javascript" src="proj4js/lib/proj4js/lib/defs/EPSG900913.js"></script>
<script type="text/javascript">
Ext.onReady(function() {
// 東京都用マップ設定
var map = new OpenLayers.Map('map', {
controls: [
new OpenLayers.Control.PanZoom(),
new OpenLayers.Control.LayerSwitcher(),
new OpenLayers.Control.MousePosition(),
new OpenLayers.Control.ScaleLine()
],
projection: new OpenLayers.Projection("EPSG:2456"),
maxResolution: 'auto',
maxExtent: new OpenLayers.Bounds(-279000,1054000,-185000,1104000),
units: 'meters',
displayProjection: new OpenLayers.Projection("EPSG:4326")
});
var panel = new GeoExt.MapPanel({
renderTo: 'gxmap',
/*
map: {
layers: [new OpenLayers.Layer.OSM("Simple OSM Map")]
},
center: [245300, 5070600],
zoom: 11,
*/
map: map,
layers: [new OpenLayers.Layer.WMS( "Tokyo Height WMS",
"http://192.168.1.141/cgi-bin/mapserv?",
// "http://localhost/cgi-bin/mapserv?",
{
map: '/home/user/mapfile/nippon_bmi_tokyo_pgis2.map',
layers: 'tokyo_tokosen',
format: 'image/png'
}),
new OpenLayers.Layer.WMS( "Tokyo Kukaku Sen WMS",
"http://192.168.1.141/cgi-bin/mapserv?",
// "http://localhost/cgi-bin/mapserv?",
{
map: '/home/user/mapfile/nippon_bmi_tokyo_pgis2.map',
layers: 'tokyo_kukaku',
transparent: true,
format: 'image/png'
}),
new OpenLayers.Layer.WMS( "OpenStreetMap WMS",
"http://192.168.1.141:8080/geoserver/wms?",
{
layers: 'japan_highway',
transparent: true,
format: 'image/png'
},{
projection: new OpenLayers.Projection("EPSG:900913")
})
],
height: 400,
width: 600,
title: 'A Simple GeoExt Map'
});
});
</script>
</head>
<body>
<div id="gxmap"></div>
</body>
</html>
<?php
// Database connection settings
define("PG_DB" , "routing");
define("PG_HOST", "localhost");
define("PG_USER", "postgres");
define("PG_PORT", "5432");
define("TABLE", "ways");
// Retrieve start point
$start = split(' ',$_REQUEST['startpoint']);
$startPoint = array($start[0], $start[1]);
// Retrieve end point
$end = split(' ',$_REQUEST['finalpoint']);
$endPoint = array($end[0], $end[1]);
?>
<?php
// Find the nearest edge
$startEdge = findNearestEdge($startPoint);
$endEdge = findNearestEdge($endPoint);
// FUNCTION findNearestEdge
function findNearestEdge($lonlat) {
// Connect to database
$con = pg_connect("dbname=".PG_DB." host=".PG_HOST." user=".PG_USER);
$sql = "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";
$query = pg_query($con,$sql);
$edge['gid'] = pg_fetch_result($query, 0, 0);
$edge['source'] = pg_fetch_result($query, 0, 1);
$edge['target'] = pg_fetch_result($query, 0, 2);
$edge['the_geom'] = pg_fetch_result($query, 0, 3);
// Close database connection
pg_close($con);
return $edge;
}
?>
<?php
// Select the routing algorithm
switch($_REQUEST['method']) {
case 'SPD' : // Shortest Path Dijkstra
$sql = "SELECT rt.gid, ST_AsGeoJSON(rt.the_geom) AS geojson,
length(rt.the_geom) AS length, ".TABLE.".gid FROM ".TABLE.", (
SELECT gid, the_geom FROM dijkstra_sp_delta(
'".TABLE."',
".$startEdge['source'].",
".$endEdge['target'].",
0.1
)
) as rt WHERE ".TABLE.".gid=rt.gid;";
break;
case 'SPA' : // Shortest Path A*
$sql = "SELECT rt.gid, ST_AsGeoJSON(rt.the_geom) AS geojson,
length(rt.the_geom) AS length, ".TABLE.".gid FROM ".TABLE.", (
SELECT gid, the_geom FROM astar_sp_delta(
'".TABLE."',
".$startEdge['source'].",
".$endEdge['target'].",
0.1
)
) as rt WHERE ".TABLE.".gid=rt.gid;";
break;
case 'SPS' : // Shortest Path Shooting*
$sql = "SELECT rt.gid, ST_AsGeoJSON(rt.the_geom) AS geojson,
length(rt.the_geom) AS length, ".TABLE.".gid FROM ".TABLE.", (
SELECT gid, the_geom FROM shootingstar_sp(
'".TABLE."',
".$startEdge['gid'].",
".$endEdge['gid'].",
0.1, 'length', true, true
)
) as rt WHERE ".TABLE.".gid=rt.gid;";
break;
} // close switch
// Connect to database
$dbcon = pg_connect("dbname=".PG_DB." host=".PG_HOST." user=".PG_USER);
// Perform database query
$query = pg_query($dbcon,$sql);
?>
<?php
// Return route as GeoJSON
$geojson = array(
'type' => 'FeatureCollection',
'features' => array()
);
// Add edges to GeoJSON array
while($edge=pg_fetch_assoc($query)) {
$feature = array(
'type' => 'Feature',
'geometry' => json_decode($edge['geojson'], true),
'crs' => array(
'type' => 'EPSG',
'properties' => array('code' => '4326')
),
'properties' => array(
'id' => $edge['id'],
'length' => $edge['length']
)
);
// Add feature array to feature collection array
array_push($geojson['features'], $feature);
}
// Close database connection
pg_close($dbcon);
// Return routing result
header('Content-type: application/json',true);
echo json_encode($geojson);
?>
id | name
-----+------------
2 | cycleway
1 | highway
4 | junction
3 | tracktype
id | type_id | name | cost
-----+---------+------------------+--------
201 | 2 | lane |
204 | 2 | opposite |
203 | 2 | opposite_lane |
202 | 2 | track |
120 | 1 | bridleway |
116 | 1 | bus_guideway |
121 | 1 | byway |
118 | 1 | cicleway |
119 | 1 | footway |
111 | 1 | living_street |
101 | 1 | motorway |
103 | 1 | motorway_junction|
102 | 1 | motorway_link |
117 | 1 | path |
114 | 1 | pedestrian |
106 | 1 | primary |
107 | 1 | primary_link |
110 | 1 | residential |
100 | 1 | road |
108 | 1 | secondary |
112 | 1 | service |
115 | 1 | services |
122 | 1 | steps |
109 | 1 | tertiary |
113 | 1 | track |
104 | 1 | trunk |
105 | 1 | trunk_link |
100 | 1 | unclassified |
401 | 4 | roundabout |
301 | 3 | grade1 |
302 | 3 | grade2 |
303 | 3 | grade3 |
304 | 3 | grade4 |
305 | 3 | grade5 |
(END):q
routing2=# UPDATE classes SET cost=1;
UPDATE 34
routing2=# UPDATE classes SET cost=2.0 WHERE name IN ('pedestrian','step','footway');
UPDATE 2
routing2=# UPDATE classes SET cost=1.5 WHERE name IN ('cicleway','living_street','path');
UPDATE 3
routing2=# UPDATE classes SET cost=0.8 WHERE name IN ('secondary','tertiary');
UPDATE 2
routing2=# UPDATE classes SET cost=0.6 WHERE name IN ('primary','primary_link');
UPDATE 2
routing2=# UPDATE classes SET cost=0.4 WHERE name IN ('trunk','trunk_link');
UPDATE 2
routing2=# UPDATE classes SET cost=0.3 WHERE name IN ('motorway','motorway_junction','motorway_link');
UPDATE 3
vertex_id | edge_id | cost
-----------+---------+--------------------
8 | 10 | 0.21436682583899
16 | 28 | 0.0616578808755829
18 | 29 | 0.0503517776608
20 | 30 | 0.0322363573642631
22 | 31 | 0.0152758932742916
24 | 383280 | 0.0193755609874666
294 | 207 | 0.14332341972053
76 | 76 | 0.0843040186165352
63 | 67 | 0.157592613117751
65 | 78 | 0.0681030174865841
56 | 62 | 0.118968821186703
57 | 591 | 0.069506289950689
964 | 12984 | 0.0607971743633479
20274 | 380597 | 0.0829580759736785
302 | 214 | 0.0948843293578448
27 | 36 | 0.190297596187546
28 | 1 | 0.680805240753506
(17 行)
vertex_id | edge_id | cost
-----------+---------+--------------------
8 | 10 | 0.21436682583899
16 | 28 | 0.0616578808755829
18 | 29 | 0.0503517776608
20 | 30 | 0.0322363573642631
22 | 31 | 0.0152758932742916
24 | 383280 | 0.0193755609874666
294 | 207 | 0.14332341972053
76 | 76 | 0.0843040186165352
63 | 67 | 0.157592613117751
65 | 78 | 0.0681030174865841
56 | 62 | 0.118968821186703
57 | 591 | 0.069506289950689
964 | 12984 | 0.0607971743633479
20250 | 380597 | 0.0829580759736785
302 | 214 | 0.0948843293578448
27 | 36 | 0.190297596187546
28 | 1 | 0.680805240753506
(17 行)
vertex_id | edge_id | cost
-----------+---------+--------------------
8 | 10 | 0.267958532298737
16 | 28 | 0.0770723510944786
18 | 29 | 0.062939722076
20 | 30 | 0.0402954467053289
22 | 31 | 0.0190948665928645
24 | 109 | 0.116227259387871
136 | 110 | 0.174299630853856
1 | 111 | 0.0382842275772729
139 | 112 | 0.286175933407192
141 | 113 | 0.0520291616070434
145 | 565 | 0.289789710373784
900 | 380609 | 0.76797799806671
187 | 380608 | 0.735939901886778
303 | 215 | 0.226197723036394
27 | 36 | 0.634325320625154
28 | 1 | 2.26935080251169
(16 行)
gid | the_geom
--------+----------------------------------------------------------------------------------------
10 | MULTILINESTRING((139.7576138 35.6405785,139.757642 35.6429882))
28 | MULTILINESTRING((139.757642 35.6429882,139.7567891 35.6429914))
29 | MULTILINESTRING((139.7567891 35.6429914,139.7560926 35.642988))
30 | MULTILINESTRING((139.7560926 35.642988,139.7556467 35.6429917))
31 | MULTILINESTRING((139.7556467 35.6429917,139.7554354 35.6429934))
109 | MULTILINESTRING((139.7554354 35.6429934,139.7549489 35.6420258))
110 | MULTILINESTRING((139.7549489 35.6420258,139.7542037 35.64058))
111 | MULTILINESTRING((139.7542037 35.64058,139.7540437 35.6402612))
112 | MULTILINESTRING((139.7540437 35.6402612,139.7535339 35.6392546,139.7528491 35.6378777))
113 | MULTILINESTRING((139.7528491 35.6378777,139.7526395 35.6374419))
(stdin):q
vertex_id | edge_id | cost
-----------+---------+--------------------
10 | 8 | 0.346119164295792
9 | 23 | 0.0146912365339526
11 | 22 | 0.075644096442472
22 | 21 | 0.0618382434046277
21 | 20 | 0.0915961112943772
20 | 19 | 0.0790971710844567
19 | 111 | 0.0382842275772729
96 | 112 | 0.286175933407192
97 | 113 | 0.0520291616070434
100 | 565 | 0.289789710373784
490 | 380609 | 0.76797799806671
123 | 380608 | 0.735939901886778
186 | 215 | 0.226197723036394
30 | 36 | 0.634325320625154
1 | -1 | 0
(15 行)
gid | the_geom
--------+----------------------------------------------------------------------------------------------------------------
8 | MULTILINESTRING((139.7577762 35.6405846,139.7602379 35.6429693))
23 | MULTILINESTRING((139.7576138 35.6405785,139.7577762 35.6405846))
22 | MULTILINESTRING((139.7567768 35.6405692,139.7576138 35.6405785))
21 | MULTILINESTRING((139.7560925 35.6405677,139.7567768 35.6405692))
20 | MULTILINESTRING((139.7550789 35.6405698,139.7560925 35.6405677))
19 | MULTILINESTRING((139.7542037 35.64058,139.7543194 35.6405713,139.7550789 35.6405698))
111 | MULTILINESTRING((139.7542037 35.64058,139.7540437 35.6402612))
112 | MULTILINESTRING((139.7540437 35.6402612,139.7535339 35.6392546,139.7528491 35.6378777))
113 | MULTILINESTRING((139.7528491 35.6378777,139.7526395 35.6374419))
565 | MULTILINESTRING((139.7526395 35.6374419,139.75219 35.6368954,139.7517603 35.6360734,139.7513313 35.6350625))
380609 | MULTILINESTRING((139.7545699 35.6414479,139.7542355 35.6407687,139.7528655 35.6380556,139.7518411 35.6360552,139.7513313 35.6350625))
(stdin):q
vertex_id | edge_id | cost
-----------+---------+--------------------
10 | 8 | 0.346119164295792
9 | 23 | 0.0146912365339526
11 | 22 | 0.075644096442472
22 | 21 | 0.0618382434046277
21 | 20 | 0.0915961112943772
20 | 19 | 0.0790971710844567
19 | 111 | 0.0382842275772729
96 | 112 | 0.286175933407192
97 | 113 | 0.0520291616070434
100 | 565 | 0.289789710373784
490 | 380609 | 0.76797799806671
123 | 380608 | 0.735939901886778
186 | 215 | 0.226197723036394
30 | 36 | 0.634325320625154
1 | -1 | 0
(15 行)
gid | the_geom
--------+----------------------------------------------------------------------------------------------------------------------
8 | MULTILINESTRING((139.7577762 35.6405846,139.7602379 35.6429693))
23 | MULTILINESTRING((139.7576138 35.6405785,139.7577762 35.6405846))
22 | MULTILINESTRING((139.7567768 35.6405692,139.7576138 35.6405785))
21 | MULTILINESTRING((139.7560925 35.6405677,139.7567768 35.6405692))
20 | MULTILINESTRING((139.7550789 35.6405698,139.7560925 35.6405677))
19 | MULTILINESTRING((139.7542037 35.64058,139.7543194 35.6405713,139.7550789 35.6405698))
111 | MULTILINESTRING((139.7542037 35.64058,139.7540437 35.6402612))
112 | MULTILINESTRING((139.7540437 35.6402612,139.7535339 35.6392546,139.7528491 35.6378777))
113 | MULTILINESTRING((139.7528491 35.6378777,139.7526395 35.6374419))
565 | MULTILINESTRING((139.7526395 35.6374419,139.75219 35.6368954,139.7517603 35.6360734,139.7513313 35.6350625))
380609 | MULTILINESTRING((139.7545699 35.6414479,139.7542355 35.6407687,139.75286 55 35.6380556,139.7518411 35.6360552,139.7513313 35.6350625))
380608 | MULTILINESTRING((139.7576194 35.6475849,139.7568929 35.6461283,139.755837 35.6439893,139.7545699 35.6414479))
215 | MULTILINESTRING((139.7585756 35.6494649,139.7576194 35.6475849))
36 | MULTILINESTRING((139.7585756 35.6494649,139.7576702 35.6475689,139.7573095 35.6468001,139.7572599 35.6465017,139.7572966 35.646252,139.7573598 35.6460477,139.7577062 35.6453051,139.7577759 35.6451083,139.7578078 35.6449769,139.757837 35.6448058,139.7578311 35.6446378,139.7578 35.6437952))
(14 行)
gid | the_geom
--------+-------------------------------------------------------------------------------------------------------------------
8 | MULTILINESTRING((139.7577762 35.6405846,139.7602379 35.6429693))
23 | MULTILINESTRING((139.7576138 35.6405785,139.7577762 35.6405846))
22 | MULTILINESTRING((139.7567768 35.6405692,139.7576138 35.6405785))
21 | MULTILINESTRING((139.7560925 35.6405677,139.7567768 35.6405692))
20 | MULTILINESTRING((139.7550789 35.6405698,139.7560925 35.6405677))
19 | MULTILINESTRING((139.7542037 35.64058,139.7543194 35.6405713,139.7550789 35.6405698))
111 | MULTILINESTRING((139.7542037 35.64058,139.7540437 35.6402612))
112 | MULTILINESTRING((139.7540437 35.6402612,139.7535339 35.6392546,139.7528491 35.6378777))
113 | MULTILINESTRING((139.7528491 35.6378777,139.7526395 35.6374419))
565 | MULTILINESTRING((139.7526395 35.6374419,139.75219 35.6368954,139.7517603 35.6360734,139.7513313 35.6350625))
380609 | MULTILINESTRING((139.7545699 35.6414479,139.7542355 35.6407687,139.7528655 35.6380556,139.7518411 35.6360552,139.7513313 35.6350625))
380608 | MULTILINESTRING((139.7576194 35.6475849,139.7568929 35.6461283,139.755837 35.6439893,139.7545699 35.6414479))
36 | MULTILINESTRING((139.7585756 35.6494649,139.7576702 35.6475689,139.7573095 35.6468001,139.7572599 35.6465017,139.7572966 35.646252,139.7573598 35.6460477,139.7577062 35.6453051,139.7577759 35.6451083,139.7578078 35.6449769,139.757837 35.6448058,139.7578311 35.6446378,139.7578 35.6437952))
(14 行)
<?xml version='1.0' encoding='UTF-8'?>
<osm version="0.6" generator="Osmosis 0.36">
<node id="26155122" version="2" timestamp="2008-02-27T22:48:02Z" uid="19799" user="daveemtb" changeset="219539" lat="26.1716092" lon="127.9096729">
<tag k="created_by" v="JOSM"/>
</node>
<node id="26155133" version="2" timestamp="2008-02-27T22:48:02Z" uid="19799" user="daveemtb" changeset="219539" lat="26.1679759" lon="127.9060651">
---
<way id="32742015" version="1" timestamp="2009-04-02T04:56:03Z" uid="24685" user="tosihisa" changeset="54083">
<nd ref="368385006"/>
<nd ref="368385008"/>
<tag k="created_by" v="Merkaartor 0.12"/>
<tag k="highway" v="trunk"/>
<tag k="name" v="国道１号線(Route 1)"/>
<tag k="oneway" v="yes"/>
<tag k="ref" v="1"/>
<tag k="tunnel" v="yes"/>
</way>
---
<relation id="1437868" version="1" timestamp="2011-02-20T16:06:16Z" uid="129607" user="Mage Whopper" changeset="7344209">
<member type="way" ref="100653311" role="inner"/>
<member type="way" ref="100653309" role="outer"/>
<tag k="type" v="multipolygon"/>
</relation>
</osm>
リレーションの一覧
スキーマ | 名前 | 型 | 所有者
----------+---------------------+------------+----------
public | classes | テーブル | postgres
public | geography_columns | ビュー | postgres
public | geometry_columns | テーブル | postgres
public | nodes | テーブル | postgres
public | relation_ways | テーブル | postgres
public | relations | テーブル | postgres
public | spatial_ref_sys | テーブル | postgres
public | types | テーブル | postgres
public | vertices_tmp | テーブル | postgres
public | vertices_tmp_id_seq | シーケンス | postgres
public | way_tag | テーブル | postgres
public | ways | テーブル | postgres
(12 行)
テーブル "public.ways"
カラム | 型 | 修飾語
--------------+------------------+----------
gid | integer |
class_id | integer | not null
length | double precision |
name | character(200) |
x1 | double precision |
y1 | double precision |
x2 | double precision |
y2 | double precision |
reverse_cost | double precision |
rule | text |
to_cost | double precision |
osm_id | integer |
the_geom | geometry |
source | integer |
target | integer |
インデックス:
"ways_gid_idx" UNIQUE, btree (gid)
"geom_idx" gist (the_geom)
"source_idx" btree (source)
"target_idx" btree (target)
CHECK 制約:
"enforce_dims_the_geom" CHECK (st_ndims(the_geom) = 2)
"enforce_geotype_the_geom" CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL)
"enforce_srid_the_geom" CHECK (st_srid(the_geom) = 4326)
CMake Warning (dev) at CMakeLists.txt:12 (add_subdirectory):
The source directory
/home/user/ダウンロード/pgrouting-1.05/cmake
does not contain a CMakeLists.txt file.
CMake does not support this case but it used to work accidentally and is
being allowed for compatibility.
Policy CMP0014 is not set: Input directories must have CMakeLists.txt. Run
"cmake --help-policy CMP0014" for policy details. Use the cmake_policy
command to set the policy and suppress this warning.
This warning is for project developers. Use -Wno-dev to suppress it.
-- PostgreSQL not found.
FATALERROR Please check your PostgreSQL installation.
Boost headers were found here: /usr/include
Output directory for libraries is set to sh: pg_config: not found
Installation directory for libraries is set to sh: pg_config: not found and for SQL files is set to /usr/share/postlbs
Installation directory for libraries is set to sh: pg_config: not found
CMake Error: The following variables are used in this project, but they are set to NOTFOUND.
Please set them or make sure they are set and tested correctly in the CMake files:
POSTGRESQL_INCLUDE_DIR (ADVANCED)
user@deb6-vmw:~ダウンロード/pgrouting-1.05$ cmake --help-policy CMP0014
cmake version 2.8.2
CMP0014
Input directories must have CMakeLists.txt.
CMake versions before 2.8 silently ignored missing CMakeLists.txt
files in directories referenced by add_subdirectory() or subdirs(),
treating them as if present but empty. In CMake 2.8.0 and above this
policy determines whether or not the case is an error. The OLD
behavior for this policy is to silently ignore the problem. The NEW
behavior for this policy is to report an error.
This policy was introduced in CMake version 2.8.0. CMake version
2.8.2 warns when the policy is not set and uses OLD behavior. Use the
cmake_policy command to set it to OLD or NEW explicitly.
user@deb6-vmw:~/pgrouting-1.05$ make
Scanning dependencies of target routing_tsp
[ 8%] Building C object extra/tsp/src/CMakeFiles/routing_tsp.dir/tsp.o
[ 16%] Building CXX object extra/tsp/src/CMakeFiles/routing_tsp.dir/tsp_solver.o
Linking CXX shared library ../../../lib/librouting_tsp.so
[ 16%] Built target routing_tsp
Scanning dependencies of target routing_dd
[ 25%] Building C object extra/driving_distance/src/CMakeFiles/routing_dd.dir/alpha.o
[ 33%] Building CXX object extra/driving_distance/src/CMakeFiles/routing_dd.dir/alpha_drivedist.o
[ 41%] Building CXX object extra/driving_distance/src/CMakeFiles/routing_dd.dir/boost_drivedist.o
In file included from /usr/include/c++/4.4/backward/hash_set:60,
from /usr/include/boost/pending/container_traits.hpp:23,
from /usr/include/boost/graph/detail/adjacency_list.hpp:31,
from /usr/include/boost/graph/adjacency_list.hpp:324,
from /home/user/pgrouting-1.05/extra/driving_distance/src/boost_drivedist.cpp:25:
/usr/include/c++/4.4/backward/backward_warning.h:28:2: warning: #warning This file includes at least one deprecated or antiquated header which may be removed without further notice at a future date. Please use a non-deprecated interface with equivalent functionality instead. For a listing of replacement headers and interfaces, consult the file backward_warning.h. To disable this warning use -Wno-deprecated.
[ 50%] Building C object extra/driving_distance/src/CMakeFiles/routing_dd.dir/drivedist.o
Linking CXX shared library ../../../lib/librouting_dd.so
[ 50%] Built target routing_dd
Scanning dependencies of target routing
[ 58%] Building C object core/src/CMakeFiles/routing.dir/dijkstra.o
[ 66%] Building C object core/src/CMakeFiles/routing.dir/astar.o
[ 75%] Building C object core/src/CMakeFiles/routing.dir/shooting_star.o
[ 83%] Building CXX object core/src/CMakeFiles/routing.dir/boost_wrapper.o
In file included from /usr/include/c++/4.4/backward/hash_set:60,
from /usr/include/boost/pending/container_traits.hpp:23,
from /usr/include/boost/graph/detail/adjacency_list.hpp:31,
from /usr/include/boost/graph/adjacency_list.hpp:324,
from /home/user/pgrouting-1.05/core/src/boost_wrapper.cpp:25:
/usr/include/c++/4.4/backward/backward_warning.h:28:2: warning: #warning This file includes at least one deprecated or antiquated header which may be removed without further notice at a future date. Please use a non-deprecated interface with equivalent functionality instead. For a listing of replacement headers and interfaces, consult the file backward_warning.h. To disable this warning use -Wno-deprecated.
[ 91%] Building CXX object core/src/CMakeFiles/routing.dir/astar_boost_wrapper.o
In file included from /usr/include/c++/4.4/backward/hash_set:60,
from /usr/include/boost/pending/container_traits.hpp:23,
from /usr/include/boost/graph/detail/adjacency_list.hpp:31,
from /usr/include/boost/graph/adjacency_list.hpp:324,
from /home/user/pgrouting-1.05/core/src/astar_boost_wrapper.cpp:25:
/usr/include/c++/4.4/backward/backward_warning.h:28:2: warning: #warning This file includes at least one deprecated or antiquated header which may be removed without further notice at a future date. Please use a non-deprecated interface with equivalent functionality instead. For a listing of replacement headers and interfaces, consult the file backward_warning.h. To disable this warning use -Wno-deprecated.
[100%] Building CXX object core/src/CMakeFiles/routing.dir/shooting_star_boost_wrapper.o
In file included from /usr/include/c++/4.4/backward/hash_set:60,
from /usr/include/boost/pending/container_traits.hpp:23,
from /usr/include/boost/graph/detail/adjacency_list.hpp:31,
from /usr/include/boost/graph/adjacency_list.hpp:324,
from /home/user/pgrouting-1.05/core/src/shooting_star_boost_wrapper.cpp:25:
/usr/include/c++/4.4/backward/backward_warning.h:28:2: warning: #warning This file includes at least one deprecated or antiquated header which may be removed without further notice at a future date. Please use a non-deprecated interface with equivalent functionality instead. For a listing of replacement headers and interfaces, consult the file backward_warning.h. To disable this warning use -Wno-deprecated.
/home/user/pgrouting-1.05/core/src/shooting_star_boost_wrapper.cpp:26:41: error: boost/vector_property_map.hpp: そのようなファイルやディレクトリはありません
In file included from /home/user/pgrouting-1.05/core/src/shooting_star_search.hpp:22,
from /home/user/pgrouting-1.05/core/src/shooting_star_boost_wrapper.cpp:27:
/home/user/pgrouting-1.05/core/src/shooting_star_relax.hpp:18:34: error: boost/property_map.hpp: そのようなファイルやディレクトリはありません
In file included from /home/user/pgrouting-1.05/core/src/edge_visitors.hpp:9,
from /home/user/pgrouting-1.05/core/src/shooting_star_search.hpp:28,
from /home/user/pgrouting-1.05/core/src/shooting_star_boost_wrapper.cpp:27:
/usr/include/boost/graph/detail/is_same.hpp:17:4: warning: #warning "This header is deprecated. Please use: boost/type_traits/is_same.hpp"
make[2]: *** [core/src/CMakeFiles/routing.dir/shooting_star_boost_wrapper.o] エラー 1
make[1]: *** [core/src/CMakeFiles/routing.dir/all] エラー 2
make: *** [all] エラー 2
---
GAUL has been configured successfully. In summary:
Version: 0.1850-0
Source code location: .
Host system type: x86_64-unknown-linux-gnu
Target system type: x86_64-unknown-linux-gnu
Debugging level: 0
C compiler: gcc
C compiler flags: -g -O2 -Wall
Additional include flags:
Install path: /usr/local
Use S-Lang: no
Use MPI: no
Use OPENMP: no
Use pthreads: yes
---
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE ServiceExceptionReport SYSTEM "http://localhost:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1" >
<ServiceException>
The requested Style can not be used with this layer. The style specifies an attribute of aeroway and the layer is: npn:japan_highway
</ServiceException></ServiceExceptionReport>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE ServiceExceptionReport SYSTEM "http://localhost:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1" >
<ServiceException>
The requested Style can not be used with this layer. The style specifies an attribute of highway and the layer is: npn:japan_highway
</ServiceException></ServiceExceptionReport>
---
<NamedLayer>
<Name>npn:japan_highway</Name> <-1
<UserStyle>
<Title>A boring default style</Title>
<Abstract>A sample style that just prints out a green line</Abstract>
<!-- start of zoom level 3 -->
<FeatureTypeStyle>
<Rule>
<Name>npn:japan_highway</Name> <-2
<Title>freeways- outer zoom level</Title>
<Abstract>freeways style openstreetmap data</Abstract>
<ogc:Filter>
<ogc:Or>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>type</ogc:PropertyName> <-3
<ogc:Literal>residential</ogc:Literal>
</ogc:PropertyIsEqualTo>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>type</ogc:PropertyName> <-3
<ogc:Literal>unclassified</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:Or>
</ogc:Filter>
<MinScaleDenominator>1000</MinScaleDenominator>
<MaxScaleDenominator>4000</MaxScaleDenominator>
<LineSymbolizer>
<Stroke>
<CssParameter name="stroke">#f4faf6</CssParameter>
<CssParameter name="stroke-width">12</CssParameter>
<CssParameter name="stroke-linejoin">round</CssParameter>
</Stroke>
</LineSymbolizer>
<TextSymbolizer>
<Label>
<ogc:PropertyName>name</ogc:PropertyName>
</Label>
<Font>
<CssParameter name="font-size">10</CssParameter>
<CssParameter name="font-family">Arial</CssParameter>
<CssParameter name="font-color">#eeeeee</CssParameter>
</Font>
<LabelPlacement>
<LinePlacement>
<PerpendicularOffset>
0
</PerpendicularOffset>
</LinePlacement>
</LabelPlacement>
<Halo>
<Radius>
<ogc:Literal>1</ogc:Literal>
</Radius>
<Fill>
<CssParameter name="fill">#f4faf6</CssParameter>
</Fill>
</Halo>
<Fill>
<CssParameter name="fill">#808080</CssParameter>
</Fill>
<VendorOption name="maxDisplacement">50</VendorOption>
<VendorOption name="labelAllGroup">true</VendorOption>
<VendorOption name="removeOverlaps">true</VendorOption>
<VendorOption name="followLine">true</VendorOption>
<VendorOption name="group">true</VendorOption>
</TextSymbolizer>
</Rule>
</FeatureTypeStyle>
---
リレーションの一覧
スキーマ | 名前 | 型 | 所有者
----------+------------------+----------+--------
public | geometry_columns | テーブル | user
public | japan_highway | テーブル | user
public | japan_natural | テーブル | user
public | japan_poi | テーブル | user
public | spatial_ref_sys | テーブル | user
(5 行)
type
--------------------------
unclassified
footway
motorway
proposed
residential;unclassified
raceway
motorway_link
steps
pedestrian
bridleway
primary_link
crossing
platform
services
motorway_junction
service
trunk_link
cycleway
byway
bus_guideway
runaway_truck_lane
living_street
plathome
path
residential
slope
road
rest_area
construction
residential;tertiary
minor
primary
secondary
track
sericve
escalator
tertiary
trunk
tertiary_link
unclassificed
secondary_link
bridge
(43 行)
(END):q
---
<FeatureTypeStyle>
<Rule>
<Name>topp:planet_osm_line</Name>
<Title>freeways- outer zoom level</Title>
<Abstract>freeways style openstreetmap data</Abstract>
<ogc:Filter>
<ogc:Or>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>highway</ogc:PropertyName>
<ogc:Literal>residential</ogc:Literal>
</ogc:PropertyIsEqualTo>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>highway</ogc:PropertyName>
<ogc:Literal>unclassified</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:Or>
</ogc:Filter>
<!-- Min および MaxScaleDenominator を LineSymbolizer の直前に Property(type) によって値が違うので一つずつ修正してください -->
<MinScaleDenominator>1000</MinScaleDenominator>
<MaxScaleDenominator>4000</MaxScaleDenominator>
<!-- ここまで -->
<LineSymbolizer>
<Stroke>
<CssParameter name="stroke">#f4faf6</CssParameter>
<CssParameter name="stroke-width">12</CssParameter>
<CssParameter name="stroke-linejoin">round</CssParameter>
</Stroke>
</LineSymbolizer>
<TextSymbolizer>
<Label>
<ogc:PropertyName>name</ogc:PropertyName>
</Label>
<Font>
<CssParameter name="font-size">10</CssParameter>
<CssParameter name="font-family">Arial</CssParameter>
<CssParameter name="font-color">#eeeeee</CssParameter>
</Font>
<LabelPlacement>
<LinePlacement>
<PerpendicularOffset>
0
</PerpendicularOffset>
</LinePlacement>
</LabelPlacement>
<Halo>
<Radius>
<ogc:Literal>1</ogc:Literal>
</Radius>
<Fill>
<CssParameter name="fill">#f4faf6</CssParameter>
</Fill>
</Halo>
<Fill>
<CssParameter name="fill">#808080</CssParameter>
</Fill>
<!-- VendorOption を TextSymbolizer 終了タグの直前にに -->
<VendorOption name="maxDisplacement">50</VendorOption>
<VendorOption name="labelAllGroup">true</VendorOption>
<VendorOption name="removeOverlaps">true</VendorOption>
<VendorOption name="followLine">true</VendorOption>
<VendorOption name="group">true</VendorOption>
<!-- ここまで -->
</TextSymbolizer>
</Rule>
</FeatureTypeStyle>
---
user@deb-vmw:~/ダウンロード$ mkdir japan_shapefiles
user@deb-vmw:~/ダウンロード$ mv japan.shapefiles.zip japan_shapefiles/
user@deb-vmw:~/ダウンロード$ cd japan_shapefiles/
user@deb-vmw:~/ダウンロード/japan_shapefiles$ ls
japan.shapefiles.zip
user@deb-vm:~/ダウンロード/japan_shapefiles$ unzip japan.shapefiles.zip
Archive: japan.shapefiles.zip
inflating: japan_natural.dbf
inflating: japan_administrative.dbf
inflating: japan_water.prj
inflating: japan_highway.prj
inflating: japan_coastline.shx
inflating: japan_location.prj
inflating: japan_poi.shp
inflating: japan_administrative.shx
inflating: japan_coastline.dbf
inflating: japan_water.dbf
inflating: japan_natural.prj
inflating: readme.txt
inflating: japan_poi.shx
inflating: japan_administrative.shp
inflating: japan_coastline.shp
inflating: japan_water.shp
inflating: japan_poi.prj
inflating: japan_highway.shx
inflating: japan_coastline.prj
inflating: japan_water.shx
inflating: japan_poi.dbf
inflating: japan_location.shx
inflating: japan_location.dbf
inflating: japan_administrative.prj
inflating: japan_highway.shp
inflating: japan_natural.shp
inflating: japan_natural.shx
inflating: japan_highway.dbf
inflating: japan_location.shp
データベース一覧
名前 | 所有者 | エンコーディング | 照合順序 | Ctype(変換演算子) | アクセス権
------------------+----------+------------------+-------------+-------------------+-----------------------
nippon_bmi | user | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 |
nippon_dnli | user | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 |
osm | user | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 |
postgres | postgres | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 |
template0 | postgres | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 | =c/postgres
: postgres=CTc/postgres
template1 | postgres | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 | =c/postgres
: postgres=CTc/postgres
template_postgis | postgres | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 |
(stdin):q
リレーションの一覧
スキーマ | 名前 | 型 | 所有者
----------+-------------------+----------+----------
public | geography_columns | ビュー | postgres
public | geometry_columns | テーブル | postgres
public | spatial_ref_sys | テーブル | postgres
(3 行)
リレーションの一覧
スキーマ | 名前 | 型 | 所有者
----------+-------------------+----------+----------
public | geography_columns | ビュー | postgres
public | geometry_columns | テーブル | user
public | spatial_ref_sys | テーブル | user
(3 行)
postgres@deb-vmw:~$ exit
logout
user@deb6-vmw:~$ cd ダウンロード/japan_shapefiles
user@deb6-vmw:~/ダウンロード/japan_shapefiles$ shp2pgsql japan_highway japan_highway > japan_highway.sql
Shapefile type: Arc
Postgis type: MULTILINESTRING[2]
Unable to convert field value "南牧場線" to UTF-8: iconv reports "Invalid or incomplete multibyte or wide character"
user@deb6-vmw:~/ダウンロード/japan_shapefiles$ shp2pgsql -W utf-8 japan_highway japan_highway > japan_highway.sql
Shapefile type: Arc
Postgis type: MULTILINESTRING[2]
user@deb6-vmw:~/Download/japan_shapefiles$ psql -d osm -f japan_highway.sql
List of relations
Schema | Name | Type | Owner
--------+------------------+-------+-------
public | geometry_columns | table | user
public | japan_highway | table | user
public | spatial_ref_sys | table | user
(3 rows)
テーブル "public.japan_highway"
カラム | 型 | 修飾語
----------+------------------------+----------------------------------------------------------------
gid | integer | not null デフォルト nextval('japan_highway_
gid_seq'::regclass) type | character varying(24) |
name | character varying(133) |
oneway | character varying(11) |
lanes | numeric(11,0) |
the_geom | geometry |
インデックス:
"japan_highway_pkey" PRIMARY KEY, btree (gid)CHECK 制約:
"enforce_dims_the_geom" CHECK (st_ndims(the_geom) = 2)
"enforce_geotype_the_geom" CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL)
"enforce_srid_the_geom" CHECK (st_srid(the_geom) = (-1))
~
(stdin):q
