[postgis-users] Enormous file geodatabase feature class > PostgreSQL/PostGIS? + attribute column standardization app or process?

[Randy George]

Hi Paul,

> Hm. Where's our open access?

	I suppose ESRI assumes it is open because they provide support$$ for
MS SQL Server, DB2, and Oracle, or maybe because geodatabase geometry is
just .shp in blobs anyway. 

	I can't see much advantage keeping all the ESRI related trigger
stuff since the "open" idea is to escape ESRI orbit in the end. To that end
I guess anything in Frank's GDAL zone is "open access" since the road out is
already built. 

Maybe you and Frank should ask for ESRI funding since you have provided
"open access" for them :)

randy

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Tuesday, February 19, 2008 9:05 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Enormous file geodatabase feature class >
PostgreSQL/PostGIS? + attribute column standardization app or process?

On 2/19/08, dnrg <dananrg at yahoo.com> wrote:

> And are there any known limitations on the size of
> feature classes (or whatever they may be called in
> PostGIS) you can manipulate with reasonable speeds?

Tables, they're called tables. Why must everything be re-named in
ESRI-land? Oh wait, I forgot, "GIS is different".

People have loaded the 500M features of UK Ordnance Survey into
PostGIS. Refractions has 20M feature hydrology databases.  TIGER has
been loaded many times (50M features).

> My system will be an OLAP, not an
> OLTP--so once the data is loaded, there won't be much
> editing to speak of.

Then it won't be particularly concurrent.  It's write contention that
causes concurrency issues, not read contention.

> Finally, does it look like ESRI will ever open its
> geodatabase format in the way they've opened up the
> shapefile?

That is an issue worth exploring, since the official pronouncements
have said it would be open, but I never really thought it was worth
agitating over since the format hadn't "arrived". But it's part of a
shipping product now. Hm. Where's our open access?
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users