en-us http://www.bostongis.com Features the latest GIS tutorials on postgis, mapserver and other GIS technologies Boston GIS (mailto:articles@paragoncorporation.com) DmnrUg http://www.78NLRvzfIwzacsSvHH4hdZWSkQdHROAk.com http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_nearest_neighbor_generic#comment_608 2013-05-06 ronny (mailto:nospam) looking for info http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01_15#comment_601 2013-04-29 jan kordaat (mailto:nospam) Hello Regina, thank you very much! Sorry I missed the R_HOME path in the screen shot. -_- Now lets play with R. With best regards, Peter http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01#comment_588 2013-04-12 Peter Seifert (mailto:nospam) Peter, I fixed your comments. I'll take care of the back slash commenting issue as well. I must have some legacy code in here. http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01#comment_587 2013-04-11 Regina (mailto:nospam) Unfortunately the comment system mask backslashes with another backslash automatically .. ? http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01#comment_586 2013-04-11 Peter Seifert (mailto:nospam) Well R_HOME has to point to: c:\Program Files\R\R-3.0.0 .... Throwing an error would be nice .… http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01#comment_585 2013-04-11 Peter Seifert (mailto:nospam) Hello, I have a strange problem on Windows 7 Enterprise ( 64-bit ). -I installed R (R-3.0.0-win.exe). -Set R_HOME to c:\Program Files\R\R-3.0.0\bin\x64\ and appended this path to PATH as well -Copied plr.dll to c:\Program Files\PostgreSQL\9.1\lib\ -Restarted the PostgreSQL-server -Installed plr with plr.sql in the database -Example took forever: http://lists.pgfoundry.org/pipermail/plr-general/2012-December/000719.html Furthermore queries using those 'hanging' plr functions can't be killed and the PostgreSQL-server can't be stopped nicely ... So I reinstalled PostgreSQL ( postgresql-9.1.9-1-windows-x64.exe ) together with PostGIS using the 'Application Stack Builder'. -Added PostGIS to the same database: CREATE EXTENSION postgis No success. The 'Hello, world' example, 'SELECT * FROM plr_environ();' and 'SELECT plr_array_accum('{23,35}', 42);' work. However, 'SELECT load_r_typenames();' hangs again ... Any idea what is causing this? A missing R package perhaps? Giving postgres all rights on the R directory did not make any change either. Thank you very much in advance, Peter http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01#comment_584 2013-04-11 Peter Seifert (mailto:nospam) I typed too fast: '\i' not '\\i'. http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01#comment_552 2013-02-13 Luis (mailto:nospam) ...it should be '/i' not '//i' http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01#comment_551 2013-02-13 Luis Carrasco (mailto:nospam) I had better luck installing plr in Win 64 when (1) restarted not only PG but also the PC and (2) ran plr.sql from psql command line using: \\i 'C:/pathto/plr.sql' PG Admin will run plr.sql once, but if you try to run it again in another database it won't as some of the elements maybe have already been created and PG Admin will (I think) run a sql script only if all of it can be run. Hope this is helpful. http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01#comment_550 2013-02-13 Luis Carrasco (mailto:nospam) A few extra tips based on what I encountered, now that it's almost 19 months later. (wow time flies) :! First I needed to INSERT the following columns, in addition to those noted in the tutorial: ALTER TABLE planet_osm_point ADD COLUMN "generator:source" text; ALTER TABLE planet_osm_polygon ADD COLUMN "generator:source" text; Next, I had to grab the latest .py generation files. If you want to play it safe, use an SVN client to pull them from the address in the tutorial. Alternatively you can grab them at the following address, but they'll gradually go stale after today: http://www.cartometric.com/uploads/other/osm_mapnik.zip Last, the two NaturalEarth downloads have moved as follows (the http:// stuff appearing twice is _correct_, it won't work if it's not doubled-up like you see here): http://www.naturalearthdata.com/http//www.naturalearthdata.com/download/110m/cultural/ne_110m_admin_0_boundary_lines_land.zip http://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/cultural/ne_10m_populated_places.zip And when you unzip them into the world_boundaries folder mentioned in the tutorial, make sure they are named as follows, (if they are otherwise, generate_xml.py will complain): 110m_admin_0_boundary_lines_land.shp ne_10m_populated_places.shp http://www.bostongis.com/PrinterFriendly.aspx?content_name=generating_osm_tiles#comment_525 2012-12-18 Elijah Robison (mailto:nospam) Mike, Sorry when you said reverse geocoding I assumed you were talking about the reverse geocoder function/geocoder packaged with PostGIS. Now I realize you might be asking about a query against OSM data. What query are you trying to run? http://www.bostongis.com/PrinterFriendly.aspx?content_name=loading_osm_postgis#comment_523 2012-12-07 Regina (mailto:nospam) Not enough information to tell. Which version of tiger geocoder are you running? the 2.0 or the 2.1.0 in trunk. Which point are you testing? Which state do you have loaded? Often time people reverse the order of the points. e.g. the point should be long lat and not lat long. That's the common mistake people make and in that case you'll get nothing back. Other causes are failure in loading. You want to make sure that in tiger_data schema for state in question that you have faces,edges,place,featnames loaded. For 2.1 you need to run the national load first that loads in state, county, zip data. Otherwise the reverse geocode will not return anything. http://www.bostongis.com/PrinterFriendly.aspx?content_name=loading_osm_postgis#comment_522 2012-12-07 Regina (mailto:nospam) just curious why reverse geocoding doesnt pull any data for an imported state when i search the coordinates? i followed the import and indexing steps http://www.bostongis.com/PrinterFriendly.aspx?content_name=loading_osm_postgis#comment_521 2012-12-07 Mike (mailto:nospam) n/a http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01_15#comment_518 2012-11-29