[postgis-users] Arc catalog (Arc GIS) import

Sun Dec 14 09:18:28 PST 2008

Stefan,
> Now, as you may know: ArcSDE 9.3 supports PostgreSQL 8.3.0/PostGIS
> 1.3.2 on Windows. Isn't this part of a solution?

My understanding is that ArcSDE for PostGIS is a solution if you are willing
to fork over $20,000 for an ArcSDE license for PostGIS and are running
ArcGIS 9.3

If you have a large number of users or need to deploy as part of a ArcGIS
server web solution, then that probably is a better option than getting
ZigGIS which is an ArcGIS desktop only solution.

So my basic understanding

ZigGIS (works with 9.1, 9.2, 9.3 - Desktop Only - one license per user
ArcGIS desktop license, sort of like direct connect) I forget the pricing -
I think around $290
ArcSDE for PostGIS - $20,000+ (I could be wrong on the pricing and I think
it depends on number of processors on your server),  9.3 Only (I think there
is a patch that may allow 9.2 desktops to use an ArcSDE 9.3), but you can
have all your users who have ArcGIS Desktop installed using it with no
additional cost if you pay the server cost.
I don't know if they have per seat costs vs.  processor like the way
Microsoft offers for say SQL Server.

Hope that helps,
Regina

2008/12/13 Sufficool, Stanley <ssufficool at rov.sbcounty.gov>:
> Well after much head banging, it looks like this would only work for 
> viewing the features since linking even to an MSSQL database won't let 
> you edit the features.
>
> Looks like zigGIS is still the best avenue for now for a non SDE 
> interconnect.
>
>> -----Original Message-----
>> From: postgis-users-bounces at postgis.refractions.net
>> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
>> Sufficool, Stanley
>> Sent: Monday, December 08, 2008 8:28 AM
>> To: PostGIS Users Discussion
>> Subject: RE: [postgis-users] Arc catalog (Arc GIS) import
>>
>>
>> It looks like ODBC is taking care of the casing issues. On MSSQL, the 
>> fields are quoted, but on PostgreSQL they are passed as unquoted 
>> lower case.
>>
>> It looks like the returned row(s) aren't parsed correctly by ArcMap. 
>> This may be where the case sensitivity issue is (row['shape'] vs 
>> row['Shape']). I'm recreating all the datasets with quoted proper 
>> case field names to see what happens. Looks like they partially 
>> abstracted the database layer ;)
>>
>>
>> > -----Original Message-----
>> > From: postgis-users-bounces at postgis.refractions.net
>> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
>> > Paragon Corporation
>> > Sent: Saturday, December 06, 2008 8:06 AM
>> > To: 'PostGIS Users Discussion'
>> > Subject: RE: [postgis-users] Arc catalog (Arc GIS) import
>> >
>> >
>> > Stan,
>> >
>> > I would be interested if you get this working.  As far as your 
>> > error, I haven't played with geodatabase upsized or ArcMap for that 
>> > matter, but I'm suspecting your issue may be a casing one.
>> >
>> > When you upsized your table are all your fields upper case or they 
>> > are in the geodatabase (as I recall I think geodatabase structure 
>> > has all uppercase fields).  Or are they lowercase.
>> >
>> > My guess is your query goes thru okay but when ArcGIS tries to pull 
>> > it it is making an assumption about the casing of the fields or no 
>> > assumption and those 2 are not in agreement.
>> >
>> > Hope that helps,
>> > Regina
>> >
>> > -----Original Message-----
>> > From: postgis-users-bounces at postgis.refractions.net
>> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
>> > Sufficool, Stanley
>> > Sent: Friday, December 05, 2008 5:55 PM
>> > To: PostGIS Users Discussion
>> > Subject: RE: [postgis-users] Arc catalog (Arc GIS) import
>> >
>> > I've gained some ground on this and have a partially working 
>> > st_aspgdb and st_geomfrompgdb function set. I am having snags in 
>> > getting ArcMap to query the "upsized" data in PostgreSQL.
>> > Is anyone out there using ArcMap with an Access Personal 
>> > Geodatabase upsized/linked to PostgreSQL?
>> >
>> > Right now I'm running into "Item not found in this collection" when 
>> > attempting to preview a layer. I'm not finding any failed queries 
>> > in the ODBC connector log files, so I'm guessing a field isn't 
>> > being returned properly to ArcMap. I have the Shape data stored as 
>> > a bytea field which is presented to ODBC as a LO (Access sees OLE 
>> > Object).
>> >
>> > Sorry for the non-postgis questions, but the goal here is 
>> > transparent PGDB to EWKB bridging, which I'm hoping is of moderate 
>> > interest.
>> >
>> > > -----Original Message-----
>> > > From: postgis-users-bounces at postgis.refractions.net
>> > > [mailto:postgis-users-bounces at postgis.refractions.net] On
>> Behalf Of
>> > > Sufficool, Stanley
>> > > Sent: Monday, December 01, 2008 10:34 AM
>> > > To: PostGIS Users Discussion
>> > > Subject: RE: [postgis-users] Arc catalog (Arc GIS) import
>> > >
>> > >
>> > > Before I get too far on this and run into a roadblock (legally or 
>> > > technically), has anyone tried the Personal Geodatabase
>> linked to a
>> > > PostgreSQL view?
>> > >
>> > > My general plan is to create a view using a function to
>> > translate WKB
>> > > to the ESRI personal geodatabase format and then have an update 
>> > > trigger take the submitted pgeo shapefile record from ArcMAP and 
>> > > translate it to the geometry type for updating the
>> underlying table.
>> > >
>> > >
>> > > > -----Original Message-----
>> > > > From: postgis-users-bounces at postgis.refractions.net
>> > > > [mailto:postgis-users-bounces at postgis.refractions.net]
>> On Behalf
>> > > > Of Paragon Corporation
>> > > > Sent: Wednesday, November 26, 2008 6:32 PM
>> > > > To: 'PostGIS Users Discussion'
>> > > > Subject: RE: [postgis-users] Arc catalog (Arc GIS) import
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > > > >  2. If you need to showcase some PostGIS functionality
>> > and people
>> > > > > don't
>> > > > see an ESRI frontend, they tend to look at you like you
>> > have three
>> > > > heads.
>> > > >
>> > > > Having 3 heads I imagine is more useful than having one 
>> > > > assuming they are not all fighting with each other :)
>> > > >
>> > >
>> > > <SNIP>
>> > > _______________________________________________
>> > > 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
>> >
>> >
>> >
>> > _______________________________________________
>> > 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
>>
> _______________________________________________
> 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