@trevorm

You can use coordinateextractors, reprojectors to get the LL.

Geometry (and geography) can be written by the relevant writer.

You can do it in one go as each table is identifiable.

For examples, some data is needed. So if you could post a sample, help will come fast on this forum.

@gio Is this sort of what it should look like? Also I couldn't find the geography transformer

@trevorm

Yes that about it.

You don't need to extract geometry in this process, unless you wish to store it. But as they are points, they are already in store.

Geography is a data type. Chosen/set on the writer side.

See relevant info:

This type represents data in a round-earth coordinate system. The SQL Server geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates. SQL Server supports a set of methods for the geography spatial data type.

@gio Thank you for the help, the results of my current field shows in the Inspector, but the reason I'm doing this is to produce new fields in the table. I need to create 4 new fields LAT , LONG , Geometry and Geography.

So when I look at my new table in SQLSMS it doesn't show those fields that were supposed to be created?

@trevorm

Extract coordinates after the reprojector.

The coordinates will be in attributes, you need to rename/copy/create them to Lat/Long.

As far is geometry and geography are concerned, writing them using a spatial writer, will create the columns. Those attributes don't show in the writer, you can see them in your table.

If you actually want a string representation of them, you can indeed extract them using Geomtery Extractor. But you do need to add the attribute to the writer (as with the Lat/Long).

But that would leave you with a table with geometry and its string representation (seems superfluous to me).

I can't access your sample sheet, alas.

Hi @trevorm,

If you only need the coordinate values you can also use the AttributeReprojector.

Hope this helps,

Itay

Hello, just a quick update; it turns out I didn't have a lic to export to SQL Spatail, once Safe hooked me up it works like a charm.

I've used all the above suggested with success, and I can even just write using the SQL Spatial server.

Thank you.