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
