Comments (3)
Using the SQL request SELECT DISTINCT `town` FROM `identity` ORDER BY `identity`.`town` ASC LIMIT 250
in https://adminer.enthic.fr, it's possible to quickly check address parsing error, and there is about 250, including town starting with a space (which is not really an error but can be improve) :
_ DONT EXPORT ET LIVRAISO
_29, CHEMIN DE VIGNEAU
- 51 WORSHIP STREET
- AUDERVILLE
- CAP D'AGDE
- COMPTE DE RESULTAT AU 3
- COURNON-D
- DAMERY
- LAN
- PARIS
- PETIT COURONNE
- PLOUER SUR RANCE
- SAINT GERMAIN DES VAUX
- SAINT-BRIEUC
- SAINT-MARTIN BOULOGNE
- SALIN DE GIRAUD
- SAMT-BEAUZIEE
, 22530 MUR DE BRETAGNE
, AVENUE DE PARIS-50100-
, AVENUE DES ANDES, 91940
, AVENUE DES GRILLONS 627
, AVENUE EUG
, RRUE ANDR
, RUE D
, RUE DE LA MAL ECLUSE
, RUE DES FIEFS 27310 FLA
,00 EUROS
,ALL
,ROUTE DE SAINT ANGE, 749
.
. BRUXELLES
. D
. ENGAGEMENT
. SAINT-LEONARD
. T
. WINCHESTER
.13007 MARSEILLE
.50...000.)
.MONTAREN ET ST MEDIERS
"ROYAUME-UNI"
(13763) LES MILLES
(40090) SAINT PERDON
(ALLEMAGNE)
(ANGLETERRE ET PAYS DE GA
(ETATS-UNIS)
(I)AA
(LA) PORTE DU DER
(LE) MONTSAUGEONNAIS
(LE) POIZAT-LALLEYRIAT
(LES) PREMIERS SAPINS
(LUXEMBOURG)
0
0 RUE AMPERE 13100 AIX EN
000
000 LE PUY EN VELA Y
000 SAINT-BR1EUC
000012
009 PARIS
070 METZ BORNY
0CORPS NUDS
0PIO
1
1 0 N
1 CROWBROOK ROAD ASKETT
1 PALK STREET
1 RUE SAINT VICTOR A BEZI
100 AIX EN PROVENCE
100 CHERBOURG EN COTENTIN
100 SAINTES
1000 ALEN
110 752 R.C.S. ALEN
111-1 DU CODE DE
111-1 DU CODE DE COMMERCE
111-1 DUCODE DE
112 LA DESTROUSSE
124 ST BARTHELEMY D
140GC
14790
174086084
18 WAMBRECHIKS
2
200 SETE
201 LISBOA
210 BUGNIERES
220 HESINGUE
230 SAINT PARGOIRE
233 763 RCS ANGERS
240 PEYPIN D'AYGUES
25 RUE BALZAC 75008 PARIS
26741
268 HAYNECOURT
28300
28330
3
300 CASTELNOU
306218
330 CHAMPIGNE
33200
346TOTAL II
35
380 MIOS
381 KINGSWAY EAST SUSSEX
39 A LEICESTER ROAD
39 SHEFFIELDSTRAAT 3047
4
4 CORSO LIBERTA
400 CHAMONIX
410 SAUVIAN
43100
435 SAINT GILLES LES HAUT
446 923
5
5
5011 PARIS
502 RCS ANGERS
505 CHELLES
510 BEAUPREAU EN MAUGES
530 AGAY
534 890 RCS REIMS
5506 BB VELDHOVEN
569 144 R.C.S. SAVERNE
570 GOUAREC
5723 ROISSY CHARLES DE GA
586
59 BVD JEAN JAURESADRESSE
591HD(VII)
6
60280
61-1 DU CODE DE COMMERCE
610 ARDRES
630 PLOUGASNOU
637 048
64 00 SAINT-LAURENT-LES-T
64130
654 FATIMA
6700 PUY L EVEQUE
7
700 ST RAPHAEL
726 RCS NANTES
728
73100
73220
74
748,46
75015
754FAFB
77000 LA ROCHETTE
77220
8
825 RCS ANGERS
830 VITORINO DOS PIAS
840
851 AIX EN PROVENCE CEDEX
86220
880 NOISE AU
9
926 FH
973
A
A R
A BIS DU CODE G
A CORUNA
I didn't check postal codes.
from enthic.
Hi @leonarf, Do you agree it has to be fixed but is not a priority right now. This could be fixed after the new database creation and production release?
from enthic.
There is interestingly quite a lot or Portuguese towns!
from enthic.
Related Issues (12)
- Choix du compte pour chiffre d'affaire: consolidé vs. complet HOT 2
- https://github.com/phe-sto/enthic/blob/master/.github/workflows/shellcheck.yml obsolete HOT 1
- Is sh/database-creations.sh still compatible with recent MySQL 8 versions HOT 2
- New metadata file make the `clear_data.sh` script crash HOT 3
- Flask app when simple quote is in denomination on search endpoint HOT 2
- Ajouter un point d'API permettant de télécharger du csv
- Calculer et stocker les déciles des scores par code APE HOT 2
- Ajouter un point d'API permettant de récupérer les déciles HOT 1
- Failed to insert data in bundle and accountability metadata HOT 4
- Compute annual statistics test fail HOT 1
- L'entreprise 538348525 a ses chiffres multipliés par 2 en 2018 HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from enthic.