Embedded Files
The "importwellmicroseismic" web service imports a well microseismic into the specified datasource.
A typical URL is http://myserver.mycompany.com:8080/INTGeoServer/api/ds/{datasourcetype}/v1/sources/{datasource}/microseismics/import with the POST method.
where
datasourcetype: type of a datasource, i.e. mongo, s3, etc.
datasource: unique id of a datasource
The following parameters are available:
importoptions: a JSON object that specifies parameters of the being imported well dataset. The following parameters are available:
wellName specifies a name of the well to add microseismic to. If the well does not exist, a new well will be created.
frackingStageName specifies a name of the fracking stage to import microseismic into. If the fracking stage does not exist a new fracking stage will be created. Note that there can be only one microseismic per fracking stage. This is an optional parameter. The default is the file name.
frackingStageNumber specifies a number of the fracking stage to import microseismic into. This is an optional parameter. If the fracking stage number is not specified, a fracking stage number will be generated based on the last fracking stage number (if fracking stages 1, 3, 7 already exist, then the next generated fracking stage number will be 8).
overwrite indicates whether to override an existing microseismic. If overwrite is false and a microseismic already existings for the specified fracking stage, then an error will be thrown. This is an optional parameter. The default is false.
dataValuesRow specifies the row that data values start to appear on
delimeter specifies a character delimiter used to parse the microseismic file
startMD specifies the start depath value for fracking stage
endMD specifies the end depth value for fracking stage
xColumnIndex specifies an index of column for x values
yColumnIndex specifies an index of column for y values
depthColumn specifies an index of column for depth values
depthUnit specifies the depth unit symbol for fracking stage. This is an optional parameter. The default is false.
attributeoptions : a JSON array representing attribute fields. The following parameters are available:
attributeName specifies the name of attribute. Attribute names must be unique.
columnIndex specifies an index of column for attribute values
timestampoptions: a JSON array representing timestamp attribute field. The following parameters are available:
timestampMode: specifies timestamp values, typically
useLineNumber: timestamp values will be based on the line number. This option will be used if a timestampMode is not specified
timestampInColumn: timestamp values are specified in timestampColumnIndex parameter.
dateAndTime: timestamp values will be specified in date and time string (either in two separate columns or one column)
timestampOriginMode: specifies how the timestamp origin is calculated (if timestampMode is useLineNumber then this the time origin is ignored), typically:
timeOfFirstRecord: use the full unix timestamp of the first timestamp value found as the timestamp origin
dateOfFirstRecord: use the unix timestamp of the date (for example 12/31/2015 05:05:66 becomes 12/312015 00:00:00) as the timestamp origin
customDateTime: use a customTimestampOrigin parameter
timestampColumnIndex: specifies the column where timestamp values appear. Timetsamp values will be in epoch format
timeColumnIndex: specifies the column where time value is specified.
dateColumnIndex: specifies the column where date value is specified.
dateFormat: specifies the date format used to parse the date string
timeFormat: specifies the time format used to parse the time string
dateTimeSeparator: the separator string used to separate date and time values that are specified in the same column
timeFirst: indicates whether time values are specified before date values. This is an optional parameter. The default is false.
customTimestampOrigin: species the custom timestamp origin in epoch format
file: a file containing a being imported well microseismic. This is required parameter.
All row and column indices start at 1.
An example import is shown below (pass multipart/form-data as Content-Type):
importoptions:
{
"wellName": "frackingStage",
"frackingStageName": "fracking",
"overwrite": true,
"depthUnit": "ft",
"dataValuesRow": 5,
"delimiter": ",",
"startMD": -6500,
"endMD": -6000,
"xColumnIndex": 4,
"yColumnIndex": 5,
"depthColumnIndex": 6
}
attributeoptions:
[
{
"attributeName": "MS_EVENT_ID",
"columnIndex": 2
},
{
"attributeName": "QC_LOC_T0",
"columnIndex": 3
},
{
"attributeName": "SP_MAGNITUDE",
"columnIndex": 7
}
]
timestampoptions:
{
"timestampMode": "dateAndTime",
"timeColumnIndex": 1,
"timeFormat": "HH24:MM:SS",
"dateColumnIndex": 1,
"dateFormat": "DD:MM:YY",
"dateTimeSeparator": ":",
"timestampOriginMode": "dateOfFirstRecord"
}
Here is an example response. This response has been formatted to improve readability.
{
"from": {
"actor": "akka://DefaultActorSystemControllerActorSystem:ImportMicroseismicsJsonActor:ImportMicroseismicsResponse for ImportMicroseismicsRequest:ImportMicroseismicsRequest{klass=AbstractMicroseismicImporter, sourceType=mongo, sourceName=c9db3458-6698-49d9-ae8f-f407ce26ae2e, pathInfo=/ds/mongo/v1/sources/c9db3458-6698-49d9-ae8f-f407ce26ae2e/microseismics/import, numberOfUploadedFiles=1, file #0=UploadedFile{file=2015HOU0098_NNE_MIP_3H_Stg 07.csv, directory=UPLOADDIR252eb8a2-9e28-43f3-a197-6600bef142396361932129294751159, fileSize=23789, checksum=d5f31fb48ae785974ff014e26485bc18, mimeType=text/csv, originalFileName=2015HOU0098_NNE_MIP_3H_Stg 07.csv, parameterName=file}, parameters=MicroseismicImportParameters{wellName=frackingStage, depthUnit=ft, frackingStageName=fracking, frackingStageNumber=null, columnParameters=[MicroseismicAttributeColumnParameters{columnIndex=2, attributeName=MS_EVENT_ID}, MicroseismicAttributeColumnParameters{columnIndex=3, attributeName=QC_LOC_T0}, MicroseismicAttributeColumnParameters{columnIndex=7, attributeName=SP_MAGNITUDE}], overwrite=true, startMD=-6500.0, endMD=-6000.0, delimiter=,, crsUniqueId=null, wgs84transformUniqueid=null, timestampColumnParameters=MicroseismicTimestampColumnParameters{timestampColumnIndex=null, timeColumnIndex=1, dateColumnIndex=1, dateFormat=DD:MM:YY, timeFormat=HH24:MM:SS, dateTimeSeparator=1, isTimeFirst=false, timeOrigin=null, timestampMode=dateAndTime, timestampOriginMode=dateOfFirstRecord}, xColumnIndex=4, yColumnIndex=5, depthColumnIndex=6, reverseDepths=false}}"
},
"data": {
"files": [
{
"fileName": "2015HOU0098_NNE_MIP_3H_Stg 07.csv",
"id": "13a31dc9-cec6-4800-b95a-aaec280c260c",
"links": [
{
"rel": "Well",
"name": "Well",
"relEntity": "v1/schema/int/well",
"href": "/ivaap/api/ds/mongo/v1/sources/c9db3458-6698-49d9-ae8f-f407ce26ae2e/wells/13a31dc9-cec6-4800-b95a-aaec280c260c",
"children": true,
"hasProjectEntityChildren": false,
"isProjectEntity": true
}
]
}
]
}
}
The fileName entry is the name of a being imported microseismic file.
The id entry is a unique id of a well a microseismic has been imported to.
The links sections provides aHATEOAS link to the "Well Data Web Service (v3)" service.
Report abuse