ogr2ft's Introduction

ogr2ft

ogr2ft tool copies features from any OGR data source to Google Fusion Table.

Usage

usage: ogr2ft.py [-h] -i INPUT_FILE -o OUTPUT_FUSION_TABLE [-a]                   
                                                                                  
Uploads a given feature collection to Google Fusion Table.                        
                                                                                  
optional arguments:                                                               
  -h, --help            show this help message and exit                           
  -i INPUT_FILE, --input-file INPUT_FILE                                          
                        input feature source (KML, SHP, SpatiLite, etc.)          
  -o OUTPUT_FUSION_TABLE, --output-fusion-table OUTPUT_FUSION_TABLE               
                        output Fusion Table name                                  
  -a, --add-missing     add missing features from the last inserted feature       
                        index

Example Run


python ./ogr2ft.py -i ../input.kml -o test_fusion_table
Creating Fusion Table: test1
Inserted 200 of 9420 features (2.12%)
Inserted 400 of 9420 features (4.25%)
Inserted 400 of 9420 features (4.25%)
Inserted 800 of 9420 features (8.49%)
Inserted 800 of 9420 features (8.49%)
Inserted 1200 of 9420 features (12.74%)
Inserted 1400 of 9420 features (14.86%)
Inserted 1400 of 9420 features (14.86%)
Inserted 1600 of 9420 features (16.99%)
Inserted 1800 of 9420 features (19.11%)
Inserted 2000 of 9420 features (21.23%)
Inserted 2200 of 9420 features (23.35%)
Inserted 2400 of 9420 features (25.48%)
Inserted 2600 of 9420 features (27.60%)
Inserted 2800 of 9420 features (29.72%)
Inserted 3000 of 9420 features (31.85%)
Inserted 3200 of 9420 features (33.97%)
Inserted 3400 of 9420 features (36.09%)
Inserted 3600 of 9420 features (38.22%)
Inserted 4000 of 9420 features (42.46%)
Inserted 4200 of 9420 features (44.59%)
Inserted 4400 of 9420 features (46.71%)
Inserted 4600 of 9420 features (48.83%)
Inserted 4800 of 9420 features (50.96%)
Inserted 5000 of 9420 features (53.08%)
Inserted 5200 of 9420 features (55.20%)
Inserted 5600 of 9420 features (59.45%)
Inserted 5600 of 9420 features (59.45%)
Inserted 5800 of 9420 features (61.57%)
Inserted 6000 of 9420 features (63.69%)
Inserted 6200 of 9420 features (65.82%)
Inserted 6400 of 9420 features (67.94%)
Inserted 6600 of 9420 features (70.06%)
Inserted 6800 of 9420 features (72.19%)
Inserted 7000 of 9420 features (74.31%)
Inserted 7200 of 9420 features (76.43%)
Inserted 7400 of 9420 features (78.56%)
Inserted 7600 of 9420 features (80.68%)
Inserted 7800 of 9420 features (82.80%)
Inserted 8000 of 9420 features (84.93%)
Inserted 8200 of 9420 features (87.05%)
Inserted 8600 of 9420 features (91.30%)
Inserted 8600 of 9420 features (91.30%)
Inserted 8800 of 9420 features (93.42%)
Inserted 9200 of 9420 features (97.66%)
Inserted 9400 of 9420 features (99.79%)
Inserted 9420 of 9420 features (100.00%).

Known Issues

Inserted row messages prints the same message from time to time, it looks like previous transaction is still busy while new inserts occur. The final table seems to be ok.

ogr2ft's People

Contributors

Stargazers

Watchers

ogr2ft's Issues

'NoneType' object has no attribute 'GetFieldCount'

Hi Gena,

I just tried to upload this file (changed .kml extension for upload here) to a fusion table based on your script. Unfortunately I got the following error:

python ./ogr2ft.py -i test.kml -o test_fusion_table
Creating Fusion Table: test_fusion_table
Traceback (most recent call last):
File "./ogr2ft.py", line 184, in
convert(args.input_file, args.output_fusion_table, args.add_missing)
File "./ogr2ft.py", line 141, in convert
[dst_layer.CreateField(f.GetFieldDefnRef(i)) for i in range(f.GetFieldCount())]
AttributeError: 'NoneType' object has no attribute 'GetFieldCount'

I tried to strip your code to get to this point of error, but that seems to work on my system? E.g.:

from osgeo import ogr
ifile = "./test.kml"
driver = ogr.GetDriverByName('KML')
src_ds = driver.Open(ifile)
src_layer = src_ds.GetLayerByIndex(0)
f = src_layer.GetFeature(1)
for i in range(f.GetFieldCount()):
print(i,f.GetFieldDefnRef(i))

So I am not sure what's going on? Any ideas?

System: Ubuntu 16.04 64-bit, Python 3.6.4 |Anaconda custom (64-bit), osgeo gdal 2.2.2

Recommend Projects