geobabbler

-- public.image_embeddings definition

-- Drop table

-- DROP TABLE public.image_embeddings;

CREATE TABLE public.image_embeddings (
	id serial4 NOT NULL,
	image_path text NULL,
	embedding public.vector NULL,

geobabbler

import os
import psycopg2
import numpy as np
from PIL import Image
from scipy.spatial.distance import cosine
import torch
from torchvision import models, transforms

# Database configuration
DB_NAME = "database"

geobabbler

import os
import psycopg2
from PIL import Image
import torch
from torchvision import models, transforms

# Database configuration
DB_NAME = "database"
DB_USER = "user"
DB_PASSWORD = "password"

geobabbler

import requests
from bs4 import BeautifulSoup
import os

qry = "glacier" #wikimedia commons query
# Define the search URL
search_url = f"https://commons.wikimedia.org/w/index.php?search={qry}&title=Special:MediaSearch&go=Go&type=image"

headers = {
    "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36"

geobabbler

import pdfkit
import requests

'''
The current theme will be applied to outputs, so it is recommended to switch to a simple theme before exporting.
'''

#Generate PDF from individual post URL
def url_to_pdf(url, output_filename):
    try:

geobabbler

SELECT
  ARRAY_TO_STRING(ARRAY_AGG(CONCAT(st_x(q.loc),',',st_y(q.loc))), ';') AS coords
FROM (
  WITH
    DATA AS (
    SELECT
      loc,
      resource_id,
      wkt,
      capture_date,

geobabbler

WITH data AS (
SELECT name, loc, resource_id, wkt, capture_date, (LAG(capture_date) OVER (PARTITION BY resource_id ORDER BY capture_date ASC)) AS prev_date,
        (LAG(wkt) OVER (PARTITION BY resource_id ORDER BY capture_date ASC)) AS prev_loc
FROM
(SELECT name, resource_id, loc, st_astext(loc) as wkt, capture_date FROM `my_project.my_dataset.geo_sample`
 order by capture_date desc) q
ORDER BY capture_date
)
SELECT name, resource_id, loc, capture_date FROM data
 WHERE 

geobabbler

var PGPubsub = require('pg-pubsub');
var nodemailer = require('nodemailer');

var pubsubInstance = new PGPubsub('postgres://password:user@host:port/database'); // don't hard code this in real life. get it from a config or environment variable

var transporter = nodemailer.createTransport({
  service: 'gmail',
  auth: {
    user: "email@gmail.com", // don't hard code this in real life. get it from a config or environment variable
    pass: "complex_gmail_password" // don't hard code this in real life. get it from a config or environment variable

geobabbler

#! <?xml version="1.0" encoding="UTF-8" ?>
#! <WORKSPACE
#    Command-line to run this workspace:
#        /opt/fme-desktop-2020/fme /home/myname/jhu_counties2gpkg.fmw
#              --SourceDataset_GEOJSON "https://services1.arcgis.com/0MSEUqKaxRlEPj5g/ArcGIS/rest/services/ncov_cases_US/FeatureServer/0/query?where=1%3D1&outFields=*&f=geojson&token="
#              --DestDataset_OGCGEOPACKAGE "/home/myname/jhu_county.gpkg"
#    
#!   ATTR_TYPE_ENCODING="SDF"
#!   BEGIN_PYTHON=""
#!   BEGIN_TCL=""

geobabbler

var PGPubsub = require('pg-pubsub');

var pubsubInstance = new PGPubsub('postgres://password:user@host:5432/database');
 
pubsubInstance.addChannel('jhucounty', function (channelPayload) {
  console.log(channelPayload); 
  console.log('---------------------------------');
  console.log(JSON.stringify(channelPayload));
});