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
- we won't educate our employees to have GIS aknowledge
- business logic must be validated by system
- collect all requirements that are inside logistics heads
So we started to build BLOCKS
Generated out from:
- settlement unit's borders
- road network
- railways
- river centerlines
- cadastrial parcels where applicable
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
- own unchangable identifier
- own shape
- can be transformed without causing problems
- address if defined
- zipcode
- servicing areas
- price zone areas
- parcelmachine areas
- mailboxes if defined
- unlimited usecases
Has relations
Can be sliced, all relations will be updated
Superblocks
User interface to handle this
User interface to handle this
TECHNOLOGY STACK
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 ...
TECHNOLOGY STACK
ElasticSearch
for serving all the geocoding needs
THANK YOU!
Kemo Oolep
Deploy OÜ
kemo.oolep@gmail.com
foss4g
By Kemo Oolep
