HackerTrans
トップ新着トレンドコメント過去質問紹介求人

sfkeller

no profile record

投稿

Does Kue bring true low-code to GIS analysis?

buntinglabs.com
3 ポイント·投稿者 sfkeller·2 年前·2 コメント

コメント

sfkeller
·2 年前·議論
Does the QGIS plugin "Kue" finally enable non-technical users, including students, to learn a tool like QGIS?

From the homepage: Kue can be used to edit symbology, search for datasets, add base maps, and more. It sends a limited amount of QGIS project data to the cloud for LLM processing, such as layer and attribute names. It is freemium and requires a subscription of $19, with the first month free.
sfkeller
·3 年前·議論
Try Photon as better front end to OSM.

And at least from now on, also OSM Nominatim now will "Wilsons Prom" afer I added this obvious local name: https://www.openstreetmap.org/relation/2693245
sfkeller
·3 年前·議論
Here's an implementation with lines of sql and pl/pgsql:

Given a table mytable with an pk id and say the fields 'block' and 'hash', replace it with mytable_changes and add an "internal" field called created_at of type "timestamp not null default now()".

Then create this trigger function (e.g. PostgreSQL):

  create function mytable_changes_trigger() returns trigger as $$
  begin
    if (tg_op = 'insert') then
      insert into mytable_changes (block, hash)
      values (new.block, hash);
      return new;
    if (tg_op = 'delete') then
      insert into mytable_changes (block, hash)
      values (old.block, old.hash);
      return old;
    elsif (tg_op = 'update') then
      insert into mytable_changes (block, hash)
      values (old.block, old.hash);
      return new;
    end if;
  end;
  $$ language plpgsql;
And create this trigger:

  create trigger mytable_changes
  after insert, update or delete on mytable
  for each row
  execute function mytable_changes_trigger();
What's left as an exercise is that the hash of the prev. block is being preprended.
sfkeller
·3 年前·議論
Couldn't you implement this in "pure" SQL by using psql-http https://github.com/pramsey/pgsql-http (from Crunchy ) for the webservice calls to OpenAI API?
sfkeller
·3 年前·議論
See also https://news.ycombinator.com/item?id=34684593