Skip to content
OpenStreetMap Quality Analysis Tools
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
docum prerequesites before launching any analysis Apr 29, 2019
img
sql
LICENSE
README.md Update README.md May 3, 2019

README.md

OQ_Analysis

OpenStreetMap Quality Analysis Tools


The prerequisite to use the SQL scripts presented in this repository is to install a PostgreSQL / PostGIS database with the Osmosis PgSnapshot Database and import an OSM file into a PostgreSQL schema (See PostGIS OSM Database with Osmosis PgSnapshot Schema). You also need to load and compile the various functions in the sql folder before running analysis.


SQL Functions

  • OQ_01_Analysis_Table_Ways_Topology.sql PostgreSQL Function (_schema, _date_extract) Main Function for Topology Analysis - Adds table ways_topology with Warnings and error flags.
    > SELECT * from public.OQ_01_Analysis_Table_Ways_Topology('myosm_extract_1', '2018_08_27');

  • OQ_01a_Building_Analysis.sql PostgreSQL Function (id, geometry, tags) -- call for each line Determines orthogonal and irregular polygons. Function applied on each row returns the Eval Json result list with metrics about the polygon and the various angles.
    > SELECT id, tags, public.OQ_01a_Building_Analysis(id, linestring, tags) as eval FROM myosm_extract_1.ways WHERE (exist(tags, 'building')) ;

  • OQ_01b_Topology_Intersect_Analysis.sql PostgreSQL Function (_schema) Topological Analysis detects Polygons Intersects.
    > SELECT id, id_b, teval, eval FROM public.OQ_01b_Topology_Intersect_Analysis(_schema);

See Documentation

Type of problems detected

GNU General Public License v3.0

You can’t perform that action at this time.