Trouble working with a .TSV containing WKT
Geographic Information Systems Asked by Carto0101 on December 2, 2020
I’m working with a .TSV file that represents district boundaries in a portion of a country in Carto. The polygon data is represented in a string column of Well-Known Text lat/long vertices, which I’m having trouble geocoding and visualizing. How would I go about representing the district boundaries as polygons on a map? Here is a screenshot of the data set for your reference. 
One Answer
An update query statement using ST_GeomFromText function like this should do the trick:
UPDATE table_name
SET the_geom = ST_GeomFromText(wkt_polygon, 4326)
Answered by ramiroaznar on December 2, 2020
Add your own answers!
Ask a Question
Get help from others!
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?
Recent Answers
- Peter Machado on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Jon Church on Why fry rice before boiling?
- Joshua Engel on Why fry rice before boiling?
- haakon.io on Why fry rice before boiling?