I should have mentioned that it's not considered good practice to have more than one geometry column per table, and hence more than one geometry object per row. This makes sense if you think of rows as representational instances of real world objects. Chris Hermansen [email protected] tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.840.4625 Timberline Natural Resource Group · www.timberline.ca 401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5
-----Original Message----- From: Nenad Milasinovic <[email protected]> Date: Mon, 13 Jul 2009 07:43:17 To: <[email protected]> Subject: Re: [postgis-users] PostGIS-PostgreSQL Thanks Chris, However maybe better question will be can spatial and non-spatial data be saved in one PostgreSQL table? Precisely, is it possible to have table with some spatial columns (geometry columns) and with some ordinary columns (non-spatial) and is it good practice? From your answer i can conclude that it is possible to have table without spatial data that refers to some spatial table through foreign key? Chris Hermansen wrote: > > This is a part of good database design. Street name, which can be changed, > is only stored in one location. > > This is part of "normalization". This practice relates to any / all > databases > ------Original Message------ > From: Nenad Milasinovic > Sender: [email protected] > To: [email protected] > ReplyTo: PostGIS Users Discussion > Subject: [postgis-users] PostGIS-PostgreSQL > Sent: Jul 13, 2009 06:18 > > Hello, > > I have some questions relating to PostGIS and PostgreSQL. > I am interested how GEO-data from PostGIS are connected to data in > PostgreSQL. > Say that we have vector layer of all city streets in PostGIS table, with > some street attributes (e.g. street name). > Say also that we have all data about locations in PostgreSQL table. That > data contains information about location street also. > What i want to accomplish is that when user change street name is > PostGIS table, that street name should automatically be changed in > all locations which belongs to that street. I am interested is there any > connection between tables in PostGIS and PostgreSQL > that could automatize this process, or i need to update all locations > with new street data by myself. > > Thanks. > > > > > -- > Nenad Milasinovic > Software Development and Testing > > --- > > "ZESIUM mobile" d.o.o. > Valentina Vodnika 8/9 > 21000 Novi Sad > Serbia > Tel: +381 (0)21 472 15 48 > Fax: +381 (0)21 472 15 49 > Mob: +381 (0)61 231 41 20 > E-mail: [email protected] > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > Chris Hermansen [email protected] > tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.840.4625 > Timberline Natural Resource Group · www.timberline.ca > 401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5 > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- View this message in context: http://www.nabble.com/PostGIS-PostgreSQL-tp24461543p24463072.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
