BTS HelpDesk: 503-823-5199
111 SW Columbia St, Suite 400, Portland, OR 97201
The CivicApps data catalog has a ton of great resources, many of which are shapefiles, a proprietary format from the Environmental Systems Research Institute (ESRI). While these formats are familiar to those who work in GIS and other mapping areas, they often present challenges to developers looking to use them for data visualization or other applications.
This article gives an overview on taking ESRI shapefiles and converting them to easy-to-use GeoJSON, while translating the state plane x & y coordinates to the more familiar lat/long combinations.
The ZIP file you’ll download will contain a number of files related to the ESRI format. One file of interest here is the metadata XML file, which contains a number of interesting details about the shape file.
When you open QGIS, you’ll get a blank workspace. To open our shapefile, go to: Layer > Add Vector Layer in the toolbar.
Click “Browse” and select the zipcode_metro.shp file. This will open the shape file in QGIS.
Once you’ve got the shape file open, go to Layer > Save As... in the toolbar. Under “Format”, select “GeoJSON”. To convert the state plane coordinates to lat/long, click the “Layer CRS” drop down under “Encoding” and choose “Selected CRS”.
The CRS, or “coordinate reference system”, will be used to transform our state plane coordinates into lat/long pairs. To filter the options, type in “NAD83” (more info here) and select NAD83 under the Geographic Coordinates Systems group at the top of the “Coordinate Systems of the world” list.
Once all your selections have been made, hit ‘OK’ and your geoJSON will be saved!
Hopefully this short guide will help make government data more accessible to you, if you're unfamiliar with the world of GIS. Take a look at the CivicApps data catalog to see what's available, and enjoy your new access to geographical data!