[postgis-users] PostGIS-PostgreSQL

Suhr, Ralf Ralf.Suhr at itc-halle.de
Mon Jul 13 07:55:02 PDT 2009


A geometry column is only a type like integer or text for postgresql.
See http://postgis.refractions.net/documentation/manual-1.3/ch04.html#id2572181


-----Ursprüngliche Nachricht-----
Von: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] Im Auftrag von Nenad Milasinovic
Gesendet: Montag, 13. Juli 2009 16:43
An: postgis-users at postgis.refractions.net
Betreff: 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: postgis-users-bounces at postgis.refractions.net
> To: postgis-users at postgis.refractions.net
> 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: nenad.milasinovic at zesium.com
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> Chris Hermansen        chris.hermansen at timberline.ca
> 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 postgis-users at postgis.refractions.net
> 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 postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list