Coleman McCormick

Archive of posts with tag 'GIS'

Weekend Reading: Honeycode, Imagery for Utilities, and BigQuery in Google Sheets

July 4, 2020 • #

🍯 Amazon Honeycode

AWS is making its entrance into the low-code app platform space.

🌲 Using satellite imagery to prioritize vegetation management for utilities

Geoff Zeiss on combining satellite imagery and spatial analysis to identify tree encroachment in utilities:

Transmission line inspections are essential in ensuring grid reliability and resilience. They are generally performed by manned helicopters often together with a ground crew. There are serious safety issues when inspections are conducted by helicopter. Data may be collected with cameras and analyzed to detect a variety of conditions including corrosion, evidence of flash over, cracks in cross arms, and right-of-way issues such as vegetation encroachment. in North America annual inspections are mandated by NERC and are not optional. With over 200,000 miles of high-voltage transmission lines and 5.5 million miles of distribution lines in the United States, improving the efficiency and reducing the risk of inspections would have a major impact on the reliability of the power grid.

🔌 Connected Sheets

Google Sheets now supports using BigQuery data inside of Google Sheets features like pivot tables and formulas, which means orders-of-magnitude increase in data limits.

Weekend Reading: Landgrid, Quantified Self, and Tesla Teardown

February 22, 2020 • #

🏘 Landgrid

This is a product from Loveland Technologies, with a cohesive dataset of parcel boundaries provided as an API for application builders.

More on their parcel data and how they do it here.

🤳🏽 My Quantified Self Setup

My goal tracking efforts pale in comparison to what Julian Lehr is doing. I might give a try to Airtable for mine, also. I’ve been in Google Sheets since mine’s pretty basic, but AT might make it more mobile-friendly for editing.

🚗 Tesla teardown finds electronics 6 years ahead of Toyota and VW

What stands out most is Tesla’s integrated central control unit, or “full self-driving computer.” Also known as Hardware 3, this little piece of tech is the company’s biggest weapon in the burgeoning EV market. It could end the auto industry supply chain as we know it.

One stunned engineer from a major Japanese automaker examined the computer and declared, “We cannot do it.”

Weekend Reading: Terrain Mesh, Designing on a Deadline, and Bookshelves

August 17, 2019 • #

🏔 MARTINI: Real-Time RTIN Terrain Mesh

Some cool work from Vladimir Agafonkin on a library for RTIN mesh generation, with an interactive notebook to experiment with it on Observable:

An RTIN mesh consists of only right-angle triangles, which makes it less precise than Delaunay-based TIN meshes, requiring more triangles to approximate the same surface. But RTIN has two significant advantages:

  1. The algorithm generates a hierarchy of all approximations of varying precisions — after running it once, you can quickly retrieve a mesh for any given level of detail.
  2. It’s very fast, making it viable for client-side meshing from raster terrain tiles. Surprisingly, I haven’t found any prior attempts to do it in the browser.

👨🏽‍🎨 Design on a Deadline: How Notion Pulled Itself Back from the Brink of Failure

This is an interesting piece on the Figma blog about Notion and their design process in getting the v1 off the ground a few years ago. I’ve been using Notion for a while and can attest to the craftsmanship in design and user experience. All the effort put in and iterated on really shows in how fluid the whole app feels.

📚 Patrick Collison’s Bookshelf

I’m always a sucker for a curated list of reading recommendations. This one’s from Stripe founder Patrick Collison, who seems to share a lot my interests and curiosities.

Discovering QGIS

May 29, 2019 • #

This week we’ve had Kurt Menke in the office (of Bird’s Eye View GIS) providing a guided training workshop for QGIS, the canonical open source GIS suite.

It’s been a great first two days covering a wide range of topics from his book titled Discovering QGIS 3.

The team attending the workshop is a diverse group with varied backgrounds. Most are GIS professionals using this as a means to get a comprehensive overview of the basics of “what’s in the box” on QGIS. All of the GIS folks have the requisite background using Esri tools throughout their training, but some of us that have been playing in the FOSS4G space for longer have been exposed to and used QGIS for years for getting work done. We’ve also got a half dozen folks in the session from our dev team that know their way around Ruby and Python, but don’t have any formal GIS training in their background. This is a great way to get folks exposure to the core principles and technology in the GIS professional’s toolkit.

Kurt’s course is an excellent overview that covers the ins and outs of using QGIS for geoprocessing and analysis, and touches on lots of the essentials of GIS (the discipline) and along the way. All of your basics are in there — clips / unions / intersects and other geoprocesses, data management, editing, attribute calculations (with some advanced expression-based stuff), joins and relates, and a deep dive on all of the powerful symbology and labeling engines built into QGIS these days1.

The last segment of the workshop is going to cover movement data with the Time Manager extension and some other visualization techniques.

  1. Hat tip to Niall Dawson of North Road Geographics (as well as the rest of the contributor community) for all of the amazing development that’s gone into the 3.x release of QGIS! 

Weekend Reading: Fulcrum in Santa Barbara, Point Clouds, Building Footprints

February 2, 2019 • #

👨🏽‍🚒 Santa Barbara County Evac with Fulcrum Community

Our friends over at the Santa Barbara County Sheriff have been using a deployment of Fulcrum Community over the last month to log and track evacuations for flooding and debris flow risk throughout the county. They’ve deployed over 100 volunteers so far to go door-to-door and help residents evacuate safely. In their initial pilot they visited 1,500 residents. With this platform the County can monitor progress in real-time and maximize their resources to the areas that need the most attention.

“This app not only tremendously increase the accountability of our door-to-door notifications but also gave us a real time tracking on the progress of our teams. We believe it also reduced the time it has historically taken to complete such evacuation notices.”

This is exactly what we’re building Community to do: to help enable groups to collaborate and share field information rapidly for coordination, publish information to the public, and gather quantities of data through citizens and volunteers they couldn’t get on their own.

☁️ USGS 3DEP LiDAR Point Clouds Dataset

From Howard Butler is this amazing public dataset of LiDAR data from the USGS 3D Elevation Program. There’s an interactive version here where you can browse what’s available. Using this WebGL-based viewer you can even pan and zoom around in the point clouds. More info here in the open on GitHub.

🏢 US Building Footprints

Microsoft published this dataset of computer-generated building footprints, 125 million in all. Pretty incredible considering how much labor it’d take to produce with manual digitizing.

24 Days of QGIS

December 23, 2018 • #

Each year GIS developer and cartographer Nyall Dawson puts together a thread of daily tweets leading up to Christmas, each with a helpful tip for QGIS. You can see all of them at the hashtag #24daysofqgis.

Here are a few of my favorites:

Weekend Reading: Geocomputation, Customers, and Linear Growth

October 13, 2018 • #

🎛 Geocomputation with R

I’ve had R on my list for a long time to dig deeper with. A while back I set myself up with RStudio and went through some DataCamp stuff. This online book seems like excellent material in how to apply R to geostatistics.

☎️ Listening to Customers At Scale

Given where we are with Fulcrum in the product lifecycle, this rang very familiar on the struggles with how to listen to customers effectively, who to listen to, and how to absorb or deflect ideas. Once you get past product-market fit, the same tight connection between your customers and product team becomes impossible. Glad to hear we aren’t alone in our struggles here.

📈 Linear Growth Companies

This piece from David Heinemeier Hansson is a good reminder that steady, linear growth is still great performance for a business. Every business puts itself in a different situation, and certainly many are in debt or investment positions that linear growth isn’t good enough for. Even so, consistent growth in the positive direction should always be commended.