Watch Los Angeles get built, one building at a time (1880–2026)
Posted by rustywasm 18 hours ago
Comments
Comment by epistasis 17 hours ago
LA is a ridiculously unaffordable place to live, not because it's nice, but because of an artificial shortage of built space, due to a monopoly on the permission to build.
Comment by slg 14 hours ago
To put numbers to this for those who aren't aware, LA was zoned for roughly 10 million people in the 1960s and by the 1980s it was zoned for roughly 4 million. It's part of the reason the city has had population growth slow to a crawl. It was decided some 40 plus years ago that LA should stay under 4 million people, so it has even til today. But the number of people who want to live in LA is constantly growing, so housing prices continue to rise and as a result lower income people are slowly but surely being pushed out of their homes and out of the city entirely.
Comment by dv_dt 25 minutes ago
Comment by lwansbrough 14 hours ago
Comment by TomGarden 13 hours ago
Comment by hackernud3s 11 hours ago
Comment by pjerem 7 hours ago
Also it’s an American city made for cars so it doesn’t help me to like it.
Comment by stasomatic 45 minutes ago
I love the climate and nature there, besides the fires. Ocean, lakes, mountains, deserts, all within 1-3 hour drive.
It is a dehumanizing city to commute in, and is expensive, but it's the best one I have lived in (NYC, Brooklyn, NJ cities, Las Vegas, Charlotte, Miami) and I want to return when finances allow.
Comment by enopod_ 5 hours ago
Comment by kfarr 17 hours ago
Comment by bingohbangoh 14 hours ago
Or do we think that property taxes would go up while other taxes stay put?
This feels like the argument at play when people criticize Prop 13. Not saying it’s good but California hasn’t ever cut taxes meaningfully and I’m not convinced raising property taxes would solve anything. California would still be expensive to live in.
Comment by andrewmutz 13 hours ago
People would move more instead of being locked in to a low effective property tax.
The tax burden would be much fairer: instead of the police and schools being funded by newcomers, everyone would be contributing their fair share to fund the city, instead of the longest tenure residents mooching off the rest of us.
Unproductive use of land would be discouraged. If a tract became highly desirable, it would be expensive to let it sit in an unproductive form
Cities could raise taxes as high as their residents wanted them to be, instead of being limited by the opinions of non-residents. Some people want to have better funded police and schools, and local government would actually be allowed to deliver that. Citizens who didnt want to live in expensive cities could vote with their feet to cheaper towns.
Comment by dv_dt 2 hours ago
The bad part about prop 13, is that it never should have applied to anything other than primary residences of people. Having it apply to rental & commercial properties is what warps the market.
Cities should be cutting their police budgets - most small towns have nearly 50% of the budgets tied up in police. All while there has been a multi-decade decrease in crime.
Comment by anonymousiam 11 hours ago
https://www.ocassessor.gov/tax-saving-programs/savings-senio...
Comment by bloppe 13 hours ago
Comment by jrmg 13 hours ago
The housing market would become more liquid because people would move out of homes if their values rose too much and they could no longer afford the taxes. This would be a shock initially, but over time it would just be seen as part of life like it is in other areas: mostly, empty nesters would downsize to a cheaper, smaller house with lower taxes. Gentrification might be more problematic though.
In practice, probably some phased rebalancing would have to happen to avoid the sudden economic shock, but, politics notwithstanding, it’s not crazy to suggest it could be done and that the end state might be overall ‘better’ for most people. The end state would be how property taxes work almost everywhere else.
Comment by tikhonj 11 hours ago
Comment by groundzeros2015 14 hours ago
Comment by syspec 15 hours ago
On a 1.5M house, that's starting at 17K a year and each year it goes up 2%, so it compounds.
That's 17k a year Just to stay in your own home.
People who don't pay property taxes here in ca, act like prop 13 means zero property taxes
Comment by isubkhankulov 14 hours ago
Your property tax goes up by 2% of your , guessing (relatively recent?) purchase price, and theirs goes up 2% of a much smaller base due to prop 13.
They have no incentive to move, downgrade. And they often use trusts to pass this tax base down to their kids. It’s feels like icky European feudalism.
Again i’m emphasizing that this goes for both residential and commercial buildings.
Comment by fatcatsbestcats 8 hours ago
Comment by cucumber3732842 14 hours ago
Pairs nicely with the permitting processes that basically boil down to "thou shalt pay the guild"
Comment by jedberg 12 hours ago
Yes and yes.
And I pay 10K less a year than my neighbor for the same value house. And I pay 10K more a year than my other neighbor.
I get a huge advantage from Prop 13, but I still think it needs to get replaced with a much fairer system.
Comment by dbmikus 15 hours ago
Comment by codemac 15 hours ago
You can argue against property taxes entirely, but Prop 13 definitely means that families, businesses, and all property owners work very hard to never sell, never reassess, and never change their tax rate.
Comment by stouset 14 hours ago
This would eliminate the tax break for commercial property, prevent it from being abused for second homes, and avoid the property trust shenanigans that have allowed some properties to change hands without a reset in the taxes paid.
Comment by lokar 12 hours ago
The main selling point of prop13 was a real problem: rapidly increasing values were driving up taxes so fast that long time residents (of modest means) were being forced out.
I don’t think it’s entirely unreasonable to have some policy that attempts to protect people living in their primary residence from rapid tax increases they can’t afford.
Comment by tikhonj 10 hours ago
The point of Prop 13 is to let people have their cake and eat it too: you get to keep the equity you gain from increased housing prices, but not pay the property tax that comes with them.
Comment by tzs 8 hours ago
The approach in Washington works well. There is a senior property tax exemption based on age and disposable income. To qualify in King County (where Seattle is) in 2027 you need to be 61+ and have a household disposable income under $101k.
That gets you (1) a freeze on the assessed value for taxes equal to the current assessed value, and (2) an exemption from the statewide school tax and from "excess levies" (basically city and county levies that are voted on).
If income is under between $76k and $89k they also exclude from tax 45% of your assessed value or $70k, whichever is larger, but not more than $200k.
If income is below $76k they exclude 80% of your assessed value or $80k, which is larger.
The income levels are based on median county household income so vary from county to county.
Disposable income is basically everything that goes into AGI plus a list of other things (like any Social Security that is not already in AGI). There are also a bunch of deductions, mostly medical including Medicare premiums, with a $7500 deduction you can elect to take instead of taking any of those specific deduction. Income includes all adults living in the house.
In my county the levies that are not "excess levies" are county roads, sheriff, conservation, mental health, veterans relief, fire district stuff, public utility district stuff, and regional library. The "excess levies" are a couple of school district levies. Overall the excess levies are about 28% of the property taxes in my county. The statewide school levy that is exempt is another 10%, so the bottom line is that the property tax rate for seniors under the income limit is about 60% of the non-senior rate.
Comment by Schiendelman 11 hours ago
Comment by lokar 11 hours ago
Comment by Schiendelman 9 hours ago
Comment by MarkusQ 11 hours ago
Comment by Schiendelman 11 hours ago
Comment by fc417fc802 5 hours ago
Comment by Schiendelman 2 minutes ago
Comment by lokar 11 hours ago
And the state did slash spending in the years following. In particular funding for the university system was hit very hard.
Comment by MarkusQ 9 hours ago
Comment by refurb 11 hours ago
Let people defer increases until their house is sold. This what many states do.
It’s seems insane that we “protect” people whose property taxes are going up because their home is getting so valuable
Comment by skywhopper 3 hours ago
Comment by tikhonj 10 hours ago
It's pretty clear that this kind of tax policy is going to totally mess up the housing market. It's not the only factor, but it's a big one.
Comment by MikeNotThePope 14 hours ago
Comment by xmprt 14 hours ago
The fact that every single person has a small private park in their front and backyards that's enjoyed maybe a couple hours per day at most is pretty wasteful - if it was shared the utilization would go way up and space used would be way down. Same goes for all the parking lots needed to facilitate car traffic - if we used more efficient/shared options like buses or trams then the parking lots that sit empty most of the day could be replaced with more businesses or houses that allow people to live closer to the services that they need every day.
Meanwhile, we have big bottlenecks in our city downtowns where all the density is packed. Spread that out and things get a lot more efficient - your commute probably goes down too because you can live closer to work. Suburbs don't work without a productive city near them - otherwise they're just rural areas.
Comment by epistasis 10 hours ago
Some plots of land are very valuable due to their location, what you can access, etc. It's pretty straightforward to find out what the monthly cost of land is in any area, either from simple regressions on property values, or empty lot sales, etc.
When the land rent starts to excessively exceed average income of number of households allowed to live on that plot of land, that's pretty inefficient.
Owning land is society letting you say to other people: you're not allowed here. When we restrict land us so that people can not figure out their best use of it, eg 4 families building townhouses together, we start to restrict access to opportunity and basic economic freedom.
Comment by mitxela 14 hours ago
Comment by Schiendelman 11 hours ago
Comment by esikich 14 hours ago
Comment by 21asdffdsa12 4 hours ago
Basically build affordable housing illegally
Comment by WD-42 10 hours ago
Of course they aren’t in LA proper. But it seems like people that want to live in SoCal want the suburbs. You talk like LA is this artificially small place except that it’s more like a neighborhood in the middle of sprawl at an almost unimaginable scale.
Not saying any of this is good. In fact it’s terrible. Personally I feel like the entire LA metro area is about as close as you can get to a real paradise lost on earth. Maybe one of the most naturally beautiful places on the planet, bulldozed over for a maze of 6 lane uncrossable suburban streets and cookie cutter McMansions.
Comment by epistasis 10 hours ago
If apartments, even small buildings, were legal in LA, they'd be building them everywhere and they'd immediately fill up.
The Mayor, Karen Bass, accidentally screwed up and made affordable possible to build, as in allowing it to get through the gauntlet of approvals. This resulted in a massive amount of extremely costly affordable housing to get built, merely because the approval couldn't be stopped arbitrarily:
https://www.pacificresearch.org/la-mayor-slowly-dismantles-h...
Ift that sort of project approval was opened up to not only affordable housing, but also for-profit housing, there would be a massive shift in the type of new housing in the area.
Comment by gradus_ad 16 hours ago
Comment by kccqzy 15 hours ago
The city’s original 1916 zoning regulation permitted a hypothetical maximum population of 55 million; after WWII the new zoning regulations essentially limited hypothetical maximum population to a little more than 10 million if everything is fully developed. Recent initiatives like City of Yes did too little to reverse the trend.
Comment by returningfory2 15 hours ago
Comment by Schiendelman 11 hours ago
Comment by tokioyoyo 14 hours ago
When I was in Vancouver, people kept saying if we got rid of rent control, houses will be built, rent will come down. But houses are expensive to build, and they need to make money asap in the “exit economy”. They won’t come up easily, unless they make it cheap to build, which isn’t happening. Rents just started coming down, but so far insignificant amount (I just checked, a place I paid $2500 for in 2019, is going for $3300 after the decrease!), and demand curbing had more influence on it. Personally, I think we shouldn’t force people to move to a different area because rents skyrocketed. I’m all in support of getting paid out though.
People look at Tokyo, and talk about “less-zoned build whatever, and no rent control, thus more or less affordable”. Which also depends*. YoY rents are going up by 10-15% right now, even more in some areas. It’s unreasonable for a good chunk of residents. Speculation is big influx of money from China. But you can actually challenge the rent increase in a good chunk of cases. So it’s a pseudo-rent control.
I’m not saying something is right or wrong, just saying everything has multiple layers of problems.
Comment by Schiendelman 11 hours ago
Tokyo, similarly, has hit the limit of what they allow to be built under the highest density of their stepped national zoning levels.
Comment by oblio 16 hours ago
At least watch this money shot: https://youtu.be/kpK5HiCKfgU?si=YNQBxsn15NxGdQQ0&t=272 (wait for the video to reveal the construction years)
As Max Fisher puts it: American cities have been frozen in amber.
Comment by epistasis 10 hours ago
Comment by golem14 14 hours ago
Comment by wdr1 14 hours ago
And all that it takes to turn seawater into potable freshwater is energy.
We don't have a water problem. We have an energy problem.
For all of LA County, it would take 500–750 MW each year to use seawater for all our freshwater needs.
Or put another, with a single nuclear power plant, we would solve all LA's freshwater needs -- forever.
Comment by thrance 13 hours ago
It's crazy how to some, building a whole nuclear reactor and dozens of desalination plants seems like a simpler solution than making a couple of very wealthy farmers a bit angry for a while. Capital really is all-powerful in the States, it even holds power in the very minds of its citizens.
Comment by cucumber3732842 3 hours ago
Yeah, you can always use state violence to take from one group and give to another but that's less than zero sum because it costs you use of state violence which isn't cheap and must be expensively maintained.
You might make things fairer doing that but you won't make them better overall. At some point for things to actually get better overall, for the pie to get bigger, you must actually build something for someone. If not a nuclear powered desalination plant then it will be something else.
Comment by thrance 3 hours ago
Huh, yes it will? You don't need state violence to reduce wealthy farmers' water rights from 10B gallons per year to 8B, which will instantly free up water for others, more important uses. Their quality of life won't decrease if they have to switch a few plots from alfalfa to wheat, if that's what you're afraid of.
> for the pie to get bigger, you must actually build something for someone
I dislike how you just assumed that because I prefer a simple political solution over an over-engineered decades-long project on this one issue, I must be opposed to all new infrastructure. In this case, there's plenty of water to go around.
> state violence which isn't cheap and must be expensively maintained.
1, you don't need much (or any) state violence to keep a few rich families from stealing water, and 2, how is that more expensive that a fucking nuclear plant??? And what about the ecological cost? Nuclear is cleaner that most energies, but it's not free. And nuclear capacity could be put to much better use than offsetting inefficient use of the commons.
> Yeah, you can always use state violence to take from one group and give to another
Yeah, that's exactly what those problematic water rights are achieving: they take most of the available fresh water and give it to a tiny minority that benefits immensely from it. I'm suggesting we improve on that.
> Your comment is a great example of the sort of zero sum ignorance that gets us where we are.
I just can't get over how arrogant and mean this line is. The pie is continually growing, the only thing preventing people from getting a slice is that capital owners keep it all to themselves. We didn't get to this situation because the people is too greedy and impairing oligarchs from building stuff. It's quite the opposite.
We have bloated contractors receiving billions for very little in exchange, and in this situation, people like you are suggesting we don't solve this very simple resource allocation problem and instead shovel a few more billions of public money to the private sector for completely superfluous infrastructure we won't catch a glimpse of before 2048.
Comment by cucumber3732842 59 minutes ago
Why develop local gas fields and solar when we can just invade nations with oil?
The only way to win sustainably is to make the resource, whatever it is, more accessible or less needed, somehow.
A few billion on this or that is pocket change compared to the economic and political cost of political policy with very obvious and well defined classes of losers. Taking things isn't free even if done domestically.
>1, you don't need much (or any) state violence to keep a few rich families from stealing water
Yes, you do. It will just be spent on schools to tell the kids how to think and carrot/stick grant programs to financially incentivize compliance among the municipalities and subsidies with strings attached and inspectors to verify these things and studies and surveys and all manner of other stuff like that rather than bombs and missiles but you absolutely need to spend untold sums of money to enforce policy that is "bad" for whoever you're enforcing it upon.
>I just can't get over how arrogant and mean this line is.
I'm jaded beyond caring about such things at this point.
>The pie is continually growing, the only thing preventing people from getting a slice is that capital owners keep it all to themselves.
>We have bloated contractors receiving billions for very little in exchange, and in this situation, people like you are suggesting we don't solve this very simple resource allocation problem and instead shovel a few more billions of public money to the private sector for completely superfluous infrastructure we won't catch a glimpse of before 2048.
I want you to do the math on what the capital owners actually make. Sure, they're filthy rich and putting their thumb on the scale in various bad ways but the rent they take is peanuts compared to the money just pissed away on goods and services that are far outside of whatever the critical path is.
For every dollar the CEO or board members or other large shareholder of some megacorp are paid the megacorp pays tens or hundreds to the "bloat" which you rightly identify as a problem in a lot of these project.
To use a metaphor, paying the football coach and the chancellor less isn't gonna fix the price of a college that has a non-teaching non-researching administrator for every two students.
Would putting the bloat into the public sector somehow make it less wasteful? Of course not.
At the end of the day we need to find a way to reduce the bloat and waste because the bloat and waste are not only why the nuclear desalination plant (or whatever) looks expensive and unattractive, it's also why the farmers care to hold onto the water. If pivoting was cheaper/easier/more reliable than perpetually fighting they would.
The past 50yr of regulation has been the kind of quasi centrally planned financial tomfoolery to incentivize the "right thing" (for who's definition?) and it's worked so poorly here we are in these comments discussing how LA has stagnated to the financial detriment of most there. No, I don't think "just one more centrally planned tweak" is gonna fix it whether we're tweaking water or something else.
Comment by jedberg 12 hours ago
You could put the salt on boats and dump it back much further out in the ocean, but that too takes energy.
Comment by epistasis 10 hours ago
As it is, water usage in Los Angeles has had flat water usage for decades, even as its population grew by over a million people.
By downzoning so much, Los Angeles got the worst of all worlds: higher water usage, unaffordable housing, and unbelievably bad traffic because everybody has to drive such massive distances to the job centers.
Downzoning is an environmental disaster compared to the alternative, like allowing factories to dump their pollution into rivers type of disaster.
Comment by kristopolous 17 hours ago
it's basically this data: https://portal.assessor.lacounty.gov/ through this portal https://data.lacity.org/
Comment by rustywasm 16 hours ago
Probably should put that front and center.
Comment by blululu 10 hours ago
Comment by 3RTB297 9 hours ago
Comment by kristopolous 8 hours ago
https://mil.library.ucsb.edu/ap_indexes/FrameFinder/
It genuinely is much more sporadic then you think. 1 or 2 houses, then empty blocks with streets there, then 1 more, then some building ...
For a modern version, look up california city - modest suburban homes respectably maintained with cars in the driveway surrounded by endless nothing.
I have to presume there's some people that look at this and say "wow, this is perfect".
Comment by wathef 16 hours ago
[1] - https://www.pbssocal.org/shows/lost-la/from-rail-to-roads-an...
[2] - https://www.lapl.org/research-guides/maps/maps-los-angeles
Comment by rustywasm 15 hours ago
Comment by davidw 15 hours ago
That's probably part of the reason they got rid of them. You still see that argument used against transit: "it will bring _____ to our part of town".
Comment by bean469 2 hours ago
Comment by WD-42 10 hours ago
Comment by lokar 12 hours ago
Comment by ZeWaka 18 hours ago
Comment by sgt 17 hours ago
Comment by rustywasm 16 hours ago
Comment by incanus77 12 hours ago
About ten years ago when we were working on Mapbox GL, I did a mobile-native viz like this to show off the vector tile tech. The blog post is still up (thankfully) which has a good bit of info on the data processing pipeline as well, ranging from Shapefile to GeoJSON to vector tiles on the backend to Swift on the frontend:
https://medium.com/mapbox/visualizing-an-entire-citys-buildi...
I always loved mirroring a phone to a large TV and showing this off at 60FPS. It was such fun tech to work on.
Comment by neilv 17 hours ago
https://www.youtube.com/watch?v=OGPh2AcmG2A
The storytelling atmosphere is somber film-noire-ish, but there's simultaneously a feeling of national prosperity and potential for many (with notable unjust exceptions), like I think fewer people feel in more recent decades.
Would also be interesting to try to convey that kind of change over time, in an immersive way.
Comment by rustywasm 16 hours ago
Comment by ericzawo 18 hours ago
Comment by rustywasm 17 hours ago
Comment by lokar 12 hours ago
Comment by foco_tubi 9 minutes ago
Comment by WD-42 10 hours ago
Comment by nunez 13 hours ago
Comment by asdff 17 hours ago
Comment by oblio 16 hours ago
Comment by ianburrell 15 hours ago
Comment by asdff 15 hours ago
Comment by mullingitover 15 hours ago
Pretty infuriating to visit Barcelona recently and see that there was a perfect example of good urban planning sitting right there for decades that LA could've simply copied. In the long run this region is simply incapable of maintaining its infrastructure with its tax base, even today you can see it starting to collapse.
Comment by tcdent 18 hours ago
Comment by computomatic 17 hours ago
Comment by tcdent 17 hours ago
Comment by djmips 18 hours ago
Comment by rustywasm 16 hours ago
And here is one that is just fun to watch because of Huell Howser --
Tallest Building | Visiting with Huell Howser https://www.youtube.com/watch?v=5ziEDhCPjOQ
Comment by tomjakubowski 15 hours ago
https://en.wikipedia.org/wiki/List_of_tallest_buildings_in_L...
Comment by toyg 17 hours ago
Comment by mag7269 17 hours ago
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.
Comment by toyg 16 hours ago
Comment by Hnrobert42 16 hours ago
Also, GP was quoting a song lyric.
Comment by rustywasm 16 hours ago
Comment by thisismyopinion 17 hours ago
Comment by esseph 16 hours ago
Counting Crows did a cover in 2002.
Comment by lotsofpulp 17 hours ago
Comment by toyg 16 hours ago
Unfortunately, humans do not know restraint.
Comment by socalgal2 13 hours ago
Comment by thomasfl 3 hours ago
Comment by CorvusCrypto 16 hours ago
Comment by esseph 16 hours ago
Comment by enjoyyourlife 18 hours ago
Comment by suncemoje 18 hours ago
Comment by slg 17 hours ago
Comment by rustywasm 17 hours ago
Comment by slg 13 hours ago
Comment by rustywasm 18 hours ago
Comment by andretti1977 7 hours ago
Comment by burningChrome 10 hours ago
Comment by sevennull 12 hours ago
Comment by SachaSOL 2 hours ago
Comment by rustywasm 9 hours ago
Comment by sshussain270 5 hours ago
Comment by andai 15 hours ago
Comment by rustywasm 15 hours ago
Comment by gregjw 14 hours ago
Comment by mark242 14 hours ago
Comment by mark242 15 hours ago
Comment by rustywasm 9 hours ago
Comment by valiant-comma 16 hours ago
Comment by shevy-java 3 hours ago
Comment by kevo1ution 16 hours ago
Comment by ck2 18 hours ago
* 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)
Comment by quaddoggy 15 hours ago
Comment by globular-toast 7 hours ago
Comment by theycallmeritik 9 hours ago
Comment by HardCodedBias 14 hours ago
Brilliant.
Comment by fsckboy 12 hours ago
Comment by tjwebbnorfolk 15 hours ago
Comment by hughw 15 hours ago
Comment by rustywasm 18 hours ago
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.]
Comment by drivers99 17 hours ago
Comment by axionbraid 8 hours ago
Comment by entelechy0 18 hours ago
Comment by losteric 18 hours ago
Comment by oijkuij 18 hours ago
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.
Comment by rustywasm 16 hours ago
LA genuinely built in bursts. The 1920s and the postwar decade each account for over 230,000 buildings still standing, and the 1930s and 1970s onward are much thinner, so even a perfect per-year animation would surge and pause.
But really it's for performance -- I group buildings into 5-year bins and fade each bin in over its span, rather than popping each building at its exact year.
A per-year filter on a million polygons re-tessellates every visible tile, which was too slow to animate, whereas fading pre-built layers is reasonably fast.
Glad you found your house!
Comment by rustywasm 17 hours ago
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.
Comment by kfarr 17 hours ago
I’ve helped with a few other zoning visualization projects recently, similar workflow. The only similarity is that each city/jurisdiction makes its data available in a different way. It’s usually accessible but it does mean there’s a lot of work munging the data to a usable format.
Here’s one of the projects: https://github.com/kfarr/zoningviz
Comment by rustywasm 16 hours ago
The other thing I learned is that some of the data sets use a destructive insert, so unless someone is doing a data snapshot data elements can be lost. (The vendors charge extra time-series option.)
Comment by fortran77 17 hours ago
Comment by dvt 18 hours ago
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.
Comment by lackoftactics 14 hours ago
Comment by tjwebbnorfolk 15 hours ago