https://redmine.openatlas.eu/https://redmine.openatlas.eu/favicon.ico?17112826112019-07-31T15:43:52ZRedmineOpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=53572019-07-31T15:43:52ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Target version</strong> set to <i>187</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=53582019-07-31T15:44:03ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Acknowledged</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=54682019-10-10T10:46:03ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Target version</strong> changed from <i>187</i> to <i>193</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=54742019-10-21T11:48:18ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Target version</strong> changed from <i>193</i> to <i>4.1.0</i></li></ul><p>Moving this feature to 4.1.0 because we will release the major version 4.0.0 first and than see if this can be implemented with the new API.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=56672020-01-23T10:30:11ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Target version</strong> changed from <i>4.1.0</i> to <i>5.0.0</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=56762020-01-24T14:35:22ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Category</strong> set to <i>Backend</i></li><li><strong>Target version</strong> changed from <i>5.0.0</i> to <i>5.2.0</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=57012020-01-29T13:52:48ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Target version</strong> changed from <i>5.2.0</i> to <i>Wishlist</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=65482020-10-07T08:59:15ZBernhard Koschiček-Krombholz
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/journals/6548/diff?detail_id=8514">diff</a>)</li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=68032021-01-07T14:56:39ZBernhard Koschiček-Krombholz
<ul><li><strong>Subject</strong> changed from <i>Import geometries</i> to <i>API: Import geometries</i></li><li><strong>Category</strong> changed from <i>Backend</i> to <i>API</i></li><li><strong>Target version</strong> changed from <i>Wishlist</i> to <i>208</i></li></ul><p>Browsing through old issues, and found that. I will move this to the API section.</p>
<p>I will start with geojson, because they don't need extra packages, are human-readable, easy to manipulate and QGIS and ArcGIS can easily convert .shp files to geojson.</p>
<p>This has to be a cooperative with the UI, since Stefan wants it in the edit view.</p>
<p>In a first version, it should be possible to upload a geojson with several geometries (no Multi Geometries and no Z value) with a name field, which creates a new entry for each geometry.</p>
Early additional features will be:
<ul>
<li>link to existing Place entity through id field</li>
<li>link to types through id if geojson import creates a new entity</li>
<li>create one entity with n geometries</li>
</ul>
<p>Question to Stefan</p>
<blockquote>
<p>WKT could be achieved by inserting the string as text and creating the polygon then via PostGIS geometry from WKT</p>
</blockquote>
<p>This can actually be done in the SQL interface provided under /sql or? Can you send me an example from you of such a string?</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=68062021-01-07T15:12:15ZBernhard Koschiček-Krombholz
<ul><li><strong>Category</strong> changed from <i>API</i> to <i>Data import/export</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=68142021-01-12T11:16:29ZBernhard Koschiček-Krombholz
<ul><li><strong>Assignee</strong> set to <i>Bernhard Koschiček-Krombholz</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=68152021-01-12T11:44:16ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul></ul><p>Just wanted to add it would be very useful to add many geometries in one go just in case this wasn't meant implicit already. What I mean is not just many geometries for one entry but also for multiple entities.<br />But first we should implement adding entities themselves.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=68162021-01-12T14:42:05ZBernhard Koschiček-Krombholz
<ul></ul>I wrote already a script that does:
<ul>
<li>link to existing Place entity through id field</li>
<li>link to types through id if geojson import creates a new entity</li>
<li>create one entity with n geometries</li>
</ul>
<p>with any amount of geometries coming from a geojson. Of course, it does only basic forms of data validation, but if the input data is fine, it works like a charm.</p>
<p>I will try to write specifications of such an import function until the meeting 28.01.21, so we can discuss this. The main format of data import will be json. Later we can add something like csv, excel and xml, because they are quite easy to convert to json.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=73832021-09-15T12:25:05ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Status</strong> changed from <i>Acknowledged</i> to <i>Assigned</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=74512021-11-04T13:05:26ZBernhard Koschiček-Krombholz
<ul><li><strong>Related to</strong> <i><a class="issue tracker-2 status-5 priority-4 priority-default closed" href="/issues/1567">Feature #1567</a>: Enhanced Import</i> added</li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=83472022-08-18T09:47:15ZBernhard Koschiček-Krombholz
<ul><li><strong>Target version</strong> changed from <i>208</i> to <i>Wishlist</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=83512022-08-18T10:14:49ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Status</strong> changed from <i>Assigned</i> to <i>Acknowledged</i></li><li><strong>Assignee</strong> deleted (<del><i>Bernhard Koschiček-Krombholz</i></del>)</li></ul><p>Removing assignees from wishlist issues, just in case anyone else wants to work on it.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=84192022-08-30T13:52:35ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Subject</strong> changed from <i>API: Import geometries</i> to <i>Import geometries</i></li><li><strong>Description</strong> updated (<a title="View differences" href="/journals/8419/diff?detail_id=10892">diff</a>)</li></ul><p>Looking into it with Bernhard just now. Removing API because implementation maybe solved another way.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=88482022-11-28T10:55:59ZBernhard Koschiček-Krombholz
<ul></ul><p>Some libraries for reading shapefile: <br /><a class="external" href="https://gis.stackexchange.com/questions/113799/reading-shapefile-in-python">https://gis.stackexchange.com/questions/113799/reading-shapefile-in-python</a></p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=88502022-11-29T08:47:41ZStefan Eichertstefan.eichert@univie.ac.at
<ul></ul><p>If we consider a shapefile import, this would probably need its own user interface in order to select which feature of the shapefile is considered to be imported.<br />A shapefile can contain multiple geometries/features like a "geom" table in PostGIS. So we would have to read the shapefile and let the user select from a list or table with a geometry preview which feature should be imported and linked to the respective entity. Also the Coordinate Reference System needs to be transformed to WGS84. Therefore the shapefile must contain the respective information or the user has to provide it. <br />I think also some kind of bulk import would be a good idea. Given the example of a cemetery plot, one could enter all the graves first and then load the shapefile of the graves. In the next step the OpenAtlas features could be correlated with the ones from the shapefile. This would really accelerate the data acquisition with already existing digital geometries e.g. in shapefile format.<br />Technically this could also be done with shp2pgsql in PostGIS: <a class="external" href="https://gis.stackexchange.com/questions/39238/how-to-import-using-shp2pgsql">https://gis.stackexchange.com/questions/39238/how-to-import-using-shp2pgsql</a></p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=94002023-03-01T15:28:22ZJona Schlegel
<ul></ul><p>This would also be interesting for INDIGO to import our sections, which we created in GIS.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=94702023-03-21T16:52:26ZBernhard Koschiček-Krombholz
<ul><li><strong>Target version</strong> changed from <i>Wishlist</i> to <i>7.17.0</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=98172023-09-12T14:04:15ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul></ul><p>shp2pgsql seems to be already part of the PostGIS Debian package and can be called (in bullseye, 3.1.1)<br />Next step would be to design the workflow when importing shape files.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=100342023-10-31T10:30:03ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Target version</strong> changed from <i>7.17.0</i> to <i>8.3.0</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=102762024-01-29T15:21:18ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Subject</strong> changed from <i>Import geometries</i> to <i>Enter WKT geometries</i></li><li><strong>Target version</strong> changed from <i>8.3.0</i> to <i>8.2.0</i></li></ul><p>We will discuss this in the next developer meeting but basically we do imports for WKT.<br />Shape files turned out to be very work intensive (needs funding), in case this is still needed please create an extra issue for this.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=102772024-01-29T15:21:41ZAlexander Watzingeralexander.watzinger@oeaw.ac.at
<ul><li><strong>Status</strong> changed from <i>Acknowledged</i> to <i>Assigned</i></li><li><strong>Assignee</strong> set to <i>Bernhard Koschiček-Krombholz</i></li></ul> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=103012024-02-08T07:54:28ZBernhard Koschiček-Krombholz
<ul><li><strong>Status</strong> changed from <i>Assigned</i> to <i>In Progress</i></li></ul><p>Since WKT ist just a text string, i will implement a additional button on the map, where the string can be entered with an additional name and description.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=103402024-02-15T13:06:10ZBernhard Koschiček-Krombholz
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/journals/10340/diff?detail_id=13154">diff</a>)</li></ul><p>Currently, WKT import for POINT, POLYLINE and POLYGON is working. Right now, POLYGON will be treated as shape. Is this enough for the beginning, or should I include a switch?</p>
<p>And multi geometries will not be supported. For this, please create a new ticket.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=103612024-02-16T11:08:21ZBernhard Koschiček-Krombholz
<ul></ul><p>Added a switch, if a polygon is entered, to choose if area or shape.</p>
<p>I have one major issue, since leaflet uses reversed coordinate system, the entered coordinates have to be reversed. I got it working for points and linestrings, but the polygon coordinates won't change. I have really no idea why and maybe someone who is more educated in JavaScript <a href="https://github.com/craws/OpenAtlas/blob/835ccaadcf348922840b9058d5df997ad4212576/openatlas/static/js/map/draw.js#L390" class="external">can take a look at it</a>.</p>
<p>Otherwise, it is working with these test WKT strings:</p>
<pre>
POINT(30 10)
LINESTRING(30 10, 10 30, 40 40)
POLYGON((30 10, 40 40, 20 40, 10 20, 30 10))
</pre> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=103742024-02-16T17:26:53ZBernhard Koschiček-Krombholz
<ul></ul><p>Fixed the problem with the polygon. <br />There is one UI issue left, which I need help with. It is very Leaflet specific, so I maybe ask Christoph.</p>
<p>After that, it is ready to deploy.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=103892024-02-19T16:11:56ZBernhard Koschiček-Krombholz
<ul><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Closed</i></li></ul><p>Basic implementation is done. At the map, under the geonames search button, is a new button where you can enter the geometry and the let it draw on the map. Then a new popup of the respective geometry will pop up and you can enter name and description.</p>
<p>Hope this is enough for the beginning. For further feedback or wishes, please create a new ticket.</p> OpenAtlas - Feature #1047: Enter WKT geometrieshttps://redmine.openatlas.eu/issues/1047?journal_id=103932024-02-20T10:36:52ZBernhard Koschiček-Krombholz
<ul></ul><p>Translations done</p>