Help! My TRIRIGA GIS Query isn’t working

TRIRIGA/MREF GIS Queries must Include GIS Latitude and Longitude and these must be labeled “Latitude” and “Longtitude.”

This is a quick note in case anyone is struggling with the same problem I encountered caused today.

Here’s the scenario.

  1. You’ve got a GIS portal section in TRIRIGA/MREF.
  2. You’ve created the GIS Map record that powers the section.
  3. You’ve set up the extent, configured your basemap(s), connected to one or more data sources for layers.
  4. You’ve created a “GIS Query” record to display TRIRIGA data on the map.

For most of you, it probably just works. Congratulations! If you’re a grug brain like me, though, read on.

No matter what you do, the map doesn’t work! It’s so broken, in fact, that the portal is unstable and your browser reports that the page is unresponsive.

If that’s you, what now?

The TRIRIGA documentation says it plainly enough: “Queries must include display columns that are labeled Longitude and Latitude. The Latitude and Longitude fields pinpoint the item on the map.”

After spending a couple hours today troubleshooting a GIS query, let me make it even more plain.

  • Make sure your query includes the Location Business Object and (of course) the correct association string.
  • Add the triGisLatitude and triGisLongitude fields from the Location BO to the query.
  • Label these fields Latitude and Longitude. This step is important! The fields are called “GIS Latitude” and “GIS Longitude” on the BO, and that won’t work.

Save the query, reload the portal, and voila!

Now I must confess what I did. Learn from grug.

grug see GIS query has longitude and latitude but TRIRIGA locations have no latitude and longitude data

this bad — it mean no TRIRIGA points on map

grug see GIS layer from ESRI includes ID

grug think user need way to open TRIRIGA record when they see something interesting on map

grug see “Show Table” on map viewer and see that records can be opened from the table

grug get idea

maybe user click on “Show Table,” find what they need with ID, and open record that way

this not great, but only option

grug change query to show data shown on GIS layer

grug think user no longer need latitude and longitude on query because these always blank

grug delete latitude and longitude from query because efficiency good

now portal no work and browser mad at grug when page load

grug try fix many ways until stop and eat lunch

maybe read documentation will help, grug think, but it only help a little

after few more tries, grug find answer and then write answer here

If this helped you, hello from the past! If you’re inclined, leave me a comment.

Ask and ye shall receive

lol

I know chatbots aim to please, but this was not on my AI bingo card.

Read the rest here.

How many of these emergent problems will have to be solved before the product is secure? And even if we could think of everything, how many entirely new problems are these tools creating which will, in turn, also have to be solved?

[Edit: I finished reading the rest of the post, which I’ve just linked again, and holy shit.]

Dreamtime in Real-Time

Watching people ask ChatGPT questions about technical matters for which I am a sort of expert and then presenting the hallucinations back to me as facts in real-time is a lot of fun. Does this happen to you?

I lifted the quote below from this bruising and well-deserved critique of GPT-5. The author of that post takes it from the original tweet here.

With LLMs it’s always the same problem. They don’t know the answer; they just know how to run an input sequence through complicated functions that predict the next word in an output sequence. The quote below from this excellent article puts it much better than I can.

Watch it go

Facebook has been a bad product since the introduction of the News Feed, but the switching costs have always been high and it was optimized by some of the best engineers our universities could produce for stickiness. The dual onslaught of Groups, which incentivize low effort/high engagement content, and AI junk, which sometimes checks both of those boxes just right, makes it an even worse product.

It’s still sticky, because we’re all still here, but will that last? Will it last when most of the posts I see give me zero value? Will it last when groups, which are weighted so heavily in the feed, are cesspools of AI-generated nonsense? I hope not. I hope a product manager at Meta is losing sleep over this problem tonight.

This is happening to the whole Internet, though. AI slop is already filling up web pages and discussion forums. Reddit will succumb to it because upvotes are the metric. Comments sections were already astroturfed; now the astroturfers will just cut out the humans sitting in the phone farm. I just had a meeting today where one of the topics was using AI to generate blog posts. There’s no turning back from this garbage because the incentives to use it are so high, and the bill for that convenience won’t become due until the entire Internet is consumed by it.

I printed (and web published) a ‘zine because I believe print is going to make a comeback very soon. By its very nature, print defies the logic of machine generation. We need analog back. The digital ocean is polluted.

