So I've geocoded files before, but the detailed street files I worked with were small (county size) and worked find (created an address locator, didn't take long).
Now I have a dataset that is statewide. I have the ESRI maps and data files including the streetMap file for North America.
I just can't seem to get the detailed streets to load correctly. On another attempt, I somehow got it to load, but the included address locator didn't work and when creating a new one (this all took FOREVER due to the size), I could only map by ZIP.
I try to open the street file in Excel to see if I can't distill the street file to just CA, to reduce some of the load on the computer, but the ~41 million records is impossible to work with.
So I am asking this:
What is the file and extension from ESRI StreetMap North America do I need? How can I cut down the included streets to *just* CA, faster in ArcGIS or other application, and why am I having problems using/creating an address locator?