CSV Parser Enhancement - Spatial data handler
Spatial data handler
Pre-requisities:
- Schema used to ingest the data has Spatial reference.
- CSV file has the Spatial data attributes.
- ExtensionProperties Block is used to provide content details of the file, the Workflow Service uses this same block to provide Spatial data information.
- SpatialMapping: This section is used to create the Spatial data block in the ingested records.
- type: This field refers to the type of the Spatial data; currently the Workflow Service only supports point.
- latitude: This field refers to the Latitude of the point.
- longitude: This field refers to the Longitude of the point.
{
"ExtensionProperties": {
"FileContentsDetails": {
"TargetKind": "<<authority>:<source>:<entityType>:<version>>",
"FileType": "csv",
"SpatialMapping":{
"type": "point",
"latitude": "Column name of the CSV which contains the LATITUDE value",
"longitude": "Column name of the CSV which contains the LONGITUDE value"
},
"FrameOfReference": [
{
"kind": "CRS",
"name": "GCS_WGS_1984",
"persistableReference": "{\"wkt\":\"GEOGCS[\\\"GCS_WGS_1984\\\",DATUM[\\\"D_WGS_1984\\\",SPHEROID[\\\"WGS_1984\\\",6378137.0,298.257223563]],PRIMEM[\\\"Greenwich\\\",0.0],UNIT[\\\"Degree\\\",0.0174532925199433],AUTHORITY[\\\"EPSG\\\",4326]]\",\"ver\":\"PE_10_3_1\",\"name\":\"GCS_WGS_1984\",\"authCode\":{\"auth\":\"EPSG\",\"code\":\"4326\"},\"type\":\"LBC\"}",
"propertyNames": [
"Column name of the CSV which contains the LATITUDE value",
"Column name of the CSV which contains the LONGITUDE value"
],
"propertyValues": [
"deg"
],
"uncertainty": 0
}
}
}
}