Sandro,
earlier you said
>One benefit is making the spatial relationships explicit, so that
> you could encode your counties as being composed by the districts,
> and the districts would be composed by faces, which would be defined
> by (shared) edges.
> At that point querying for "all districts in a county" would just be
> a matter of listing the components of a "county" TopoGeometry.

Does this mean it is better approach to have only one topology enabled
layer (in my case districts) with features having some id of which
county they belong to? In the end, I need to have county > districts >
cadastral areas chain (all of them being represented as polygons).
Right now I have both counties and districts layer with topology, but
I can't see a way to join them (e. g. to "select all districts from
counties where county.id = 1").

On 10/11/12, Michal Zimmermann <zimm...@gmail.com> wrote:
> ALTER ROLE postgres IN DATABASE postgistemplate SET
> search_path="$user", public, topology; seems to do the magic.
>
> On 10/11/12, Sandro Santilli <s...@keybit.net> wrote:
>> On Thu, Oct 11, 2012 at 09:49:03AM +0200, Michal Zimmermann wrote:
>>> Got it! There was no username associated with the search_path and it
>>> seems that was causing the trouble.
>>
>> I don't understand it, can you please tell us more about how you fixed it
>> ?
>> The search_path `` "$user", public, topology `` seems sane to me.
>>
>> --strk;
>>
>>>
>>> On 10/11/12, Michal Zimmermann <zimm...@gmail.com> wrote:
>>> > Variable search_path for postgistemplate DB has the following values:
>>> > "$user", public, topology.
>>> >
>>> > On 10/11/12, Michal Zimmermann <zimm...@gmail.com> wrote:
>>> >> How do I find out?
>>> >>
>>> >> On 10/11/12, Sandro Santilli <s...@keybit.net> wrote:
>>> >>> On Thu, Oct 11, 2012 at 09:30:30AM +0200, Michal Zimmermann wrote:
>>> >>>> On 10/11/12, Sandro Santilli <s...@keybit.net> wrote:
>>> >>>> > On Thu, Oct 11, 2012 at 09:02:58AM +0200, Michal Zimmermann
>>> >>>> > wrote:
>>> >>>> >> Hi,
>>> >>>> >> I tried with SELECT CreateTopology('kraje_topo', 4326); and got
>>> >>>> >> the
>>> >>>> >> following error: ERROR: AddGeometryColumn() - invalid SRID. Is
>>> >>>> >> there
>>> >>>> >> something special I need to do before creating topology?
>>> >>>> >
>>> >>>> > The SRID must be in spatial_ref_sys.
>>> >>>> > Did you forget to load spatial_ref_sys.sql ?
>>> >>>>
>>> >>>> No, if I try select * from spatial_ref_sys where srid=4326, I get
>>> >>>> exactly one result. The topology table belongs to topology scheme,
>>> >>>> while the spatial_ref_sys belongs to public scheme, could that be a
>>> >>>> problem?
>>> >>>
>>> >>> Uhm, good question. Is "public" not in your search path ?
>>> >>>
>>> >>> --strk;
>>> >>>
>>> >>>  http://www.cartodb.com - Map, analyze and build applications with
>>> >>> your
>>> >>> data
>>> >>>
>>> >>>                                        ~~ http://strk.keybit.net
>>> >>>
>>> >>> _______________________________________________
>>> >>> postgis-users mailing list
>>> >>> postgis-users@postgis.refractions.net
>>> >>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>> >>>
>>> >>
>>> >>
>>> >> --
>>> >> Michal Zimmermann (zimmi)
>>> >> WWW: http://www.zimmi.cz
>>> >>
>>> >
>>> >
>>> > --
>>> > Michal Zimmermann (zimmi)
>>> > WWW: http://www.zimmi.cz
>>> >
>>>
>>>
>>> --
>>> Michal Zimmermann (zimmi)
>>> WWW: http://www.zimmi.cz
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users@postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>> --
>>
>>  http://www.cartodb.com - Map, analyze and build applications with your
>> data
>>
>>                                        ~~ http://strk.keybit.net
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
> --
> Michal Zimmermann (zimmi)
> WWW: http://www.zimmi.cz
>


-- 
Michal Zimmermann (zimmi)
WWW: http://www.zimmi.cz
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to