[Gvsig_english] gvsig and joins::what to do, if a join does not "work" 100 % - workaround...

[José Antonio Canalejo Alonso]

Hello Wolfgang,
maybe die Normalization extension http://www.gvsig.gva.es/index.php?id=2181&L=2 helps you to repair the table with "broken" addresses.

LG
José
 
DESCRIPTION:

The functionality of breaking up chains of text into different parts and storing them in table fields it is added to gvSIG with the new normalization extension.  These chains of text can have their origin in plain text files or in the different records of a table field.
 --
José Canalejo
CSGIS
Email:jose.canalejo at csgis.de
Web: http://www.csgis.de 



----- Mensaje original ----
> De: Wolfgang Qual <Wolfgang.Qual at muenchen.de>
> Para: Users and Developers mailing list <gvsig_internacional at listserv.gva.es>
> Enviado: jueves, 20 de agosto, 2009 5:43:17
> Asunto: [Gvsig_english] gvsig and joins::what to do, if a join does not "work" 100 % - workaround...
> 
> Hi list,
> as described before, I have to use addresses as a source for geocoding 
> features, like physicians. In order to geocode them, I use a shapefile 
> that contains all addresses of our City as target table.
> The table to geocode is the source table. However, addresses of the 
> source table may be spelled wrong every no and when and it is important 
> to identify and correct those. Unfortunately, selecting those "broken" 
> addresses in the joined table seemed to be useless, since the selection 
> is removed when removing the join. BUT what you can do is the following:
> 1) select broken addresses in joined table
> 2) move selection on top
> 3) remove join
> As the sorting of the table will not change, the broken addresses will 
> remain where they were in step 2). Easy to correct them now (you just 
> have to keep in mind the last record of the selection).
> Hopefully, this workaround will also work in 2.0.
> 
> Best,
> Wolfgang
> -- 
> 
>     *Wolfgang Qual
> 
> * *Referat für Gesundheit und Umwelt*
> Umweltschutz
> Umweltvorsorge
> RGU-UW 11
> 
> Bayerstraße 28a
> 80335 München
> 
> Telefon +49 - 89 - 233 - 4 77 17
> Telefax +49 - 89 - 233 - 4 77 05
> 
> http://www.muenchen.de/umweltatlas
> uw11.rgu at muenchen.de
> Bitte beachten Sie die Hinweise zur elektronischen
> Kommunikation mit der Landeshauptstadt München:
> http://www.muenchen.de/ekomm
> 
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional