Hi Michal,
One suggestion...
There are two ways (at least :-) to do this in a RDBMS. You can have the
spatial relationship implicit in the feature geometries, so a spatial query is
used, for example, to determine the cities within a country:
select * from polygons a, polygons b
where a.type =
It should be all in share folder. Note extensions is not in contrib its in
root of share so in the zip you should see a share that has
share/
contrib
extension
I think the older zip may have had it not in share, which was incorrect.
The batch script provided should copy the relevant files
All,
You probably want to add in lines as well, for doing buffered searches from
along Railraod routes for example.
bobb
>>> Michal Kubenka wrote:
Actually what we need is some hierarchical base for relationship between
countries, cities, regions, etc. Main goal of the application wil
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
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
I was wondering if someone could help me about implementing a bezier or spline
method to smooth data, perhaps some extra software to be installed/connected to
PostGis to do this, eg, R, any idea will be very welcome, thanks.
___
Are you planning to store multiple versions of these polygons, for zoom layers?
Generally you need a high res version (eg: coastline) when zoomed in (large
scale) and a lower resolution version when zoomed out (you can't see & don't
need the detail.
This may or may not have an impact on your ev
Hmm much easier with Postgis Topology...
(thanks Brent for the Topology example)
By the way, is it the right way to use topology to simplify a layer ?
create table new_dept as (
select gid, code_dept, (st_dump(geom)).*
from departement
);
create index new_dept_geom_gist on new_de
>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
Thank you for reply.
But I'm afraid that such solution won't fit our system, because for
example there can be situation when POI belong to region. And also I think
it can cause some problems with ORM.
Michal K.
On Mon, Apr 9, 2012 at 2:22 PM, Francois Hugues
wrote:
> I think it could be better
Hi all,
I'm trying to install the 2.0.0 on Windows,
Normally I copy the binary structures into the PostgreSQL\9.1 files (i.e.
contrib --> contrib), and run CREATE EXTENSION postgis;
but with these new binaries, there are almost no similar files to copy from
to.
Can anyone advise on how to copy th
>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.
I think it could be better to have a table for each kind of object because they
will have different attributes (for an example, in a matter of scale, a POI
belong to a city, a city belong to a province which is part of a sub_region
which is included into a state and the continent is composed of
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
15 matches
Mail list logo