[postgis-users] Select polygons within polygon with PostGIS 2.0

[Michal Zimmermann]

I'm digging deeper into topology model of storing spatial data, but
what I can't see is HOW I can use it for the purpose I started this
thread for. Assuming I have a topology created for the counties... I'm
sort of stuck what to do next. How do I go for my original goal -
selecting all districts of a given county - with topology?

On 10/11/12, Michal Zimmermann <zimmicz at gmail.com> wrote:
> Got it! There was no username associated with the search_path and it
> seems that was causing the trouble.
>
> On 10/11/12, Michal Zimmermann <zimmicz at gmail.com> wrote:
>> Variable search_path for postgistemplate DB has the following values:
>> "$user", public, topology.
>>
>> On 10/11/12, Michal Zimmermann <zimmicz at gmail.com> wrote:
>>> How do I find out?
>>>
>>> On 10/11/12, Sandro Santilli <strk at keybit.net> wrote:
>>>> On Thu, Oct 11, 2012 at 09:30:30AM +0200, Michal Zimmermann wrote:
>>>>> On 10/11/12, Sandro Santilli <strk at 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 at 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
>


-- 
Michal Zimmermann (zimmi)
WWW: http://www.zimmi.cz