<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-2022-jp">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
{font-family:"Cordia New";
panose-1:2 11 3 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:"Yu Gothic";
panose-1:2 11 4 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@Yu Gothic";
panose-1:2 11 4 0 0 0 0 0 0 0;}
@font-face
{font-family:"\@MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="JA" style="font-family:"Yu Gothic",sans-serif">$B$3$N%Z!<%8$K$h$k$H(B</span></p>
<p class="MsoNormal"><a href="https://gdal.org/drivers/vector/csv.html">https://gdal.org/drivers/vector/csv.html</a></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">VRT<span lang="JA" style="font-family:"Yu Gothic",sans-serif">$B%U%!%$%k$r:n$k$H$$$$$_$?$$$G$9!#(B</span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="JA" style="font-family:"Yu Gothic",sans-serif">$B2<$NFbMF$r(B</span>exif.vrt<span lang="JA" style="font-family:"Yu Gothic",sans-serif">$B$H$$$&%F%-%9%H%U%!%$%k$KJ]B8$7$F(B</span></p>
<p class="MsoNormal">ogr2ogr -f GeoJSON out.json exif.vrt</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="JA" style="font-family:"Yu Gothic",sans-serif">$B$3$l$G$G$-$^$7$?!#(B</span>OGRVRTLayer name=$B!I(BXXXXX$B!I(B<span lang="JA" style="font-family:"Yu Gothic",sans-serif">$B!!$3$N%l%$%d!<%M!<%`$O(B</span>CSV<span lang="JA" style="font-family:"Yu Gothic",sans-serif">$B%U%!%$%k$NL>A0$H0lCW$7$F$J$$$H%@%a$_$?$$$G$9(B</span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><OGRVRTDataSource></p>
<p class="MsoNormal"> <OGRVRTLayer name="exif"></p>
<p class="MsoNormal"> <SrcDataSource>./exif.csv</SrcDataSource></p>
<p class="MsoNormal"> <GeometryType>wkbPoint</GeometryType></p>
<p class="MsoNormal"> <LayerSRS>WGS84</LayerSRS></p>
<p class="MsoNormal"> <GeometryField encoding="PointFromColumns" x="GPSLongitude" y="GPSLatitude"/></p>
<p class="MsoNormal"> <Field name="SourceFile" src="SourceFile" type="String"/></p>
<p class="MsoNormal"> <Field name="GPSLongitude" src="GPSLongitude" type="Real"/></p>
<p class="MsoNormal"> <Field name="GPSLatitude" src="GPSLatitude" type="Real"/></p>
<p class="MsoNormal"> <Field name="GPSAltitude" src="GPSAltitude" type="Real"/></p>
<p class="MsoNormal"> </OGRVRTLayer></p>
<p class="MsoNormal"></OGRVRTDataSource><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-- <o:p></o:p></p>
<p class="MsoNormal">Yosuke Kimura<o:p></o:p></p>
<p class="MsoNormal">Center For Energy and Environmental Resources<o:p></o:p></p>
<p class="MsoNormal">The University of Texas at Austin<o:p></o:p></p>
<p class="MsoNormal">Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986">
Mail</a> for Windows 10<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="border:none;padding:0in"><b>From: </b><a href="mailto:wata909@gmail.com">Nobusuke Iwasaki</a><br>
<b>Sent: </b>Sunday, February 12, 2023 10:24 PM<br>
<b>To: </b><a href="mailto:OSGeoJapan-discuss@lists.osgeo.org">osgeojapan-discuss</a><br>
<b>Subject: </b>[OSGeoJapan-discuss] ogr2ogr<span lang="JA" style="font-family:"Yu Gothic",sans-serif">$B$G(B</span>csv<span lang="JA" style="font-family:"Yu Gothic",sans-serif">$B%U%!%$%k$rJQ49$9$k:]$N%G!<%?7?$N;XDj(B</span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="JA" style="font-family:"MS Gothic"">$B$_$J$5$^(B</span><br>
<br>
<span lang="JA" style="font-family:"MS Gothic"">$B4d:j$G$9!#$4B8$8$NJ}$,$$$i$C$7$c$l$P!"65$($F2<$5$$!#(B</span><br>
exiftool<span lang="JA" style="font-family:"MS Gothic"">$B$H!"(B</span>OSGeo4W<span lang="JA" style="font-family:"MS Gothic"">$B$N(B</span>ogr2ogr<span lang="JA" style="font-family:"MS Gothic"">$B$r;H$C$F!"2hA|$N(B</span>EXIF<span lang="JA" style="font-family:"MS Gothic"">$B>pJs$+$i0LCV>pJs$r<h$j=P$7!"(B</span>GeoJSON<span lang="JA" style="font-family:"MS Gothic"">$B$J$j!"(B</span>Flatgeobuf<span lang="JA" style="font-family:"MS Gothic"">$B$J$j$NE@%G!<%?$KJQ49$7$?$$$H;W$C$F$$$^$9!#(B</span><br>
<span lang="JA" style="font-family:"MS Gothic"">$B0J2<$N%3%^%s%I$G%U%!%$%k$r:n$k$3$H$O$G$-$k$N$G$9$,!"$G$-$?%U%!%$%k$NB0@-CM$,!"?tCM7?$G$O$J$/J8;zNs7?$K$J$C$F$7$^$$$^$9!#(B</span><br>
<br>
exiftool<span lang="JA" style="font-family:"MS Gothic"">$B$G!"2hA|$N(B</span>EXIF<span lang="JA" style="font-family:"MS Gothic"">$B$+$i(B</span>csv<span lang="JA" style="font-family:"MS Gothic"">$B%U%!%$%k$r:n@.(B</span><br>
exiftool -csv -GPSLongitude -GPSLatitude -GPSAltitude -n *.JPG >exif.csv<br>
<br>
ogr2ogr<span lang="JA" style="font-family:"MS Gothic"">$B$G!"(B</span>csv<span lang="JA" style="font-family:"MS Gothic"">$B$+$i(B</span>geojson<span lang="JA" style="font-family:"MS Gothic"">$B$r:n@.(B</span><br>
ogr2ogr -dialect SQLite -sql "SELECT *, MakePoint(CAST(GPSLongitude AS<br>
float),CAST(GPSLatitude AS float)) FROM exif" -a_srs EPSG:4612<br>
point.geojson exif.csv<br>
<br>
<span lang="JA" style="font-family:"MS Gothic"">$B0J2<!"JQ4985$N%U%!%$%k$H!"JQ49$7$?(B</span>csv<span lang="JA" style="font-family:"MS Gothic"">$B%U%!%$%k$r6&M-$7$^$9!#(B</span><br>
<a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dropbox.com%2Ft%2FJ0iDbfYtcrkWIXYl&data=05%7C01%7C%7C48e1a1110dd34aea3f9e08db0d7a267f%7C31d7e2a5bdd8414e9e97bea998ebdfe1%7C0%7C0%7C638118590528244778%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Og6JFVZQamjuxq5HPi%2FfFoo0vdkE%2FboWUNQ7euLtATE%3D&reserved=0">https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dropbox.com%2Ft%2FJ0iDbfYtcrkWIXYl&data=05%7C01%7C%7C48e1a1110dd34aea3f9e08db0d7a267f%7C31d7e2a5bdd8414e9e97bea998ebdfe1%7C0%7C0%7C638118590528244778%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Og6JFVZQamjuxq5HPi%2FfFoo0vdkE%2FboWUNQ7euLtATE%3D&reserved=0</a><br>
<br>
ogr2ogr<span lang="JA" style="font-family:"MS Gothic"">$B$G!"(B</span>csv<span lang="JA" style="font-family:"MS Gothic"">$B$+$i(B</span>geojson<span lang="JA" style="font-family:"MS Gothic"">$B$b$7$/$O(B</span>flatgeobuf<span lang="JA" style="font-family:"MS Gothic"">$B$KJQ49$9$k$H$-$K!"%U%#!<%k%I$N%G!<%?$N7?$r;XDj$9$kJ}K!$r$4B8$8$NJ}$,$$$i$C$7$c$l$P!"65$($F$$$?$@$1$k$H9,$$$G$9!#(B</span><br>
<span lang="JA" style="font-family:"MS Gothic"">$B$h$m$7$/$*4j$$$7$^$9(B</span>m(_ _)m<br>
<br>
<br>
<br>
-- <br>
<span lang="JA" style="font-family:"MS Gothic"">$B4d:j(B</span><span lang="JA"> </span>
<span lang="JA" style="font-family:"MS Gothic"">$BOKE5(B</span><br>
_______________________________________________<br>
OSGeoJapan-discuss mailing list<br>
OSGeoJapan-discuss@lists.osgeo.org<br>
<a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fosgeojapan-discuss&data=05%7C01%7C%7C48e1a1110dd34aea3f9e08db0d7a267f%7C31d7e2a5bdd8414e9e97bea998ebdfe1%7C0%7C0%7C638118590528244778%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=e2Sh4T4NcjK37II8UpoC6yx3bER%2BGfLtuQx0M94aVJo%3D&reserved=0">https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fosgeojapan-discuss&data=05%7C01%7C%7C48e1a1110dd34aea3f9e08db0d7a267f%7C31d7e2a5bdd8414e9e97bea998ebdfe1%7C0%7C0%7C638118590528244778%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=e2Sh4T4NcjK37II8UpoC6yx3bER%2BGfLtuQx0M94aVJo%3D&reserved=0</a><br>
>> This message is from an external sender. Learn more about why this <<<br>
>> matters at <a href="https://links.utexas.edu/rtyclf">https://links.utexas.edu/rtyclf</a>. <<<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>