What's new

The Coffee House

I'm Geogeek Happy! :biggrin-93:

I've been writing a script that matches an road segment ID to an address, based on the road segment's address range (if the address is 123 Main Street, then get the segment for 100 - 199 main Street and write the segment ID to the address point.) The problem I've been battling is how to filter the address points to just those matching the road name; there are about 390,000 addresses and 44,000 road segments. No matter how I try to code the filter I keep getting an error.

Yesterday afternoon I finally found a little piece of code (three lines) that sets up the filter. I cant just say x = y, but have to build a line of text referencing x and y individually. Everything went well (several times) with my test date (about 1,000 streets and 3,000 addresses). Today, I added code that will check for the required fields, and if they don't exist in the files, the fields are added. it went well with the test data, and now I'm running it against a copy of the production files. So far, so good.:boogie:

This is related to the next generation 9-1-1 (NextGen) stuff that is very rapidly coming to life, but has some other applications where we might need to associate an address point (a main door) with the section of road (like a section between two intersections).


How to cope with the variation in density?

Do the road sections have different lengths that correspond to the address density variation?
Yes, lengths and address ranges Differ for various reasons. I just split some segments due to changes in speed limits.
Why can't you just get everybody a Garmin?
Because I'm better.
 
I'm Geogeek Happy! :biggrin-93:

I've been writing a script that matches an road segment ID to an address, based on the road segment's address range (if the address is 123 Main Street, then get the segment for 100 - 199 main Street and write the segment ID to the address point.) The problem I've been battling is how to filter the address points to just those matching the road name; there are about 390,000 addresses and 44,000 road segments. No matter how I try to code the filter I keep getting an error.

Yesterday afternoon I finally found a little piece of code (three lines) that sets up the filter. I cant just say x = y, but have to build a line of text referencing x and y individually. Everything went well (several times) with my test date (about 1,000 streets and 3,000 addresses). Today, I added code that will check for the required fields, and if they don't exist in the files, the fields are added. it went well with the test data, and now I'm running it against a copy of the production files. So far, so good.:boogie:

This is related to the next generation 9-1-1 (NextGen) stuff that is very rapidly coming to life, but has some other applications where we might need to associate an address point (a main door) with the section of road (like a section between two intersections).


How to cope with the variation in density?

Do the road sections have different lengths that correspond to the address density variation?
Yes, lengths and address ranges Differ for various reasons. I just split some segments due to changes in speed limits.
Why can't you just get everybody a Garmin?
Because I'm better.
Gary doesn't know about that ... Mr. Garmin had that figured out years ago.
 
Nothing (Even phone mapping) knew our address until the Garmin in my truck now.
And on that note I bid you all a good night.

Sent from my SAMSUNG-SM-G890A using Tapatalk
 
259E6862-6659-4742-92DB-20F6A128BF72.webp

Gary made some orange sorbet today ... it is Delish.
 
Dave is parked at work waiting on a key holder. Need to see if the buffer mechanic showed up yesterday.

Sent from my SAMSUNG-SM-G890A using Tapatalk
 
Dave is parked at work waiting on a key holder. Need to see if the buffer mechanic showed up yesterday.

Sent from my SAMSUNG-SM-G890A using Tapatalk
You are the first one there - you should be a key holder.
 
We're leaving for work in a minute. It's going to be a long day, trying to get a lot done before we head out this weekend.
 
I'm only working one day next week, so today is feeling like a super-special Friday.

I made pizza dough last night, so we'll have some good eats for dinner tonight, and I think I'm going to throw together a big batch of egg nog to age for the holidays.

My mom has an ancient family recipe that she makes every year, and I've never had anything like it. I think it's because she uses egg whites instead of yolks...or maybe some sort of weird combination, I'm not sure as she won't divulge the recipe. She takes a hand mixer to it before serving, so you get a creamy/foamy layer with a boozy layer underneath.

I'm going to try Alton Brown's recipe this year to compare.
 
That egg nog sounds amazing! ! I love the stuff, but have to be careful since it has such a deadly calorie count. :lol:

My mom has the most amazing cheesecake recipe on the planet. Three types of cheese, takes two days to make, and is all kinds of thick but creamy cheese heaven.

Ah, holiday recipes! :586:

In other news, Happy Friday, hosers!
 
Happy Friday!!

That was exhausting. Shouldn't have gone for that second exclamation point.
 
Time to head up to floor #4 and it MLW is ready, home.
MLW's beef stew, tonight.
Beef stew sounds really good. Leftovers tonight. Mary Lou brought home a store roasted chicken and some store made mac & cheese ... we need to get to eat before it's too late.
The wife made beef stew yesterday and forgot to add the beef....I called it vegetable poo, she thought it was funny.
 
Happy Friday Hosers! (just one as I don't want to tucker myself out).

What's on the agenda this weekend folks?
 

Create an account or login to comment

You must be a member in order to leave a comment

Create account

Create an account on our community. It's easy!

Log in

Already have an account? Log in here.

Back
Top Bottom