Issue: Massive problems with the Butterfly Count app in Denmark

AnneEskildsen commented 6 months ago

Describe the issue

Many glitches with the app reported by volunteers, specifically:

[x] one or more transects completely missing in the app
[x] one or more sections missing in the transect
[x] sections appearing twice in a transect
[x] the app jumps randomly between sections during the count

Expected behaviour

expected: correct number of transects/sections visible in the app

To Reproduce

No response

App Version

v1.26.0 (346) (this is my app version, but problems reported from many different volunteers)

Device

Samsung Galaxy

When did this happen

20.-21. may

Screenshots

No response

Additional context

No response

kazlauskis commented 6 months ago

@AnneEskildsen thanks for reporting this.

Can you provide the volunteer's butterfly-monitoring.net account ID or their account email (forward the email to karolis@flumens.io)?
Can you specify which transects are missing or incorrect?
Also, which sections of the transect are missing or duplicated?

Thanks

AnneEskildsen commented 6 months ago

Hi! I have heard from many volunteers, but here are those I am sure of: Andreas Bennetsen Boe, id 379572. Two whole transects missing: 'Læsten Bakker' and 'Assentoft Bakker' Hans Paarup Thomsen, id 376116. transect 'Forst botanisk have og travbanen i Aarhus' all sections were doubled. Helene Dalgaard Clausen, id 355171. Section 2 of transect 'Kærgårdsvej ved skydebanen' missing Anne Eskildsen, id 352089, Two whole transects missing: 'Løvbakke 1' and 'Løvbakke 2'. Heidi Buur Holbeck, id 349931. One transect missing: 'Ege Carpets' + app jumped randomly between sections in transects 'Rugmarken' and 'Granplantagen'

kazlauskis commented 6 months ago

@johnvanbreda I think the issue here is that users can't see other users' locations, which we've talked about in the other thread. Regional coordinators might only need to see their own transects, but people can join other transects on the website, so this same issue applies. I am reverting the app to use the original report.

/reports/projects/ebms/ebms_app_sites_list.xml

To get all the attributes, you can use the locattrs parameter with a comma separated list of IDs, or just use the value "#all_survey_attrs" and supply an additional parameter survey_id=n where n is the survey to load all attributes for.

I'd like to retrieve all of these values. Does the locattrs or the all_survey_attrs allow this? Say to get the created_on or parent_id fields?

AnneEskildsen commented 6 months ago

Hi Karolis! I hope I am not confusing you - I din't think this has anything to do with users seeing other users locations, but simply that people cannot see their own transects, or parts of them.

kazlauskis commented 6 months ago

@AnneEskildsen I am looking at this particular site, Læsten Bakker which was created by Søgaard and is accessible to Andreas because he was invited. Is that how it was set up?

AnneEskildsen commented 6 months ago

yes, that is correct. Of the transects I mentioned above, that are causing problems, some are shared between several volunteers, but not all. Shared ones are:

Læsten Bakker
Assentoft Bakker
Ege Carpets
Løvbakke 1
Løvbakke 2

kazlauskis commented 6 months ago

Thanks. Yeah, the sharing is broken at the moment, users can only see their own-created sites.

AnneEskildsen commented 6 months ago

Ok, so that explains some of the problems! But probably not the issues of certain sections suddenly missing from some of the transects + the app jumping randomly between non-consecutive sections?

johnvanbreda commented 6 months ago

I think the issue here is that users can't see other users' locations, which we've talked about in the other thread. Regional coordinators might only need to see their own transects, but people can join other transects on the website, so this same issue applies. I am reverting the app to use the original report.

/reports/projects/ebms/ebms_app_sites_list.xml

To get all the attributes, you can use the locattrs parameter with a comma separated list of IDs, or just use the value "#all_survey_attrs" and supply an additional parameter survey_id=n where n is the survey to load all attributes for. I'd like to retrieve all of these values. Does the locattrs or the all_survey_attrs allow this? Say to get the created_on or parent_id fields?

Ah, the attributes I was referring to were the custom ones. Looking at the report, I see that that the main filter is based on you passing the Drupal user ID in a userID parameter, so the report can then return locations that are linked to the user via their Drupal ID (as opposed to filtering to the locations the user created). If so then I think we could reproduce that filter in the REST API as it's not as bespoke as I originally thought.

