[Gdal-dev] Importing VMAP0 into PostGIS database; Was: Custom scenery integration

[Paul Spencer]

Frank,

this is timely.  I'm interested in the vmap0 data also.  I downloaded 
v0sas and extracted it, then used ogrinfo that is built with the most 
recent version of FGS ... it has OGDI support (as of yesterday) and no 
core dump ;) with ogrinfo --formats, but it refuses to open the dataset 
using the syntax you listed below.  So I d/l and extracted your dataset 
and tried ... again, no joy :S

pspencer at merlin /home/common/vmap0 $ ogrinfo 
gltp:/home/common/vmap0/v0eur/vmaplv0/eurnasia 'crop at veg*_area' -so
FAILURE:
Unable to open datasource 
`gltp:/home/common/vmap0/v0eur/vmaplv0/eurnasia' with the following drivers.
   -> ESRI Shapefile
   -> UK .NTF
   -> SDTS
   -> TIGER
   -> S57
   -> MapInfo File
   -> DGN
   -> VRT
   -> AVCBin
   -> REC
   -> Memory
   -> CSV
   -> GML
   -> ODBC
   -> OGDI
   -> PostgreSQL
   -> MySQL

any ideas?  Am I missing some option in OGDI?

Paul

Frank Warmerdam wrote:
> On 8/9/05, Martin Spott <Martin.Spott at mgras.net> wrote:
> 
>>>FrankW  nhv: Check http://rafb.net/paste/results/PGY8bR34.html
>>
>>Indeed, this is almost what I'm doing here. I just added renaming the
>>layers (with "-nln") in order to make it a functional equivalent of
>>yours. All this looks quite reasonable and 'ogr2ogr' always returns
>>zero. What makes me wonder is that the dump of the resulting database
>>is only 14 MByte in size as the respective 'v0eur' dataset is 521
>>MByte. Does this match your experience or do you think I missed
>>something relevant ?
>>Some old posting on this topic suggested to remove trailing dots at
>>filenames in the VMAP0 set - I already did that without realizing
>>significant change.
> 
> 
> Martin,
> 
> On reflection, I think the problem is still likely to be the related to 
> the naming conventions of the fileset.  Where did you get your VMAP0
> dataset?   Could I suggest you grab and unpack:
> 
>   ftp://ftp.remotesensing.org/v0eur.tar.gz
> 
> With this and FWTools 0.9.9b3 I get the following for one of the layers.
> Could you see if you get a similar result? 
> 
> $ ogrinfo gltp:/vrf/home/warmerda/v0eur/vmaplv0/eurnasia 'cropa at veg(*)_area' -so
> ERROR 4: OGDI Driver doesn't support update.
> Had to open data source read-only.
> INFO: Open of `gltp:/vrf/home/warmerda/v0eur/vmaplv0/eurnasia'
> using driver `OGDI' successful.
> 
> Layer name: cropa at veg(*)_area
> Geometry: Polygon
> Feature Count: 44114
> Extent: (-10.377182, 30.000000) - (159.805161, 68.291046)
> Layer SRS WKT:
> GEOGCS["NAD83",
>     DATUM["North_American_Datum_1983",
>         SPHEROID["GRS 1980",6378137,298.257222101,
>             AUTHORITY["EPSG","7019"]],
>         TOWGS84[0,0,0,0,0,0,0],
>         AUTHORITY["EPSG","6269"]],
>     PRIMEM["Greenwich",0,
>         AUTHORITY["EPSG","8901"]],
>     UNIT["degree",0.0174532925199433,
>         AUTHORITY["EPSG","9108"]],
>     AXIS["Lat",NORTH],
>     AXIS["Long",EAST],
>     AUTHORITY["EPSG","4269"]]
> id: Integer (10.0)
> f_code: String (5.0)
> ftc: Integer (5.0)
> veg: Integer (5.0)
> tile_id: Integer (5.0)
> fac_id: Integer (10.0)
> 
> Best regards,

-- 
+-----------------------------------------------------------------+
|Paul Spencer                           pspencer at dmsolutions.ca   |
+-----------------------------------------------------------------+
|Applications & Software Development                              |
|DM Solutions Group Inc                 http://www.dmsolutions.ca/|
+-----------------------------------------------------------------+