This is the syntax I used to import an ESRI geodatabase (GDB format) into an existing postGIS database:
ogr2ogr -f "PostgreSQL" PG:"host=hostname user=username dbname=mydb password=mypwd" mygeodb.gdb/ -a_srs EPSG:3003 - overwtrite
I’ve already read a great how to on “geolocation” named “Istant HTML5 geolocation how to” written by Ben Werdmuller
Below my review:
This manual, while being more directed to professional profiles web-developing oriented, can also be very helpful for other categories of professionals, including those who have to manage with the world of GIS and then of georeferencing. Reading this book you will understand which could be the interactions between users and web applications; personally, since I’m a GIS technologist, I have been able to achieve significant and deep implications among the topics treated in the manual and the practical applications of GIS. Even if he is not a developer, the great Ben Werdmuller has been able to guide me through the java-script and php languages to connect them, in a simple and intuitive way, to objects closer to me such as a KML or GPS.
Another particularly important aspect carried out with a very clear and effective approach in the manual is that relating to the security of users information and the protection of their privacy.
As is my habit, in order to check the effectiveness of the procedures explained, I have played step by step all the procedures and have tested all the code in the manual; even in this case I found the clarity of exposition and the thickness of the contents exposed by the author. In particular, the author faces thoroughly and exhaustively all the topics, with the consequence that the reader finds an answer to all his questions on the matter, and this once again confirms the professionalism of the author, which is already well known to the public sector. Finally, the excellent model used by the publishing house Packt (already adopted in many of his other publications) to organize and present the topics covered must be underlined, to the advantage of immediacy and clarity that help in an important way the reader in understanding the content exposed .