3

I have a .csv file with population data according to specific locations (Points). My problem is that all locations are given in WKB format like that: 0101000020E6100000B953EFEEEEB253C0F15BD4CCCC4C05C0

How can I visualize my data with QGIS? I don't know why there is no simple solution. Because to visualize WKB from a database is no problem. I hope you can help me.

1

I create CSV table with attribute "0101000020E6100000B953EFEEEEB253C0F15BD4CCCC4C05C0" (without header). Then import csv table in PostgreSQL/PostGIS database: first: create table with Point geometry field, WGS1984 SRID

CREATE TABLE layer (coord geometry(Point, 4326));

second: import in table data from scv table

COPY layer("coord") FROM 'D:\data.csv';

Then open QGIS, add PostGIS layer (table layer) and receive point feature with coordinates "-78.79583333;-2.6625". This table in PostgreSQL/PostGIS database you caan easy save/export in shapefile.

  • Hey HasT, thanks a lot. Now I'm able to import WKB to QGIS :) – Cris Aug 23 '13 at 12:03
1

As per your question following plugin QuickWKT will helpful for you.

This plugin opens a dialog where the user can paste(E)WKT and WKB code and see it on the map.

For more details please open this link (Translate this link to the English to understand)

hope it will help for you..

let us know if you have any questions

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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