2

I want to know how to import a layer of polygons that I have exported from a database in postgis to txt format to my dataset. I have used the ST_GeomFromText function but it does not identify the geometry.


I have passed the geometry to geojson from postgis but continuous CARTO is not to identify me as a geometry in the dataset. An example of the "coordenada" field would be:

{"type":"MultiPolygon","coordinates":[[[[443954.068437832,4474249.04503992],[443953.121781595,4474248.30754893],[443952.38433774,4474249.25416733],[443953.330941997,4474249.99165832],[443954.068437832,4474249.04503992]]]]}

I'm importing it from csv as the CARTO example:

name, geojson "Null Island", "{" "type" ":" "Point" "," "coordinates" ": [0,0]}"

closed as too broad by aldo_tapia, whyzar, BERA, mgri, HDunn Nov 6 '17 at 17:58

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

1

I would recommend converting your layer of polygon to geojson which can reside in a text file or format as you are interested in.

ST_AsGeoJSON

Return the geometry as a GeoJSON element.

Not the answer you're looking for? Browse other questions tagged or ask your own question.