No subject

spatial data that refers to some spatial table through foreign key?


Chris Hermansen wrote:
>=20
> This is a part of good database design. Street name, which can be changed=
,
> is only stored in one location.
>=20
> This is part of "normalization".  This practice relates to any / all
> databases=20
> ------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
>=20
> Hello,
>=20
> I have some questions relating to PostGIS and PostgreSQL.
> I am interested how GEO-data from PostGIS are connected to data in=20
> PostgreSQL.
> Say that we have vector layer of all city streets in PostGIS table, with=
=20
> some street attributes (e.g. street name).
> Say also that we have all data about locations in PostgreSQL table. That=
=20
> data contains information about location street also.
> What i want to accomplish is that when user change street name is=20
> PostGIS table, that street name should automatically be changed in
> all locations which belongs to that street. I am interested is there any=
=20
> connection between tables in PostGIS and PostgreSQL
> that could automatize this process, or i need to update all locations=20
> with new street data by myself.
>=20
> Thanks.
>=20
>=20
>=20
>=20
> --=20
> Nenad Milasinovic
> Software Development and Testing
>=20
> ---
>=20
> "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
>=20
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>=20
>=20
> Chris Hermansen        chris.hermansen at timberline.ca
> tel+1.604.714.2878 =C2=B7 fax+1.604.733.0631 =C2=B7 mob+1.778.840.4625
> Timberline Natural Resource Group =C2=B7 www.timberline.ca
> 401 =C2=B7 958 West 8th Avenue  =C2=B7 Vancouver BC =C2=B7 Canada =C2=B7 =
V5Z 1E5
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>=20
>=20

--=20
View this message in context: http://www.nabble.com/PostGIS-PostgreSQL-tp24=
461543p24463072.html
Sent from the PostGIS - User mailing list archive at Nabble.com.