There’s also SQLPro Studio - the studio namespace is getting crowded!
69 karma · joined August 3, 2011
for pretty much any geospatial source you can convert to .pmtiles via GDAL[3] and tippecanoe (.shp .gpkg ...) | ogr2ogr -> .geojson | tippecanoe -> .pmtiles
for OpenStreetMap data there's planetiler[4], and and openmaptiles[5] styles that work with Maplibre
with those combinations you've got a great start to something you can host for pennies on AWS S3+CloudFront or Cloudflare R2, with an open source data pipeline
[2] https://github.com/felt/tippecanoe
[4] https://github.com/onthegomap/planetiler
[5] https://openmaptiles.org/styles/
ps I find GDAL/ogr2ogr documentation pretty hard to parse, as an example to get you started
ogr2ogr -f GeoJSON counties.json -t_srs EPSG:4326 -nln counties -sql "SELECT STATEFP, COUNTYFP, NAME FROM tl_2022_us_county" /vsizip/tl_2022_us_county.zip
https://www.census.gov/geographies/mapping-files/time-series/geo/cartographic-boundary.html"TL;DR
In 2012, Dmitri Krioukov, a physicist at the University of California, San Diego, faced a $400 fine for allegedly running a stop sign. Instead of accepting the fine, Krioukov crafted an academic paper titled "The Proof of Innocence" to argue his case in court.
Surprisingly, the judge was convinced and acquitted him. Krioukov shared his paper online with a subtitle, "A way to fight your traffic tickets," humorously noting that the paper earned a special prize of $400, which he didn't have to pay to California.
The paper discusses a scenario in which if a car stops at a stop sign, an observer (e.g., a police officer) located at a specific distance perpendicular to the car's trajectory might perceive the car as not stopping under specific conditions. These conditions are:
1 - The observer measures not the linear but angular speed of the car.
2 - The car decelerates and subsequently accelerates relatively quickly.
3 - There is a short-time obstruction of the observer's view of the car by an external object (e.g., another car) at the moment when both cars are near the stop sign.
Disclaimer: the paper was submitted on April 1st, 2012, so there's a non-zero probability this could a be joke by Dmitri :) Either way, it's a good paper."
Remote: Yes
Willing to relocate: No
Technologies: Ruby/Rails, Javascript, Angular, Node, Docker, AWS, PostgreSQL, MongoDB
Résumé/CV: https://tzwolak.com
Email: root@tzwolak.com
and if you've got an hour (or two) to waste http://www.wired.com/wired/archive/4.12/ffglass.html
> It's like magic, except it's math.
hacked!
A couple of months ago my sister approached my and asked "How do I learn how to make websites?" She has no programming experience, so I thought for a while on where to start. I figured if I showed her what I was working on in Python/Django, she would be completely overwhelmed. So I started with just HTML. As she worked through that, she started asking questions like, how to change layout and fonts, so we started working with CSS. She's not at the point yet, but I think PHP is going to blow her mind, as I've seen her copy/pasting stuff from file to file.
I think its important to start at the beginning and learn some of the pain points that these frameworks solve before jumping in. Otherwise you just get frustrated wondering why things are set up a certain way.
I remember the manager telling me we were making $30,000 a day during the week-long sale. I guess "going out of business" is good business, haha.