Re: [postgis-users] Test bench results on peformance/limits of postgis/postgresql?
Hello, Look on this blog post http://blog.cleverelephant.ca/2012/02/postgis-vs-oracle-spatial.html that redirect you to a complete paper comparing Oracle and PostGIS. For perfs too, see some thoughts about latest PostgreSQL features (not spatial in particular) http://www.databasesoup.com/2012/04/foss4g-na-2012.html For tuning advice focusing on PostGIS http://underdark.wordpress.com/2011/01/14/postgis-tuning/ who share the link to OpenGeo tutorial Dont forget the official PostgreSQL wiki http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server Regards ThomasG ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Problems Accessing prj2epsg.org
Hello, No idea but you can install it on your own server e.g http://svn.opengeo.org/prj2epsg/trunk/ Regards ThomasG ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] POSTGIS Security
Hello, I don't think there is something called POSTGIS ES but a new version of PostGIS 1.5.x serie was released e.g http://postgis.refractions.net/pipermail/postgis-users/2012-May/033992.html I think it's what you're expecting. Regards ThomasG ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] about 64-bit postgis
Hello, On the website e.g http://www.postgis.org/download/windows/#windbinaries Regards ThomasG ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] postgis tutorial
Hello, Look on this topic on gis stack exchange http://gis.stackexchange.com/questions/10376/spatial-databases-learning-resources-for-newbies Regards ThomasG ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Turning Semantic Mediawiki into a full Semantic GIS
Hello, This project can maybe help you https://dev.opensahara.com/projects/2/wiki/IndexingSail It already uses PostGIS to deal with geo semantic and triple store. Regards ThomasG ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Moving geometry from MySQL to PostGIS
Hello, Have a look on GDAL (compiled with PostgreSQL and Spatialite libs) For MySQL e.g http://www.gdal.org/ogr/drv_mysql.html or PostGIS http://www.gdal.org/ogr/drv_pg.html You can use OpenLite beta utility too http://www.gaia-gis.it/OpenLite/index.html Regards Thomas Gratier ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS websites in PHP without a map server?
Hello, Maybe http://code.google.com/p/postgis-restful-web-service-framework/project can help you a bit. Only based on PHP and PostGIS Regards ThomasG GIS specialist ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Convert a non spatial table into a spatial table
Hello, You can convert our wkt table to PostGIS. See PostGIS docs for this. http://postgis.refractions.net/docs/ch04.html#OpenGISWKBWKT You can in first convert your table to PostGIS with your wkt as a text, after create a proper geometry column and apply functions from the docs to get a result you can open in Qgis. Regards ThomasG GIS specialist ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Retrieve the portion of line external to polygon
Hello, st_snap() function is in the 2.0 future release. You find informations about this function in the trunk documentation http://postgis.refractions.net/documentation/manual-svn/reference.html and for the particular function you're looking for http://postgis.refractions.net/documentation/manual-svn/ST_Snap.html Regards ThomasG GIS specialist ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Looking for some exercises about spatial sql
Hello, Look on http://gis.stackexchange.com/questions/3251/how-do-i-get-started-with-postgis Concerning the book Postgis in action, if you have a credit card, you can get it in pdf version. Regards ThomasG GIS specialist ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] getting the longest connected path of a multistring
Hello, Maybe this post from Paul Ramsey can help you a bit e.g http://blog.cleverelephant.ca/2010/07/network-walking-in-postgis.html Regards ThomasG GIS specialist ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Paris data
Hello, See http://www.postgis.us, the official website for the book. Regards ThomasG GIS specialist ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PosGISViewer plugin PgAdmin III
Hello, Without presuming of the dependencies libraries of the project , look on http://www.mono-project.com/Main_Page It's maybe possible to make it work on unix/linux. Regards ThomasG GIS specialist PS : Christophe, I see you everywhere not only a well known forum ;) ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 1.5
Hello, Look depending of postgresql installation into http://postgis.refractions.net/download/windows/pg82/ http://postgis.refractions.net/download/windows/pg83/ http://postgis.refractions.net/download/windows/pg84/ For upgrading database, go to http://wiki.debian.org/DebianGis/UpdatingPostGIS for some advices Regards ThomasG GIS specialist ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostgreSQL version for PostGIS ver 1.5.1
Hello, You don't have direct installation in Linux for Postgis 1.5 (except if someone have done a backport I don't know) You will have to compile http://georezo.net/wiki/main:logiciels:postgis:start for install instructions on Linux 10.04 (in french, but for commands no difference) Regards ThomasG GIS Specialist ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Re: Can't Call shp2pgsql.exe From Run or VB Program, only works with DOS prompt opened first
Dan, I can't directly help you but some people works about vbs for importing shp via shp2pgsql. Let's have a look on this post http://georezo.net/forum/viewtopic.php?id=47156 (in the middle of this french topic, you have VBS code ) Hope it helps Thomas G ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users