On Tue, Oct 16, 2012 at 06:02:19AM +, Astrid Bjørnerød wrote:
> But has the TopoGeometry object id from the geometry ?
The TopoGeometry object does NOT have an identifier of your feature.
But you can put a TopoGeometry value into a column of your features table,
thus building the link you're
ctions.net
[mailto:postgis-users-boun...@postgis.refractions.net] På vegne av Sandro
Santilli
Sendt: 15. oktober 2012 17:41
Til: PostGIS Users Discussion
Emne: Re: [postgis-users] Select polygons within polygon with PostGIS 2.0
On Mon, Oct 15, 2012 at 11:37:08AM +, Astrid Bjørnerød wrote:
&g
On Mon, Oct 15, 2012 at 11:37:08AM +, Astrid Bjørnerød wrote:
> No, I have really not understood the way to get a link between the
> relation-table and the originally geo-table.
A TopoGeometry object represents that link.
> I have a table geoTable.
> All I want is to make query which return
ctions)?
Best regards
Astrid
-Opprinnelig melding-
Fra: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] På vegne av Sandro
Santilli
Sendt: 12. oktober 2012 13:27
Til: PostGIS Users Discussion
Emne: Re: [postgis-users] Select polygons
On Fri, Oct 12, 2012 at 10:54:16AM +, Astrid Bjørnerød wrote:
> I have problems understanding the difference between ST_CreateTopogeo,
> CreateTopoGeom and toTopoGeom.
> I have a dataset made by intersection between A and B.
> generated by sql:
> CREATE TABLE sammen.ab AS
> SELECT nextval
On Thu, Oct 11, 2012 at 01:21:25PM +0200, Michal Zimmermann wrote:
> Yep, I have TopoGeometry fields.
> -- counties
> "Topology topo_kraje (12), SRID 4326, precision 0
> 36 nodes, 48 edges, 14 faces, 14 topogeoms in 1 layers
> Layer 1, type Polygonal (3), 14 topogeoms
> Deploy: edpp.kraje.topo
> "
Yep, I have TopoGeometry fields.
-- counties
"Topology topo_kraje (12), SRID 4326, precision 0
36 nodes, 48 edges, 14 faces, 14 topogeoms in 1 layers
Layer 1, type Polygonal (3), 14 topogeoms
Deploy: edpp.kraje.topo
"
-- districts
"Topology topo_orp (13), SRID 4326, precision 0
962 nodes, 1611 edg
On Thu, Oct 11, 2012 at 12:10:34PM +0200, Michal Zimmermann wrote:
> 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 b
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
ALTER ROLE postgres IN DATABASE postgistemplate SET
search_path="$user", public, topology; seems to do the magic.
On 10/11/12, Sandro Santilli 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
>> see
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
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 `
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 wrote:
> Variable search_path for postgistemplate DB has the following values:
> "$user", public, topology.
>
> On 10/11/12, Michal Zimmermann wrote:
>> How do
Variable search_path for postgistemplate DB has the following values:
"$user", public, topology.
On 10/11/12, Michal Zimmermann wrote:
> How do I find out?
>
> On 10/11/12, Sandro Santilli wrote:
>> On Thu, Oct 11, 2012 at 09:30:30AM +0200, Michal Zimmermann wrote:
>>> On 10/11/12, Sandro Santil
How do I find out?
On 10/11/12, Sandro Santilli wrote:
> On Thu, Oct 11, 2012 at 09:30:30AM +0200, Michal Zimmermann wrote:
>> On 10/11/12, Sandro Santilli wrote:
>> > On Thu, Oct 11, 2012 at 09:02:58AM +0200, Michal Zimmermann wrote:
>> >> Hi,
>> >> I tried with SELECT CreateTopology('kraje_top
On Thu, Oct 11, 2012 at 09:30:30AM +0200, Michal Zimmermann wrote:
> On 10/11/12, Sandro Santilli 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: AddGeometry
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?
On 10/11/12, Sandro Santilli wrote:
> On Thu, Oct 11, 2012 at 09:02:58AM +0200, Michal
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 spati
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?
On 10/10/12, Paolo Corti wrote:
> On Wed, Oct 10, 2012 at 12:16 PM, Sandro Santilli wrote:
>>
>> O
On Wed, Oct 10, 2012 at 12:16 PM, Sandro Santilli wrote:
>
> 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
Sandro I am definitely going to read up something on PostGIS Topology,
as it sounds really interesting. Thanks for your advice!
On 10/10/12, Sandro Santilli wrote:
> On Wed, Oct 10, 2012 at 11:44:54AM +0200, Michal Zimmermann wrote:
>> Thanks for the answers guys! I guess the data is ok, I was gi
On Wed, Oct 10, 2012 at 11:44:54AM +0200, Michal Zimmermann wrote:
> Thanks for the answers guys! I guess the data is ok, I was given them
> at the university which had bought it from the GIS company, that's why
> I trust this data source. Also when I try selecting the disctricts
> with ArcMap, it
Thanks for the answers guys! I guess the data is ok, I was given them
at the university which had bought it from the GIS company, that's why
I trust this data source. Also when I try selecting the disctricts
with ArcMap, it works (not with QGIS, though!).
Sandro, would you be so kind and share some
On Wed, Oct 10, 2012 at 10:27:42AM +0200, Michal Zimmermann wrote:
> Hi to all,
> I have a relation representing all the counties in my country and the
> other one containing all the districts - e. g. each and every county
> is composed of several districts. How do I select them with spatial
> quer
Hello,
I don't know how your differents layers has been made but your problem
certainly rely on difference with boundaries even if there are very little
different and just one point not into the county, your district will not be
select.
If you want to correct that you could use a buffer
(st_w
25 matches
Mail list logo
