Difference between revisions of "Public:Future OpenCellID database content"
Line 15: | Line 15: | ||
{| class="wikitable sortable" style="font-size: 85%; text-align: left;" width=998px | {| class="wikitable sortable" style="font-size: 85%; text-align: left;" width=998px | ||
|- | |- | ||
− | ! scope="col" | Field | + | ! scope="col" | Field name |
! scope="col" | Data type | ! scope="col" | Data type | ||
! scope="col" | Description | ! scope="col" | Description | ||
Line 24: | Line 24: | ||
! scope="col" | Comment | ! scope="col" | Comment | ||
|- | |- | ||
− | | title="Field" | LCID | + | | title="Field name" | LCID |
| title="Data type" | string | | title="Data type" | string | ||
| title="Description" | concatenation of RNC and CID | | title="Description" | concatenation of RNC and CID | ||
Line 33: | Line 33: | ||
| title="Comment" | | | title="Comment" | | ||
|- | |- | ||
− | | title="Field" | RNC | + | | title="Field name" | RNC |
| title="Data type" | string | | title="Data type" | string | ||
| title="Description" | [http://de.wikipedia.org/wiki/Radio_Network_Controller Radio Network Controller] | | title="Description" | [http://de.wikipedia.org/wiki/Radio_Network_Controller Radio Network Controller] | ||
Line 42: | Line 42: | ||
| title="Comment" | | | title="Comment" | | ||
|- | |- | ||
− | | title="Field" | RGPS | + | | title="Field name" | RGPS |
| title="Data type" | string | | title="Data type" | string | ||
| title="Description" | Real GPS position (changeable=0) | | title="Description" | Real GPS position (changeable=0) | ||
Line 51: | Line 51: | ||
| title="Comment" | Currently EITHER the real GPS position OR the computed GPS position is provided in cell_towers.csv depending if the fix GPS position is available or not. The intention of this field is to provide the calculated GPS position as well as the fix GPS position in case the fix GPS position exists. | | title="Comment" | Currently EITHER the real GPS position OR the computed GPS position is provided in cell_towers.csv depending if the fix GPS position is available or not. The intention of this field is to provide the calculated GPS position as well as the fix GPS position in case the fix GPS position exists. | ||
|- | |- | ||
− | | title="Field" | SGPS | + | | title="Field name" | SGPS |
| title="Data type" | string | | title="Data type" | string | ||
| title="Description" | GPS position of measurement with best signal | | title="Description" | GPS position of measurement with best signal | ||
| title="Filter criteria" | | | title="Filter criteria" | | ||
| title="Formula (if computed)" | The cloaser the signal is to ASU=31 or -51 dBm the better it is | | title="Formula (if computed)" | The cloaser the signal is to ASU=31 or -51 dBm the better it is | ||
+ | | title="Affected components" | cell_towers.csv | ||
+ | | title="Technology" | all | ||
+ | | title="Comment" | | ||
+ | |- | ||
+ | | title="Field name" | cell_range | ||
+ | | title="Data type" | | ||
+ | | title="Description" | | ||
+ | | title="Filter criteria" | | ||
+ | | title="Formula (if computed)" | ??? | ||
| title="Affected components" | cell_towers.csv | | title="Affected components" | cell_towers.csv | ||
| title="Technology" | all | | title="Technology" | all |
Revision as of 19:03, 25 January 2014
This page is intended to compile all ideas how to improve the information stored for each measurement / cell in the main OpenCellID database.
Please use the "Discussion" page for discussing the various ideas, concerns etc. It is planned to keep this discussion going for a few weeks and when it becomes obvious that no additional, new information is contributed regarding this topic then it will be decided what to implement. Due to the current work load of the developer it is unlikely to start with the implementation of the enhanced database sceme before summer 2014, so there is enough time from that perspective to discuss the OpenCellID database evolution briefly. The following table contains the list of potential additional fields of the database according to the current status of the discussion. |
Field name | Data type | Description | Filter criteria | Formula (if computed) | Affected components | Technology | Comment |
---|---|---|---|---|---|---|---|
LCID | string | concatenation of RNC and CID | measurements_.csv / cell_towers.csv | UMTS | |||
RNC | string | Radio Network Controller | measurements_.csv / cell_towers.csv | UMTS | |||
RGPS | string | Real GPS position (changeable=0) | cell_towers.csv | all | Currently EITHER the real GPS position OR the computed GPS position is provided in cell_towers.csv depending if the fix GPS position is available or not. The intention of this field is to provide the calculated GPS position as well as the fix GPS position in case the fix GPS position exists. | ||
SGPS | string | GPS position of measurement with best signal | The cloaser the signal is to ASU=31 or -51 dBm the better it is | cell_towers.csv | all | ||
cell_range | ??? | cell_towers.csv | all |
* Add the value cellid in long/short-format in measurements_.csv/cell_towers.csv
* Add the value RNC (Radio Network Controller) in measurements_.csv/cell_towers.csv (UMTS)
* Add latitude and longitude from the calculated real position in the cell_towers.csv (Real place from the base station)
The actual position from the most cells is the middle from all measurements.
With the value signal maybe it is possible to calculate with the best signals (ASU = 31 or -51 dBm) the best calculated real place from the base station.
The value for the real latitude/longitude can used in example from a clf-import.
At the moment it is a mix with the middle and clf-import with the real position.
The real postion is useful for the apps G-Mon, G-NetTrack or RF Signal Tracker to create a cellfile or show alayer with the base stations.
Calculated middle from the cell:
changeable=1: the GPS position of the cell tower has been calculated from all available measurements
Real position from the cell:
changeable=0: the GPS position of the cell tower is precise; no measurements have been used to calculate it.
Example:
latitude_middle, longitude_middle, latitude_real, longitude_real
* Add the value cellrange.
With the value cellrange you can add the simple way for triangulation (see example google).
For this you use the calculated middle.
Lat=45.641502
Lon=8.812474
Range=1177 m
Example with the calculated middle and cellrange:
* Add value description for details from the cell
Example:
- street
- address
- bcch
- town
Links: