Portable WKT · longitude-first · no sign-up

Address in.
WKT point out.

pointkit geocodes a plain address and hands back a POINT(longitude latitude) WKT string — the portable geometry format that Postgres, SQL Server, Oracle Spatial, SpatiaLite, and most GIS software all read directly.

Also available: Postgres/PostGIS · MySQL POINT · GeoJSON
WKT
{{ heroResultText }}
No SRID attached — that's expected for plain WKT. Wrap it yourself where your tool needs one, e.g. ST_GeomFromText('{{ heroResultText }}', 4326).
{{ heroErrorText }} Buy more credits →

The format that isn't tied to one database

Every serious spatial system reads WKT, which is exactly why it's worth having on hand even if you already use Postgres or MySQL day to day: it's what you paste into a one-off SQL Server or Oracle Spatial query, what QGIS and ArcGIS import without complaint, and what plenty of internal tools accept as a lowest-common-denominator geometry input.

The catch is the same one every spatial format shares: axis order. WKT is (longitude, latitude). Get a coordinate pair from somewhere that returns lat/long first — a lot of consumer mapping APIs do — and swap them by mistake, and the point silently lands somewhere else on Earth. pointkit geocodes the address directly, so the order is right from the start.

WKT FAQ

What is WKT?
Well-Known Text is a plain-text geometry format defined by the Open Geospatial Consortium. A point is written as POINT(longitude latitude). It's read and written by Postgres/PostGIS, SQL Server, Oracle Spatial, SpatiaLite, and most GIS desktop software.
Does WKT include the SRID / coordinate reference system?
No — plain WKT is just the geometry, with no spatial reference attached. Supply that separately, e.g. by wrapping it in ST_GeomFromText('POINT(...)', 4326). pointkit's Postgres output already does this wrapping for you; the WKT here is the bare geometry for anywhere else you need it.
Is WKT longitude-first or latitude-first?
Longitude first: POINT(longitude latitude). Every major spatial format follows this except MySQL/MariaDB's default SRID 4326, which reverses it.
Can I convert a whole file of addresses to WKT at once?
Yes — export the addresses as a CSV and use pointkit's batch converter, which appends a WKT column to the file.