Skip to content

Instantly share code, notes, and snippets.

View Rachmanin0xFF's full-sized avatar
💭
blibbity blorp

Adam Lastowka Rachmanin0xFF

💭
blibbity blorp
View GitHub Profile

Data Validation Failures

Addresses

[2026-02-24T20:42:48.382294] === Validation Report for theme=addresses ===

type=address: 467,831,412 rows, 6 errors (0.000%)
  [unit|value:value_error]  (5)
    e.g. unit|value: Value error, String cannot have leading or trailing whitespace: '3e\t\t'
WITH city_boundaries AS (
SELECT 'Paris' as city, ST_Union_Aggr(geometry) as geometry
FROM wherobots_open_data.overture_maps_foundation.divisions_division_area
WHERE ST_GeometryType(geometry) IN ('ST_Polygon', 'ST_MultiPolygon')
AND names.primary = 'Paris'
AND region LIKE 'FR-IDF'
AND subtype = 'localadmin'
UNION ALL
import numpy as np
from scipy.stats import multivariate_normal, chi2
import matplotlib.pyplot as plt
def get_prob(mean_1, cov_1, mean_2, cov_2):
mean_diff = mean_2 - mean_1
cov_sum = cov_1 + cov_2
inv_cov_sum = np.linalg.inv(cov_sum)
D_squared = mean_diff.T @ inv_cov_sum @ mean_diff
k = len(mean_1)