My First FOSS4G Experience

I was delighted to be selected for a traveling grants for the HOTSUMMIT / FOSS4G to Dar es Salaam from the27th August to 2nd September. The Free and Open Source Software 4 Geospatial (FOSS4G)conference is the largest community gathering focused on open source geospatial software. The event brings together developers, users, decision-makers and observers from wide range of organisations and field operation. The event comprised of a series of workshops, presentations, community events as well as social events and hangouts. I learned that FOSS4G is a platform for collaboration, business and networking.

44312078692_440d11a17e_o

The workshops were held by developers of various software, and that gave us an opportunity to meet face to face with people using software one is interested in. My interest was on QGIS and I was able to attend a number of QGIS specific workshops. There was also a wide range of QGIS related presentations during the main conference. I became fully aware of how diverse the open source community is and how it is used by people from various discipline and that to me became prominent in the keynotes.

I learned from the conference how other countries make use of open source and I made a decision to create Lesotho OSGeo Local Chapter of which I wish to see Lesotho taking part in FOSS4G community. As a spatial planner all I thought was useful to me was how QGIS is used to manipulate data in making spatial plans but from what I learned from this conference I have to go beyond that and spread my wings. Open Source is important to everyone it is of assistance socially, economically and environmentally. There are some ministries or departments in Lesotho besides Physical Planning which I think can benefit from open data such as health and education to name but a few.

20180907_224306

I met a lot of people I have been in contact with through social media from HOTOSM, OpenStreetMap, OSMAfrica, Mapillary etc. That gave us a chance to exchange ideas and learn from each other. I was also able to hold my head high as Lesotho is well known for being the mostly mapped country through the #MapLesotho. However I realised how detailed Dar es Salaam OpenStreetMap is and learned that we can only achieve that if we can all come together as organisations, ministries, departments etc and map our country.

20180907_223746

I also volunteered and chaired some of the workshops and presentations and that taught me a thing or two; time management, coordinating and immediate decision- making. I’m really grateful and appreciative to the FOSS4G for granting me the opportunity to have such an amazing experience.

IMG-20180829-WA0000

Advertisements

End of #MapLesotho Phase 2

The mapping is over after a year of hard work and dedication by a number of us. We were  used to seeing the progress chart, and mappers watching how their districts are doing. Each day came with change, more tiles getting done, changing from white to orange to green when validation started.

However, some of the districts got this all wrong in terms of required effort.  That is to say, that we often appeared to not know the required accuracy and engagement.   That led to some of the tiles being invalidated and percentages simultaneously increasing and decreasing at some points, which seemed to frustrate some people. That is a normal thing for a collaboration involving the work of a lot of people.  The project slack feed would show that a core of 10 people contributed regularly, and others less frequently. Of the eleven tasks, only three Qacha’s Nek, Quthing and Thaba-Tseka got to 100% done and validated within the year, the rest either still needed some mapping or some more validation.

#MapLesotho phase II was designed to map the things that would help planners make plans, therefore we have to move on and make the map tidier and more useful. As a planner before making plans we have to map what’s there, in that case we would know what’s lacking in an area. We still have a long way to go when it comes to planning. It’s true we work at a local level, but we need guiding tools, there has to be a national plan that guides us as planners to plan our local areas. #MapLesotho is our foundation to make National, District then Local plans long into the future, so long as we get the hard work over with now.

#maplesotho analysis, QN vs Quthing the 2 complete districts

*Query*

SELECT admin_level,name, way

FROM planet_osm_polygon

WHERE admin_level is not null

 

*results*

admin_level name
5 “Mokhotlong District”
2 “South Africa”
2 “Lesotho”
5 “Mafeteng District”
5 “Mohale’s Hoek”
5 “Maseru District”
5 “Berea District”
5 “Quthing District”
5 “Leribe District”
10 “Setsoto Ward 14”
10 “setsoto Ward 12”
5 “Thaba_Tseka District”
5 “Butha-Buthe District”
5 “Qacha’s Nek District”

 

 

Next will be how to extract a district from the entire planet_osm

*Query*

Qacha’s  Nek                                                                         Quthing

CREATE TABLE qacha_district AS                 CREATE TABLE quthing_district AS

SELECT admin_level, name                              SELECT admin_level, name

FROM planet_osm_polygon                              FROM planet_osm_polygon

WHERE admin_level = ‘5’                                 WHERE admin_level = ‘5’

AND name = ‘Qacha’’s Nek District                 AND name = ‘Quthing District

 

Then in the next queries, we want to get the geometries that are only within two districts of choice (Quthing and Qacha’s Nek), so I had to use the ST_Intersects function. this will intersect my two specific districts with the rest of the planet geometries, namely; points, lines and polygons.

 

 

