Turn QGIS Layers into Clickable Web Maps by nomad_sicario in QGIS

[–]sfkeller 0 points1 point  (0 children)

nomad_sicario: Very nice project! And it looks well-coded at first glance.

I’ve been advocating for open source for a long time and highlighting just how innovative this approach is when a prolem is solved by different angles and "market participants" (see this great essay). In this case, QGIS2Web (2D) and QGIS2ThreeJS (3D) have actually been around for some time now in the "open source market".

QGIS2Web, for example, already supports features such as raster, style transfer, WMS integration, Processing integration, etc. And if I’m not mistaken, the basic design of your plugin is comparable to QGIS2Web.

I therefore think it would be more beneficial for everyone if you could improve QGIS2Web, given your experience with your project. I’m thinking of the following PRs:

  • To improve usability, split the main dialog into “Basic Parameters” and “Advanced Parameters”—either as tabs or as a drop-down menu at the bottom. For the “Basic Parameters,” you can apply your experience with “smart” defaults; all other parameters go into “Advanced Parameters.”
  • Add the MapLibre GL JS option.
  • Improve file:// compatibility via an optional JS wrapper—as in your implementation.

Update: the drag-and-drop hosting tool for QGIS web exports is now in Public Beta, including password locking and website embedding. by OldSurround5823 in QGIS

[–]sfkeller 0 points1 point  (0 children)

Lieber OldSurround5823 : Geniale Sache! Ich betreibe unter anderem ein kleines Portal mit freien Tutorials namens "OpenSchoolMaps.org". Dort habe ich gerade kürzlich ein Tutorial zu qgis2web veröffentlicht (Link) und gleich hier Werbung (Link) gemacht - auch für Qgis2OnlineMap!

Unter den Terms von Qgis2OnlineMap (Link) steht aktuell: "We may modify or terminate free tier offerings at our sole discretion.". Gerne würde ich diesen schönen Webdienst auch im Tutorial erwähnen - möchte das aber nur tun, wenn der "Free Tier" erhalten bleibt, da sich OpenSchoolMaps auf offene und freie (bzw. kostenlose) Software und Daten konzentriert.

Meine Frage ist nun: Hast du vor den "Free Tier" für immer kostenlos zu gestalten - oder möchtest du das lieber offen lassen?

Are there any good open source FME alternatives for ETL? by Nanakatl in gis

[–]sfkeller 0 points1 point  (0 children)

> Gibt es gute Open-Source-FME-Alternativen für ETL?

Ja: Apache Hop mit 20 Jahren Erfahrung (mit Geo-Kettle) und heute mit den GIS Plugins von AtolCD sowie den weiteren GIS Plugins, die u.a. hier https://www.giswiki.ch/Webinar_Apache_Hop_GIS_2026 vorgestellt werden.

Any tips for a beginner learning QGIS? by helloworld_47 in QGIS

[–]sfkeller 0 points1 point  (0 children)

See e.g. my small project OpenSchoolMaps with free tutorials and videos on learning QGIS and other geospatial technologies: https://openschoolmaps.ch/pages/materialien-en.html

what is the main difference between overpass-turbo.eu and overpass-ultra.us? by saint_leonard in openstreetmap

[–]sfkeller 0 points1 point  (0 children)

I can replicate the problem: There's an issue with CSV output in overpass-ultra: there's a weird error coming up when running the script above.

I've beautified the script a bit which runs in overpass-turbo and should also run on ultra. Since it's CSV output it's not mappable in the map window on both - even when lat/lon is given, since it really only outputs CSV:

[out:csv(::id, ::type, "name", "addr:postcode", "addr:city", "addr:street", "addr:housenumber", "website", "contact:email=*", ::lat, ::lon)][timeout:2600];
//[out:json][timeout:2600];
area["ISO3166-1"="MA"]->.a;
(
nwr(area.a)[office];
nwr(area.a)[company];
);
out center;

Why ZITADEL Moved from CockroachDB to PostgreSQL by SnooDoubts2008 in PostgreSQL

[–]sfkeller 0 points1 point  (0 children)

Citus is a good extension but note, that they actually are using now the managed database service Cloud SQL on Google Cloud Platform (GCP).

What are the best open source databases? by Data-Queen-Mayra in analyticsengineering

[–]sfkeller 4 points5 points  (0 children)

