ranchodeluxe

import fs from 'fs';
import OpenAI from 'openai';

const openaiClient = new OpenAI({
  apiKey: process.env.OPENAI_API_KEY,
});

const main = async () => {
  // Get filename from command line arguments
  const args = process.argv.slice(2);

ranchodeluxe

{                                                                                                                                                                                                                                                                             
  "id": "97994",                                                                                                                                                                                                                                                              
  "name": "GFCI Outlets",                                                              
  "description": "Task to inspect or replace GFCI outlets at the property.",                                                                                                   
  "category": "electrical",                                                            
  "contractorType": "electrician",                                                                                                

ranchodeluxe

from postal.expand import expand_address
import sys
import xxhash
import math
import pprint
import pandas as pd
from sqlalchemy import create_engine, text
from datetime import datetime, timedelta

DATABASE_URI = "postgresql://kaiizenadmin:[email protected]/kaiizen"

ranchodeluxe

from postal.expand import expand_address
import sys
import xxhash
import pandas as pd
from sqlalchemy import create_engine, text
from datetime import datetime, timedelta

DATABASE_URI = "postgresql://kaiizenadmin:[email protected]/kaiizen"
engine = create_engine(DATABASE_URI)

ranchodeluxe

from postal.expand import expand_address
import xxhash
from sqlalchemy import create_engine
import pandas as pd
import sys

DATABASE_URI = "postgresql://kaiizenadmin:[email protected]/kaiizen"
engine = create_engine(DATABASE_URI)

ranchodeluxe

          addr          | cherre_properties_current_pk |    pk     
------------------------+------------------------------+-----------
 9708 NW 86TH TER       |          6254075447118810691 | 317232748
 1840 QUEENS MEADOW LN  |         -3759370953727434638 | 411670888
 2 ARIANA DR            |         -8100103611089870304 | 504686232
 125 SPRINGFIELD CT     |            21506068986401567 | 155389880
 23 TERRACE PL          |          6191829075971316516 | 504233524
 2500 WOODFIELD WAY     |         -4593649634119494027 | 544301740
 7911 FOREST FLAME      |          4530592079101629405 | 503017212
 1451 DANIEL LN         |         -4478937597315041628 | 158381596

ranchodeluxe

{
    "cherre_properties_current_pk": -8001908294576819000,
    "arms_length_code": "Arms length transaction",
    "assessed_tax_year": 2023,
    "assessed_value_improvements": 18400,
    "assessed_value_land": 2800,
    "assessed_value_total": 21200,
    "basement_finished_sqft": null,
    "basement_sqft": null,
    "cherre_is_flip": false,

ranchodeluxe

d9d88ca43c44','level':'Error','levelId':4,'processId':28,'exceptionDetails':'Microsoft.Azure.WebJobs.Host.FunctionInvocationException : Exception while executing function: Functions.HrrrStactoolsCollection ---> Microsoft.Azure.WebJobs.Script.Workers.Rpc.RpcException : Result: Failure\nException: RuntimeError: Cannot find the ecCodes library\nStack:   File \'/azure-functions-host/workers/python/3.11/LINUX/X64/azure_functions_worker/dispatcher.py\', line 604, in _handle__invocation_request\n    call_result = await self._loop.run_in_executor(\n                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \'/usr/local/lib/python3.11/concurrent/futures/thread.py\', line 58, in run\n    result = self.fn(*self.args, **self.kwargs)\n             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \'/azure-functions-host/workers/python/3.11/LINUX/X64/azure_functions_worker/dispatcher.py\', line 933, in _run_sync_func\n    return ExtensionManager.get_sync_invocation_wrapper(context,\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

ranchodeluxe

import os
import pytest
import s3fs
import fsspec
import pickle
from multiprocessing import Process, Queue

fs = fsspec.filesystem('local')

ranchodeluxe

Thread 9160 (idle): "MainThread"
    wait (threading.py:331)
    _wait_once (grpc/_common.py:116)
    wait (grpc/_common.py:156)
    _next (grpc/_channel.py:959)
    __next__ (grpc/_channel.py:542)
    run (apache_beam/runners/worker/sdk_worker.py:262)
    main (apache_beam/runners/worker/sdk_worker_main.py:212)
    <module> (apache_beam/runners/worker/sdk_worker_main.py:367)
    _run_code (<frozen runpy>:88)