Difference between revisions of "Public:Future OpenCellID database content"

From OpenCellID wiki
Jump to: navigation, search
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{|width=998
 
|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.
+
{|width=998
 +
|This page including its sub pages is intended for compiling all ideas on how to expand the information stored in the OpenCellID database.
 +
The following data base tables are currently discussed:
  
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.<br>
+
*[[Public:Future_OpenCellID_database_content_cellid|Future cell-id data structure]]<br>
In case there are different opinions regarding one or the other feature it is intended to initiate a vote similar to the votes in OpenStreetMap, which is a proven mechanism.
+
*[[Public:Future_OpenCellID_database_content_cellid_neighbours|cell-id neighbours]]<br>
 +
*[[Public:Future_OpenCellID_database_content_wifi|Future WiFi data structure]]<br>
 +
*[[Public:Future_OpenCellID_database_content_wifi_network_neighbours|wifi network neighbours]]<br>
 +
*[[Public:Future_OpenCellID_database_content_gps|Future GPS position data structure]]<br>
  
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.
+
Please use the "Discussion" page of each of the above sub pages for discussing the various ideas and concerns on this subject.
  
The following table contains the list of potential additional fields of the database according to the current status of the discussion.<br>
+
The plan is to keep this discussion going for a few weeks and decide what to implement when it becomes obvious that no additional new information is contributed regarding thess topics.<br>
Please update it each time you introduce discussion about a new database field.
+
In cases where there are different opinions regarding a feature, a vote similar to the votes in OpenStreetMap, which is a proven mechanism, will be initiated.
|}
+
  
{| class="wikitable sortable" style="font-size: 85%; text-align: left;" width=998px
+
Due to the current work load of the developer, it is unlikely to start with the implementation of the enhanced database scheme before summer 2014; therefore, there is enough time in that perspective to discuss the OpenCellID database evolution briefly.
|-
+
! scope="col" | Field name
+
! scope="col" | Data type
+
! scope="col" | Description
+
! scope="col" | Filter criteria
+
! scope="col" | Formula (if computed)
+
! scope="col" | Affected components
+
! scope="col" | Technology
+
! scope="col" | Comment
+
|-
+
| title="Field name" | LCID
+
| title="Data type" | string
+
| title="Description" | concatenation of RNC and CID
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | measurements_.csv / cell_towers.csv
+
| title="Technology" | UMTS
+
| title="Comment" |
+
|-
+
| title="Field name" | RNC
+
| title="Data type" | string
+
| title="Description" | [http://de.wikipedia.org/wiki/Radio_Network_Controller Radio Network Controller]
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | measurements_.csv&nbsp;/ cell_towers.csv
+
| title="Technology" | UMTS
+
| title="Comment" |
+
|-
+
| title="Field name" | RGPS
+
| title="Data type" | string
+
| title="Description" | Real GPS position (changeable=0)
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | cell_towers.csv
+
| title="Technology" | all
+
| 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 name" | SGPS
+
| title="Data type" | string
+
| title="Description" | GPS position of measurement with best signal
+
| title="Filter criteria" |
+
| title="Formula (if computed)" | The closer 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" | CGPS
+
| title="Data type" | string
+
| title="Description" | GPS position computed from all measurements of all cells being a sector of the same base station
+
| title="Filter criteria" |
+
| title="Formula (if computed)" | Average of all GPS positons of all measurements of all cells being a sector of the same base station
+
| 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="Technology" | all
+
| title="Comment" |
+
|-
+
| title="Field name" | ZIP code
+
| title="Data type" |
+
| title="Description" |
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | cell_towers.csv
+
| title="Technology" | all
+
| title="Comment" |
+
|-
+
| title="Field name" | city
+
| title="Data type" | string
+
| title="Description" |
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | cell_towers.csv
+
| title="Technology" | all
+
| title="Comment" |
+
|-
+
| title="Field name" | street name
+
| title="Data type" | string
+
| title="Description" |
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | cell_towers.csv
+
| title="Technology" | all
+
| title="Comment" |
+
|-
+
| title="Field name" | house number
+
| title="Data type" | string
+
| title="Description" |
+
| title="Filter criteria" |
+
| title="Formula (if computed)" | ???
+
| title="Affected components" | cell_towers.csv
+
| title="Technology" | all
+
| title="Comment" |
+
|-
+
| title="Field name" | other address information
+
| title="Data type" | string
+
| title="Description" |
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | cell_towers.csv
+
| title="Technology" | all
+
| title="Comment" |
+
|-
+
| title="Field name" | altitude
+
| title="Data type" | string
+
| title="Description" | GPS altitude
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | measurements_.csv
+
| title="Technology" | all
+
| title="Comment" |
+
|-
+
| title="Field name" | tower height
+
| title="Data type" | integer
+
| title="Description" | height of the tower/building above ground
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | cell_towers.csv
+
| title="Technology" | all
+
| title="Comment" | how to enter this data?
+
|-
+
| title="Field name" | technology
+
| title="Data type" | string
+
| title="Description" | GSM/UMTS/LTE ???
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | measurements_.csv / cell_towers.csv
+
| title="Technology" | all
+
| title="Comment" |
+
|-
+
| title="Field name" | bcch
+
| title="Data type" | string
+
| title="Description" | Der Broadcast Control Channel ist ein Downlink-Kanal in GSM, der dem Endgerät Informationen über die aussendende Zelle liefert. Dies sind z. B. die PLMN-Kennung des Netzes, Cell-ID, Location Area, Kanalstruktur, Zugriffsbeschränkungen, Verfügbarkeit von Datendiensten und Frequenzen der Nachbarzellen.
+
| title="Filter criteria" |
+
| title="Formula (if computed)" |
+
| title="Affected components" | measurements_.csv / cell_towers.csv
+
| title="Technology" | all
+
| title="Comment" |
+
 
|}
 
|}

Latest revision as of 00:26, 3 February 2014

This page including its sub pages is intended for compiling all ideas on how to expand the information stored in the OpenCellID database.

The following data base tables are currently discussed:

Please use the "Discussion" page of each of the above sub pages for discussing the various ideas and concerns on this subject.

The plan is to keep this discussion going for a few weeks and decide what to implement when it becomes obvious that no additional new information is contributed regarding thess topics.
In cases where there are different opinions regarding a feature, a vote similar to the votes in OpenStreetMap, which is a proven mechanism, will be initiated.

Due to the current work load of the developer, it is unlikely to start with the implementation of the enhanced database scheme before summer 2014; therefore, there is enough time in that perspective to discuss the OpenCellID database evolution briefly.