场景:有2个经纬度。4个字段,拼接线geojson
SELECT
json_build_object(
'type', 'Feature',
'geometry', ST_AsGeoJSON(
ST_MakeLine(
ST_SetSRID(ST_MakePoint(ST_X(ST_Transform(ST_SetSRID(ST_Point(startpty::float, startptx::float), 4549), 4326))-0.75,
ST_Y(ST_Transform(ST_SetSRID(ST_Point(startpty::float, startptx::float), 4549), 4326))), 4326),
ST_SetSRID(ST_MakePoint(ST_X(ST_Transform(ST_SetSRID(ST_Point(endpty::float, endptx::float), 4549), 4326))-0.75,
ST_Y(ST_Transform(ST_SetSRID(ST_Point(endpty::float, endptx::float), 4549), 4326))), 4326)
)
)::json,
'properties', json_build_object(
'pipelinetype',pipelinetype,
'startptx',startptx,
'startpty',startpty,
'endptx',endptx,