Revfad Blog

Category: Tech

  • SQLite blessing

    —

    by

    David Faden
    in

    Appreciating this message from the SQLite source code: May you do good and not evil.May you find forgiveness for yourself and forgive others.May you share freely, never taking more than you give. Amen!

  • A hole in Los Altos (continued)

    —

    by

    David Faden
    in

    The city clerk got back to me this morning. (Thanks much for the prompt response!) The hole in the map is also a hole in the ground — a reservoir belonging to the City of Mountain View. We happened to be in the area after checking out Tom’s Depot Cafe yesterday so I snapped a…

  • A hole in Los Altos

    —

    by

    David Faden
    in ,

    Looking at the Census page for Los Altos, something funny caught my eye: there’s a hole in the map for Los Altos: https://data.census.gov/profile/Los_Altos_city,_California?g=160XX00US0643280 Returning to the data from https://lab.data.ca.gov/dataset/california-city-boundaries-and-identifiers, we see the same thing: > library(ggplot2)> library(sf)> cities <- read_sf(“~/Downloads/California_Cities_and_Identifiers_Blue_Version_view_-6943741225906831761.gpkg”)> losAltos <- subset(cities, CDTFA_CITY == “Los Altos”)> ggplot(losAltos) + geom_sf() What’s in that hole? >…

  • What Wittier Whittier

    —

    by

    David Faden
    in

    I was really impressed to get an almost immediate reply from the CIO, GIS to my note about Whittier appearing to some extra stuff in the geometries provided here: https://lab.data.ca.gov/dataset/california-city-boundaries-and-identifiers. They pointed to the California Department of Tax and Fee Administration as the original source of the geometries, which has been updated in the meantime:…

  • California cities (continued)

    —

    by

    David Faden
    in

    Let’s get back roughly to where we were with the R session from California cities, reading in a copy of the data pulled from Wikipedia. > library(dplyr)> library(fillpattern)> library(sf)> library(ggplot2)> cities <- read_sf(“~/Downloads/California_Cities_and_Identifiers_Blue_Version_view_-6943741225906831761.gpkg”)> stats <- read.csv(url(“https://raw.githubusercontent.com/fadend/ca_cities_data/refs/heads/main/ca_cities.csv”), stringsAsFactors=FALSE) Oops. There’s some disagreement on names: > setdiff(stats$city_name, cities$city_name)[1] “Angels Camp” “California City” “City of Industry”> setdiff(cities$city_name, stats$city_name)[1]…

  • California cities

    —

    by

    David Faden
    in

    Here’s something fun: boundaries for cities in California: https://lab.data.ca.gov/dataset/california-city-boundaries-and-identifiers. Working with this in R: > library(sf)> cities <- read_sf(“~/Downloads/California_Cities_and_Identifiers_Blue_Version_view_-6943741225906831761.gpkg”) There are a few columns with the city names; “CENSUS_PLACE_NAME” and “CDTFA_CITY” (CA Department of Tax and Fee Administration?) agree so let’s just use “CDTFA_CITY” > sum(cities$CENSUS_PLACE_NAME != cities$CDTFA_CITY)[1] 0 It’s nice to see that there…

  • Hack to get DBeaver a JRE

    —

    by

    David Faden
    in

    I was happy to get DBeaver to build, following the directions at https://github.com/dbeaver/dbeaver/wiki/Build-from-sources: git clone https://github.com/dbeaver/dbeavercd dbeaver/tools./build.sh But the new app was failing to run: cd ../product/community/target/products/org.jkiss.dbeaver.core.product/macosx/cocoa/aarch64open DBeaver.app A dialog was popping up: A short term hack I found: just copy “jre” from the installed version of DBeaver: cd DBeaver.app/Contents/Eclipsecp -r /Applications/DBeaver.app/Contents/Eclipse/jre .rm -rf jre/Contents/_CodeSignaturecd…

  • Kagi puts greg.app at top for [yerba buena cat safety] also

    —

    by

    David Faden
    in

    Seeing A Three Month Review of Kagi Search on Hacker News got me curious about Kagi again. My first search, following up on a previous post looking at Google’s results for the same, was [yerba buena cat safety]. I was a little disappointed to see this: You can take a look at the Reddit post…

  • What the heck, Preview?

    —

    by

    David Faden
    in

    Occasionally, Preview gets persnickety about saving changes to images: Turning on streaming of log messages in Console, I finally got some details on it: Text from that: Other people seem to be complaining about a similar Preview issue here as well: https://discussions.apple.com/thread/255194116?sortBy=rank. From that discussion, it sounds like certain images trigger the behavior. Hovering over…

  • Chrome crashing

    —

    by

    David Faden
    in

    I’m unsure what triggered it — updating Mac OS, updating Chrome, or something else — but Chrome has started crashing for me consistently within seconds of starting up. I haven’t figured out a fix yet so I’m back to my old friend Firefox, but I did learn a few things. Crash logs go in ~/Library/Application…