db_query / queries

Commit History

Fix KML site labels and update physical DB
e81ad8d
Running

DavMelchi commited on

Add site profile bands for CIQ 3G and 4G
ad9d9f8

DavMelchi commited on

Adjust 3G WBTS IDs for U900-only sites
c3d5a3c

DavMelchi commited on

Fix ADJL pandas copy warnings
544393a

DavMelchi commited on

Remove stray debug prints
71d8e09

DavMelchi commited on

Align 2G CIQ output with final schema
824d7bb

DavMelchi commited on

Refactor CIQ 3G final schema config
d13ea55

DavMelchi commited on

Normalize MRBTS keys before merges
abd754b

DavMelchi commited on

Handle dump headers on first or second row
7efc151

DavMelchi commited on

Add selectable CIQ sheet detection
d9f7219

DavMelchi commited on

feat: add 3gpp ue capability parser with volte assessment
7b6d659

DavMelchi commited on

Add UI toggle for decommissioned 2G BSC exclusion
885850c

DavMelchi commited on

Add INVUNIT_NUMBER sheet with cleanup and MRBTS name lookup
e925d18

DavMelchi commited on

Fix KeyError when optional DB columns are missing
ab417d5

DavMelchi commited on

improve perf
32d2c79

DavMelchi commited on

update 2g ciq
1fc2001

DavMelchi commited on

update TRX calculation to reset per BSC+BCF and count in btsId order
b333e60

DavMelchi commited on

update CIQ app
7723c9f

DavMelchi commited on

forbiden BCF
68f370b

DavMelchi commited on

adding CIQ verification app
53c4407

DavMelchi commited on

create BCF ID if missing
1d869c5

DavMelchi commited on

Add TDD band support to CIQ 4G Generator with L2300 band configuration, implement non-breaking space stripping in integer parsing, update default band blocks to include L700/L2300, add TDD_BANDS set for conditional UL EARFCN omission, extend 4x4 MIMO mode assignment to L2300, and refactor output column builder to skip UL EARFCN columns for TDD bands
00554ac

DavMelchi commited on

Add CIQ 4G Generator with LNBTS/LNCEL sheet generation, implement site parsing from CIQ brut Excel with eNodeB/cell name extraction, band detection from cell names, sector ID mapping, DL/UL EARFCN conversion, MIMO mode assignment per band, and multi-band block configuration builder with TAC/PCI/RSI parameters and Excel export
1c0596c

DavMelchi commited on

Add CIQ 3G Generator with WBTS/WCEL sheet generation, refactor CIQ 2G to extract shared site parsing logic with MCC/MNC parameters, implement TRX sheet builder with BCCH/TRX frequency parsing and MAIO assignment, add BTS sheet builder with template name detection and sector ID mapping, and create MAL sheet builder with mobile allocation frequency extraction from CIQ brut Excel
1e7ca72

DavMelchi commited on

Add CIQ 2G Generator with BCF assignment logic, site parsing from CIQ brut Excel, dump BTS column extraction, band/sector detection, configuration building, and multi-sheet Excel export with placeholder sheets for BTS, GPRS, AMR, HOC, POC, MAL, PLMNPERMITTED, and TRX
b9e6156

DavMelchi commited on

Improve databases with fatima request
7045784

DavMelchi commited on

improve invunit
95972c3

DavMelchi commited on

add HSN to gsm db
35a5ba2

DavMelchi commited on

improve invunit
fc6fa12

DavMelchi commited on

Add 3G Adjl checking
a7ca75d

DavMelchi commited on

Process ADJL - 2G part 1st
f135ea9

DavMelchi commited on

Remove process MRBTS and introduce ADJL
2e86e92

DavMelchi commited on

IMPROVE MRBTS INFOS
a365f87

DavMelchi commited on

adding NICE DB
9a4ad92

DavMelchi commited on

Adding City Adresse Commune and cercle to Physical DB
9d69630

DavMelchi commited on

Add City to DataBase
002ceab

DavMelchi commited on

improve neighb report size
c03a5ca

DavMelchi commited on

Adding same BSIC and BCCH checking to ADCE
9457c7e

DavMelchi commited on

Fix pandas warning
485e98c

DavMelchi commited on

Addind Synchronized checking
cd3fd31

DavMelchi commited on

add some columns to gsm
81c766f

DavMelchi commited on

adding TXR initialfreqeuncy distribution chart
337f0be

DavMelchi commited on

Adding Distance to all neighbors
9bd7cb4

DavMelchi commited on

Adding coordinates and distance to ADCE
4989fde

DavMelchi commited on

adding NEI symetrique checking
449287c

DavMelchi commited on

clear Pandas .loc warning
ec8f588

DavMelchi commited on

adding Analysis for site database
56f36cc

DavMelchi commited on

Adding site database and sheet
424caf8

DavMelchi commited on

adding cells mandatory for capacity analysis
46a5af8

DavMelchi commited on

add few formating to excel
1b27434

DavMelchi commited on