I can find the points in the polygon in the picture from the database.
How can I write this result in the field_farm_area field or the field I will create myself?
e.g. log record 97
this is my query–>
select name from taxonomy_term_data
where tid in(
select point.entity_id,st_contains(polygon.geom,point.geom) sonuc
from (select ST_GEOMFROMTEXT(ST_AsText(ST_GeomFromWKB(field_farm_geofield_geom))) as geom,entity_id from field_data_field_farm_geofield where bundle=‘farm_areas’) point,
(select ST_GEOMFROMTEXT(ST_AsText(ST_GeomFromWKB(field_farm_geofield_geom))) as geom from field_data_field_farm_geofield
where entity_id=97) polygon) x
this is the result–>
I want to print these numbers on a field or field farm area.
subject if field_farm_area is empty.
In addition, this query will work for every log, here I just gave 97 as an example.