New answers tagged

2

You were almost there... MultiPolygonZ should do the trick: ALTER TABLE urbana_prueba ALTER COLUMN geom TYPE geometry(MultiPolygonZ, 3857) USING ST_Force_3D(geom);


0

You could also create a new column via Field Calculator with the following expression: '["lat"=>'||$y||', "lng"=>'||$x||'],' Then, export your layer in CSV format (as indicated by @ed.hankins). Open the CSV file with a text editor such as Notepad++ in which: replace carriage returns by nothing in order to put all your coordinates on the same line ...


0

Make the layer you want to export the active layer, and paste following code into python console (or execute as script): fn = 'E:\\test.txt' f = open(fn, 'w') for feat in layer.selectedFeatures(): f.write('[') for p in feat.geometry().asPolygon()[0]: f.write('[\"lat\"=>{0:.5f}, \"lng\"=>{1:.5f}], '.format(p[0], p[1])) f.seek(-2, 2) ...


0

right click on the layer you want to export and select save as and choose CSV (comma seperated value) then in the layers part of the OGR options type GEOMETRY=AS_XY I am not sure how to export it to the exact format you want, but you can use excel to batch them into that format after the export. also see: How do I calculate the latitude and longitude ...


0

With your Import ID, you should be able to run an authenticated request to the status endpoint to see what's the status of the upload. The endpoint is: GET /api/v1/imports/<import_id> In your case it would be: https://username.cartodb.com/api/v1/imports/fcbfd6ag-c8df-47b2-8a16-fa8392576f2c?api_key=your_api_key More info on the official docs: ...



Top 50 recent answers are included