<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I think you want to </div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<ul data-editing-info="{"orderedStyleType":1,"unorderedStyleType":1}" style="margin-top: 0px; margin-bottom: 0px; list-style-type: disc;">
<li style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<div class="elementToProof">Create a dataset with the geotiff driver with appropriate data type, and 1 band</div>
</li><li style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<div class="elementToProof">Construct geotransform from the longitude/latitude arrays (google: gdal python geotransform)</div>
</li><li style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<div class="elementToProof">Write the 3<sup>rd</sup> band (values) of your array to that dataset</div>
</li></ul>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Otherwise, yeah the XYZ approach looks good since if you create a numpy array from that list, it should be shape [number of pixels, 3]</div>
<div id="appendonsend" style="color: inherit;"></div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<hr style="display: inline-block; width: 98%;">
<div id="divRplyFwdMsg" dir="ltr" style="color: inherit;"><span style="font-family: Calibri, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);"><b>From:</b> gdal-dev <gdal-dev-bounces@lists.osgeo.org> on behalf of gdal-dev-request@lists.osgeo.org <gdal-dev-request@lists.osgeo.org><br>
<b>Sent:</b> Tuesday, July 30, 2024 5:14 AM<br>
<b>To:</b> gdal-dev@lists.osgeo.org <gdal-dev@lists.osgeo.org><br>
<b>Subject:</b> gdal-dev Digest, Vol 242, Issue 48</span>
<div> </div>
</div>
<div style="font-size: 11pt;">Send gdal-dev mailing list submissions to<br>
        gdal-dev@lists.osgeo.org<br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
        <a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" id="OWA53d90644-2df1-cce0-6efc-f014d2076d5f" class="OWAAutoLink" data-auth="NotApplicable">
https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
or, via email, send a message with subject or body 'help' to<br>
        gdal-dev-request@lists.osgeo.org<br>
<br>
You can reach the person managing the list at<br>
        gdal-dev-owner@lists.osgeo.org<br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of gdal-dev digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
   1. ogr2ogr postgres index generation (Hanskaspar Frei)<br>
   2. Python-GDAL - How do I create a GeoTIFF from this array?<br>
      (Stefan Gofferje)<br>
   3. Issue with GeoJSON to DGN Conversion and Back<br>
      (Shahrukh Mirza Nawandish)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Tue, 30 Jul 2024 08:57:05 +0000<br>
From: Hanskaspar Frei <hkfrei@karten-werk.ch><br>
To: "gdal-dev@lists.osgeo.org" <gdal-dev@lists.osgeo.org><br>
Subject: [gdal-dev] ogr2ogr postgres index generation<br>
Message-ID: <b2b05d57-4e9c-4ffc-9615-ee8d5fa19f33@karten-werk.ch><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi everybody<br>
<br>
We used an old GDAL Version (3.2.1) to load data to a postgis db with<br>
ogr2ogr.<br>
There was an automatic spatial index generation taking place, which<br>
seemed to have a logic to avoid duplicated index names.<br>
<br>
Examples with GDAL 3.2.1:<br>
<br>
For a table with the name<br>
"ch059_liegenschaften_grundstueckpos_hilfslinien" a index named<br>
"ch059_liegenschaften_grundstueckpos_hilfs_wkb_geometry_geom_idx" got<br>
created.<br>
For a table with the name<br>
"ch059_liegenschaften_grundstueckpos_hilfslinien_proj" a index named<br>
"ch059_liegenschaften_grundstueckpos_hilfslinien_proj_wkb_geomet" got<br>
created.<br>
<br>
<br>
Examples with GDAL 3.9.1:<br>
For a table with the name<br>
"ch059_liegenschaften_grundstueckpos_hilfslinien" a index named<br>
"ch059_liegenschaften_grundstueckpos_hilfs_wkb_geometry_geom_idx" got<br>
created.(equal like GDAL 3.2.1)<br>
For a table with the name<br>
"ch059_liegenschaften_grundstueckpos_hilfslinien_proj" it tries to<br>
create an index named<br>
"ch059_liegenschaften_grundstueckpos_hilfs_wkb_geometry_geom_idx" which<br>
is equal to the one of the table above and therefore not valid in postgres<br>
<br>
I am aware that the the maximum identifier length in postgis is 63 Bytes<br>
and therefore the index names get cutted.<br>
<br>
But why is this change in the index naming happening between GDAL<br>
Version 3.2.1 and 3.9.1?<br>
<br>
We don't want to downgrade to the old GDAL Version, but Is there a way<br>
to go back to the old naming system which avoided duplicated names?<br>
<br>
<br>
<br>
<br>
Thanks and best regards<br>
<br>
Hanskaspar Frei<br>
<br>
--<br>
[logo]<br>
Karten-Werk GmbH<br>
Hanskaspar Frei<br>
Via Vincenzo Dalberti 13<br>
6718 Olivone<br>
<br>
Phone: +41 79 360 72 83<br>
Web: <a href="https://karten-werk.ch" id="OWA3b484671-1019-a09b-98ae-0dabebadb784" class="OWAAutoLink" data-auth="NotApplicable">
https://karten-werk.ch</a> | E-Mail: hkfrei@karten-werk.ch<mailto:hkfrei@karten-werk.ch><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/3f0680d5/attachment-0001.htm" id="OWA6581a1b0-7000-bf2f-6256-690d66836dfd" class="OWAAutoLink" data-auth="NotApplicable">http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/3f0680d5/attachment-0001.htm</a>><br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: logomarker.png<br>
Type: image/png<br>
Size: 2456 bytes<br>
Desc: logomarker.png<br>
URL: <<a href="http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/3f0680d5/attachment-0001.png" id="OWA43094d2f-abe3-77ce-7b31-d0efcb38328a" class="OWAAutoLink" data-auth="NotApplicable">http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/3f0680d5/attachment-0001.png</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Tue, 30 Jul 2024 09:03:13 +0000<br>
From: Stefan Gofferje <lists@home.gofferje.net><br>
To: gdal-dev@lists.osgeo.org<br>
Subject: [gdal-dev] Python-GDAL - How do I create a GeoTIFF from this<br>
        array?<br>
