Thanks for the quick answer. Just read your writeup on the subject [1]. This
looks like a _very nice_ addition and should be extremely helpful. I've got
some experimenting to do!
-=- Jerry
[1]
http://strk.keybit.net/projects/postgis/Paris2011_TopologyWithPostGIS_2_0.pdf
In otherwords, you
On Wed, Apr 11, 2012 at 11:47:02AM -0400, Jerry Carter wrote:
> I might have a geometry for a country and separate geometries for the
> next layer of administrative regions (e.g. states in the United States).
> But there are often minor differences in the polygons such that the
> polygon for the c
Question out ignorance because I was not aware that this capability existed.
I might have a geometry for a country and separate geometries for the next
layer of administrative regions (e.g. states in the United States). But there
are often minor differences in the polygons such that the polygo
Thank you.
On Wed, Apr 11, 2012 at 2:29 PM, Sandro Santilli wrote:
> On Mon, Apr 09, 2012 at 11:59:14PM +0200, Michal Kubenka wrote:
> > Actually what we need is some hierarchical base for relationship between
> > countries, cities, regions, etc.
>
> PostGIS topology supports hirearchical modeli
On Mon, Apr 09, 2012 at 11:59:14PM +0200, Michal Kubenka wrote:
> Actually what we need is some hierarchical base for relationship between
> countries, cities, regions, etc.
PostGIS topology supports hirearchical modeling of layers, with each object
in upper layer defined by items of the lower lay
,
the optimal one is defined by your use case: the sorts of queries you want to
apply.
--- On Tue, 4/10/12, Michal Kubenka wrote:
From: Michal Kubenka
Subject: Re: [postgis-users] How to design a database for continents,
countries, regions, cities and POIs?
To: pcr...@pcre
gt;
> I'd say there are several approaches you could take to build a viable
> database, the optimal one is defined by your use case: the sorts of queries
> you want to apply.
>
>
> --- On *Tue, 4/10/12, Michal Kubenka * wrote:
>
>
> From: Michal Kubenka
> Subje
: the sorts of queries you want to
apply.
--- On Tue, 4/10/12, Michal Kubenka wrote:
From: Michal Kubenka
Subject: Re: [postgis-users] How to design a database for continents,
countries, regions, cities and POIs?
To: pcr...@pcreso.com
Cc: "PostGIS Users Discussion"
Date: Tuesday,
ite what you are
describing, but a robust & well tested model for global roads & related spatial
data, which does not use Postgis at all.
http://booki.flossmanuals.net/openstreetmap/_draft/_v/1.0/the-osm-data-model/
--- On Mon, 4/9/12, mkubenka wrote:
From: mkubenka
Subject: [post
ed
> spatial data, which does not use Postgis at all.
>
>
> http://booki.flossmanuals.net/openstreetmap/_draft/_v/1.0/the-osm-data-model/
>
> --- On *Mon, 4/9/12, mkubenka * wrote:
>
>
> From: mkubenka
> Subject: [postgis-users] How to design a database for continents
Actually what we need is some hierarchical base for relationship between
countries, cities, regions, etc. Main goal of the application will be
collecting data from many sources about specific cities, regions,
countries and so on, and store it in database. Let's say we will have city
Rome, we collec
for global roads & related spatial
data, which does not use Postgis at all.
http://booki.flossmanuals.net/openstreetmap/_draft/_v/1.0/the-osm-data-model/
--- On Mon, 4/9/12, mkubenka wrote:
From: mkubenka
Subject: [postgis-users] How to design a database for continents, countries,
region
>Thank's for your reply.
>
>I think we'll go same ways as you describe - use two main tables `polygons`
>and `points` and couple supporting tables which handle relationships
>and additional content.
>
>Michal K.
Hi,
If you plan to use two tables of kind polygons and point, and don't plan to
use a
Thank's for your reply.
I think we'll go same ways as you describe - use two main tables `polygons`
and `points` and couple supporting tables which handle relationships
and additional content.
Michal K.
On Mon, Apr 9, 2012 at 3:05 PM, Andrea Peri wrote:
> >My question is how to design database
ractions.net
> Objet : [postgis-users] How to design a database for continents,
> countries, regions, cities and POIs?
>
> I'm brand new to GIS programming and I am designing a GIS application.
> Target
> is to create system with continents, countries, regions (including states,
>My question is how to design database for this system? I was thinking of 2
>tables polygons and points, but I'm not sure if it's good way of thinking.
Hi,
we chhose by desing to use two table for the geometries (lines and
polygons).
And many tables to link the geometries inside these two tables.
ign a database for continents, countries,
regions, cities and POIs?
I'm brand new to GIS programming and I am designing a GIS application. Target
is to create system with continents, countries, regions (including states,
sub-regions, provinces), cities and places in cities. Each of this ele
I'm brand new to GIS programming and I am designing a GIS application. Target
is to create system with continents, countries, regions (including states,
sub-regions, provinces), cities and places in cities. Each of this elements
will contain some text information and related stuff. As database we a
18 matches
Mail list logo