6.5.1.7. Exporting lists and spatial data
Last updated
Last updated
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.
The lists and spatial data of a Geo-Object Type can be exported as a spreadsheet or a shapefile, respectively:
Go to the Lists and Spatial Data module either by clicking the module icon on the homepage or by clicking the hamburger menu () in the upper right corner and selecting Lists and Spatial Data.\
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).\
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.\
The list for the Geo-Object Type will open. Click the Export button.\
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.\
Once the data has been downloaded, check the default downloads folder of your computer for the downloaded data.
The downloaded file will contain the following depending on what has been selected:
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:
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.\
The second worksheet is the metadata containing information about the list.\
The third worksheet is the data dictionary providing details about the different fields/columns in the lists.\
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.\
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.\
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.