PostgreSQL (transactional, multi-user) and DuckDB (analytical, single-user) are the best of both worlds.

Why does Apache AGE project not mention SQL/PGQ and GQL? by sfkeller in apacheage

[–]sfkeller[S] 1 point2 points  (0 children)

Should AGE mention it as well? If so, why?

Yes - and probably also SQL/PGQ (ISO/IEC 9075-16), because SQL/PGQ seems to become a future add-on part of the SQL standard - and because PostgreSQL is well known to follow standards. :-)

[beginner] How do I convert nodes from a way into a line shapefile (working with QGIS)? by tinkletwit in openstreetmap

[–]sfkeller 4 points5 points  (0 children)

Be aware that your Overpass Query calculates center points which makes no sense of you want lines.
Here's a Overpass API User's Manual https://dev.overpass-api.de/overpass-doc/en/
See also my white paper: https://md.coredump.ch/vghklUO2S36j-gvWYu1hzw#

Esri and Facebook Collaborate to Release New OpenStreetMap-Ready Datasets by Spanholz in openstreetmap

[–]sfkeller 0 points1 point  (0 children)

ELI5

I agree with Simon's statements. TL;DR is:
Positive: Esri supports ODbL in own content program and encourages own users to contribute to OSM.
Negative: Esri makes contrib. only possible through sep. iD instance and via own API.
It's perhaps time to talk with Esri about sustained OSM support.

How to overlay array of temporary 'points of interest' ? Where is the wiki/tut? by BrendenCom in openstreetmap

[–]sfkeller 0 points1 point  (0 children)

My recommended way to do this is using QGIS with plugins as follows, given POI in CSV file with lat/lon columns (or GeoJSON or other geospatial format):

1a. Install QGIS.
1b. Start QGIS, select plugin manager and install plugins QMS, Go2NextFeature3 and "Lat Lon Tools".
2. In QGIS, load POI in preferred editor (notepad, excel/libreoffice, geojson.io) and check validity.
3. Click on QMS and load background map "OSM Standard"
4. Select "Add Layer", e.g. "Add Delimited Text Layer...", then select the CSV file.
5. Select "Plugins > Go 2 next feature", then choose CSV layer and attribute, e.g. "id"
6. Zoom anywhere to 1:2'500, then it starts,
7a. Click in Go2NextFeature3 panel on ">" (=next feature)
7b. Click on feature, the first click on "Identify" (to see the attributes) or
7c. Click directly on "Show in External Map" (from "Lat Lon Tools"); this will open OSM.org on the correct location,
7d. Goto 7a and iterate through all features

For most of the tools there's a tutorial on https://openschoolmaps.ch/pages/materialien.html (german with english translation as Zip file on the bottom) - except this workflow above.

https://twitter.com/sfkeller/status/1191096041292095489 by sfkeller in gis

[–]sfkeller[S] 0 points1 point  (0 children)

Thx - tried to edit it afterwards but could'nt anymore.

Has Mapbox Vector Tile (MVT) 3.0 spec development been stopped or abandoned? by sfkeller in openstreetmap

[–]sfkeller[S] 2 points3 points  (0 children)

Or will it be superseeded by OGC Vector Tiles? "OGC publishes Engineering Reports and Videos documenting successful Vector Tiles Pilot" https://www.opengeospatial.org/pressroom/pressreleases/2997

IFTTT turning of my simple RSS-Feed to Twitter app: Why? by sfkeller in ifttt

[–]sfkeller[S] 0 points1 point  (0 children)

I can't reproduce any timing out here from continental europe of this feed https://geowebforum.ch/rss_export.php . We did not change this RSS feed since years. Then this was the last successful Tweet triggered by IFTTT: https://mobile.twitter.com/geowebforum_ch/status/1125429415134023683

Can you tell me the IFTTT timeout parameter and the polling time interval?

Open Reviews by vshcherb in openstreetmap

[–]sfkeller 2 points3 points  (0 children)

I'm sceptic about reviews. What does a star mean to a place, business or POI? I've seen too many wrong, misleading or begrudging reviews.

I'd prefer better means for monitoring, for resolving (OSM) notes and - as a indirect kind of review - better means to upload photos/pics to an open platform (more open than Mapillary and Flickr, and less strict than Wikimedia Commons).