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.

[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 · 58 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:···············