I am attempting to build an address locator out of the street centerline dataset from Palm Beach County: Information Systems Services Data Catalog
However, when I attempt to create an address locator from the data using the following options, I get an error message stating:
ERROR 000042: Failed to create the address locator.
An invalid SQL statement was used.
Has anyone encountered this problem or have an idea what the source of this error could be?
I appreciate the help!
Hannes,
Were you ever able to solve this issue? I have gotten the same error with PBC data.
Allison
Can you try exporting your data into a file gdb and then see if you can build the address locator?
Was version of ArcGIS Desktop are you working in?
It is in a file gdb and I have tried it on 10.2.2. and 10.5.1.
Are your To and From fields defined as numbers or text?
I was never able to resolve the issue, I ended up using the google geocoding service.
GPS Visualizer's Easy Batch Geocoder: Convert addresses to coordinates
As numbers
STREET_NAM is defined as double. I believe that needs to be a text field.
That worked, thank you Michael!