Sorry, can you clarify what you mean by "the lot layer has the right of way specified in it of the actual width of the road"? You have information about the width of a road inside the lot layer? What if multiple roads run past one lot?
–
underdark♦Aug 11 '10 at 23:16

@undermark, if you see in the picture, the white space where the road line goes through is not defined in the parcel layer. it is a representation of "as built"
–
dassoukiAug 11 '10 at 23:22

Is an arcobjects based command written for arcmap an acceptable solution? If it is, it might provide some performance advantages.
–
Kirk KuykendallAug 12 '10 at 15:28

@Kirk Kuykendall - I would think so. In all reality, this is a command that I'll probably do once a year (when our plot maps get updated)
–
dassoukiAug 12 '10 at 15:41

I am working on a similar project but it is the other way around. I need to select the roads adjacent to the property. My problem is all the roads are located a different distance apart to buffering doesn't work. Any suggestions?
–
Tamar NiescierMay 7 at 16:04

It should create a buffer around the road and select the property geometry that intersects the buffer, the property land no, and the road id that was used for the buffer. It should also only select one property using DISTINCT ON (p."land_no") even if the property touches two road buffers.

This query uses a buffer of 50m but you will just need to adjust that so that cover the road reserve area.

This is what the result in QGIS looks like:

EDIT: This seems to do the count right, it's a bit slow due to having to do two runs but I'm sure someone might be able to optimize it.

SELECT road, Count(land_no) FROM
(select DISTINCT ON (p."land_no") a."Road_asset_ID" as road, p.land_no ,p."SP_GEOMETRY"
from "roads_old_centre_lines" a
INNER JOIN "Property" p on st_intersects(st_buffer(a."SP_GEOMETRY",50), p."SP_GEOMETRY")
where a."Road_asset_ID" = 1500 OR a."Road_asset_ID" = 1502) as Test
GROUP BY road

Create a buffer for each street centerline segment, wider than the standard ROW. Make sure that the buffer has the name of the street as an attribute. Then intersect your buffer layer with your parcel layer. You will then have a list of all of the street names, along with any parcel ids that intersected that particular buffer. That should also cover the double frontages. Once you have the workflow down, it should be easy to set it up in ModelBuilder.

With an ArcInfo level license, you can use the Buffer command with a "FLAT" end type, which allow you to get around the problem mentioned by @underdark. As @Zachary mentioned, this is a pretty easy model to create. Using the "make feature layer" will allow you to define a query (ie- Main St), and buffer the selected layer to a temp in memory layer (in_memory\road_buffer) using a distance (set as a parameter to make interactive), and use the in memory buffer to select taxlots within the chosen distance (select features by location). See below: