Skip to content
A mapnik datasource for SQL Server
C++ Makefile
Branch: master
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
mssql rename `empty_featureset` => `invalid_featureset` to avoid ambiguity Oct 25, 2016
msvc
test fix parameter type in test Oct 26, 2016
.gitignore change mapnik sdk path and x64 version May 12, 2015
.travis.yml Fix travis-ci and update mapnik Jan 31, 2018
COPYING.txt more cleanup Jan 5, 2015
Makefile travis.yml Jun 18, 2016
README.md travis.yml Jun 18, 2016
appveyor.yml Fix travis-ci and update mapnik Jan 31, 2018

README.md

mapnik-mssql

Build status Build Status

A mapnik datasource plugin for Microsoft Sql Server 2012/2014/2016. Based on the PostGIS plugin.

Parameters

parameter value description default
connection_string string An odbc connection string. If empty, the parameters "driver", "host", "port", "dbname", "user", "password," and "connect_timeout" will be used.
driver string name of the odbc driver SQL Server Native Client 11.0
host string host or host\instance
port integer used only when there is no instance in server (default 1433)
dbname string name of the database
user string username to use for connecting
password string user password to use for connecting
connect_timeout integer timeout is seconds for the connection to take place 4
persist_connection boolean choose whether to share the same connection for subsequent queries true
table string name of the table to fetch, this can be a sub-query; subquery has to use syntax of: '( ) as table'.
geometry_field string name of the geometry field, in case you have more than one in a single table. This field and the SRID will be deduced from the query in most cases, but may need to be manually specified in some cases.
geometry_table string name of the table containing the returned geometry; for determining RIDs with subselects
srid integer srid of the table, if this is > 0 then fetching data will avoid an extra database query for knowing the srid of the table 0
extent string maxextent of the geometries determined by querying the metadata for the table
extent_from_subquery boolean evaluate the extent of the subquery, this might be a performance issue false
row_limit integer max number of rows to return when querying data, 0 means no limit 0
initial_size integer initial size of the stateless connection pool 1
max_size integer max size of the stateless connection pool 10
simplify_geometries boolean whether to automatically reduce input vertices. Only effective when output projection matches (or is similar to) input projection. false
max_async_connection integer Max number of queries for rendering one map in asynchronous mode. Used only when asynchronous_request=true. Queries are sent asynchronously : while rendering a layer, queries for further layers will run in parallel in the remote server. Default value (1) has no effect. 1
wkb bool Fetch the geometry column as a WKB with .STAsBinary() instead of using SQL Server CLR type false

Installation

Copy mssql.input to the mapnik\input directory.

Building instructions

Windows

Requirements and dependencies:

  • Visual Studio 2015
  • Mapnik SDK >= 3.0

Linux / OS X (Tested with unixODBC / FreeTDS 0.95)

make
make install

You can’t perform that action at this time.