kylebarron

import geopandas as gpd
import pandas as pd
import pyarrow as pa
import pyarrow.feather as feather
import pyarrow.parquet as pq
import pygeos
import pyogrio

# https://ookla-open-data.s3.us-west-2.amazonaws.com/parquet/performance/type=mobile/year=2019/quarter=1/2019-01-01_performance_mobile_tiles.parquet

leighajarett

zacdezgeo

create table hex_r8 as (
  with envelope as (
        select st_envelope(wkb_geometry) geom from quartiers_sociologiques 
    ), h3_id as (
        select h3_polyfill(geom, 8) id from envelope
    )
    select id, st_setsrid(h3_h3index_to_geoboundary(id), 4326) geom from h3_id
  );

janbenetka

SELECT jslibs.h3.ST_GEOGPOINTFROMH3("u2ce02j")
SELECT jslibs.h3.ST_H3_BOUNDARY(jslibs.h3.ST_H3(ST_GEOGPOINT(13.377534960188237, 49.747300576525554), 11))
SELECT jslibs.h3.h3GetResolution("u2ce02j");


# lat/lon to hexagon
SELECT jslibs.h3.ST_H3(ST_GEOGPOINT(statistics.coordinate.longitude, statistics.coordinate.latitude), 10) AS dwell_hex_id,


WITH polygon AS (

270ajay

from ortools.sat.python import cp_model

''' course: https://www.coursera.org/learn/solving-algorithms-discrete-optimization#about 
About how cp works and intro to solver strategies'''



def patchingThe9HeavensProblem(): #sudoku problem
    model = cp_model.CpModel()

dougallj

# IDA (disassembler) and Hex-Rays (decompiler) plugin for Apple AMX
#
# WIP research. (This was edited to add more info after someone posted it to
# Hacker News. Click "Revisions" to see full changes.)
#
# Copyright (c) 2020 dougallj


# Based on Python port of VMX intrinsics plugin:
# Copyright (c) 2019 w4kfu - Synacktiv

Mizux

#!/usr/bin/env python3
"""Capacited Vehicles Routing Problem (CVRP).

Here we simulate a vehicle already loaded with 4 orders and on its way to deliver them
When a new order (node 5 -> 6) arrives.
"""
from ortools.constraint_solver import routing_enums_pb2
from ortools.constraint_solver import pywrapcp

def print_solution(manager, routing, solution):

Alex3917

worker_processes 1;

user nginx;
error_log  /var/log/nginx/error.log warn;
pid /var/run/nginx.pid;

events {
  worker_connections 1024; # increase if you have lots of clients
  accept_mutex off; # set to 'on' if nginx worker_processes > 1
}

Alex3917

# In .ebextensions/01_celery.config

files:
    "/etc/systemd/system/celery.service":
        mode: "000644"
        owner: celery
        group: celery  
        content: |
            [Unit]
            Description=Celery Service

wboykinm

-- Isolate building features and height attributes
WITH buildings AS (
SELECT 
  feature_type, 
  osm_id, 
  osm_timestamp, 
  ST_Centroid(geometry) AS centroid, 
  (
    SELECT 
      value