{
"sql22": "select objectid,st_asewkt(shape) as wkt,cast(cast(labeldm as int2) as varchar) as zwlx,'中文' as fddd from dt_sample limit 111",
"sql":"select objectid,st_asewkt(shape) as wkt,sys_label.value as zwlx,sys_label.type as type from dt_sample inner join interpret_job_runtime_sample on objectid=sample_id inner join sys_label on labeldm=code where interpret_job_runtime_id='259232356180037'",
"geoType": "MultiPolygon",
"wktField": "wkt",
"saveShpFile": "/home/rsanalysis/shp2/test.shp",
"modifyPrj": true
}
curl --location --request POST 'http://gykj123.cn:9000/middleground-rsanalysis-sample/api/v1/dtyfcj/generateSqlToShp' \
--header 'token: {{access_token}}' \
--header 'Content-Type: application/json' \
--data-raw '{
"sql22": "select objectid,st_asewkt(shape) as wkt,cast(cast(labeldm as int2) as varchar) as zwlx,'\''中文'\'' as fddd from dt_sample limit 111",
"sql":"select objectid,st_asewkt(shape) as wkt,sys_label.value as zwlx,sys_label.type as type from dt_sample inner join interpret_job_runtime_sample on objectid=sample_id inner join sys_label on labeldm=code where interpret_job_runtime_id='\''259232356180037'\''",
"geoType": "MultiPolygon",
"wktField": "wkt",
"saveShpFile": "/home/rsanalysis/shp2/test.shp",
"modifyPrj": true
}'
{
"timestamp": 1670905996643,
"datetime": "2022-12-13T12:33:16.646",
"code": 200,
"message": "成功",
"success": true,
"data": {
"sql": "select objectid,st_asewkt(shape) as wkt,cast(cast(labeldm as int2) as varchar) as zwlx,'中文' as fddd from dt_sample limit 111",
"geoType": "MultiPolygon",
"wktField": "wkt",
"saveShpFile": "/home/rsanalysis/shp2/11126.shp",
"modifyPrj": false
}
}