Skip to content
This repository has been archived by the owner on Dec 26, 2017. It is now read-only.

Used Features vs Mapped Features Analysis #258

Closed
lukasmartinelli opened this issue Apr 19, 2016 · 2 comments
Closed

Used Features vs Mapped Features Analysis #258

lukasmartinelli opened this issue Apr 19, 2016 · 2 comments
Assignees
Milestone

Comments

@lukasmartinelli
Copy link
Member

Incorporate the script from #255 https://gist.github.com/ImreSamu/fb1cf6f78226aefb16b671ebf071afeb#file-sql_output-txt from @ImreSamu into the /tools section so we can create reports by just running the Docker container.

@lukasmartinelli
Copy link
Member Author

Can you @ImreSamu just commit the SQL script to the folder /tools/mapping-qa-report (or something like this) since it is your code?

https://gist.github.com/ImreSamu/fb1cf6f78226aefb16b671ebf071afeb#file-sql_output-txt

I will then hack the bash script, Docker container and docker-compose definition around it. This will help.

ImreSamu added a commit to ImreSamu/osm2vectortiles that referenced this issue Apr 19, 2016
…sm_id-s

draft code; current know limitation
* current  imposm3 mapping osm_id is not uniq :  "type_mappings" without "use_single_id_space": true,

expected output ( hungary osm extract )

           tid           | allrec | usedrec |                                 osmlist                                 |               layerlist               | percent
-------------------------+--------+---------+-------------------------------------------------------------------------+---------------------------------------+---------
 osm_admin_linestring    |  11284 |     813 | {osm_admin_linestring}                                                  | {admin_layer}                         |    7.20
 osm_aero_*              |    643 |     643 | {osm_aero_linestring,osm_aero_polygon}                                  | {aeroway_layer}                       |  100.00
 osm_airport_*           |    119 |     119 | {osm_airport_point,osm_airport_polygon}                                 | {airport_label_layer}                 |  100.00
 osm_barrier_*           |  22880 |   22880 | {osm_barrier_linestring,osm_barrier_polygon}                            | {barrier_line_layer}                  |  100.00
 osm_building_*          | 604304 |  604304 | {osm_building_polygon_gen0,osm_building_polygon}                        | {building_layer}                      |  100.00
 osm_housenumber_*       | 108376 |  108376 | {osm_housenumber_point,osm_housenumber_polygon}                         | {housenum_label_layer}                |  100.00
 osm_landuse_*           |  79337 |   79337 | {osm_landuse_polygon,osm_landuse_polygon_gen0,osm_landuse_polygon_gen1} | {landuse_overlay_layer,landuse_layer} |  100.00
 osm_mountain_peak_point |   3235 |    3235 | {osm_mountain_peak_point}                                               | {mountain_peak_label_layer}           |  100.00
 osm_place_*             |  12269 |    6921 | {osm_place_geometry}                                                    | {place_label_layer}                   |   56.41
 osm_poi_*               | 120793 |   75108 | {osm_poi_point,osm_poi_polygon}                                         | {poi_label_layer}                     |   62.18
 osm_rail_station_point  |   2990 |    2990 | {osm_rail_station_point}                                                | {rail_station_label_layer}            |  100.00
 osm_road_geometry       | 522469 |  522469 | {osm_road_geometry}                                                     | {road_layer,road_label_layer}         |  100.00
 osm_water_linestring    |  31075 |   20458 | {osm_water_linestring}                                                  | {waterway_layer,waterway_label_layer} |   65.83
 osm_water_polygon_*     |  10496 |   10496 | {osm_water_polygon_gen1,osm_water_polygon}                              | {water_layer,water_label_layer}       |  100.00
(14 rows)

ref: osm2vectortiles#258
@ImreSamu
Copy link
Contributor

Done .. see #259

Modify , adapt or drop as you like :)

I would like to create other QA scripts,

  • so it would be better if there will be some meta tables for the views

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants