[postgis-users] PostGIS-PostgreSQL

[Chris Hermansen]

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        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


-----Original Message-----
From: Nenad Milasinovic <nenad.milasinovic at zesium.com>

Date: Mon, 13 Jul 2009 07:43:17 
To: <postgis-users at postgis.refractions.net>
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: 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