How do I get the distance meter value between two geometries in PostGIS?Defining coordinate system for finding distance in metersHow to calculate distance between two 3D points in kilometers using postgisGetting result in metric from QGIS Distance Matrix tool in QGIS?PostGIS - incorrect result distance between two pointsWhat is the real distance between positions?Does Oracle Spatial calculate geodetic distance?Postgis meassuring distance between first and third points of a polygonHow to use St_intersects with different geometry typeMeasure the distance between 2 pointsHow to handle distance in postgis using ST_DWithinSelect nearest 3D point with sfcgalPostGIS: calculate minimum distance between feature types
How do I gain back my faith in my PhD degree?
A category-like structure without composition?
ssTTsSTtRrriinInnnnNNNIiinngg
What does the expression "A Mann!" means
Is it possible to create a QR code using text?
How badly should I try to prevent a user from XSSing themselves?
Why was the shrinking from 8″ made only to 5.25″ and not smaller (4″ or less)?
Gatling : Performance testing tool
Detention in 1997
Ambiguity in the definition of entropy
Why is consensus so controversial in Britain?
If human space travel is limited by the G force vulnerability, is there a way to counter G forces?
Watching something be piped to a file live with tail
Why can't we play rap on piano?
What do you call someone who asks many questions?
How much of data wrangling is a data scientist's job?
Why are the 737's rear doors unusable in a water landing?
Is it inappropriate for a student to attend their mentor's dissertation defense?
How to compactly explain secondary and tertiary characters without resorting to stereotypes?
How can I determine if the org that I'm currently connected to is a scratch org?
Avoiding the "not like other girls" trope?
Intersection Puzzle
Can a virus destroy the BIOS of a modern computer?
Venezuelan girlfriend wants to travel the USA to be with me. What is the process?
How do I get the distance meter value between two geometries in PostGIS?
Defining coordinate system for finding distance in metersHow to calculate distance between two 3D points in kilometers using postgisGetting result in metric from QGIS Distance Matrix tool in QGIS?PostGIS - incorrect result distance between two pointsWhat is the real distance between positions?Does Oracle Spatial calculate geodetic distance?Postgis meassuring distance between first and third points of a polygonHow to use St_intersects with different geometry typeMeasure the distance between 2 pointsHow to handle distance in postgis using ST_DWithinSelect nearest 3D point with sfcgalPostGIS: calculate minimum distance between feature types
I have a simple question about calculating distances in PostGIS.
I would like to get the distance between two geometries. I am using this sid : 4269 in meters
what i am doing now is this : ST_Distance((a.geom,b.geom)) FROM ... but I am getting result in degrees. I think that I should work with geography but how can I cast a geom to a geography? I tried with (a.geom::geography) but i am getting an error.
What can I do to get my result in meters?
Thank You
postgis coordinate-system postgresql distance
edited Apr 19 '12 at 16:06
Stev_k
5,1932741
asked Apr 19 '12 at 15:20
YassineGeomaYassineGeoma
107117
add a comment |
I have a simple question about calculating distances in PostGIS.
I would like to get the distance between two geometries. I am using this sid : 4269 in meters
what i am doing now is this : ST_Distance((a.geom,b.geom)) FROM ... but I am getting result in degrees. I think that I should work with geography but how can I cast a geom to a geography? I tried with (a.geom::geography) but i am getting an error.
What can I do to get my result in meters?
Thank You
postgis coordinate-system postgresql distance
edited Apr 19 '12 at 16:06
Stev_k
5,1932741
asked Apr 19 '12 at 15:20
YassineGeomaYassineGeoma
107117
add a comment |
I have a simple question about calculating distances in PostGIS.
I would like to get the distance between two geometries. I am using this sid : 4269 in meters
what i am doing now is this : ST_Distance((a.geom,b.geom)) FROM ... but I am getting result in degrees. I think that I should work with geography but how can I cast a geom to a geography? I tried with (a.geom::geography) but i am getting an error.
What can I do to get my result in meters?
Thank You
postgis coordinate-system postgresql distance
edited Apr 19 '12 at 16:06
Stev_k
5,1932741
asked Apr 19 '12 at 15:20
YassineGeomaYassineGeoma
107117
I have a simple question about calculating distances in PostGIS.
I would like to get the distance between two geometries. I am using this sid : 4269 in meters
what i am doing now is this : ST_Distance((a.geom,b.geom)) FROM ... but I am getting result in degrees. I think that I should work with geography but how can I cast a geom to a geography? I tried with (a.geom::geography) but i am getting an error.
What can I do to get my result in meters?
Thank You
postgis coordinate-system postgresql distance
postgis coordinate-system postgresql distance
edited Apr 19 '12 at 16:06
Stev_k
5,1932741
asked Apr 19 '12 at 15:20
YassineGeomaYassineGeoma
107117
edited Apr 19 '12 at 16:06
Stev_k
5,1932741
asked Apr 19 '12 at 15:20
YassineGeomaYassineGeoma
107117
edited Apr 19 '12 at 16:06
Stev_k
5,1932741
edited Apr 19 '12 at 16:06
Stev_k
5,1932741
edited Apr 19 '12 at 16:06
Stev_k
5,1932741
5,1932741
asked Apr 19 '12 at 15:20
YassineGeomaYassineGeoma
107117
asked Apr 19 '12 at 15:20
YassineGeomaYassineGeoma
107117
asked Apr 19 '12 at 15:20
YassineGeomaYassineGeoma
107117
107117
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
with ST_Distance_Sphere you can achieve that:
ST_Distance_Sphere(a.geom,b.geom)
answered Apr 19 '12 at 15:57
Francisco ValdezFrancisco Valdez
1,0451814
ERREUR: la fonction st_distance_spheroid(geometry, geometry) n'existe pas ... i just added (a.geom,b.geom, 'SPHEROID["WGS 84",6378137,298.257223563]') and now it is working fine thank you very much !
– YassineGeoma
Apr 19 '12 at 17:07
1
well, you used a different function, st_distance_spheroid which is slower than st_distance_sphere but more precise.
– Francisco Valdez
Apr 19 '12 at 17:28
What about the maximum distance between 2 geometries ?
– vasilakisfil
Jun 4 '15 at 11:08
The maximum distance would be earth_radius - minimum_distance, which would be traveling the opposite way. (heading + 180º)
– Francisco Valdez
Jul 8 '15 at 2:50
1
@don-prog It works for 3D and 2D point :SELECT ST_Distance_Sphere(ST_GeomFromEWKT('SRID=4326;POINT(-72.1235 42.3521 4)'), ST_GeomFromEWKT('SRID=4326;POINT(-72.1260 42.45 15)'))
– Francisco Valdez
Apr 17 '18 at 23:00
|
show 2 more comments
The units of SRID 4269 (NAD 83) are not metres - this is a geodetic projection, i.e. the co-ordinates are degrees (geographic co-ordinates).
pacofvf's answer will give you the distance in metres, but if you really did have your intial co-ordinates specified in metres then then you should use a projected co-ordinate system. Probably for North America you want something like State Plane Coordinate System which has a number of different projections depending on which region you want to map.
I suspect though that you are just using lat/lon values so probably this second paragraph isn't relevant - just use the ST_Distance_Sphere function as above.
answered Apr 19 '12 at 16:05
Stev_kStev_k
5,1932741
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f23820%2fhow-do-i-get-the-distance-meter-value-between-two-geometries-in-postgis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
with ST_Distance_Sphere you can achieve that:
ST_Distance_Sphere(a.geom,b.geom)
answered Apr 19 '12 at 15:57
Francisco ValdezFrancisco Valdez
1,0451814
ERREUR: la fonction st_distance_spheroid(geometry, geometry) n'existe pas ... i just added (a.geom,b.geom, 'SPHEROID["WGS 84",6378137,298.257223563]') and now it is working fine thank you very much !
– YassineGeoma
Apr 19 '12 at 17:07
1
well, you used a different function, st_distance_spheroid which is slower than st_distance_sphere but more precise.
– Francisco Valdez
Apr 19 '12 at 17:28
What about the maximum distance between 2 geometries ?
– vasilakisfil
Jun 4 '15 at 11:08
The maximum distance would be earth_radius - minimum_distance, which would be traveling the opposite way. (heading + 180º)
– Francisco Valdez
Jul 8 '15 at 2:50
1
@don-prog It works for 3D and 2D point :SELECT ST_Distance_Sphere(ST_GeomFromEWKT('SRID=4326;POINT(-72.1235 42.3521 4)'), ST_GeomFromEWKT('SRID=4326;POINT(-72.1260 42.45 15)'))
– Francisco Valdez
Apr 17 '18 at 23:00
|
show 2 more comments
with ST_Distance_Sphere you can achieve that:
ST_Distance_Sphere(a.geom,b.geom)
answered Apr 19 '12 at 15:57
Francisco ValdezFrancisco Valdez
1,0451814
ERREUR: la fonction st_distance_spheroid(geometry, geometry) n'existe pas ... i just added (a.geom,b.geom, 'SPHEROID["WGS 84",6378137,298.257223563]') and now it is working fine thank you very much !
– YassineGeoma
Apr 19 '12 at 17:07
1
well, you used a different function, st_distance_spheroid which is slower than st_distance_sphere but more precise.
– Francisco Valdez
Apr 19 '12 at 17:28
What about the maximum distance between 2 geometries ?
– vasilakisfil
Jun 4 '15 at 11:08
The maximum distance would be earth_radius - minimum_distance, which would be traveling the opposite way. (heading + 180º)
– Francisco Valdez
Jul 8 '15 at 2:50
1
@don-prog It works for 3D and 2D point :SELECT ST_Distance_Sphere(ST_GeomFromEWKT('SRID=4326;POINT(-72.1235 42.3521 4)'), ST_GeomFromEWKT('SRID=4326;POINT(-72.1260 42.45 15)'))
– Francisco Valdez
Apr 17 '18 at 23:00
|
show 2 more comments
with ST_Distance_Sphere you can achieve that:
ST_Distance_Sphere(a.geom,b.geom)
answered Apr 19 '12 at 15:57
Francisco ValdezFrancisco Valdez
1,0451814
with ST_Distance_Sphere you can achieve that:
ST_Distance_Sphere(a.geom,b.geom)
answered Apr 19 '12 at 15:57
Francisco ValdezFrancisco Valdez
1,0451814
answered Apr 19 '12 at 15:57
Francisco ValdezFrancisco Valdez
1,0451814
answered Apr 19 '12 at 15:57
Francisco ValdezFrancisco Valdez
1,0451814
answered Apr 19 '12 at 15:57
Francisco ValdezFrancisco Valdez
1,0451814
1,0451814
ERREUR: la fonction st_distance_spheroid(geometry, geometry) n'existe pas ... i just added (a.geom,b.geom, 'SPHEROID["WGS 84",6378137,298.257223563]') and now it is working fine thank you very much !
– YassineGeoma
Apr 19 '12 at 17:07
1
well, you used a different function, st_distance_spheroid which is slower than st_distance_sphere but more precise.
– Francisco Valdez
Apr 19 '12 at 17:28
What about the maximum distance between 2 geometries ?
– vasilakisfil
Jun 4 '15 at 11:08
The maximum distance would be earth_radius - minimum_distance, which would be traveling the opposite way. (heading + 180º)
– Francisco Valdez
Jul 8 '15 at 2:50
1
@don-prog It works for 3D and 2D point :SELECT ST_Distance_Sphere(ST_GeomFromEWKT('SRID=4326;POINT(-72.1235 42.3521 4)'), ST_GeomFromEWKT('SRID=4326;POINT(-72.1260 42.45 15)'))
– Francisco Valdez
Apr 17 '18 at 23:00
|
show 2 more comments
ERREUR: la fonction st_distance_spheroid(geometry, geometry) n'existe pas ... i just added (a.geom,b.geom, 'SPHEROID["WGS 84",6378137,298.257223563]') and now it is working fine thank you very much !
– YassineGeoma
Apr 19 '12 at 17:07
1
well, you used a different function, st_distance_spheroid which is slower than st_distance_sphere but more precise.
– Francisco Valdez
Apr 19 '12 at 17:28
What about the maximum distance between 2 geometries ?
– vasilakisfil
Jun 4 '15 at 11:08
The maximum distance would be earth_radius - minimum_distance, which would be traveling the opposite way. (heading + 180º)
– Francisco Valdez
Jul 8 '15 at 2:50
1
@don-prog It works for 3D and 2D point :SELECT ST_Distance_Sphere(ST_GeomFromEWKT('SRID=4326;POINT(-72.1235 42.3521 4)'), ST_GeomFromEWKT('SRID=4326;POINT(-72.1260 42.45 15)'))
– Francisco Valdez
Apr 17 '18 at 23:00
ERREUR: la fonction st_distance_spheroid(geometry, geometry) n'existe pas ... i just added (a.geom,b.geom, 'SPHEROID["WGS 84",6378137,298.257223563]') and now it is working fine thank you very much !
– YassineGeoma
Apr 19 '12 at 17:07
ERREUR: la fonction st_distance_spheroid(geometry, geometry) n'existe pas ... i just added (a.geom,b.geom, 'SPHEROID["WGS 84",6378137,298.257223563]') and now it is working fine thank you very much !
– YassineGeoma
Apr 19 '12 at 17:07
1
1
well, you used a different function, st_distance_spheroid which is slower than st_distance_sphere but more precise.
– Francisco Valdez
Apr 19 '12 at 17:28
well, you used a different function, st_distance_spheroid which is slower than st_distance_sphere but more precise.
– Francisco Valdez
Apr 19 '12 at 17:28
What about the maximum distance between 2 geometries ?
– vasilakisfil
Jun 4 '15 at 11:08
What about the maximum distance between 2 geometries ?
– vasilakisfil
Jun 4 '15 at 11:08
The maximum distance would be earth_radius - minimum_distance, which would be traveling the opposite way. (heading + 180º)
– Francisco Valdez
Jul 8 '15 at 2:50
The maximum distance would be earth_radius - minimum_distance, which would be traveling the opposite way. (heading + 180º)
– Francisco Valdez
Jul 8 '15 at 2:50
1
1
@don-prog It works for 3D and 2D point :
SELECT ST_Distance_Sphere(ST_GeomFromEWKT('SRID=4326;POINT(-72.1235 42.3521 4)'), ST_GeomFromEWKT('SRID=4326;POINT(-72.1260 42.45 15)'))– Francisco Valdez
Apr 17 '18 at 23:00
@don-prog It works for 3D and 2D point :
SELECT ST_Distance_Sphere(ST_GeomFromEWKT('SRID=4326;POINT(-72.1235 42.3521 4)'), ST_GeomFromEWKT('SRID=4326;POINT(-72.1260 42.45 15)'))– Francisco Valdez
Apr 17 '18 at 23:00
|
show 2 more comments
The units of SRID 4269 (NAD 83) are not metres - this is a geodetic projection, i.e. the co-ordinates are degrees (geographic co-ordinates).
pacofvf's answer will give you the distance in metres, but if you really did have your intial co-ordinates specified in metres then then you should use a projected co-ordinate system. Probably for North America you want something like State Plane Coordinate System which has a number of different projections depending on which region you want to map.
I suspect though that you are just using lat/lon values so probably this second paragraph isn't relevant - just use the ST_Distance_Sphere function as above.
answered Apr 19 '12 at 16:05
Stev_kStev_k
5,1932741
add a comment |
The units of SRID 4269 (NAD 83) are not metres - this is a geodetic projection, i.e. the co-ordinates are degrees (geographic co-ordinates).
pacofvf's answer will give you the distance in metres, but if you really did have your intial co-ordinates specified in metres then then you should use a projected co-ordinate system. Probably for North America you want something like State Plane Coordinate System which has a number of different projections depending on which region you want to map.
I suspect though that you are just using lat/lon values so probably this second paragraph isn't relevant - just use the ST_Distance_Sphere function as above.
answered Apr 19 '12 at 16:05
Stev_kStev_k
5,1932741
add a comment |
The units of SRID 4269 (NAD 83) are not metres - this is a geodetic projection, i.e. the co-ordinates are degrees (geographic co-ordinates).
pacofvf's answer will give you the distance in metres, but if you really did have your intial co-ordinates specified in metres then then you should use a projected co-ordinate system. Probably for North America you want something like State Plane Coordinate System which has a number of different projections depending on which region you want to map.
I suspect though that you are just using lat/lon values so probably this second paragraph isn't relevant - just use the ST_Distance_Sphere function as above.
answered Apr 19 '12 at 16:05
Stev_kStev_k
5,1932741
The units of SRID 4269 (NAD 83) are not metres - this is a geodetic projection, i.e. the co-ordinates are degrees (geographic co-ordinates).
pacofvf's answer will give you the distance in metres, but if you really did have your intial co-ordinates specified in metres then then you should use a projected co-ordinate system. Probably for North America you want something like State Plane Coordinate System which has a number of different projections depending on which region you want to map.
I suspect though that you are just using lat/lon values so probably this second paragraph isn't relevant - just use the ST_Distance_Sphere function as above.
answered Apr 19 '12 at 16:05
Stev_kStev_k
5,1932741
answered Apr 19 '12 at 16:05
Stev_kStev_k
5,1932741
answered Apr 19 '12 at 16:05
Stev_kStev_k
5,1932741
answered Apr 19 '12 at 16:05
Stev_kStev_k
5,1932741
5,1932741
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f23820%2fhow-do-i-get-the-distance-meter-value-between-two-geometries-in-postgis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
