How to Pull a House Number Out of an Address

One of the most common tasks associated with addresses, is how to pull the house number out of an address.

First, create a new field in your data.  Name it House_Number.

Next, copy the parcel address into this new field.

Then, if you haven't done so already, start an edit session.

Open Field Calculator for House_Number.  Using VBA type:
           split([field], " ")(0)

This is telling the field to delete everything after the first space, giving you the house number.

Happy GIS-ing!
Lindsy Bentley

Popular posts from this blog

How to Create a 3D Surface

In my last post, I talked about going 3D with your GIS.  But how do you do it? Let's say you want to create a 3D surface and use it in a 3D scene online, and you have a Microstation XML in Utah State Plane Central Foot. Where do you start? Open a new Pro project.   First, you will convert the XML to a TIN. Convert TIN to Raster Change the sample distance to cell size  Sampling Value is 1 foot Optional - Mosaic to new Raster If you are working with multiple surfaces, it is easiest to mosaic them into one raster at this point. Doing this allows the remaining steps to be done on one raster, instead of multiple. Change the pixel type to 32 bit float to maintain the elevation. Define Projection Up to this point in the conversion process, it is finally time to tell the data where in the world it is located.  Use the Define Projection tool and set it to Utah State Plane Central Foot. Project Raster Since you will be using your 3D surface in ...
Read more

3D GIS

Image
There is a big push in the GIS world to go 3D.  But this is being met with quite the resistance.  The reasons I hear are that organizations don't have time, resources, the right programs, money, and the biggest reason, why? The conversion process can take a long time, but the results are incredible. The first time I was tasked with converting something to 3D, it was daunting.  Nobody had done it before.  There wasn't any documentation online about how to do so.  Tech support was no help. First, I started with LiDar points, and pulled out trees and buildings.  I spent 2 weeks learning how to change the roof types and directions, the tree heights and canopy spreads.  I felt like I was building a video game (does anyone remember Half Life?). I finally got it to work.  And I was proud of figuring it all out. A random engineer came to my desk to ask for a map.  He saw my screen and asked "What is that?"  I told him all about it....
Read more

ESRI GIS Model Builder

Image
Who here loves Model Builder? Well, if you haven't had a reason to use it before, let's chat about it's benefits.  Prior to my working at an engineering firm, I never had a reason to use it.  There wasn't anything that I did on a regular basis that called for it.  I took all of the classes, read all of the books, and I just didn't get why it was useful. Then, I was asked to convert utilities for a project.  Not just once, but on a weekly basis.  Start to finish, it took me two weeks to convert and clean up the utilities from CAD on that beastly project.  Two.  VERY. PAINFUL. Weeks.  *Bang head against desk here.* This meant the utilities were never up to date in the project map.  After two months of figuring out the kinks in the conversion process, I was challenged to create a model of this process.  It looked something like this: Yes I'm OCD, and everything has to line up pretty. My first model.  I had my doubts ...
Read more