Convert GeoJSON to WKT Online Free
GeoJSON is ideal for web mapping APIs, but spatial databases like PostGIS and PostgreSQL require WKT for SQL INSERT queries and spatial function arguments. Converting GeoJSON to WKT yields compact text suitable for ST_GeomFromText() statements.
SQL & Code Example
How to perform this conversion directly in your PostgreSQL / PostGIS database:
-- Insert converted WKT into PostGIS
INSERT INTO parcels (name, geom)
VALUES ('Parcel 1', ST_GeomFromText('POLYGON((-77.04 -12.04, -77.03 -12.04, ...))', 4326));Frequently Asked Questions
How do I insert GeoJSON into PostgreSQL / PostGIS?+
You can either convert your GeoJSON to WKT using this tool and insert with ST_GeomFromText(wkt, 4326), or use PostGIS ST_GeomFromGeoJSON(geojson_string).
Are GeoJSON feature properties preserved in WKT?+
WKT represents geometry only. To preserve non-spatial properties alongside WKT, export your layer as a CSV containing a dedicated WKT column with property columns.
WKT Geometry Reference
Not sure your input is valid? Each geometry type has its own page with syntax rules, the mistake that most often breaks it, and PostGIS and Shapely recipes.