Email is Wrong

No matter what you do, odds are that a significant amount of your time doing it is spent answering emails. That is certainly true for me. Email is a unifying thread across my professional and creative life. It directs the course of my days at work and my nights playing music and making art. As a result, it is the first thing I check in the morning, the most important part of my workday during the week, and one of the last things I look at before I go to sleep at night. Everyone I know is in the same situation.

A literal mountain of emails. Image produced by Microsoft Copilot.

It’s too bad, then, that email is all wrong. Though email is such an important part of my day, none of the email tools I’ve tried offer any of the things that I need to respond thoughtfully and keep myself organized. Email web apps limit you to accounts provided by that host or require you to do a bunch of weird setup to look at other accounts. That’s before looking at any of the tools these providers offer. Thunderbird is stuck trying to emulate the way Outlook worked in 2007. Outlook—the default, required client for most users—offers notes, tasks, folders, reminders, rules, and integrations to other Office software, but at the end of the day every email that flows into the application looks and feels the same, and every important tool exists somewhere else on the reader’s machine. It’s up to the reader to categorize, prioritize, leverage the right tools, and follow-up on their messages. Most readers are OK with that responsibility, but the sheer volume of email we have to deal with everyday can make it difficult to faithfully execute this responsibility.

Here are the main problems as I see them:

  • Every email in every client looks and feels the same by default
  • “Reading” is the objective. For many users, when an email is “read,” it is filed away for further action in the same pile with things that don’t need action. Important items can fall through the cracks unless the user deploys some secondary processing method. These methods vary widely by user but may include flags, folders, tasks, changing the status back to unread, or (more likely, I suspect) some combination of everything the interface offers in a desperate bid to stay on top of it all.
  • Every item must be read in order to be processed. See above.
  • All of the most important tools—word processors, spreadsheets, web searches, IM clients, checklists, and so on—exist somewhere else. There is no connection between an email which triggered a process and the tools needed to complete it.
  • This is also true in the archival sense. Often an email and its attachments are the only evidence of work done. These are only the most superficial products of deeper processes which are documented on both local and remote file systems.

Lately I’ve been thinking about a different kind of email tool. I’d like to have an app where I can build process templates and drag emails to “anchors” for those processes. Dragging an email to the app would create an action item, and the process anchor would follow rules to provide the specific tools needed to complete the item.

Let’s say you have a standard process you typically need to support from email. For example, for several years my job looked like this:

  • Receive an email with an assignment
  • Create a folder on a filesystem on the enterprise network
  • Populate this folder with certain templates
  • Collect information from the internet and other emails
  • Use this information to complete the templates in the folder
  • Submit a link to the folder to a reviewer
  • Revise items based on the reviewer’s comments
  • Send approved items to a customer
  • Archive work products in an online repository

In my platonic email app, I would drag the assignment email to a process anchor in the app. This process anchor would increment an action item counter and then follow a rule to create the folder, populate it with templates, provide a list of links to the places where I need to gather information, give me the ability to open the template documents and work them right from the application, automatically send a message to the approver when I’m ready, automatically email the customer, and then pop a link to the repository upload (or, in an even more perfect world, use an API to upload the work products). After completing the process, the action item counter would decrement.

Each action item associated to the anchor would have its own workspace, which would include other tools like a notepad and calculator. Similar anchors would exist for other processes configured by the user, surfacing different tools and following different processes set in advance. These processes would be configured with natural language rules, like Monday.com automations.

Anyway, I doubt I’ll ever have the time to build this tool, but I’m always looking for it. In the meantime, maybe just writing out the ways that I think email is wrong will help me be more thoughtful about how to make it right with the tools I already have.

Computers should be bicycles for the mind, but with email we are trudging through confusion.

Old Disks and Old Metaphors

Call it a passion project. The past few days in my spare time at work I’ve been recovering data from twenty-five and thirty-year old floppy disks. The files on these old disks—CAD drawings, meeting minutes, reports, and other construction-related documents structured in 1.44 MB or smaller bundles—are interminably boring, but there is something intellectually thrilling in the process of accessing and reviewing them. I’ve been thinking of this as an archival thrill, similar in the little raised neurons it tickles to the feeling I get when chasing leads in old newspapers or digging through a box of original documents in search of names, clues, faces. Entire careers have come and gone since these files were copied to the magnetic circles in their little plastic cases. Whole computing paradigms have risen and fallen in that time, and, with them, our own sense of technical superiority to the people who authored these files. Still, the same meticulous attention to detail is evident in the files, the same sense of their own sophistication on the part of the authors, the same workaday problems we are solving today.

