Latest Contributions by HeatherCarlos

Business analyst has some great address locators, but I can't find detailed documentation for them.  For example, there is a locator called USA_PointAddresses.  It matches to address points - but is it rooftops, E911 data or what?  The reference data is listed   \REF_DATA\USA.gdb\EsriPointAddress and the path shows that it is on my desktop, but it isn't.  I need to understand the how the data was created, how old it was, is it consistent across the US or does it concentrate on Urban areas,  etc. Another example, I'm finding addresses that match with the 5 digit ZIP locator, but not with the ZIP +4, even though according to the USPS, the ZIP +4 is valid.  I need the documentation on how these address locators were created and details on the underlying source data and can't seem to find it anywhere in the documentation. I'm using the desktop version of Business Analyst. ... View more

Hi, I need to run a 900,000 x 240 OD Cost Matrix (not by choice!) and I'm looking for the most efficient way of getting this done. I'm using the StreetMap dataset, my destinations are spread throughout North Carolina and most of my origins are in NC, but not all are.  I do have a limit of 180 min of travel time. I recently did a 300,000 x 240 matrix by running subsets of 50,000 x 240.  Each subset took about 2 weeks to process on a desktop dedicated to this (64 bit, 8GB RAM, windows 7, ArcGIS v10.1).  The good news is I didn't run into any out of memory errors, the bad news is we could have had a power outage minutes before completion and I would have lost 2 weeks.  Also, I did this manually and it was a bit of a hassle to keep track of the different subsets (I had several false starts and stops and I have 3 different desktops dedicated to this, which are living in different offices) So, the question is, how best to tackle the 900,000 x 240 matrix (minimizing my time as well as computer time): 1) use the 50,000 origin subset concept since it worked before 2) automate a loop that runs much smaller subsets, say 1,000x240 - but this leaves me with lots and lots of files to merge together. 3) instead of subsetting the origins, subset the destinations (i.e. 900,000 x 10 and then run this 24 times) 4) other reasonable options?  (Not doing it isn't an option). Thanks for any ideas, Heather ... View more

Hello, I need to parse some street addresses (stored as strings in one attribute field) to 2 separate fields ??? one for the house number, one for the street name.  Of course the addresses have varying lengths of house numbers (or sometimes none) and varying lengths of street names (and varying word count), so I can???t just use Left() or Right().  For example: 1 Main St 10 Main St 100 Maine Street 100 Main Podunk St Podunk St   I think I need to tokenize the string with the space as a deliminator, but I've never used python (and only basic VB scripts), so I'm getting lost as I troll through the various python resources.  Can someone help me out - I'd like to do this in the field calculator. Thanks, Heather ... View more

Hi, I have two point datasets of tobacco retailers - the gold standard is based on actual tobacco license files, the other based on the types of stores that sell tobacco (conv store, grocery store etc).  I want to compare the two datasets - spatially, to understand how different they are.  Neither dataset has attributes in common (one has the name, the other the type) and I don't really care about the attributes.  Essentially, what I want to know: is the dataset with store type (which I can get nationally) a good proxy for the dataset based on license files (which isn't available nationally, but I can get it for a few states to test). Any suggestions on comparing these datasets?  Anything I've come across is really getting at a relationship between their attributes rather than their location. Thanks, Heather Carlos Dartmouth College ... View more

Hello all! I have a frequency table with a with a bunch of different attributes (destinations).  I want to iterate through the rows of the table, and then check that a select list of the attributes have a value >0, if so, I then want to make a selection from a related shapefile and draw a convex hull around the selection.  If any of the list of attributes = 0, then I do nothing and move on to the next row of the frequency table. To do this, I set up a submodel with iterate field values and calculate value to check the list of attributes.  I use "stop" if one of the attributes = 0, otherwise continue.  In the main model, I Iterate Row Selection on the frequency table and then send the selected row to the submodel.  I then have the results of the submodel (the "continue") as a precondition for selecting from the shapefile and drawing the convex hull. Two problems:  1) my calculate value always returns "true" even if the attribute = 0 2) Even when the submodel finds all the attributes > 0, the next step in the main model won't run because "the precondition is false". I've attached the model, submodel the calculate value code is as follows: getVal("%DestName%") def getVal(intValue):   if intValue >= 1:     return "TRUE"   else:     return "FALSE" Data Type is Boolean ... View more

I'm having trouble nesting 2 iterators. I have tax parcels that are categorized by the type of destination (grocery store, bank etc....). My study subjects are in a point file and in another file, I have polygons that are buffers (sometimes network buffers, sometimes simple circles) around each study subject. For each individual study subject, I want to select all the parcels that are in that study subject's buffer, then I'll use NEAR to calculate the distance from the study subject to each of the selected parcels. So, I have two iterators. 1) Iterate feature selection - this iterates through the buffer file and selects each buffer (I can also use the value from this process to select the related study subject) 2) Iterate field values - this iterates through the types of destinations (grocery, bank etc) I would like to loop as follows: Select one buffer/subject pair Select one destination group --calculate NEAR (which also means adding fields,calculating values, converting to layers and whatnot) Repeat for all of the destinations (for the first buffer subject pair) Repeat for the next buffer/subject pair   and so on Since I can only use one iterator for each model, I've tried lots of combinations of submodels, but I still end up with the first iterator running completely through ALL of the iterators before it starts doing the second iterator.  So, in essence, they aren't nested, one does all of its business before the next one starts. I've included jpg's of the current incarnation of my model. Thanks for any thoughts. Heather Carlos ... View more