James Fee GIS Blog

Geospatial Technology, Web Mapping and Spatial Services

James Fee GIS Blog header image 4

Comparing SQL Server 2008, MySQL and PostgreSQL/PostGIS

July 21st, 2008 · 9 Comments · GIS

Regina Obe has developed a table to compare the new SQL Server 2008 with PostgreSQL/PostGIS (with MySQL thrown in there to boot).  The table does a wonderful job showing the comparative strengths and weaknesses of all three relational databases.

SHARETHIS.addEntry({ title: “Comparing SQL Server 2008, MySQL and PostgreSQL/PostGIS”, url: “http://www.spatiallyadjusted.com/2008/07/21/comparing-sql-server-2008-mysql-and-postgresqlpostgis/” });

[Read more →]

Tags:····

zigGIS 2.0 Coming Soon

December 19th, 2007 · 7 Comments · ArcGIS Desktop, ArcSDE, ESRI, Open Source, PostGIS, PostgreSQL

PostgreSQL is about to get really integrated into ArcGIS workflows in 2008. First off we have ArcGIS Server Enterprise (ArcSDE) which will support PostgreSQL (ESRI and PostGIS data types) and now we have zigGIS 2.0 which will support PostGIS/PostgreSQL without the need for the traditional “ArcSDE” connection.
First and foremost, the zigGIS codebase will remain [...]

[Read more →]

Tags:·······

ArcGIS Server and ArcSDE (and Even Microsoft SQL Server 2008 Spatial)

December 17th, 2007 · 55 Comments · ArcGIS Server, ArcSDE, ESRI

OK, so here is what is happening at 9.3 with ArcSDE.

ArcSDE finally rides into the sunset. Even though technically ArcSDE has been replaced at 9.2, it was still a separate product. Now at 9.3 it will become fully integrated into ArcGIS Server. ArcGIS Server Enterprise will be the “traditional” ArcSDE level where [...]

[Read more →]

Tags:·········

Create GIS Workstation Using Ubuntu and Open Source GIS Software

October 22nd, 2007 · 34 Comments · GRASS, Mapserver, OSGeo, Open Source, PostGIS, PostgreSQL, QGIS

I get tons of emails from people asking where they can get free ArcView licenses for home use. People really want to work with GIS at home as well as at work which makes sense to me. I’ve always pointed folks to QGIS and other tools, but Matt Perry has a wonderful and [...]

[Read more →]

Tags:···············

Open Source on the Beach at Waikiki

October 1st, 2007 · 25 Comments · ArcGIS Desktop, ArcSDE, ESRI, Extensions, GRASS, Mapserver, OSGeo, Open Source, PostGIS, PostgreSQL, QGIS

I’m “stuck” in Waikiki this week at our Honolulu office helping them get back on track with their GIS after our GIS coordinator resigned to join her husband in the peace corps on Tonga. The new GIS person is really excited about GIS and that is always nice to be around. Sometimes even [...]

[Read more →]

Tags:··········