[mapserver-users] Mapserver and GDB files

[Dave Fuhry]

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 <pramsey at cleverelephant.ca> 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 <dfuhry at gmail.com> 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 <pramsey at cleverelephant.ca> 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 <snaperski at gmail.com> 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 <woklist at kyngchaos.com>
>>>> 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
>>>>> mapserver-users at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>>
>>>>
>>>> _______________________________________________
>>>> mapserver-users mailing list
>>>> mapserver-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>>
>>>>
>>> _______________________________________________
>>> mapserver-users mailing list
>>> mapserver-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>