en-us http://www.bostongis.com Features the latest GIS tutorials on postgis, mapserver and other GIS technologies Boston GIS (mailto:articles@paragoncorporation.com) Nice examples, and I've got the query returning the set of nearest neighbors. That said, what's the simplest example of performing the query and returning the nearest neighbor as a join? I'm struggling to accomplish this with the custom pgis_nn type. Thanks. Steve http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_nearest_neighbor_generic#comment_185 2010-02-13 Stephen Mather (mailto:nospam) Vivian, You may want to try out the new PostGIS GUI loader. You can install it as a Plug-In in PgAdmin III. It also doesn't have that upper case issue that SPIT has. We've updated this article detailing this. http://www.postgis.us/chapter_07 http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01#comment_184 2010-02-12 Regina (mailto:nospam) I have found this tutorial very useful and succeeded in importing a large shape after adding the optional command -W utf8 and selecting the specific .shp file instead of just typing the .shp file title.... In the end I found www.gisvm.com a virual machine where PostGIS is already setup and Q-Gis installed. Q-GIS comes with a tool called SPIT. The combination of PostGIS and Q-GIS (SPIT) allows to import and view data from and two a PostGIS database. (The full idiot way: 100% no terminal commands) http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01#comment_182 2010-02-09 Vivian (mailto:nospam) Garret, Guess we have to update this. Use ST_Union instead and see if that works. http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01#comment_181 2010-01-30 Regina (mailto:nospam) Hi, great tutorial. Its exactly what I have been looking for. One question... When using your select statement: SELECT Area(geomunion(the_geom)) FROM towns where town = 'BOSTON'; I get the error: ERROR: function geomunion(geometry) does not exist LINE 1: SELECT Area(geomunion(the_geom)) FROM towns where town = 'BO... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ********** Error ********** ERROR: function geomunion(geometry) does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Character: 13 Any thoughts on why I might be getting this error? Thanks! http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01#comment_180 2010-01-29 Garret (mailto:nospam) Question - I use ESRI arcmap ArcView and I want to store all my data in SQL express 2008 Spatial I have not been successful in marring the two, any help or direction would be wonderful. Nathan http://www.bostongis.com/PrinterFriendly.aspx?content_name=sql2008_tut01#comment_178 2010-01-27 nbentley (mailto:nospam) Very nice site! http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut03#comment_177 2010-01-22 Very nice site! (mailto:nospam) Very nice site! cheap cialis http://opxaiey.com/oyyraqy/4.html http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut03#comment_176 2010-01-22 Very nice site! cheap cialis http://opxaiey.com/oyyraqy/4.html (mailto:nospam) Very nice site! [url=http://opxaiey.com/oyyraqy/2.html]cheap cialis[/url] http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut03#comment_175 2010-01-22 Very nice site! [url=http://opxaiey.com/oyyraqy/2.html]cheap cialis[/url] (mailto:nospam) The code suggestion for converting MapInfo to PostGIS didn't work for me because a quotation mark was in the wrong place. It should read: ogr2ogr -f "PostgreSQL" "PG:host=myhost user=myloginname dbname=mydbname password=mypassword" mytabfile.tab Note the double quote after PG: should be before PG:. This dogged me for a whole day. http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet#comment_174 2010-01-21 Chris McCarthy (mailto:nospam) Need Guide http://www.bostongis.com/PrinterFriendly.aspx?content_name=sql2008_tut01#comment_173 2010-01-21 Abdul Wahid (mailto:nospam) je desire tous connaitre sur postgis http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01#comment_166 2010-01-06 regragui (mailto:nospam) I need info about spatial datatypes http://www.bostongis.com/PrinterFriendly.aspx?content_name=sql2008_tut01#comment_160 2009-12-26 ya (mailto:nospam) I need this becouse my project http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_sharpmap_tut01#comment_159 2009-12-26 Hala (mailto:nospam) Balu Nadig, You are using ST_MakePoint wrong. The third argument is not the SRID, but the Z coordinate if you have one (there are 2 ST_MakePoint variants one that takes X,Y and one that Takes X,Y,Z). You want to do ST_SetSRID(ST_MakePoint(longitude,latitude), yoursridhere) http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut03#comment_158 2009-12-23 Regina (mailto:nospam)