• (disco) in reply to PleegWat
    PleegWat:
    WW1 peace treaty on

    That was 28 June 1919 and armistice was 11 November 1918. I've seen a lot of other days too. I guess some are the specific day the town was 'liberated' after WWII because I've seen several squares with some crazy date name that have some war time monument. The 14 July is also popular. As is De Gaulle. Bonus points for that one because you can have both a Rue Général De Gaulle and a Rue Président De Gaulle.

  • (disco) in reply to FrostCat
    FrostCat:
    all look like "Address Line 1" to me

    Our legacy address format, based on a very expensive commercial system we're trying to leave behind:

    private String buildingName;
private String unitNumber;
private String streetNumber;
private String streetName;
private StreetType streetType;
private String suburb;
private String city;
private State state;
private Country country;
private String postcode;

    Unit number and street number must be numeric so building name is abused heavily. Street type is from a list of enumerated values, as is state, country and postcode. State must be an Australian state. Different fields are sometimes used, sometimes not. The code to turn this structure into a nicely formatted address is... interesting.

  • (disco)

    No one mentioned the madness we have here sometimes - houses / buildings without a street number. They are referred to only as "b.b." (short for "no number").

    Have fun finding those in a street. With whatever and a half at least you have a number to look around, the non-numbered one could be anywhere.

  • (disco) in reply to another_sam

    Are the numeric fields at least 'required non-zero'?

  • (disco) in reply to gleemonk
    gleemonk:
    Yeah, it's a shame. They just switched from "Rue de l'Égalité" to "Rue de Lyon" or somesuch. I was hoping to see "-10 Rue de l'Égalité" and was mightily disappointed.

    Here in the US, usually just switches from north to south or east to west, or vice-versa. In Lincoln, NE moving south, you have 103 N 40th St, 101 N 40th St, 101 S 40th St, and 103 S 40th St.

    First Street is the dividing line on the west; after you get west of that, the numbered streets count up again, so you have 101 NW 40th St, 101 SW 40th St, 101 N 40th St, and 101 S 40th St. Even the locals were confused.

    And then there's South Street...addresses are plain South Street east of First street (i.e., 814 South St) but then there's addresses like 1532 W South St.

    All roads end somewhere.

  • (disco) in reply to CoyneTheDup
    CoyneTheDup:
    All roads end somewhere.

    Rome?

  • (disco) in reply to Zemm
    Zemm:
    gleemonk:
    They just switched from "Rue de l'Égalité" to "Rue de Lyon" or somesuch

    Are these your examples or do they use "rural numbering" in Paris?

    These are my examples. In Paris the scheme would not work for obvious reasons. Though I'm still trying to get my brain decide whether the numbering I saw was in meters or in decameters.

    Zemm:
    PWolff:
    Not even palindromized the street name?

    Around here many roads are simply the two endpoints. Like "Southport-Nerang Rd" is the main road between Southport and Nerang. That would be interesting to swap the names around and have a second numbering system!

    So the numbering follows the direction of the road? "1 Southport-Nerang Rd" would be at Southport? How extraordinarily convenient! (Not to say boring :smiley: )

  • (disco) in reply to ScholRLEA
    ScholRLEA:
    CoyneTheDup:
    All roads end somewhere.

    Rome?

    :smile: Some of them end in Rome, yes. Rome, Maryland. (Warning: conspiracy theories.)

  • (disco) in reply to another_sam

    That seems wildly overengineered. So it breaks, say, "23 17th Court" into three components? Does it handle "17353 NW 19th St"?

    Building name, I assume, is like how, say, a tower downtown might be "The Willis Tower" or an apartment might be "The Ravenholme"?

  • (disco) in reply to CoyneTheDup
    CoyneTheDup:
    All roads end somewhere.

    https://en.wikipedia.org/wiki/Interstate_495_(Capital_Beltway)

    :weary:

  • (disco) in reply to boomzilla

    No True ScotsmanRoad™, obviously.

  • (disco) in reply to CoyneTheDup
    CoyneTheDup:
    First Street is the dividing line on the west; after you get west of that, the numbered streets count up again, so you have 101 NW 40th St, 101 SW 40th St, 101 N 40th St, and 101 S 40th St. Even the locals were confused.

    I spent a few months in the Phoenix area doing an internship while I was in university. Phoenix is more-or-less east-west symmetrical around Central Ave. East of Central Ave., north-south streets are named 1st St., 2nd St., 3rd St., etc. West of Central, they're named 1st Ave., 2nd Ave., 3rd Ave., etc. If you get the address wrong and go to 50th St. instead of 50th Ave., you're about 10 miles from where you wanted to be. (Then there are Places, Courts, etc., that are sometimes fit in between the main Streets and Avenues; IIRC, they also have a pattern that differs east and west of Central, but looking at a map, I can't find enough examples to work out the pattern.)

    At least you'll learn your American Presidents if you live there. East-west streets are named for Presidents, starting with Washington in the center, and proceeding in roughly chronological order, alternating (but not consistently) north and south of Washington: Adams north, Jefferson south, Madison south, Monroe north, (skipping Adams again), Jackson south, Van Buren north, etc. up to Roosevelt; they haven't renamed existing streets after more recent presidents.

  • (disco) in reply to FrostCat
    FrostCat:
    That seems wildly overengineered.

    Quite.

    FrostCat:
    Does it handle "17353 NW 19th St"?

    I think this would require abusing the building name field with "17353 NW". It's nowhere near a common address format here. Oh, did I mention we store international addresses because we have international investors? And that we can't store their state/province/prefecture? Good times. We also have no South Sudan because it's far too new and we still have Czechoslovakia.

    FrostCat:
    Building name, I assume, is like how, say, a tower downtown might be "The Willis Tower" or an apartment might be "The Ravenholme"?

    Yes, or "23B" because street number can't have non-numerics so it goes in the building name field.

    Good job discourse, you fucked this one up pretty good.

  • (disco) in reply to PWolff
    PWolff:
    Are the numeric fields at least 'required non-zero'?

    No way! This database doesn't even have many primary keys. Data integrity is completely unknown. It's glorious!

  • (disco) in reply to another_sam
    another_sam:
    Data integrity is completely unknown.

    It's just a matter of ensuring that the data's incentives are aligned with those of the stakeholders.

  • (disco) in reply to another_sam
    another_sam:
    I think this would require abusing the building name field with "17353 NW".

    Awesome. And wrong, as I bet you already knew. The street name is "NW 19th".

    another_sam:
    It's nowhere near a common address format here.

    It's pretty common--well, ok, it's probably not terribly uncommon--in big cities here. South Florida, at least, seems like a 60-or-however-many-mile grid of cities that all grew into each other. Using anything but numbered streets would probably be horrible.

  • (disco) in reply to FrostCat
    FrostCat:
    Awesome. And wrong, as I bet you already knew. The street name is "NW 19th".

    Ah, I did not know that, but I didn't spend all that long trying to decode it either. In that case, the street number can be "17353" and the street name can be "NW 19th" until somebody else thinks it's wrong and "fixes" it.

Leave a comment on “The Graduate”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article