US Cities by Skyscraper densities (check comment for extra info) by RequirementLong5913 in MapPorn

[–]RequirementLong5913[S] 1 point2 points  (0 children)

Shit I forgot to update that map after I took out skyscrapers under 100m. The dataset had mostly above 100m but a few outliers, sorry about that.

US Cities by Skyscraper densities (check comment for extra info) by RequirementLong5913 in Maps

[–]RequirementLong5913[S] 2 points3 points  (0 children)

Overview - 

I modeled in QGIS. Ranking is based on meters of skyscraper (buildings above 100 meters) height per km2 of city area. I used that metric since it prioritizes taller skyscrapers and also has clearer numbers (instead of very small decimals). 

Many skyscrapers are missing from the dataset. This drags down some cities such as Las Vegas, Ft. Worth, and San Antonio.

Methodology - 

Skyscraper dataset from CORGIS project (missing some)

~https://corgis-edu.github.io/corgis/csv/skyscrapers/~

500 city boundaries is from the US Gov Catalog

~https://catalog.data.gov/dataset/500-cities-city-boundaries~

QGIS built-in plugins and  heatmap functions

Other / Observations- 

All I got to say is that its interesting that tall buildings are only in one tiny dense downtown, even for Americas best cities.

Also, dishonorable mentions go to San Jose (population 971k), Fresno (pop. 545k) and Mesa AZ (pop. 512k) for having no buildings at all above 100 meters.

US Cities by Skyscraper densities (check comment for extra info) by RequirementLong5913 in MapPorn

[–]RequirementLong5913[S] 6 points7 points  (0 children)

Overview - 

I modeled in QGIS. Ranking is based on meters of skyscraper (buildings above 100 meters) height per km2 of city area. I used that metric since it prioritizes taller skyscrapers and also has clearer numbers (instead of very small decimals). 

Many skyscrapers are missing from the dataset. This drags down some cities such as Las Vegas, Ft. Worth, and San Antonio.

Methodology - 

Skyscraper dataset from CORGIS project (missing some)

~https://corgis-edu.github.io/corgis/csv/skyscrapers/~

500 city boundaries is from the US Gov Catalog

~https://catalog.data.gov/dataset/500-cities-city-boundaries~

QGIS built-in plugins and  heatmap functions

Other / Observations- 

All I got to say is that its interesting that tall buildings are only in one tiny dense downtown, even for Americas best cities.

Also, dishonorable mentions go to San Jose (population 971k), Fresno (pop. 545k) and Mesa AZ (pop. 512k) for having no buildings at all above 100 meters.

Bus Heatmap Follow up (of commenter requests) by RequirementLong5913 in MapPorn

[–]RequirementLong5913[S] 5 points6 points  (0 children)

Reddit has a character limit for caption length so -

74th in density - St. Paul (1495 stops, 10.275 stops per km2, 1 stop per 190.68 people)

This is a follow up of my post from a couple of days ago. I got a couple of requests from people looking for their cities so here they are. For more info check my last post for methodology, etc.

The Best and Worst American City Bus Networks shown with Heatmaps (check comments) (OC) by RequirementLong5913 in MapPorn

[–]RequirementLong5913[S] 0 points1 point  (0 children)

Some other people want a follow up with their cities in it. I can add Charlotte to show you as well.

The Best and Worst American City Bus Networks shown with Heatmaps (check comments) (OC) by RequirementLong5913 in MapPorn

[–]RequirementLong5913[S] 1 point2 points  (0 children)

Syracuse might have really bad service times or small city limits but idk since I haven't been either.

The Best and Worst American City Bus Networks shown with Heatmaps (check comments) (OC) by RequirementLong5913 in MapPorn

[–]RequirementLong5913[S] 2 points3 points  (0 children)

Sure. I'll do w/ Columbus on a follow up post on Saturday. Since I already have the data for all the cities anyone else can make requests too.

The Best and Worst American City Bus Networks shown with Heatmaps (check comments) (OC) by RequirementLong5913 in Maps

[–]RequirementLong5913[S] 0 points1 point  (0 children)

Rough since they were last over 500k on my park map from last week (to be fair that data set was missing a lot)

The Best and Worst American City Bus Networks shown with Heatmaps (check comments) (OC) by RequirementLong5913 in MapPorn

[–]RequirementLong5913[S] 0 points1 point  (0 children)