Working the files, I noticed two more things:

  1. The sound of a physical device reading data is special, and it can be deeply satisfying. I had forgotten the audible experience of computing—the whining, clicking, tapping, and whirring which used to characterize the entire experience. All of this is gone now, replaced by the sterile sound of fans, maybe, like wind blowing over a dried lakebed. There are audible affordances in physical media. When the sound stops, for example, the transfer is finished. When the button clicks on a cassette tape, the experience is complete.
  2. The old files on these disks are authored with maximum efficiency in mind. With only a few hundred KBs to work with, designers had to get creative in ways we don’t today. There are a lot of pointillistic graphics, tiny GIFS, plaintext, line drawings; none of the giant, full-resolution graphics we include everywhere today.

One of the disks contains a full website, preserved like a museum piece from 1999. Clicking around those old pages got me thinking about the archival thrill of the old internet.

Consider the way that the most prominent metaphors of the web have shifted over time.

It used to be that people would surf information on the internet, riding a flow state wave across documents and domains in pursuit of greater knowledge, entertaining tidbits, or occult truths previously hidden in books, microfilm, periodicals, letters, and other texts. The oceanic internet held out the sort of thrill you feel when wandering among the stacks of a vast library or perusing the Sufi bookstalls of old Timbuktu. It was an archival thrill, tinged with participatory mystique, abounding with secrets.

In the heady days of the early web, to surf was to thrill in the freedom of information itself.

When Google arrived on the scene and began its ongoing project of organizing the information on the web, feeding took the place of surfing. This act, like every triumph of industrial capital, relied first upon the extraction of surplus value from the laborers who produced the commodity—i.e., the authors of the information. That is a subject for another day. More to my point in today’s rumination, however, Google’s revolutionary commodification of the web also took advantage of the customer’s innate narcissism. You have specific and important information needs, Google says with its design language, which this text bar can satisfy.

Google delivered on this promise by surfing the web on behalf of searchers. To deploy another (very stretched) oceanic metaphor, Google turned surfers into consumers of tuna fish. Each search serves up a little can of tuna. Enter a term in the box and out pops a little tin; pop the can and get what you need, increasingly on the first page; and then get on with Your Busy Life.

The Your Busy Life warrant is the play on narcissism. You don’t have time to surf, it says, because you are important. Have this can of tuna instead.

I love tuna. I search every day. Google was so successful, however, that the web wrapped itself around the tuna-dispensing search box. By the mid-2000s, users no longer used search primarily as an entry point to the waves but, rather, as a sort of information vending machine serving up content from Google’s trusted searches.

Beginning around 2008, feeding completely overtook surfing as the dominant user metaphor of the web. As Infinite-scroll apps on smartphones took the place of websites, the purveyors of these apps took it upon themselves to predict what users would like to know, see, or do. To this end, the most talented software engineers in the world have spent more than two decades now building algorithms designed to settle users in a stationary location and serve them little morsels of information on an infinite conveyor belt. Cans of tuna became Kibbles and Bytes, piece by piece, scrolling past.

The participatory mystique, or archival thrill, as I have called it, has been almost completely displaced by this dull feedlot experience. I know that the old experience of the web exists alongside the new, that I could go surfing right now if the urge carried me away, but I lament that so many of the people who could be building more and better websites are building cans of tuna for the Google vending machine on the web or Kibbles and Bytes for the apps.

Think of what we could have.

For Digital Immersion

I have just finished Will Blythe’s searching essay on the future (and present) of literary fiction at Esquire. I’ll let Blythe’s argument stand for itself, but to briefly recap: the web, and the devices we use to access it, are radically splintering attention spans. This has already dramatically reduced the viability of literary fiction in traditional venues, he argues, but may spell serious trouble for the future of the literary novel, as well. It’s a powerful, sobering essay. I have thought and written at some length about digital tools, reading, and distraction in these pages, and I largely agree with Blythe on the impossibility of serious, focused thought in our current technological paradigm. I don’t have anything new to say on the subject of distraction, but I did have some thoughts about technology while reading the essay.

