Nathan Layman

I also like this idea because it would make it easier to use foam with Quarto.

Need mysql sf methods

This is just adding an ellipse to the doltr dbWriteTable() method right? That definitely seems like a good step and closes in on the location of the WKB / EWKB...

Tooling around today I identified where sf is storing the CRS in the binary string ``` geom st_set_crs(4326) sf:::to_postgis(conn, geom, binary = T) state city coord 1 alabama montgomery 0101000020e61000001ab0856e00000001df43c7d640402e4b...

Thanks! What I'm looking for now is differences between the PostGIS and MySQL specification. Mostly just to orient myself.

Another thing to note is that the points returned by ``` > geom geom Simple feature collection with 2 features and 2 fields Geometry type: POINT Dimension: XY Bounding box:...

drilling down this occurs within readWKB ``` > readWKB(sf_via_dbi$coord[[1]], EWKB = T) POINT (7.291125e-304 1.448735e+54) ```

Some more clues. sf expects the WKB hex provided by the dolt db to be big endian, that the point coordinates come last, and are 8L long each. Maybe this...

It's that and an endian problem. There's a difference in precision in the leading ints or dolt / mySQL is storing more stuff. The following recovers the original points. ```...

Issue's #38 and #60