Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am attempting to get a nice KML for simple review of POI/geocoding from a CSV. I a using ogr2ogr and a vrt. You can see the vet file below, with two attempts to get this right.

Basically, the issue is using ogr2ogr -f KML ... with the vrt w/o renaming results in a lot of "SimpleData" tags in the KML.

I'd like to get some CSV fields as the KML Placemark "Name" and "Description", concatenated fields, actually. -dsco NameField=RegionName option in ogr2ogr, but I don't see a way to concatenate fields into name, e.g Street, City, State..

In the .vrt below, the SrcSQL field results in no records. It does open, but with layer info. The Field tag (when not commented out) does result all records with in the new alias, but the "name" is the only field that comes through, it drops all other fields. Further, is there a way to concatenate fields using ?

Of course, perhaps ogr is not capable of concatenation ...


    <OGRVRTLayer name="roofing-poi2">
        <GeometryField encoding="PointFromColumns" x="Longitude" y="Latitude"/>
<!--         <Field src="StreetAddress" name="name" /> -->
        <SrcSQL>SELECT StreetAddress as name</SrcSQL>
share|improve this question
Just to add in, ideally, i'd want to concat the parsed address into the name, in SQL "SELECT concatenate(Street, City, Staet, ZIP) AS name" but that's not a deal breaker. – greenwar Aug 7 '12 at 23:22
i'd be happy just getting the Field tag in the vrt to work, doing one alias (Street as name) and then the rest of the columns without having to specify each column from the CSV. – greenwar Aug 7 '12 at 23:23

Circumventing ogr2ogr for the first conversion, I've found a unix tool that will allow me to do this (

csv2geojson -lat "latitude" -lon "longitude" input.csv > intermediatefile.geojson

I use a constant name for the output file so it gets just overwritten a bunch of times, but now I can convert to kml

ogr2ogr -f KML output.kml intermediatefile.geojson
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.