23-12-25, 04:32 AM
3WiFi is a free database of Wi-Fi hotspots created by the Router Scan / Stas'M Corp community. It is not a commercial service like WiFi Map, but a project that collects technical information about Wi-Fi hotspots (including vulnerable devices) around the world.
Data is provided by users.
Access point data is voluntarily submitted to the database by users who run scans via Router Scan and upload the results to the website.
🔹 Contains technical parameters.
The database stores various detailed fields
🔹 Access point coordinates
The geolocation of access points is determined automatically by BSSID (access point MAC address) through third-party geolocation services.
GEO:
NETS:
Download File:
I wish everyone a good day!
Data is provided by users.
Access point data is voluntarily submitted to the database by users who run scans via Router Scan and upload the results to the website.
🔹 Contains technical parameters.
The database stores various detailed fields
🔹 Access point coordinates
The geolocation of access points is determined automatically by BSSID (access point MAC address) through third-party geolocation services.
GEO:
Code:
CREATE TABLE IF NOT EXISTS `geo` (
 `BSSID` bigint(20) unsigned NOT NULL,
 `latitude` float(12,8) DEFAULT NULL,
 `longitude` float(12,8) DEFAULT NULL,
 `quadkey` bigint(20) unsigned DEFAULT NULL,
 PRIMARY KEY (`BSSID`) USING BTREE,
 KEY `quadkey` (`quadkey`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `geo` (`BSSID`, `latitude`, `longitude`, `quadkey`) VALUES
(1, 60.01082993, 30.34729004, 26828257630231),
(2, 28.55530739, 77.08552551, 30130242625494),
(5, 55.79156494, 37.95751572, 27286327558118),
(6, 50.08129120, 19.88912201, 27071908952396),
(8, 52.38114166, 9.74131680, 26994366277363),
(11, 55.81186295, 37.71264267, 27286303297314),
(16, -37.77166748, 144.96073914, 59018928508470),
(17, 50.29106522, 18.94602394, 27068626159654),
(20, 60.03046036, 30.24308014, 26828246929988),
(24, 43.35181427, 132.17388916, 31872943184004),
(33, 55.74535370, 38.63207626, 27287224499722),
(34, 55.74514771, 38.63178253, 27287224499169),
(35, 55.74518204, 38.63155365, 27287224499096),
(72, 26.05719376, -98.36452484, 12615027156146),
(80, 48.14829636, 11.53677845, 27146364136302),
    (281474976710655, 55.68841171, 37.55886078, 27286360182024);NETS:
Code:
CREATE TABLE IF NOT EXISTS `nets` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `time` timestamp NULL DEFAULT NULL,
 `cmtid` int(10) unsigned DEFAULT NULL,
 `IP` int(11) DEFAULT NULL,
 `Port` smallint(5) unsigned DEFAULT NULL,
 `Authorization` tinytext DEFAULT NULL,
 `name` tinytext DEFAULT NULL,
 `RadioOff` bit(1) NOT NULL DEFAULT b'0',
 `Hidden` bit(1) NOT NULL DEFAULT b'0',
 `NoBSSID` tinyint(3) unsigned NOT NULL,
 `BSSID` bigint(20) unsigned NOT NULL,
 `ESSID` varchar(32) DEFAULT NULL,
 `Security` tinyint(3) unsigned DEFAULT NULL,
 `NoWiFiKey` tinyint(4) NOT NULL DEFAULT 0,
 `WiFiKey` varchar(64) NOT NULL,
 `NoWPS` bit(1) NOT NULL DEFAULT b'0',
 `WPSPIN` int(10) unsigned NOT NULL,
 `LANIP` int(11) DEFAULT NULL,
 `LANMask` int(11) DEFAULT NULL,
 `WANIP` int(11) DEFAULT NULL,
 `WANMask` int(11) DEFAULT NULL,
 `WANGateway` int(11) DEFAULT NULL,
 `DNS1` int(11) DEFAULT NULL,
 `DNS2` int(11) DEFAULT NULL,
 `DNS3` int(11) DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE,
 UNIQUE KEY `WIFI` (`NoBSSID`,`BSSID`,`ESSID`,`NoWiFiKey`,`WiFiKey`,`NoWPS`,`WPSPIN`),
 KEY `BSSID` (`BSSID`) USING BTREE,
 KEY `ESSID` (`ESSID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30223736 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `nets` (`id`, `time`, `cmtid`, `IP`, `Port`, `Authorization`, `name`, `RadioOff`, `Hidden`, `NoBSSID`, `BSSID`, `ESSID`, `Security`, `NoWiFiKey`, `WiFiKey`, `NoWPS`, `WPSPIN`, `LANIP`, `LANMask`, `WANIP`, `WANMask`, `WANGateway`, `DNS1`, `DNS2`, `DNS3`) VALUES
(1, '2016-05-23 21:28:12', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 132098958484324, 'ASUS', 193, 0, '9264319757', b'0', 6525200, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, '2016-10-19 21:08:01', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 48751583425856, 'ASUS21', 193, 0, 'blacktea21', b'0', 30439245, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, '2016-02-22 12:02:25', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 247163795465769, 'SaabExpertOffice', 225, 0, '111111111', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, '2019-03-11 07:41:15', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 268749066239920, 'Asus1536', 225, 0, 'masirat1959', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, '2017-04-22 19:33:35', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 268749066239920, 'Seven-sky105', 225, 0, 'masirat1959', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, '2015-12-27 15:53:18', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 233918939486322, 'UPVEL', 225, 0, 'Upvel123', b'0', 49378429, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, '2016-10-19 21:10:56', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 233918939486322, 'UPVEL', 225, 0, '89168648756', b'0', 49378429, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, '2018-02-07 13:00:54', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 233569151838012, 'Maks', 193, 0, '12345678', b'0', 98128907, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, '2015-11-19 11:47:30', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 158969165988460, 'DIR-615', 225, 0, '12345678', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, '2016-02-22 12:02:29', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 136606244655, 'QTECH-114312', 225, 0, '29943562', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, '2016-08-27 17:56:46', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 36074244586578, 'asus520', 161, 0, '3030303030', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, '2016-08-28 11:59:29', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 89420834244, 'moris druon', 193, 0, 'arovanna1', b'0', 50501809, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, '2018-04-14 13:47:52', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 49135996411851, 'Monstr64', 193, 0, 'lipeck48', b'0', 37036935, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, '2019-02-19 03:57:44', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 18413742392144, 'ASUS LAG', 193, 0, 'HDDREC1990', b'0', 25956719, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, '2021-06-12 13:59:41', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 13431564372475, 'MGTS_GPON_B908', 193, 0, 'sTSjXSke', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, '2021-07-18 14:56:31', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 13431564372475, 'MGTS_GPON_B908', 193, 0, '20213500', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, '2020-10-04 14:43:28', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 13431564372103, 'Syn511_2.4G', 193, 0, '20173500', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, '2019-02-18 15:35:30', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 172001945239155, 'ASUS Network', 193, 0, '9161433026', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(19, '2022-07-22 11:44:07', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 220152328922144, 'lyda', 193, 0, '9295542376', b'0', 29762514, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(20, '2020-01-13 14:16:02', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 220152323761768, 'CARECA', 225, 0, '11121987', b'0', 9109520, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, '2015-11-19 11:51:11', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 225066312682366, 'homest', 225, 0, '1122334455', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, '2020-01-08 12:08:58', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 273711865970401, 'Kv_228', 193, 0, '9653186229', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(23, '2017-10-13 08:11:48', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 220152323740584, 'ILDERFSON', 161, 0, 'vidalouca210891', b'0', 45304347, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(24, '2016-08-27 17:59:36', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 215769621177524, 'Klop20001', 225, 0, 'tel7330553', b'0', 20494421, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, '2018-08-13 13:23:10', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 233512605932540, 'Beeline_2G_F21397', 225, 0, 'Dr8YMfCeTY', b'0', 60785992, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(26, '2016-08-27 18:00:05', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 151740156233, 'dshbam', 193, 0, 'arovanna1', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(27, '2017-10-18 09:41:20', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 151740156233, 'dshbam', 193, 0, 'arovanna2', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, '2018-07-21 16:40:43', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 62488679221860, 'ASUS', 193, 0, 'asavor70', b'0', 3352021, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(29, '2020-05-02 15:44:12', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 105979604736075, 'DIR-815S', 193, 0, '37969417', b'0', 37969417, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(30, '2020-12-03 16:05:58', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 105979604736075, 'Kotsvell', 193, 0, '300689lvbnhbq', b'0', 37969417, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(31, '2018-03-28 20:39:19', 0, NULL, NULL, NULL, NULL, b'0', b'0', 0, 255726490159224, 'TP-LINK_9B0878', 193, 0, '00244138', b'0', 244138, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(30223735, '2019-12-18 08:35:57', 1, NULL, NULL, NULL, NULL, b'0', b'0', 0, 224497407444481, 'MikroTik-39', 225, 0, 'lotoreya', b'1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);Download File:
I wish everyone a good day!
