QGIS

Mobile Data Collection: Input

rjhale · Feb 25, 2020 · Leave a Comment

If you flash back to 2008 you would have seen me sitting on my couch unwrapping a Trimble SB (?) running Arcpad. At the time I thought “collecting data” would be a beneficial add-on to me being a consultant. Spoiler alert – It wasn’t.

If you flash back to 2013 I was sitting in the Caribbean needed to collect data and I was holding a new giant yellow GPS unit that wouldn’t quit rebooting when it got hot. Spoiler Alert – It’s always hot (generally) in the Caribbean. What I did find is Fulcrum – and that allowed me and about 5 or so folk to disperse and work all over the place and collect data – WITH OUR PHONE. Which for 2013 was pretty awesome for me.Since then I’ve always been interested in how people are collecting data. I will make fun of you for doing it “Pencil and Paper” but I will admit to having a field journal and pencils in my laptop bag just in case.

A client asked a few weeks back “We need to take a copy of the data into the field” and that trip into the field was going to be with no to limited connectivity, no data collection, but they needed to know where they were. They are a IOS/Mac heavy group. Print a map seemed a bit harsh and working through some other hoops seemed unnecessary.

So my suggestion was Input. So what is an Input? Lutra Consulting developed a mobile app built off the QGIS Source Code. It runs on Android and IOS. There are tutorials out there on using Input. I can’t do better than the ones that are out so I won’t even try. I can throw in some screen shots and just general discussion on why Input is pretty cool from an avid QGIS user. When you get it installed on your mobile device of choice you get this:

Simple. Home being the map screen, my projects being things you can work on, shared being projects that are shared with you from others, and finally explore just in case you can’t find your project.

So we will tackle this one of two ways. One way with Mergin and one without. What’s Mergin? Mergin is the commercial end of Input. Commercial? What? Yes – there is a commercial end of Input.

1. Install Mergin and Get an account. Don’t worry – it’s free for small projects. Download Mergin from the Plugin Manager in QGIS. Mergin will appear in your browser panel.

2. Build a project in QGIS. Import your data into Geopackage. Build the project the way you’d want it to be displayed on your phone. When I say “build your project” you’re going to build widgets for data input, set up labels, and set up your colors. I prefer boring as seen by this screenshot.

3. Import your project into Mergin (You’ll have to connect the plugin to your Mergin Account).

Give it a few minutes and you can now download your project into Input and start working. Edit your points, lines, and polygons….and attributes….

4. Sync your project back to Mergin. Download it back to your computer.

One word of caution :

You’re going to build a project .
You’re going to COPY it to the server using Mergin.
Move it to your mobile device.
Edit it locally and sync it back to the server
Eventually you’re going to download it back to your compute using Mergin
So at the end you’ll have one old project and one new one sitting on your machine. Just pay attention. I did get confused at first but I’m slow.

You don’t want to use Mergin?

Then copy your data to your mobile device.
Create a directory under the projects folder under Input and move your data there.
Start working. At some point you’ll have to manually move things back to your laptop.

….and there you go.

So where does that leave me with all of my current love of data and databases? So as an experiment I connected to a test server and edited data against PostGIS (live). I wouldn’t suggest that for day to day because “you always need a network connection of some sort”. So I’d always build a local project to share to your mobile device.

I need more than “me” collecting data – then read up. Several people can edit and Lutra has used Geodiff to handle multiple users. All your edits can go back into the same geopackage that you download back to your Workstation.

So should you pay for Mergin? If I stuff a street centerline file, building footprints, streams, and a few other things for a medium sized city I’m getting close to 100mb of disk space. So I’d say pay. If you just can’t pay – then keep it under 100Mb or manually move your data over.

Overall I like it. For years I’ve said “QGIS on Mobile” and now we have Qfield and Input.

Fishbones for the TN NG911 Address Server

rjhale · Feb 19, 2020 · Leave a Comment

It’s been a bit since I’ve talked about the TN address server. I’ve been slowly adding more functionality to it and some of that functionality has been more difficult than others.

If you’ve played in the address space any length of time you’ve heard of fishbones – and that is simply drawing a line from the address point to it’s “spot on the street”. Granted if you’ve ever done an addressing project from scratch (I had the joy to do that a few years ago in the Caribbean) it makes a lot of sense. You can quickly see problems where lines cross over other lines or where addresses have no lines at all. Please read up here if you are so inclined.

There are probably multiple ways to do this but I’ve gotten fishboning (if that’s a word) running in the TN NG911 Address Server. In PostGIS with less than 25 lines of SQL (and I’m quite proud of myself – 5 years ago I sucked at SQL. I still suck at it – but way less). While it’s not quite ready for prime time it’s close – I’m just trying to figure out what I can pull out of this that makes the County’s job easier in the addressing realm. I’d love to move it to python at some point – and it’s probably doable (well I know it is – it’s just doing it).

Three things happen:

I join the address point to the closest road using ST_LineLocatePoint
Does the closest point fit the address range on the street (double bonus I also check left and right).
Finish it up with ST_Makeline to join the spot closest to the street to the address point.

