I am in the process of learning Node and React in order to rewrite the app with an intent of refactoring into a simpler app which I can put up on Github as open source.
During the last few weeks I’ve rewritten the data collect app to provide more intuitive interface and added the capability to edit or add new assets to the web mapping system. In addition, I’ve added the capability for the manager to audit and approve the additions or changes. This allows public works staff to add or change information in the field intuitively. The next step is adding all our service-line information to the map and the upgrade lets me delegate the task to public works… a win-win 🙂
I have decided to support local community groups by donating 25% of my fees after the first year when much of the set-up and mapping work is complete. Feels quite satisfying to be able to make difference by not only to small rural municipalities by providing access to tech via open source & cutting costs drastically but also being able to support local community groups.
Creativity is thriving at the village facilitated by open source tools. Our web site is based on WordPress which has allowed us tremendous freedom to add and modify content with ease. Staff has also started contributing more content. Introduction of WordPress to museum staff followed by open source media tools is empowering them them expand into creating rich multimedia and streaming content. The COVID crisis has only increased the importance of these tools for public information and discourse.
The design of the system is complete and I am very pleased with the final product. It is powerful while retaining simplicity in its code base. This is a practical software to be used operationally, day to day. It is not just a collection of fancy reports that have no bearing on the reality of running a small municipality. I put a lot of though on the design of the reports to convey useful information while avoiding unnecessary complexity. I’ve also been able to shave off costs for servers etc allowing me to offer basic service for free and thus democratising asset management. This compares to tens of thousands to implement anything near the functionality of the system. I had set out to design a system that was inclusive and I am proud to have accomplished that , allowing small municipalities to access a toolset not otherwise afforded to them. This also builds the platform that will allow me to expand into low-cost sensors & AI. Now comes the marketing which admittedly is not my strength, although I think in time with the quality of work and word of mouth I should be able to reach a significant audience.
The AM workshop was a success. There were a full range of municipalities from the very small to larger ones like Burnaby present. I believe everyone took away something practical from the workshop. I had finance professionals working on GIS and Databases and kept them engaged so I consider that a success! The feedback has been positive. The interest in BI continues so that it could be a recurring topic for future workshops.
I am conducting a GFOABC pre-conference workshop demonstrating a full-features system comprised of an integrated database, GIS system, Business Intelligence based reporting and a web-application. This hands on workshop has participants building an asset management system with real world data and gaining practical experience and appreciation of challenges involved. Participants need only to bring their laptops and desire to learn. No prior technical background necessary.
Please load the following on your laptop: