https://wiki.schwatke.de/index.php?action=history&feed=atom&title=MySQL_Spatial_%2B_Shapely MySQL Spatial + Shapely - Versionsgeschichte 2026-07-04T18:50:58Z Versionsgeschichte dieser Seite in Wiki MediaWiki 1.28.0 https://wiki.schwatke.de/index.php?title=MySQL_Spatial_%2B_Shapely&diff=1669&oldid=prev 129.187.36.61 am 11. März 2021 um 09:40 Uhr 2021-03-11T09:40:47Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='de'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 11. März 2021, 09:40 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l18" >Zeile 18:</td> <td colspan="2" class="diff-lineno">Zeile 18:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; UPDATE tablenname SET field=GeomFromText(&#039;Polygon((-102.3031 45.675, -102.3168 45.7129, -102.2948 45.7426, -102.2729 45.7469, -102.3113 45.7757, -102.3182 45.8034, -102.2653 45.802, -102.1864 45.7546, -102.1802 45.7393, -102.2186 45.7354, -102.2413 45.7091, -102.2646 45.7023, -102.2749 45.6726, -102.3031 45.675))&#039;) WHERE id=XXX</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; UPDATE tablenname SET field=GeomFromText(&#039;Polygon((-102.3031 45.675, -102.3168 45.7129, -102.2948 45.7426, -102.2729 45.7469, -102.3113 45.7757, -102.3182 45.8034, -102.2653 45.802, -102.1864 45.7546, -102.1802 45.7393, -102.2186 45.7354, -102.2413 45.7091, -102.2646 45.7023, -102.2749 45.6726, -102.3031 45.675))&#039;) WHERE id=XXX</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Intersection </ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> SELECT pass,ST_AsText(ST_Intersection(ST_GeomFromText(&quot;LINESTRING(-180 0, 360 0)&quot;),track)) FROM `sentinel3a_nominal`</ins></div></td></tr> </table> 129.187.36.61 https://wiki.schwatke.de/index.php?title=MySQL_Spatial_%2B_Shapely&diff=1648&oldid=prev Chris am 13. Mai 2020 um 07:50 Uhr 2020-05-13T07:50:16Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='de'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 13. Mai 2020, 07:50 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l12" >Zeile 12:</td> <td colspan="2" class="diff-lineno">Zeile 12:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; ref_area = loads(d[&#039;ref_area&#039;])</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; ref_area = loads(d[&#039;ref_area&#039;])</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; area_min_lon,area_min_lat,area_max_lon,area_max_lat = ref_area.bounds</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; area_min_lon,area_min_lat,area_max_lon,area_max_lat = ref_area.bounds</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Update Geometry with MySQL</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> UPDATE tablenname SET field=GeomFromText(&#039;POINT(-102.2278 45.7535)&#039;) WHERE id=XXX</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> UPDATE tablenname SET field=GeomFromText(&#039;Polygon((-102.3031 45.675, -102.3168 45.7129, -102.2948 45.7426, -102.2729 45.7469, -102.3113 45.7757, -102.3182 45.8034, -102.2653 45.802, -102.1864 45.7546, -102.1802 45.7393, -102.2186 45.7354, -102.2413 45.7091, -102.2646 45.7023, -102.2749 45.6726, -102.3031 45.675))&#039;) WHERE id=XXX</ins></div></td></tr> </table> Chris https://wiki.schwatke.de/index.php?title=MySQL_Spatial_%2B_Shapely&diff=1637&oldid=prev Chris: Die Seite wurde neu angelegt: „ from shapely.wkt import dumps, loads from shapely.geometry import Point from shapely.geometry.polygon import Polygon Select 'AsText(ref_location)','AsTex…“ 2018-04-23T07:45:56Z <p>Die Seite wurde neu angelegt: „ from shapely.wkt import dumps, loads from shapely.geometry import Point from shapely.geometry.polygon import Polygon Select &#039;AsText(ref_location)&#039;,&#039;AsTex…“</p> <p><b>Neue Seite</b></p><div><br /> from shapely.wkt import dumps, loads<br /> from shapely.geometry import Point<br /> from shapely.geometry.polygon import Polygon<br /> <br /> Select &#039;AsText(ref_location)&#039;,&#039;AsText(ref_area)&#039; FROM Table <br /> <br /> ref_location = loads(d[&#039;ref_location&#039;])<br /> area_ref_lon = ref_location.x<br /> area_ref_lat = ref_location.y<br /> <br /> ref_area = loads(d[&#039;ref_area&#039;])<br /> area_min_lon,area_min_lat,area_max_lon,area_max_lat = ref_area.bounds</div> Chris