As a quick fix, I can add created_on and parent_id to the report. Is that all you need right now @kazlauskis?

kazlauskis commented 6 months ago

I pretty much use all of the default location model attributes, such as lat, long, geometries, etc. Can we pull these into the report?

We should also do the same to the ebms_app_sections_list.xml report, as this is a combination of the two that were used before.

Ideally, if this is not too difficult, then enhancing the REST API to support the Drupal userID would be neater on my end. The API receives JWT tokens, which contain the CMS userID. Maybe the endpoint can return all of the locations that either the warehouse user OR the CMS user is linked to by default. Would that be feasible?

johnvanbreda commented 6 months ago

@kazlauskis you can try 2 new reports I've added - ebms_app_sites_list_2 and ebms_app_sections_list_2 which should have all the attributes.

kazlauskis commented 6 months ago

@johnvanbreda thanks, I am getting a 500 error. I've tried with and without the website_id param.

11:43:34 debug Constructing XMLReportReader for report /srv/sites/warehouse1.indicia.org.uk/modules/brc_reports/reports/projects/ebms/ebms_app_sites_list_2.xml.
11:43:34 error #44: Error in Rest API report request. There was an SQL error: ERROR: column l.website_id does not exist
LINE 20: WHERE (l.website_id in (118) or l.website_id is null)

johnvanbreda commented 6 months ago

@kazlauskis can you try again now?

kazlauskis commented 6 months ago

@johnvanbreda Cool, that works well. Sorry, one tiny thing, can you rename the sref_system to centroid_sref_system? I can do that on my end, but changing this would then exactly match the REST locations API, and I can use the report as is.

kazlauskis commented 6 months ago

@johnvanbreda the ebms_app_sections_list_2 report returns some sections multiple times, I understand it doesn't filter out the deleted ones. For example, site id=321060 returns the below response:

JSON response

