dassouki

i think it is a + b >= 1/3 (a +b + c)

if a or b then a, b, c. How can I build an equation (with + and - ) around this

but thanks for the help. I really appreciate it :)

souski?

and can lead someone to thinking about the problem in a certain way

I think what you provided can be a comment

that bridge might have some pot holes in it and therefore will have a lower condition

Think of a 5 km road that has a bridge in the middle

but it could also differ in a group

Correct

here's an answer I got from IRC:

so the first 500 m were done in 2005, while another is done in 2014

well each road might be built in a different year

Thanks for your help so far. Initially, I was thinking of doing a python script that runs through the data and whenever and have a certain acceptable sigma value that it reaches

I just edited my question to reflect on your suggestions. feel free to delete your comments as I will delete mine as well

ok

A001_002 is the 50 meter road section that comes directly after A001_001

A001_001 is a 50 meter road section that has a condition rating of 3

No

sorry what I meant is that each record represents a 50 m section so over 50 m, the condition rating is 4

meters

the data is collected in 50 m bins

@robbieboy74 the data will be part of a larger heuristic model that's already built and functioning. We don't need data at the 50m level, we need it at between 200 and 500m. Otherwise, the model will be very long to optimize. also, condition ratings, let's say between 0 and 3 indicate Poor, whereas 'Fair' is between 3 and 5, etc.

@robbieboy74 there is no time factors, it's just sections of roads segmented over 50 m intervals. Clustering is probably a better term to what I'm trying to do. I'm not very familiar with the technical terms

@robbieboy74 the data is sequential

thanks so much for your help so far though

I might not be here, if I have any other questions I might email you or ask again here

now time to update the joins

jeez that was blazing fast

this way, I can do some unit tests on my calcs

yup figured that out!

awesome ! thanks

thanks

ok

here's what I did for the calcs pastie.org/private/gnme9pnm1q7hwsloglzsa

so when you say data tarnsfer between tables, you mean regular data join/

any other recommendations you'd recommend?

Awesome. Well this is very helpful!

is that ok?

awesome. One thing I find is that it takes 37 seconds for arcpy, to load itself, open the geodatabase and duplicate a featureclass

thank you so much for all yoru help so far .. just by doing the non join stuff in cursors shaved about 100 secodns off of a 400 second process

I figured out the update cursor. You're right it's much faster! thank for hte tip

Sounds good

I'll be back in a bit headed to a meeting. I 'm not suer what you mean by isolate

could very well be!

we have a software that takes in a shape file as input to do some linear programming and markov chains modelling. The input layer comes from the road data provider as a geodatabase. Another Event table comes in that indicates which roads will be worked on over the next few years. I combine the shape file with event table to create one shape file to be used in teh software

I really do appreciate this. Thank you very much

my email address by the way is my username here at the glorious gmail if yo uwant to share anythign that way

I'm reading the documentation on that right now. IT doesnt' seem very clear but I'm sure I'll get it eventually