Hello, I needed to import this in to a mysql DB.
I used the phpmyadmin Import tool, using Columns enclosed with "" and comma separated.
Column names as: otherid,pcode,locality,state,long,lat,deliveryoffice,type
I had to remove the double "" characters in many of the locality names.
I also changed a few of the column names too.
Hopefully this cleanses the data a little better for you. :)
Hello, I needed to import this in to a mysql DB. I used the phpmyadmin Import tool, using Columns enclosed with "" and comma separated. Column names as: otherid,pcode,locality,state,long,lat,deliveryoffice,type
I had to remove the double "" characters in many of the locality names. I also changed a few of the column names too.
Hopefully this cleanses the data a little better for you. :)