```js { "count": 19, "paging": { "self": "https://warehouse1.indicia.org.uk/index.php/services/rest/reports/projects/ebms/ebms_app_sections_list_2.xml?website_id=118&userID=5720&location_list=321060&known_count=19" }, "data": [ { "parent_id": "321060", "id": "321061", "name": "Kærgårdsvej ved skydebanen - S1", "code": "S1", "sref_system": "4326", "centroid_sref": "55.88536N, 9.79383E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1090133.4977663,7535504.9152508],[1090138.2750805,7535531.7876435],[1090145.4410519,7535546.7167506],[1090177.090759,7535570.0061576],[1090202.7688231,7535584.3381004],[1090232.8718211,7535598.8177169],[1090271.6874996,7535567.1680099],[1090275.2704853,7535579.1112956],[1090242.4264497,7535610.1638383],[1090282.4364567,7535684.2122094],[1090319.4606422,7535762.4407306],[1090342.152885,7535789.9102876],[1090410.2949282,7535835.4254028]]}", "created_on": "2023-06-06 22:48:55", "created_by_id": "355171", "updated_on": "2023-06-07 12:37:53", "updated_by_id": "352089", "centroid_geom": "POINT(1090244.16851589 7535627.84130272)", "boundary_geom": "LINESTRING(1090133.4977663 7535504.9152508,1090138.2750805 7535531.7876435,1090145.4410519 7535546.7167506,1090177.090759 7535570.0061576,1090202.7688231 7535584.3381004,1090232.8718211 7535598.8177169,1090271.6874996 7535567.1680099,1090275.2704853 7535579.1112956,1090242.4264497 7535610.1638383,1090282.4364567 7535684.2122094,1090319.4606422 7535762.4407306,1090342.152885 7535789.9102876,1090410.2949282 7535835.4254028)", "location_type_id": "778", "public": "f", "lat": "55.88536", "lon": "9.79383000000003" }, { "parent_id": "321060", "id": "321062", "name": "Kærgårdsvej ved skydebanen - S2", "code": "S2", "sref_system": "4326", "centroid_sref": "55.88542N, 9.79407E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1090268.8239007,7535579.1603448],[1090270.6153936,7535585.7291519],[1090240.7571794,7535607.8242304],[1090250.9089722,7535627.5306517],[1090271.8097221,7535662.1661802],[1090287.3359935,7535691.4272301],[1090305.8480863,7535726.0627585]]}", "created_on": "2023-06-06 22:48:55", "created_by_id": "355171", "updated_on": "2023-06-07 12:33:13", "updated_by_id": "352089", "centroid_geom": "POINT(1090270.88519368 7535639.75031217)", "boundary_geom": "LINESTRING(1090268.8239007 7535579.1603448,1090270.6153936 7535585.7291519,1090240.7571794 7535607.8242304,1090250.9089722 7535627.5306517,1090271.8097221 7535662.1661802,1090287.3359935 7535691.4272301,1090305.8480863 7535726.0627585)", "location_type_id": "778", "public": "f", "lat": "55.885419999999975", "lon": "9.794070000000026" }, { "parent_id": "321060", "id": "321063", "name": "Kærgårdsvej ved skydebanen - S3", "code": "S3", "sref_system": "4326", "centroid_sref": "55.88616N, 9.79481E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1090301.4377785,7535722.8467816],[1090316.9640498,7535758.6766386],[1090339.6562926,7535788.5348527],[1090371.9031639,7535807.6441098],[1090435.2025779,7535850.6399382]]}", "created_on": "2023-06-06 22:48:55", "created_by_id": "355171", "updated_on": "2023-06-07 12:32:48", "updated_by_id": "352089", "centroid_geom": "POINT(1090353.26161686 7535786.62960913)", "boundary_geom": "LINESTRING(1090301.4377785 7535722.8467816,1090316.9640498 7535758.6766386,1090339.6562926 7535788.5348527,1090371.9031639 7535807.6441098,1090435.2025779 7535850.6399382)", "location_type_id": "778", "public": "f", "lat": "55.88615999999997", "lon": "9.794809999999964" }, { "parent_id": "321060", "id": "321064", "name": "Kærgårdsvej ved skydebanen - S2", "code": "S2", "sref_system": "4326", "centroid_sref": "55.88673N, 9.79623E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1090432.8139208,7535850.5901776],[1090442.3685493,7535843.4242062],[1090502.0849777,7535888.8086917],[1090530.7488633,7535912.695263],[1090560.6070774,7535938.9704915],[1090597.631263,7535967.6343771]]}", "created_on": "2023-06-06 22:48:55", "created_by_id": "355171", "updated_on": "2023-06-07 12:34:17", "updated_by_id": "352089", "centroid_geom": "POINT(1090511.33529379 7535899.76827422)", "boundary_geom": "LINESTRING(1090432.8139208 7535850.5901776,1090442.3685493 7535843.4242062,1090502.0849777 7535888.8086917,1090530.7488633 7535912.695263,1090560.6070774 7535938.9704915,1090597.631263 7535967.6343771)", "location_type_id": "778", "public": "f", "lat": "55.886730000000014", "lon": "9.796229999999998" }, { "parent_id": "321060", "id": "321065", "name": "Kærgårdsvej ved skydebanen - S3", "code": "S3", "sref_system": "4326", "centroid_sref": "55.88725N, 9.79771E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1090595.2426059,7535967.1616156],[1090613.1575344,7535983.8822155],[1090638.2384343,7535993.4368441],[1090680.0399341,7536008.9631154],[1090690.7888912,7536012.5461011],[1090707.5094912,7536020.9064011],[1090725.4244197,7536017.3234154],[1090762.4486052,7536023.2950582]]}", "created_on": "2023-06-06 22:48:55", "created_by_id": "355171", "updated_on": "2023-06-07 12:39:02", "updated_by_id": "352089", "centroid_geom": "POINT(1090676.08814017 7536002.98394436)", "boundary_geom": "LINESTRING(1090595.2426059 7535967.1616156,1090613.1575344 7535983.8822155,1090638.2384343 7535993.4368441,1090680.0399341 7536008.9631154,1090690.7888912 7536012.5461011,1090707.5094912 7536020.9064011,1090725.4244197 7536017.3234154,1090762.4486052 7536023.2950582)", "location_type_id": "778", "public": "f", "lat": "55.88725", "lon": "9.79771000000005" }, { "parent_id": "321060", "id": "321066", "name": "Kærgårdsvej ved skydebanen - S3", "code": "S3", "sref_system": "4326", "centroid_sref": "55.88730N, 9.80087E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1090760.5653609,7536023.8329359],[1090708.8770699,7536023.2522313],[1090799.3810393,7536017.8612931],[1090823.2676107,7536016.6669645],[1090841.1825392,7536016.6669645],[1090871.0407533,7536023.2357716],[1090879.4010533,7536017.2641288],[1090888.3585175,7535999.3492003],[1090897.3159818,7535989.7945718],[1090984.2186438,7535982.2375591],[1091031.9917865,7535995.3751733],[1091082.1535863,7535955.9623306],[1091212.3354001,7535944.0190449],[1091244.5822714,7535951.1850163],[1091353.2661709,7536067.0348873],[1091482.2536561,7536082.5611587],[1091620.7957699,7536119.5853442]]}", "created_on": "2023-06-06 22:48:55", "created_by_id": "355171", "updated_on": "2023-06-07 12:39:40", "updated_by_id": "352089", "centroid_geom": "POINT(1091027.85773107 7536012.90860091)", "boundary_geom": "LINESTRING(1090760.5653609 7536023.8329359,1090708.8770699 7536023.2522313,1090799.3810393 7536017.8612931,1090823.2676107 7536016.6669645,1090841.1825392 7536016.6669645,1090871.0407533 7536023.2357716,1090879.4010533 7536017.2641288,1090888.3585175 7535999.3492003,1090897.3159818 7535989.7945718,1090984.2186438 7535982.2375591,1091031.9917865 7535995.3751733,1091082.1535863 7535955.9623306,1091212.3354001 7535944.0190449,1091244.5822714 7535951.1850163,1091353.2661709 7536067.0348873,1091482.2536561 7536082.5611587,1091620.7957699 7536119.5853442)", "location_type_id": "778", "public": "f", "lat": "55.88730000000001", "lon": "9.800869999999989" }, { "parent_id": "321060", "id": "321067", "name": "Kærgårdsvej ved skydebanen - S7", "code": "S7", "sref_system": "4326", "centroid_sref": "55.88716N, 9.80052E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1090894.7430426,7535992.1090742],[1090922.2125997,7535986.1374313],[1090954.459471,7535986.1374313],[1090984.3176851,7535983.7487742],[1091015.3702279,7535990.9147456],[1091029.7021707,7535996.8863884],[1091048.8114277,7535983.7487742],[1091065.5320277,7535962.25086]]}", "created_on": "2023-06-06 22:48:55", "created_by_id": "355171", "updated_on": "2023-06-07 12:23:18", "updated_by_id": "352089", "centroid_geom": "POINT(1090988.89590929 7535985.1195948)", "boundary_geom": "LINESTRING(1090894.7430426 7535992.1090742,1090922.2125997 7535986.1374313,1090954.459471 7535986.1374313,1090984.3176851 7535983.7487742,1091015.3702279 7535990.9147456,1091029.7021707 7535996.8863884,1091048.8114277 7535983.7487742,1091065.5320277 7535962.25086)", "location_type_id": "778", "public": "f", "lat": "55.88716000000002", "lon": "9.800519999999969" }, { "parent_id": "321060", "id": "321068", "name": "Kærgårdsvej ved skydebanen - S7", "code": "S7", "sref_system": "4326", "centroid_sref": "55.88699N, 9.80202E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1091064.3376991,7535961.3053438],[1091089.418599,7535954.1393724],[1091137.1917417,7535951.7507153],[1091189.7421986,7535945.7790724],[1091208.8514557,7535943.3904153],[1091243.4869841,7535948.1677296]]}", "created_on": "2023-06-06 22:48:55", "created_by_id": "355171", "updated_on": "2023-06-07 12:25:15", "updated_by_id": "352089", "centroid_geom": "POINT(1091155.87514548 7535951.37593642)", "boundary_geom": "LINESTRING(1091064.3376991 7535961.3053438,1091089.418599 7535954.1393724,1091137.1917417 7535951.7507153,1091189.7421986 7535945.7790724,1091208.8514557 7535943.3904153,1091243.4869841 7535948.1677296)", "location_type_id": "778", "public": "f", "lat": "55.88698999999997", "lon": "9.80201999999997" }, { "parent_id": "321060", "id": "321069", "name": "Kærgårdsvej ved skydebanen - S7", "code": "S7", "sref_system": "4326", "centroid_sref": "55.88737N, 9.80344E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1091242.2005146,7535948.6404842],[1091349.6900856,7536065.6846838],[1091348.495757,7536066.8790123]]}", "created_on": "2023-06-06 22:48:55", "created_by_id": "355171", "updated_on": "2023-06-07 12:25:58", "updated_by_id": "352089", "centroid_geom": "POINT(1091313.94882241 7536026.80314155)", "boundary_geom": "LINESTRING(1091242.2005146 7535948.6404842,1091349.6900856 7536065.6846838,1091348.495757 7536066.8790123)", "location_type_id": "778", "public": "f", "lat": "55.88736999999998", "lon": "9.803440000000002" }, { "parent_id": "321060", "id": "321070", "name": "Kærgårdsvej ved skydebanen - S7", "code": "S7", "sref_system": "4326", "centroid_sref": "55.88768N, 9.80494E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1091349.7808638,7536066.6304357],[1091466.8250633,7536078.5737213],[1091626.8650912,7536121.5695498]]}", "created_on": "2023-06-06 22:48:55", "created_by_id": "355171", "updated_on": "2023-06-07 12:28:14", "updated_by_id": "352089", "centroid_geom": "POINT(1091480.9280586 7536088.33640851)", "boundary_geom": "LINESTRING(1091349.7808638 7536066.6304357,1091466.8250633 7536078.5737213,1091626.8650912 7536121.5695498)", "location_type_id": "778", "public": "f", "lat": "55.88767999999999", "lon": "9.804940000000002" }, { "parent_id": "321060", "id": "321162", "name": "Kærgårdsvej ved skydebanen - S2", "code": "S2", "sref_system": "4326", "centroid_sref": "55.88447N, 9.79295E", "geom": "{\"type\":\"LineString\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[[1090401.9346282,7535831.8424171],[1090419.8495567,7535824.6764457],[1090461.6510565,7535858.1176456],[1090546.4483848,7535938.1376596],[1090596.6101846,7535976.3561737],[1090704.0997556,7536020.5463307]]}", "created_on": "2023-06-07 12:35:51", "created_by_id": "352089", "updated_on": "2023-06-07 12:40:52", "updated_by_id": "352089", "centroid_geom": "POINT(1090146.20736399 7535451.19315764)", "boundary_geom": "LINESTRING(1090401.9346282 7535831.8424171,1090419.8495567 7535824.6764457,1090461.6510565 7535858.1176456,1090546.4483848 7535938.1376596,1090596.6101846 7535976.3561737,1090704.0997556 7536020.5463307)", "location_type_id": "778", "public": "f", "lat": "55.884470000000015", "lon": "9.792950000000012" }, { "parent_id": "321060", "id": "321163", "name": "Kærgårdsvej ved skydebanen - S2", "code": "S2", "sref_system": "4326", "centroid_sref": "55.88447N, 9.79295E", "geom": "{\"type\":\"Point\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[1090146.20736399,7535451.19315764]}", "created_on": "2023-06-07 12:36:13", "created_by_id": "352089", "updated_on": "2023-06-07 12:38:06", "updated_by_id": "352089", "centroid_geom": "POINT(1090146.20736399 7535451.19315764)", "location_type_id": "778", "public": "f", "lat": "55.884470000000015", "lon": "9.792950000000012" }, { "parent_id": "321060", "id": "322362", "name": "Kærgårdsvej ved skydebanen - S4", "code": "S4", "sref_system": "4326", "centroid_sref": "55.88447N, 9.79295E", "geom": "{\"type\":\"Point\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[1090146.20736399,7535451.19315764]}", "created_on": "2023-06-20 21:10:03", "created_by_id": "352089", "updated_on": "2023-06-20 21:10:03", "updated_by_id": "352089", "centroid_geom": "POINT(1090146.20736399 7535451.19315764)", "location_type_id": "778", "public": "f", "lat": "55.884470000000015", "lon": "9.792950000000012" }, { "parent_id": "321060", "id": "322363", "name": "Kærgårdsvej ved skydebanen - S5", "code": "S5", "sref_system": "4326", "centroid_sref": "55.88447N, 9.79295E", "geom": "{\"type\":\"Point\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[1090146.20736399,7535451.19315764]}", "created_on": "2023-06-20 21:10:03", "created_by_id": "352089", "updated_on": "2023-06-20 21:10:03", "updated_by_id": "352089", "centroid_geom": "POINT(1090146.20736399 7535451.19315764)", "location_type_id": "778", "public": "f", "lat": "55.884470000000015", "lon": "9.792950000000012" }, { "parent_id": "321060", "id": "322364", "name": "Kærgårdsvej ved skydebanen - S6", "code": "S6", "sref_system": "4326", "centroid_sref": "55.88447N, 9.79295E", "geom": "{\"type\":\"Point\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[1090146.20736399,7535451.19315764]}", "created_on": "2023-06-20 21:10:03", "created_by_id": "352089", "updated_on": "2023-06-20 21:10:03", "updated_by_id": "352089", "centroid_geom": "POINT(1090146.20736399 7535451.19315764)", "location_type_id": "778", "public": "f", "lat": "55.884470000000015", "lon": "9.792950000000012" }, { "parent_id": "321060", "id": "322365", "name": "Kærgårdsvej ved skydebanen - S7", "code": "S7", "sref_system": "4326", "centroid_sref": "55.88447N, 9.79295E", "geom": "{\"type\":\"Point\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[1090146.20736399,7535451.19315764]}", "created_on": "2023-06-20 21:10:03", "created_by_id": "352089", "updated_on": "2023-06-20 21:10:03", "updated_by_id": "352089", "centroid_geom": "POINT(1090146.20736399 7535451.19315764)", "location_type_id": "778", "public": "f", "lat": "55.884470000000015", "lon": "9.792950000000012" }, { "parent_id": "321060", "id": "322366", "name": "Kærgårdsvej ved skydebanen - S8", "code": "S8", "sref_system": "4326", "centroid_sref": "55.88447N, 9.79295E", "geom": "{\"type\":\"Point\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[1090146.20736399,7535451.19315764]}", "created_on": "2023-06-20 21:10:03", "created_by_id": "352089", "updated_on": "2023-06-20 21:10:03", "updated_by_id": "352089", "centroid_geom": "POINT(1090146.20736399 7535451.19315764)", "location_type_id": "778", "public": "f", "lat": "55.884470000000015", "lon": "9.792950000000012" }, { "parent_id": "321060", "id": "322367", "name": "Kærgårdsvej ved skydebanen - S9", "code": "S9", "sref_system": "4326", "centroid_sref": "55.88447N, 9.79295E", "geom": "{\"type\":\"Point\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[1090146.20736399,7535451.19315764]}", "created_on": "2023-06-20 21:10:03", "created_by_id": "352089", "updated_on": "2023-06-20 21:10:03", "updated_by_id": "352089", "centroid_geom": "POINT(1090146.20736399 7535451.19315764)", "location_type_id": "778", "public": "f", "lat": "55.884470000000015", "lon": "9.792950000000012" }, { "parent_id": "321060", "id": "322368", "name": "Kærgårdsvej ved skydebanen - S10", "code": "S10", "sref_system": "4326", "centroid_sref": "55.88447N, 9.79295E", "geom": "{\"type\":\"Point\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"EPSG:900913\"}},\"coordinates\":[1090146.20736399,7535451.19315764]}", "created_on": "2023-06-20 21:10:03", "created_by_id": "352089", "updated_on": "2023-06-20 21:10:03", "updated_by_id": "352089", "centroid_geom": "POINT(1090146.20736399 7535451.19315764)", "location_type_id": "778", "public": "f", "lat": "55.884470000000015", "lon": "9.792950000000012" } ] } ```

johnvanbreda commented 6 months ago

I've renamed sref_system to centroid_sref_system and filtered out deleted locations @kazlauskis.

kazlauskis commented 6 months ago

@johnvanbreda thanks!

This is done now and will appear in the next app version, v1.26.2, once the app stores approve it.

BiologicalRecordsCentre / ABLE