瓦片地图与geoserver发布

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;