Change: ‘loadData’

The <loadData> change works the same as before except that Well-Known Text and Extended Well-Known Text formats are supported.

As a Best Practice, use the Extended Well-Known Text format and match the SRID to the value given in the column’s geometry column type.

Example

<changeSet id="1" author="bob">
   <loadData tableName="home" file="home.csv">
      <column name="id" type="numeric"/>
   </loadData>
</changeSet>
home.csv
id, location
1, POINT(-106.445305 39.117769)
2, SRID=4326;POINT(-106.47556 39.1875)
3, SRID=4326;POINT(-106.32056 38.92444)