[postgis-users] How to install Postgresql + Postgis 2.0 on Ubuntu 12-04 LTS
Hi guys!! I'm trying to install Postgresql and PostGis 2.0 on my Ubuntu, so I have doubts and I have been looking for information with google but I didn't find clear information. Someone could help me with this? Thanks, José María ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How to install Postgresql + Postgis 2.0 on Ubuntu 12-04 LTS
Hi José if you are willing to compile source code have a look at this page: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204src Stefano --- 41.95581N 12.52854E http://www.linkedin.com/in/stefanoiacovella http://twitter.com/#!/Iacovellas 2012/10/2 José María jmamu...@gmail.com Hi guys!! I'm trying to install Postgresql and PostGis 2.0 on my Ubuntu, so I have doubts and I have been looking for information with google but I didn't find clear information. Someone could help me with this? Thanks, José María ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Tiger geocoder, Spanish street types are pushed to the end
Attaching to the ticket would be great :) -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of James Marca Sent: Tuesday, October 02, 2012 1:23 AM To: 'PostGIS Users Discussion' Subject: Re: [postgis-users] Tiger geocoder,Spanish street types are pushed to the end Leo and Regina, Thanks for the tips. To follow up, I ended up going in a slightly different direction, as I really wanted the whole segment from one intersection to another, not just the intersection point. My method relies more on regexes than yours, but I also have the advantage that I'm only trying to geocode one data source, not any random address. Unfortunately, my source data is even less consistent than the census in how it treats abbreviations! I'm getting about 70% match rate, and will have to do the rest by process of elimination I think. One thing that might help your effort is I did a quick translation of the abbreviations pdf into a csv document. I can post it to github or attach it to the bug report if you are interested. I use it by testing for both the full name and any possible abbreviations in the regex compare. Regards, James On Thu, Sep 27, 2012 at 04:20:41PM -0400, Paragon Corporation wrote: James, Which version are you using? I assume the 2.1.0SVN one? That we can probably change the structure of a bit since it hasn't been released yet and can probalby get away with change the norm_addy type as well which we've been dragging our feet on a bit Mostly because it brings along a bunch of upgrade issues we'd need to provide for people using tiger already. If you look at the file tiger_2011\tables\lookup_tables_2011.sql The street_type_lookup values is what controls how Camino is treated. That probably will require another field at some point we are guessing to better follow the Tiger Feature name types convention of Prefix Type / Suffix type (and possibly Spanish column) they document in http://www.census.gov/geo/www/tiger/tgrshp2011/TGRSHP2011_TechDoc_E.pd f I think we are missing a bunch too. Haven't bothered reconciling their list with what we have. That's probably a good start. The normalize_address function itself is kinda scary to looku at but you can if you want. We were hoping to modularize it a bit more later. Hope that helps, Leo and Regina http://www.postgis.us -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of James Marca Sent: Thursday, September 27, 2012 4:06 PM To: 'PostGIS Users Discussion' Subject: Re: [postgis-users] Tiger geocoder,Spanish street types are pushed to the end On Thu, Sep 27, 2012 at 03:56:53PM -0400, Paragon Corporation wrote: James, Sadly this is a known issue and one we haven't settled on the best way to fix without resorting to major surgery. oops, my bad. I forgot to look at the open tickets. Here is the ticket for it: http://trac.osgeo.org/postgis/ticket/1118 If you can add your examples to the ticket and add yourself to cc for the ticket that would be great. We'll add these to our regress tests when we finally come up with a palpable fix. I'll do it now In MA we have similar issues, but mostly with french streets locally they are a rare occurrence, but Leo feels your pain about Cali since he's a San Diego boy. I was going to say this might be a problem in other countries, but, duh, Tiger is US-only. Sorry we couldn't be more helpful. I'm a reasonably competent hacker, so if you point me at the right file(s) I'd be happy to try my hand. Regards, James ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How to install Postgresql + Postgis 2.0 on Ubuntu 12-04 LTS
Thanks Stefano, But when I try to follow the steps I get errors. If you could to install everything without problems Could you help me? Please. Thanks again, José María 2012/10/2 Stefano Iacovella stefano.iacove...@gmail.com Hi José if you are willing to compile source code have a look at this page: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204src Stefano --- 41.95581N 12.52854E http://www.linkedin.com/in/stefanoiacovella http://twitter.com/#!/Iacovellas 2012/10/2 José María jmamu...@gmail.com Hi guys!! I'm trying to install Postgresql and PostGis 2.0 on my Ubuntu, so I have doubts and I have been looking for information with google but I didn't find clear information. Someone could help me with this? Thanks, José María ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How to install Postgresql + Postgis 2.0 on Ubuntu 12-04 LTS
I did not write the procedure, but I did install PostgreSQL and PostGIS on Ubuntu compiling both from source. If you can elaborate a bit about the errors you found I am pretty sure that me or many others may help you here. Regards Stefano --- 41.95581N 12.52854E http://www.linkedin.com/in/stefanoiacovella http://twitter.com/#!/Iacovellas 2012/10/2 José María jmamu...@gmail.com Thanks Stefano, But when I try to follow the steps I get errors. If you could to install everything without problems Could you help me? Please. Thanks again, José María 2012/10/2 Stefano Iacovella stefano.iacove...@gmail.com Hi José if you are willing to compile source code have a look at this page: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204src Stefano --- 41.95581N 12.52854E http://www.linkedin.com/in/stefanoiacovella http://twitter.com/#!/Iacovellas 2012/10/2 José María jmamu...@gmail.com Hi guys!! I'm trying to install Postgresql and PostGis 2.0 on my Ubuntu, so I have doubts and I have been looking for information with google but I didn't find clear information. Someone could help me with this? Thanks, José María ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How to install Postgresql + Postgis 2.0 on Ubuntu 12-04 LTS
Jose, Be sure to install geos and postgis in the usr directory on your Ubuntu box, and make sure that libxml2 is there too. I spent all day yesterday trying to do exactly what you're trying to do. The wiki link procedure sent by the previous poster worked for me. Vince --- On Tue, 10/2/12, José María jmamu...@gmail.com wrote: From: José María jmamu...@gmail.com Subject: Re: [postgis-users] How to install Postgresql + Postgis 2.0 on Ubuntu 12-04 LTS To: PostGIS Users Discussion postgis-users@postgis.refractions.net Date: Tuesday, October 2, 2012, 6:07 AM Thanks Stefano, But when I try to follow the steps I get errors. If you could to install everything without problems Could you help me? Please. Thanks again, José María 2012/10/2 Stefano Iacovella stefano.iacove...@gmail.com Hi José if you are willing to compile source code have a look at this page: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204src Stefano --- 41.95581N 12.52854E http://www.linkedin.com/in/stefanoiacovella http://twitter.com/#!/Iacovellas 2012/10/2 José María jmamu...@gmail.com Hi guys!! I'm trying to install Postgresql and PostGis 2.0 on my Ubuntu, so I have doubts and I have been looking for information with google but I didn't find clear information. Someone could help me with this? Thanks, José María ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -Inline Attachment Follows- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How to install Postgresql + Postgis 2.0 on Ubuntu 12-04 LTS
On 3 October 2012 02:07, José María jmamu...@gmail.com wrote: Thanks Stefano, But when I try to follow the steps I get errors. If you could to install everything without problems Could you help me? Please. Thanks again, Hi José, I wrote those instructions, and I frequently test them out on new releases without problems. What are your errors? -Mike ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Drive time and routing directions?
Hey all, I'm looking for recommendations on how to get data that I can use for computing drive times and routing directions in PostGIS + Python. So, if I have some set of polygons X that represents Congressional districts, and I want to compute driving directions from each extremity of each polygon to some set of points Y representing hospitals, and I want to see the average drive timeYou see where this is going? Any suggestions on where to get started? -dx ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] PostGIS 2.0.1 build results in .../postgis-2.0.so: undefined symbol: json_tokener_errors
Hi, This error was seen earlier in the year but it seems it was never resolved. Now i'm experiencing it on Amazon Linux AMI release 2012.03 and I'm stumped so far. make install succeeds yet: $ psql -d yourdatabase -f postgis.sql ... psql:postgis.sql:47: ERROR: could not load library /usr/lib64/pgsql/postgis-2.0.so: /usr/lib64/pgsql/postgis-2.0.so: undefined symbol: json_tokener_errors Additionally, make check results in the same: $ cat /tmp/pgis_reg/regress_log SET BEGIN psql:/home/ec2-user/postgis-2.0.1/regress/00-regress-install/share/contrib/postgis/postgis.sql:47: ERROR: could not load library /home/ec2-user/postgis-2.0.1/regress/00-regress-install/lib/postgis-2.0.so: /home/ec2-user/postgis-2.0.1/regress/00-regress-install/lib/postgis-2.0.so: undefined symbol: json_tokener_errors I'm building on a free, Micro Amazon Linux EC2 instance and it should be reproducible using this Gist (it takes several hours to build everything on a Micro instance): https://gist.github.com/3824423 I have the ./configure, make, and make check output in this Gist: https://gist.github.com/3824387 I also have a test file to verify that linking against libjson-c does indeed work: https://gist.github.com/3824400 Does this imply something still misconfigured for this distribution or my environment causing the build's configure or link commands to generate incomplete/incorrect statements? Lastly, some useful configuration info: $ cat /etc/ld.so.conf include ld.so.conf.d/*.conf /usr/local/lib $ ldconfig -p | grep json libjson.so.0 (libc6,x86-64) = /usr/local/lib/libjson.so.0 libjson.so (libc6,x86-64) = /usr/local/lib/libjson.so libjson-c.so.2 (libc6,x86-64) = /usr/local/lib/libjson-c.so.2 libjson-c.so (libc6,x86-64) = /usr/local/lib/libjson-c.so It'll be much appreciated if someone can help me resolve this. Thanks, Robert smime.p7s Description: S/MIME cryptographic signature ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2.0.1 build results in .../postgis-2.0.so: undefined symbol: json_tokener_errors
Try running... ldd postgis-2.0.so That'll tell you if postgis can't find the json lib. If it can't, try... nm libjson.so | grep json_tokener_errors You may need to try libjson-c.so instead. If the grep doesn't find json_tokener_errors, something is up... -bborie On Tue, Oct 2, 2012 at 7:32 PM, robert rob...@urban4m.com wrote: Hi, This error was seen earlier in the year but it seems it was never resolved. Now i'm experiencing it on Amazon Linux AMI release 2012.03 and I'm stumped so far. make install succeeds yet: $ psql -d yourdatabase -f postgis.sql ... psql:postgis.sql:47: ERROR: could not load library /usr/lib64/pgsql/postgis-2.0.so: /usr/lib64/pgsql/postgis-2.0.so: undefined symbol: json_tokener_errors Additionally, make check results in the same: $ cat /tmp/pgis_reg/regress_log SET BEGIN psql:/home/ec2-user/postgis-2.0.1/regress/00-regress-install/share/contrib/postgis/postgis.sql:47: ERROR: could not load library /home/ec2-user/postgis-2.0.1/regress/00-regress-install/lib/postgis-2.0.so: /home/ec2-user/postgis-2.0.1/regress/00-regress-install/lib/postgis-2.0.so: undefined symbol: json_tokener_errors I'm building on a free, Micro Amazon Linux EC2 instance and it should be reproducible using this Gist (it takes several hours to build everything on a Micro instance): https://gist.github.com/3824423 I have the ./configure, make, and make check output in this Gist: https://gist.github.com/3824387 I also have a test file to verify that linking against libjson-c does indeed work: https://gist.github.com/3824400 Does this imply something still misconfigured for this distribution or my environment causing the build's configure or link commands to generate incomplete/incorrect statements? Lastly, some useful configuration info: $ cat /etc/ld.so.conf include ld.so.conf.d/*.conf /usr/local/lib $ ldconfig -p | grep json libjson.so.0 (libc6,x86-64) = /usr/local/lib/libjson.so.0 libjson.so (libc6,x86-64) = /usr/local/lib/libjson.so libjson-c.so.2 (libc6,x86-64) = /usr/local/lib/libjson-c.so.2 libjson-c.so (libc6,x86-64) = /usr/local/lib/libjson-c.so It'll be much appreciated if someone can help me resolve this. Thanks, Robert ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users