User:Davielde/WME Data Store View history

mNo edit summary
No edit summary
 
(12 intermediate revisions by the same user not shown)
Line 7: Line 7:
[[File:WME Data Store Exports.PNG|framed|center]]
[[File:WME Data Store Exports.PNG|framed|center]]


* 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.   
* 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.


[[File:WME Data Store Exports - French.PNG|framed|center]]
[[File:WME Data Store Exports - French.PNG|framed|center]]
Line 13: Line 13:
[[File:WME Data Store Exports - Dutch.PNG|framed|center]]
[[File:WME Data Store Exports - Dutch.PNG|framed|center]]


'''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.
[[File:WME Data Store - Basic Stats.png|framed|center]]


'''Exporting Data'''
'''Exporting Data'''
Line 18: Line 24:


* 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".
* 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.
[[File:WME Data Store - Sample CSV.PNG|framed|center]]


*''Current Column List''
*''Current Column List''
Line 35: Line 45:
:#PlaceID
:#PlaceID
:#PlaceName
:#PlaceName
:#FirstAltName†
:#Brand
:#Brand
:#Lock
:#Lock
Line 40: Line 51:
:#Type
:#Type
:#PublicOrPrivate
:#PublicOrPrivate
:#PlaceApproved (overall Place approval status of true or false)
:#Description (limited to first 100 characters)
:#Phone†
:#Website†
:#UpdateRequestCount (number of pending approvals)
:#CountryName
:#StateName
:#CityName
:#StreetName
:#HouseNumber
:#NumHours (number of opening hours added, not the hours themselves)†
:#NumServices (number of services checked, not the services themselves)†
:#CreateDateTime
:#CreateDateTime
:#CreatedByName
:#CreatedByName
Line 47: Line 70:
:#UpdatedByRank
:#UpdatedByRank
:#Permalink
:#Permalink
:#ImageCount (number of images pending or approved)
:#PrimaryImageThumbnail
:#ImageApproved (status of true or false for ''primary'' image)
:#ImageUserName
:#ImageUserRank
:#ImageDateTime
†Thanks to AlanOfTheBerg for these suggested additions.


:'''Segments'''
:'''Segments'''
Line 69: Line 100:
:#UpdatedByRank
:#UpdatedByRank
:#Permalink
:#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.
** The exports will only work properly in the Production, not Beta, editor.
'''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.

Latest revision as of 18:18, 13 October 2014

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. FirstAltName†
  4. Brand
  5. Lock
  6. PrimaryCategory
  7. Type
  8. PublicOrPrivate
  9. PlaceApproved (overall Place approval status of true or false)
  10. Description (limited to first 100 characters)
  11. Phone†
  12. Website†
  13. UpdateRequestCount (number of pending approvals)
  14. CountryName
  15. StateName
  16. CityName
  17. StreetName
  18. HouseNumber
  19. NumHours (number of opening hours added, not the hours themselves)†
  20. NumServices (number of services checked, not the services themselves)†
  21. CreateDateTime
  22. CreatedByName
  23. CreatedByRank
  24. UpdateDateTime
  25. UpdatedByName
  26. UpdatedByRank
  27. Permalink
  28. ImageCount (number of images pending or approved)
  29. PrimaryImageThumbnail
  30. ImageApproved (status of true or false for primary image)
  31. ImageUserName
  32. ImageUserRank
  33. ImageDateTime

†Thanks to AlanOfTheBerg for these suggested additions.


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.
    • The exports will only work properly in the Production, not Beta, editor.


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.