topic Re: Parcel Points in State & Local Government Questions

Parcel Points

JAKERODEL — Fri, 06 Jan 2012 17:57:25 GMT

Looks like I might have missed a step when I imported my road ROW into my Parcel Fabric. Some of the roads do not have parcel points at the vertices. Is there a way I can remove my ROW parcel type from the fabric and reload them or some way to create 2 point lines once they are already in the fabric?

Re: Parcel Points

DanNarsavage — Wed, 11 Jan 2012 14:44:26 GMT

Hi Jacob. This is one of my beefs with the fabric--dealing with things in bulk is nigh impossible & you're kinda limited to editing individual features inside ArcMap edit sessions. There's some reasonable logic behind this (bulk changes can easily hose things up with all of the fabric's complex relationships), but in practice this makes for some serious headaches now & again. Anyway I think that ESRI might be working on ways to allow some bulk management of parcel fabric features.

In the meantime, there is a workaround but it's ugly and scary (at least to me). If you're running your fabric in SDE then you can connect directly to the RDBMS, find the tables that contain the fabric's features, and find & delete those rogue features using SQL commands (note that you can't just delete the parcel features; you'll have to also delete the lines and points related to the parcels, but you also have to avoid deleting any points that are shared with parcels that you DON'T want to delete). Also note that you'll want to compress back to state zero and disallow editors from editing the fabric while you're doing this to make sure you don't miss anything in the A & D tables. I've done this successfully once before (coincidentally it was with hundreds of road ROWs that I screwed up importing), but I made about seventeen backups of our database and drank an entire bottle of whiskey before I worked up the nerve to attempt it. 🙂 I suppose if you're using a personal GDB then you can do essentially the same thing using MS Access.

Re: Parcel Points

JAKERODEL — Wed, 11 Jan 2012 15:24:50 GMT

Haha! I just found an add in this morning that I hope does this. I am working on it now and haven't tried it yet though. Thanks for the response!

Re: Parcel Points

ChrisBuscaglia — Thu, 12 Jan 2012 21:13:58 GMT

Jacob,

Could it be that you are using the default 'Minimum Line String Segment Count' during the load process? Sounds like something from a 1950's science fiction movie doesn't it?

Anyway, If you are using the default (10) the parcel(s) may have been loaded with line-strings. Line-strings are really supposed to be used for natural boundaries and other non-2pt. line features. This could explain why these parcel appeared to be missing points. If so, you can bump this number up and then re-load the ROW parcels to see if they come in correctly.

As for once you are using the Parcel Editing tools. If you need to repair parcels that may have accidentally recieved line-strings for boundaries, you can open the parcel, right click the line (in the grid or map) and "split line-string". This will restore the parcel to its former 2-pt. line glory (and restore the points).

Chris