[postgis-users] mapping multi dependencies

[kaotika at gmx.de]

I have a simple unnormalized table and didn't know how to normalize it in the correct way. The species field depends on the category field. How can I map this?

gid     the_geom        category            species
0       Point 10, 10    broad-leaved tree   chestnut
1       Point 20, 10    conifer             fir
2       Point 10, 0     conifer             spruce
3       Point 0, 0      broad-leaved tree   oak
4       Point 0, 10     broad-leaved tree   oak
5       Point 20, 0     conifer             spruce
6       Point 20, 20    broad-leaved tree   hazel

-- 
NEU: FreePhone - kostenlos mobil telefonieren!			
Jetzt informieren: http://www.gmx.net/de/go/freephone