手机版
你好,游客 登录 注册
背景:
阅读新闻

PostGIS常见的空间数据的导入导出

[日期:2012-08-09] 来源:Linux社区  作者:cnhome [字体: ]

本片文章简单记录了PostGIS涉及的常用数据导入导出的使用方法。

1.将osm数据导入PostGIS

osm2pgsql -c -d osm -l -E 4326 -S /usr/share/osm2pgsql/default.style xxxxx.osm


这里要注意几个参数,是选用-c还是-a要看你的应用方式,-S这个是在Ubuntu下路径不同时使用,espg可以不用再使用900913了。自然要使得数据库采用UTF8编码最好。

osm2pgsql SVN version 0.70.5
Usage:
osm2pgsql [options] planet.osm
osm2pgsql [options] planet.osm.{gz,bz2}
osm2pgsql [options] file1.osm file2.osm file3.osm


This will import the data from the OSM file(s) into a PostgreSQL database
suitable for use by the Mapnik renderer


Options:
   -a|--append Add the OSM file into the database without removing
              existing data.
   -b|--bbox Apply a bounding box filter on the imported data
              Must be specified as: minlon,minlat,maxlon,maxlat
              e.g. --bbox -0.5,51.25,0.5,51.75
   -c|--create Remove existing data from the database. This is the
              default if --append is not specified.
   -d|--database The name of the PostgreSQL database to connect
                to (default: gis).
   -i|--tablespace-index The name of the PostgreSQL tablespace where indexes will be create
                to (default: pg_default).
   -l|--latlong Store data in degrees of latitude & longitude.
   -m|--merc Store data in proper spherical mercator (default)
   -M|--oldmerc Store data in the legacy OSM mercator format
   -E|--proj num Use projection EPSG:num
   -u|--utf8-sanitize Repair bad UTF8 input data (present in planet
                dumps prior to August 2007). Adds about 10% overhead.
   -p|--prefix Prefix for table names (default planet_osm)
   -s|--slim Store temporary data in the database. This greatly
            reduces the RAM usage but is much slower.
   -S|--style Location of the style file. Defaults to /usr/share/default.style
   -C|--cache Only for slim mode: Use upto this many MB for caching nodes
              Default is 800
   -U|--username Postgresql user name.
   -W|--password Force password prompt.
   -H|--host Database server hostname or socket location.
   -P|--port Database server port.
   -e|--expire-tiles [min_zoom-]max_zoom Create a tile expiry list.
   -o|--expire-output filename Output filename for expired tiles list.
   -r|--input-reader Input frontend.
              libxml2   - Parse XML using libxml2. (default)
              primitive - Primitive XML parsing.
   -O|--output Output backend.
              pgsql - Output to a PostGIS database. (default)
              gazetteer - Output to a PostGIS database suitable for gazetteer
              null  - No output. Useful for testing.
   -x|--extra-attributes
              Include attributes for each object in the database.
              This includes the username, userid, timestamp and version.
              Note: this option also requires additional entries in your style file.
   -k|--hstore Generate an additional hstore (key/value) column to  postgresql tables
   -z|--hstore-column Generate an additional hstore (key/value) column to containing all tags
                      that start with the specified string, eg --hstore-column "name:" will
                      produce an extra hstore column that contains all name:xx tags
   -G|--multi-geometry Generate multi-geometry features in postgresql tables.
   -K|--keep-coastlines Keep coastline data rather than filtering it out.
              By default natural=coastline tagged data will be discarded based on the
              assumption that post-processed Coastline Checker shapefiles will be used.
   -h|--help Help information.
   -v|--verbose Verbose output.


Add -v to display supported projections.
Use -E to access any espg projections (usually in /usr/share/proj/epsg)

linux
相关资讯       PostGIS 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款