QGIS style sheets to render OSM data (PostgreSQL/postgis) like OSM or Google maps
- or -
Post a project like this2529
$$
- Posted:
- Proposals: 1
- Remote
- #1553527
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 - 2 weeks
I'm looking for QGIS style sheets to render OSM data held in a Postgres/PostGIS db to look like Google Maps.
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:
planet_osm_line
planet_osm_point
planet_osm_polygon
planet_osm_roads
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.
Thank you,
Ian
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:
planet_osm_line
planet_osm_point
planet_osm_polygon
planet_osm_roads
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.
Thank you,
Ian
Ian O.
98% (10)Projects Completed
13
Freelancers worked with
12
Projects awarded
33%
Last project
26 Mar 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification 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 2017No thank you. I already have the data I need from OSM.
-
Hi Ian,
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.
Regards,
Aleks.Ian O.05 May 2017Thanks Aleks, now uploaded
409208404203
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies