• Ongoing coronavirus / COVID-19 discussion: how is the pandemic affecting your community, workplace, and wellness? 🦠

    Working from home? So are we. Come join us! Cyburbia is a friendly big tent, where we share our experiences and thoughts about urban planning practice, planning adjacent topics, and whatever else comes to mind. No ads, no spam, no social distancing.

GIS / spatial Converting SBLs into tax map parcel numbers

GeogPlanner

Cyburbian
Messages
1,433
Points
25
Oh Throbbing Brain®...

Does anyone know a way to convert 20 character SBLs into a tax map number?
(16801300020090000000 --> 168.13-2-9) I once knew someone who could do it through MS Access, but I'm not too up on how she did it.
 

lowlyplanner

Cyburbian
Messages
69
Points
4
Ah the joys of concatenation (real word)...

You can do this in MS Access, but it takes a fairly good knowledge of queries. In addition to fields from tables, queries can include "expressions" which can be derived from the information in fields (using functions), and other characters mixed together. You can also use these functions to split an item into its component parts, and then use the "Make Table Query" function to create a new table. Then make a new query to put them back together into your new format.

For example, you could use the use "Left" function to get the leftmost 3 characters, then insert a ".", then skip a few spaces and get the next couple of characters, etc.

It takes some playing around to get the formats right, and the format has to be exactly the same for each item in the source file. I'd consult the Access guru at your office...

I hope that answer made some kind of sense to someone out there... You kind of have to wade right into Access - make a copy of your data and you can't hurt anything.

GeogPlanner said:
Oh Throbbing Brain®...

Does anyone know a way to convert 20 character SBLs into a tax map number?
(16801300020090000000 --> 168.13-2-9) I once knew someone who could do it through MS Access, but I'm not too up on how she did it.
 

GeogPlanner

Cyburbian
Messages
1,433
Points
25
thanks...scary thing is that i am the closest thing to an access guru in my office...then its off to the IT people for help...
 
Top