[GRASSLIST:10082] Re: trying to read in ArcView/.mdb file of NYC roads

[U. George]

yup, ur right: Now for a segfault to brighten this day

mdb-schema /tmp/lion/Data/LION.mdb
DROP TABLE ALTNAMES;
CREATE TABLE ALTNAMES
  (
         OBJECTID                        Long Integer (4),
         PDIR                    Text (4),
         PTYPE                   Text (12),
         SNAME                   Text (60),
         STYPE                   Text (12),
         SDIR                    Text (4),
         JOIN_ID                 Text (30)

);
-- CREATE ANY INDEXES ...

DROP TABLE GDB_AnnoSymbols;
CREATE TABLE GDB_AnnoSymbols
  (
         ID                      Long Integer (4),
         Symbol                  OLE

);
-- CREATE ANY INDEXES ...

DROP TABLE GDB_AttrRules;
CREATE TABLE GDB_AttrRules
  (
         RuleID                  Long Integer (4),
         Subtype                 Long Integer (4),
         FieldName                       Text (510),

...........................

-- CREATE ANY Relationships ...

relationships are not supported for access
relationships are not supported for access
relationships are not supported for access
relationships are not supported for access
relationships are not supported for access
Segmentation fault


Markus Neteler wrote:
> On Tue, Jan 31, 2006 at 08:12:26AM -0500, U. George wrote:
> 
>>got and compiled the src. not readable! :-{
>>
>> > mdb-ver /tmp/lion/Data/Lion.mdb
>>Can't alloc filename
> 
> 
> ls -la /tmp/lion/Data/Lion.mdb
> 
> ?
> 
> Also:
> IMHO the CVS version is more advanced than the 0.5 release.
> 
> Markus
>  
> 
>>Markus Neteler wrote:
>>
>>>U. George wrote:
>>>
>>>
>>>>from the website:
>>>
>>>>http://www.nyc.gov/html/dcp/html/bytes/dwnlion.shtml
>>>>
>>>>i would like to view the roads in the bronx. I am not familiar with
>>>>either grass, or arcview.
>>>>I have built 'grass' from source.  But am unable to import the
>>>>LION.mdb data file.
>>>>
>>>>
>>>>GRASS 6.0.1 (GRASS):/tmp/lion > unzip -l nyc_lion05bav.zip
>>>>Archive:  nyc_lion05bav.zip
>>>>Length     Date   Time    Name
>>>>--------    ----   ----    ----
>>>>  15360  05-10-05 14:59   LION Streets.lyr
>>>>  18432  05-10-05 14:52   LION.lyr
>>>>  27640  05-02-05 13:53   NYC LION Geocoding (GDB).lot
>>>>  27201  05-10-05 11:44   NYC LION Geocoding (SDE).lot
>>>> 133436  08-02-05 10:11   nyc_lion_metadata.htm
>>>>48627712  08-02-05 10:08   Data/LION.mdb
>>>>      0  07-11-05 12:21   Data/
>>>> 109568  07-20-05 12:34   Geocoding with LION.doc
>>>>--------                   -------
>>>>48959349                   8 files
>>>>
>>>
>>>You may use:
>>>
>>>http://mdbtools.sourceforge.net/
>>>" The MDB Tools project is a effort to document the MDB file format
>>>used in Microsoft <http://www.microsoft.com/>'s Access database
>>><http://www.microsoft.com/office/access/default.asp> package, and to
>>>provide a set of tools and applications to make that data available on
>>>other platforms."
>>>
>>>Markus
>>>
>>>
>>>
>>
>>
>