...
The basic spatial intersection data definition is something like the following:
| Code Block |
|---|
| xml | xml |
|---|
| title | Table join with output rows pulled from child table |
|---|
| xml |
|---|
|
<?xml version="1.0" encoding="UTF-8"?>
<config xmlns = "urn:com.cohga.server.config#1.0" xmlns:data = "urn:com.cohga.server.data.database#1.0">
<data:datadefinition id="spatial.join">
<spatialintersectiondataconnection entity="parentEntityId" table="childTableName"/>
</data:datadefinition>
</config>
|
...
If you want to limit the columns returned then you can add "parameter" tags to describe the columns you want returned, e.g.
| Code Block |
|---|
xml |
|---|
| xml |
|---|
| title | Table join with output columns specified directly |
|---|
| xml |
|---|
|
<?xml version="1.0" encoding="UTF-8"?>
<config xmlns = "urn:com.cohga.server.config#1.0" xmlns:data = "urn:com.cohga.server.data.database#1.0">
<data:datadefinition id="spatial.join">
<spatialintersectiondataconnection entity="parentEntityId" table="childTableName">
<parameter name="childColumn1" label="Child Column 1" column="CHILD_COLUMN1"/>
<parameter name="childColumn2" label="Child Column 2" column="CHILD_COLUMN2"/>
</spatialintersectiondataconnection>
</data:datadefinition>
</config>
|
...
Additionally you can specify a child entity rather than a child table if you already have an entity that represents the table that you're trying to join with, e.g.
| Code Block |
|---|
xml |
|---|
| xml |
|---|
| title | Entity join with output columns pulled from child entity |
|---|
| xml |
|---|
|
<?xml version="1.0" encoding="UTF-8"?>
<config xmlns = "urn:com.cohga.server.config#1.0" xmlns:data = "urn:com.cohga.server.data.database#1.0">
<data:datadefinition id="spatial.join">
<spatialintersectiondataconnection entity="parentEntityId" targetentity="childEntityId"/>
</data:datadefinition>
</config>
|
or with parameters also defined directly
| Code Block |
|---|
| xml | xml |
|---|
| title | Entity join with output columns defined |
|---|
| xml |
|---|
|
<?xml version="1.0" encoding="UTF-8"?>
<config xmlns = "urn:com.cohga.server.config#1.0" xmlns:data = "urn:com.cohga.server.data.database#1.0">
<data:datadefinition id="spatial.join">
<spatialintersectiondataconnection entity="parentEntityId" targetentity="childEntityId">
<parameter name="childColumn1" label="Child Column 1" column="CHILD_COLUMN1"/>
<parameter name="childColumn2" label="Child Column 2" column="CHILD_COLUMN2"/>
</spatialintersectiondataconnection>
</data:datadefinition>
</config>
|
Finally it's also possible to specify a buffer that can be applied to the parent geometry before using it to select the child rows, e.g.
| Code Block |
|---|
| xml | xml |
|---|
| title | Table join with buffer specified for source geometry |
|---|
| xml |
|---|
|
<?xml version="1.0" encoding="UTF-8"?>
<config xmlns = "urn:com.cohga.server.config#1.0" xmlns:data = "urn:com.cohga.server.data.database#1.0">
<data:datadefinition id="spatial.join">
<spatialintersectiondataconnection entity="parentEntityId" table="childTableName" buffer="10" bufferUnits="m"/>
</data:datadefinition>
</config>
|
...