The name of my table is odk_duct.duct_monitoring1_core and the select statement below is what i want to see the distance. The table has 2 longitudes and 2 latitudes.
select
"_URI" as id,
"_SUBMISSION_DATE" as date,
initcap("INFO_TEAM_NAME") as team_name,
initcap("INFO_SUPERVISOR_NAME") as supervisor_name,
"INFO_LOCATION" as location,
"RPT_FTR_POINT1_LAT" as first_point_lat,
"RPT_FTR_POINT1_LNG" as first_point_long,
"RPT_FTR_POINT2_LAT" as second_point_lat,
"RPT_FTR_POINT2_LNG" second_point_long,
"RPT_FTR_WIDTH" as width_cleared,
formid
FROM odk_duct.duct_monitoring1_core
I want to know the distance between point 1 and point 2 in meters using PostGIS query.
No comments:
Post a Comment