We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.
Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.
I would never try to export based on street numbers. What do you do with numbers like 811-15? I suggest that you look at using some combination of the Zip+4, the DPC, the CART, and the LOT. Each of these fields is available in query. You'll probably have to do a lot of investigation to determine the exact combinations and values that you need to pull.
If you plan on using these regions a lot, you may want to considering updating all of the "Region" fields on your addresses. Again, that doesn't help with your immediate problem, but it will help in the long run.
Drew
__________________ J. Drew Allen
Children's Hospital of Philadelphia
Crystal Reports and SQL Server Consultant
It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
I would never try to export based on street numbers. What do you do with numbers like 811-15? I suggest that you look at using some combination of the Zip+4, the DPC, the CART, and the LOT. Each of these fields is available in query. You'll probably have to do a lot of investigation to determine the exact combinations and values that you need to pull.
If you plan on using these regions a lot, you may want to considering updating all of the "Region" fields on your addresses. Again, that doesn't help with your immediate problem, but it will help in the long run.
Drew
Heya,
Sadly, this is something that has to be done quite frequently in NYC. We solicit ranges of addresses differently, and they vary greatly.
Not all of our addresses have the LOT, DPC, CART numbers, etc... Most do, but not all.
Is there anything USPS can do for you? Perhaps someone at the City can help?
You can't be the only ones with this problem.
I've called before. They're useless. Ideally, zip code would be the best way, but zip codes tend to go from fifth all the way to east end.. (entire length of east side).
Maybe you need to do something creative with attributes. Maybe export the street addresses and split them between house numbers and streets (maybe namechop or some other software would help). Then import the house number to an address attribute and the street name to another address attribute. Then you could more easily query on the two fields especially if the number were a numerical field and not text.
Mica, 1000 would not be between 10 and 20 if the field were a numerical field attribute - only if it is a text field attribute. It all depends on how you set up the attribute.
I am not saying it would be the only option or even easy to maintain but it would work. If you can find some easy way to do the initial records fairly easily and then make the attributes required on all addresses in the future it shouldn't be too hard. The difficuly would come in when an address is changed and no-one changes the attributes.
If you need to do this type of querying fairly often you may need to come up with some typwe of system like this. Do you have VBA/API? Someone could write a program for you to run each night to add/update these attributes.
Mica, 1000 would not be between 10 and 20 if the field were a numerical field attribute - only if it is a text field attribute. It all depends on how you set up the attribute.
I am not saying it would be the only option or even easy to maintain but it would work. If you can find some easy way to do the initial records fairly easily and then make the attributes required on all addresses in the future it shouldn't be too hard. The difficuly would come in when an address is changed and no-one changes the attributes.
If you need to do this type of querying fairly often you may need to come up with some typwe of system like this. Do you have VBA/API? Someone could write a program for you to run each night to add/update these attributes.
Heya,
Sadly, I don't have the VBA/API... however, I did just write up a quick SQL query in access that'll let me filter them out.
Does anyone have the plug-in product ZipFinder? At the organization I was at previously, we acquired this base package from Blackbaud and they made enhancements to make it work the way we wanted to. It was a bit of a struggle, but they finally got the product working the way we wanted and apparently it works well now.
You specify all records or a specific query, then you can choose multiple address types, specify specific city & state, OR specify a specific zip code and radius (in miles) - you can also exclude a zone by miles.
Not sure if this would be of interest, and if Blackbaud still offers this custom module.
__________________ Gina Gerhard
Business Systems Analyst
New Hampshire Charitable Foundation
You specify all records or a specific query, then you can choose multiple address types, specify specific city & state, OR specify a specific zip code and radius (in miles) - you can also exclude a zone by miles.
We use MapPoint for this stuff. MapPoint might be a good option for the original question. It's integrated with RE and will write back a query based on selections in MapPoint.
Drew
__________________ J. Drew Allen
Children's Hospital of Philadelphia
Crystal Reports and SQL Server Consultant
It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
I do not know MapPoint but if radius search is the primary rool then I am not sure it will work. New York City is a strange animal and you may want just certain streets which are a mile long but if you go 1/2 mile east or west you are in territories you do not want. A radius works well in more rural areas or to get an entire city but New York may be a different beast.
I don't use MapPoint myself, so I don't remember all of its capabilities. There are capabilities other than a simple radius. I believe that these include a freehand drawing tool. The coolest one in my opinion is the driving time tool. It is similar to radius except that it's based on driving time rather than miles.
Drew
__________________ J. Drew Allen
Children's Hospital of Philadelphia
Crystal Reports and SQL Server Consultant
It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
Linear Mode
