This is a how-to guide which will explain how to add your own custom city to the HTC Sense Weather application. I HIGHLY recommend having Root Explorer or another file explorer capable of copy/pasting/deleting files from the system memory although you should be able to use ADB commands if necessary.
1. Download
SQLite Database Browser and unzip the folder to your desktop
2. On your phone, using either Root Explorer (Downloadable in Market) or ADB, copy/or pull the file
WPDB.zip from
/system/etc and place it on your desktop. (This file contains all weather databases for all languages)
3. Unzip the WPDB.zip file on your desktop and you will see several database files contained inside. The one we want to edit is
WP_0409WWE
4. Inside of the SQLite folder, open
SQLite Database Browser 2.0 b1
5. On the top of the window, click the open folder and open the
WP_0409WWE from within the WPDB.zip folder you unzipped
6. Click on the "Browse Data" Tab
7. Click "Table:" and then on the drop down menu next to it select "locationlist" and it will populate all of your locations below
8. To add your location, go to
www.accuweather.com and type in your local city and get the weather. What we are after is how Accuweather has the name spelled out in the web address. Here is an example of Seaside Heights, NJ for allof you first pumpers:
http://www.accuweather.com/us/nj/seaside-heights/08751/city-weather-forecast.asp
9. Now in SQLite, on the top right, select "New Record"
10. You will now have an empty line at the bottom where we will enter our new location data. Double-click on the empty box under the "code" column and enter text in this format: NAM|US|<state>|<city> So, for example, NAM|US|NJ|
SEASIDE-HEIGHTS (These will be ALL CAPS with no spaces or line breaks after the block of text (you can have spaces in the city name)
**Extremely Important** The city name you enter in the "code" column MUST be how it shows in the accuweather web adress.
11. Under the "name" column, put the desired city name without any spaces or line breaks after the block of text. Example would be "Seaside Heights"
12. Under the "state" column, put the state abbreviation, Example, "NJ"
13. Under the "timezone" column, the values are 300, 360, 420, or 480, depending on what your timezone is:
Eastern time - 300
Central time - 360
Mountain time - 420
Pacific time - 480
14. Under the "timezoneld" column, put either "America/New_York", "America/Chicago", "America/Denver", or "America/Los_Angeles" in, again, depending on the timezone you live in:
Eastern time - America/New_York
Central time - America/Chicago
Mountain time - America/Denver
Pacific time - America/Los_Angeles
15. Once you are finished adding locations, Go to "File" and "Save Database"
16. In the WPDB.zip folder, select all files and repack them into a .zip folder named
WPDB.zip.
17. Paste/Push this file back into
/system/etc (If you are using Root Explorer, remount the system in read/write mode to delete the old file)
18. Reboot your phone and you should now be able to add your custom cities within the weather app
**If you have any problem after rebooting, go to
Settings>Applications>Manage Applications>Running>Weather Provider and "Clear Data" Then go into the Weather app and add your cities.