software solutions network element information management neim : gis solution case study...
TRANSCRIPT
SOFTWARESOLUTIONS
Network Element information Management
NEiM : GIS solution
Case Study
Telecommunications > Geomarketing
SOFTWARESOLUTIONS
Network Element information Management
1. NEiM overview
2. Telecom Geomarketing case study
Agenda
SOFTWARESOLUTIONS
Network Element information Management
1. NEiM overview
SOFTWARESOLUTIONS
Network Element information Management
Description
> Geographical Information System (GIS) (intranet mode)
> Maps (point of sales, network…) shared between users
> Geo-data analysis (coverage vs population…)
> Integrated dataset (geographical layers, population density per square km…)
1. NEiM overview (1/5)
SOFTWARESOLUTIONS
Network Element information Management
Basic features
> Create/Edit map from one or multiple layer(s)
> Export data/map (CSV, KML, TAB, SHP, GIF…)
> Attach pictures/documents (JPG, GIF, PDF, DOC, XLS…)
> Search, Select, Zoom in/out, Measure distance, Print…
1. NEiM overview (2/5)
SOFTWARESOLUTIONS
Network Element information Management
Advanced features
> Users/Maps management : users profile, map sharing…
> Files/Database management : files upload (TAB, SHP…)...
> Create/Save/Export SQL query
> Analysis : Layers comparison, Coverage eligibility, Coverage radius…
1. NEiM overview (3/5)
SOFTWARESOLUTIONS
Network Element information Management
Integrated dataset
> Icons library
> Google Maps, Open Street Maps…
> Worldwide geographical layers (administrative boundaries, primary/secondary roads, railways, rivers…)
> (optional) Population density, Wind/Solar intensity…
1. NEiM overview (4/5)
SOFTWARESOLUTIONS
Network Element information Management
1. NEiM overview (5/5)
SOFTWARESOLUTIONS
Network Element information Management
2. Telecom Geomarketing case study
SOFTWARESOLUTIONS
Network Element information Management
Objectives> Estimate the number and location of Base Stations required> Calculate the % of population covered
within a given area of study and where population density is above a certain level.
2. Telecom Geomarketing case study (1/7)
SOFTWARESOLUTIONS
Network Element information Management
Area of study> Location: Sibut (Central African Republic)> Total population: 27,712> Total surface: 1739 square km
Assumption: population per square km > 20> Urban: pop per sq km > 300, coverage radius: 0,5 km> Suburban: pop per sq km: 50-300, coverage radius: 2 km> Rural: pop per sq km: 20-50, coverage radius: 12 km
2. Telecom Geomarketing case study (2/7)
SOFTWARESOLUTIONS
Network Element information Management
Requirements> NEiM solution> Population density (LandScan) vector layer of Sibut area
PS: LandScan integrates daytime movements and collective travel habits into a single measure to produce a better representation of where people are located during an average day.
2. Telecom Geomarketing case study (3/7)
SOFTWARESOLUTIONS
Network Element information Management
Step 1: Locate the most populated areas> by SQL query: population per square km > 20 (highlighted by the green squares in figure below)
Total targeted population: 19,566Total targeted surface: 23 square km
PS: the above numbers have been calculated by exporting the SQL query in CSV (Excel compatible)
2. Telecom Geomarketing case study (4/7)
SOFTWARESOLUTIONS
Network Element information Management
Step 2: Locate the theoritical Base Stations> by creating Base Stations in center of the targeted areas (where population per square km > 20) (highlighted by the blue circles in figures below)
Number of Base Stations required: 17
PS: Base Stations locations can be extracted fromthe CSV export (Excel compatible)
2. Telecom Geomarketing case study (5/7)
SOFTWARESOLUTIONS
Network Element information Management
Step 3: Calculate the % of population covered> by comparing 2 layers: « Population density » vs « Base Stations »
% of population covered: 63%
2. Telecom Geomarketing case study (6/7)
SOFTWARESOLUTIONS
Network Element information Management
Results> Number of Base Stations required: 17(Location of Base Stations can be extracted from the CSV file)> % of population covered: 63%
Time to generate the above results> Less than 2 hours (including manual tasks)
2. Telecom Geomarketing case study (7/7)
