That, and the sudden syntax changes, all to SQL compliance: delimit fields with "field", not [field] wildcards _ and %, not ? and * UPPER and LOWER, not UCASE and LCASE
and newly supported SQL clauses which ESRI is doubtful to have gone to extra lengths to implement: SELECT DISTINCT GROUP BY, ORDER BY Correlated sub-queries Select list expressions Trivial for a full-fledged db, but atypical for a single-file persistence & query system. -Dave On Tue, Sep 23, 2008 at 3:42 PM, Paul Ramsey <[EMAIL PROTECTED]> wrote: > Not sure what you're seeing that screams "SQLLite", but I found this > line on the final "Post 8.2" slide regarding access options > interesting: > > "Home grown open source spatial data API (e.g. GDAL, FDO)" > > P. > > On Tue, Sep 23, 2008 at 12:21 PM, Dave Fuhry <[EMAIL PROTECTED]> wrote: >> Does anybody know if the .gdb format is SQLite-based? I remember >> hearing rumors that ESRI's next geodatabase file format was to be. >> I'm unable to find anything confirming or denying this online. >> >> I read >> http://gis.esri.com/library/userconf/pug07/papers/workshops/file-gdb.pdf >> as giving strong indications that it is. >> >> -Dave >> >> >> On Tue, Sep 23, 2008 at 1:23 AM, Paul Ramsey <[EMAIL PROTECTED]> wrote: >>> Write an ArcGIS script to do all the work :) ArcGIS can export to >>> Shape file and can read lyr files. >>> >>> Heck: http://arcscripts.esri.com/details.asp?dbid=12766 >>> >>> P. >>> >>> On Mon, Sep 22, 2008 at 10:20 PM, Raivo Alla <[EMAIL PROTECTED]> wrote: >>>> Thank you all very much for answers. >>>> I am working on a project, where all data is in .gdb files and styles in >>>> ArcGIS .lyr format. >>>> I guess both - getting .gdb and .lyr files working in mapserver environment >>>> - are at the moment not possible? >>>> So I must convert convert .gdb files (using FME maybe?) to some readable >>>> format like shapefiles (if possible) and >>>> just type manually mapserver symbology files... uhh. >>>> >>>> >>>> Raivo >>>> >>>> On Mon, Sep 22, 2008 at 7:19 PM, William Kyngesburye <[EMAIL PROTECTED]> >>>> wrote: >>>>> >>>>> On Sep 22, 2008, at 9:59 AM, Frank Warmerdam wrote: >>>>> >>>>>> Fawcett, David wrote: >>>>>>> >>>>>>> .gdb files are ESRI's new File Geodatabase proprietary format. I am >>>>>>> quite sure that OGR/FWTools does not support it. >>>>>> >>>>>> David, >>>>>> >>>>>> Ah thanks. Indeed they are not supported and it is hard to imagine they >>>>>> will be supported for a while. ESRI has indicated in the past that they >>>>>> intend to provide an open mechanism to access the file geodatabase and >>>>>> that >>>>>> is still likely to happen at some point. However, I think this would be >>>>>> quite a few months away at best. >>>>> >>>>> Hmmm, and if ESRI provides it, then, like SDE, it probably won't be >>>>> available for OSX (or other linux platforms?). Bleh. >>>>> >>>>> ----- >>>>> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> >>>>> http://www.kyngchaos.com/ >>>>> >>>>> "I ache, therefore I am. Or in my case - I am, therefore I ache." >>>>> >>>>> - Marvin >>>>> >>>>> >>>>> _______________________________________________ >>>>> mapserver-users mailing list >>>>> [email protected] >>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>>> >>>> >>>> _______________________________________________ >>>> mapserver-users mailing list >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>>> >>>> >>> _______________________________________________ >>> mapserver-users mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>> >> _______________________________________________ >> mapserver-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
