直接从postgis使用github gist api作为geojson或topojson创建地图。
pgsql2gist的Python项目详细描述
直接从postgis使用github gist api作为geojson或topojson创建地图。
开发分支
大师级
目标
创建一个类似于pgsql2shp的命令行实用程序,但其输出应该是 一个匿名私人主旨的链接。gist链接应该利用github的 呈现geojson/topojson,例如呈现地图。
有关要实现的其他功能,请参见问题。
当前使用/注意事项
下面列出了–帮助用法信息。
POST GeoJSON or TopoJSON features from PostGIS to a Github Gist. Example usage: pgsql2gist --host localhost --user matt tilestache \ "SELECT name, ST_AsGeoJSON(geom) AS geometry FROM neighborhoods LIMIT 5;" Current SELECT Statement Requirements: - Geometry must be in EPSG:4326 WGS84 coordinate system - Geometry must be wrapped in ST_AsGeoJSON(), ST_AsTopoJSON() usage: pgsql2gist [-f FILE] [-d DESCRIPTION] [-h HOST] [-p PORT] [-P PASSWORD] [-u USER] [-g GEOM_COL] [-t TOPOLOGY_LAYER] [-v] [-?] database SELECT positional arguments: database PostGIS database name. SELECT SELECT Statement. NOTE: Geometry must be WGS84; wrapped in ST_AsGeoJSON() or AsTopoJSON(). optional arguments: -f FILE, --file FILE Filename. NOTE: Must end in 'geojson' or 'topojson' extension. (default: upload.geojson) -d DESCRIPTION, --description DESCRIPTION Description of upload (default: File uploaded using pgsql2gist.) -h HOST, --host HOST PostGIS database hostname. (default: None) -p PORT, --port PORT PostGIS database port. (default: 5432) -P PASSWORD, --password PASSWORD PostGIS user password. (default: None) -u USER, --user USER PostGIS database user. (default: postgres) -g GEOM_COL, --geom-col GEOM_COL Geometry column name as defined in SELECT statement. (default: geometry) -t TOPOLOGY_LAYER, --topology-layer TOPOLOGY_LAYER For TopoJSON Queries; Name of Topology Layer (default: None) -v, --verbose Verbose output. (default: False) -?, --help
资源
gist api:(http://developer.github.com/v3/gists/)
谢谢
db上下文管理器背后的spiffy思想来自migurski的awesome tilestache 地图服务器。http://tilestache.org