Nathan Layman

Okay how about [this](https://github.com/ecohealthalliance/doltr/blob/8119ba5b0eaef55a91fa0332b8c3c91fca6ad67b/R/sf-read.R)? I think I'm up to speed with what you have been saying this whole time now.

The goals is to add a WEKB reader to doltr that can be pulled into sf eventually. Write an st_read method to handle this case. We will need to read...

Relevant resources: https://github.com/r-spatial/sf/issues/757 https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html

Also I think we can declare srid in an insert query via ``` dbExecute(conn, "insert into us_state_capitals_NCL values ('alabama', 'montgomery', ST_SRID(point(32.361667, -86.279167), 4326));") ```

@latot would you be willing to test a potential fix to this issue? If so, install `doltr` from the following branch and try out `st_read()` and `st_write()`. No need to...

Collecting resources: https://stackoverflow.com/questions/63573122/dbwritetable-with-geometry-point-type-to-mariadb

I think the next steps will be to modify [`castData`](https://github.com/ankane/dbx/blob/e7e4a5094719518f339b49c9aeeb6050e74ae439/R/helpers.R#L263) and / or [`quoteRecords`](https://github.com/ankane/dbx/blob/e7e4a5094719518f339b49c9aeeb6050e74ae439/R/helpers.R#L263) in `dbx`. If we can nail `dbxInsert` we're most of the way there. I don't think...

Okay I have a patch proposed to dbx that should allow dbWriteTable to handle sf objects. In testing I was able to create an sf object in R, create a...

I had some method dispatch problems with dbWriteTable which are (hopefully) now resolved. You can try the patch by installing doltr from this branch. So far `write_sf` appears to work...

Okay now we have `st_write()` and `st_read()` methods.