Help finding similar sounding street names
I have a REST - ish service running that dumps a database. It looks like this:
[{"division":"ADMIN","objectid":"18186","name":"Central Avenue Pedestrian and Lighting Improvements Project Phase II","pid":"DESIGN"},{"division":"CIP","objectid":"18149","name":"4th Street Roadway Improvements (Central to Tijeras)","pid":"CONSTRUCTION"},{"division":"CIP","objectid":"18152","name":"Alligator Courtyard Exhibit","pid":"CONSTRUCTION"},{"division":"CIP","objectid":"18574","name":"Convention Center Remodel Phase 2","pid":"CONSTRUCTION"},{"division":"CIP","objectid":"19020","name":"Edith Transfer Station","pid":"PROJECT_DEVELOPMENT"}]
I then created a webpage that connects to this data and compares the user input. It prints out any name that sounds the same. I used resign so I could match the word DESIGN. You would have more words that match so it would print any that did.
then here is the code. The architecture is like REST. You write a server side script to query your DB and put out the info in JSON. then the website uses AJAX to get the data and do the work client side. In my first example I used ArcServer because then you dont have to write the server side. the HTML is below and below that I have attached a sample server side script that would generate the JSON.
<html>
<head><title>Blank</title>
<script src="http://myserver/JavaScript/ThirdParty/qwest/qwest-0.6.0.min.js"></script>
</head>
<body>
Name: <input type="text" id="myText" >
<button onclick='compareWords()'>Copy Text</button>
<p id='data'></p>
<script>
var e;
var compare;
var sound;
var response;
var soundex = function (s) {
var a = s.toLowerCase().split('')
f = a.shift(),
r = '',
codes = {
a: '', e: '', i: '', o: '', u: '',
b: 1, f: 1, p: 1, v: 1,
c: 2, g: 2, j: 2, k: 2, q: 2, s: 2, x: 2, z: 2,
d: 3, t: 3,
l: 4,
m: 5, n: 5,
r: 6
};
r = f +
a
.map(function (v, i, a) { return codes
.filter(function (v, i, a) { return ((i === 0) ? v !== codes
.join('');
return (r + '000').slice(0, 4).toUpperCase();
};
function compareWords(){
w=document.getElementById("myText").value;
console.log(w);
sound=soundex(document.getElementById("myText").value);
qwest.get('http://myserver/myJSON.asp')
.success(function(response){
for(i=0;i<response.length-1;i++){
e=response.pid;
compare=soundex(response.pid);
console.log(response.pid);
console.log(compare);
if(sound.substring(1) == compare.substring(1)){
console.log(e +" sounds like " +w );
var data = document.getElementById("data");
data.innerHTML+=e +"<br/>";
}else{console.log("nope");}
}
})
.error(function(message){
alert(message);
});
}
</script>
</body>
</html>
Server side : need to populate your connection string wiht DB values for CAP variables
<%
set myconn_ = server.createobject("adodb.connection")
connection_ = "Provider=sqloledb; Data Source=NAME; Initial Catalog=DBNAME;User Id=USER; Password=PASSWORD;Network Library=DBMSSOCN"
myconn_.open (connection_)
set result_ = server.createobject("adodb.recordset")
sql = "Select distinct something from some table"
set result_ = myconn_.execute(sql)
Response.ContentType = "application/json"
response.write("[")
while not result_.EOF
response.write("{""division"":""" & result_("Division")&""",""objectid"":"""& result_("objectid") &""",""name"":"""& result_("ProjectName") &""",""pid"":"""& result_("Project_Status") &"""},")
result_.movenext()
wend
response.write(" {""division"":"" " & 9 &""",""objectid"":"""& 9 &" "",""name"":"""& 9 &" "",""status"":"""& 9 &"""}]")
result_.close
myconn_.close
set result_ = Nothing
set myconn_ = Nothing
response.end
%>
An update -
I never figured out how to do this via a web interface, but I did find some source code available in C# that works and produces pretty much exactly what I need.
Phonetic String Comparison with Soundex
I converted it to VB using a C# to VB tool, and fixed any conversion errors manually to make the program run correctly. (I needed to edit the code to personalize the program more, and I know VB more than C#)
I successfully converted the provided SoundEx code to VB, but couldn't figure out how to convert the supplied Metaphone code to VB. So I searched the internet and found a different Metaphone implementation and got it working that way. (Honestly, I cannot find where I found this since I lost all of my bookmarks.)
Here is what I came up with.
I added to the code a way to load a text file from a directory, and save this location to an .ini file so that I don't need to reload the street names list every time.
The only thing to do now is export my Street Centerlines to an excel when I add any new street names to the list, format it to show only my 'rd_name' column, and save it as a text file.
