All tables are the same. Spatial data is just a different type, like date or text.
So you can put the street centreline geometry in the same table as the street name, assumed width, and a foreign key to the maintenance authority. There are two unusual aspects to geometry: first, there is an index type specialized for efficiently searching geometry; second, there are two tables specific to the use of geographic data that together help determine projection and datum. There are also a number of operators and functions that do useful things with geometry. 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
