North Pole coordinates

[grimzy]

North Pole coordinates

[grimzy]

Responding late, I know. Sorry about that.

I'm not sure about defining a const, but how about adding a PointInterface? I've been thinking of ways to customize the Geometry classes and interfaces feels like the right way to go.

[Shujee]

Thanks for getting back on this. Has been quite some time since I last worked on this stuff. I'm not a PHP pro by any stretch (more of a .NET guy), but I do like the idea of having interfaces that all geometry classes implement. I'm still thinking about how this will be used to store a nullable Point type. Can u shed some light on your plan?

[grimzy]

If your goal is to store a null Point in the database, unfortunately the limitation is on MySQL; I mean, as long as you want to keep the spatial index.

Now, I didn't look into this yet, but if we add a PointInterface, we could create variations of Points, for example, the NullPoint, NorthPole, SouthPole (all implementing PointInterface). You can then add these custom points to the GeometryCollections but not save them to the database.

I've been getting requests to be able to flip lat/lng in the helpers and having a PointInterface might help.

PS: what are the north pole coordinates you're trying to insert?

[Shujee]

I'm not trying to insert null into that column, I know that's not possible as long as I want to use index on that column. So my alternate plan was to use a far off value as a representation of null; North Pole was one such value that will not be needed by any real location in my case, so I thought it would be a good candidate to represent null. I believe I was using (0, -90) or something like that as my null value.

[Shujee]

Ah, grabbed my code. Here is a small helper class I had created then:

<?php
namespace App;

class NullablePoint extends \Grimzy\LaravelMysqlSpatial\Types\Point
{
    public static function NORTHPOLE()
    {
        return new \Grimzy\LaravelMysqlSpatial\Types\Point(90, 0);
    }

    public static function fromCommaSeparatedPair($pair)
    {
        list($lng, $lat) = explode(',', trim($pair, "\t\n\r \x0B()"));

        return new static((float) trim($lat), (float) trim($lng));
    }
}
?>

I'd then use it as the default null value of the spatial column in my create function:

$User->current_location = NullablePoint::NORTHPOLE();