Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
marklit
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
16 ms
·
241.
▲
AI on Street View
(tech.marksblogg.com)
2 points
by
marklit
2y ago
|
0 comments
242.
▲
Microsoft's 1.4B Global ML Building Footprints
(tech.marksblogg.com)
3 points
by
marklit
2y ago
|
0 comments
243.
▲
Microsoft's 1.4B Global ML Building Footprints
(tech.marksblogg.com)
4 points
by
marklit
2y ago
|
0 comments
244.
▲
ICEYE's Satellite Imagery
(tech.marksblogg.com)
1 points
by
marklit
2y ago
|
0 comments
245.
▲
ICEYE's Satellite Imagery
(tech.marksblogg.com)
1 points
by
marklit
2y ago
|
0 comments
246.
▲
ICEYE's Satellite Imagery
(tech.marksblogg.com)
3 points
by
marklit
2y ago
|
0 comments
247.
▲
ICEYE's Satellite Imagery
(tech.marksblogg.com)
1 points
by
marklit
2y ago
|
0 comments
248.
▲
by
marklit
2y ago
OSM doesn't have the same metadata as this project.
249.
▲
Global EV Charging Points with Open Charge Map
(tech.marksblogg.com)
145 points
by
marklit
2y ago
|
129 comments
250.
▲
Baltic Maritime Traffic Feed
(tech.marksblogg.com)
4 points
by
marklit
2y ago
|
0 comments
251.
▲
Global Flight Tracking (2023)
(tech.marksblogg.com)
1 points
by
marklit
2y ago
|
0 comments
252.
▲
Japan's Building Footprints
(tech.marksblogg.com)
3 points
by
marklit
2y ago
|
1 comments
253.
▲
Revisiting Overture's Global Geospatial Datasets
(tech.marksblogg.com)
13 points
by
marklit
2y ago
|
0 comments
254.
▲
AI-Extracted Asian Building Footprints
(tech.marksblogg.com)
2 points
by
marklit
2y ago
|
0 comments
255.
▲
by
marklit
2y ago
Thanks for clearing that up.
256.
▲
by
marklit
2y ago
The JSON files in the S3 bucket can be downloaded in isolation from any other format and they're pretty small. I did some geo-enrichment of them in a previous blog post where I found the country and waters of Umbra's ship imagery.
257.
▲
Satellites Spotting Aircraft
(tech.marksblogg.com)
233 points
by
marklit
2y ago
|
66 comments
258.
▲
Baltic Maritime Traffic Feed
(tech.marksblogg.com)
3 points
by
marklit
2y ago
|
0 comments
259.
▲
Revisiting Overture's Global Geospatial Datasets
(tech.marksblogg.com)
2 points
by
marklit
2y ago
|
0 comments
260.
▲
by
marklit
2y ago
DuckDB's file format is OLAP-based but supports CRUD operations. I've created DBs with it with 10s of millions of records and gotten amazing query speeds. Efficient querying using indices over S3 for their format isn't someth
261.
▲
by
marklit
2y ago
The GPKG files https://github.com/marklit/osm_split produces are SQLite files under the hood and come with an R-Tree Spatial index so they'll load into QGIS and other GIS software quickly.
262.
▲
by
marklit
3y ago
Green Idea | Estonia | REMOTE | Full-time | Windows + DirectX C++ Developer I'm looking for a C++ developer to build Geospatial / GIS visualisation and editing tools for Windows. These will work in both 2D and 3D. These will act m
263.
▲
by
marklit
3y ago
Yeah, you can. The file will be huge though and QGIS won't be performant. Somewhere like Tokyo will be ~400 MB in OSM's PBF format but will contain ~1,300 different types of features. Seeing these listed in alphabetical order in a
264.
▲
by
marklit
3y ago
Add them in https://rapideditor.org/rapid There are usually several satellite image providers for anywhere that isn't a sea or ocean. You can trace over them.
265.
▲
by
marklit
3y ago
I built osm_split to extract OSM features into named GPKG files. It makes it easy to pick features by name and drop them into QGIS. https://github.com/marklit/osm_split
266.
▲
by
marklit
4y ago
Done :) https://github.com/ClickHouse/ClickHouse/issues/45130
267.
▲
by
marklit
4y ago
I'll take a look into it. Last year I found ClickHouse did H3 enrichment much faster than PG or BQ so it has become a go-between for larger workloads with simple enrichment requirements. The dataset in the post is an example anyone can
268.
▲
Telegrams from all over the world stop off at Tallinn's Lasnamäe
(news.err.ee)
2 points
by
marklit
4y ago
|
0 comments
269.
▲
by
marklit
4y ago
I began taking GIS seriously this year so QGIS, GDAL, Shapely + GEOS, PostGIS & Valhalla. As for video editing, I'm using DiVinci Resolve for all my videos now.
270.
▲
by
marklit
4y ago
As soon as you have a few of their IPs, look them up on ipinfo.io/1.2.3.4 and you'll find they probably belong to a handful of hosting firms. You can get each firm's entire IP list on that page and add all of those CIDRs to y
More ›