Daily Archives: November 8, 2024

Django Database options

Posted on by
Reply

I have been looking at Django for several projects. I've been looking at implementation details including hosting and database.

database options for Django and have settled on PostGIS as in PostgresSQL with GIS support.
https://stackoverflow.com/questions/3743632/gis-postgis-postgresql-vs-mysql-vs-sql-server

In general I have found reading through the following helpful
https://www.digitalocean.com/community/tutorials/how-to-create-a-django-app-and-connect-it-to-a-database
https://djangobuilder.io/#/
http://darrenoneill.co.uk/post/using-postgis-and-geodjango-find-nearest-neighbour/
https://medium.com/@amirm.lavasani/classic-machine-learning-in-python-k-nearest-neighbors-knn-a06fbfaaf80a
https://www.geeksforgeeks.org/find-the-nearest-node-to-a-point-using-osmnx-distance-module/
https://github.com/fabiocaccamo/django-treenode
https://github.com/peopledoc/django-ltree-demo


https://stackoverflow.com/questions/38921444/modelling-a-polymorphic-tree-with-django-treebeard
https://dev.to/pawnsapprentice/postgresql-in-geospatial-applications-unleashing-the-power-of-location-data-4jan
https://github.com/gboeing/osmnx
https://github.com/feincms/django-tree-queries
https://django-treebeard.readthedocs.io/en/stable/

Find adjacent language equals
Weight algorithm: Node edge in lang-tree = .5, overlapping GIS = .20, adjacent GIS edge = .25

Radwagon 4 Collapse

Posted on by
Reply

My kids and I started using our Radwagon 4 this year to commute around the Belle Mead area of New Jersey.

Often we make the trip into Princeton. Today we got our things loaded up on the bike and just as I had started the electrical assistance the front tire tore off and we crashed at the end of our long-ish driveway. To be clear our front quick release axle was tight before departure (departure on our 40 second trip). Also we are evidently not alone in this experience.

Our use is rather low as we have just started using the bike about two months ago and are at 279 miles.

We are concerned for two reasons.

First we are sad about what happened and desperately want to know how to fix the broken parts. My son expressed it in the moment like this:

Second, we’re not entirely sure how this happened and we are concerned that it might happen again. We travel roads and there are cars on those roads so we want to be sure the equipment we use is not going to fail. Damage to our bodies included scrapes, bruises, and jarring. But the bike sustained moderate damage including a bent disc break in the front, a bent drive wheel, a broken front splash guard and scraped paint in several places including the front basket and back runners.

The front wheel ended up under the bike.
We were all scraped up.
Hugh’s Back
My Hand
My Elbow
My Leg
Bend to the back cage.
Front disc break completely bent
Demolished front fender
Dented and bent front drive chain

From what I read on the internet I see that the front axle doesn’t have “Lawyer tabs” which would prevent the axle from moving out of the forks. This seems to be a design flaw but the design around the forks is short and there isn’t really a way to add my own. A newly designed fork, like those mentioned here, would be a welcomed addition.