Progress…

October 9th, 2009

As of today, we have acquired data from 35 of 39 counties. Data from 34 counties has been reviewed. 14 counties have been normalized. Garfield, Ferry, and Skamania counties now have GIS parcels. Wahkiakum and Columbia counties are unable to participate due to technical issues, but their data may be available in the future.

2009 Database Progress

August 12th, 2009

The Parcels Working Group Technical Sub-Committee met on July 15, 2009, to discuss changes to the database format.  Suggestions and comments we’ve received about field names, attribute domains, data types, unique identifiers and various other technical issues were addressed.  The updated format is being implemented for the 2009 version of the database.

2009 Parcel Database Development

July 8th, 2009

In the middle of  May we contacted Washington’s 39 counties to begin collecting the data for the next round of the Washington State Parcel Database.  Development is well underway.

FME Training

May 11th, 2009

In April, we spent two days at Safe Software’s headquartes in Surrey, BC, attending an FME training.  As we continue to develop the Washington State Parcel Database detecting changes in the parcel data from different dates will be a central component.  We believe FME is the tool to use to detect and understand these changes in parcel geometry and attributes.

FME Help File

May 19th, 2008

We just had a good start to a Monday. We were finally able to find an on-line version of the FME help documentation, rather than downloading PDFs. Our lives will be made much easier with this link: http://docs.safe.com/fme/html/Workbench/fme_workbench_help.htm.

Round 1, New Server Required

April 16th, 2008

Since our last post in December we made some very good progress on normalizing all of the data. Learning how to use Safe Software’s FME Workbench was our first challenge. Dealing with such large amounts of data was the larger challenge. After successfully transforming and importing most of Washington’s parcel data, we ran into a few hardware obstacles. Luckily, after a few weeks of product investigation and ordering, we have two new servers just a few days away from being ready to re-import all of the data into. The bright side of this unforeseen delay is that we were able to go back to our original transformation methods and rework some of the steps and troubleshoot some of the bugs. Stay tuned for more updates soon!

Almost done with data collection!

December 28th, 2007

It’s been a few months since we last posted anything. We’ve been busy contacting all of the assessors in Washington State and working with the GIS staff member and/or public request staff member to sort out the details for data requesting, sharing, and more. It’s been quite an educational experience; we’ve learned more about county-maintained parcel data and assessment procedures and data storage methods than we ever expected to know! Luckily, it’s a fascinating world and we are happy to be learning so much.

For the most part, the cooperation from the counties is wonderful. Most are very receptive to working together to build a statewide parcel layer that can be shared with other public agencies and organization, recognizing that sharing data requests and transfers could greatly reduce costs and time.

As the end of the year rapidly approaches, we are happy to report that we have data from 36 counties; we are still working on requesting and acquiring data from 3 more counties.

We started using Safe Software’s FME (http://www.safe.com/products/desktop/overview.php) to transform the various data formats into one common format. We are amazed by how easy it is to document the process and to make changes to a method in a matter of minutes. This tool is an amazing addition to our work.

Currently, we are working on building the crosswalks to a normalized data set and continuing to document our progress (all the way from the initial data requests to detailed data processing steps). We will be contacting the counties once the initial data layer is  built to further investigate the data sharing methods and applicability.

Happy New Year!

Keeping track of data producers

September 24th, 2007

How are we keeping track of all of the information while we are contacting the data producers?

First, we have a database that stores contact information, data status, and communications. We can quickly jump to a data provider by using a web-based interface that looks like the picture below.

Data Producers Overview

 

Then, we can store and add lots of information about each data provider’s data request methods, current status of GIS, and other pertinent information about their parcel data.

 

Data Producer Status

 

We can then track all communications between a data producing agency or group and anyone working with  our end of the project. This allows multiple people to have the most current information about a data producer if anyone sends an e-mail or calls one of the cooperators on the project.

 

Communications with data producers

 

    And, lastly, we printed out a very large map of Washington, showing all 39 counties. Using the old pen and ink method, we have color coded boxes and labels that we fill in as we contact the county, ask for the data, and receive the data. We welcome any suggestions to help us continue to keep all of this information relevant and useful!

Parcel data, here we come!

September 24th, 2007

Cold calling for parcel data has never been so fun! In an effort to include everyone in this project, we are making a lot of phone calls, sending a lot of e-mails, and spending a lot of time talking about the project. And, surprisingly, it’s pretty fun.

 So far, the response has been pretty positive. Here are some of the most common concerns voiced thus far:

  • Increased work for counties to respond to our request — this concern has mostly been alleviated when we explain that we don’t want to add any more work to already overworked departments, thus are solely requesting data as it would normally be distributed to the public.

  • Commercial use of list of names — This is a sticky subject for some counties. Luckily, since neither the statewide parcel database project nor the family forest database are using the parcel-related information for commercial purposes, this concern is less of a problem at this time. If the completed statewide parcel layer is to be shared with other members of the Parcel Framework Management Group, it may be necessary for each agency or cooperator to individually sign license agreements with the counties which require the agreements.

  • Non-GIS data — We recognize that multiple counties in Washington do not currently have (or use) a GIS to store and manage parcel-related data. One of the goals of this project is to document parcel data producers’ current status in relation to GIS and to garner more support for counties to build, update, and maintain GIS data. In the event that a county does not have GIS, we have a method that can extract estimated location of the parcel to the Range or Section from the tabular data (Assessor’s tax rolls).

As of today, September 24, we have received data from 11 counties (although 2 of the counties are only partially received — meaning we either have the assessor’s data or the spatial data but not both). We are in the process of receiving data from 12 more counties and have either submitted data request forms or signed license agreement or are just waiting for the data to be uploaded or delivered. We are waiting to hear back from 13 counties regarding data acquisition and 5 counties still need to be contacted over the phone. As explained in an earlier post, we sent out initial e-mails to all 39 counties.

Back to the phone!

Acquiring Parcel Data

September 4th, 2007

Today, we made the first phone call and started gathering parcel data. Asking for the data over the phone provides the opportunity for us to speak first-hand with the people in charge of producing, maintaining, and/or distributing parcel data. This allows for an open-ended conversation, addresssing privacy and re-distribution concerns, project goals and timeline, and necessary relationship-building.

Snohomish County was our first phone call; we are using Snohomish County data as an example of a method to identify forest landowners for an upcoming Forum on forest land retention strategies in Washington. We will test out our methods and definitions, with help from the project’s advisory team, on Snohomish County’s parcel data.

Sample Data Acquistion Methods

  1. Call the person(s) responsible for distributing the GIS data.
  2. Find out as much information as possible about current GIS and parcel data status (e.g., is there data, how to access the data, how to acquire the data, current storage and file, license agreements, and more).
  3. Download data or request CD.
  4. Enter attribute information into Attribute Matrix database (more on this in future posts).
  5. Begin exploring data (more on this in future posts).

Currently, we are working on developing the methods for data storage, importing procedures, and more.