
QGIS style sheets to render OSM data (PostgreSQL/postgis) like OSM or Google maps
- or -
Post a project like this3221
£285(approx. $385)
- Posted:
- Proposals: 3
- Remote
- #1470269
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
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 but by default it isn't visualised in a good way.
I'm looking for QGIS style sheets to render the data to look like a useful and pretty map - either like the OSM map (www.openstreetmap.org) or Google Maps.
I expect 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 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.
I have only pulled the data for the UK but may extend it at a later date. There will likely be ongoing work to keep the style sheets up to date.
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
I'm looking for QGIS style sheets to render the data to look like a useful and pretty map - either like the OSM map (www.openstreetmap.org) or Google Maps.
I expect 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 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.
I have only pulled the data for the UK but may extend it at a later date. There will likely be ongoing work to keep the style sheets up to date.
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,
Please let me know If you have a limited budget, . I'm open to discuss further for a fixed budget if you need.
336973
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