PostGIS: Difference between revisions

From Wildsong
Jump to navigationJump to search
Brian Wilson (talk | contribs)
mNo edit summary
Brian Wilson (talk | contribs)
Line 44: Line 44:


What about loading ArcGIS data using fwtools?
What about loading ArcGIS data using fwtools?
== Resources ==
An article of interest
http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008_postgis_mysql_compare

Revision as of 03:28, 13 June 2009

Given: I have to be able to manage data in a SQL database server. I can't hack geoprocessing on the desktop any more. The datasets are too large.

Enterprise geodatabase server

The hardware

2 dual core Xeon processors,

12 GB of RAM

RAID stripe (for performance) with 3 drives

The software

All installed from packages unless noted otherwise

Debian (32 bit but should be upgraded to 64 bit soon)

PostgreSQL

PROJ 4.4.9

gdal 1.3.1 (bound to pgsql and python)

postgis

python

To facilitate viewing the data

Apache

Mapserver

php mapscript

python mapscript

Loading data into PostGIS

The word is that I can use ArcGIS to do this??? Is this true? I don't want to get anywhere near SDE if I don't have to, so putting it on top of PostgreSQL is not what I want.

What about loading ArcGIS data using fwtools?

Resources

An article of interest

http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008_postgis_mysql_compare