Determine Requirements for Lot Dimensions

[mattyschell]

Lot dimensions come from tax_lot_face.lot_face_length

[mattyschell]

Question to ESRI:

is all that is needed for vector tile map labeling is a point feature class with the attribute and the azimuth value (0-369)?

Answer to OTI:

Correct, If you’re already encoding the rotation attribute, that’s all we need to get the labels to align correctly.

[mattyschell]

Question to DOF:

I’m trying to nail down whether tax lot faces are always defined like this, with a start point and end point:

X--------123.45------------X

Or if sometimes they are defined with several points.

X--------X-------X--------123.45--------X---X------X

[mattyschell]

Answer from the Department of Finance:

While the first is what you will encounter the most, there can and will be cases of the second as well. A single “lot face” is a line segment, with a start and end and if the line is not entirely straight but, as defined in the metes and bounds, considered a single dimension, they will be drawn as a single lot face with multiple points. You will likely see this with curves. The point is, whatever dimensions are specified in the metes and bounds is what will be considered the lot faces and each lot face will have the dimension value (as defined in the metes and bounds) as one of the attributes (lot_face_length) for the lot face. This attribute is configured to be the label for every line feature in tax_lot_face and always displayed on the INSIDE of the corresponding tax lot polygon.

[mattyschell]

First iteration of requirements:

1. Convert tax_lot_face with ransomware SDELOB geometry storage type to tax_lot_face_sdo with mdsys.sdo_geometry storage type. The wizards require SDELOB, this step cannot be avoided and may require some sort of ETL lite to manage.
2. Confirm that directionality is maintained after conversion. Who knows.
3. Create a view that uses SDO_LRS functions that return the mid point of the tax_lot_face and the rotation. In this case the rotation is relative to 0 degrees pointing north. In the legacy system 0 degrees was graph paper 0 degrees pointing east. So it goes.

[mattyschell]

Number 2 above, confirmed visually to my satisfaction for now. Tax_Lot_Face_Sdo