North River Geographic Systems Inc

Spatial Problem Solving

QGIS

QGIS 3.x: Setting up a Project

· · 2 Comments

I’ve been digging through the QGIS class this week as I wrestle with a way to move the class online. While doing that I started filing in the gaps of things that I wanted to add but didn’t because of time. Well – with the class moving online I can add more things.

Usually what we do when setting up a QGIS project is:

  • Open QGIS
  • Toss a bunch of data in it
  • Save it somewhere
  • Come back to it later

So for those of you just starting out or maybe for those of you who have been working with this for a while – a helpful hint.

Open QGIS. Slow down and go to  Project -> Properties -> General. We are only going to look at 3 things in this – so don’t worry. This won’t be anything complicated.

You should see this:

qgis project properties

We’re really going to worry about two things:

QGIS project properties

When setting up a new project I always do one thing to kick off the event. I build a directory structure to start storing scripts and maps and anything of use.  I set the Project Home (above) to be that directory. I also set a working project title like “My Map” or something.

qgis working project

I also go ahead and set the Measurements. I know this project will be in a local planimetric projection so I’ll set that to None/Planimetric and since my world revolves around Feet/Square feet I’ll go ahead and set that up.

The next thing I do is set up the Coordinate system – so click on the CRS Tab on the left and set it to whatever you need it to be – in my case EPSG:2274

project properties CRS

I click Apply or OK and the last thing I do is Save my Project (back to the Save Project portion under the Project menu of QGIS) . That last save leaves you with a complete Project Properties.

Completed project properties

So who cares right?

Well if you happen to use the browser panel you’ll notice something has changed:

project home in browser

 

Project Home now appears  – which means I have quick access to everything I need from shapefiles to geopackages to imagery to whatever. Right in the browser which really gives you a ‘Workspace” feel for your project.

How long does it take to set up? Not that long but the benefits of getting that one small part done outweigh the time you’ll spend setting it up. I’ve been bitten many times by having the wrong units set up or something else that could have been taken care of by spending 1 minute setting this up.

Mobile Data Collection: Input

· ·

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:

input start screen

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.

QGIS Project Screen

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….

Input Project

 

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

One word of caution :

  1. You’re going to build a project .
  2. You’re going to COPY it to the server using Mergin.
  3. Move it to your mobile device.
  4. Edit it locally and sync it back to the server
  5. Eventually you’re going to download it back to your compute using Mergin
  6. 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?

  1. Then copy your data to your mobile device.
  2. Create a directory under the projects folder under Input and move your data there.
  3. 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

· ·

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:

  1. I join the address point to the closest road using ST_LineLocatePoint
  2. Does the closest point fit the address range on the street (double bonus I also check left and right).
  3. 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

· ·

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

· ·

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.

 

Contact