User:Davielde/WME Data Store

WME Data Store (WDS) is a script for the Waze Map Editor that adds basic statistics (not yet available) and CSV export capability (available) for some common data. The script requires Tampermonkey for Chrome or Greasemonkey for Firefox, and it is available here from GreasyFork

User Interface

• After installing the script, load WME. WDS is not triggered until after the user pans or zooms the map, which populates most of the objects that WDS uses. At that point, you should see the Waze "Geek" icon as well as export links in the lower left corner of the map next to the Google icon.

• WDS also offers basic translation support, which relies upon WME's translations. Changing the language in WME should also change the export labels to correspond with the selected language. Everything else will appear in English.

Statistics

• Basic statistics for the current view appear when the user hovers over the Waze "Geek" icon.
• More is planned for future releases, and suggestions for analysis are welcome.

Exporting Data

• WDS currently supports CSV export capability for a variety of objects. The data depends upon the same zoom level used for selecting or viewing these objects in WME. For example, most segments will only appear in an export if the user is at a zoom level between 4 and 10, Point Places will only export at a zoom between 5 and 10, etc.

• NOTE: Because the exports involve comma delimited files, any commas(,) in names or other text are replaced with a period(.). For example, "Historic Fort Wayne, Detroit" would export as "Historic Fort Wayne. Detroit".

• CSV (comma delimited) files are not natively handled in an application like Microsoft Excel. If using Excel, you will more than likely need to use the "Text Import Wizard" and manually specify that you are using a Delimited File on window 1 of 3 and Comma on window 2 of 3. If the CSV opens in Excel and everything is in column A, and commas are present, go to the Data tab and select "Text to Columns" to reach the Text Import Wizard.

• Current Column List

Cities

1. CountryID
2. Country
3. StateID
4. State
5. CityID
6. CityName
7. CityEnglishName
8. IsEmpty
9. Permalink

Places

1. PlaceID
2. PlaceName
3. Brand
4. Lock
5. PrimaryCategory
6. Type
7. PublicOrPrivate
8. Approved (status of true or false)
9. Description (limited to first 100 characters)
10. ImageCount (number of images pending or approved)
11. UpdateRequestCount (number of pending approvals)
12. CountryName
13. StateName
14. CityName
15. StreetName
16. HouseNumber
17. CreateDateTime
18. CreatedByName
19. CreatedByRank
20. UpdateDateTime
21. UpdatedByName
22. UpdatedByRank
23. Permalink
24. PrimaryImageThumbnail

Segments

1. SegmentID
2. CountryName
3. StateName
4. CityName
5. PrimaryStreetName
6. RoadType
7. RoadTypeName
8. FwdToll
9. ReverseToll
10. FwdDirection
11. ReverseDirection
12. Elevation
13. Rank
14. LengthInMeters
15. CreatedByName
16. CreatedByRank
17. UpdateDateTime
18. UpdatedByName
19. UpdatedByRank
20. Permalink

Troubleshooting

• Exports have headers but no data, or data is from a previous map area
  • You may not be at the correct zoom level for properly exporting data, or the map may not have finished loading all of the objects prior to clicking on the export. WDS relies upon zoom *end* and move *end* events, which means that it will not execute until the map finishes a pan or zoom and reloads data. This may take a few seconds. Also, cities are tied to street names, so it is necessary to at least wait for the road layer to load.

Known Issues

• Nothing refreshes when you use the search bar to change locations. You need to first pan the map for new data to display/export.
• Refreshing on a zoom is sometimes unreliable. Panning is much more reliable.
• Much of the data export is "raw" (i.e. Place categories of "STADIUM_ARENA"). The initial releases will be about getting functionality correct.