I have a layer of points and want to join some data from polygons where the two coincide. I might have several points in one poly.
The points were generated from a CSV as;
UPDATE t_osab_with_voa_ndr SET geom_point_4258 = ST_SetSrid(ST_MakePoint(longitude, latitude),4258);
Where they are stated as being ETRS89 projection which is SRID 4258
I'm running into problems as the points have SRID 4258 and the Polys are 27700 I've tried using ;
ALTER TABLE t_osab_with_voa_ndr
ALTER COLUMN geom_point_4258 TYPE geometry(point,27700)
When I look in QGIS I see this;
But when I run;
create or replace view v_spatialjoin_northeast_st_within1 as
select * from t_osab_with_voa_ndr , d_geom_northeast where st_within(t_osab_with_voa_ndr.geom_point, d_geom_northeast.geom);
I get no results when I can see I should
Question 1. Can i combine the ST_Within / ST_Interects and specify the SRID in the process or am i better transforming the points first?
EDIT: Reason for my blanks was SQL problem with ST_Within, but still interested to know if you can set SRID or what is the fastest way to execute this