osm2pgsql -s -d simple -U postgres -H localhost -S default.style E:\SzgcSj2016\osmosis-latest\bin\Wuhan.pbf --prefix wuhan -W

SELECT osm_id,edge_id, (dp).path[1] As
index, ST_AsText((dp).geom) As wktnode from
(
select osm_id,row_number() over() as
edge_id,ST_DumpPoints(way) as dp from
wuhan_roads limit 100)x
//将geometry的空间参考改为4326（因为默认为900913）
ALTER TABLE wuhan_roads ALTER
COLUMN way TYPE
geometry(LineString,4326) USING
ST_Transform(way,4326);
ALTER TABLE wuhan_line ALTER
COLUMN way TYPE
geometry(LineString,4326) USING
ST_Transform(way,4326);
ALTER TABLE wuhan_point ALTER
COLUMN way TYPE geometry(Point,4326)
USING ST_Transform(way,4326);
//给表格wuhan_polygon添加属性way2 geometry
ALTER TABLE wuhan_polygon ADD COLUMN way2
geometry;

//给表格wuhan_polygon的属性way2 geometry添加格式：(way,4326)
update wuhan_polygon SET way2=ST_Transform(way,4326);

//删除表格wuhan_polygon的属性way
ALTER TABLE wuhan_polygon DROP COLUMN way;

//给表格wuhan_polygon的属性way2改民为way
ALTER TABLE wuhan_polygon RENAME way2 TO way;

#wuhanpolygon {
  ::outline {
    line-color: #3c22d6;
    line-width: 2;
    line-join: round;
  }
  polygon-fill: #03b6ad;
}
host=localhost port=5432 user=postgres password=root dbname=simple
#wuhanroads {
  ::outline {
    line-color: #3c22d6;
    line-width: 2;
    line-join: round;
  }
  polygon-fill: #03b6ad;
}

#wuhanpoint {
  marker-width:6;
  marker-fill:#8b9091; //f45
  marker-line-color:#813;
  marker-allow-overlap:true;
}