Perhaps style sheets to do this exist somewhere already but can't find them. If you find already existing sheets that I have the rights to use, I'll pay you for finding them. If not, I'm looking for someone to create them.
I have imported OSM data for the UK into a Postgres9.5/postgis2.2 db. I use QGIS 2.8 to connect to the db to visualise the data. I need style sheets created for each table:
A sample of data the roads table and full schema is attached. Each table has columns representing the tags of the stored info which the style sheet will use to know how to render the item. As they represent tags, most columns are empty as there are many possible tags and usually only a few set.
Full tag info can be found at https://taginfo.openstreetmap.org (a lot of info).
Note planet_osm_roads does not only contain roads, it also has things like harbours and waterways etc.
A technical point, the osm data was loaded with the osm2pgsql tool using the --hstore option so any tags that don't fit in the columns are stored in the hstore column.
It's essential that you like doing this sort of design/rendering (or online searching) work - there's no point taking this task if you're going to find it a pain. In my experience of pph that never works out if you don't enjoy the task.
If there is anything else you need to be able to consider this task, please get in touch.
Ian O.98% (8)
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Hi Ian, do you require vector data for the UK, or data for other countries? I can supply OS open data for the UK, and advise on other open data GIS resources for other countries.Ian O.05 May 2017
No thank you. I already have the data I need from OSM.
I can't see any files attached at the moment.
If you could upload them when you get a sec I'll take a look and see if this is something I can help you with.
Aleks.Ian O.05 May 2017
Thanks Aleks, now uploaded