mappa delle strade dai nomi confusi di Trento
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
data
.gitignore
README.md
bundle.js
index.html
main.js
package.json

README.md

strade-nomi-confusi

Map of the streets with the confused names in Trento

Demo

Algorithms

Data

data/
├── highway.json		GeoJSON original data downloaded from Openstreetmap by Overpass
├── highway.csv			Main properties without geometries
├── highway.sqlite		Sqlite version from csv, to group streets by names and filter commons *bad words* (via,piazza,strada...)
├── highway_blacklist_name.csv 	Commons *bad words* generated by complete list of names
└── highway_distinct_name.csv 	List of distinct names

Bad words

How to generate a list of commons bad words

SQL Query:

SELECT DISTINCT LOWER(SUBSTR(name, 0, INSTR(name, ' '))) AS word1
FROM highway 
WHERE highway.highway <> '' 
ORDER BY word1

highway.sqlite -> highway_distinct_name.csv:

Usage

npm install
npm start