[postgis-users] Re : postgis-users Digest, Vol 154, Issue 12
Beekk Meess
marabaut at yahoo.fr
Sun Dec 14 02:48:39 PST 2014
may be the solution exist if there is a way to changing the interne schemas(meta data level) of postgis topology
--------------------------------------------
En date de : Sam 13.12.14, postgis-users-request at lists.osgeo.org <postgis-users-request at lists.osgeo.org> a écrit :
Objet: postgis-users Digest, Vol 154, Issue 12
À: postgis-users at lists.osgeo.org
Date: Samedi 13 décembre 2014, 21h00
Send postgis-users mailing list
submissions to
postgis-users at lists.osgeo.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help'
to
postgis-users-request at lists.osgeo.org
You can reach the person managing the list at
postgis-users-owner at lists.osgeo.org
When replying, please edit your Subject line so it is more
specific
than "Re: Contents of postgis-users digest..."
Today's Topics:
1. Re: reverse_geocode not returning
predirabbrev
(Paragon Corporation)
2. neeed help in postgis (Beekk Meess)
3. Re: neeed help in postgis (Beekk
Meess)
4. Re: neeed help in postgis (Stephen
Woodbridge)
5. Re: neeed help in postgis (Sandro
Santilli)
----------------------------------------------------------------------
Message: 1
Date: Fri, 12 Dec 2014 15:45:55 -0500
From: "Paragon Corporation" <lr at pcorp.us>
To: "'PostGIS Users Discussion'" <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] reverse_geocode not returning
predirabbrev
Message-ID: <5967C58D2B2142C1A0DF9F79635F5C20 at O>
Content-Type: text/plain;
charset="us-ascii"
Barry,
Sorry for the late reply. Completely missed this
email. This issue was
fixed in 2.1.4 (as detailed here http://postgis.net/2014/09/10/postgis-2.1.4
)
so just upgrade your postgis_tiger_geocoder to the latest.
If that is not possible you can just replace the
reverse_geocoder function
you have with the one in this ticket. Make sure to set
the path to tiger
though otherwise will get installed in your default schema.
http://trac.osgeo.org/postgis/ticket/2927
Hope that helps,
Regina
http://www.postgis.us
http://postgis.net
-- ORIGINAL MESSAGE --
I have an existing daily utilized PostGIS install on psql
9.2. It was
functioning fine up until the latest change. This change was
the
installation of the tz_world shapefile from http://efele.net/maps/tz/world/
to use lon/lat for getting timezone data.
Since the installation reverse_geocode(); is still
functional; however, I
never get data in predirabbrev. Going back through about
7.9M records that
have been geocoded, not one has N, W, S or any data that (I
would assume)
would come from direction_lookup.
I've attempted to re run indexes with no luck. I installed
the tz shapefile
with: shp2pgsql -S -s 4326 -I tz_world | psql -U postgres
geocoder
Any help would be greatly appreciated!
Thanks!
----------------------------------------------------------------------------
--------------------------
Linux ip-172-16-x-x 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22
03:15:09 UTC
2013 x86_64 x86_64 x86_64 GNU/Linux
---------------------------------------------------
PostgreSQL "9.2.9"
---------------------------------------------------
SELECT extname, extversion
FROM pg_extension;
"plpgsql";"1.0"
"postgis";"2.1.3"
"postgis_topology";"2.1.3"
"fuzzystrmatch";"1.0"
"postgis_tiger_geocoder";"2.1.3"
"plsh";"2"
---------------------------------------------------
"POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921"
PROJ="Rel. 4.8.0, 6
March 2012" GDAL="GDAL 1.9.2, released 2012/10/08"
LIBXML="2.7.6"
LIBJSON="UNKNOWN" TOPOLOGY RASTER"
------------------------------
Message: 2
Date: Sat, 13 Dec 2014 14:43:45 +0000
From: Beekk Meess <marabaut at yahoo.fr>
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] neeed help in postgis
Message-ID:
<1418481825.69311.YahooMailBasic at web171306.mail.ir2.yahoo.com>
Content-Type: text/plain; charset=utf-8
hello,
and when i add an edge for example, all topology
relations are changing by adding an edge. i want to adding
an edge and controlling the changint of topology. i mean i
want to make more then one network edges or faces topology
in the same topologic schema. in reality for example if i
have a bridge above an road. edges representing way in the
under level make a topology and edges connecting with the
bridge making other network topology but all these edges in
the same table. i'm sorry for my bad english again.
------------------------------
Message: 3
Date: Sat, 13 Dec 2014 14:45:14 +0000
From: Beekk Meess <marabaut at yahoo.fr>
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] neeed help in postgis
Message-ID:
<1418481914.556.YahooMailBasic at web171302.mail.ir2.yahoo.com>
Content-Type: text/plain; charset=iso-8859-1
hello, i m very happy to your request, thank your very much,
but i want to use the topology but there is a lot of
instructions like ST_AddEdgeModFace
and when i add an edge for example, all topology
relations are changing by adding an edge. i want to adding
an edge and controlling the changint of topology. i mean i
want to make more then one network edges or faces topology
in the same topologic schema. in reality for example if i
have a bridge above an road. edges representing way in the
under level make a topology and edges connecting with the
bridge making other network topology but all these edges in
the same table. i'm sorry for my bad english
again.
--------------------------------------------
En date de?: Sam 13.12.14, Sandro Santilli <strk at keybit.net> a
?crit?:
Objet: Re: neeed help in postgis
?: "Beekk Meess" <marabaut at yahoo.fr>
Date: Samedi 13 d?cembre 2014, 14h27
On Sat, Dec 13, 2014 at
03:00:07AM +0000, Beekk Meess wrote:
>
hello, i m very happy to your request, thank your very
much
> but i want to use the topology but
there is a lot of instructions like ST_AddEdgeModFace
[...]
But
you're still writing to me privately, while I asked you
to use
the mailing list :)
--strk;
()?
ASCII ribbon campaign? --? Keep it simple !
/\? http://strk.keybit.net/rants/ascii_mails.txt
------------------------------
Message: 4
Date: Sat, 13 Dec 2014 10:50:21 -0500
From: Stephen Woodbridge <woodbri at swoodbridge.com>
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] neeed help in postgis
Message-ID: <548C603D.2050808 at swoodbridge.com>
Content-Type: text/plain; charset=windows-1252;
format=flowed
Hi Beekk,
I can't offer help with the postgis topology, but in
pgrouting we do
this with a zlevel attribute at each node. So the water
might have
zlevel=1, the bridge would have zlevel=2 and if you had a
tunnel going
under the river it might have zlevel=0. Then when we build
our topology
for routing (NOT the same thing as postgis topology), we use
the zlevel
to separate nodes at different levels.
I'm not sure if postgis topology has a similar mechanism.
-Steve
On 12/13/2014 9:45 AM, Beekk Meess wrote:
> hello, i m very happy to your request, thank your very
much, but i
> want to use the topology but there is a lot of
instructions like
> ST_AddEdgeModFace and when i add an edge for example,
all topology
> relations are changing by adding an edge. i want to
adding an edge
> and controlling the changint of topology. i mean i want
to make more
> then one network edges or faces topology in the same
topologic
> schema. in reality for example if i have a bridge above
an road.
> edges representing way in the under level make a
topology and edges
> connecting with the bridge making other network
topology but all
> these edges in the same table. i'm sorry for my bad
english again.
> -------------------------------------------- En date de
: Sam
> 13.12.14, Sandro Santilli <strk at keybit.net> a
?crit :
>
> Objet: Re: neeed help in postgis ?: "Beekk Meess"
> <marabaut at yahoo.fr>
Date: Samedi 13 d?cembre 2014, 14h27
>
> On Sat, Dec 13, 2014 at 03:00:07AM +0000, Beekk Meess
wrote:
>>
> hello, i m very happy to your request, thank your very
much
>> but i want to use the topology but
> there is a lot of instructions like ST_AddEdgeModFace
[...]
>
> But you're still writing to me privately, while I asked
you to use
> the mailing list :)
>
> --strk;
>
> () ASCII ribbon campaign -- Keep it simple
! /\
> http://strk.keybit.net/rants/ascii_mails.txt
>
>
> _______________________________________________
postgis-users mailing
> list postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
------------------------------
Message: 5
Date: Sat, 13 Dec 2014 18:10:26 +0100
From: Sandro Santilli <strk at keybit.net>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] neeed help in postgis
Message-ID: <20141213171026.GF31398 at localhost>
Content-Type: text/plain; charset=us-ascii
On Sat, Dec 13, 2014 at 10:50:21AM -0500, Stephen Woodbridge
wrote:
> Hi Beekk,
>
> I can't offer help with the postgis topology, but in
pgrouting we do
> this with a zlevel attribute at each node. So the water
might have
> zlevel=1, the bridge would have zlevel=2 and if you had
a tunnel
> going under the river it might have zlevel=0. Then when
we build our
> topology for routing (NOT the same thing as postgis
topology), we
> use the zlevel to separate nodes at different levels.
>
> I'm not sure if postgis topology has a similar
mechanism.
No way to avoid a node on intersection with postgis
topology
(and ISO Geometry Topology, differently from ISO Network
Topology)
--strk;
------------------------------
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
End of postgis-users Digest, Vol 154, Issue 12
**********************************************
More information about the postgis-users
mailing list