[postgis-users] The Old Who is using PostGIS survey again?

[Van Bakergem, William]

>From a newbie:

Where should I post the following question:

We're developing a virtual city generator and will be using PostGIS.  We're just about to define our geometry using WKT but noticed that  WKT doesn't have a third value for the Z axis (CAD) - Y axis (X3D).  Our viewer will be Xj3D.


I understand from Olivier Courtin that It depends which SFS version, you use
in SFS 1.1 it's true, only 2D are available
but in SFS 1.2 you will find Z axis *and* 3D primitive (i.e
PolyhedralSurface)


I've built a new server with PostGIS and Ruby on Rails on CentOS 5.2, but I'm uncertain where the SFS 1.2 version is applied.  Is it an extension of PostGIS that needs to be installed on our server?  Or, is it handled some other way?


Dave



-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of Simon Greener
Sent: Wed 1/7/2009 5:55 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] The Old Who is using PostGIS survey again?
 
> Fastest way to migrate: drop a couple thousand bucks on an FME license
> and run it once. :)  If you understand Oracle Spatial, you understand
> PostGIS, conceptually. Just a few function names different. The
> drudgery of a migration though, that's something FME can cure.

Paul's on the money. I'm a reasonable Oracle Spatial expert and have found learning
PostGIS (or SQL Server 2008 Spatial etc) exceedingly easy. The "difficult" thing is
not so much the large/rich PostGIS function-set (what is the best way to skin the cat) but 
the fact that to be really efficient in any database requires one to understand the whole
database architecture and operating environment (that comes with time and experience).

regards
S

> P.
>
> On Wed, Jan 7, 2009 at 12:36 PM, Stephen Carville <scarville at landam.com> wrote:
>> We're not there yet but one of the developers and I just started a project to
>> migrate our Flood zone data from  Oracle spacial to postGIS.
>>
>> I am a systems engineer; the other guy is a C and Java developer and neither
>> of us has a deep knowledge of GIS and database management.  Right now I'd
>> snap up a "dummies" book for postGIS in a heartbeat.   I could use any help I
>> can get :-)
>>
>> --
>> Stephen Carville <scarville at landam.com>
>> Systems Engineer
>> Land America
>> 1.626.667.1450 X1326
>> ============================================================
>> Any security software design that doesn't assume the enemy
>> possesses the source code is already untrustworthy.
>>                                           -- Eric Raymond
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 



-- 
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
  Email: simon at spatialdbadvisor.com
  Voice: +613 9016 3910
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
NAC:W80CK 7SWP3
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 5167 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090107/3aad8e71/attachment.bin>