HomeDiagramsDatabaseMapsForum About
     

Go Back   SkyscraperPage Forum > Diagrams & Database > Diagrams


Reply

 
Thread Tools Display Modes
     
     
  #1  
Old Posted Dec 2, 2023, 8:41 PM
cabasse's Avatar
cabasse cabasse is offline
Registered User
 
Join Date: Jun 2002
Location: atalanta
Posts: 4,163
Database enhancement suggestion

wasn't sure where this would be appropriate to bring up, but figured this was the best forum.

it would be really freaking nifty if an additional key/parameter could be added to the diagrams database for neighborhood/district/borough. would be super cool to be able to easily pull up all buildings in brooklyn, or buckhead, or houston's medical center, etc etc.

just a thought. i'd be willing to volunteer to help modify the database/php if resources are an issue, since dylan and the staff are probably already busy dealing with forum database issues.

__________________
Reply With Quote
     
     
  #2  
Old Posted Dec 3, 2023, 8:17 AM
Anders Franzén's Avatar
Anders Franzén Anders Franzén is offline
Registered User
 
Join Date: Aug 2009
Location: Swedish East Coast
Posts: 2,553
I believe there was a mention about something similar to this idea some years ago.

As far as I know, nothing have happened since then, unfortunately.
Reply With Quote
     
     
  #3  
Old Posted Dec 4, 2023, 12:15 AM
La_Parca's Avatar
La_Parca La_Parca is offline
Registered User
 
Join Date: Oct 2013
Location: Buenos Aires - Argentina
Posts: 314
I proposed something like this but with states, the biggest countries have states divisions, like Argentina,Usa,Brazil, i wanted it for all countries, but they said that implementing that would take a lot of space in the servers or something like that
Reply With Quote
     
     
  #4  
Old Posted Dec 4, 2023, 8:34 PM
Quilmeño89's Avatar
Quilmeño89 Quilmeño89 is offline
Illustrator
 
Join Date: Dec 2012
Location: Quilmes
Posts: 846
I looked for a way to do this in Argentina: I put the name of the neighborhood after the street address (for the moment, only in Buenos Aires and Vicente López). In this way, when you type the name of the neighborhood in the Diagram Search Form (in the building name box), all the buildings in that neighborhood appear. The only problem may arise if there is a building that bears the name of a different neighborhood to which it belongs, or of a street that coincides with a neighborhood.
Reply With Quote
     
     
  #5  
Old Posted Dec 6, 2023, 9:27 PM
Artemco's Avatar
Artemco Artemco is offline
Ukrainian moderator
 
Join Date: Apr 2005
Posts: 4,590
Quote:
Originally Posted by La_Parca View Post
I proposed something like this but with states, the biggest countries have states divisions, like Argentina,Usa,Brazil, i wanted it for all countries, but they said that implementing that would take a lot of space in the servers or something like that
in past time there was already divisions of almost all countries, but Dylan have turned them off, he said because of high loading of database. So don't dream about neighborhoods.
Emporis had urban districts, boroughs, neighborhoods, complexes and what? it crushed completely
Reply With Quote
     
     
  #6  
Old Posted Dec 21, 2023, 10:56 PM
Dylan Leblanc's Avatar
Dylan Leblanc Dylan Leblanc is offline
Website Manager
 
Join Date: Dec 1999
Posts: 9,318
The way to do this would be to use the existing latitude, longitude location for a building. If we had the boundary for a neighbourhood or borough, then there's a calculation that can be done to find all building that are within that boundary. The website isn't able to accommodate this kind of search though, and getting the proper boundaries would take a lot of work to. I'm not keen on adding an extra data field for this either, as that could create a form of duplicate data and not an ideal way to implement a solution.

For now the suggestion that Quilmeño89 has, editors putting the neighbourhood name into the address field, is the best thing to do. Then a neighbourhood/borough can be searched on using the Building Name field of the diagrams search form (along with the City field).
Reply With Quote
     
     
  #7  
Old Posted Dec 29, 2023, 8:31 AM
plinko's Avatar
plinko plinko is offline
them bones
 
Join Date: Jul 2001
Location: Santa Barbara adjacent
Posts: 7,388
I've wondered about this possibility as well, but I am also wondering if there is a way to search by architect? I know we don't have them all in the database, but it would be amazing to be able to do so.
__________________
Even if you are 1 in a million, there are still 8,000 people just like you...
Reply With Quote
     
     
End
 
 
Reply

Go Back   SkyscraperPage Forum > Diagrams & Database > Diagrams
Forum Jump


Thread Tools
Display Modes

Forum Jump


All times are GMT. The time now is 10:57 AM.

     
SkyscraperPage.com - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.