...
The SRID column should contain the EPSG code for the projection that the data for the layer is stored in.
Using geometry metadata configuration
As of Weave 2.5.16 it's possible to specify the information contained in the geometry metadata table directly in the spatial engine configuration.
| Name | Description |
|---|---|
name | The table name |
schema | The optional table schema |
| type | The geometry type (point, linestring, polygon, multipoint, multilinestring, multipolygon) |
| srid | The geometry srid |
| dimension | The geometry dimension |
| Code Block | ||
|---|---|---|
| ||
<spatial:spatialengine id="sqlserver">
<dbtype>sqlserver</dbtype>
<host>sqlhost</host>
<port>1434</port>
<user>gis</user>
<passwd>hak0rz</passwd>
<schema>GIS</schema>
<minconnection>2</minconnections>
<validateconnections>true</validateconnections>
<geometrymetadata>
<table schema="dbo" name="park" type="multipolygon" srid="28355" dimension="2"/>
<table schema="dbo" name="property" type="polygon" srid="28355" dimension="2"/>
<table schema="dbo" name="road" type="linestring" srid="28355" dimension="2"/>
</geometrymetadata>
</spatial:spatialengine> |