I was awe struck as I waited while the queries ran, for example, for qacha_lines table, it resulted in 32965 rows and took 3409067ms overall to load the results. This is an example of a map with content.

 

NB: there are numerous different ways around querying this.

 

*Queries*

Qacha’s Nek                                                                    Quthing

points

CREATE TABLE qacha_points AS (                CREATE TABLE quthing_points AS (

SELECT *                                                             SELECT *

FROM planet_osm_point as qp                             FROM planet_osm_point as qp

WHERE ST_Intersects(qp.way, (                         WHERE ST_Intersects(qp.way, (

SELECT way                                                       SELECT way

FROM planet_osm_polygon                                FROM planet_osm_polygon

WHERE admin_level = ‘5’ AND                         WHERE admin_level = ‘5’ AND

name = ‘Qacha’’s Nek District’)))                          name = ‘Quthing District’)))

 

 

lines

CREATE TABLE qacha_lines AS (                     CREATE TABLE quthing_lines AS

SELECT *                                                                SELECT *

FROM planet_osm_line as ln                                   FROM planet_osm_line as qn

WHERE ST_Intersects (ln.way, (                            WHERE ST­_Intersects(qn.way, (

SELECT way                                                              SELECT way

FROM planet_osm_polygon                                     FROM planet_osm_polygon

WHERE admin_level = ‘5’                                       WHERE admin_level = ‘5’

AND name = ‘Qacha’’s Nek District’)))                   AND name = ‘Quthing District’

 

You can do the same thing for polygons, you will just have to substitute the words line or point with polygon.

 

Now the next step is to create tables that count many things that are mapped in your districts as they are tagged, could be buildings, roads, rivers e.t.c as follows:

*Query*

SELECT highway, count(*)                               SELECT highway, Count(*)

FROM qacha_lines                                             FROM quthing_lines

WHERE highway is not null                              WHERE highway is not null

GROUP BY highway                                         GROUP BY highway

 

*Results*

QACHA                                                                     QUTHING

Highway Count highway count
Primary 34 primary 23
unclassified 167 secondary 13
secondary 36 unclassified 348
track 646 track 780
footway 458 footway 13
service 13 service 12
path 1520 path 2694
tertiary 47 tertiary 56
residential 703 residential 1139
road 6
bridleway 1

 

 

 

*Query*

SELECT waterway, count(*)                                     SELECT waterway, count(*)

FROM qacha_lines                                                    FROM quthing_lines

WHERE waterway is not null                                    WHERE waterway is not null

GROUP BY waterway                                              GROUP BY waterway

 

*Results*

QACHA                                                                     QUTHING

Waterway Count waterway count
Drain 20 drain 110
Weir 3 weir 3
River 141 river 149
Stream 14367 dam 1

 

*Query*

SELECT landuse, count(*)                                         SELECT landuse, count(*)

FROM qacha_polygon                                               FROM quthing_polygon

WHERE landuse is not null                                        WHERE landuse is not null

GROUP BY landuse                                                  GROUP BY landuse

 

*Results*

QACHA                                                                     QUTHING

Landuse Count landuse count
Cemetery 12 cemetery 82
Meadow 1 recreation_ground 1
Farmland 4184 farm 1
Farmyard 24 farmland 7760
Military 1 farmyard 258
residential 700 military 1
Orchard 3 residential 1935
Forest 24 orchard 1
Industrial 3 forest 154
Quarry 9 Quarry 42
plant_nursery 2 Industrial 1
commercial 9 Commercial 13
Landfill 1 Grass 6
Retail 1 Garages 1
health centre 1

 

 

*Query*

SELECT building, count(*)                                        SELECT building, count (*)

FROM qacha_polygon                                               FROM quthing_polygon

WHERE building is not null                                       WHERE building is not null

GROUP BY building                                                 GROUP BY building

 

*Results*

QACHA                                                                     QUTHING

Building count building count
House 38 house| 64
Church 4 Church 13
Ruins 104 farm 4
Hangar 1 ruins 290
Hospital 4 Kraal 2
Apartments 2 Industrial 3
Industrial 7 Commercial 130
Commercial 14 Clinic 1
Ruin 7 Office 40
Office 4 Yez 1
Civic 1 Wall 5
School 15 School 25
Shed 84 Terrace 1
Farm houses 2 Shed 11
Garage 2 Service 2
Wall 5 Hu 1
Residential 10 Garage 1
Wal 333 Residential 8
Cabin 3 Building 1
Yes 20431 Yes 34269
Construction 1349 Construction 3460
Retail 1 Retail 38
Hotel 11 Hotel 3
Hut 17910 Hut 24813
Garages 1 Barn 2
Ruind 1 Woolshed 1

 

After running and checking them analysis, especially for Qacha’s Nek because I definitely would know anything about Quthing. Our data is still not accurately tagged. For instance some of the buildings are tagged as yez instead of yes, wal instead of wall or ruind instead of ruins, more over some of the numbers do not match what is observeable of the area or on ground. For example, Qacha’s Nek does not have any industrial buildings but in the tabulated results our Industrial buildings = 7.

this is open for everyone to comment though!

the data used was that of the 28th december 2016, downloaded from download.geofabrik.de. this was loaded into pgadmin using the following command line:

cd C:\Program Files\osm

-c -d lesotho -K -H localhost -U postgres -P 5432 –slim -S default.style 2812-lesotho-latest.osm.pbf

QUTHING CELEBRATE NEW YEAR WITH VICTORY

img-20161213-wa0011-1

Good news for #MapLesotho on festive holidays, second district completed. Quthing is the second district to reach the finishing line and beat the dead line which is February 2017 for eleven tasks launched in June 2016.Quthing was the first district to host the mapathon on the 1st and 2nd of June 2016.

#MapQuthing mapathon was held by Quthing APPs and people from other districts joined to launch phase II. This time around tasks have got to be more detailed mapping more than just buildings and highways. On the 13th October Quthing was all mapped, that is, all tiles being yellow.

fb_img_1482904180511

That was good news but then validation was to be done and all in all there are 485 done by 15 mappers. The table below will illustrate,

screenshot_2016-12-27-22-53-58-1-1

I would like to thank every one who helped complete Quthing, this is for the good of the entire Mountain Kingdom not just one district completed. Geofrizzbdiscoe and DeBigC thank you so much for big effort you have put in making #MapLesotho successful. Welcoming 2017 in style, #MapLesotho. Happiiiiiiiiiiiiiii🎉🎉🎉🎉

#Maplesotho. Qacha’s Nek’s yet another success

IMG_20160905_191456

presenting the completion of the task #1942 of the Qacha’s Nek district detailed mapping, the first district to 100% mapped. Qacha’s Nek Assistant Physical Planners (APPs), would like to pledge their gratitude to the following people;  Andrewbuck, Autre for Nepal, DebigC, Greenmtdave, RustyB and Tshedy  for their most valued support making up the 13.5% of the contribution towards the completion this task.

img-20160906-wa0001

Mapping this task was a real deal and a great adventure for QN Mappers (APPs). It was not an easy road but it came with positive factors like the much appreciated outside help mentioned above and the  never ending courage they received from the DebigC . all this helped them to overcome any obstacle. QN Mappers(APPs) would also like to recognize her Majesty the the Queen of Maplesotho A.K.A Tshedy,  for being their inspiration. “we want to be a bunch of you.”

img-20160906-wa0000

QN Mappers namely; (MontshyQn, FifiQn, Topsqn, Mabatho and Stanley Makhanya)img-20160907-wa0005  showed great team work and extended much dedication which lead towards the successful completion of this task. Not leaving behind MontshyQn who has claimed a leadership position by throwing in the  28% contribution.—> way to girl, keep up the good work.<—

 

#Maplesotho QN’ s success

img-20160907-wa0006

Qacha’s Nek celebrates victory when QN Analysis kombat, the analysis team from Qacha’s Nek was presented a winner in the analysis month competition. QN Analysis Kombat members, Fifiqn, Stanley Makhanya and MontshiQn, and Topsqn (a behind the scene member) dedicated their all when they were confronted with this competition. This competition was an uphill climb for them, it hurt their heads a lot but in the end, it was all worth it when they won themselves a prize of a limitless month’s internet. QN Analysis Kombat wishes to thank the following people

  • Fifiqn the team manager who worked tirelessly and drove her team towards this victory.
  • RustyB, who was always available to lend a helping hand here and there at any given time of the day.

QN Analysis Kombat, again thanks RustyB since this competition introduced them to other interesting and new things like how to commit repositories using a markdown format in github, how to create, open and use gists also in github and how to interact using slack, a very interesting application which is like whatsapp but even better since one can even add “code snippets” so that they appear as they should, something whatsapp cannot do I think.  QN Analysis Kombat’s team members, worked till late ours, they googled, they read a lot and they consulted in order to achieve all this greatness. In the end, out of this competition, a lot of knowledge and skill is acquired. QN Analysis Kombat wishes to thank all those who congratulated them upon their victory.

#Maplesotho, this is one project we are proud of, that brings out our inner hard worker.

GO QN ANALYSIS KOMBAT and  RISE #Maplesotho.