<html xmlns:v="urn:schemas-microsoft-com:vml" 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=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
code
{mso-style-priority:99;
font-family:"Courier New";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.gmail-hljs-keyword
{mso-style-name:gmail-hljs-keyword;}
span.gmail-hljs-number
{mso-style-name:gmail-hljs-number;}
span.gmail-hljs-string
{mso-style-name:gmail-hljs-string;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>1) Are you sure QGIS is not setting the SRID to 2154 for some reason <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>2) Are you sure your QGIS load is not erroring out for some reason, e.g. you file is not multipolygon but instead POINT or POLYGON.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>3) Also to allow mixed geometry SRID, you don’t need to pass in the srid.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>This is slightly shorter and clearer in purpose:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><pre><span class=gmail-hljs-keyword>alter</span><code> </code><span class=gmail-hljs-keyword>table</span><code> activite.prescription<o:p></o:p></code></pre><pre><span class=gmail-hljs-keyword>alter</span><code> </code><span class=gmail-hljs-keyword>column</span><code> geom type geometry(MULTIPOLYGON);<o:p></o:p></code></pre><pre><code><o:p> </o:p></code></pre><pre><code><o:p> </o:p></code></pre><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>mathias cunault<br><b>Sent:</b> Friday, May 13, 2022 8:06 AM<br><b>To:</b> postgis-users@lists.osgeo.org<br><b>Subject:</b> [postgis-users] can't import a shapefile with different SRID in a geometry column<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><div><div><p><strong><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>PostgreSQL 13, PostGIS 3, QGIS 3.22</span></strong><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'><o:p></o:p></span></p><p><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>In a table, I had a geometry column geom with a SRID 2154.<br>Now I have to store geometries with different SRIDs in geom. So I did :<o:p></o:p></span></p><pre><span class=gmail-hljs-keyword>alter</span><code> </code><span class=gmail-hljs-keyword>table</span><code> activite.prescription<o:p></o:p></code></pre><pre><span class=gmail-hljs-keyword>alter</span><code> </code><span class=gmail-hljs-keyword>column</span><code> geom type geometry(MULTIPOLYGON, </code><span class=gmail-hljs-number>0</span><code>),<o:p></o:p></code></pre><p><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>to be able to store different SRIDs, replacing 2154 with 0.<o:p></o:p></span></p><pre><span class=gmail-hljs-keyword>SELECT</span><code> Find_SRID(</code><span class=gmail-hljs-string>'activite'</span><code>, </code><span class=gmail-hljs-string>'prescription'</span><code>, </code><span class=gmail-hljs-string>'geom'</span><code>)<o:p></o:p></code></pre><p><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>returns 0 as expected.<o:p></o:p></span></p><p><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>Now I try to upload a shapefile with a SRID 5490 using QGIS and the plugin </span><code><span style='font-size:10.0pt'>export to PostgreSQL</span></code><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>. (The shapefile has the correct .prj file)<o:p></o:p></span></p><p><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>If the shp is imported correctly, even the geometry, its SRID is "converted" in 2154. It is not a reprojection but just a ununderstandable change. No trigger is activated.<o:p></o:p></span></p><pre><span class=gmail-hljs-keyword>select</span><code> </code><span class=gmail-hljs-keyword>distinct</span><code> st_srid(geom) </code><span class=gmail-hljs-keyword>from</span><code> activite.prescription<o:p></o:p></code></pre><p><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>returns just <strong><span style='font-family:"Verdana",sans-serif'>one</span></strong> SRID 2154!<o:p></o:p></span></p><p><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>When I load the layer in QGIS choosing 5490 to display the feature, the layer is indeed empty.<o:p></o:p></span></p><p><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>When I run a query like </span><code><span style='font-size:10.0pt'>select st_setsrid(geom)...</span></code><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'> applied to the feature imported, it returns 2154 so to speak the SRID initially existing.<o:p></o:p></span></p><p><span style='font-size:18.0pt;font-family:"Verdana",sans-serif'>Why can't I keep the different SRIDs ?<o:p></o:p></span></p></div></div></div><div><div><div><div><div><div><div><div><div><div><div><div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><i>----------</i><o:p></o:p></p></div><div><p class=MsoNormal><i><span style='font-size:7.5pt'>Mathias Cunault</span></i><o:p></o:p></p></div></div></div><div><p class=MsoNormal><i><span style='font-size:7.5pt'>référent SIG / Admin Caviar<br>Inrap Tours - 148 av. Maginot<br>37000 TOURS<br>06 32 05 98 96</span></i><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:7.5pt'>abonnez-vous à la lettre d'information de l'Inrap : <a href="http://www.inrap.fr/newsletter.php" target="_blank">http://ww</a><a href="http://www.inrap.fr/newsletter.php" target="_blank">w.inrap.fr/newsletter.php</a></span><o:p></o:p></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></body></html>