Block grid system usage at the example of Estonian Postal Services
Kemo Oolep
Deploy OÜ
kemo.oolep@gmail.com
- around 2300 emloyees
- leader of parcel terminal market in Baltics
Omniva group
- international post and logistics comapny
- has 5 companies from the Baltics
There comes client
And there comes requirements
So we started to build BLOCKS
Generated out from:
in the database
this array is unnested + the geometry aggregate (re-)calculated
875000,875001,875007,875008,875009,903489,903490,913095,913096,913435,913436,914112,927305,927837,927839,929857,929858,931568,952849,952850,953233,953234,953245,956428,956452,956453,959481,959482,962737,969587,969588,969589,969590,969591,969592,969593,980661,980668,988687,988688,988689,996904,996932,996933,996968,1005667,1018950,1018951,1023436,1023437,1026775,1027996,1027997,1027998,1027999,1028000,1037034,1037035,1037041,1041860,1041883,1041884,1046698,1046699,1051460,1051463,1051465,1056243,1061130,1061131,1061135,1061138,1066042,1066043,1070776,1070777,1080825,1085642,1090455,1090456,1100077,1110146,1110150,1110154,1110155,1119651,1119678,1129677,1129678,1129721,1134596,1134599,1139392,1149217,1154230,1158893,1163705,1163706,1163752,1178213,1178251,1178252,1178254,1178255,1187644,1192719,1202345,1202365,1202366,1202370,1202371,1206914,1206915,1211637,1211662,1211664,1211665,1211666,1211667,1216220,1216221,1216222,1220718,1225589,1225590,1225594,1225596,1230305,1230306,1230307,1230308,1230309,1230312,1230315,1234991,1235022,1235023,1235027,1239456,1239457,1239459,1244133,1244134,1244135,1244136,1244137,1244138,1248803,1248859,1258272,1258276,1262937,1272139,1276675,1276680,1280929,1280930,1285293,1294245,1294286,1294287,1298692,1298695,1303184,1303185,1307693,1307694,1307695,1312008,1312052,1312067,1312070,1312074,1320966,1320982,1320983,1320984,1325431,1325432,1329840,1329861,1334215,1334216,1334218,1338609,1338610,1342841,1342882,1347230,1347264,1356003,1356004,1356008,1356010,1360151,1364583,1364599,1364610,1364622,1364623,1373222,1373223,1377475,1377505,1377520,1377521,1377522,1381616,1381617,1385848,1389921,1398149,1398165,1398167,1402403,1406398,1406425,1410716,1410723,1410725,1410726,1414984,1414987,1414989,1419181,1419183,1423330,1427504,1427525,1427527,1427528,1431664,1431670,1431673,1435667,1435670,1435672,1435676,1435678,1448045,1448047,1448048,1448049,1452039,1452050,1460103,1460104,1460107,1460108,1460109,1464090,1464093,1472505,1476614,1476618,1476623,1480707,1480723,1480724,1484609,1484624,1484653,1484654,1496748,1500741,1504623,1504653,1504654,1508810,1510476,1512723
Block
Has all the information
Has relations
Can be sliced, all relations will be updated
Superblocks
User interface to handle this
User interface to handle this
MS SQLServer
database backend
GeoServer
serving WMS/TMS/WFS + vector tiles
OpenLayers + React
standalone application + embedded maps in UI
Spring boot + RabbitMQ
For background preprocessing
PostgreSQL/PostGIS, QGIS, OGR,
Python ...
ElasticSearch
for serving all the geocoding needs
THANK YOU!
Kemo Oolep
Deploy OÜ
kemo.oolep@gmail.com