I'm looking for some info/advice on paper parcels. Here's Belmont's situation:
Belmont formats MAP_PAR_ID as MAP_BLOCK_LOT, for example, 29_68_C.
Belmont formats PROP_ID as (MAP_PAR_ID)_UNIT, for example, 29_68_C_2.
If there are two condos on the property, then they would be assigned PROP_IDs of 29_68_C_2 & 29_68_C_4, ideally. In reality, if these are affordable housing units, the LOT component is overwritten in CAMA with an X, for example, 29_68_C_2 is exported from the CAMA database as 29_68_X_2. This does not jive well with our geometry.
There happens to be another physical parcel named 29-68-B, with affordable housing condos. It has a record of 29_68_X_1. So, now it looks like 29_68_X_1 & 29_68_X_2 should live on the same piece of geometry, right?
Belmont also has "floating" parcels. Meaning, there are a few high rise condo units with hundreds of condos in them. The MAP_BLOCK_LOT assigned to each of these parcels does not match any MAP_BLOCK_LOT in our geometry. It's as if the BLOCK field has been ommitted and the record exists as MAP_LOT_UNIT, instead of MAP_BLOCK_LOT. For example, 39_49_1 doesn't exist on a map. 39_28 does exist as the master parcel. This floating parcel should be 39_28_49_1.
So, I run a script that replaces the MAP_PAR_ID exported from our CAMA with the MAP_PAR_ID associated with the geometry for these records. Once I've joined the CAMA data to my geometry and stacked the parcels, I then run a script to update the LOC_ID (X_Y) field. It works, but it's inconvenient.
In all, 4.5% of Belmont's parcel records do not automatically resolve to parcel geometry, by default.
So, at long last, are my questions:
1. Do your municipalities experience paper parcels, too?
2. If so, then how do you deal with them?
3. Is unreasonable to expect to match a CAMA ParcelID to a GIS ParcelID without manipulating the data?
All input is greatly appreciated.
NEURISA serves Connecticut, New Hampshire, Maine, Massachusetts, Rhode Island and Vermont.
NEURISA is a not-for-profit [501(c)(6)] professional organization incorporated in Massachusetts.