It has been a while. I’ve had a running project in PostGIS now that is 4 years old. It ends this month. It spent 3 years as a shapefile and one year as a File Based Geodatabase before I decided to “learn hos this postgis thing works”. Having a running project last for that long is a bit rare on my end. With that ending other things are starting up which is nice – because I tend to seek out a comfortable routine and don’t push myself.
Flash forward to this month’s fun. Sixty one columns and 22,000 something points. Not that insane – but editing is a bit of a chore. AS you’ve got 61 columns of stuff. Do they edit all 61 columns? No.

I did the new standard routine of loading QGIS/PostGIS/Geoserver/Fulcrum and we were off and running. As it turns out it had been a while since they had edited and the backlog was filling up.
Part of the fun of a new client is learning their processes. One the first things we did is start editing data. This can be a bit unnerving for new users:

You get all 61 columns in one menu upon adding new data. The cool thing with QGIS is there’s a good way to reduce the choices using the tools you’re provided. If you right click the layer in the Layers Panel and go to Properties and then to Attributes form you’ll notice at the very top you’ve got three choices. The first being just use the default. The second would be the drag and drop designer. You can remove the things you don’t need to edit. So just start clicking that minus button on the form layout. Yes I just randomly removed a bunch of stuff as an example.

You can now edit things with a little bit less confusion.
So now when you add a point:

BUT…..What if you want a less confusing menu for editing? YOU SAID THREE CHOICES FOR MENUS AND YOU ONLY MENTIONED TWO. Part 2 is coming…..WHY DIDN’T I INCLUDE IT NOW? Well….my posts are too long as is…..