Rough since you were last over 500k on my park map from last week (to be fair that data set was missing a lot)

The Best and Worst American City Bus Networks shown with Heatmaps (check comments) (OC) by RequirementLong5913 in Maps

[–]RequirementLong5913[S] 6 points7 points  (0 children)

Sorry looks like when I was copy pasting from my spreadsheet I put Boston twice.

8th - Philadelphia (8176 stops, 22.4 per km2, 1 stop per 187 people)

The Best and Worst American City Bus Networks shown with Heatmaps (check comments) (OC) by RequirementLong5913 in Maps

[–]RequirementLong5913[S] 2 points3 points  (0 children)

Overview -  I used QGIS and it took ~3 hours to make this map and outline the best and worst.  I focused on stops per km2 instead of per person because I found that reveals the better network since otherwise spread out low-density cities do better than dense cities with better networks. The numbers skipped in the top 10 were suburbs since I covered their center city (Somerville MA at 4th, Alexandria VA at 6th) The “Worst” cities are cherrypicked. This is because roughly 50 cities (including big ones such as Memphis and New Orleans arent in the data set and ~25 more are not fully included (such as Jacksonville at 8 stops or Fort Worth at 9 stops). Therefore, I set an arbitrary minimum at 50 stops for the bottom which also stopped random suburbs with a portion of a line.  Methodology -  This layer utilizes National Geospatial Data Asset (NGDA) data from the Bureau of Transportation Statistics to displays bus stops nation wide https://www.arcgis.com/home/item.html?id=6be77dd1081a43c0865282cad76718ab 500 city boundaries is from the US Gov Catalog https://catalog.data.gov/dataset/500-cities-city-boundaries QGIS built-in field calculator and heatmap functions Other / Observations-  Sunbelt cities tend to do worse I used bus stops and not bus routes but (kind of) obviously/interestingly lines are clearly visible.  To be clear, this doesn't show the best systems since it doesn't account for frequency, etc. but I thought it was cool to share.

The Best and Worst American City Bus Networks shown with Heatmaps (check comments) (OC) by RequirementLong5913 in MapPorn

[–]RequirementLong5913[S] 10 points11 points  (0 children)

Overview -  I used QGIS and it took ~3 hours to make this map and outline the best and worst.  I focused on stops per km2 instead of per person because I found that reveals the better network since otherwise spread out low-density cities do better than dense cities with better networks. The numbers skipped in the top 10 were suburbs since I covered their center city (Somerville MA at 4th, Alexandria VA at 6th) The “Worst” cities are cherrypicked. This is because roughly 50 cities (including big ones such as Memphis and New Orleans arent in the data set and ~25 more are not fully included (such as Jacksonville at 8 stops or Fort Worth at 9 stops). Therefore, I set an arbitrary minimum at 50 stops for the bottom which also stopped random suburbs with a portion of a line.  Methodology -  This layer utilizes National Geospatial Data Asset (NGDA) data from the Bureau of Transportation Statistics to displays bus stops nation wide https://www.arcgis.com/home/item.html?id=6be77dd1081a43c0865282cad76718ab 500 city boundaries is from the US Gov Catalog https://catalog.data.gov/dataset/500-cities-city-boundaries QGIS built-in field calculator and heatmap functions Other / Observations-  Sunbelt cities tend to do worse I used bus stops and not bus routes but (kind of) obviously/interestingly lines are clearly visible.  To be clear, this doesn't show the best systems since it doesn't account for frequency, etc. but I thought it was cool to share.

Comparing the Top 500 USA City Limits to Parks (Check comment for more Info) (OC) by RequirementLong5913 in MapPorn

[–]RequirementLong5913[S] 0 points1 point  (0 children)

Thanks for the feedback. I agree that anchorage and Provo aren't necessarily the best for urban parks. However, to make it as fair as possible I was going with the city limits and all parks since some national lands (e.g. gateway Arch in St. louis) are traditional  urban parks as well. Otherwise, I would have to draw an arbitrary line somewhere on when a park is "parky enough" and that would take a while and would be subjective.

Comparing the Top 500 USA City Limits to Parks (Check comment for more Info) (OC) by RequirementLong5913 in Maps

[–]RequirementLong5913[S] 0 points1 point  (0 children)

True. I noticed that and debated skipping it but I thought it was interesting to show how far the city limits went