Having moved to LA this february, the sprawl is really something I had no true appreciation for until I moved here for real, and tried to run errands across town. It's a gigantic, beautiful, complicated place.
One the experiences for me that never gets old is coming in to LAX (flight path East to West) and the sprawl just goes on forever. The other crazy thing that 60% of the population speak a language other than English at home. So I think it has one of the best options for cuisine in the world, because it's all there (somewhere!)
The density at least means you don't have to really run across town for much and can stay within a certain radius for most all your needs and wants. I mean look at the density of costcos alone. Many other metros might have 1 or 2 for the entire area. Then again a lot of other metros you basically can drive end to end in 25 miles.
I did a project recently where I extracted every Los Angeles building permit record for a property and was able to look at the evolution of its infrastructure and tenancy over time by embedding the permit documents into an image-based embedding model. Could be an interesting way to incorporate more granularity of the history of properties over time, although it dramatically increases the scope of data processed.
I had an LLM reverse engineer the API protocol of LADBS and extract the content I wanted. Wether that scales from one property to many (rate limits for one) I don't know, but I didn't encounter anything in the thousands I extracted.
Paradise? LA was a big giant horrible underdeveloped wasteland in Spanish/Mexican times which, at the time in 1849, had 1,600 residents. Most of them had a largely pastoral life and life was brutal there.
LA under US rule is the prime example of what industrialized people can do to a place that lacked nearly everything of what it is at this moment: a world-class city.
Objectively, if it had stayed under Mexican rule, it’d resemble Yuma at best or Tecate at worst. I should know, my family lineage goes back to that era to both sides of the border.
Especially with this sort of map regarding this specific city. For example, Beverly Hills is a separate municipality contained entirely within the borders of Los Angeles. It appears here like an empty black space no different from the ocean, lakes, mountains, and parks also scattered around the city. The styling of this map makes it impossible to tell if an area is truly undeveloped and if so, why. Throw in the way there appears to be arbitrary selection criteria for some buildings outside city limits that make them appear as lone buildings in undeveloped space, and I think it adds up to potentially give people a wrong picture of the area.
early 1900s to early 2000s was a wild and crazy ride for humanity
when I was a teenager I used to run early morning before sunrise and I would never see a car, like maybe once per hour
but these days it's like rush hour at 5am which is frustrating and annoying
and then I realized in perspective that within my own lifetime from teen to 60 the world population has more than DOUBLED, so what I am experiencing makes some sense in that regard (plus technology advancement)
Yey yet another vibe coded viz. these are the “hello world” of LLM projects.
nifty. what about this makes it HN worth? What cool problems did you (not the robot) solve? What did you do beyond prompting it, is there anything for others to learn from? Was the data difficult to acquire, clean up, or is this just an obvious viz on a public dataset anyone could get? Did you glean insights from having this viz, does the graphic serve a narrative or distilling information not otherwise apparent, or is it just pretty?
I ask these genuinely. It’s the difference between “oh I figured out how to print ‘hello world’” vs “I built something”
This started as a data puzzle. There is a lot of public data but it's hosted by for-profit companies and the data models don't seem to be coherent (probably lots of good reasons for the data models being the way they are, so no criticism, and it's wonderful they are public.)
So for LA City, they use Socrata (owned by Tyler Technologies -- NYSE: TYL) to host and publish open data. LA City also uses Esri's ArcGIS for geo-based data.
So behind the scenes there is my code that builds a parquet database of
* MyLA311 service requests
* Permits
* Construction Enforcement
* Crime
* Parcels Id with Polygons
* Lidar
So that part was a typical data-munging exercise, and it was fun & interesting to me to learn how public entities try and deal with IT budget cuts and service the community, etc. (For example, 311 requests for homeless issues are transferred to another department, so they all look they are closed immediately, but I never could find the agency data that ultimately resolved that type of request.)
So I have a pile of data that is organized in a way that makes sense to me, but I could not build an interface that I liked.
So I asked Claude to create a fly-over visualization to see what it could do with this data, and it blew my mind.
I'm a life-long coder and I'm old, so it's an interesting experience to see how good these models and coding harnesses are, and how quickly they are improving.
As to what makes this HN worthy? I enjoyed playing with the interface, and there might be more people than just me who love LA (warts and all) and its history and architecture. So it's interesting and I'm not asking for anything in return, so for me that satisfies the "HN Show" criteria.
The deeper question for me right now is what does hacking mean when the coding is done by these systems? It's a different kind of hacking, and its makes things possible that impossible before, but it's a million miles away from 6502 assembly.
No need to justify yourself to some bitter, petty, sad troll. Let the upvotes and discussion speak for itself. I love seeing other people's vibe-coded projects come to life. I've re-started a bunch of stalled hobby projects thanks to AI.
If you want to encourage folks to continue their efforts and really "build something", I think you'd want to ask your questions in a way that shows genuine interest and support, rather than ridiculing and questioning the level of effort involved.
I agree, I'd love to learn where the dada was sourced! I'm also curious why it appears to come in waves, as opposed to each building going up independently (as I would have expected it to in reality). Cool idea! I can see my house from here haha.
> What cool problems did you (not the robot) solve?
Building products has nothing to do with technical problems, just the end result. This is in contrast with things like writing a library or coming up with a new algorithm, or doing research, or even writing a technical blog post, etc.
> or is it just pretty?
People have been sharing "just pretty" things on HN for decades. It might be interesting, thought-provoking, discussion-worthy, or whatever. Even if this wasn't vibe-coded, it wouldn't be some monumental technical achievement. Your point is absolutely moot.
I joined the county's 2020 lidar building footprints (LARIAC) to the assessor roll, so every one of the 1,129,558 buildings inside the City of LA has a footprint, a height, and a year built for 98% of them. (All public info, but kind of a pain to grab.)
The page extrudes them in 3D and plays the city filling in from 1880 to now. Colors are by decade, or switch to height and fly to downtown. Hover any building for its address, year, height, and footprint. Some things I found: the 1950s, not the 1920s, is the biggest decade still standing; the Valley visibly snaps into existence after the war; and downtown's 150-foot height limit shows up as a hard ceiling until 1957. Zoomed out it draws a 100 m grid because a citywide view can't carry a million polygons, and heights are exaggerated below street level zoom (the corner label says by how much).
Stack: DuckDB spatial for the join, tippecanoe to PMTiles, MapLibre fill-extrusion, all static files on R2 with no server. City of LA only, since the parcel polygons I pulled stop at the city line.
Happy to answer questions about the data or the rendering.
Bit misleading since it only shows properties still standing, seemingly. So the older periods look extremely empty.
I noticed most of the tall buildings are sixties to eighties. Some more info about that here. https://www.pbssocal.org/shows/artbound/a-brief-history-of-l...
Having moved to LA this february, the sprawl is really something I had no true appreciation for until I moved here for real, and tried to run errands across town. It's a gigantic, beautiful, complicated place.
One the experiences for me that never gets old is coming in to LAX (flight path East to West) and the sprawl just goes on forever. The other crazy thing that 60% of the population speak a language other than English at home. So I think it has one of the best options for cuisine in the world, because it's all there (somewhere!)
The density at least means you don't have to really run across town for much and can stay within a certain radius for most all your needs and wants. I mean look at the density of costcos alone. Many other metros might have 1 or 2 for the entire area. Then again a lot of other metros you basically can drive end to end in 25 miles.
I did a project recently where I extracted every Los Angeles building permit record for a property and was able to look at the evolution of its infrastructure and tenancy over time by embedding the permit documents into an image-based embedding model. Could be an interesting way to incorporate more granularity of the history of properties over time, although it dramatically increases the scope of data processed.
Interesting idea. Is there a practical way to obtain those permit records at scale?
I had an LLM reverse engineer the API protocol of LADBS and extract the content I wanted. Wether that scales from one property to many (rate limits for one) I don't know, but I didn't encounter anything in the thousands I extracted.
They paved paradise, and put up a parking lot.
Paradise? LA was a big giant horrible underdeveloped wasteland in Spanish/Mexican times which, at the time in 1849, had 1,600 residents. Most of them had a largely pastoral life and life was brutal there.
LA under US rule is the prime example of what industrialized people can do to a place that lacked nearly everything of what it is at this moment: a world-class city.
Objectively, if it had stayed under Mexican rule, it’d resemble Yuma at best or Tecate at worst. I should know, my family lineage goes back to that era to both sides of the border.
Is there an alternative if 13 million people want to live somewhere?
Nice! Would be better if it shows the difference between the ocean and other land
Agree, I personally also think dark mode never goes well with a map-based app...
Especially with this sort of map regarding this specific city. For example, Beverly Hills is a separate municipality contained entirely within the borders of Los Angeles. It appears here like an empty black space no different from the ocean, lakes, mountains, and parks also scattered around the city. The styling of this map makes it impossible to tell if an area is truly undeveloped and if so, why. Throw in the way there appears to be arbitrary selection criteria for some buildings outside city limits that make them appear as lone buildings in undeveloped space, and I think it adds up to potentially give people a wrong picture of the area.
Yes, good point. The LA City data was rich, but the other communities have data in other places. I will see what I can do.
Good idea! Let me work on that...
wild to see that, reminds me vaguely of the amazing ariel photos by kite of San Francisco after the earthquakes in 1906
* https://en.wikipedia.org/wiki/File:San_Francisco_in_ruin_edi...
early 1900s to early 2000s was a wild and crazy ride for humanity
when I was a teenager I used to run early morning before sunrise and I would never see a car, like maybe once per hour
but these days it's like rush hour at 5am which is frustrating and annoying
and then I realized in perspective that within my own lifetime from teen to 60 the world population has more than DOUBLED, so what I am experiencing makes some sense in that regard (plus technology advancement)
Yey yet another vibe coded viz. these are the “hello world” of LLM projects.
nifty. what about this makes it HN worth? What cool problems did you (not the robot) solve? What did you do beyond prompting it, is there anything for others to learn from? Was the data difficult to acquire, clean up, or is this just an obvious viz on a public dataset anyone could get? Did you glean insights from having this viz, does the graphic serve a narrative or distilling information not otherwise apparent, or is it just pretty?
I ask these genuinely. It’s the difference between “oh I figured out how to print ‘hello world’” vs “I built something”
This started as a data puzzle. There is a lot of public data but it's hosted by for-profit companies and the data models don't seem to be coherent (probably lots of good reasons for the data models being the way they are, so no criticism, and it's wonderful they are public.)
So for LA City, they use Socrata (owned by Tyler Technologies -- NYSE: TYL) to host and publish open data. LA City also uses Esri's ArcGIS for geo-based data.
So behind the scenes there is my code that builds a parquet database of * MyLA311 service requests * Permits * Construction Enforcement * Crime * Parcels Id with Polygons * Lidar
So that part was a typical data-munging exercise, and it was fun & interesting to me to learn how public entities try and deal with IT budget cuts and service the community, etc. (For example, 311 requests for homeless issues are transferred to another department, so they all look they are closed immediately, but I never could find the agency data that ultimately resolved that type of request.)
So I have a pile of data that is organized in a way that makes sense to me, but I could not build an interface that I liked.
So I asked Claude to create a fly-over visualization to see what it could do with this data, and it blew my mind.
I'm a life-long coder and I'm old, so it's an interesting experience to see how good these models and coding harnesses are, and how quickly they are improving.
As to what makes this HN worthy? I enjoyed playing with the interface, and there might be more people than just me who love LA (warts and all) and its history and architecture. So it's interesting and I'm not asking for anything in return, so for me that satisfies the "HN Show" criteria.
The deeper question for me right now is what does hacking mean when the coding is done by these systems? It's a different kind of hacking, and its makes things possible that impossible before, but it's a million miles away from 6502 assembly.
No need to justify yourself to some bitter, petty, sad troll. Let the upvotes and discussion speak for itself. I love seeing other people's vibe-coded projects come to life. I've re-started a bunch of stalled hobby projects thanks to AI.
If you want to encourage folks to continue their efforts and really "build something", I think you'd want to ask your questions in a way that shows genuine interest and support, rather than ridiculing and questioning the level of effort involved.
I agree, I'd love to learn where the dada was sourced! I'm also curious why it appears to come in waves, as opposed to each building going up independently (as I would have expected it to in reality). Cool idea! I can see my house from here haha.
> What cool problems did you (not the robot) solve?
Building products has nothing to do with technical problems, just the end result. This is in contrast with things like writing a library or coming up with a new algorithm, or doing research, or even writing a technical blog post, etc.
> or is it just pretty?
People have been sharing "just pretty" things on HN for decades. It might be interesting, thought-provoking, discussion-worthy, or whatever. Even if this wasn't vibe-coded, it wouldn't be some monumental technical achievement. Your point is absolutely moot.
I joined the county's 2020 lidar building footprints (LARIAC) to the assessor roll, so every one of the 1,129,558 buildings inside the City of LA has a footprint, a height, and a year built for 98% of them. (All public info, but kind of a pain to grab.)
The page extrudes them in 3D and plays the city filling in from 1880 to now. Colors are by decade, or switch to height and fly to downtown. Hover any building for its address, year, height, and footprint. Some things I found: the 1950s, not the 1920s, is the biggest decade still standing; the Valley visibly snaps into existence after the war; and downtown's 150-foot height limit shows up as a hard ceiling until 1957. Zoomed out it draws a 100 m grid because a citywide view can't carry a million polygons, and heights are exaggerated below street level zoom (the corner label says by how much).
Stack: DuckDB spatial for the join, tippecanoe to PMTiles, MapLibre fill-extrusion, all static files on R2 with no server. City of LA only, since the parcel polygons I pulled stop at the city line.
Happy to answer questions about the data or the rendering.
[Just a fun project, no commercial relevance.]
Didn't realize you could zoom in until I saw this. It looks really cool when you zoom in and it replaces the boxes with actual building shapes.