When we say “Technology” in 2023, for most people that means smartphones and apps.

This is not just how things worked out. It doesn’t have to be this way. Technology can foster immersive experiences as well as it can splinter attention spans. Technology can contribute to a flowering of literary fiction as readily as it can spell its demise. Technology could give us more literary fiction, more genre fiction, more historiography and literary criticism, more poetry, more everything, as well as extremely powerful tools to annotate, index, summarize, and recall all of these texts.

In fact, technology has given us all of these things. Take a spin around the listings of online literary journals at Duotrope. Look at the insane library of classic literature, periodicals, and texts of all kinds at Project Gutenberg or the Internet Archive. If you are an inveterate notebook-keeper, like me, look at Joplin or OneNote (just not Evernote any more, after recent changes, including a massive price hike). Or just take a look at Notepad and a filesystem. If you take notes specifically around books and articles, and need to build bibliographies, check out Zotero. Need an immersive word processor? Check out FocusWriter. I could keep going, but the point is hopefully clear by now: technology feels hopeless and limiting because our definition of technology is too narrow. One need not look far beyond the confines of iMessage or Twitter X to see that technology has radically exceeded the promise of the “Information Superhighway.”

The smartphone is not the best tool for immersive reading, thinking, and working–but not, necessarily, because of some logic inherent to the form. Smartphones are platforms for apps, and the most popular apps steal their users’ attention because that is what they have been designed to do. Take away the distraction-inducing apps, and you would take away the distraction. But which apps are you willing to delete? The makers of these apps know that attention and relationships are more powerful and pleasurable inducements to action than pretty much anything else in the world–right up there with nicotine, sugar, and opium–and using that fact to drive traffic to their apps is how they make their living. They won’t stop doing it until the demand goes away.

Here are some ways to start reducing that demand.

For Users:

  1. Turn off app notifications on your phone for everything except phone and messaging.
  2. Remove all but the most essential apps from your home screen. If you need to open an app, search for it. Bonus: if you keep notifications enabled, you won’t see badges on the app icons to draw you in.
  3. Instead of replying to messages throughout the day, set aside an hour or so for focused correspondence. You can use this time to write emails, check your DMs, or whatever. Let the messages pile up otherwise. In my experience, people understand after a very short time that you will respond later.

It falls upon those of us who build technology and care deeply about attention and immersion to build experiences that foster attention and thought. For developers, then, two quick thoughts:

  1. Resist user notifications at all costs. If your company uses notifications to drive engagement growth and sales, rather than meet legitimate business needs for the user, you work at the wrong place.
  2. Declutter the interface of dynamic elements, like popup hints and user nudges. Clutter it with tools instead. The interface of LibreOffice Writer affords a great example of this principle. Some would call it ugly, and they would be right. I believe it is ugly in the way that a well-used workbench is ugly, however. This is a happy, focused place for those who thrive among their tools. (You might think this doesn’t work well for smartphone apps, but look at how much dynamic garbage Meta crams onto the Facebook app screen. It works.)

Let’s broaden our definition of “technology” beyond smartphones and apps, and then use what we find in that land beyond to make apps on smartphones better. If we do that, much more than literary fiction is sure to benefit.

Social Media is Dead

Facebook feels like MySpace in 2008. Twitter is in a death spiral. Reddit alienated everyone. Mastodon is a navel-gazing wasteland. Threads is a graveyard of branded content and hustleporn.

Social media is circling a cul-de-sac at the end of the 2010s and everyone there is just waiting now for the Next Thing™️ to come along.

Even in the lifetime of most millennials, social media at the height of its social and cultural power existed for an extremely brief moment — maybe fifteen years — but we have acted as though it will always be with us. The Next Thing™️ will not be a Twitter replacement, however. I believe that it will look more like the time before: websites again, like this one; IM clients; chat rooms; and web rings (or federation, if you will).

The idea that we should share everything with everyone by handing it all over to a handful of powerful corporations to manage has been weird and probably wrong since the beginning. Let’s take this opportunity to build the web the way it was meant to be, instead: fiercely autonomous, deeply personal, and delightfully eclectic.