select a.name, ST_Distance(a.geolocation, b.geolocation) as distance from addresses a left join addresses b on (a.id b.id) where b.name = 'Hashrocket JAX' --and ST_Distance(a.geolocation, b.geolocation) < 1000 order by distance;
Hi, I have a temperature dataset in 2 files (.cvd and .xlsx) and I would like to create a geo-referenced map with multiple layers according to the temperature at different time points. I would like to be able to filter by layer and also select one or more combinations. Is this possible? Any advice is appreciated. Thanks in advance for your help!
Also I was wondering, why do you have to say ST_Distance(a.geolocation, myrtle_parkway.geolocation) < 1000, instead of distance < 1000. I know it doesn't work, but why is that?
@@GIS-Engineer Sure. veggiekeller@gmail.com. Im learning too, so I might not know everything, but feel free to shoot me an email. I'll answer what I can!
when i update the geolocation column with ST_MakePoint it only saves the lat long like this "POINT (-49.1162121 -26.9281947)" it doesnt save as it is shown on the video. Anyone else had this problem too?
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
Great job done for 5 min!
select a.name, ST_Distance(a.geolocation, b.geolocation) as distance
from addresses a
left join addresses b
on (a.id b.id)
where b.name = 'Hashrocket JAX'
--and ST_Distance(a.geolocation, b.geolocation) < 1000
order by distance;
Wow! Really great video and super easy to follow! This is great!!
Love your explanation, easy to follow and very nice.
Amazing video
Oh my god, thank you so much!
Very good video! Thank you!
ST_DISTANCE will return distance in mts regardless of the SRID of the geometries? I think with 4326 it will return distance in degrees right?
Thank you !!
So helpful !
hi can u help with st_within function,how can I use this ?
Can someone explain what is the use of SRID?
Hi, I have a temperature dataset in 2 files (.cvd and .xlsx) and I would like to create a geo-referenced map with multiple layers according to the temperature at different time points. I would like to be able to filter by layer and also select one or more combinations. Is this possible? Any advice is appreciated. Thanks in advance for your help!
where have I been?
Also I was wondering, why do you have to say ST_Distance(a.geolocation, myrtle_parkway.geolocation) < 1000, instead of distance < 1000. I know it doesn't work, but why is that?
ST_makepoint doesn't exist error
Plz give solution
Try this. It worked for me!
ST_MakePoint(longitude::double precision, latitude::double precision);
@@veggiekeller thanx a lot
@@GIS-Engineer No problem! Did it work ok?
@@veggiekeller plz give me ur email..if u dont have prob.
I need ur help in postgresql some other question
@@GIS-Engineer Sure. veggiekeller@gmail.com. Im learning too, so I might not know everything, but feel free to shoot me an email. I'll answer what I can!
This is a really great tutorial, but what you type is hidden unless I put the video on full screen, which makes it difficult to follow along to.
I am sure that this is a good tutorial, but I am English (from England) and cannot understand some of the things being said. (Eg: 4:04).
when i update the geolocation column with ST_MakePoint it only saves the lat long like this "POINT (-49.1162121 -26.9281947)" it doesnt save as it is shown on the video. Anyone else had this problem too?
Thank you!