Message-ID:<br>
        <0107019102e11de9-fc989f77-4e56-433e-a182-a0f9670aaacf-000000@eu-central-1.amazonses.com><br>
       <br>
Content-Type: text/plain; charset=UTF-8; format=flowed<br>
<br>
Hi all,<br>
<br>
I'm still learning Python and GDAL.<br>
<br>
I'm pulling the NOAA Aurora forecast in Python and create an array from<br>
it in this format:<br>
<br>
[ [lon, lat, value], [lon, lat, value], [lon, lat, value] ...]<br>
<br>
like<br>
<br>
[ [-180,-90,0], [-180,-89,0], ... , [359, 89, 0], [359, 90, 0] ]<br>
<br>
I would like to write this into a 1 band GeoTIFF but I'm missing some<br>
understanding of data types apparently.<br>
I was wondering if somebody could point me in the right direction...<br>
<br>
-Stefan<br>
<br>
--<br>
  (o_   Stefan Gofferje            | SCLT, MCP, CCSA<br>
  //\   Reg'd Linux User #247167   | VCP #2263<br>
  V_/_  <a href="https://www.gofferje.net" id="OWA4441bd40-952c-2048-6c8e-238d11a910d4" class="OWAAutoLink" data-auth="NotApplicable">
https://www.gofferje.net</a>   | <a href="https://www.saakeskus.fi" id="OWAbd791010-d07b-677a-96b0-bfe4aeb55bf4" class="OWAAutoLink" data-auth="NotApplicable">
https://www.saakeskus.fi</a><br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Tue, 30 Jul 2024 14:04:39 +0300<br>
From: Shahrukh Mirza Nawandish <mirza.nawandish@haritaevi.com><br>
To: "gdal-dev@lists.osgeo.org" <gdal-dev@lists.osgeo.org><br>
Subject: [gdal-dev] Issue with GeoJSON to DGN Conversion and Back<br>
Message-ID: <327921722337401@mail.yandex.com><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/8fd52840/attachment.htm" id="OWA72385e10-3c0f-86af-f67c-4a0188b3ba62" class="OWAAutoLink" data-auth="NotApplicable">http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/8fd52840/attachment.htm</a>><br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: converter_from_dgn.geojson<br>
Type: application/json<br>
Size: 6893 bytes<br>
Desc: not available<br>
URL: <<a href="http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/8fd52840/attachment.json" id="OWA4b4db4b3-d250-985a-932f-9176eb9b5b9e" class="OWAAutoLink" data-auth="NotApplicable">http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/8fd52840/attachment.json</a>><br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: peak_sample_data_UTM_EPSG_32643.dgn<br>
Type: application/octet-stream<br>
Size: 2658 bytes<br>
Desc: not available<br>
URL: <<a href="http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/8fd52840/attachment.obj" id="OWAecbac525-a085-d1c6-e581-f7c5d1397bb9" class="OWAAutoLink" data-auth="NotApplicable">http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/8fd52840/attachment.obj</a>><br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: peak_sample_data.GeoJSON<br>
Type: application/json<br>
Size: 3081 bytes<br>
Desc: not available<br>
URL: <<a href="http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/8fd52840/attachment-0001.json" id="OWA79d16f1b-33bb-9b2a-5d0a-a6412ddb46d5" class="OWAAutoLink" data-auth="NotApplicable">http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240730/8fd52840/attachment-0001.json</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
gdal-dev mailing list<br>
gdal-dev@lists.osgeo.org<br>
<a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" id="OWA10db3771-f59a-d3d5-0c6d-af70178b55fe" class="OWAAutoLink" data-auth="NotApplicable">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
<br>
<br>
------------------------------<br>
<br>
End of gdal-dev Digest, Vol 242, Issue 48<br>
*****************************************</div>
</body>
</html>