# Export polygon from Aggregate **URL:** \ **Category:** Support\ **Created:** [October 17, 2018, 9:10am UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740 "2018-10-17T09:10:29Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Eddy\_Rellum](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/e/45deac/32.png) [@Eddy\_Rellum](https://forum.getodk.org/u/Eddy_Rellum)\ **Post date:** [October 17, 2018, 9:10am UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740/1 "2018-10-17T09:10:29Z")
Dear all, I have defined a polygon field in ODK collect with 15,999 characters. It seems to work well regarding the collection of polygon data. But the challenge now is to retrieve it from Aggregate. I tried export to CSV, KML and JSON and tried to load it into QGIS. I tried downloading with Briefcase and see how to convert it to a GIS format. I also tried Mobile Data Conversion Kit from GeoODK, but this also seems to bug... (never ending processing...) I also set up a connection with Google Fusion, but this does not seem to read the geoformat of Aggregate. Is there any solution how to do this and show my polygon features? PS: My polygon field is in a group & has 15,999 characters. Maybe this is the bottleneck. Any suggestions of people who experienced the same problem? Thanks! ---
**Author:** ![mathieubossaert](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/mathieubossaert/32/6131_2.png) [@mathieubossaert](https://forum.getodk.org/u/mathieubossaert)\ **Post date:** [October 17, 2018, 2:16pm UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740/2 "2018-10-17T14:16:23Z")
geometry storage into aggregate is not "standard". The string stores 4 dimension for each edge and ends with the first one (to close the line). We faced it and then created a function on PostgreSQL to generate proper geometries. So this post might help you if you store your datas into PostgreSQL : > [@Geo fields should be stored in wkt format (Well Known Text)](https://forum.getodk.org/t/geo-fields-should-be-stored-in-wkt-format-well-known-text/7048): > > Good evening everybody, I would like to suggest some improvement of the spatial data storage. Actually, geopoint are stored into 4 attributes (longitude, latitude, elevation and accuracy), Geotrace and geoshape are stored in a text field. The format of that string is not so simple. The use of Well Known Text format could be a great enhancement. All the databases supported by odk do understand that GIS format. [https://fr.wikipedia.org/wiki/Well-known\_text](https://fr.wikipedia.org/wiki/Well-known_text) Actually we have to create some fun sq… And, in any case, this discussion will be interesting to follow : [Add a GeoJSON export to Briefcase and Aggregate](https://forum.getodk.org/t/add-a-geojson-export-to-briefcase-and-aggregate/15184) ---
**Author:** ![Eddy\_Rellum](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/e/45deac/32.png) [@Eddy\_Rellum](https://forum.getodk.org/u/Eddy_Rellum)\ **Post date:** [October 18, 2018, 4:48pm UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740/3 "2018-10-18T16:48:58Z")
Thanks Mathieu, I will see if I can manage this. As I understand there is no simple straight forward solution yet. But why is the Mobile Data Conversion Kit from GeoODK not working...? I tried several things, but it seems that this tool has a serious bug. ---
**Author:** ![mathieubossaert](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/mathieubossaert/32/6131_2.png) [@mathieubossaert](https://forum.getodk.org/u/mathieubossaert)\ **Post date:** [October 19, 2018, 11:25am UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740/4 "2018-10-19T11:25:01Z")
"Mobile Data Conversion" has not been updated since 2014, and as far as I can see into the Github source files, this application does only manage lat/long based point geometries. I don't know which software you usually use to manage GIS data. Did you get a look at the QgisODK extension for QGIS : [https://github.com/enricofer/QgisODK](https://github.com/enricofer/QgisODK) ---
**Author:** ![Eddy\_Rellum](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/e/45deac/32.png) [@Eddy\_Rellum](https://forum.getodk.org/u/Eddy_Rellum)\ **Post date:** [October 22, 2018, 5:19pm UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740/5 "2018-10-22T17:19:27Z")
Hi Mathieu, Thanks for the clarification about Mobile Data Converter. I use QGIS. I tried the QgisODK tool but it appears that you need to generate your ODK collect form through this tool in order to download the polygons...(?) I think. Anyway, it gives me an error as soon as I try to connect to my aggregate... I am wondering how all other users using the geotracing tool are now downloading or visualising their polygon data... As the geotrace/geoshape tool is quiet important for many users, I think it is quiet urgent to have something userfriendly to download the polygon data in user friendly format... ---
**Author:** ![mathieubossaert](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/mathieubossaert/32/6131_2.png) [@mathieubossaert](https://forum.getodk.org/u/mathieubossaert)\ **Post date:** [October 22, 2018, 5:40pm UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740/6 "2018-10-22T17:40:28Z")
Eddy, I think @ggalmazor eared you 😉 > [@Add a GeoJSON export to Briefcase and Aggregate](https://forum.getodk.org/t/add-a-geojson-export-to-briefcase-and-aggregate/15184/43): > > Hi, all! I've just pushed a PR with a working version of the new GeoJSON export type for Briefcase. If you want to try it, you can use this JAR file: [https://github.com/opendatakit/briefcase/files/2499280/briefcase-geojson.jar.zip](https://github.com/opendatakit/briefcase/files/2499280/briefcase-geojson.jar.zip) Any feedback will be very valuable! You can write it directly to the PR: [https://github.com/opendatakit/briefcase/pull/669](https://github.com/opendatakit/briefcase/pull/669) Don't hesitate to contact @Enrico_Ferreguti about QgisODK ---
**Author:** ![mathieubossaert](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/mathieubossaert/32/6131_2.png) [@mathieubossaert](https://forum.getodk.org/u/mathieubossaert)\ **Post date:** [October 22, 2018, 5:42pm UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740/7 "2018-10-22T17:42:25Z")
I agrre with you, the more it will be easy to get GIS data from aggregate for non DBA users, the more ODK will be use to collect geographical data. ---
**Author:** ![Eddy\_Rellum](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/e/45deac/32.png) [@Eddy\_Rellum](https://forum.getodk.org/u/Eddy_Rellum)\ **Post date:** [October 22, 2018, 6:16pm UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740/8 "2018-10-22T18:16:05Z")
I seems so...🙂 Interesting! Ik will try it immedeately...! Many thanks! ---
**Author:** ![Eddy\_Rellum](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/e/45deac/32.png) [@Eddy\_Rellum](https://forum.getodk.org/u/Eddy_Rellum)\ **Post date:** [October 23, 2018, 7:17am UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740/9 "2018-10-23T07:17:30Z")
Works smootly! Great work. ---
**Author:** ![ggalmazor](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ggalmazor/32/2702_2.png) [@ggalmazor](https://forum.getodk.org/u/ggalmazor)\ **Post date:** [November 23, 2018, 9:17am UTC](https://forum.getodk.org/t/export-polygon-from-aggregate/15740/10 "2018-11-23T09:17:20Z")
Hi, folks! We've just released Briefcase v1.13, which includes a new GeoJSON export option. Check it out: [ODK Briefcase v1.13](https://forum.getodk.org/t/odk-briefcase-v1-13/16442)