Coder Social home page Coder Social logo

Comments (3)

leonarf avatar leonarf commented on June 26, 2024 1

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.

phe-sto avatar phe-sto commented on June 26, 2024 1

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.

phe-sto avatar phe-sto commented on June 26, 2024

There is interestingly quite a lot or Portuguese towns!

from enthic.

Related Issues (12)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.