ST_Intersects

[ihahachi]

Hello,
Does this function ST_Intersects exist?

[saibotk]

Yes the function can be found here:

laravel-magellan/src/Database/PostgisFunctions/MagellanTopologicalRelationshipFunctions.php

Line 129 in ccd04d8

public static function intersects($geometryA, $geometryB, ?GeometryType $geometryType = GeometryType::Geometry): MagellanBooleanExpression

Is this what you were looking for?

[ihahachi]

Can I use it like this?

public function intersection()
    {
        $parser = app(GeojsonParser::class);
        $point = $parser->parse('{
            "type": "Feature",
            "properties": {},
            "geometry": {
              "coordinates": [
                7.528140941533081,
                36.87362083085081
              ],
              "type": "Point"
            }
          }');

        $polygon = $parser->parse('   {
            "type": "Feature",
            "properties": {},
            "geometry": {
              "coordinates": [
                [
                  [
                    7.527677125092879,
                    36.87539249560881
                  ],
                  [
                    7.526419531088692,
                    36.87502329062498
                  ],
                  [
                    7.525051278049034,
                    36.8735484449562
                  ],
                  [
                    7.525816572121784,
                    36.87199936255416
                  ],
                  [
                    7.527637044386836,
                    36.87153555931674
                  ],
                  [
                    7.5293531583694175,
                    36.87214777899487
                  ],
                  [
                    7.53044841726782,
                    36.873351830952416
                  ],
                  [
                    7.5308078735742185,
                    36.87516060464338
                  ],
                  [
                    7.527677125092879,
                    36.87539249560881
                  ]
                ]
              ],
              "type": "Polygon"
            }
          }');

        return ST::intersects($point, $polygon);
    }

[saibotk]

Sorry for the late reply.

Actually all actions will need to be done via a database query. You could just use something along the lines of DB::query()->stSelect(ST:intersects($point, $polygon))->get()

(You would need to try this out, I currently cannot check that, just wrote it out of my head.)

Hope that helps!

[ihahachi]

Thank you for your response