Skip to content

MECODA Smartcitizen widgets



The mecoda-orange add-on includes 2 widgets:

  • Smart Citizen Search. This widget looks for the kits in the Smart Citizen kits. Here you select the kit which data you're going to work with

  • Smart Citizen Data. This widget gets the data from that widget

Smart Citizen Search is a widget that gets information about kits, but not the data gathered by those kits. This the menu of the Smart Citizen Search:

The info panel is going to get updated with data fetched from the Smart Citizen back end. If you don't press "Search devices" is not going to fetch anything.

Search all?

If you press Search devices while there is no filter it's going to retrieve all the devices in the database, which is not necessarily a bad thing because you can filter/find yours after that.

The Search filters are going to apply some filters in case that you want to find one specific Kit

  • City states the city that you are looking for. Remember to spell it with the first letter in upper case and with the local denomination.
  • Tags looks for tags separated with commas with the logical operator "OR". That means that if you look for indoor, online the widget is going to get all the kits that at least one of their tags are either indoor or online
  • User name the user that it is linked to.
  • Kit-ID refers to the type of kit that is your smart citizen kit.

And lastly if you know the Device ID (unique to your specific kit) you can find the kit that you need. You can find the ID of your kit in the last part of the URL of your kit. For example this kit from this URL has the Device ID of 15618.

Alternatively you can use this search to find the deviceID in a table and then lock the ID of the kit that you need information about

The Search devices button makes the request to the database so it's important to press it.

In the bottom part also you can see how many devices have you retrieved from your query.

Smart Citizen Data

The widget Smart Citizen Data from the data of one (and just one per widget) it will retrieve the data that one device has gathered.

It requires to be connected as an input one Smart Citizen device.

This is the menu of Smart Citizen Data:

  • The info panel is going to get updated with the data that is connected to. If it's not connected it will be empty. It will show you also when you press Get data how many rows has it retrieved.

  • The Get data a specific fequency is the panel where we state the data frequency that we want to get. Rollup is the amount and the Rollup units is the time units that you can choose from.

Options meaning

The options are y for years, M for months, w for weeks, d for days, h for hours, m for minutes, s for seconds and ms for milliseconds

No frequency, no data

This frequency is mandatory to be filled for the widget to work.

  • The Filter by Date (YYYY-MM-DD) is a panel where you can select a subset of all the dates in format YYYY-MM-DD (Year-month-day). From initial date 00:00 up to end date 00:00 (so the end date is not taken in a complete loop)

No date, all data

If this field is empty, the widget retrieves all the data on the record.

  • The checkbox resample data if checked fills the missing data from the rollup so you will have al the lines from the rollup even if it doesn't exist with empty cells. If it's unchecked is only going to get the data that is available.

Example without resampling in a datatable: (rollout of 30 minutes)

Same example with resampling in a datatable: (rollout of 30 minutes)