http://blog.gmane.org/gmane.comp.gis.postgis hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.gis.postgis/31856 <pre>Done. Thanks Francesco Lovergine, and the Debian staff. Could someone update the howto? All the best. -------- Messaggio originale -------- Oggetto: geos_3.3.3-1_i386.changes ACCEPTED into unstable Data: Wed, 23 May 2012 21:47:24 +0000 Mittente: Debian FTP Masters &lt;ftpmaster&lt; at &gt;ftp-master.debian.org&gt; A: Francesco Paolo Lovergine &lt;frankie&lt; at &gt;debian.org&gt;, Debian GIS Project &lt;pkg-grass-devel&lt; at &gt;lists.alioth.debian.org&gt; Accepted: geos_3.3.3-1.debian.tar.gz to main/g/geos/geos_3.3.3-1.debian.tar.gz geos_3.3.3-1.dsc to main/g/geos/geos_3.3.3-1.dsc geos_3.3.3.orig.tar.gz to main/g/geos/geos_3.3.3.orig.tar.gz libgeos++-dev_3.3.3-1_i386.deb to main/g/geos/libgeos++-dev_3.3.3-1_i386.deb libgeos-3.3.3_3.3.3-1_i386.deb to main/g/geos/libgeos-3.3.3_3.3.3-1_i386.deb libgeos-c1_3.3.3-1_i386.deb to main/g/geos/libgeos-c1_3.3.3-1_i386.deb libgeos-dbg_3.3.3-1_i386.deb to main/g/geos/libgeos-dbg_3.3.3-1_i386.deb libgeos-dev_3.3.3-1_i386.deb to main/g/geos/libgeos-dev_3.3.3-1_i386.deb libgeos-doc_3.3.3-1_all.deb to main/g/geos/libgeos-doc_3.3.3-1_all.deb libgeos-ruby1.8_3.3.3-1_i386.deb to main/g/geos/libgeos-ruby1.8_3.3.3-1_i386.deb Changes: geos (3.3.3-1) unstable; urgency=low . * New upstream bugfixing version. This is useful because correctly support new topology-enabled for Postgis 2.0. * Policy bumped to 3.9.3, no changes required. * Debhelper level set to 9. * Patch geos-config revised, partially merged upstream. Override entries for your package: geos_3.3.3-1.dsc - source science libgeos++-dev_3.3.3-1_i386.deb - optional libdevel libgeos-3.3.3_3.3.3-1_i386.deb - optional libs libgeos-c1_3.3.3-1_i386.deb - optional libs libgeos-dbg_3.3.3-1_i386.deb - extra debug libgeos-dev_3.3.3-1_i386.deb - optional libdevel libgeos-doc_3.3.3-1_all.deb - optional doc libgeos-ruby1.8_3.3.3-1_i386.deb - optional ruby Announcing to debian-devel-changes&lt; at &gt;lists.debian.org Thank you for your contribution to Debian. _______________________________________________ Pkg-grass-devel mailing list Pkg-grass-devel&lt; at &gt;lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-grass-devel </pre> Paolo Cavallini 2012-05-24T08:10:15 http://permalink.gmane.org/gmane.comp.gis.postgis/31855 <pre>I think the proj parser might dislike the line breaks you've embedded in your row. Try to get rid of them. Also if you've set your +ellps and +datum you don't need an +a parameter. P. On Wed, May 23, 2012 at 7:00 PM, David Wu &lt;d.wu&lt; at &gt;delcan.com&gt; wrote: </pre> Paul Ramsey 2012-05-24T05:21:18 http://permalink.gmane.org/gmane.comp.gis.postgis/31854 <pre>The 2011 data imported correctly and results look pretty good. On Wed, May 23, 2012 at 3:53 PM, Jeff Rossi [via PostGIS] &lt; ml-node+s17n4997746h37&lt; at &gt;n6.nabble.com&gt; wrote: </pre> Jeff Rossi 2012-05-24T00:05:01 http://permalink.gmane.org/gmane.comp.gis.postgis/31853 <pre>Hi Samran - I'm relatively new to these parts, but I think the answer depends on how much data you're trying to migrate from prior versions of Postgres. If you're just getting started with PostGIS, I'd remove all of those packages and follow the instructions linked below. After that, go ahead and reinstall GeoServer. It should see that you've already install Postgres and PostGIS and be just fine. (I think...) If you need to migrate data, SQL scripts, etc., I'd suggest you read up on migration or get some other advice. I'd like to help, but don't have any experience in those areas. Good luck! ; ) Thanks, Jeff As Jeff said, installing on Ubuntu 12.04 using apt-get is easy, and I've only used stackbuilder once. You don't really need it. postgis-users mailing list postgis-users&lt; at &gt;postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users </pre> Jeff Meyer 2012-05-23T22:21:53 http://permalink.gmane.org/gmane.comp.gis.postgis/31852 <pre>Thanks for the reply Jeff. The extensions in my database is only plpgsql. Nothing else. Also I did not separately install PostGIS. I installed it along with GeoServer using the Synaptic. The complete list of installed packages are as follows, 1. postgresql 9.1 + postgis 1.5.3 2. postgis 1.5.3 3. postgresql 8.4 + postgis 1.5.3 4. opengeo-postgis 2.4.4 I did not install any from the source as in the wiki link you gave. So If I remove, which ones should I remove?? Also since I need it to be connected to Geoserver will removing the package affect the opengeo suite? Thanks &amp; Regards, Smaran Harihar On Wed, May 23, 2012 at 12:45 PM, Jeff Meyer &lt;jeff&lt; at &gt;gwhat.org&gt; wrote: </pre> Smaran Harihar 2012-05-23T21:13:33 http://permalink.gmane.org/gmane.comp.gis.postgis/31851 <pre>The geocoder seems to only report one point per city if that helps with your diagnosis. -- View this message in context: http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997746.html Sent from the PostGIS - User mailing list archive at Nabble.com. </pre> Jeff Rossi 2012-05-23T19:53:05 http://permalink.gmane.org/gmane.comp.gis.postgis/31850 <pre>Mean to add this before - it's an image of the Extensions folder in pgAdmin III: http://s1064.photobucket.com/albums/u361/jeffmegwhat/?action=view&amp;current=postgisextensions.png As Jeff said, installing on Ubuntu 12.04 using apt-get is easy, and I've only used stackbuilder once. You don't really need it. postgis-users mailing list postgis-users&lt; at &gt;postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users </pre> Jeff Meyer 2012-05-23T19:45:36 http://permalink.gmane.org/gmane.comp.gis.postgis/31849 <pre>My house 1506 Tuscaloosa Ave, Holly Hill FL 32117 returned lat: 29.2442380014026 lng: -81.0463110761681 Google Results Latitude: 29.249946 Longitude: -81.05232699999999 Navteq Results Latitude: 29.250059000651042 Longitude: -81.0520100911458 -- View this message in context: http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997743.html Sent from the PostGIS - User mailing list archive at Nabble.com. </pre> Jeff Rossi 2012-05-23T19:44:35 http://permalink.gmane.org/gmane.comp.gis.postgis/31848 <pre>Hi Smaran - I can't speak to what went wrong during your install, but have you double-checked your ability to add extensions through pgAdmin III? You should be able to open your db, navigate to extensions, right click on the extensions label, and then click "New Extension." If PostGIS isn't listed as a possible extension, then something went wrong in the PostGIS install. You may want to then do an 'apt-get remove postgis' and then follow the instructions at: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204. Thanks, Jeff As Jeff said, installing on Ubuntu 12.04 using apt-get is easy, and I've only used stackbuilder once. You don't really need it. postgis-users mailing list postgis-users&lt; at &gt;postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users </pre> Jeff Meyer 2012-05-23T19:42:04 http://permalink.gmane.org/gmane.comp.gis.postgis/31847 <pre>My mistake that is the right name. It the 5 digit zcta. so looks like it imported fine for you and that's not the issue. Will if you can give me an example point, I can check it out. 4997634p4997738.html </pre> Paragon Corporation 2012-05-23T19:32:32 http://permalink.gmane.org/gmane.comp.gis.postgis/31846 <pre>For some reason the table is called fl_zcta5, and it has 983 rows. I am running the script to import tiger 2011 into a separate database. -- View this message in context: http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997738.html Sent from the PostGIS - User mailing list archive at Nabble.com. </pre> Jeff Rossi 2012-05-23T19:25:59 http://permalink.gmane.org/gmane.comp.gis.postgis/31845 <pre>The reverse geocoder uses zcta table where as the geocoder does not. Verify that data is filled. There should be one for each state you load like fl_zcta. That load I added in 2.0.0 so it should be there (assuming you have the 2.0.0 tar ball) and be part of the loading, but not sure I tested it on Linux though so I might have an error somewhere there. You should see it in the loader_lookuptables. Thanks for testing, Regina http://www.postgis.us _____ From: postgis-users-bounces&lt; at &gt;postgis.refractions.net [mailto:postgis-users-bounces&lt; at &gt;postgis.refractions.net] On Behalf Of Jeff Rossi Sent: Wednesday, May 23, 2012 8:38 AM To: postgis-users&lt; at &gt;postgis.refractions.net Subject: Re: [postgis-users] tiger_geocoder import error psql --version psql (PostgreSQL) 9.1.3 postgis-1.5 from ubuntu repo I have the 2010 tiger data, and added the tiger geocoder from the 2.0 download. Perhaps my issue is due to the errors with the import. Thanks, Jeff On Tue, May 22, 2012 at 10:20 PM, Paragon Corporation-2 [via PostGIS] &lt;[hidden email]&gt; wrote: Jeff, Which point for example are you trying to reverse geocode? Mine seems to be working fine but I just have MA data loaded. Also are you using the tiger_2010 or tiger_2011. ��In the 2.1 trunk I have tiger_2011 and even if you are on 2.0 probably the best to use since its designed for the newer tiger data and the newer tiger data has many data quality improvements I am told. ��They also changed the fields quite a bit between tiger_2010 and tiger_2011 releases and no longer offer the state by state folders http structure so I had to change the loader quite a bit to handle that they have all the states now in a single folder. Can you also let me know what version of PostGIS and PostgreSQL you are using? Thanks, Regina http://www.postgis.us _____ View this message in context: Re: &lt;http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997699.html&gt; tiger_geocoder import error Sent from the PostGIS - &lt;http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html&gt; User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users&lt; at &gt;postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users </pre> Paragon Corporation 2012-05-23T18:55:55 http://permalink.gmane.org/gmane.comp.gis.postgis/31844 <pre>Hi, I have already installed PostGIS 2.0 and Postgres 9.3.1 using synaptic package manager. Now when I run your commands in psql console, shpRepo=# CREATE EXTENSION postgis; I am receiving an error, ERROR: could not open extension control file "/usr/share/postgres/9.1/extension/postgis.control": No such file or directory Where did I go wrong? On Wed, May 23, 2012 at 9:58 AM, Brian H Wilson &lt;brian&lt; at &gt;wildsong.biz&gt; wrote: </pre> Smaran Harihar 2012-05-23T17:09:17 http://permalink.gmane.org/gmane.comp.gis.postgis/31843 <pre>Hi there, I need to add a projection to support an imported shapefiles dataset with the following projection: PROJCS [ "Business Analyst Projection", GEOGCS[ "GCS_WGS_1984", DATUM[ "D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]], PRIMEM["Greenwich",0.0], UNIT["Degree",0.0174532925199433]], PROJECTION["Equidistant_Conic"], PARAMETER["False_Easting",0.0], PARAMETER["False_Northing",0.0], PARAMETER["Central_Meridian",-88.02657853618898], PARAMETER["Standard_Parallel_1",41.82305904132364], PARAMETER["Standard_Parallel_2",41.82305804132364], PARAMETER["Latitude_Of_Origin",0.0], UNIT["Meter",1.0] ] I used the following SQL to add the projection to the spatial_ref_sys table: INSERT INTO spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) VALUES (9998, 'EPSG', 9998, 'PROJCS["Business Analyst Projection", GEOGCS["GCS_WGS_1984", DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]], PRIMEM["Greenwich",0.0], UNIT["Degree",0.0174532925199433]], PROJECTION["Equidistant_Conic"], PARAMETER["False_Easting",0.0], PARAMETER["False_Northing",0.0], PARAMETER["Central_Meridian",-88.02657853618898], PARAMETER["Standard_Parallel_1",41.82305904132364], PARAMETER["Standard_Parallel_2",41.82305804132364], PARAMETER["Latitude_Of_Origin",0.0], UNIT["Meter",1.0]]', '+proj=eqdc +lat_0=41.82305904132364 +lon_0=-88.02657853618898 +lon_1=-88.02657853618898 +lon_2=-88.02657853618898 +x_0=0 +y_0=0 +a=6378137.0 +ellps=WGS84 +datum=WGS84 +units=m +no_defs'); When I tried to do a transform test [ update major set geom=transform(geom, 4326) ], I go the following error: ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=eqdc +lat_0=41.82305904132364 +lon_0=-88.02657853618898 +lon_1=-88.02657853618898 +lon_2=-88.02657853618898 +x_0=0 +y_0=0 +a=6378137.0 +ellps=WGS84 +datum=WGS84 +units=m +no_defs': major axis or radius = 0 or not given BTW, I found no documentation that provides a complete listing of parameters I need to set for eqdc projection. Thanks for any hint. DWW ____ This communication may contain information that is confidential, privileged or subject to copyright. If you are not the intended recipient, please advise by return e-mail and delete the message and any attachments immediately without reading, copying or forwarding to others. _______________________________________________ postgis-users mailing list postgis-users&lt; at &gt;postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users </pre> David Wu 2012-05-23T17:00:08 http://permalink.gmane.org/gmane.comp.gis.postgis/31842 <pre> As Jeff said, installing on Ubuntu 12.04 using apt-get is easy, and I've only used stackbuilder once. You don't really need it. I like to experiment with the latest so currently I do install PostGIS from sources. The version in the official Ubuntu repository is still at 1.5.3 There are instructions here for PostGIS 2 packages that look pretty promising: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204 My own grueling details are here: http://wildsong.biz/index.php/PostGIS Feedback welcome. Hope this helps, Brian </pre> Brian H Wilson 2012-05-23T16:58:20 http://permalink.gmane.org/gmane.comp.gis.postgis/31841 <pre>Jeff - Unless someone's updated the packages in the last few weeks, there are some GDAL and GEOS dependencies that won't install properly using that method. José - Have you tried the instructions at: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204? Thanks, Jeff new tools like postgis. postgis-users mailing list postgis-users&lt; at &gt;postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users postgis-users mailing list postgis-users&lt; at &gt;postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users </pre> Jeff Meyer 2012-05-23T16:21:15 http://permalink.gmane.org/gmane.comp.gis.postgis/31840 <pre>why not just sudo apt-get install postgresql-9.1-postgis _______________________________________________ postgis-users mailing list postgis-users&lt; at &gt;postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users </pre> Jeff Rossi 2012-05-23T15:25:17 http://permalink.gmane.org/gmane.comp.gis.postgis/31839 <pre>Someone know how can linstall postgresql-9.1.3-2-linux.run in Ubuntu 12.04? I installed it but I can not to launch stackbuilder to configure new tools like postgis. I need help, please!!! Thanks _______________________________________________ postgis-users mailing list postgis-users&lt; at &gt;postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users </pre> José María Amuedo 2012-05-23T15:08:54 http://permalink.gmane.org/gmane.comp.gis.postgis/31838 <pre>I got it working installed the pg, georuby, and spatial_adapter gems # in app/models/ class PostgisGeocoder &lt; ActiveRecord::Base establish_connection "postgis_geocoder_#{Rails.env}" def self.normalize_address(address_string) query = "SELECT (addy).address As stno, (addy).streetname As street, (addy).streettypeabbrev As styp, (addy).location As city, (addy).stateabbrev As st,(addy).zip FROM normalize_address('#{address_string}') as addy;" norm_addy = self.connection.execute(query) norm_addy[0] end end # in database.yml postgis_geocoder_development: adapter: postgresql database: geocoder username: postgres password: ********* Hope that can help . -- View this message in context: http://postgis.17.n6.nabble.com/calling-tiger-geocoder-functions-from-rails-tp4997646p4997700.html Sent from the PostGIS - User mailing list archive at Nabble.com. </pre> Jeff Rossi 2012-05-23T12:45:08 http://permalink.gmane.org/gmane.comp.gis.postgis/31837 <pre>psql --version psql (PostgreSQL) 9.1.3 postgis-1.5 from ubuntu repo I have the 2010 tiger data, and added the tiger geocoder from the 2.0 download. Perhaps my issue is due to the errors with the import. Thanks, Jeff On Tue, May 22, 2012 at 10:20 PM, Paragon Corporation-2 [via PostGIS] &lt; ml-node+s17n4997688h39&lt; at &gt;n6.nabble.com&gt; wrote: -- View this message in context: http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997699.html Sent from the PostGIS - User mailing list archive at Nabble.com._______________________________________________ postgis-users mailing list postgis-users&lt; at &gt;postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users </pre> Jeff Rossi 2012-05-23T12:37:37 http://permalink.gmane.org/gmane.comp.gis.postgis/31836 <pre>Jeff, Which point for example are you trying to reverse geocode? Mine seems to be working fine but I just have MA data loaded. Also are you using the tiger_2010 or tiger_2011. In the 2.1 trunk I have tiger_2011 and even if you are on 2.0 probably the best to use since its designed for the newer tiger data and the newer tiger data has many data quality improvements I am told. They also changed the fields quite a bit between tiger_2010 and tiger_2011 releases and no longer offer the state by state folders http structure so I had to change the loader quite a bit to handle that they have all the states now in a single folder. Can you also let me know what version of PostGIS and PostgreSQL you are using? Thanks, Regina http://www.postgis.us 4997634p4997681.html </pre> Paragon Corporation 2012-05-23T02:19:52 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.gis.postgis