summaryrefslogtreecommitdiff
path: root/sources/db/pre.sql
Commit message (Collapse)AuthorAge
* Revert "Remove "in_wiki_en" column. Wasn't used."Jochen Topf2015-07-16
| | | | | | | This reverts commit b9e7209f12e755881e9d9f951ba3f715fd4dab14. Turns out the in_wiki_en column is used after all (in the keys/without_wiki_page api call).
* Some experimental code to find unicode properties in keys.Jochen Topf2015-04-28
| | | | | | | | OSM allows nearly all unicode characters in keys and values. This is some experimental code to find keys that contain unusual characters. Currently this is not run or used in the normal setup, but I thought I'd throw it out there in case somebody wants to play with it. I am not sure yet myself where this is going.
* An attempt to classify all keys into 'good', 'bad', and 'unknown'.Jochen Topf2015-03-19
| | | | Of course this is very rough. Could be used to show "bad" keys in editors etc.
* Remove unused fields from tags table.Jochen Topf2015-03-14
|
* Remove deprecated table "selected_tags".Jochen Topf2015-03-06
|
* Add similarity program to check for similar keys.Jochen Topf2015-02-26
| | | | | | This adds the 'similarity' program that checks for similar keys in the taginfo-db database. It is not run yet by the update script, but the supporting database tables etc. are added by this commit.
* Remove spaces at line endings.Jochen Topf2014-09-29
|
* Remove "in_wiki_en" column. Wasn't used.Jochen Topf2014-09-29
|
* Remove in_josm and in_potlatch columns. (Were unused for a while.)Jochen Topf2014-09-29
|
* Use new top_tags table instead of old selected_tags table.Jochen Topf2014-09-29
|
* Prepare for putting project stats in db.keys and db.values.Jochen Topf2014-09-18
|
* Remove last remnants of never-used merkaartor source.Jochen Topf2014-05-20
|
* Add code to create maps for tags.Jochen Topf2014-05-12
| | | | | | | For a long time we had the capability to create overview maps for keys, but never for tags (ie key-value-combinations). This commit now adds code to create maps for frequently used tags. We can't create maps for all tags, because each map takes about 8k in RAM and there are a lot of tags.
* Add in_wiki and in_wiki_en columns to tags and selected_tags tableJochen Topf2013-01-24
|
* Rename (key|tag)pairs to (key|tag)_combinationsJochen Topf2013-01-19
|
* Remove unused prevalent_values field in keys sql tableJochen Topf2013-01-17
|
* Extract prevalent relation member roles.Jochen Topf2013-01-14
|
* Create relation member and role statsJochen Topf2013-01-14
|
* Add support in tagstat for counting key-value-combinationsJochen Topf2011-12-10
|
* fix: distribution map did not work when there were no nodes with a tagJochen Topf2011-10-13
|
* Generate distribution maps for keys on way, tooJochen Topf2011-10-12
| | | | | | | | Until now distribution maps were only generated for keys on nodes. No there are maps for keys on ways, too. (Not for relations, though). This commit also adds command line options for tagstats to define the area you want the map for. Its no longer necessary to recompile tagstats if you want to change this. This commit does not change the UI/API yet, so you still only get the node map.
* new prevalent_values tableJochen Topf2010-11-14
|
* Multiple changesJochen Topf2010-11-13
| | | | | | | * Improved and cleaned up source import scripts * Improved some reports and report overview * New osmium version that uses a better hash function * Some experimental magic to include Javascipt in an easier way (tested in keys.erb)
* New report: characters in keysJochen Topf2010-11-04
|
* Added reportsJochen Topf2010-11-01
| | | | | Added infrastructure for reports and the first report (not finished yet) Preparation for better wiki and merkaartor source inclusion
* Begin of Potlatch supportJochen Topf2010-10-24
|
* first commitJochen Topf2010-10-04