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

[Wolfgang Qual]

Hi José/list
thanks for the hint. However, the extension will not help to _identify_ 
wrong addresses. This can only be done by selecting the "empty" elements 
in the joined table. And these records I am interested in.
"Broken" was not the correct description for misspelled addresses, sorry 
for my mistake.

Best,
Wolfgang


José Antonio Canalejo Alonso schrieb:
> 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
>>     
>
>
>
>       
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>   

-- 

	*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