Which quickly shows something is wrong here:

Bonus for this one as is it’s not incredibly obvious what the problem is at first glance….UNTIL you see you have an addressing issue where you have 2, 3, and 4 on the same side of the street.

Hurrah for misspelled street names by leaving a W off

Anyway – there will be more announcements coming like this “running in the cloud” and other things. I’d like to get the fishbones running once a night or realistically run the one for the new address. Why not both probably. Anyway – pretty nice for an ArcView/FGDB Replacement.

QGIS 16 Hour Class May 13-14th 2020

rjhale · Feb 11, 2020 ·

The QGIS Workshop makes an appearance on May 13th-14th 2020 at Chattanooga State Technical Community College.

This 16 hour workshop is designed to introduce you to QGIS 3.x, an alternative Open Source GIS software for viewing, editing, and managing spatial data in a wide variety of commonly used vector and raster formats. It is lightweight, flexible, and can be installed on Windows, MacOSX, and Linux. Best of all, most will find QGIS to be extremely affordable while still providing a growing list of features and functionality.

Length of workshop: Approximately 16 hours

Topics Covered:

Interface
Vector Data
Raster Data
Plugins
Processing Tools
Field Calculator
Exercises Throughout

Registration: https://www.campusce.net/cscc/course/EventDetail.aspx?C=106

Cost: $700

Now that I have all that boring stuff out of the way…..

So the first class went pretty well and although small – I received great feedback from people. Plus it made me navigate my way back through the QGIS Certification process for my end (Certificates/Payment). So the two day will get a slight upgrade for the May class and I should have certificates in hand on the last day. Plus the exercises will be a lot easier vs what I’m doing now.

On the facility – Easy parking and easier lunch. Granted we will all need to jump in a car for lunch it’s only a few miles away.

Anyway – come learn some QGIS and hang out in Chattanooga for a few days.

QGIS 4 hour workshop at TNGIC Conference on April 7th 2020

rjhale · Feb 4, 2020 ·

It’s that time of the year again.

So I’ll be doing the 4 hour QGIS Workshop at the TNGIC Conference this year. The Conference will be in Kingsport TN for 2020. Where is Kingsport? Head to the NE Corner of the state until you’re about an hour past the last “Gatlinburg TN” sign.

If you happen to scroll past all the ESRI Centric stuff I’m at the bottom. As I’m not getting paid for this workshop I’d highly encourage you to sneak in. In fact – bring a friend. I’ve capped the class at 20 but if history is any indication I’ll be in a oversized room. Bring data. Bring Questions. Bring people.

What are we going to cover?

How this is better than ArcPro
Symbology
Making maps
Reading data
Editing data

What do you need?

QGIS
Laptop
Sense of Humor

If we have time after the class we can discuss a Full Open Source Server Installation for those that are interested.

Where is my workshop? I have no idea.

What time is my workshop? No one has told me.

I suppose it’s somewhere in all the details – BUT – show up! I’ll show you a new way to enjoy your GIS again.

The 10th Day of XYMas….QGIS

rjhale · Jan 3, 2020 ·

……….andthis was a given…….So what am i going to tell you that you don’t already know about QGIS. If you’ve even remotely been up here for any length of time you know I’m a fan and use the software for work, attempt to train people in it, and just generally enjoy it.

So here’s something a bit different: QGIS Community

Yeah – it’s not a technical post but a post about the group of people I’ve gotten the chance to talk to over the last year:

Nyall Dawson – he completely rocked the QGIS meeting we had in Chattanooga. Remotely. He stayed up from 11:00 PM to over midnight (Australian whatever time) to talk to a group of people in Chattanooga. Not paid and never blinked. He’s a major contributor/programmer in the QGIS Community. He’s awesome.
Nathan Woodrow – The first person to answer my first QGIS Question (maybe in 2012?). He randomly pops up in the morning and we chat. Why? I have no clue why anyone wants to talk to me but I appreciate the random notes, google chats, and questions. Plus he has to put up with me asking random python questions.
Saber Razmjooei – So Saber popped up one day and asked “Hey have you heard about Input?” and he patiently waited for me to get time cleared out and walked me through the software. Even did a video hangout which meant for him it was after hours. It was awesome.

Why is QGIS So much fun? It’s these people. Not necessarily ONLY these people. It’s the interaction with the community. I’ve been in GIS for way to long so you can jump up and point at your technical support and I’ll go “meh”. Show me the people using the software and other people I can talk to at this point.

The QGIS Community starts here:

…and it builds out from there. Communication happens over the email lists. I tune in there and twitter for news and noise. It’s a good group of people who are friendly and good at answering questions. Bonus you get to watch this all get made if you want. Yes – watch this all come together as debates are held, questions raised, and problems are all out in the open. It’s awesome. I have filed terrible bug reports and good bug reports and people answer them. I have complained and they’ve responded with just being super nice about my complaining.

So I’d encourage you to join the email lists, donate time and resources, and contribute to a great project. So for the 10th day of XYMas – I give you a community of people.

QGIS

Contact