Just for a reference I am going to post these links to the installation of Postgresql Plus on Windows:
http://www.enterprisedb.com/learning/getting_started.do
This also includes the documentation for installing the server with Apache/PHP support for web applications.
Showing posts with label PostGIS. Show all posts
Showing posts with label PostGIS. Show all posts
Thursday, January 29, 2009
Friday, January 16, 2009
Implementation of phPhoneHome for remote iPhone connections
I have come across the phPhoneHome program for Postgresql that will allow me to administer the NIJ database from an iPhone. This should provide a useful starting point for our mobile application and should let us start sending/receiving data between the device and the server.
The program is installed as part of stackbuilder on the Enterprise DB installation, which is located at: http://www.enterprisedb.com/begin-download.do?redirectReason=startDownload . The application isn't really an application in essence, but a way to format the administrative tools for use on the iPhone.
The program was created by Dave Page who has an interesting and useful blog at: http://pgsnake.blogspot.com/ . Dave works for EnterpriseDB and developed the Iphone application that I will be using. His blog is a useful source of information for Postgresql information that I hope to use more of in the future.
Currently I am trying to get the server running on my Windows box since I have to get Scott Wood to do the install on our main DB server. At the moment, things don't seem to be working correctly and my server isn't recieving incoming connection on TCP/IP. Once i have this problem resolved I should be able to load the iPhone interface and try to test sending quieries and updates via SQL to the server.
Below are some screenshots that show how pgPhoneHome looks and works:
The program is installed as part of stackbuilder on the Enterprise DB installation, which is located at: http://www.enterprisedb.com/begin-download.do?redirectReason=startDownload . The application isn't really an application in essence, but a way to format the administrative tools for use on the iPhone.
The program was created by Dave Page who has an interesting and useful blog at: http://pgsnake.blogspot.com/ . Dave works for EnterpriseDB and developed the Iphone application that I will be using. His blog is a useful source of information for Postgresql information that I hope to use more of in the future.
Currently I am trying to get the server running on my Windows box since I have to get Scott Wood to do the install on our main DB server. At the moment, things don't seem to be working correctly and my server isn't recieving incoming connection on TCP/IP. Once i have this problem resolved I should be able to load the iPhone interface and try to test sending quieries and updates via SQL to the server.
Below are some screenshots that show how pgPhoneHome looks and works:
This show the main interface with all the tools available for use
This next screenshot show the server information once a connection is established.
Friday, July 18, 2008
zigGIS
I just made a great discovery in a ArcGIS extension called zigGIS.
From their site:
zigGIS is an ArcGIS Desktop extension that allows you to connect directly to spatial data stored in PostGIS. It is a lightweight option to allow you to centralize your spatial data into the leading open-source spatially-enabled relational database.
Using zigGIS, you will be able to take advantage of the advanced analysis and cartographic tools of ArcMap while leveraging the superior spatial data storage and management capabilities of PostGIS. zigGIS will enable you to view, analyze and edit your PostGIS spatial data from within ArcMap.
The most exciting new feature of zigGIS is the introduction of multi-user editing of PostGIS data from within ArcMap. zigGIS now includes tools to enable you to check out your data and make edits with the native ArcMap tools.
Best of all, zigGIS enables all of this capability for users of ArcView on up without the need for additional middleware.
(via: http://www.obtusesoft.com/)
This is awesome news for me since I use PostGIS everyday. The only gripe I have is no support for ESRI (at least not editing). This is going to make my life a hell of a lot easier and data management a breeze for me. Because, currently uploading spatial data to PostGIS is a bitch of a process when going from a windows box using ArcInfo to a PostGIS database on a linux server.
From their site:
zigGIS is an ArcGIS Desktop extension that allows you to connect directly to spatial data stored in PostGIS. It is a lightweight option to allow you to centralize your spatial data into the leading open-source spatially-enabled relational database.
Using zigGIS, you will be able to take advantage of the advanced analysis and cartographic tools of ArcMap while leveraging the superior spatial data storage and management capabilities of PostGIS. zigGIS will enable you to view, analyze and edit your PostGIS spatial data from within ArcMap.
The most exciting new feature of zigGIS is the introduction of multi-user editing of PostGIS data from within ArcMap. zigGIS now includes tools to enable you to check out your data and make edits with the native ArcMap tools.
Best of all, zigGIS enables all of this capability for users of ArcView on up without the need for additional middleware.
(via: http://www.obtusesoft.com/)
This is awesome news for me since I use PostGIS everyday. The only gripe I have is no support for ESRI (at least not editing). This is going to make my life a hell of a lot easier and data management a breeze for me. Because, currently uploading spatial data to PostGIS is a bitch of a process when going from a windows box using ArcInfo to a PostGIS database on a linux server.
Subscribe to:
Posts (Atom)
