# 6.5.1.7. Exporting lists and spatial data

{% hint style="info" %}
Registry Administrators, Registry Maintainers and Registry Contributors can export the lists and spatial data for the Geo-Object Types in their organization, and for Geo-Object Types belonging to other organizations that are publicly visible.
{% endhint %}

The lists and spatial data of a Geo-Object Type can be exported as a spreadsheet or a shapefile, respectively:

1. Go to the *Lists and Spatial Data* module either by clicking the module icon on the homepage or by clicking the hamburger menu (![](https://lh3.googleusercontent.com/4ieAODNcwrlKZ6iUiZnYlbLGZmQJiEse_Z8mls7B1vwiKHOfldO3TWH3smxfa1IJQb_BhxM7c6iTe--Wm0sPvlovt4jp-DaoMkTqq5MNslg-imIrXqyoa3A3Fnq-Ct_7AAaQzW-xMCIbev1kGSUU8xN5v8iFIayG4z8c4H78mU80Ms6J_4PBB1ghQw)) in the upper right corner and selecting **Lists and Spatial Data**.\\

   <figure><img src="https://3732932512-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9giVyCrmTxAs33YrSRbJ%2Fuploads%2FtdjYb0MObuGZVHZVXXgI%2Fimage.png?alt=media&#x26;token=d53db434-159a-4d07-b58d-65c6b599516c" alt=""><figcaption></figcaption></figure>
2. In the left sidebar, find and click the Geo-Object Type of which you would like to export the list and/or spatial data. Then click on the set from which you want to perform the export (the *Community health worker (MOH)* Geo-Object Type in the example below).\\

   <figure><img src="https://3732932512-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9giVyCrmTxAs33YrSRbJ%2Fuploads%2FjZfrqKK2wQK8HGi70hTT%2Fimage.png?alt=media&#x26;token=3a4e2a6e-1c18-4eb8-8041-d15a0f7c4a5e" alt=""><figcaption></figcaption></figure>
3. Depending on the type of set, you might see one or more instances in the set (one per date or period of validity). Decide for which instance you want to do the export (only one in the example here, dated *2022-03-03*) and if you want to export the working version or the published version and under that version, click **List**.\\

   <figure><img src="https://3732932512-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9giVyCrmTxAs33YrSRbJ%2Fuploads%2Fkq8mqEpoSlwtjEcEIW5i%2Fimage.png?alt=media&#x26;token=33795a2a-e8ab-42bb-9927-4a9a0cef7031" alt=""><figcaption></figcaption></figure>
4. The list for the Geo-Object Type will open. Click the **Export** button.\\

   <figure><img src="https://3732932512-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9giVyCrmTxAs33YrSRbJ%2Fuploads%2FP73oBQKCjDQPnDClucki%2Fimage.png?alt=media&#x26;token=a2e64848-3fd1-4ef9-b12c-82fe4a4850d7" alt=""><figcaption></figcaption></figure>
5. The *Export* window opens. Select whether you would like to export the list (spreadsheet) or the spatial data (shapefile) and then click the **Submit** button.\\

   <figure><img src="https://lh3.googleusercontent.com/tX344nIeXFt4DF78ZaDvxdqIFhUbB-A862QfwBWdXGl_f1vZhzjoiYFX3mwUe_wBS6oKUGfkC3Zeuirz2cFb2fnvpcPRTOrmf8BFwZFhkwFGzSEPoIMtSDf2xNLoeK-JUxdHgBEdGQ9JoOte828GyQPUu_4C8bc2sSCh68K7LrhD3JcEGnwApMmSxA" alt=""><figcaption></figcaption></figure>
6. Once the data has been downloaded, check the default downloads folder of your computer for the downloaded data.
7. The downloaded file will contain the following depending on what has been selected:
   1. *List (spreadsheet)*: The downloaded list is in .XLSX format with the file name being the Geo-Object Type code and the start date of validity of the selected list. In the example below, the downloaded list is of the *Community health worker (MOH)* type with the starting date of validity of *2022-03-03,* so the downloaded file name is *CHW-2022-03-03.xlsx*. This file has three worksheets:
      1. The first worksheet contains the list of the Geo-Objects as it appears in GeoPrism Registry. The worksheet name is the first 31 characters of the name of the list and spatial data set in GeoPrism Registry.\\

         <figure><img src="https://lh6.googleusercontent.com/ozu5nxtx3EbnCntc8uNt6qQt0zcDnc-fibziRoGPUMS7sB0-B-QIgHHJjJKEfuZsqsciZw53y6HNM7GpVivEXo3GO7WJKD1DhJ2adzT50I_t6I1reTBXePNH0oF6HNFXMY2MYcELJRwj40FWBDOxtTLaWWZjXHkzurbgt9B-cI_NyduWS5Gub3SJqQ" alt=""><figcaption></figcaption></figure>
      2. The second worksheet is the metadata containing information about the list.\\

         <figure><img src="https://3732932512-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9giVyCrmTxAs33YrSRbJ%2Fuploads%2FeNBVFpFW2KMlLjorGpeB%2Fimage.png?alt=media&#x26;token=b7001c0f-c539-4705-a10c-2cf81e7d1560" alt=""><figcaption></figcaption></figure>
      3. The third worksheet is the data dictionary providing details about the different fields/columns in the lists.\\

         <figure><img src="https://3732932512-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9giVyCrmTxAs33YrSRbJ%2Fuploads%2FOT7MqVPj3lrCI4NORGZs%2Fimage.png?alt=media&#x26;token=52b44b44-ca81-483c-bacf-154fe2405272" alt=""><figcaption></figcaption></figure>
   2. *Spatial data (shapefile)*: The downloaded spatial data is stored in a compressed file (.ZIP) with the file name being the Geo-Object Type code and the start date of validity of the selected spatial data. In the example below, the downloaded spatial data is of the *Community health worker (MOH)* type with the starting date of validity of *2022-03-03* so the downloaded file name is *CHW-2022-03-03.zip*. The .ZIP file contains the six files composing a shapefile and a metadata file containing the information about the shapefile in .XLSX file format.\\

      1. You may now open the shapefile in your preferred geographic information system (GIS) software. The attribute table of the shapefile contains the information about the Geo-Objects as it appears in GeoPrism Registry. The field names are abbreviated due to the field name length restriction for shapefiles. You will find the complete description of the field names in the *Data Dictionary* worksheet of the metadata file.\\

         <figure><img src="https://lh5.googleusercontent.com/cZW_eFsbbB8BNproJmGO6gXqk-OIlCJwMwsGHtZeSBJDATLtadlMxXS4B9THyl82GSl9gtY9y7bM46ztHV79hOFBi9VyNUc-GevXadLo7sZ2hmcVtKkEwf0MMcTiaZVdW3w8pkl7sUlPXB6ZGJXWwvNdryhd63GurYXrUbGTpWI52XvViZBoHxwtXg" alt=""><figcaption></figcaption></figure>
      2. The metadata file contains two worksheets, *Metadata* and *Data Dictionary*, of which the content is the same as the one obtained when downloading the list.

      <figure><img src="https://lh6.googleusercontent.com/qAiVur-H3PezIq2iP_MNwsxdw1VK6A6IQqmMFzdkv4m5gdqg7u1vviIDuXB5jMSPnzNqGXBO_yHnOVCuD71n2QXQGhsTF7b7nmEZlbATNoFgqe2CyKSguESBFBH8CI99dI-UKbkyJf_CimOpO0QhyC8NgK0CEXOSm5XRspykiWfeTfSG0eBkuLThnQ" alt=""><figcaption></figcaption></figure>
