Hi, Even through "ogrinfo" can see all the fields and the features in my KML I can never get ogr2ogr to actually give me the feature info that I want: name, description, point, polygon. The only format that actually shows is JSON but that is a real pain to import into PostGreSQL. CSV and PostGreSQL get to the "MultiGeometry" KML that contains POINT and POLYGON and then seem to give up.
I am quite new to GDAL and spent some time working through manuals, FAQ and did a list search and can only find "Re: missing point in MultiGeometry KML file" which may be a solution as the answer specifies having to have "<coordinates>" in triplets and lo and behold the source KML is missing the "Z" dimension that should be set to 0. However a test I did adding the third triplet still gives the same results. Any help very much appreciated. GDAL 1.11.3, released 2015/09/16 PRIMARY KML FEED (REGIONATED): http://pirlwww.lpl.arizona.edu/~rbeyer/kml/HiRISE_PDS.kml KML FEED WEBPAGE: http://rossbeyer.net/science/kml/ EXTRACTED REGION: http://files.michaelzfreeman.org/MC-01-0-0-0.kml USED COMMANDS: ogrinfo -ro fields=YES -geom=YES Beyer_Hirise_Areas_KML/MC-01-0-0-0.kml > ogrinfo_hirise.txt ogr2ogr -f PGDump output_pgdump Beyer_Hirise_Areas_KML/MC-01-0-0-0.kml ogr2ogr -f CSV output.csv Beyer_Hirise_Areas_KML/MC-01-0-0-0.kml http://files.michaelzfreeman.org/ogrinfo_hirise.txt http://files.michaelzfreeman.org/output_pgdump http://files.michaelzfreeman.org/output.csv --- Michael Z Freeman
FAILURE: Unable to open datasource `fields=YES' with the following drivers. -> ESRI Shapefile -> MapInfo File -> UK .NTF -> SDTS -> TIGER -> S57 -> DGN -> VRT -> REC -> Memory -> BNA -> CSV -> NAS -> GML -> GPX -> LIBKML -> KML -> GeoJSON -> Interlis 1 -> Interlis 2 -> GMT -> GPKG -> SQLite -> DODS -> ODBC -> WAsP -> PGeo -> MSSQLSpatial -> OGDI -> PostgreSQL -> MySQL -> PCIDSK -> OpenFileGDB -> XPlane -> AVCBin -> AVCE00 -> DXF -> Geoconcept -> GeoRSS -> GPSTrackMaker -> VFK -> PGDump -> OSM -> GPSBabel -> SUA -> OpenAir -> PDS -> WFS -> HTF -> AeronavFAA -> Geomedia -> EDIGEO -> GFT -> GME -> SVG -> CouchDB -> Idrisi -> ARCGEN -> SEGUKOOA -> SEGY -> XLS -> ODS -> XLSX -> ElasticSearch -> PDF -> Walk -> CartoDB -> SXF
Name,description,timestamp,begin,end,altitudeMode,tessellate,extrude,visibility,drawOrder,icon ESP_018108_2680," <p> Exposure of polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_018108_2680'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_018318_2675," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_018318_2675'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_019031_2675," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_019031_2675'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_019069_2680," <p> Exposure of polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_019069_2680'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_025463_2675," <p> North polar terrain in spring </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_025463_2675'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_025489_2720," <p> North polar terrain in spring </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_025489_2720'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_025758_2695," <p> North polar terrain in spring </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_025758_2695'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_025818_2675," <p> North polar terrain in spring </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_025818_2675'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_027034_2680," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_027034_2680'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_027246_2680," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_027246_2680'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_028140_2680," <p> Inter-annual monitoring of north polar residual cap and top of trough </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_028140_2680'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_028299_2670," <p> Interannual monitoring of north polar residual cap surface </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_028299_2670'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_037227_2675," <p> Possible exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_037227_2675'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_037277_2675," <p> Exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_037277_2675'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_037305_2675," <p> Possible exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_037305_2675'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_045190_2670," <p> North polar layered deposit trough </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_045190_2670'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, ESP_045543_2720," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/ESP_045543_2720'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_001371_2720," <p> Exposure of polar layered deposits not well covered by Mars Global Surveyor </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_001371_2720'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_001385_2680," <p> Exposure of polar layered deposits not well covered by Mars Global Surveyor </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_001385_2680'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_001530_2670," <p> Layering in north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_001530_2670'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_001582_2730," <p> Anomalously bright region - continue time coverage of Mars Global Surveyor </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_001582_2730'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_001584_2670," <p> Anomalously bright region - continue time coverage of Mars Global Surveyor </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_001584_2670'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_009111_2730," <p> North polar ice and frost monitoring site </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_009111_2730'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_009258_2675," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_009258_2675'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_009309_2725," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_009309_2725'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_009325_2675," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_009325_2675'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_009589_2675," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_009589_2675'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_010060_2720," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_010060_2720'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_010087_2730," <p> Sample of north polar monitoring site </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_010087_2730'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_010101_2680," <p> High-latitude exposure of north polar layered deposits </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_010101_2680'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, PSP_010272_2670," <p> North polar layered deposit trough - change from year one </p> <p><a href='http://hirise.lpl.arizona.edu/PSP_010272_2670'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,, TRA_000832_2670," <p> Layering in north polar troughs </p> <p><a href='http://hirise.lpl.arizona.edu/TRA_000832_2670'>HiRISE Observation Web page</a> </p> <div> <a href='http://hirise.lpl.arizona.edu'><img src=""HiRISE_logo.png"" /></a> </div> ",,,,,1,-1,-1,,
output_pgdump
Description: Binary data
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
