BlockLotFinder

This tool creates a query expression based on the inputs provided by the user and uses the expression to provide an output parcel layer of the desired block and lot.

Expression examples:

The SQL expression used for a "Contains" query with only a block provided is:

PCL_MUN = '1111' AND PCLBLOCK LIKE '%701%'

The SQL expression used for a "Contains" query with both a block and a lot provided is:

PCL_MUN = '1111' AND PCLBLOCK LIKE '%701%' AND PCLLOT LIKE '%6%'

The SQL expression used for an "Exact Match" query with only a block provided is:

PCL_MUN = '1111' AND PCLBLOCK = '701'

The SQL expression used for an "Exact Match" query with both a block and lot provided is:

PCL_MUN = '1111' AND PCLBLOCK = '701' AND PCLLOT = '6'

If you receive the error "Unable to complete operation" you may need to confirm that your block and lot exist in the chosen municipality. You could also try changing the query type to "Contains".