Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [address]

For questions about identifying and labelling locations with postal addresses or similar encoding schemes. Both published standard schemes and novel schemes are included.

Often an application will need to identify locations by the mailing address. Many different schemes for addresses exist globally. How these schemes are held and processed in a database adds a further layer of design decision, with benefits and costs to consider.

13 questions
25
votes
7 answers

What problems are solved by splitting street addresses into individual columns?

We have a team who designs the tables and relations for software developers. In our organization, they are pretty strict about enforcing 3NF normalization - which to be honest, I agree with given the size of our organization and how the needs or our…
Greg Burghardt
  • 353
  • 3
  • 10
10
votes
2 answers

PostgreSQL, what is the hostname address of my default database?

I just created a PostgreSQL database on my laptop (following these instructions), which is running Linux CentOS 7. Now I would like to understand what is the hostname address of my default database. I thought it was localhost but it's not. I want to…
DavideChicco.it
  • 327
  • 2
  • 5
  • 13
7
votes
1 answer

How do I parse addresses in PostgreSQL?

Let's say for instance that I want to parse these addresses for the Chicken Ranch Chicken Ranch 10511 Homestead Rd Pahrump, NV 89061 Chicken Ranch 1600 Pennsylvania Avenue NW Washington, D.C. 20500 In both of these cases, I'd like to get rid of Rd…
Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
5
votes
2 answers

Postgres inet array contains a single ip

Requirement: user can add single ips or ip address ranges to a database table(for example permissions table having ipAddresses of inet[] type). I need to query that a single ip is contained in the array of ipAddresses field which can be array of ip…
Radio Active
  • 177
  • 1
  • 7
5
votes
2 answers

Separate Address Table, Latitude, Longitude

We are designing a DB for a limited functionality social networking application. Users (Registered Users), Retail Outlets, etc are several entities we need to store. We need to store Address of each of these entities. Also we need to store latitude…
Rakesh B
  • 51
  • 3
4
votes
5 answers

How do others know what is delivery address and invoice address if they are in the same table?

When I searched around, the recommended way is to use the invoice address and delivery address in the same table and use a field "type" to show what it is. For example Addresses(Company, address, city, type) Type = 1: The address is a delivery…
Xtreme
  • 141
  • 1
  • 4
3
votes
2 answers

Relational database for address model

I want to design an "Address" model for all types of entities like users, businesses, etc. I have two types of main models: one is User and the other is Business. Each one has different address types like below. User 1.Contact Address 2.Billing…
Gowri
  • 209
  • 1
  • 3
  • 11
2
votes
1 answer

Field/datatype for searchable address components?

I'm using Django with Postgres, and I'm looking for a field/datatype to store address components that come from Google Places API in this format: "address_components": [ {"long_name": "27", "short_name": "27", "types": ["street_number"]}, …
davidtgq
  • 759
  • 1
  • 8
  • 23
1
vote
1 answer

Should I assimilate all address lines to a single line?

I'm new here, so I'll keep my question straight and short. I am building a webapp that lets users select some product, submit their details and place an order. Currently, my ORDER table contains only one field for the address. I was planning to…
user21904
  • 113
  • 4
1
vote
0 answers

How do I parse Address into Street Number, Street Name, Type, Unit Number?

How do I parse Address into Street Number, Name, Type, Unit Number? Is there a function which will conduct this? 2280 MEYERS AVE ALDERGROVE AVE & S VINEWOOD ST SIMPSON WAY & N…
user173948
0
votes
1 answer

Can a foreign key be used for two primary keys?

I'm still a beginner in sql and I have to transform this relation between clients and addresses and vendors and adresses. This uses 2 primary keys(1 for the vendors and 1 for the clients). My question is, is it better practice to use two foreign…
Nightstar479
  • 1
0
votes
1 answer

Combine addresses missing Unit/Suite #

I have a list of addresses which need to be updated in SQL Server. How can I go about adding the Suite # to the addresses which are missing it? Address 1 Burton Hills Blvd, Suite 250 1 Burton Hills Blvd 1 Burton Hills Blvd 1 Burton Hills Blvd 1…
Geoff Dawdy
  • 1,143
  • 7
  • 23
  • 53
0
votes
1 answer

Struggling to design addresses table for fast querying

I have two tables: addresses and locations. Locations zipcode city county state Addresses line1 line2 city county state zipcode Posts Id Address_id Body All my users are required to provide at least a personal address and some need to provide…
Cristian
  • 203
  • 1
  • 3
  • 11