Show Parcel frontage and depth in the table

[sukishums]

Hi all,

Click Prospector tab - Sites - Lots - Parcels, there's a table pop up below showing lot number, area and perimeter. I would usually select all and right click copy to clipboard and paste in an Excel sheet.

Is there a way to show lot's frontage and depth in the table that I can export?

Thanks in advance 🙂

Suki 

[TerryDotson]

Determining frontage and depth can't simply be determined by a parcel alone.  The only logical approach is to use an alignment to find the station and offset values of all points on the parcel, sort by station, subtract and estimate the frontage.  Then the minimum and maximum offsets could be averaged to estimate the depth.  While we include these estimates in a report in one of our tools, the only way to build a truly trustworthy table is to use HI (Human Intelligence) to evaluate each parcel and build the table.

[brian.strandberg]

If you compare to your alignment, and look at a lot you can get the compared offset for each point.  I can see adding a formula to an excel sheet to determine frontage length.

You can export this with the quick export to file, or use the object sets to more precisely customize the setup.

[sukishums]

Hi everyone,

Thank you in advance for your help.

I received the pre-cal plan from the engineer, and I’m a bit uncertain about how to apply alignment to it. I apologize for my limited understanding of alignment. Since I already have the segment lengths for the lots, I'm wondering why alignment is still necessary in this context.

I noticed that under the Annotate tab, there's an option to add tables for parcels, specifically using the "Add Area" function. I was able to create a Parcel table that displays the Parcel number, Area, Perimeter, and Segment Lengths (all lengths in one cell as shown in image).

My goal is to export an Excel table with "width of lot" and "depth of lot" in separate cells. Referring to the image, the table  I want would be Parcel number in one column, Area in one column, width of parcel in one column, and depth of parcel in one column.

Would the best approach be to draw alignments manually, or should I use the current Parcel table and then manually separate the segment lengths into a width column and depth column in Excel? I’m working with around 1000 lots.

I’ve attached the original pre-cal plan from the engineer (no centerline for building alignment), the parcel plan I created (with lot segment label), and the corresponding Parcel table (with all segments in the same cell).

Thanks again for your assistance.

[TerryDotson · Accepted solution]

Since I already have the segment lengths for the lots, I'm wondering why alignment is still necessary in this context.

---

To do it manually you would NOT need alignments, you could zoom/pan around and check distances or review existing labels.  You were looking for automation, and without alignments the only remaining approach would be ...

<rambling mode on> to apply a rule that parcels are always deeper (depth) than they are wide (frontage).  In automation without alignments one could rotate the parcel in memory until each comes close to ortho rectangles, then use the dimensions of that to determine results.  However, glancing at your parcels drawing, it looks like that rule would only work about 90% of the time.  To minimize the possibility of errors, the best approach I can imagine (again in automation) is to place two dimension objects in each parcel with the parcel data as extra data, let the user review and tweak, then report from those special dims. <rambling mode off>

Given that there is no perfect solution in existence, I would recommend you get started building the data table on paper, then pass it off to a clerical person to put in a spreadsheet.

[rl_jackson]

@TerryDotson <ramble mode> was that part BOT 🤣

[sukishums]

Thanks guys 🙂

[TerryDotson]

A general question to those who know the application of the term frontage and how it applies in curves (cul-de-sac or otherwise).  From one source I've found, the frontage value in a curve reflects the chord distance between the property corners, as opposed to the distance along the curve (almost always more).

Any subdivision experts out there have opinions on this?

[fcernst]

You have to read the zoning code. Sometimes it’s measured at the building setback line.

[TerryDotson]

You have to read the zoning code. Sometimes it’s measured at the building setback line.

---

The main thing I'm seeing is that it's always going to be subject to interpretation(s) and need planner intervention, and could never be 100% fully automated.  So I'm thinking the best approach would be automated generation of two approximate dimensions F/D that the planner would review and adjust (grip edited) as needed, then a report generated from those dimensions.